G
Gemini_13
Гость
XLex, ну дык, ясен перец) у тебя же мультитрекер не стоит
$topics = DB()->fetch_rowset("
SELECT t.topic_title, t.topic_id, tp.post_text
FROM ". BB_TOPICS ." t
LEFT JOIN ". BB_FORUMS ." f ON (t.forum_id = f.forum_id)
LEFT JOIN ". BB_POSTS_TEXT ." tp ON (tp.post_id = t.topic_first_post_id)
LEFT JOIN ". BB_BT_TORRENTS ." tor ON (t.topic_id = tor.topic_id)
LEFT JOIN ". BB_BT_TRACKER_SNAP ." sn ON (t.topic_id = sn.topic_id)
WHERE t.topic_dl_type = 1
$forum_in
ORDER BY (tor.tor_seeders + IFNULL(sn.seeders, 0)) DESC
LIMIT 50
");
$topics = DB()->fetch_rowset("
SELECT t.topic_title, t.topic_id, tp.post_text
FROM ". BB_TOPICS ." t
LEFT JOIN ". BB_FORUMS ." f ON (t.forum_id = f.forum_id)
LEFT JOIN ". BB_POSTS_TEXT ." tp ON (tp.post_id = t.topic_first_post_id)
LEFT JOIN ". BB_BT_TRACKER_SNAP ." sn ON (t.topic_id = sn.topic_id)
WHERE t.topic_dl_type = 1
$forum_in
ORDER BY sn.seeders DESC
LIMIT 50
");
$forum_pron = '2161, 1533, 2051, 854, 853, 852, 2015, 851, 626, 855, 1666, 589'; // Pron форумы