add this in index.php where do you want to appear
PHP Code:
//== Start of Last X torrents with poster and marquee mod ==//
$query="SELECT id, name, poster FROM torrents WHERE poster <> '' ORDER BY added DESC LIMIT 10";
$result=mysql_query($query);$num = mysql_num_rows($result);
print("<table cellpadding=2 width=93% align=center><tr><td colspan=1 align=center>
<marquee scrollAmount=2 onmouseover=this.scrollAmount=0 onmouseout=this.scrollAmount=2 scrolldelay=50 direction=left>");
while ($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$name = $row['name'];
$poster = $row['poster'];
$name = str_replace('_', ' ' , $name);
$name = str_replace('.', ' ' , $name);
$name = substr($name, 0, 50);
if (!empty($poster)){
print("<a href=$BASEURL/details.php?id=$id title=$name><img src=$poster width=120 height=180 title=$name border=0></a>");
} else {
print("<a href=$BASEURL/details.php?id=$id title=$name><img src=pic/poster.jpg width=120 height=180 title=$name border=0></a>");
} } print("</marquee></td></tr></table>");
//== End of Last X torrents with poster and marquee mod ==//
and run this SQL query in phpmyadmin
PHP Code:
ALTER TABLE torrents ADD `poster` blob ;