/** * Load notifications * @param type $limit */ function load($limit = 5) { $db = new DB("notifications"); $db->setColPrefix("notification_"); $db->setSort("notification_added DESC"); if (intval($limit)) { $db->setLimit($limit); } $db->select("notification_user = '******'"); if ($db->numRows()) { $return = ""; while ($db->nextRecord()) { $return .= "<li>"; switch ($db->type) { case 'friend': $data = json_decode($db->data); $user = new Acl($data->user); switch ($data->type) { case 'accept': $return .= "<b><a href='" . page("profile", "view", $user->name) . "'>" . $user->name . "</a></b> <small>" . get_date($db->added) . "</small> <br /> " . _t("Has accepted your friend request"); break; case 'decline': $return .= "<b><a href='" . page("profile", "view", $user->name) . "'>" . $user->name . "</a></b> <small>" . get_date($db->added) . "</small> <br /> " . _t("Has declined your friend request"); break; case 'remove': $return .= "<b><a href='" . page("profile", "view", $user->name) . "'>" . $user->name . "</a></b> <small>" . get_date($db->added) . "</small> <br /> " . _t("Has removed you from his friends list"); break; } break; case 'system': $data = json_decode($db->data); $group = new DB("groups"); $group->setColPrefix("group_"); $group->select("group_id = '" . $data->group . "'"); $group->nextRecord(); switch ($data->type) { case 'upgrade': $return .= _t("You have been upgraded to ") . "<b>" . $group->name . "</b><br /><small>" . get_date($db->added) . "</small>"; break; case 'downgrade': $return .= _t("You have been demoted to ") . "<b>" . $group->name . "</b><br /><small>" . get_date($db->added) . "</small>"; break; } break; } $return .= "</li>"; } } else { $return = "<li>" . _t("No notifications found") . "</li>"; } echo $return; }
<h4><?php echo _t("Forum activites"); ?> </h4> <table width="100%"> <?php $acl = new Acl(USER_ID); $db = new DB("forum_posts"); $db->setCols(array("DISTINCT topic_id", "post_user", "post_added", "topic_id", "topic_subject", "post_id")); $db->join("left", "{PREFIX}forum_topics", "topic_id", "post_topic"); $db->join("left", "{PREFIX}forum_forums", "forum_id", "topic_forum"); $db->setLimit("5"); $db->setSort("post_id DESC"); $db->select("forum_group <= '" . $acl->group . "' GROUP BY topic_id"); while ($db->nextRecord()) { $user = new Acl($db->post_user); echo "<tr><td class='border-bottom'>\n <a href='" . page("profile", "view", $user->name) . "'><strong>" . $user->name . "</strong></a> " . _t("wrote in") . " \n <a href='" . page("forums", "view-topic", $db->topic_subject . "-" . $db->topic_id, "", "", "page=p" . $db->post_id . "#post" . $db->post_id) . "'>" . $db->topic_subject . "</a>\n <br />" . get_date($db->post_added) . "</td></tr>"; } ?> </table>
echo page("admin", "members", "log", $acl->name); ?> "><?php echo _t("View full log"); ?> </a> </form> </td> </tr> <tr> <td> <?php $db = new DB("users_log"); $db->setColPrefix("log_"); $db->setSort("log_added DESC"); $db->setLimit(10); $db->select("log_user = '******'"); if ($db->numRows()) { while ($db->nextRecord()) { $user = new Acl($db->poster); ?> <div style="border-bottom: 1px solid #ddd; float:left; width: 100%;"> <div style="float:left; padding: 3px;"> <a href="<?php echo page("profile", "view", $user->name); ?> "><?php echo $user->name; ?> </a> - </div>
</thead> <tbody> <?php $forums = new DB("forum_forums"); $forums->setColPrefix("forum_"); $forums->setSort("forum_sort ASC"); $forums->select("forum_group <= " . $acl->group . " AND forum_category = '" . $forum_cat->id . "'"); while ($forums->nextRecord()) { $db = new DB(); $db->query("SELECT COUNT(topic_id) as topics FROM {PREFIX}forum_topics WHERE topic_forum = '" . $forums->id . "'"); $db->nextRecord(); $topics = $db->topics; $db = new DB("forum_topics"); $db->join("left", "{PREFIX}forum_posts", "topic_id", "post_topic"); $db->setSort("post_added DESC"); $db->setLimit("1"); $db->select("topic_forum = '" . $forums->id . "'"); if (!$db->numRows()) { $last_post = "--"; } else { $db->nextRecord(); $user = new Acl($db->post_user); $last_post = _t("By") . " <a href='" . page("profile", "view", strtolower($user->name)) . "'>" . $user->name . "</a> in " . $db->topic_subject . "<br />" . get_date($db->post_added); } ?> <tr id="forum_<?php echo $forums->id; ?> "> <td class="border-bottom" align="center"><img src="images/forum/forum-default.png"></td> <td class="border-bottom"><a href="<?php
* @package openTracker */ if (!defined("INCLUDED")) { die("Access denied"); } ?> <h4><?php echo _t("Latest Torrents"); ?> </h4> <?php $db = new DB("torrents"); $db->setSort("torrent_added DESC"); $db->setLimit("6"); $db->select("torrent_visible = '1'"); if ($db->numRows()) { ?> <table width="100%"> <?php while ($db->nextRecord()) { ?> <tr> <td> <a href="<?php echo page("torrent", "details", "", "", "", "id=" . $db->torrent_id); ?> "><?php echo trimstr($db->torrent_name, 37); ?>
$db = new DB("forum_topics"); $db->setColPrefix("topic_"); $db->join("left", "{PREFIX}forum_posts", "post_topic", "topic_id"); $db->setSort("topic_sticky DESC, post_added DESC"); $db->setLimit($pager->limit); $db->select("topic_forum = '" . $db->escape($id) . "' GROUP BY post_topic"); while ($db->nextRecord()) { $user = new Acl($db->userid); $q = new DB(); $q->query("SELECT COUNT(post_id) as posts FROM {PREFIX}forum_posts WHERE post_topic = '" . $db->id . "'"); $q->nextRecord(); $posts = $q->posts - 1; $q = new DB("forum_topics"); $q->join("left", "{PREFIX}forum_posts", "topic_id", "post_topic"); $q->setSort("post_added DESC"); $q->setLimit("1"); $q->select("topic_id= '" . $db->id . "'"); $r = new DB("forum_postread"); $r->setColPrefix("post_"); $r->select("post_userid = '" . USER_ID . "' AND post_topicid = " . $db->id); if ($r->numRows()) { $r->nextRecord(); $last = $r->lastpostread; } else { $last = 0; } $q->nextRecord(); $new = $q->post_id > $last ? true : false; if (!$db->numRows()) { $last_post = "--"; } else {
} else { $pagemenu .= "<a href='" . page("forums", "view-topic", $this->args['var_a'], "", "", "page={$i}") . "'>{$i}</a>\n"; } } if ($page == 1) { $pagemenu .= "<br /><font class='gray'>" . _t("Prev") . "</font>"; } else { $pagemenu .= "<br /><a href='" . page("forums", "view-topic", $this->args['var_a'], "", "", "page=" . ($page - 1)) . "'>" . _t("Prev") . "</a>"; } $pagemenu .= " "; if ($page == $pages) { $pagemenu .= "<font class='gray'>" . _t("Next") . "</font></p>\n"; } else { $pagemenu .= "<a href='" . page("forums", "view-topic", $this->args['var_a'], "", "", "page=" . ($page + 1)) . "'>" . _t("Next") . "</a></p>\n"; } $db->setLimit("{$offset},{$perpage}"); $db->select("post_topic = " . $db->escape($id)); $i = 1; echo $pagemenu; while ($db->nextRecord()) { $user = new Acl($db->post_user); $edit = false; if ($acl->id == $user->id) { $edit = true; } if ($acl->Access("x")) { $edit = true; } $time = time() - 300; $online = $user->last_access < $time ? _t("Online") . " " . get_date($user->last_access) : "<b><font color='green'>Online</font></b>"; ?>
echo _t("Uploaded"); ?> </b> </td> <td class="border-right border-bottom" align="center"> <b><img src="images/icons/down.gif" title="leechers"></b> </td> <td class="border-bottom" align="center"> <b><img src="images/icons/up.gif" title="seeders"></b> </td> </tr> </thead> <tbody> <?php $db = new DB("torrents"); $db->setLimit($pager['limit']); $db->setSort("torrent_added DESC"); $db->select(implode(" AND ", $where) . ""); while ($db->nextRecord()) { $torrent = new Torrent($db->torrent_id); ?> <tr> <td class="border-bottom"> <img src="images/categories/<?php echo $torrent->category(); ?> " /> </td> <td width="50%" class="border-bottom"> <a href="<?php echo page("torrent", "details", "", "", "", "id=" . $db->torrent_id);
<tbody> <?php $db = new DB("support"); $db->select("ticket_user = '******'"); while ($db->nextRecord()) { switch ($db->ticket_status) { default: $status = "<font color='red'>" . _t("Unsolved") . "</font>"; break; case 1: $status = "<font color='green'>" . _t("Solved") . "</font>"; break; } $last = new DB("support_messages"); $last->setSort("message_added DESC"); $last->setLimit(1); $last->select("message_ticket = '" . $db->escape($db->ticket_id) . "'"); $last->nextRecord(); $last_user = new Acl($last->message_user); $user = new Acl($db->ticket_user); ?> <tr> <td class="border-bottom"><a href="<?php echo page("support", "view", "", "", "", "ticket=" . $db->ticket_id); ?> "><?php echo htmlformat($db->ticket_subject); ?> </td> <td class="border-bottom border-right"></td> <td class="border-bottom border-right"><?php
</td> <td class="" align="center"> <a href="<?php echo page("torrent", "browse", "", "", "", "{$oldlink}sort=leechers&type={$order_link}"); ?> "><b><img src="images/icons/down.gif" title="leechers"></b></a> </td> <td class="" align="center"> <b>Uploader</b> </td> </tr> </thead> <tbody> <?php $db = new DB("torrents"); $db->setLimit($pager->limit); $db->setSort($orderby); $db->select(implode(" AND ", $where) . ""); while ($db->nextRecord()) { $user = new Acl($db->torrent_userid); $torrent = new Torrent($db->torrent_id); ?> <tr> <td class=""> <img src="images/categories/<?php echo $torrent->category(); ?> " /> </td> <td width="50%" class=""> <a href="<?php
$torrent->setCols($torrent_cols); $torrent->setColPrefix("torrent_"); $torrent->select("torrent_info_hash = '" . $data['info_hash'] . "'"); if (!$torrent->numRows()) { throw new Exception("Error 4: Torrent not found!"); } $torrent->nextRecord(); $torrent_id = $torrent->id; $callback[] = "d" . benc_str("interval") . "i" . 60 * 30 . "e" . benc_str("peers") . "l"; $totpeers = $torrent->seeders + $torrent->leechers; $peer = new DB("peers"); $peer->setCols($peer_cols); $peer->setColPrefix("peer_"); if ($totpeers > $readsize) { $peer->setSort("RAND()"); $peer->setLimit($readsize); } $peer->select("peer_torrent = '" . $torrent->id . "'"); while ($peer->nextRecord()) { $peer->peer_id = str_pad($peer->peer_id, 20); if ($peer->peer_id === $data['peer_id']) { $self = $peer; continue; } $callback[] = "d" . benc_str("ip") . benc_str($peer->ip); if (!$_GET['no_peer_id']) { $callback[] = benc_str("peer id") . benc_str($peer->peer_id); } $callback[] = benc_str("port") . "i" . $peer->port . "e" . "e"; } $callback[] = "ee";