Last 5 uploads in index?
Joe do you have the code to put the last 5 uploads in index?
|
add below where you want to show in index.php
Code:
OpenTable("last 10 uploads"); $sql = "SELECT ".$db_prefix."_torrents.*, IF(".$db_prefix."_torrents.numratings < '".$minvotes."', NULL, ROUND(".$db_prefix."_torrents.ratingsum / ".$db_prefix."_torrents.numratings, 1)) AS rating, ".$db_prefix."_categories.name AS cat_name, ".$db_prefix."_categories.image AS cat_pic, U.username, IF(U.name IS NULL, U.username, U.name) as user_name, U.level as user_level FROM ".$db_prefix."_torrents LEFT JOIN ".$db_prefix."_categories ON category = ".$db_prefix."_categories.id LEFT JOIN ".$db_prefix."_users U ON ".$db_prefix."_torrents.owner = U.id WHERE banned = 'no' AND ".$db_prefix."_torrents.password IS NULL ORDER BY ".$db_prefix."_torrents.added DESC LIMIT 10;"; $res = $db->sql_query($sql) or btsqlerror($sql); if ($db->sql_numrows($res) > 0) { torrenttable($res,"usertorrent"); } else { OpenTable2(); echo " Code:
DESC LIMIT 10 helps to search code main forum to ;) http://www.phpmybittorrent.com/forum.../399/#msg_2722 |
All times are GMT +2. The time now is 07:54. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.