lmao I forgot that the body was for side bar But dont fear I know what to do
PHP Code:
OpenTable("Latest posters");
$news = $db->sql_query("SELECT id, name, added, post_img FROM ".$db_prefix."_torrents WHERE banned = 'no' AND visible='yes' ORDER BY ".$db_prefix."_torrents.id DESC LIMIT 15")or sqlerr(__FILE__, __LINE__);
if ($db->sql_numrows($news) > 0) {
print("<marquee scrollamount=\"3\" onmouseover=\"this.scrollAmount=0\" onmouseout=\"this.scrollAmount=3\" scrolldelay=\"0\" direction=\"right\"><table align=center cellpadding=0 cellspacing=0 width=100% border=0>\n<tr>\n");
while ($row2 = $db->sql_fetchrow($news)) {
$tor = $row2['0'];
$altname = $row2['1'];
$orderby = "ORDER BY ".$db_prefix."_torrents.id DESC"; //Order
$limit = "LIMIT 15"; //Limit
$where = "WHERE banned = 'no' AND visible='yes' AND ".$db_prefix."_torrents.id='$tor'";
$res = $db->sql_query("SELECT ".$db_prefix."_torrents.id, ".$db_prefix."_torrents.seeders, ".$db_prefix."_torrents.leechers, ".$db_prefix."_torrents.post_img, ".$db_prefix."_torrents.screen1, ".$db_prefix."_torrents.screen2, ".$db_prefix."_torrents.screen3, ".$db_prefix."_torrents.screen4, ".$db_prefix."_torrents.added, ".$db_prefix."_categories.name AS cat_name FROM ".$db_prefix."_torrents LEFT JOIN ".$db_prefix."_categories ON ".$db_prefix."_torrents.category = ".$db_prefix."_categories.id $where $orderby $limit")or sqlerr(__FILE__, __LINE__);
$row = $db->sql_fetchrow($res);
$cat = $row['cat_name'];
$seed =$row['seeders'];
$leech =$row['leechers'];
$simg1 = $row['screen1'];
$simg2 = $row['screen2'];
$simg3 = $row['screen3'];
$simg4 = $row['screen4'];
$show2 = ($simg2 != '')? ($simg2 != 'NULL')?"<td><img src=$simg2 width=250 border=0></td>" : '' :'';
$show3 = ($simg3 != '')? ($simg3 != 'NULL')? "<td><img src=$simg3 width=250 border=0></td>" : '' : '' ;
$show4 = ($simg4 != '')? ($simg4 != 'NULL')? "<td><img src=$simg4 width=250 border=0></td>" : '' : '' ;
$img1 = "<a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" width='130' onmouseover=\" return overlib('<center><h1><b>screen Shots:</b></h1></center><hr><table width=100%><br><tr><td><img src=$simg1 width=250 border=0></td>$show2$show3$show4</tr></table>', CENTER, HEIGHT, 250, WIDTH, 300);\" onmouseout=\"return nd();\"></a><br><font color=\"green\"><b>S</font> $seed</b> and <font color=\"red\"><b>L</font> $leech </b><br>";
$img2 = "<a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" width='130' onmouseover=\" return overlib('<center><h1><b>screen Shots:</b></h1></center><hr><table width=100%><br><br><br><br><br><tr><td><center><font color=red size=4><b>Sorry no screens available</b></font></center></td></tr></table>', CENTER, HEIGHT, 250, WIDTH, 300);\" onmouseout=\"return nd();\"></a><br><font color=\"green\"><b>S</font> $seed</b> and <font color=\"red\"><b>L</font> $leech </b><br>";
if ($row["post_img"] != ""){
if ($row["screen1"]!=''){
print("<td style=\"text-align: center;\">". $img1 ."<BR>\n</td>\n");
}else{
print("<td style=\"text-align: center;\">". $img2 ."<BR>\n</td>\n");
}
}
}
print("</tr></table></marquee>");
print("</div></div>");
}
CloseTable();
__________________
Do not ask me to help you work on your site that is not phpMyBitTorrent
Do not ask me to make a mod for any other source
Do not Ask me to setup your site.
I will no longer help you setup your site, there is a setup script if you have trouble with it post in the forum here or in
BT.Manager™ forum
My Current Demo is here
http://demo.btmanager.org/