root/bookmarks.php

<?php</span>
<span class="code-lang">$root_path = './';
require ($root_path . 'include/config.php');
require ($root_path . 'include/functions_torrenttable.php');

$userdata = session_pagestart($user_ip);
init_userprefs($userdata);

loggedinorreturn();

$tor_id = request_var('torrent', 0);
$del_bookmark = request_var('delbookmark', array(''=>''));
$sort = request_var('sort', 0);
$type = request_var('type', 0);</span>
<span class="code-lang">
if ( $tor_id ) {
    $sql = 'SELECT name, category FROM ' . TORRENTS_TABLE . ' WHERE fid = ' . $tor_id;
    $result = $db->sql_query($sql);

    if ( !$row = $db->sql_fetchrow($result) ) {
        trigger_error(sprintf($lang['invalid_id'],$tor_id));
    }

    $cats = $cache->obtain_cats();
    $cat_id = $row['category'];
    $cat_parent_id = ( isset($cats[$cats[$cat_id]['cat_parent']]['cat_id']) ? $cats[$cats[$cat_id]['cat_parent']]['cat_id'] : 0 );

    // www.phpBB-SEO.com SEO TOOLKIT BEGIN
    if ( $cat_parent_id ) {
        $seo->set_url($cats[$cat_parent_id]['cat_name'], $cat_parent_id, $seo->seo_static['browse']);
        $seo->set_parent($cat_id, $seo->seo_static['browse'], $cat_parent_id, $seo->seo_static['browse']);
    }
    $seo->set_url($cats[$cat_id]['cat_name'], $cat_id, $seo->seo_static['browse']);
    $seo->set_parent($tor_id, $seo->seo_static['details'], $cat_id, $seo->seo_static['browse']);
    $seo->set_url(censor_text($row['name']), $tor_id, $seo->seo_static['details']);
    // www.phpBB-SEO.com SEO TOOLKIT END

    $url = 'details.php?id=' . $tor_id;
    meta_refresh(3, append_sid($root_path . $url));

     if ((get_row_count(BOOKMARKS_TABLE, 'WHERE userid=' . $userdata['uid'] . ' AND torrentid = ' . $tor_id)) > 0) {
         trigger_error(sprintf($lang['torrent_already_bookmarked'], $tor_id));
     }

     $sql = 'INSERT INTO ' . BOOKMARKS_TABLE . ' (userid, torrentid) VALUES (' . $userdata['uid'] . ', ' . $tor_id . ')';
     $db->sql_query($sql);

     trigger_error(sprintf($lang['torrent_bookmarked'], $tor_id));
}

if ( $del_bookmark ) {
    $ids = array();
    for ( $i = 0; $i < sizeof($del_bookmark); ++$i ) {
        $ids[] = intval($del_bookmark[$i]);
    }

    $sql = 'SELECT id FROM ' . BOOKMARKS_TABLE . ' WHERE id IN (' . implode(', ',$ids) . ') AND userid = ' . $userdata['uid'];
     $result = $db->sql_query($sql);
     if ( $row = $db->sql_fetchrow($result) ) {
         $ids = array();
         do {
             $ids[] = $row['id'];
         }
         while ( $row = $db->sql_fetchrow($result) );
         $sql = 'DELETE FROM ' . BOOKMARKS_TABLE . ' WHERE id IN (' . implode(', ', $ids) . ')';
         $db->sql_query($sql);
     }

     redirect( append_sid('bookmarks.php'));
}


if ( $sort && $type ) {
        $column = '';
        $ascdesc = '';

        switch( $sort ) {
                case 'asc': $ascdesc = 'ASC'; break;
                case 'desc': $ascdesc = 'DESC'; break;
                default: $ascdesc = 'DESC'; break;
        }

        switch( $type ) {
                case '1': $column = 't.name'; break;
                case '2': $column = 't.numfiles'; break;
                case '3': $column = 't.comments'; break;
                case '4':
                    $column = 'IF(t.numratings < ' . $config['minvotes'] . ', 0, ROUND(t.ratingsum / t.numratings, 1)) ' . $ascdesc;
                    $column .= ', t.numratings ' . $ascdesc;
                    $column .= ', t.ctime';
                break;
                case '5': $column = 't.ctime'; break;
                case '7': $column = 't.size'; break;
                case '8': $column = 't.completed'; break;
                case '9': $column = 't.seeders'; break;
                case '10': $column = 't.leechers'; break;
                case '11': $column = 'u.name'; break;
                default: $column = 't.ctime'; break;
        }

        $orderby = 'ORDER BY ' . $column . ' ' . $ascdesc;

}
else {
        $orderby = 'ORDER BY t.ctime DESC';
}

$cats = $cache->obtain_cats();

$sql = 'SELECT COUNT(id) AS count FROM ' . BOOKMARKS_TABLE . ' WHERE userid = ' . $userdata['uid'];
$result = $db->sql_query($sql);
$count = ( $row = $db->sql_fetchrow($result) ) ? intval($row['count']) : 0;
$torrentsperpage = ( !$userdata['torrentsperpage'] ? 30 : $userdata['torrentsperpage'] );</span>
<span class="code-lang">
list($pagertop, $pagerbottom, $offset, $limit) = pager($torrentsperpage, $count, 'bookmarks.php?');

$sql = 'SELECT b.id AS bookmarkid, t.fid, t.category, t.leechers, t.seeders, t.name, t.completed, t.free, t.size, t.ctime, t.comments, t.numfiles, t.filename, t.owner, t.hidden, t.numratings, t.ratingsum, t.numfiles, t.filename, t.size, t.completed, t.category, t.moderated, t.banned, u.privacy, u.parked, u.name AS username, u.title, u.class, u.donor, u.name_append, u.enabled, u.warneduntil, u.uid</span>
<span class="code-lang">        FROM ' . BOOKMARKS_TABLE . ' b, ' . TORRENTS_TABLE . ' t, ' . USERS_TABLE . ' u
        WHERE b.userid = ' . $userdata['uid'] . ' AND b.torrentid = t.fid AND t.owner = u.uid ' . $orderby;
$result = $db->sql_query_limit($sql, $limit, $offset);

$template->assign_vars(array(</span>
<span class="code-lang">        'PAGER_TOP' => $pagertop,
        'PAGER_BOTTOM' => $pagerbottom
));
$ary = array();</span>
<span class="code-lang">while ( $row = $db->sql_fetchrow($result) ) {
    $ary[] = $row;
}
$tpl = torrenttable($ary, true);</span>
<span class="code-lang">
if ( !sizeof($ary) ) {
    trigger_error($lang['you_have_no_bookmarks']);
}


stdhead($lang['bookmarks']);
$template->set_filenames(array(</span>
<span class="code-lang">        'body' => 'bookmarks.html')
);
stdfoot();
?>