" . $a["username"] . ""; else $latestuser = $a['username']; */ $registered = number_format(get_row_count("users")); //$unverified = number_format(get_row_count("users", "WHERE status='pending'")); $torrents = number_format(get_row_count("torrents")); //$dead = number_format(get_row_count("torrents", "WHERE visible='no'")); $r = mysql_query("SELECT value_u FROM avps WHERE arg='seeders'") or sqlerr(__FILE__, __LINE__); $a = mysql_fetch_row($r); $seeders = 0 + $a[0]; $r = mysql_query("SELECT value_u FROM avps WHERE arg='leechers'") or sqlerr(__FILE__, __LINE__); $a = mysql_fetch_row($r); $leechers = 0 + $a[0]; $seeders = number_format(get_row_count("peers", "WHERE seeder='yes'")); $leechers = number_format(get_row_count("peers", "WHERE seeder='no'")); $peers = number_format($seeders + $leechers); $uniqpeer = number_format(get_row_count("peers", "WHERE connectable='yes'")); if ($leechers == 0) $ratio = 0; else $ratio = round($seeders / $leechers * 100); $dt = gmtime() - 180; $dt = sqlesc(get_date_time($dt)); $result = mysql_query("SELECT SUM(last_access >= $dt) AS totalol FROM users") or sqlerr(__FILE__, __LINE__); while ($row = mysql_fetch_array ($result)) { $totalonline = $row["totalol"]; } $dt = gmtime() - 180; $dt = sqlesc(get_date_time($dt)); $res = mysql_query("SELECT id, username, class, donor, warned FROM users WHERE last_access >= $dt ORDER BY username") or print(mysql_error()); while ($arr = mysql_fetch_assoc($res)) { if ($activeusers) $activeusers .= ",\n"; switch ($arr["class"]) { case UC_SYSOP: $arr["username"] = "" . $arr["username"] . ""; break; case UC_ADMINISTRATOR: $arr["username"] = "" . $arr["username"] . ""; break; case UC_MODERATOR: $arr["username"] = "" . $arr["username"] . ""; break; case UC_UPLOADER: $arr["username"] = "" . $arr["username"] . ""; break; case UC_VIP: $arr["username"] = "" . $arr["username"] . ""; break; case UC_POWER_USER: $arr["username"] = "" . $arr["username"] . ""; break; } $donator = $arr["donor"] === "yes"; if ($donator) $activeusers .= ""; $warned = $arr["warned"] === "yes"; if ($warned) $activeusers .= ""; if ($CURUSER) $activeusers .= "{$arr["username"]}"; else $activeusers .= "{$arr["username"]}"; if ($donator) $activeusers .= "" .DONOR. " {$$arr["donor"]}"; if ($warned) $activeusers .= "" .WARNED. " {$$arr["warned"]}"; } if (!$activeusers) $activeusers = "There have been no active users in the last 15 minutes."; stdhead("Home"); //echo "Welcome to our newest member, $latestuser!\n"; print("
"); print("
" .RECENT_NEWS. ""); if (get_user_class() >= UC_ADMINISTRATOR) print(" - [" .NEWS_PAGE. "]"); print("
\n"); $res = mysql_query("SELECT * FROM news WHERE ADDDATE(added, INTERVAL 45 DAY) > NOW() ORDER BY added DESC LIMIT 10") or sqlerr(__FILE__, __LINE__); if (mysql_num_rows($res) > 0) { print("
\n
* "); while($array = mysql_fetch_array($res)) { print("" . gmdate("Y-m-d",strtotime($array['added'])) . " - " . format_comment($array['body'])); if (get_user_class() >= UC_ADMINISTRATOR) { print(" [" .EDIT. "]"); print(" [" .DELETE_. "]"); } print("
"); } print("
\n"); } if ($CURUSER) { // Get current poll $res = mysql_query("SELECT * FROM polls ORDER BY added DESC LIMIT 1") or sqlerr(); if($pollok=(mysql_num_rows($res))) { $arr = mysql_fetch_assoc($res); $pollid = $arr["id"]; $userid = $CURUSER["id"]; $question = format_comment($arr["question"]); $o = array($arr["option0"], $arr["option1"], $arr["option2"], $arr["option3"], $arr["option4"], $arr["option5"], $arr["option6"], $arr["option7"], $arr["option8"], $arr["option9"], $arr["option10"], $arr["option11"], $arr["option12"], $arr["option13"], $arr["option14"], $arr["option15"], $arr["option16"], $arr["option17"], $arr["option18"], $arr["option19"]); // Check if user has already voted $res = mysql_query("SELECT * FROM pollanswers WHERE pollid=$pollid AND userid=$userid") or sqlerr(); $arr2 = mysql_fetch_assoc($res); } print("
" .POLL. ""); if (get_user_class() >= UC_MODERATOR) { print(""); print(" - [" .P_NEW. "]\n"); if($pollok) { print(" - [" .EDIT. "]\n"); print(" - [" .DELETE_. "]"); } print(""); } print("
\n"); if($pollok) { print("
\n"); print("
"); print("
$question
\n"); $voted = $arr2; if ($voted) { // display results if ($arr["selection"]) $uservote = $arr["selection"]; else $uservote = -1; // we reserve 255 for blank vote. $res = mysql_query("SELECT selection FROM pollanswers WHERE pollid=$pollid AND selection < 20") or sqlerr(); $tvotes = mysql_num_rows($res); $vs = array(); // array of $os = array(); // Count votes while ($arr2 = mysql_fetch_row($res)) $vs[$arr2[0]] += 1; reset($o); for ($i = 0; $i < count($o); ++$i) if ($o[$i]) $os[$i] = array($vs[$i], $o[$i]); function srt($a,$b) { if ($a[0] > $b[0]) return -1; if ($a[0] < $b[0]) return 1; return 0; } // now os is an array like this: array(array(123, "Option 1"), array(45, "Option 2")) if ($arr["sort"] == "yes") usort($os, srt); print("\n"); $i = 0; while ($a = $os[$i]) { if ($i == $uservote) $a[1] .= " *"; if ($tvotes == 0) $p = 0; else $p = round($a[0] / $tvotes * 100); if ($i % 2) $c = ""; else $c = " bgcolor=#ECE9D8"; print("\n"); ++$i; } print("
" . $a[1] . " " . " $p%
\n"); $tvotes = number_format($tvotes); print("
" .VOTES. ": $tvotes
\n"); } else { print("
\n"); $i = 0; while ($a = $o[$i]) { print("$a
\n"); ++$i; } print("
"); print("" .BLANK_VOTE. "
\n"); print("
"); } ?>
" .PREVIOUS_POOLS. "
\n"); ?>
\n"; echo "
"; echo"
" .NO_ACTIVE_POOLS. "
\n"; echo "
"; } } ?>
- ( )
