Esempio n. 1
0
 /**
  * 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;
 }
Esempio n. 2
0
<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>
Esempio n. 3
0
    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>
Esempio n. 4
0
                </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 
Esempio n. 5
0
 * @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);
        ?>
Esempio n. 6
0
 $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 {
Esempio n. 7
0
     } 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 .= "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
 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>";
     ?>
Esempio n. 8
0
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);
Esempio n. 9
0
    <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 
Esempio n. 10
0
            </td>
            <td class="" align="center">
                <a href="<?php 
echo page("torrent", "browse", "", "", "", "{$oldlink}sort=leechers&amp;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 
Esempio n. 11
0
 $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";