Example #1
0
while ($row3 = mysql_fetch_array($result3)) {
    $event_fav = $row3['COUNT'];
}
while ($row4 = mysql_fetch_array($result4)) {
    $event_user_id[] = $row4['USER_ID'];
    $user_last_name[] = $row4['USER_LAST_NAME'];
    $user_first_name[] = $row4['USER_FIRST_NAME'];
}
while ($row5 = mysql_fetch_array($result5)) {
    $organizer_user_id = $row5['USER_ID'];
    $organizer_last_name = $row5['USER_LAST_NAME'];
    $organizer_first_name = $row5['USER_FIRST_NAME'];
}
//イベント詳細情報を文字ごとに改行
$host_comment = mb_wordwrap($host_comment, 25, "<br>\n", true);
$event_detail = mb_wordwrap($event_detail, 25, "<br>\n", true);
//$event_detail = nl2br($event_detail);
//データベース切断
mysql_close($link);
?>

<!-- マルチバイト対応のwordwrap -->
<?php 
function mb_wordwrap($string, $width = 75, $break = "\n", $cut = false)
{
    if (!$cut) {
        $regexp = '#^(?:[\\x00-\\x7F]|[\\xC0-\\xFF][\\x80-\\xBF]+){' . $width . ',}\\b#U';
    } else {
        $regexp = '#^(?:[\\x00-\\x7F]|[\\xC0-\\xFF][\\x80-\\xBF]+){' . $width . '}#';
    }
    $string_length = mb_strlen($string, 'UTF-8');
Example #2
0
 if ($thistorrent['is_private']) {
     $statusflags .= "&middot; Private ";
 }
 if ($thistorrent['complete'] == 1) {
     $statusstyle = "complete";
 } else {
     $statusstyle = "incomplete";
 }
 if ($thistorrent['is_active'] == 1) {
     $statusstyle .= "active";
 } else {
     $statusstyle .= "inactive";
 }
 echo "<div class='container' style='width:550px'>\n";
 echo "<table border=0 cellspacing=0 cellpadding=5 class='maintable' width='100%'>\n";
 echo "<tr class='row2'><td class='datacol' align=right><b>Name</b></td><td><span class='torrenttitle {$statusstyle}'>" . mb_wordwrap($thistorrent['name'], 60, "<br/>\n", TRUE) . "</span></td></tr>\n";
 echo "<tr class='row1'><td class='datacol' align=right><b>Status</b></td><td><img src='images/" . $statusstyle . ".gif' width=10 height=9 alt='Status' /> " . $thistorrent['status_string'] . "</td></tr>\n";
 echo "<tr class='row2'><td class='datacol' align=right><b>Priority</b></td><td>";
 echo "<form action='control.php' method='post'>";
 echo "<input type='hidden' name='hash' value='" . $thistorrent['hash'] . "' />";
 echo "<select name='set_tpriority'>\n";
 echo "<option value='0' " . ($thistorrent['priority'] == 0 ? "selected" : "") . ">Off </option>\n";
 echo "<option value='1' " . ($thistorrent['priority'] == 1 ? "selected" : "") . ">Low </option>\n";
 echo "<option value='2' " . ($thistorrent['priority'] == 2 ? "selected" : "") . ">Normal </option>\n";
 echo "<option value='3' " . ($thistorrent['priority'] == 3 ? "selected" : "") . ">High </option>\n";
 echo "</select>\n";
 echo "<input type='submit' value='Set' />\n";
 echo "</form>\n";
 echo "<tr class='row1'><td class='datacol' align=right><b>Status Flags</b></td><td>" . $statusflags . "</td></tr>\n";
 echo "<tr class='row2'><td class='datacol' align=right><b>Message</b></td><td>" . $thistorrent['message'] . "</td>";
 echo "<tr class='row1'><td class='datacol' align=right><b>Completed Bytes</b></td><td>" . format_bytes($thistorrent['completed_bytes']) . "</td></tr>\n";
Example #3
0
        if (substr($date, 5, 1) == 0) {
            $date_month = substr($date, 6, 1);
        } else {
            $date_month = substr($date, 5, 2);
        }
        //イベント開始日の表示(先頭の0は表示されない)
        if (substr($date, 8, 1) == 0) {
            $date_day = substr($date, 9, 1);
        } else {
            $date_day = substr($date, 8, 2);
        }
        $temp = $temp . "<tr>";
        $temp = $temp . "<td class=e_num_main>" . $display_num++ . "</td>";
        $temp = $temp . "<td class=e_title_main><a href=../event/event_detail.php?event_id={$send}>" . $row['EVENT_TITLE'] . "</a></td>";
        $temp = $temp . "<td class=e_date_main>" . substr($date, 0, 4) . "年" . $date_month . "月" . $date_day . "日" . "</td>";
        $temp = $temp . "<td class=e_detail_main>" . mb_wordwrap($row['EVENT_DETAIL'], 30, "<br>\n", true) . "</td>";
        $temp = $temp . "</tr>";
    }
    $msg = "<p><h3>検索結果: 該当するイベントが" . $rows . "件表示されました。</h3></p><br>";
} else {
    $msg = "<p><h3>検索結果: 該当するイベントは存在しません。</h3></p>";
}
//mysql_close() - MySQLサーバへの接続をクローズにする
$close_flag = mysql_close($link);
if (!$close_flag) {
    die('切断に失敗しました。' . mysql_error());
}
//print('<p>切断に成功しました。</p>');
?>

Example #4
0
        }
        echo '<div id="messages">';
        gb_showpages($_GET['page']);
        // положение первой записи страницы
        $begin = ($_GET['page'] - 1) * RECSPERPAGE;
        $result = mysql_query('SELECT * FROM mandarinko_poll_comments WHERE `moder` = 1 and `hc_id` = ' . $_GET['poll'] . ' ORDER BY time DESC LIMIT ' . $begin . ', ' . RECSPERPAGE);
        // цикл по всем выбранным записям
        while ($row = mysql_fetch_array($result)) {
            $out = '<div class=element><div class=title><b>' . stripslashes($row['nick']) . '</b> ';
            if ($row['email']) {
                $out .= '( ';
                $out .= ' <a href=mailto:' . stripslashes($row['email']) . '>email</a>';
                $out .= ' )';
            }
            $row['time'] = date('d.m.Y H:i', $row['time']);
            $out .= ' пишет ' . $row['time'] . ':</div><div class=msg>' . htmlspecialchars(mb_wordwrap(html_entity_decode(stripslashes($row['msg']), ENT_QUOTES), 120, "\n")) . '</div></div>';
            echo $out;
        }
        // уничтожаем результат
        mysql_free_result($result);
        gb_showpages($_GET['page']);
        echo '</div>';
        //форма добавления сообщения
        ?>
		<div id="add_msg">
			<h2>Добавить новое сообщение</h2>
			<table cellspacing="2" cellpadding="2" border="0">
				<form action="?poll=<?php 
        echo $_GET['poll'];
        ?>
&result=1&add=1" method=post>
Example #5
0
/**
 * wrapper for mail()
 *
 * @param string  $to
 * @param string  $subject
 * @param string  $body
 * @param array   $headers     (optional)
 * @param string  $fingerprint (optional) encrypt mail with the public key with this fingerprint
 * @return bool
 */
function send_mail($to, $subject, $body, array $headers=array(), $fingerprint="") {

	$subject = mb_encode_mimeheader( limitstr(MAIL_SUBJECT_PREFIX.$subject, 125) );

	$headers[] = "Content-Type: text/plain; charset=UTF-8";
	$headers[] = "Content-Transfer-Encoding: 8bit";
	if (MAIL_FROM) $headers[] = "From: ".MAIL_FROM;

	$body = mb_wordwrap($body);

	if (GNUPG_SIGN_KEY) {
		$gnupg = new_gnupg();
		if ( $gnupg->addsignkey(GNUPG_SIGN_KEY) ) {
			if ($fingerprint) {
				if ( gnupg_keyinfo_matches_email($gnupg->keyinfo($fingerprint), $to) and $gnupg->addencryptkey($fingerprint) ) {
					$body = $gnupg->encryptsign($body);
				} else {
					$body .= "\n\n".mb_wordwrap(_("This email should be encrypted, but no available key matching your fingerprint and email address was found! Please check your settings:")." ".BASE_URL."settings_encryption.php");
					$body = $gnupg->sign($body);
				}
			} else {
				$body = $gnupg->sign($body);
			}
		} else {
			trigger_error("Gnupg sign key cound not be added", E_USER_WARNING);
		}
	}

	return mail($to, $subject, $body, join("\r\n", $headers));
}
Example #6
0
                                                    }
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
//自己紹介文を文字ごとに改行
$profile = mb_wordwrap($profile, 26, "<br>\n", true);
mysql_close($link);
?>

<!-- このページの利用者が立ち上げているイベント情報の取得 -->
<?php 
$event_title = array();
$event_start = array();
$event_id = array();
$link = mysql_connect('localhost', 'root', 'root');
if (!$link) {
    die('接続失敗です。' . mysql_error());
}
$db_selected = mysql_select_db('greenbakari', $link);
if (!$db_selected) {
    die('データベース選択失敗です。' . mysql_error());
Example #7
0
 function render($width, $options)
 {
     // Allow room for the border.
     // TODO: Consider left-right padding and margin
     $bw = $this->getStyle('border-width', 0);
     if ($bw) {
         $width -= 4;
     }
     $output = parent::render($width, $options);
     if ($output instanceof PreFormattedText) {
         // TODO: Consider CSS rules
         return new PreFormattedText("\n" . $output);
     }
     $output = trim($output);
     if (!strlen($output)) {
         return "";
     }
     // Wordwrap the content to the width
     switch ($this->ws) {
         case 'nowrap':
         case 'pre':
             break;
         case 'pre-line':
         case 'pre-wrap':
         case 'normal':
         default:
             $output = mb_wordwrap($output, $width, "\n", true);
     }
     // Apply stylesheet styles
     // TODO: Padding
     // TODO: Justification
     // Border
     if ($bw) {
         $output = self::borderize($output, $width);
     }
     // Margin
     $mb = $this->getStyle('margin-bottom', 0);
     $output .= str_repeat("\n", (int) $mb);
     return "\n" . $output;
 }
Example #8
0
File: view.php Project: nylen/rtgui
         $status_flags .= '&middot; Hash Checked ';
     }
     if ($this_torrent['is_hash_checking']) {
         $status_flags .= '&middot; Hash Checking ';
     }
     if ($this_torrent['is_multi_file']) {
         $status_flags .= '&middot; Multi-file ';
     }
     if ($this_torrent['is_open']) {
         $status_flags .= '&middot; Open ';
     }
     if ($this_torrent['is_private']) {
         $status_flags .= '&middot; Private ';
     }
     $status_style = ($this_torrent['complete'] ? 'complete' : 'incomplete') . ($this_torrent['is_active'] ? 'active' : 'inactive');
     $name = mb_wordwrap($this_torrent['name'], 60, "<br />\n", true);
     $selected = array();
     foreach (range(0, 3) as $i) {
         $selected[$i] = $this_torrent['priority'] == $i ? ' selected="selected"' : '';
     }
     $formatted = array();
     foreach (array('completed_bytes', 'size_bytes', 'down_rate', 'down_total', 'up_rate', 'up_total') as $i) {
         $formatted[$i] = format_bytes($this_torrent[$i]);
     }
     $percent_bar = percentbar($this_torrent['percent_complete']);
     $ratio = number_format($this_torrent['ratio'] / 1000, 2);
     echo <<<HTML
 <div class="container">
   <table border=0 cellspacing=0 cellpadding=5 class="maintable" width="100%">
     <tr class="row">
       <td class="datacol" align=right><b>Name</b></td>
Example #9
0
//mysql_num_rows() - クエリの実行結果から行の数を取得する
$rows = mysql_num_rows($result);
if ($rows) {
    //mysql_fetch_array() - クエリの実行結果を連想配列として取得する
    while ($row = mysql_fetch_array($result)) {
        $send = $row['USER_ID'];
        $name = $row['USER_LAST_NAME'] . $row['USER_FIRST_NAME'];
        $temp = $temp . "<tr>";
        $temp = $temp . "<td class=u_num_main>" . $display_num++ . "</td>";
        //ログイン中のユーザが表示される場合はmypage.phpへのリンクを生成
        if ($send == $user_id) {
            $temp = $temp . "<td class=u_name_main><a href=../mypage/mypage.php>" . $name . "</a></td>";
        } else {
            $temp = $temp . "<td class=u_name_main><a href=../mypage/personalpage.php?user_id={$send}>" . $name . "</a></td>";
        }
        $temp = $temp . "<td class=u_prof_main>" . mb_wordwrap($row['PROFILE'], 45, "<br>\n", true) . "</td>";
        $temp = $temp . "</tr>";
    }
    $msg = "<p><h3>検索結果: 該当する利用者が" . $rows . "名表示されました。</h3></p><br>";
} else {
    $msg = "<p><h3>検索結果: 該当する利用者は存在しません。</h3></p>";
}
//mysql_close() - MySQLサーバへの接続をクローズにする
$close_flag = mysql_close($link);
if (!$close_flag) {
    die('切断に失敗しました。' . mysql_error());
}
//print('<p>切断に成功しました。</p>');
?>

<!-- マルチバイト対応のwordwrap -->
Example #10
0
$result = mysql_query('SELECT * FROM mandarinko_gbook WHERE `moder` = 1 ORDER BY time DESC LIMIT ' . $begin . ', ' . RECSPERPAGE);
// цикл по всем выбранным записям
while ($row = mysql_fetch_array($result)) {
    if ($row['id'] == 1) {
        $out = '<div class=element><div class=msg><b>' . htmlspecialchars(mb_wordwrap(html_entity_decode(stripslashes($row['msg']), ENT_QUOTES), 120, "\n")) . '</b></div></div>';
    } else {
        $out = '<div class=element><div class=title><b>' . stripslashes($row['nick']) . '</b> ';
        if ($row['email']) {
            $out .= '( ';
            $out .= ' <a href=mailto:' . stripslashes($row['email']) . '>email</a>';
            $out .= ' )';
        }
        $row['time'] = date('d.m.Y H:i', $row['time']);
        $out .= ' пишет ' . $row['time'] . ':</div><div class=msg>' . htmlspecialchars(mb_wordwrap(html_entity_decode(stripslashes($row['msg']), ENT_QUOTES), 120, "\n")) . '</div>';
        if ($row['answer']) {
            $out .= '<div class=answer>Ответ: ' . htmlspecialchars(mb_wordwrap(html_entity_decode(stripslashes($row['answer']), ENT_QUOTES), 200, "\n")) . '</div></div>';
        }
    }
    echo $out;
}
// уничтожаем результат
mysql_free_result($result);
gb_showpages($_GET['page']);
echo '</div>';
//форма добавления сообщения
?>
<div id="add_msg">
 	<h2>Добавить новое сообщение</h2>
	<table cellspacing="2" cellpadding="2" border="0">
		<form action=?add=1 method=post>
			<tr>
Example #11
0
    function showSurveyMetaData($message = '')
    {
        echo '
        <ol class="breadcrumb">
  <li><a href="?page=surveys">Surveys</a></li>
  <li><a href="?page=survey">' . $this->survey->getName($_SESSION['language']) . '</a></li>
  <li class="active">' . 'Meta data' . '</li>
</ol>';
        echo mb_wordwrap('this is a very long <b>string</b> ah yes wee ais a very long string yes is a very long string yes yesyes', 25, '--<br/>-----');
        echo '<div class="well" style="background: white;">';
        echo $message;
        global $survey;
        $sections = $survey->getSections();
        $level = 0;
        $lastq = '';
        $condition = '';
        $output = '';
        $state = 0;
        foreach ($sections as $section) {
            $filename = prependPath($section->getRulesLocation());
            //echo $filename;
            $tokens = token_get_all(file_get_contents($filename));
            foreach ($tokens as $key => $token) {
                echo "<b>{$key}</b>:" . print_r($token);
                echo '<br/>';
                if (is_array($token)) {
                    echo '---' . token_name($token[0]) . '---<br/>';
                    if ($token[0] == T_IF) {
                        echo 'THIS IS AN IFFFFFF!';
                        $condition = 'IF ';
                        $state = 1;
                    } elseif ($token[0] == T_ELSE) {
                        $output .= '<br/>ELSE ';
                    }
                    if ($token[1] == 'ask') {
                        //question to ask!!
                        $output .= '<hr>ASK!!(' . $level . '):' . $lastq . '<hr>';
                        //$output .= substr($lastq, 1) . '<br/>';
                        $question = $survey->getQuestionOrGroup(substr($lastq, 1));
                        if ($question != null) {
                            // $output .= $question;
                            //                        $output .= '<br/>NOT NULL<br/>';
                            //                          $output .= json_encode($question);
                            //                      $output .= '-----<br/>----' . get_class($question) . '-----<br/>----';
                            //                    $output .= 'end expr';
                            if ($question instanceof Question) {
                                $output .= tagwrap($question->getQuestionText(), 25, '<br/>');
                                $output .= '<hr>';
                            }
                        }
                    }
                    if ($token[1] == 'value') {
                    } else {
                        if ($token[1] == '->') {
                        } else {
                            //question
                            if ($state == 1) {
                                $condition .= ' ' . $token[1];
                            }
                            $lastq = $token[1];
                        }
                    }
                } else {
                    //level?
                    if ($token == '{') {
                        $state = 0;
                        $output .= '<b>' . $condition . '</b>';
                        //'IF???';
                        $output .= '<br/>';
                        $condition = '';
                        $level++;
                    } elseif ($token == '}') {
                        $output .= '<b>END</b>';
                        //'IF???';
                        $output .= '<br/>';
                        $condition = '';
                        $state = 0;
                        $level--;
                    }
                }
            }
        }
        echo '<hr>OUTPUT<hr>';
        echo $output;
        echo '<hr><hr>';
        echo tagwrap('this is a very long string yes is a very long string yes is a very long string yes yesyes', 25, '--<br/>-----');
    }
Example #12
0
	/**
	 * save vote for this issue
	 *
	 * @param string  $token
	 * @param array   $vote
	 */
	public function vote($token, array $vote) {

		// example for one single proposal:
		// array( 123 => array('acceptance' => 0) )
		// example for two proposals:
		// array( 123 => array('acceptance' => 1, 'score' => 2), 456 => array('acceptance' => -1, 'score' => 0) )

		// convert strings to integers
		foreach ( $vote as &$value ) {
			$value = array_map('intval', $value);
		}
		unset($value);

		DB::transaction_start();

		$sql = "INSERT INTO vote_vote (token, vote) VALUES (".DB::esc($token).", ".DB::esc(serialize($vote)).") RETURNING votetime";
		if ( $result = DB::query($sql) ) {
			list($votetime) = pg_fetch_row($result);

			if (!Login::$member->mail) {
				notice(_("Your vote has been saved, but the email receipt could not be sent, because you have no confirmed email address!"));
			} else {

				// Since the subject can not be encrypted, we don't show which issue.
				$subject = _("Vote receipt");

				$body = _("Group").": ".$this->area()->ngroup()->name."\n\n";

				$body .= sprintf(_("Vote receipt for your vote on issue %d:"), $this->id)."\n\n";
				foreach ( $vote as $proposal_id => $vote_proposal ) {
					$proposal = new Proposal($proposal_id);
					$body .= mb_wordwrap(_("Proposal")." ".$proposal_id.": ".$proposal->title)."\n"
						.BASE_URL."proposal.php?id=".$proposal->id."\n"
						._("Acceptance").": ".acceptance($vote_proposal['acceptance']);
					if (isset($vote_proposal['score'])) $body .= ", "._("Score").": ".score($vote_proposal['score']);
					$body .= "\n\n";
				}
				$body .= _("Your username").": ".Login::$member->username."\n"
					._("Your user ID").": ".Login::$member->id."\n"
					._("Your vote token").": ".$token."\n"
					._("Voting time").": ".date(VOTETIME_FORMAT, strtotime($votetime))."\n\n"
					._("You can change your vote by voting again on:")."\n"
					.BASE_URL."vote.php?issue=".$this->id."\n";

				if ( send_mail(Login::$member->mail, $subject, $body, array(), Login::$member->fingerprint) ) {
					success(_("Your vote has been saved and an email receipt has been sent to you."));
				} else {
					warning(_("Your vote has been saved, but the email receipt could not be sent!"));
				}

			}

			DB::transaction_commit();

		} else {
			warning(_("Your vote could not be saved!"));
			DB::transaction_rollback();
		}

	}
 function contentbuilder_wordwrap($str, $width = 75, $break = "\n", $cut = false, $charset = null)
 {
     return mb_wordwrap($str, $width, $break, $cut, $charset);
 }
Example #14
0
function tagwrap($html, $width = 75, $break = "nr")
{
    $html = '<div>' . $html . '</div>';
    //using dom object
    $dom = new domDocument();
    //load the html into the object
    $dom->loadXML($html);
    // preserve white space
    $dom->preserveWhiteSpace = true;
    //getting all tags
    $content = $dom->getElementsByTagname("*");
    $html = "";
    foreach ($content as $item) {
        //wrapping contents of tags, function described above is used,
        //but you can use your own function or simple wordwrap() php function
        $item->nodeValue = mb_wordwrap($item->nodeValue, $width, $break);
        $html .= $dom->saveXML($item);
    }
    //return the results
    return $html;
    //html_entity_decode($html);
}