Bravo List - [TSSE 5.1 Torrent moder]

Would someone contribute this to me how shall a tsse pass 5.1 on this ?

Code:



Sql



ALTER TABLE torrents ADD `ell` enum('yes','no','unnuked') character set latin1 collate latin1_general_ci NOT NULL default 'unnuked';

ALTER TABLE torrents ADD `ellkom` text character set latin1 collate latin1_general_ci NOT NULL;

ALTER TABLE torrents ADD `ellido` datetime NOT NULL default '0000-00-00 00:00:00';

ALTER TABLE torrents ADD `ellenorzo` varchar(40) character set latin1 collate latin1_general_ci NOT NULL;ALTER TABLE torrents ADD  `kep` text character set latin1 collate latin1_general_ci NOT NULL;ALTER TABLE torrents ADD  `sebb` text character set latin1 collate latin1_general_ci NOT NULL;ALTER TABLE torrents ADD  `sebb2` text character set latin1 collate latin1_general_ci NOT NULL;ALTER TABLE torrents ADD  `ido` text character set latin1 collate latin1_general_ci NOT NULL;ALTER TABLE torrents ADD  `ido2` text character set latin1 collate latin1_general_ci NOT NULL;

cut this open and look for it a details.php

search

Code:

$res = mysql_query("SELECT torrents.seeders, torrents.banned, torrents.leechers, torrents.info_hash, torrents.filename, LENGTH(torrents.nfo) AS nfosz, UNIX_TIMESTAMP() - UNIX_TIMESTAMP(torrents.last_action) AS lastseed, torrents.numratings, torrents.name, IF(torrents.numratings < $minvotes, NULL, ROUND(torrents.ratingsum / torrents.numratings, 1)) AS rating, torrents.owner, torrents.save_as, torrents.descr, torrents.visible, torrents.size, torrents.added, torrents.views, torrents.hits, torrents.times_completed, torrents.id, torrents.type, torrents.numfiles, torrents.anonymous, categories.name AS cat_name, users.username FROM torrents LEFT JOIN categories ON torrents.category = categories.id LEFT JOIN users ON torrents.owner = users.id WHERE torrents.id = $id")

    or sqlerr();

$row = mysql_fetch_array($res);

add this

Code:

torrents.ell, torrents.ellkom, torrents.ellido, torrents.ellenorzo,

look for this soon

[code]
rint("