This is for TBDev 2009
Example:
Uploader1 - uploads: 22
Uploader2 - uploads: 12
Uplooder3 - uploads: 9
1. Add in table users:
PHP Code:
ALTER TABLE users ADD `numero_uploads` int(10) unsigned NOT NULL default '0';
2. In takeupload.php find:
PHP Code:
mysql_query("INSERT INTO files (torrent, filename, size) VALUES ".file_list($filelist,$id));
Add below:
PHP Code:
$user123 = $CURUSER["id"]; mysql_query("UPDATE users SET numero_uploads = numero_uploads + 1 WHERE id='$user123'") or sqlerr(__FILE__, __LINE__);
3. In delete.php find:
PHP Code:
mysql_query("DELETE FROM torrents WHERE id = $id"); foreach(explode(".","peers.files.comments.ratings") as $x)
Add above:
PHP Code:
$res = mysql_query("SELECT owner FROM torrents WHERE id = $id"); $row = mysql_fetch_assoc($res); $rr = $row["owner"]; mysql_query("UPDATE users SET numero_uploads = numero_uploads - 1 WHERE id='$rr'") or sqlerr(__FILE__, __LINE__);
4. in index.php add this:
PHP Code:
$HTMLOUT .= "<table border=1 width=50% align=center><tr><td>"; $n_up = mysql_query("SELECT * FROM users ORDER BY `numero_uploads` DESC LIMIT 4") or sqlerr(); while($rank = mysql_fetch_array($n_up)){ static $contar=0; $contar++; $avatar = $rank["avatar"]; if (!$avatar) $avatar = "pic/default_avatar.png"; $HTMLOUT .= "<div> $contar - <a href=userdetails.php?id=".$rank["id"]."><img src=$avatar width=30 height=30 border=0 class=vsmall_thumb></a></div> <a href=userdetails.php?id=".$rank["id"]."><b>".$rank["username"]."</b></a> Uploads : <b>".$rank["numero_uploads"]."</b> Reputation : ".$rank["reputation"]." </div>"; } $HTMLOUT .= "</td></tr></table>";
NOTE: In query the value 4 you change for you want, if you want show 10 uploaders change for 10.
HID@tbdev.net/index.php?showtopic=22792