View Single Post
  #15  
Old 28th August 2012, 13:46
Giorgatzelos's Avatar
Giorgatzelos Giorgatzelos is offline
Senior Member
 
Join Date: Nov 2009
Greece
Posts: 300
Default
Of course, here:
i just did cellpading 200 and it kinda works but it's 200px bigger vertically...and how can i add the torrent name above the upload date and time?
PHP Code:
<?php

if (!defined('IN_PMBT')) die ("You can't access this file directly");

OpenTable("Τελευταίες Προσθήκες:");


    
$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=\"1\" onmouseover=\"this.scrollAmount=0\" onmouseout=\"this.scrollAmount=1\" scrolldelay=\"0\" direction=\"left\"><table align=center cellpadding=200 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."_torrents.comments, ".$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'];
            
$comments =$row['comments'];
            
$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 "<b>".$row["added"]."</b><br><a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" height='120' width='180' ></a><br><font color=\"green\"><b>Τροφοδότες</font> $seed</b>  <font color=\"red\"><b>Αποδέκτες</font> $leech </b><br><b>Σχόλια: <a href=\"details.php?id=".$row["id"].$hit."\">" $row["comments"] . "</a></b><br>"
                        
$img2 "<b>".$row["added"]."</b><br><a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" height='120' width='180' ></a><br><font color=\"green\"><b>Τροφοδότες</font> $seed</b>  <font color=\"red\"><b>Αποδέκτες</font> $leech </b><br><b>Σχόλια: <a href=\"details.php?id=".$row["id"].$hit."\">" $row["comments"] . "</a></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();              
?>

Last edited by Giorgatzelos; 28th August 2012 at 14:11.
Reply With Quote