function maketable($res) { global $tracker_lang, $use_ttl, $ttl_days; $ret = "<table class=main border=1 cellspacing=0 cellpadding=5>" . "<tr><td class=colhead align=left>" . $tracker_lang['type'] . "</td><td class=colhead>" . $tracker_lang['name'] . "</td>" . ($use_ttl ? "<td class=colhead align=center>" . $tracker_lang['ttl'] . "</td>" : "") . "<td class=colhead align=center>" . $tracker_lang['size'] . "</td><td class=colhead align=right>" . $tracker_lang['details_seeding'] . "</td><td class=colhead align=right>" . $tracker_lang['details_leeching'] . "</td><td class=colhead align=center>" . $tracker_lang['uploaded'] . "</td>\n" . "<td class=colhead align=center>" . $tracker_lang['downloaded'] . "</td><td class=colhead align=center>" . $tracker_lang['ratio'] . "</td></tr>\n"; while ($arr = mysql_fetch_assoc($res)) { if ($arr["downloaded"] > 0) { $ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3); $ratio = "<font color=" . get_ratio_color($ratio) . ">{$ratio}</font>"; } else { if ($arr["uploaded"] > 0) { $ratio = "Inf."; } else { $ratio = "---"; } } $catid = $arr["catid"]; $catimage = htmlspecialchars_uni($arr["image"]); $catname = htmlspecialchars_uni($arr["catname"]); $ttl = $ttl_days * 24 - floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600); if ($ttl == 1) { $ttl .= " час"; } else { $ttl .= " часов"; } $size = str_replace(" ", "<br />", mksize($arr["size"])); $uploaded = str_replace(" ", "<br />", mksize($arr["uploaded"])); $downloaded = str_replace(" ", "<br />", mksize($arr["downloaded"])); $seeders = number_format($arr["seeders"]); $leechers = number_format($arr["leechers"]); $ret .= "<tr><td style='padding: 0px'><a href=\"browse.php?cat={$catid}\"><img src=\"pic/cats/{$catimage}\" alt=\"{$catname}\" border=\"0\" /></a></td>\n" . "<td><a href=details.php?id={$arr['torrent']}&hit=1><b>" . $arr["torrentname"] . "</b></a></td>" . ($use_ttl ? "<td align=center>{$ttl}</td>" : "") . "<td align=center>{$size}</td><td align=right>{$seeders}</td><td align=right>{$leechers}</td><td align=center>{$uploaded}</td>\n" . "<td align=center>{$downloaded}</td><td align=center>{$ratio}</td></tr>\n"; } $ret .= "</table>\n"; return $ret; }
function maketable($res) { global $cats; if (!isset($cats)) { $res2 = mysql_query("SELECT id, image, name FROM categories") or sqlerr(__FILE__, __LINE__); while ($arr = mysql_fetch_assoc($res2)) { $catimages[$arr["id"]] = $arr["image"]; $catnames[$arr["id"]] = $arr["name"]; } } $ret = '<table class=main border=1 cellspacing=0 cellpadding=5>' . '<tr><td class="colhead" align="center">Tegund</td><td class="colhead">Nafn</td><td class="colhead" align="center">TTL</td><td class="colhead" align="center">Stærð</td><td class="colhead" align="center">Uppl.</td>'."\n" . '<td class="colhead" align="center">Downl.</td><td class="colhead" align="center">Hlutfall</td><td class="colhead" align="center">IP-tala</td></tr>'."\n"; while ($arr = mysql_fetch_assoc($res)) { $res2 = mysql_query("SELECT name,size,category,added FROM torrents WHERE id=$arr[torrent]"); $arr2 = mysql_fetch_assoc($res2); if ($arr["downloaded"] > 0) { $ratio = number_format($arr["uploaded"] / $arr["downloaded"], 2); $ratio = "<font color=" . get_ratio_color($ratio) . ">$ratio</font>"; } else if ($arr["uploaded"] > 0) $ratio = "Inf."; else $ratio = "---"; $catimage = htmlspecialchars($catimages[$arr2["category"]]); $catname = htmlspecialchars($catnames[$arr2["category"]]); $ttl = (28*24) - floor((gmtime() - sql_timestamp_to_unix_timestamp($arr2["added"])) / 3600); if ($ttl == 1) $ttl .= "<br>klst"; $size = str_replace(" ", "<br>", mksize($arr2["size"])); $uploaded = str_replace(" ", "<br>", mksize($arr["uploaded"])); $downloaded = str_replace(" ", "<br>", mksize($arr["downloaded"])); $ip = $arr['ip']; $ret .= '<tr><td style="padding: 0px"><img src="pic/'.$catimage.'" alt="'.$catname.'" width="42" height="42"></td>'."\n" . '<td><a href=details.php?id='.$arr[torrent].'&hit=1><b>'; if(!empty($arr2['name'])) $ret .= htmlspecialchars($arr2[name]); else $ret .= '[Ekkert nafn]'; $ret .= '</b></a></td><td align="center">'.$ttl.'</td><td align="center">'.$size.'</td><td align="center">'.$uploaded.'</td>'."\n" . '<td align="center">'.$downloaded.'</td><td align="center">'.$ratio.'</td><td align="center">'.$ip.'</td></tr>'."\n"; } $ret .= "</table>\n"; return $ret; }
function usertable($res, $frame_caption) { global $CURUSER; begin_frame($frame_caption, true); begin_table(); ?> <tr> <td class=colhead>Место</td> <td class=colhead align=left>Пользователь</td> <td class=colhead>Раздач</td> <td class=colhead align=left>Скорость раздачи</td> <td class=colhead>Закачал</td> <td class=colhead align=left>Скорость закачки</td> <td class=colhead align=right>Рейтинг</td> <td class=colhead align=left>Зарегистрирован</td> </tr> <?php $num = 0; while ($a = mysql_fetch_assoc($res)) { ++$num; $highlight = $CURUSER["id"] == $a["userid"] ? " bgcolor=#BBAF9B" : ""; if ($a["downloaded"]) { $ratio = $a["uploaded"] / $a["downloaded"]; $color = get_ratio_color($ratio); $ratio = number_format($ratio, 2); if ($color) { $ratio = "<font color={$color}>{$ratio}</font>"; } } else { $ratio = "Inf."; } print "<tr{$highlight}><td align=center>{$num}</td><td align=left{$highlight}><a href=userdetails.php?id=" . $a["userid"] . "><b>" . $a["username"] . "</b>" . "</td><td align=right{$highlight}>" . mksize($a["uploaded"]) . "</td><td align=right{$highlight}>" . mksize($a["upspeed"]) . "/s" . "</td><td align=right{$highlight}>" . mksize($a["downloaded"]) . "</td><td align=right{$highlight}>" . mksize($a["downspeed"]) . "/s" . "</td><td align=right{$highlight}>" . $ratio . "</td><td align=left>" . date("Y-m-d", strtotime($a["added"])) . " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($a["added"])) . " назад)</td></tr>"; } end_table(); end_frame(); }
} // End --> </script> <?php print "<h2>" . safeChar($count) . " accounts inactive for longer than " . safeChar($days) . " days.</h2>"; print "<form action=\"inactive.php\" method=\"post\">"; print "<table class=main border=1 cellspacing=0 cellpadding=5><tr>\n"; print "<td class=colhead>Username</td>"; print "<td class=colhead>Class</td>"; print "<td class=colhead>Mail</td>"; print "<td class=colhead>Ratio</td>"; print "<td class=colhead>Last Seen</td>"; print "<td class=colhead align=\"center\">x</td>"; while ($arr = mysql_fetch_assoc($res)) { $ratio = $arr["downloaded"] > 0 ? number_format($arr["uploaded"] / $arr["downloaded"], 3) : ($arr["uploaded"] > 0 ? "Inf." : "---"); $last_seen = $arr["last_access"] == "0000-00-00 00:00:00" ? "never" : "" . get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["last_access"])) . " ago"; $class = get_user_class_name($arr["class"]); print "<tr>"; print "<td><a href=\"userdetails.php?id=" . $arr["id"] . "\">" . $arr["username"] . "</a></td>"; print "<td>" . $class . "</td>"; print "<td><a href=\"mailto:" . $arr["email"] . "\">" . safeChar($arr["email"]) . "</a></td>"; print "<td>" . $ratio . "</td>"; print "<td>" . $last_seen . "</td>"; print "<td align=\"center\" bgcolor=\"#FF0000\"><input type=\"checkbox\" name=\"userid[]\" value=\"" . $arr["id"] . "\" /></td>"; print "</tr>"; } print "<tr><td colspan=\"6\" class=\"colhead\" align=\"center\">\n<select name=\"action\">\n<option value=\"mail\">Send mail</option>\n<option value=\"deluser\" " . ($CURUSER["class"] < UC_ADMINISTRATOR ? "disabled" : "") . ">Delete users</option>\n<option value=\"disable\">Disable Accounts</option>\n</select> <input type=\"submit\" name=\"submit\" value=\"Apply Changes\"/> <input type=\"button\" value=\"Check all\" onClick=\"this.value=check(form)\"></td></tr>"; if ($record_mail) { $ress = sql_query("SELECT avps.value_s AS userid, avps.value_i AS last_mail, avps.value_u AS mails, users.username FROM avps LEFT JOIN users ON avps.value_s=users.id WHERE avps.arg='inactivemail' LIMIT 1"); $date = mysql_fetch_assoc($ress); if ($date["last_mail"] > 0) {
$topicname = $arr["subject"]; $forumid = $arr["f_id"]; $forumname = $arr["name"]; $newposts = $arr["lastpostread"] < $arr["lastpost"] && $CURUSER["id"] == $userid; $order_is = "p.id DESC"; $from_is = "posts AS p LEFT JOIN topics as t ON p.topicid = t.id LEFT JOIN forums AS f ON t.forumid = f.id"; $select_is = "t.id, p.*"; $where_is = "t.id = {$topicid} AND f.minclassread <= " . $CURUSER['class']; $queryposts = "SELECT {$select_is} FROM {$from_is} WHERE {$where_is} ORDER BY {$order_is} {$limit}"; $res2 = sql_query($queryposts) or sqlerr(__FILE__, __LINE__); $arr2 = mysql_fetch_assoc($res2); $postid = $arr2["id"]; $posterid = $arr2["userid"]; $queryuser = sql_query("SELECT username FROM users WHERE id={$arr2['userid']}"); $res3 = mysql_fetch_assoc($queryuser); $added = $arr2["added"] . " GMT (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($arr2["added"])) . " ago)"; ?> <STYLE TYPE="text/css" MEDIA=screen> td.clearalt6 { background: #777777; padding: 5px; border: 0px; border: hidden; } td.clearalt7 { padding: 5px; background: #555555; border: 0px; border: hidden; } </STYLE>
<td class="colhead"><nobr>Last access</td> <td class="colhead"><nobr>Class</td> <td class="colhead">Downloaded</td> <td class="colhead">UpLoaded</td> <td class="colhead">Ratio</td> <td class="colhead">Status</td> <td class="colhead"><nobr>Enabled</td> </tr><?php while ($arr = mysql_fetch_assoc($res)) { if ($arr["downloaded"] > 0) { $ratio = "<font color=" . get_ratio_color(number_format($arr["uploaded"] / $arr["downloaded"], 3)) . ">{$ratio}</font>"; } elseif ($arr["uploaded"] > 0) { $ratio = 'Inf.'; } else { $ratio = "---"; } $uploaded = prefixed($arr["uploaded"]); $downloaded = prefixed($arr["downloaded"]); $added = $arr['added'] != '0000-00-00 00:00:00' ? substr($arr['added'], 0, 10) : '-'; $last_access = $arr['last_access'] != '0000-00-00 00:00:00' ? substr($arr['last_access'], 0, 10) : '-'; $class = get_user_class_name($arr["class"]); echo "<tr align='center'><td><input type=\"checkbox\" name=\"ids[]\" value=\"{$arr['id']}\"></td><td><a href=/userdetails.php?id={$arr['id']}><b>{$arr['username']}</b></a>" . ($arr["donor"] == "yes" ? "<img src=pic/star.gif border=0 alt='Donor'>" : "") . ($arr["warned"] == "yes" ? "<img src=pic/warned.gif border=0 alt='Warned'>" : "") . "</td>\n\t\t<td><nobr>{$added}<br />(<font class='small'>" . get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["added"])) . " ago</font>)</td>\n\t\t<td><nobr>{$last_access}<br />(<font class='small'>" . get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["last_access"])) . " ago</font>)</td>\n\t\t<td>{$class}</td>\n\t\t<td>{$downloaded}</td>\n\t\t<td>{$uploaded}</td>\n\t\t<td>{$ratio}</td>\n\t\t<td>" . $arr['status'] . "</td>\n\t\t<td>" . $arr['enabled'] . "</td>\n\t\t</tr>\n"; } echo "<tr><td colspan=10 align='center'><select name='do'><option value='enabled' disabled selected>What to do?</option><option value='enabled'>Enable selected</option><option value='confirm'>Confirm selected</option><option value='delete'>Delete selected</option></select><input type='submit' value='Submit'></td></tr></form>"; end_table(); echo $pagerbottom; } else { stdmsg('Sorry', 'Nothing found!'); } end_main_frame(); stdfoot();
//echo $pagertop; if (mysql_num_rows($res) == 0) { $votesviewtpl->set("vv2", "<p align=center><b>Nothing Found</b></p>\n"); } else { $votesviewtpl->set("vv3", "<center><table width=99% class=lista align=center cellpadding=3>\n"); $votesviewtpl->set("vv4", "<tr><td class=header>Username</td><td class=header>Uploaded</td><td class=header>Downloaded</td>" . "<td class=header>Ratio</td>\n"); while ($arr = mysql_fetch_assoc($res)) { if ($arr["downloaded"] > 0) { $ratio = number_format($arr["uploaded"] / $arr["downloaded"], 3); //$ratio = "<font color=" . get_ratio_color($ratio) . ">$ratio</font>"; } else { if ($arr["uploaded"] > 0) { $ratio = "Inf."; } else { $ratio = "---"; } } $uploaded = makesize($arr["uploaded"]); $joindate = "{$arr['added']} (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["added"])) . " ago)"; $downloaded = makesize($arr["downloaded"]); if ($arr["enabled"] == 'no') { $enabled = "<font color = red>No</font>"; } else { $enabled = "<font color = green>Yes</font>"; } $req[$i]["vv5"] = "<tr><td class=lista><center><a href=index.php?page=userdetails&id={$arr['userid']}><b>{$arr['username']}</b></a></td><td align=left class=lista><center>{$uploaded}</td><td align=left class=lista><center>{$downloaded}</td><td align=left class=lista><center>{$ratio}</td></tr>\n"; $i++; } $votesviewtpl->set("req", $req); $votesviewtpl->set("vv6", "</table></center><BR><BR>\n"); }
</form> </div></td></tr></table> <br> NOTE: No HTML Code Allowed. (NO HTML) <? } if ($_GET['action'] == ""){ stdhead("Unconnectable Peers Mass PM Log"); $getlog = mysql_query("SELECT * FROM `notconnectablepmlog` LIMIT 10"); print("<h1>Unconnectable Peers Mass PM Log</h1>"); print("<a href=findnotconnectable.php?action=sendpm><h3>Send All not connectable Users A PM</h3></a>"); print("<a href=findnotconnectable.php?action=list><h3>List Unconnectable Users</h3></a>"); print("<br>Please dont use the mass PM too often. we dont want to spam the users, just let them know they are unconnectable.<p>"); print("<br>Every week would be ok.<p>"); print("<table border=1 cellspacing=0 cellpadding=5>\n"); print("<tr><td class=colhead>By User</td><td class=colhead>Date</td><td class=colhead>elapsed</td></tr>"); while($arr2 = mysql_fetch_assoc($getlog)){ $r2 = mysql_query("SELECT username FROM users WHERE id=$arr2[user]") or sqlerr(); $a2 = mysql_fetch_assoc($r2); $elapsed = get_elapsed_time(sql_timestamp_to_unix_timestamp($arr2[date])); print("<tr><td class=colhead><a href=userdetails.php?id=$arr2[user]>$a2[username]</a></td><td class=colhead>$arr2[date]</td><td>$elapsed ago</td></tr>"); } print("</table>"); } stdfoot(); ?>
$ipcount = $arrip[0]; $nip = ip2long($ip); $banres = mysql_query("SELECT COUNT(*) FROM bans WHERE $nip >= first AND $nip <= last") or sqlerr(__FILE__, __LINE__); $banarr = mysql_fetch_row($banres); if ($banarr[0] == 0) if ($ipcount > 1) $ipshow = "<b><a href=ipsearch.php?ip=". $arr['ip'] .">" . $arr['ip'] ."</a></b>"; else $ipshow = "<a href=ipsearch.php?ip=". $arr['ip'] .">" . $arr['ip'] ."</a>"; else $ipshow = "<a href='/testip.php?ip=" . $arr['ip'] . "'><font color='#FF0000'><b>" . $arr['ip'] . "</b></font></a>"; } $date = display_date_time(sql_timestamp_to_unix_timestamp($arr["access"]) , $CURUSER[tzoffset] ); print("<tr><td>$date</td>\n"); print("<td>$ipshow</td>\n"); print("<td>$addr</td>\n"); } end_table(); if ($countrows > $perpage) echo $pagerbottom; end_frame(); end_main_frame(); stdfoot();
$peers = $torr['seeders'] . " seeder" . ($torr['seeders'] > 1 ? "s" : "") . ", " . $torr['leechers'] . " leecher" . ($torr['leechers'] > 1 ? "s" : ""); print "<tr><td><a href=\"userdetails.php?id=" . $arr['userid'] . "\">" . $arr['username'] . "</a> (" . $uratio . ")</td><td><a href=\"details.php?id=" . $arr['torrent'] . "\" alt=\"" . $torr['name'] . "\" title=\"" . $torr['name'] . "\">" . $torrname . "</td><td>" . $peers . "</td></tr>\n"; } print "</table>\n"; end_frame(); end_main_frame(); stdfoot(); } else { stdhead("Torrents Needing Seeds"); begin_main_frame(); begin_frame("[<a href=\"?needed=leechers\" class=\"altlink\">Seeders In Need</a>] - Torrents Needing Seeds"); $res = sql_query("SELECT id, name, seeders, leechers, added FROM torrents WHERE leechers >= 0 AND seeders = 0 ORDER BY leechers DESC LIMIT 40"); if (mysql_num_rows($res) > 0) { print "<table class=main border=1 cellspacing=0 cellpadding=5>\n"; print "<tr><td class=\"colhead\">Torrent</td><td class=\"colhead\">Seeders</a></td><td class=\"colhead\">Leechers</td></tr>\n"; while ($arr = mysql_fetch_assoc($res)) { $torrname = htmlspecialchars($arr['name']); if (strlen($torrname) > 55) { $torrname = substr($torrname, 0, 55) . "..."; } $ttl = 28 * 24 - floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600); print "<tr><td><a href=\"details.php?id=" . $arr['id'] . "&hit=1\" alt=\"" . $arr['name'] . "\" title=\"" . $arr['name'] . "\">" . $torrname . "</td><td><font color=\"red\">" . $arr['seeders'] . "</a></td><td>" . number_format($arr['leechers']) . "</td></tr>\n"; } print "</table>\n"; } else { print "-- There are no torrents needing seeds right now --\n"; } end_frame(); end_main_frame(); stdfoot(); }
echo "<th class='table_head'>" . T_("DOWNLOADED") . "</th>"; echo "<th class='table_head'>" . T_("RATIO") . "</th>"; echo "<th class='table_head'>" . T_("TORRENTS_POSTED") . "</th>"; echo "<th class='table_head'>AVG Daily Upload</th>"; echo "<th class='table_head'>" . T_("ACCOUNT_SEND_MSG") . "</th>"; echo "<th class='table_head'>Joined</th>"; echo "</tr>"; for ($i = 0; $i <= $zerofix; $i++) { $id = mysql_result($result, $i, "id"); $username = mysql_result($result, $i, "username"); $added = mysql_result($result, $i, "added"); $uploaded = mysql_result($result, $i, "uploaded"); $downloaded = mysql_result($result, $i, "downloaded"); $donated = mysql_result($result, $i, "donated"); $warned = mysql_result($result, $i, "warned"); $joindate = "" . get_elapsed_time(sql_timestamp_to_unix_timestamp($added)) . " ago"; $upperquery = "SELECT added FROM torrents WHERE owner = {$id}"; $upperresult = SQL_Query_exec($upperquery); $seconds = mkprettytime(utc_to_tz_time() - utc_to_tz_time($added)); $days = explode("d ", $seconds); if (sizeof($days) > 1) { $dayUpload = $uploaded / $days[0]; $dayDownload = $downloaded / $days[0]; } $torrentinfo = mysql_fetch_array($upperresult); $numtorrents = mysql_num_rows($upperresult); if ($downloaded > 0) { $ratio = $uploaded / $downloaded; $ratio = number_format($ratio, 3); $color = get_ratio_color($ratio); if ($color) {
// /////////////// if ($user['ip'] && (get_user_class() >= UC_MODERATOR || $user['id'] == $CURUSER['id'])) { $ip = $user['ip']; $dom = gethostbyaddr_timeout($ip); if ($dom == $ip) { $addr = '<a href="whois.php?query=' . $ip . '">' . $ip . '</a>'; } else { $dom = htmlentities($dom, ENT_QUOTES); $addr = '<a href="whois.php?query=' . $ip . '">' . $ip . '</a> (' . $dom . ')'; } } // ///////////////////////////// $joindate = $user['added'] == '0000-00-00 00:00:00' ? 'N/A' : $user['added'] . ' (' . get_elapsed_time(sql_timestamp_to_unix_timestamp($user['added'])) . ' ago)'; $lastseen = $user['last_access'] == '0000-00-00 00:00:00' ? 'Never' : $user['last_access'] . ' (' . get_elapsed_time(sql_timestamp_to_unix_timestamp($user['last_access'])) . ' ago)'; $lapsetime = ($lapsetime = time() - sql_timestamp_to_unix_timestamp($user["last_login"])) / 3600 % 24 . ' Hours ' . $lapsetime / 60 % 60 . ' minutes ' . $lapsetime % 60 . ' seconds '; $onlinetime = "{$user['last_login']} (" . get_date_time(sql_timestamp_to_unix_timestamp($user["last_access"])) . ")"; $res = sql_query("SELECT COUNT(*) FROM comments WHERE user="******"id"])) or sqlerr(); $arr3 = mysql_fetch_row($res); $torrentcomments = $arr3[0]; $res = sql_query("SELECT COUNT(*) FROM posts WHERE userid=" . unsafeChar($user["id"])) or sqlerr(); $arr3 = mysql_fetch_row($res); $forumposts = $arr3[0]; $country = ''; include 'include/cache/countries.php'; foreach ($countries as $country) { if ($country["id"] == $user["country"]) { $country = "<td class=embedded><img src=\"{$pic_base_url}flag/{$country['flagpic']}\" alt=\"" . $country['name'] . "\" style='margin-left: 8pt'></td>"; break; } } $ipto = sql_query("SELECT COUNT(id) FROM `users` AS iplist WHERE `ip` = '" . unsafeChar($user["ip"]) . "'") or sqlerr(__FILE__, __LINE__);
stdhead("Personal lists for " . $user['username']); begin_frame("Personal lists for " . class_user($user[username]) . ""); print "<div style='margin-top:10px; margin-bottom:20px' align='center'><font size=2><font color=#0080FF><b>List of Personal watched users</b></font></div>"; ?> <table class="table_table" border="0" width="100%"> <tr> <th class="table_head"><b>User Name</b></td></th> <th class="table_head"><b>Account enabled?</b></td></th> <th class="table_head"><b>Contact user</td></th> <th class="table_head"><b>Last Seen</b></td></th> <th class="table_head"><b>REMOVE</b></td></th> </tr> <?php $res = SQL_Query_exec("SELECT b.bkid as id, u.username AS name, u.class, u.avatar, u.title, u.enabled, u.last_access FROM bookmarkuser AS b LEFT JOIN users as u ON b.bkid = u.id WHERE userid={$userid} ORDER BY name"); if (mysql_num_rows($res) == 0) { $bookmarkuser = "******"; } else { while ($bookmarkuser = mysql_fetch_array($res)) { $title = $bookmarkuser["title"]; if (!$title) { $title = get_user_class_name($bookmarkuser["class"]); } $banned = $bookmarkuser["enabled"]; echo "<tr>\n <td class='table_col1' align='center'><a href='../user/?id=" . $bookmarkuser['id'] . "'><b>" . class_user($bookmarkuser['name']) . "</b></a></td>\n <td class='table_col2' align='center'>{$banned}</td>\n <td class='table_col1' align='center'><a href='../message/?compose&id=" . $bookmarkuser['id'] . "'><img src='../images/button_pm.gif' title='Send PM'></a></td>\n <td class='table_col2' align='center'><div style='margin-top:10px; margin-bottom:2px'>Last seen: " . date("<\\b>d.M.Y<\\/\\b> H:i", utc_to_tz_time($bookmarkuser['last_access'])) . "</div>[<b>" . get_elapsed_time(sql_timestamp_to_unix_timestamp($bookmarkuser[last_access])) . " ago</b>]</td>\n <td class='table_col1' align='center'><b><a href='../watch/?id={$userid}&action=delete&type=bookmarkuser&targetid=" . $bookmarkuser['id'] . "'><font style='margin-left:7px'><input type='submit' value='Remove' class='btn btn-success'/></font></a></b></td>\n </tr>"; } } ?> </table> <?php end_frame(); stdfoot();
$res_who2 = sql_query("SELECT name FROM torrents WHERE id = {$arr_info['reporting_what']}"); $arr_who2 = mysql_fetch_assoc($res_who2); $link_to_thing = "<a class=altlink href=details.php?id={$arr_info['reporting_what']}><b>" . safechar($arr_who2['name']) . "</b></a>"; break; case "Hit_And_Run": $res_who2 = sql_query("SELECT users.username, torrents.name, r.2nd_value FROM users, torrents LEFT JOIN reports AS r ON r.2nd_value = torrents.id WHERE users.id={$arr_info['reporting_what']}"); $arr_who2 = mysql_fetch_assoc($res_who2); $link_to_thing = "<b>user:</b> <a class=altlink href=userdetails.php?id=" . $arr_info['reporting_what'] . "&completed=1><b>" . $arr_who2['username'] . "</b></a><br>hit and run on:<br> <a class=altlink href=details.php?id=" . $arr_info['2nd_value'] . "&page2=0#snatched><b>" . safechar($arr_who2['name']) . "</b></a>"; break; case "Post": $res_who2 = sql_query("SELECT subject FROM topics WHERE id = " . $arr_info['2nd_value']); $arr_who2 = mysql_fetch_assoc($res_who2); $link_to_thing = "<b>post:</b> <a class=altlink href=forums.php?action=viewtopic&topicid=" . $arr_info['2nd_value'] . "&page=last#" . $arr_info['reporting_what'] . "><b>" . safechar($arr_who2['subject']) . "</b></a>"; break; } } echo "<tr><td align=left valign=top class={$class}>" . $arr_info['added'] . "</td><td align=left valign=top class={$class}><a class=altlink href=userdetails.php?id=" . $arr_info['reported_by'] . ">" . "<b>" . $arr_info['username'] . "</b></a></td><td align=left valign=top class={$class}>{$link_to_thing}</td><td align=left valign=top class={$class}><b>" . str_replace("_", " ", $arr_info["reporting_type"]) . "</b>" . "</td><td align=left valign=top class={$class}>" . safechar($arr_info['reason']) . "</td><td align=center valign=top class={$class}>{$dealtwith} {$delt_link}</td><td align=center valign=middle class={$class}>{$checkbox}</td>" . (get_user_class() == UC_SYSOP ? "<td align=center valign=middle class={$class}><a class=altlink href=reports.php?id=" . $arr_info['id'] . "&delete=1><font color=red>Delete</font></a></td>" : "") . "</tr>\n"; // ===how was it delt with? if ($arr_info['how_delt_with']) { echo "<tr><td colspan=" . (get_user_class() == UC_SYSOP ? "8" : "7") . " class={$class} align=left><b>Delt with by " . $arr_who['username'] . ":</b> on: " . $arr_info['when_delt_with'] . " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($arr_info['when_delt_with'])) . " ago)</td></tr><tr><td colspan=" . (get_user_class() == UC_SYSOP ? "8" : "7") . " class={$class} align=left>" . safechar($arr_info['how_delt_with']) . "<br><br></td></tr>"; } } } echo "</table>"; if ($count > '0') { // === deal with it echo "<br><br><p align=center><b>How {$CURUSER['username']} Delt with this report:</b> [ required ] </p><textarea name=how_delt_with cols=70 rows=5 ></textarea><br><br>" . "<input type=submit class=button value=Confirm><br><br></form></td></tr></table>"; } //=== end if count stdfoot(); die;
while ($row = mysql_fetch_assoc($res_search)) { // =======change colors $count = ++$count % 2; $class = 'clearalt' . ($count == 0 ? 6 : 7); $class2 = 'clearalt' . ($count == 0 ? 7 : 6); // === if not searching one member... if (!$member) { $res_username = sql_query('SELECT username,id FROM users WHERE id=' . sqlesc($row[$sender_reciever]) . ' LIMIT 1') or sqlerr(__FILE__, __LINE__); $arr_username = mysql_fetch_array($res_username); $the_username = '******' . $arr_username['id'] . '>' . htmlspecialchars($arr_username['username']) . '</a>'; } // === if searching all boxes... $arr_box = $row['location'] == 1 ? 'Inbox' : ($row['location'] < 1 ? 'Sentbox' : ''); if ($all_boxes && $arr_box === '') { $res_box_name = sql_query('SELECT name FROM pmboxes WHERE userid=' . $CURUSER['id'] . ' AND boxnumber=' . sqlesc($row['location'])) or sqlerr(__FILE__, __LINE__); $arr_box_name = mysql_fetch_assoc($res_box_name); $arr_box = $arr_box_name['name']; } // ==== highlight search terms... from Jaits search forums mod $body = str_ireplace($keywords, '<font style=\'background-color:yellow;font-weight:bold;color:black;\'>' . $keywords . '</font>', format_comment($row['msg'])); $subject = str_ireplace($keywords, '<font style=\'background-color:yellow;font-weight:bold;color:black;\'>' . $keywords . '</font>', htmlspecialchars($row['subject'])); // === print the damn thing :P // === if it's as a list or as posts... echo 0 + $_POST['as_list_post'] == 2 ? '<tr><td class=colhead colspan=4>message from: ' . ($row[$sender_reciever] == 0 ? 'System' : '<b>' . $the_username . '</b>') . '</td></tr><tr><td class=' . $class2 . ' colspan=4><b>subject:</b> <a class=altlink href=?action=viewmessage&id=' . $row['id'] . '>' . ($row['subject'] !== '' ? $subject : 'No Subject') . '</a> ' . ($all_boxes ? '[ found in ' . $arr_box . ' ]' : '') . ' at: ' . $row['added'] . ' GMT (' . get_elapsed_time(sql_timestamp_to_unix_timestamp($row['added'])) . ' ago)</td></tr><tr><td class=' . $class . ' colspan=4>' . $body . '</td></tr>' : '<tr><td class=' . $class . '><img src=pic/outbox.gif alt=Read></td><td class=' . $class . '><a class=altlink href=?action=viewmessage&id=' . $row['id'] . '>' . ($row['subject'] !== '' ? $subject : 'No Subject') . '</a> ' . ($all_boxes ? '[ found in ' . $arr_box . ' ]' : '') . '</td>' . '<td class=' . $class . '>' . ($row[$sender_reciever] == 0 ? 'System' : '<b>' . $the_username . '</b>') . '</td><td nowrap class=' . $class . '>' . $row['added'] . ' GMT (' . get_elapsed_time(sql_timestamp_to_unix_timestamp($row['added'])) . ' ago) </td></tr>'; } } // === the bottom echo ($num_resault > 0 ? '</table>' : '') . '<br><a class=altlink href=?action=search>Search Messages</a> || <a class=altlink href=?action=editmailboxes>Mailbox Manager / PM settings</a> || <a class=altlink href=/sendmessage.php?receiver=' . $CURUSER['id'] . '&draft=1>write new Draft</a></div>'; stdfoot(); } die;
function latestforumposts() { global $pic_base_url, $CURUSER, $config, $php_file, $page_find, $lang_off, $language; // / FIRST WE MAKE THE HEADER (NON-LOOPED) /// ?> <table align="center" width="760" cellspacing=0 cellpadding=8><tr><td align="left" class=colhead><b><?php echo $language['topic']; ?> </b></td><!--<td align="center" class=colhead><b>Author</b></td><td align="center" class=colhead><b>Replies</b></td>--><td align="center" class=colhead><b><?php echo $language['view']; ?> </b></td><td align="center" class=colhead><b><?php echo $language['post']; ?> </b></td><!--<td align="center" class=colhead><b>Posted At</b></td>--> </tr> <?php $page = 1; $num = 0; // / HERE GOES THE QUERY TO RETRIEVE DATA FROM THE DATABASE AND WE START LOOPING /// $topicres = sql_query("SELECT t.id, t.userid, t.subject, t.locked, t.forumid, t.pollid, t.lastpost, t.sticky, t.views, t.forumid, f.minclassread, f.name " . ", (SELECT COUNT(id) FROM posts WHERE topicid=t.id) AS p_count " . ", p.userid AS puserid, p.added " . ", u.id AS uid, u.username " . ", u2.username AS u2_username " . "FROM topics AS t " . "LEFT JOIN forums AS f ON f.id = t.forumid " . "LEFT JOIN posts AS p ON p.id=(SELECT MAX(id) FROM posts WHERE topicid = t.id) " . "LEFT JOIN users AS u ON u.id=p.userid " . "LEFT JOIN users AS u2 ON u2.id=t.userid " . "WHERE t.locked = 'no' AND f.minclassread <= " . $CURUSER['class'] . " " . "ORDER BY t.lastpost DESC LIMIT 11") or sqlerr(__FILE__, __LINE__); while ($topicarr = mysql_fetch_assoc($topicres)) { $topicid = $topicarr["id"]; $topic_userid = $topicarr["userid"]; $perpage = $CURUSER["postsperpage"]; if (!$perpage) { $perpage = 24; } $posts = $topicarr["p_count"]; $replies = max(0, $posts - 1); $first = $page * $perpage - $perpage + 1; $last = $first + $perpage - 1; if ($last > $num) { $last = $num; } $pages = ceil($posts / $perpage); // $menu = "\n"; $menu = ""; for ($i = 1; $i <= $pages; $i++) { if ($i == 1 && $i != $pages) { $menu .= "[ "; } if ($pages > 1) { $menu .= "<a href=/forums.php?action=viewtopic&topicid={$topicid}&page={$i}>{$i}</a>\n"; } if ($i < $pages) { $menu .= "|\n"; } if ($i == $pages && $i > 1) { $menu .= "]"; } } $added = $topicarr["added"] . '<br /><font class=small>(' . get_elapsed_time(sql_timestamp_to_unix_timestamp($topicarr["added"])) . ' ago)</font>'; $username = is_valid_id($topicarr['uid']) ? "<a href=/userdetails.php?id=" . $topicarr["puserid"] . "><b>" . $topicarr['username'] . "</b></a>" : "<i>Unknown[{$topic_userid}]</i>"; $author = !empty($topicarr['u2_username']) ? "<a href=/userdetails.php?id={$topic_userid}><b>" . $topicarr['u2_username'] . "</b></a>" : "<i>Unknown[{$topic_userid}]</i>"; $staffimg = $topicarr["minclassread"] > 0 ? "<img src=" . $pic_base_url . "staff.png border=0 />" : ""; $lockimg = $topicarr["locked"] == 'yes' ? "<img src=" . $pic_base_url . "lockednew.gif border=0 />" : ""; $pollimg = is_valid_id($topicarr["pollid"]) ? "<img src=\"" . $pic_base_url . "poll.gif\" alt=\"Poll:\" width=\"12\" height=\"14\" /> " : ""; $stickyimg = $topicarr["sticky"] == 'yes' ? "<img src=\"" . $pic_base_url . "sticky.gif\" alt=\"Sticky:\" width=\"12px\" height=\"14px\" /> " : ""; $subject = $pollimg . $stickyimg . "<a href=\"forums.php?action=viewtopic&topicid={$topicid}&page=last#" . $topicarr["lastpost"] . "\"><b>" . encodehtml($topicarr["subject"]) . "</b></a>{$lockimg} {$staffimg} {$menu}<br /><font class=small> in <i><a href=\"/forums.php?action=viewforum&forumid=" . $topicarr['forumid'] . "\">" . $topicarr['name'] . "</a></i> by " . $author . " " . get_elapsed_time(sql_timestamp_to_unix_timestamp($topicarr["added"])) . " ago </font>"; ?> <tr><td><?php echo $subject; ?> </td><td align="center"><?php echo number_format($topicarr["views"]); ?> </td><td align="center"><?php echo $username; ?> </td></tr><?php } ?> </table> <?php }
} else { echo '<td align=center>---</td>'; } } } echo '</table><br>'; $select = sql_query("SELECT * FROM invite_codes WHERE sender = " . sqlesc($CURUSER['id']) . " AND status = 'Pending'") or sqlerr(); $num_row = mysql_num_rows($select); print "<table border=1 width=750 cellspacing=0 cellpadding=5>" . "<tr class=tabletitle><td colspan=6 class=colhead><b>Created Invite Codes</b></td></tr>"; if (!$num_row) { echo '<tr class=tableb><td colspan=6>You have not created invite codes at the moment!</tr>'; } else { echo '<tr class=tableb><td><b>Invite Code</b></td><td><b>Created Date</b></td><td><b>Delete</b></td><td><b>Status</b></tr>'; for ($i = 0; $i < $num_row; ++$i) { $fetch_assoc = mysql_fetch_assoc($select); echo '<tr class=tableb><td>' . $fetch_assoc['code'] . ' <a href="?do=send_email&id=' . (int) $fetch_assoc['id'] . '"><img src="pic/email.gif" border="0" / ></td><td>' . "" . get_elapsed_time(sql_timestamp_to_unix_timestamp($fetch_assoc['invite_added'])) . " ago" . '</td>'; echo '<td><a href="?do=delete_invite&id=' . (int) $fetch_assoc['id'] . '"><img src=pic/del.png border=0 /></a></td><td>' . $fetch_assoc['status'] . '</td></tr>'; } } echo '<tr class=tableb><td colspan=7 align=center><form action="?do=create_invite" method="post"><input type=submit value="Create Invite Code" style=height: 20px></form></td></tr>'; echo '</table>'; stdfoot(); } elseif ($do == 'create_invite') { if ($CURUSER['invites'] <= 0) { stderr('Error', 'No invites!'); } if ($CURUSER["invite_on"] == 'no') { stderr("Denied", "Your invite sending privileges has been disabled by the Staff!"); } $res = sql_query("SELECT COUNT(*) FROM users") or sqlerr(__FILE__, __LINE__); $arr = mysql_fetch_row($res);
$arg = $autoslowclean_interval; break; case 's2slowcleantime': $arg = $s2autoslowclean_interval; break; case 'lastoptimizedbtime': $arg = $optimizedb_interval; break; case 'lastbackupdbtime': $arg = $backupdb_interval; break; case 'lastautohitruntime': $arg = $autohitrun_interval; break; } echo '<tr>' . '<td>' . $arr['arg'] . '</td>' . '<td>' . get_date_time($arr['value_u']) . ' (' . get_elapsed_time(sql_timestamp_to_unix_timestamp(get_date_time($arr['value_u']))) . ' ago)</td>' . '<td>' . calctime($arg) . '</td>' . '<td>' . calctime($arr['value_u'] - (gmtime() - $arg)) . '</td>' . '</tr>'; } end_table(); ?> <br><form action="<?php echo $_SERVER["SCRIPT_NAME"]; ?> " method="post"> <table align="center"><tr><td class="chs"> <input type="checkbox" name="docleanup">Do Cleanup <input type="checkbox" name="doslowcleanup">Do Slow Cleanup <input type="checkbox" name="dos2slowcleanup">Do Slow Cleanup2 <input type="checkbox" name="dooptimization">Do Optimization
} echo "</table>\n"; echo "<p align=right><input type=submit value=Delete></p>"; echo "</form>"; echo $pagerbottom; echo "</td></tr></table>\n"; } stdfoot(); } // View application if ($action == "viewapp") { $id = $_GET["id"]; $res = sql_query("SELECT uploadapp.*, users.id AS uid, users.username, users.class, users.added, users.uploaded, users.downloaded FROM uploadapp INNER JOIN users on uploadapp.userid = users.id WHERE uploadapp.id={$id}") or sqlerr(__FILE__, __LINE__); $arr = mysql_fetch_assoc($res); $membertime = get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["added"])); $elapsed = get_elapsed_time(sql_timestamp_to_unix_timestamp($arr["applied"])); stdhead("Uploader applications"); echo "<h1 align=center>Uploader application</h1>"; echo "<table width=750 border=1 cellspacing=0 cellpadding=5>"; echo "<tr><td class=rowhead width=25%>My username is</td><td><a href=userdetails.php?id={$arr['uid']}>{$arr['username']}</a></td></tr>"; echo "<tr><td class=rowhead>I have joined at</td><td>{$arr['added']} ({$membertime} ago)</td></tr>"; echo "<tr><td class=rowhead>My upload amount is</td><td>" . prefixed($arr["uploaded"]) . "</td></tr>"; echo "<tr><td class=rowhead>My download amount is</td><td>" . prefixed($arr["downloaded"]) . "</td></tr>"; echo "<tr><td class=rowhead>My ratio is </td><td>" . number_format($arr["uploaded"] / $arr["downloaded"], 3) . "</td></tr>"; echo "<tr><td class=rowhead>I am connectable</td><td>{$arr['connectable']}</td></tr>"; echo "<tr><td class=rowhead>My current userclass is</td><td>" . get_user_class_name($arr["class"]) . "</td></tr>"; echo "<tr><td class=rowhead>I have applied at</td><td>{$arr['applied']} ({$elapsed} ago)</td></tr>"; echo "<tr><td class=rowhead>My upload speed is</td><td>" . htmlspecialchars($arr["speed"]) . "</td></tr>"; echo "<tr><td class=rowhead>What I have to offer</td><td>" . htmlspecialchars($arr["offer"]) . "</td></tr>"; echo "<tr><td class=rowhead>Why I should be promoted</td><td>" . htmlspecialchars($arr["reason"]) . "</td></tr>"; echo "<tr><td class=rowhead>I am uploader at other sites</td><td>{$arr['sites']}</td></tr>";
} if ($n_tor == 0) { stdmsg("Sorry...", "No categories defined!"); } else { if ($catorder == "lastul") { $orderby = "last DESC, c.name"; } elseif ($catorder == "torrents") { $orderby = "n_t DESC, c.name"; } elseif ($catorder == "peers") { $orderby = "n_p DESC, name"; } else { $orderby = "c.name"; } $res = mysql_query("SELECT c.name, MAX(t.added) AS last, COUNT(DISTINCT t.id) AS n_t, COUNT(p.id) AS n_p\r\n\tFROM categories as c LEFT JOIN torrents as t ON t.category = c.id LEFT JOIN peers as p\r\n\tON t.id = p.torrent GROUP BY c.id ORDER BY {$orderby}") or sqlerr(__FILE__, __LINE__); begin_frame("Category Activity", true); begin_table(); print "<tr><td class=colhead><a href=\"" . $_SERVER['PHP_SELF'] . "?uporder={$uporder}&catorder=category\" class=colheadlink>Category</a></td>\r\n\t<td class=colhead><a href=\"" . $_SERVER['PHP_SELF'] . "?uporder={$uporder}&catorder=lastul\" class=colheadlink>Last Upload</a></td>\r\n\t<td class=colhead><a href=\"" . $_SERVER['PHP_SELF'] . "?uporder={$uporder}&catorder=torrents\" class=colheadlink>Torrents</a></td>\r\n\t<td class=colhead>Perc.</td>\r\n\t<td class=colhead><a href=\"" . $_SERVER['PHP_SELF'] . "?uporder={$uporder}&catorder=peers\" class=colheadlink>Peers</a></td>\r\n\t<td class=colhead>Perc.</td></tr>\n"; while ($cat = mysql_fetch_assoc($res)) { print "<tr><td class=rowhead>" . $cat['name'] . "</b></a></td>"; print "<td " . ($cat['last'] ? ">" . $cat['last'] . " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($cat['last'])) . " ago)" : "align = center>---") . "</td>"; print "<td align=right>" . $cat['n_t'] . "</td>"; print "<td align=right>" . number_format(100 * $cat['n_t'] / $n_tor, 1) . "%</td>"; print "<td align=right>" . $cat['n_p'] . "</td>"; print "<td align=right>" . ($n_peers > 0 ? number_format(100 * $cat['n_p'] / $n_peers, 1) . "%" : "---") . "</td>\n"; } end_table(); end_frame(); } end_main_frame(); stdfoot(); die;
while ($i <= 200) { $per_page_drop_down .= '<option value="?action=problems&per_page=' . $i . '" ' . ($perpage == $i ? ' selected' : '') . '>' . $i . ' items per page</option>'; $i = $i + 10; } $per_page_drop_down .= '</select></form>'; list($pagertop, $pagerbottom, $limit) = pager($perpage, $count, '?action=problems' . ($_GET['per_page'] && 0 + $_GET['per_page'] > 0 ? '&per_page=' . (0 + $_GET['per_page']) : '') . '&'); echo '<p align=center>' . $pagertop . '</p><p align=center>' . $per_page_drop_down . '</p>'; echo '<table align=center border=1 cellpadding=5 cellspacing=0><td class=colhead align=center>Added</td><td class=colhead align=center>Added by</td><td class=colhead align=center>Problem</td><td class=colhead align=center>Solved - by</td><td class=colhead align=center>Solved in*</td>' . (get_user_class() == UC_SYSOP ? '<td class=colhead align=center>Delete</td>' : '') . '</tr>' . '<form method=post name=helpdesk action=?staff_delete=1 onSubmit="return ValidateForm(this,\'delhd\')">'; $res = sql_query("SELECT added, solved_date, added_by, id, title, solved, solved_by FROM helpdesk ORDER BY added DESC {$limit}") or sqlerr(__FILE__, __LINE__); while ($arr = mysql_fetch_array($res)) { $biatch_rez = sql_query("SELECT username FROM users WHERE id =" . $arr['added_by']) or sqlerr(__FILE__, __LINE__); $biatch_arr = mysql_fetch_assoc($biatch_rez); $solved_by_rez = sql_query("SELECT username FROM users WHERE id =" . $arr['solved_by']) or sqlerr(__FILE__, __LINE__); $solved_by_arr = mysql_fetch_assoc($solved_by_rez); // === if problem solved print info, if not hell, print that too :-O $solved_in_wtf = sql_timestamp_to_unix_timestamp($arr['solved_date']) - sql_timestamp_to_unix_timestamp($arr['added']); $solved_in = $arr['solved_date'] == '0000-00-00 00:00:00' ? ' [ N/A ]' : ' [ ' . round_time($solved_in_wtf) . ' ]'; switch (true) { case $arr['solved_date'] == '0000-00-00 00:00:00': $solved_color = 'pink'; break; case $solved_in_wtf > 2 * 3600: $solved_color = 'red'; break; case $solved_in_wtf > 3600: $solved_color = 'orange'; break; case $solved_in_wtf <= 1800: $solved_color = 'green'; break; }
while ($i < $num2) { $uid = mysqli_result($result, $i, "uid"); $res2 = do_sqlquery("SELECT username,id_level from {$TABLE_PREFIX}users WHERE id={$uid}"); $result2 = mysqli_fetch_array($res2); $reputt = do_sqlquery("SELECT * FROM {$TABLE_PREFIX}users_level WHERE id_level =" . $result2['id_level']); $setrept = mysqli_fetch_array($reputt); $name = stripslashes($setrept[prefixcolor]) . $result2[username] . stripslashes($setrept[suffixcolor]); $date = mysqli_result($result, $i, "date"); $hash_info = mysqli_result($result, $i, "info_hash"); $res3 = do_sqlquery("SELECT filename,external from {$TABLE_PREFIX}files WHERE info_hash='" . $hash_info . "'"); $result3 = mysqli_fetch_array($res3); $fname = $result3["filename"]; if ($result3["external"] == 'yes') { $fname = "{$fname} <font color =red>(EXT)</font>"; } $damn = sql_timestamp_to_unix_timestamp($date); $pretty1 = get_elapsed_time($damn); $pos = strpos($pretty1, ","); $pretty = substr($pretty1, 0, $pos); $pretty = $pretty1; $weeks = "week"; $rep = "w"; if (strpos($pretty, "week") == true) { $prettynew = str_replace($weeks, $rep, $pretty); } if (strpos($pretty, "day") == true) { $prettynew = str_replace("day", "d", $pretty); } if (strpos($pretty, "hour") == true) { $prettynew = str_replace("hour", "h", $pretty); }
} elseif ($pollid) { header("Location: {$BASEURL}/polls.php#{$pollid}"); } else { header("Location: {$BASEURL}"); } die; } stdhead(); if ($pollid) { print "<h1>Edit poll</h1>"; } else { // Warn if current poll is less than 3 days old $res = sql_query("SELECT question,added FROM polls ORDER BY added DESC LIMIT 1") or sqlerr(); $arr = mysql_fetch_assoc($res); if ($arr) { $hours = floor((gmtime() - sql_timestamp_to_unix_timestamp($arr["added"])) / 3600); $days = floor($hours / 24); if ($days < 3) { $hours -= $days * 24; if ($days) { $t = "{$days} day" . ($days > 1 ? "s" : ""); } else { $t = "{$hours} hour" . ($hours > 1 ? "s" : ""); } print "<p><font color=red><b>Note: The current poll (<i>" . $arr["question"] . "</i>) is only {$t} old.</b></font></p>"; } } print "<h1>Make poll</h1>"; } ?>
} else { ?> <html><head><link rel="stylesheet" href="<?php echo $DEFAULTBASEURL; ?> /default.css" type="text/css" media="screen" /></head><body> <table width='100%' cellpadding='5' border="1"> <tr align="center"> <td>File Name</td> <td nowrap="nowrap" >Downloaded by</td> <td>Downloads</td> <td>Date</td> </tr><?php $dls = 0; while ($arr = mysql_fetch_assoc($res)) { echo "<tr align='center'>" . "<td>" . safeChar($arr['filename']) . "</td>" . "<td><a class='pointer' onclick=\"opener.location=('/userdetails.php?id=" . (int) $arr['userid'] . "'); self.close();\">" . safeChar($arr['username']) . "</a></td>" . "<td>" . (int) $arr['downloads'] . "</td>" . "<td>" . $arr['date'] . " (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($arr['date'])) . ")</td>" . "</tr>"; $dls += (int) $arr['downloads']; } ?> <tr><td colspan='4'><b>Total Downloads:</b> <b><?php echo number_format($dls); ?> </b></td></tr></table></body></html><?php } } else { if ($action == "viewforum") { // -------- Action: View forum $forumid = (int) $_GET['forumid']; if (!is_valid_id($forumid)) { stderr('Error', 'Invalid ID!'); }
} else { $star = ""; } // get warned if ($warned == "yes") { $klicaj = "<img src=pic/warned8.gif>"; } else { $klicaj = ""; } $counter = $i + 1; echo "<tr>"; echo "<td align=center>{$counter}.</td>"; echo "<td><a href=/userdetails.php?id={$id}>{$username}</a> {$star} {$klicaj}</td>"; echo "<td>{$uploaded} / {$downloaded}</td>"; echo "<td>{$ratio}</td>"; echo "<td>{$numtorrents} torrents</td>"; if ($numtorrents > 0) { $lastadded = mysql_result($upperresult, $numtorrents - 1, "added"); echo "<td>" . get_elapsed_time(sql_timestamp_to_unix_timestamp($lastadded)) . " ago (" . gmdate("d. M Y", strtotime($lastadded)) . ")</td>"; } else { echo "<td>---</td>"; } echo "<td align=center><a href=sendmessage.php?receiver={$id}><img src=pic/pm.gif></a></td>"; echo "</tr>"; } echo "</table>"; } } else { echo "Not permitted."; } stdfoot();
print "<h1>Previous polls</h1>"; 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 "<p><table width=750 border=1 cellspacing=0 cellpadding=10><tr><td align=center>\n"; print "<p class=sub>"; $added = gmdate("Y-m-d", strtotime($poll['added'])) . " GMT (" . get_elapsed_time(sql_timestamp_to_unix_timestamp($poll["added"])) . " ago)"; print "{$added}"; if (get_user_class() >= UC_ADMINISTRATOR) { print " - [<a href=makepoll.php?action=edit&pollid={$poll['id']}><b>Edit</b></a>]\n"; print " - [<a href=?action=delete&pollid={$poll['id']}><b>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 = mysql_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"))
print "<h2 align=left><a name=\"friends\">" . $user['username'] . " has " . $fcount . " Friend " . ($fcount > 1 ? "s" : "") . "</a></h2>\n"; print "<table width=737 border=1 cellspacing=0 cellpadding=5><tr><td>"; $i = 0; $res = mysql_query("SELECT f.friendid as id, u.username AS name, u.class, u.avatar, u.title, u.donor, u.warned, u.enabled, u.last_access FROM friends AS f LEFT JOIN users as u ON f.friendid = u.id WHERE userid={$userid} AND f.confirmed='yes' ORDER BY name") or sqlerr(__FILE__, __LINE__); if (mysql_num_rows($res) == 0) { $friends = "<em>" . $user['username'] . " has no friends.</em>"; } else { while ($friend = mysql_fetch_array($res)) { $pm_pic = "<img src=" . $pic_base_url . "button_pm.gif alt='Send PM' border=0>"; $dt = gmtime() - 180; $online = $friend["last_access"] >= '' . get_date_time($dt) . '' ? ' <img src=' . $pic_base_url . 'user_online.gif border=0 alt=Online>' : '<img src=' . $pic_base_url . 'user_offline.gif border=0 alt=Offline>'; $title = htmlspecialchars($friend["title"]); if (!$title) { $title = get_user_class_name($friend["class"]); } $body1 = "<a href=userdetails.php?id=" . $friend['id'] . "><b>" . $friend['name'] . "</b></a>" . get_user_icons($friend) . " ({$title}) {$online}<br /><br />last seen on " . $friend['last_access'] . "<br />(" . get_elapsed_time(sql_timestamp_to_unix_timestamp($friend['last_access'])) . " ago)"; $body2 = $id == $CURUSER['id'] ? "" : "<br /><a href=friends.php?id={$CURUSER['id']}&action=add&type=friend&targetid=" . $friend['id'] . ">Add Friend</a>" . "<br /><br /><a href=sendmessage.php?receiver=" . $friend['id'] . ">" . $pm_pic . "</a>"; $avatar = $CURUSER["avatars"] == "yes" ? htmlspecialchars($friend["avatar"]) : ""; // if (!$avatar) // $avatar = "".$pic_base_url."default_avatar.gif"; if ($i % 2 == 0) { print "<table width=737 style='padding: 0px'><tr><td class=bottom style='padding: 5px' width=50% align=center>"; } else { print "<td class=bottom style='padding: 5px' width=50% align=center>"; } print "<table class=main width=737 height=75px>"; print "<tr valign=top><td width=75 align=center style='padding: 0px'>" . ($avatar ? "<div style='width:75px;height:75px;overflow: hidden'><img width=75px src=\"{$avatar}\"></div>" : "") . "</td><td>\n"; print "<table class=main>"; print "<tr><td class=embedded style='padding: 5px' width=737>{$body1}</td>\n"; print "<td class=embedded style='padding: 5px' width=20%>{$body2}</td></tr>\n"; print "</table>";
print("<table width=750 border=1 cellspacing=0 cellpadding=5><tr class=tablea><td>"); $i = 0; $friendadd = mysql_query("SELECT f.userid AS fuid, u.username AS name, u.id AS uid, u.class, u.avatar, u.title, u.donor, u.warned, u.enabled, u.last_access FROM friends AS f LEFT JOIN users AS u ON f.userid = u.id WHERE friendid = $CURUSER[id] ORDER BY name") or sqlerr(__FILE__, __LINE__); if(mysql_num_rows($friendadd) == 0) $friendsno = "<em>Engir vinir enn þá</em>"; else while ($friend = mysql_fetch_array($friendadd)) { $title = $friend["title"]; if (!$title) $title = get_user_class_name($friend["class"]); $body1 = "<a href=userdetails.php?id=" . $friend['fuid'] . "><b>" . $friend['name'] . "</b></a>" . get_user_icons($friend) . " ($title)<br><br>Sást síðast " . $friend['last_access'] . "<br>(" . get_elapsed_time(sql_timestamp_to_unix_timestamp($friend[last_access])) . " síðan)"; $body2 = "<br><a href=sendmessage.php?receiver=" . $friend['fuid'] . ">Senda einkaskilaboð</a>"; $avatar = ($CURUSER["avatars"] == "yes" ? htmlspecialchars($friend["avatar"]) : ""); if (!$avatar) $avatar = "/pic/default_avatar.gif"; if ($i % 2 == 0) print("<table width=100% style='padding: 0px'><tr><td class=bottom style='padding: 5px' width=50% align=center>"); else print("<td class=bottom style='padding: 5px' width=50% align=center class=tablea>"); print("<table class=main width=100% height=75px class=tablea>"); print("<tr valign=top class=tableb><td width=75 align=center style='padding: 0px'>" . ($avatar ? "<div style='width:75px;height:75px;overflow: hidden'><img width=75px src=\"$avatar\"></div>" : ""). "</td><td>\n"); print("<table class=main>"); print("<tr bgcolor=#BECDD8><td class=embedded style='padding: 5px' width=80%>$body1</td>\n"); print("<td class=embedded style='padding: 5px' width=20%>$body2</td></tr>\n"); print("</table>");
function sql_ts_to_ut($s) { return sql_timestamp_to_unix_timestamp($s); }
$seedbox[$i]["sw12"] = "<tr>"; if (strlen($data["hash"]) > 0) { $seedbox[$i]["sw13"] = "<td NOWRAP align=center class=lista>"; $seedbox[$i]["sw14"] = "<a href=download.php?id=" . $data["hash"] . "><center><img src='images/download.gif' border='0' alt='" . $language["DOWNLOAD_TORRENT"] . "' title='" . $language["DOWNLOAD_TORRENT"] . "' /></center></a>"; //waitingtime if (max(0, $CURUSER["WT"]) > 0) { $resuser = do_sqlquery("SELECT * FROM {$TABLE_PREFIX}users WHERE id=" . $CURUSER["uid"]); $rowuser = mysqli_fetch_array($resuser); if (max(0, $rowuser['downloaded']) > 0) { $ratio = number_format($rowuser['uploaded'] / $rowuser['downloaded'], 2); } else { $ratio = 0.0; } $res2 = do_sqlquery("SELECT * FROM {$TABLE_PREFIX}files WHERE info_hash='" . $data["hash"] . "'"); $added = mysqli_fetch_array($res2); $vz = sql_timestamp_to_unix_timestamp($added["data"]); $timer = floor((time() - $vz) / 3600); if ($ratio < 1.0 && $rowuser['id'] != $added["uploader"]) { $wait = $CURUSER["WT"]; } $wait -= $timer; if ($wait <= 0) { $wait = 0; } } //end waitingtime $id = mysqli_query($GLOBALS["___mysqli_ston"], "select username,id_level FROM {$TABLE_PREFIX}users WHERE id =" . $data["uploader"]); $rowt = mysqli_fetch_array($id); $idi = mysqli_query($GLOBALS["___mysqli_ston"], "select prefixcolor, suffixcolor FROM {$TABLE_PREFIX}users_level WHERE id =" . $rowt["id_level"]); $rowti = mysqli_fetch_array($idi); $seedbox[$i]["sw15"] = "</td>";