Poster Mod
- Автор темы Xeza
- Дата начала
S
Saint
Гость
max_well, http://torrentpier.com/threads/poster-mod.665/page-3#post-20301 не работает. 
все так же как и было.
все так же как и было.
Lange
Легенда
Конкретно как делал?Как сделать вывод в ленту случайных релизов?
Пробовал с помощью ORDER BY RAND() - не работает.
Lynx
Пользователь
$new_torrent = DB()->sql_query("SELECT t.topic_id, ph.post_html, ph.post_id, tt.topic_title, tt.topic_time, t.size, t.poster_id, u.username, u.user_id, f.forum_id, t.forum_id, f.forum_name
FROM ".BB_BT_TORRENTS." AS t,
".BB_POSTS_HTML." AS ph,
".BB_TOPICS." AS tt,
".BB_USERS." AS u,
".BB_FORUMS." AS f
WHERE ph.post_id = t.post_id
AND tt.topic_id = t.topic_id
AND tt.topic_id = t.topic_id
AND t.poster_id = u.user_id
AND t.forum_id = f.forum_id
ORDER BY RAND() LIMIT 30
");
FROM ".BB_BT_TORRENTS." AS t,
".BB_POSTS_HTML." AS ph,
".BB_TOPICS." AS tt,
".BB_USERS." AS u,
".BB_FORUMS." AS f
WHERE ph.post_id = t.post_id
AND tt.topic_id = t.topic_id
AND tt.topic_id = t.topic_id
AND t.poster_id = u.user_id
AND t.forum_id = f.forum_id
ORDER BY RAND() LIMIT 30
");
Lynx
Пользователь
drew, спасибо за подсказку! Сделал:
$new_torrent = DB()->sql_query("
SELECT COUNT(topic_id) as count FROM ". BB_BT_TORRENTS ." WHERE tor_status = ". TOR_APPROVED ." LIMIT 30");
$new_torrent = DB()->sql_query("
SELECT t.topic_id, ph.post_html, ph.post_id, tt.topic_title, tt.topic_time, t.size, t.poster_id, u.username, u.user_id, f.forum_id, t.forum_id, f.forum_name
FROM ".BB_BT_TORRENTS." AS t,
".BB_POSTS_HTML." AS ph,
".BB_TOPICS." AS tt,
".BB_USERS." AS u,
".BB_FORUMS." AS f
WHERE ph.post_id = t.post_id
AND tt.topic_id = t.topic_id
AND tt.topic_id = t.topic_id
AND t.poster_id = u.user_id
AND t.forum_id = f.forum_id
ORDER BY RAND() LIMIT 30
");
Но 2 запроса серьёзно грузят сервак, и на данном этапе ХЗ, как уменьшить нагрузку.
$new_torrent = DB()->sql_query("
SELECT COUNT(topic_id) as count FROM ". BB_BT_TORRENTS ." WHERE tor_status = ". TOR_APPROVED ." LIMIT 30");
$new_torrent = DB()->sql_query("
SELECT t.topic_id, ph.post_html, ph.post_id, tt.topic_title, tt.topic_time, t.size, t.poster_id, u.username, u.user_id, f.forum_id, t.forum_id, f.forum_name
FROM ".BB_BT_TORRENTS." AS t,
".BB_POSTS_HTML." AS ph,
".BB_TOPICS." AS tt,
".BB_USERS." AS u,
".BB_FORUMS." AS f
WHERE ph.post_id = t.post_id
AND tt.topic_id = t.topic_id
AND tt.topic_id = t.topic_id
AND t.poster_id = u.user_id
AND t.forum_id = f.forum_id
ORDER BY RAND() LIMIT 30
");
Но 2 запроса серьёзно грузят сервак, и на данном этапе ХЗ, как уменьшить нагрузку.
