Bravo List - Search Engine & Recommended torrents, question

Bravo List (http://www.bvlist.com/index.php)

- Torrent Strike (http://www.bvlist.com/forumdisplay.php?f=21)

- - Search Engine & Recommended torrents, question (http://www.bvlist.com/showthread.php?t=4550)

tells me on browse.php

PHP Code:


		
			
$res1 = mysql_query("SELECT  torrents.id, torrents.size, torrents.name, torrents.filename,  torrents.poster, torrents.leechers, torrents.seeders,  torrents.times_completed, torrents.owner, users.username AS username,  users.class AS class FROM torrents INNER JOIN users ON torrents.owner =  users.id WHERE torrents.recommend='yes' ORDER BY  torrents.times_completed DESC LIMIT 3"); if (mysql_num_rows($res1) > 0) { begin_frame("Recommend Torrent",true,5); while ($arr1 = mysql_fetch_assoc($res1)) { $dispname = htmlspecialchars(trim($arr1["name"])); $count_dispname=strlen($dispname); $max_lenght_of_torrent_name="15"; // maximum lenght if($count_dispname > $max_lenght_of_torrent_name){ $short_torrent_name_alt="title=\"$dispname \""; $dispname=substr($dispname, 0, $max_lenght_of_torrent_name) . "..."; }else $short_torrent_name_alt="$dispname"; echo " 
[IMG]http://212.233.212.154/%5C%22$arr1%5Bposter%5D%5C%22[/IMG] 
$dispname

Seed ($arr1[seeders]) Leech  ($arr1[leechers]) Snatched  ($arr1[times_completed])
Size: ".mksize($arr1['size'])."
Upped by: ".$arr1['username']."
" . "Download Torrent" . "

Quote:

Nicky

code used poster or remove in query

Code:

torrents.poster,

and

Code:

in your case step 6:

Code:

$res1 = mysql_query("SELECT torrents.id, torrents.size, torrents.name, torrents.filename, torrents.leechers, torrents.seeders, torrents.times_completed, torrents.owner, users.username AS username, users.class AS class FROM torrents INNER JOIN users ON torrents.owner = users.id WHERE torrents.recommend='yes' ORDER BY torrents.times_completed DESC LIMIT 3");

Code:

$res1 = mysql_query("SELECT torrents.id, torrents.size, torrents.name, torrents.filename, , torrents.leechers, torrents.seeders, torrents.times_completed, torrents.owner, users.username AS username, users.class AS class FROM torrents INNER JOIN users ON torrents.owner = users.id WHERE torrents.recommend='yes' ORDER BY torrents.times_completed DESC LIMIT 3");

Can you explain it more easy.. (im litle indian :D)
btw i use code in takeupload.php

PHP Code:


		
			
$ret = mysql_query("INSERT INTO torrents (search_text, filename, owner, visible, info_hash, name, size, numfiles, type, descr, ori_descr, description, category, save_as, added, last_action, nfo, poster, ori_descr, recommend) VALUES (" .

error comming from this?

Well recommend must be afther type

Code:

$ret = mysql_query("INSERT INTO torrents (search_text, filename, owner, visible, info_hash, name, size, numfiles, type, recommend, descr, ori_descr, description, category, save_as, added, last_action, nfo, poster, ori_descr, recommend) VALUES (" .

If you have still problem, please explain more, what are you trying to do , whats the error, a screenshot will be nice. what version of torrentstrike are you using.

Nao works :) but when i edit torrent it dissapears and i have 2 click on recomended again (btw i use Torrentstrike Fullymodded v1.0)
http://img130.imageshack.us/img130/2050/herejq.jpg

can it be made to look like this:

http://img94.imageshack.us/img94/5015/recomendedn.jpg

Take a look in edit & takeedit maybe you do something wrong,end for screenshot 2 it looks like a normal torrent, but with some modifcation end put it on recommeded , maybe some one have the code . any way , good luck with your tracker :drink: