代码拉取完成，页面将自动刷新
<?php
require "include/bittorrent.php";
require "./memcache.php";
dbconn();
require_once(get_langfile_path());
loggedinorreturn();
$action = isset($_POST['action']) ? htmlspecialchars($_POST['action']) : (isset($_GET['action']) ? htmlspecialchars($_GET['action']) : '');
$allowed_actions = array("userlog", "dailylog", "chronicle", "funbox", "news", "poll");
if (!$action)
$action = 'userlog';
if (!in_array($action, $allowed_actions))
stderr($lang_log['std_error'], $lang_log['std_invalid_action']);
if (get_user_class() < $log_class && $action != 'userlog') {
stderr($lang_log['std_sorry'], $lang_log['std_permission_denied_only'] . get_user_class_name_zh($log_class, false, true, true) . $lang_log['std_or_above_can_view'], false);
}
function permissiondeny() {
global $lang_log;
stderr($lang_log['std_sorry'], $lang_log['std_permission_denied'], false);
}
function logmenu($selected = "dailylog") {
global $lang_log;
global $showfunbox_main;
begin_main_frame();
print ("<div id=\"lognav\"><ul id=\"logmenu\" class=\"menu\">");
print ("<li><a href=\"userlog.php\">" . $lang_log['text_userlog'] . "</a></li>");
print ("<li><a href=\"totaluser.php\">统计用户</a></li>");
print ("<li" . ($selected == "userlog" ? " class=selected" : "") . "><a href=\"?action=userlog\">" . $lang_log['head_user_log'] . "</a></li>");
print ("<li" . ($selected == "dailylog" ? " class=selected" : "") . "><a href=\"?action=dailylog\">" . $lang_log['text_daily_log'] . "</a></li>");
print ("<li" . ($selected == "chronicle" ? " class=selected" : "") . "><a href=\"?action=chronicle\">" . $lang_log['text_chronicle'] . "</a></li>");
if ($showfunbox_main == 'yes')
print ("<li" . ($selected == "funbox" ? " class=selected" : "") . "><a href=\"?action=funbox\">" . $lang_log['text_funbox'] . "</a></li>");
print ("<li" . ($selected == "news" ? " class=selected" : "") . "><a href=\"?action=news\">" . $lang_log['text_news'] . "</a></li>");
print ("<li" . ($selected == "poll" ? " class=selected" : "") . "><a href=\"?action=poll\">" . $lang_log['text_poll'] . "</a></li>");
print ("</ul></div>");
end_main_frame();
}
function searchtable($title, $action, $opts = array()) {
global $lang_log;
print("<table border=1 cellspacing=0 width=940 cellpadding=5>\n");
print("<tr><td class=colhead align=left>" . $title . "</td></tr>\n");
print("<tr><td class=toolbox align=left><form method=\"get\" action='" . $_SERVER['PHP_SELF'] . "'>\n");
print("<input type=\"text\" name=\"query\" style=\"width:500px\" value=\"" . $_GET['query'] . "\">\n");
if ($opts) {
print($lang_log['text_in'] . "<select name=search>");
foreach ($opts as $value => $text)
print("<option value='" . $value . "'" . ($value == $_GET['search'] ? " selected" : "") . ">" . $text . "</option>");
print("</select>");
}
print("<input type=\"hidden\" name=\"action\" value='" . $action . "'> ");
print("<input type=submit value=" . $lang_log['submit_search'] . "></form>\n");
print("</td></tr></table><br />\n");
}
function additem($title, $action) {
global $lang_log;
print("<table border=1 cellspacing=0 width=940 cellpadding=5>\n");
print("<tr><td class=colhead align=left>" . $title . "</td></tr>\n");
print("<tr><td class=toolbox align=left><form method=\"post\" action='" . $_SERVER['PHP_SELF'] . "'>\n");
print("<textarea name=\"txt\" style=\"width:500px\" rows=\"3\" >" . $row["txt"] . "</textarea>\n");
print("<input type=\"hidden\" name=\"action\" value=" . $action . ">");
print("<input type=\"hidden\" name=\"do\" value=\"add\">");
print("<input type=submit value=" . $lang_log['submit_add'] . "></form>\n");
print("</td></tr></table><br />\n");
}
function edititem($title, $action, $id) {
global $lang_log;
$result = sql_query("SELECT * FROM " . $action . " where id = " . sqlesc($id)) or sqlerr(__FILE__, __LINE__);
if ($row = mysql_fetch_array($result)) {
print("<table border=1 cellspacing=0 width=940 cellpadding=5>\n");
print("<tr><td class=colhead align=left>" . $title . "</td></tr>\n");
print("<tr><td class=toolbox align=left><form method=\"post\" action='" . $_SERVER['PHP_SELF'] . "'>\n");
print("<textarea name=\"txt\" style=\"width:500px\" rows=\"3\" >" . $row["txt"] . "</textarea>\n");
print("<input type=\"hidden\" name=\"action\" value=" . $action . ">");
print("<input type=\"hidden\" name=\"do\" value=\"update\">");
print("<input type=\"hidden\" name=\"id\" value=" . $id . ">");
print("<input type=submit value=" . $lang_log['submit_okay'] . " style='height: 20px' /></form>\n");
print("</td></tr></table><br />\n");
}
}
if (!in_array($action, $allowed_actions))
stderr($lang_log['std_error'], $lang_log['std_invalid_action']);
else {
switch ($action) {
case "userlog":
stdhead($lang_log['head_user_log']);
$query = mysql_real_escape_string(trim($_GET["query"]));
$search = $_GET["search"];
$addparam = "";
$wherea = "";
if (get_user_class() >= $confilog_class) {
switch ($search) {
case "mod": $wherea = " WHERE security_level = 'mod'";
break;
case "normal": $wherea = " WHERE security_level = 'normal'";
break;
case "all": break;
}
$addparam = ($wherea ? "search=" . rawurlencode($search) . "&" : "");
} else {
$wherea = " WHERE security_level = 'normal'";
}
if ($query) {
$wherea .= ($wherea ? " AND " : " WHERE ") . " txt LIKE '%$query%' ";
$addparam .= "query=" . rawurlencode($query) . "&";
}
logmenu('userlog');
$opt = array(all => $lang_log['text_all'], normal => $lang_log['text_normal'], mod => $lang_log['text_mod']);
// ------------- start: stats ------------------//
?>
<h2><?php echo $lang_log['text_tracker_statistics'] ?></h2>
<table width="100%"><tr><td class="text" align="center">
<table width="60%" class="main" border="1" cellspacing="0" cellpadding="10">
<?php
$Cache->new_page('stats_userslog', 3600, true);
if (!$Cache->get_page()) {
$Cache->add_whole_row();
$registered = number_format(get_row_count("users"));
$unverified = number_format(get_row_count("users", "WHERE status='pending'"));
$totalonlinetoday = number_format(get_row_count("users", "WHERE last_access >= " . sqlesc(date("Y-m-d H:i:s", (TIMENOW - 86400)))));
$totalonlineweek = number_format(get_row_count("users", "WHERE last_access >= " . sqlesc(date("Y-m-d H:i:s", (TIMENOW - 604800)))));
$VIP = number_format(get_row_count("users", "WHERE class=" . UC_VIP));
$donated = number_format(get_row_count("users", "WHERE donor = 'yes'"));
$warned = number_format(get_row_count("users", "WHERE warned='yes'"));
$disabled = number_format(get_row_count("users", "WHERE enabled='no'"));
$registered_male = number_format(get_row_count("users", "WHERE gender='Male'"));
$registered_female = number_format(get_row_count("users", "WHERE gender='Female'"));
?>
<tr>
<?php
twotd($lang_log['row_users_active_today'], $totalonlinetoday);
twotd($lang_log['row_users_active_this_week'], $totalonlineweek);
?>
</tr>
<tr>
<?php
twotd($lang_log['row_registered_users'], $registered . " / " . number_format($maxusers));
twotd($lang_log['row_unconfirmed_users'], $unverified);
?>
</tr>
<tr>
<?php
twotd(get_user_class_name_zh(UC_VIP, false, false, true), $VIP);
twotd($lang_log['row_donors'] . " <img class=\"star\" src=\"pic/trans.gif\" alt=\"Donor\" />", $donated);
?>
</tr>
<tr>
<?php
twotd($lang_log['row_warned_users'] . " <img class=\"warned\" src=\"pic/trans.gif\" alt=\"warned\" />", $warned);
twotd($lang_log['row_banned_users'] . " <img class=\"disabled\" src=\"pic/trans.gif\" alt=\"disabled\" />", $disabled);
?>
</tr>
<tr>
<?php
twotd($lang_log['row_male_users'], $registered_male);
twotd($lang_log['row_female_users'], $registered_female);
?>
</tr>
<?php
$Cache->end_whole_row();
$Cache->cache_page();
}
echo $Cache->next_row();
?>
<tr><td colspan="4" class="rowhead"> </td></tr>
<?php
$Cache->new_page('stats_torrentslog', 1800, true);
if (!$Cache->get_page() && 1) {
$Cache->add_whole_row();
$torrents = number_format(get_row_count("torrents", "WHERE visible = 'yes' AND banned = 'no'")); //非断种，且不在回收站的(活种)
$dead = number_format(get_row_count("torrents", "WHERE visible = 'no'"));
$seeders = get_row_count("peers", "WHERE seeder = 'yes'");
$leechers = get_row_count("peers", "WHERE seeder = 'no'");
if ($leechers == 0)
$ratio = 0;
else
$ratio = round($seeders / $leechers * 100);
$activewebusernow = get_row_count("users", "WHERE last_access >= " . sqlesc(date("Y-m-d H:i:s", (TIMENOW - 900))));
$activewebusernow = number_format($activewebusernow);
$activetrackerusernow = number_format(get_single_value("peers", "COUNT(DISTINCT(userid))"));
$peers = number_format($seeders + $leechers);
$seeders = number_format($seeders);
$leechers = number_format($leechers);
$totaltorrentssize = mksize(get_row_sum("torrents", "size"));
$totaluploaded = get_row_sum("users", "uploaded");
$totaldownloaded = get_row_sum("users", "downloaded");
$totaldata = $totaldownloaded + $totaluploaded;
?>
<tr>
<?php
twotd($lang_log['row_torrents'], $torrents);
twotd($lang_log['row_dead_torrents'], $dead);
?>
</tr>
<tr>
<?php
twotd($lang_log['row_seeders'], $seeders);
twotd($lang_log['row_leechers'], $leechers);
?>
</tr>
<tr>
<?php
twotd($lang_log['row_peers'], $peers);
twotd($lang_log['row_seeder_leecher_ratio'], $ratio . "%");
?>
</tr>
<tr>
<?php
twotd($lang_log['row_active_browsing_users'], $activewebusernow);
twotd($lang_log['row_tracker_active_users'], $activetrackerusernow);
?>
</tr>
<tr>
<?php
twotd($lang_log['row_total_size_of_torrents'], $totaltorrentssize);
twotd($lang_log['row_total_uploaded'], mksize($totaluploaded));
?>
</tr>
<tr>
<?php
twotd($lang_log['row_total_downloaded'], mksize($totaldownloaded));
twotd($lang_log['row_total_data'], mksize($totaldata));
?>
</tr>
<?php
$Cache->end_whole_row();
$Cache->cache_page();
}
echo $Cache->next_row();
?>
<tr><td colspan="4" class="rowhead"> </td></tr>
<?php
$Cache->new_page('stats_classeslog', 4535, true);
if (!$Cache->get_page()) {
$Cache->add_whole_row();
$peasants = number_format(get_row_count("users", "WHERE class=" . UC_PEASANT));
$users = number_format(get_row_count("users", "WHERE class=" . UC_USER));
$powerusers = number_format(get_row_count("users", "WHERE class=" . UC_POWER_USER));
$eliteusers = number_format(get_row_count("users", "WHERE class=" . UC_ELITE_USER));
$crazyusers = number_format(get_row_count("users", "WHERE class=" . UC_CRAZY_USER));
$insaneusers = number_format(get_row_count("users", "WHERE class=" . UC_INSANE_USER));
$veteranusers = number_format(get_row_count("users", "WHERE class=" . UC_VETERAN_USER));
$extremeusers = number_format(get_row_count("users", "WHERE class=" . UC_EXTREME_USER));
$ultimateusers = number_format(get_row_count("users", "WHERE class=" . UC_ULTIMATE_USER));
$nexusmasters = number_format(get_row_count("users", "WHERE class=" . UC_NEXUS_MASTER));
?>
<tr>
<?php
twotd(get_user_class_name_zh(UC_PEASANT, false, false, true) . " <img class=\"leechwarned\" src=\"pic/trans.gif\" alt=\"leechwarned\" />", $peasants);
twotd(get_user_class_name_zh(UC_USER, false, false, true), $users);
?>
</tr>
<tr>
<?php
twotd(get_user_class_name_zh(UC_POWER_USER, false, false, true), $powerusers);
twotd(get_user_class_name_zh(UC_ELITE_USER, false, false, true), $eliteusers);
?>
</tr>
<tr>
<?php
twotd(get_user_class_name_zh(UC_CRAZY_USER, false, false, true), $crazyusers);
twotd(get_user_class_name_zh(UC_INSANE_USER, false, false, true), $insaneusers);
?>
</tr>
<tr>
<?php
twotd(get_user_class_name_zh(UC_VETERAN_USER, false, false, true), $veteranusers);
twotd(get_user_class_name_zh(UC_EXTREME_USER, false, false, true), $extremeusers);
?>
</tr>
<tr>
<?php
twotd(get_user_class_name_zh(UC_ULTIMATE_USER, false, false, true), $ultimateusers);
twotd(get_user_class_name_zh(UC_NEXUS_MASTER, false, false, true), $nexusmasters);
?>
</tr>
<?php
$Cache->end_whole_row();
$Cache->cache_page();
}
echo $Cache->next_row();
?>
</table>
</td></tr></table>
<?php
// ------------- end: stats ------------------//
stdfoot();
die;
break;
case "dailylog":
stdhead($lang_log['head_site_log']);
$query = mysql_real_escape_string(trim($_GET["query"]));
$search = $_GET["search"];
$addparam = "";
$wherea = "";
if (get_user_class() >= $confilog_class) {
switch ($search) {
case "mod": $wherea = " WHERE security_level = 'mod'";
break;
case "normal": $wherea = " WHERE security_level = 'normal'";
break;
case "all": break;
}
$addparam = ($wherea ? "search=" . rawurlencode($search) . "&" : "");
} else {
$wherea = " WHERE security_level = 'normal'";
}
if ($query) {
$wherea .= ($wherea ? " AND " : " WHERE ") . " txt LIKE '%$query%' ";
$addparam .= "query=" . rawurlencode($query) . "&";
}
logmenu('dailylog');
$opt = array(all => $lang_log['text_all'], normal => $lang_log['text_normal'], mod => $lang_log['text_mod']);
searchtable($lang_log['text_search_log'], 'dailylog', $opt);
$res = sql_query("SELECT COUNT(*) FROM sitelog" . $wherea);
$row = mysql_fetch_array($res);
$count = $row[0];
$perpage = 50;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, "log.php?action=dailylog&" . $addparam);
$res = sql_query("SELECT added, txt FROM sitelog $wherea ORDER BY added DESC $limit") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 0)
print($lang_log['text_log_empty']);
else {
//echo $pagertop;
print("<table width=940 border=1 cellspacing=0 cellpadding=5>\n");
print("<tr><td class=colhead align=center><img class=\"time\" src=\"pic/trans.gif\" alt=\"time\" title=\"" . $lang_log['title_time_added'] . "\" /></td><td class=colhead align=left>" . $lang_log['col_event'] . "</td></tr>\n");
while ($arr = mysql_fetch_assoc($res)) {
$color = "";
if (strpos($arr['txt'], '移入'))
$color = "purple";
if (strpos($arr['txt'], '移出'))
$color = "green";
if (strpos($arr['txt'], '发布'))
$color = "green";
if (strpos($arr['txt'], '上传'))
$color = "green";
if (strpos($arr['txt'], '删除'))
$color = "red";
if (strpos($arr['txt'], '编辑'))
$color = "blue";
if (strpos($arr['txt'], 'settings updated by'))
$color = "darkred";
print("<tr><td class=\"rowfollow nowrap\" align=center>" . gettime($arr['added'], true, false) . "</td><td class=rowfollow align=left><font color='" . $color . "'>" . htmlspecialchars($arr['txt']) . "</font></td></tr>\n");
}
print("</table>");
echo $pagerbottom;
}
print($lang_log['time_zone_note']);
stdfoot();
die;
break;
case "chronicle":
stdhead($lang_log['head_chronicle']);
$query = mysql_real_escape_string(trim($_GET["query"]));
if ($query) {
$wherea = " WHERE txt LIKE '%$query%' ";
$addparam = "query=" . rawurlencode($query) . "&";
} else {
$wherea = "";
$addparam = "";
}
logmenu("chronicle");
searchtable($lang_log['text_search_chronicle'], 'chronicle');
if (get_user_class() >= $chrmanage_class)
additem($lang_log['text_add_chronicle'], 'chronicle');
if ($_GET['do'] == "del" || $_GET['do'] == 'edit' || $_POST['do'] == "add" || $_POST['do'] == "update") {
$txt = $_POST['txt'];
if (get_user_class() < $chrmanage_class)
permissiondeny();
elseif ($_POST['do'] == "add")
sql_query("INSERT INTO chronicle (userid,added, txt) VALUES ('" . $CURUSER["id"] . "', now(), " . sqlesc($txt) . ")") or sqlerr(__FILE__, __LINE__);
elseif ($_POST['do'] == "update") {
$id = 0 + $_POST['id'];
if (!$id) {
header("Location: log.php?action=chronicle");
die();
} else
sql_query("UPDATE chronicle SET txt=" . sqlesc($txt) . " WHERE id=" . $id) or sqlerr(__FILE__, __LINE__);
}
else {
$id = 0 + $_GET['id'];
if (!$id) {
header("Location: log.php?action=chronicle");
die();
} elseif ($_GET['do'] == "del")
sql_query("DELETE FROM chronicle where id = '" . $id . "'") or sqlerr(__FILE__, __LINE__);
elseif ($_GET['do'] == "edit")
edititem($lang_log['text_edit_chronicle'], 'chronicle', $id);
}
}
$res = sql_query("SELECT COUNT(*) FROM chronicle" . $wherea);
$row = mysql_fetch_array($res);
$count = $row[0];
$perpage = 50;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, "log.php?action=chronicle&" . $addparam);
$res = sql_query("SELECT id, added, txt FROM chronicle $wherea ORDER BY added DESC $limit") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 0)
print($lang_log['text_chronicle_empty']);
else {
//echo $pagertop;
print("<table width=940 border=1 cellspacing=0 cellpadding=5>\n");
print("<tr><td class=colhead align=center>" . $lang_log['col_date'] . "</td><td class=colhead align=left>" . $lang_log['col_event'] . "</td>" . (get_user_class() >= $chrmanage_class ? "<td class=colhead align=center>" . $lang_log['col_modify'] . "</td>" : "") . "</tr>\n");
while ($arr = mysql_fetch_assoc($res)) {
$date = gettime($arr['added'], true, false);
print("<tr><td class=rowfollow align=center><nobr>$date</nobr></td><td class=rowfollow align=left>" . format_comment($arr["txt"], true, false, true) . "</td>" . (get_user_class() >= $chrmanage_class ? "<td align=center nowrap><b><a href=\"" . $PHP_SELF . "?action=chronicle&do=edit&id=" . $arr["id"] . "\">" . $lang_log['text_edit'] . "</a> | <a href=\"" . $PHP_SELF . "?action=chronicle&do=del&id=" . $arr["id"] . "\"><font color=red>" . $lang_log['text_delete'] . "</font></a></b></td>" : "") . "</tr>\n");
}
print("</table>");
echo $pagerbottom;
}
print($lang_log['time_zone_note']);
stdfoot();
die;
break;
case "funbox":
stdhead($lang_log['head_funbox']);
$query = mysql_real_escape_string(trim($_GET["query"]));
$search = $_GET["search"];
if ($query) {
switch ($search) {
case "title": $wherea = " WHERE title LIKE '%$query%' AND status != 'banned'";
break;
case "body": $wherea = " WHERE body LIKE '%$query%' AND status != 'banned'";
break;
case "both": $wherea = " WHERE (body LIKE '%$query%' or title LIKE '%$query%') AND status != 'banned'";
break;
}
$addparam = "search=" . rawurlencode($search) . "&query=" . rawurlencode($query) . "&";
} else {
$wherea = " WHERE status != 'banned'";
$addparam = "";
}
logmenu("funbox");
$opt = array(title => $lang_log['text_title'], body => $lang_log['text_body'], both => $lang_log['text_both']);
searchtable($lang_log['text_search_funbox'], 'funbox', $opt);
$res = sql_query("SELECT COUNT(*) FROM fun " . $wherea);
$row = mysql_fetch_array($res);
$count = $row[0];
$perpage = 10;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, "log.php?action=funbox&" . $addparam);
$res = sql_query("SELECT added, body, title, status FROM fun $wherea ORDER BY added DESC $limit") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 0)
print($lang_log['text_funbox_empty']);
else {
//echo $pagertop;
while ($arr = mysql_fetch_assoc($res)) {
$date = gettime($arr['added'], true, false);
print("<table width=940 border=1 cellspacing=0 cellpadding=5>\n");
print("<tr><td class=rowhead width='10%'>" . $lang_log['col_title'] . "</td><td class=rowfollow align=left>" . $arr["title"] . " - <b>" . $arr["status"] . "</b></td></tr><tr><td class=rowhead width='10%'>" . $lang_log['col_date'] . "</td><td class=rowfollow align=left>" . $date . "</td></tr><tr><td class=rowhead width='10%'>" . $lang_log['col_body'] . "</td><td class=rowfollow align=left>" . format_comment($arr["body"], false, false, true) . "</td></tr>\n");
print("</table><br />");
}
echo $pagerbottom;
}
print($lang_log['time_zone_note']);
stdfoot();
die;
break;
case "news":
stdhead($lang_log['head_news']);
$query = mysql_real_escape_string(trim($_GET["query"]));
$search = $_GET["search"];
if ($query) {
switch ($search) {
case "title": $wherea = " WHERE title LIKE '%$query%' ";
break;
case "body": $wherea = " WHERE body LIKE '%$query%' ";
break;
case "both": $wherea = " WHERE body LIKE '%$query%' or title LIKE '%$query%'";
break;
}
$addparam = "search=" . rawurlencode($search) . "&query=" . rawurlencode($query) . "&";
} else {
$wherea = "";
$addparam = "";
}
logmenu("news");
$opt = array(title => $lang_log['text_title'], body => $lang_log['text_body'], both => $lang_log['text_both']);
searchtable($lang_log['text_search_news'], 'news', $opt);
$res = sql_query("SELECT COUNT(*) FROM news" . $wherea);
$row = mysql_fetch_array($res);
$count = $row[0];
$perpage = 20;
list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, "log.php?action=news&" . $addparam);
$res = sql_query("SELECT id, added, body, title FROM news $wherea ORDER BY added DESC $limit") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 0)
print($lang_log['text_news_empty']);
else {
//echo $pagertop;
while ($arr = mysql_fetch_assoc($res)) {
$date = gettime($arr['added'], true, false);
print("<table width=940 border=1 cellspacing=0 cellpadding=5>\n");
print("<tr><td class=rowhead width='10%'>" . $lang_log['col_title'] . "</td><td class=rowfollow align=left>" . $arr["title"] . "</td></tr><tr><td class=rowhead width='10%'>" . $lang_log['col_date'] . "</td><td class=rowfollow align=left>" . $date . "</td></tr><tr><td class=rowhead width='10%'>" . $lang_log['col_body'] . "</td><td class=rowfollow align=left>" . format_comment($arr["body"], false, false, true) . "</td></tr>\n");
print("</table><br />");
}
echo $pagerbottom;
}
print($lang_log['time_zone_note']);
stdfoot();
die;
break;
case "poll":
$do = $_GET["do"];
$pollid = $_GET["pollid"];
$returnto = htmlspecialchars($_GET["returnto"]);
if ($do == "delete") {
if (get_user_class() < $chrmanage_class)
stderr($lang_log['std_error'], $lang_log['std_permission_denied']);
int_check($pollid, true);
$sure = $_GET["sure"];
if (!$sure)
stderr($lang_log['std_delete_poll'], $lang_log['std_delete_poll_confirmation'] .
"<a href=?action=poll&do=delete&pollid=$pollid&returnto=$returnto&sure=1>" . $lang_log['std_here_if_sure'], false);
sql_query("DELETE FROM pollanswers WHERE pollid = $pollid") or sqlerr();
sql_query("DELETE FROM polls WHERE id = $pollid") or sqlerr();
$Cache->delete_value('current_poll_content');
$Cache->delete_value('current_poll_result', true);
if ($returnto == "main")
header("Location: " . get_protocol_prefix() . "$BASEURL");
else
header("Location: " . get_protocol_prefix() . "$BASEURL/log.php?action=poll&deleted=1");
die;
}
$rows = sql_query("SELECT COUNT(*) FROM polls") or sqlerr();
$row = mysql_fetch_row($rows);
$pollcount = $row[0];
if ($pollcount == 0)
stderr($lang_log['std_sorry'], $lang_log['std_no_polls']);
$polls = sql_query("SELECT * FROM polls ORDER BY id DESC LIMIT 1," . ($pollcount - 1 )) or sqlerr();
stdhead($lang_log['head_previous_polls']);
logmenu("poll");
print("<table border=1 cellspacing=0 width=940 cellpadding=5>\n");
//print("<tr><td class=colhead align=center>".$lang_log['text_previous_polls']."</td></tr>\n");
function srt($a, $b) {
if ($a[0] > $b[0])
return -1;
if ($a[0] < $b[0])
return 1;
return 0;
}
while ($poll = mysql_fetch_assoc($polls)) {
$o = array($poll["option0"], $poll["option1"], $poll["option2"], $poll["option3"], $poll["option4"],
$poll["option5"], $poll["option6"], $poll["option7"], $poll["option8"], $poll["option9"],
$poll["option10"], $poll["option11"], $poll["option12"], $poll["option13"], $poll["option14"],
$poll["option15"], $poll["option16"], $poll["option17"], $poll["option18"], $poll["option19"]);
print("<tr><td align=center>\n");
print("<p class=sub>");
$added = gettime($poll['added'], true, false);
print($added);
if (get_user_class() >= $pollmanage_class) {
print(" - [<a href=makepoll.php?action=edit&pollid=$poll[id]><b>" . $lang_log['text_edit'] . "</b></a>]\n");
print(" - [<a href=?action=poll&do=delete&pollid=$poll[id]><b>" . $lang_log['text_delete'] . "</b></a>]\n");
}
print("<a name=$poll[id]>");
print("</p>\n");
print("<table class=main border=1 cellspacing=0 cellpadding=5><tr><td class=text>\n");
print("<p align=center><b>" . $poll["question"] . "</b></p>");
$pollanswers = sql_query("SELECT selection FROM pollanswers WHERE pollid=" . $poll["id"] . " AND selection < 20") or sqlerr();
$tvotes = mysql_num_rows($pollanswers);
$vs = array(); // count for each option ([0]..[19])
$os = array(); // votes and options: array(array(123, "Option 1"), array(45, "Option 2"))
// Count votes
while ($pollanswer = mysql_fetch_row($pollanswers))
$vs[$pollanswer[0]] += 1;
reset($o);
for ($i = 0; $i < count($o); ++$i)
if ($o[$i])
$os[$i] = array($vs[$i], $o[$i]);
print("<table width=100% class=main border=0 cellspacing=0 cellpadding=0>\n");
$i = 0;
while ($a = $os[$i]) {
if ($tvotes > 0)
$p = round($a[0] / $tvotes * 100);
else
$p = 0;
print("<tr><td class=embedded>" . $a[1] . " </td><td class=\"embedded nowrap\">" .
"<img class=\"bar_end\" src=\"pic/trans.gif\" alt=\"\" /><img class=\"unsltbar\" src=\"pic/trans.gif\" style=\"width: " . ($p * 3) . "px\" /><img class=\"bar_end\" src=\"pic/trans.gif\" alt=\"\" /> $p%</td></tr>\n");
++$i;
}
print("</table>\n");
$tvotes = number_format($tvotes);
print("<p align=center>" . $lang_log['text_votes'] . "$tvotes</p>\n");
print("</td></tr></table><br /><br />\n");
print("</p></td></tr>\n");
}
print("</table>");
print($lang_log['time_zone_note']);
stdfoot();
die;
break;
}
}
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手