View Single Post
  #12  
Old 11th February 2012, 00:34
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
sorry try this please.
PHP Code:
OpenTable("Latest Posters");
    ?>
<style type="text/css">

#marqueecontainer{
position: relative;
width: 180px; /*marquee width */
height: 800px; /*marquee height */
overflow: hidden;
padding: 2px;
padding-left: 4px;
}

</style>
<script type="text/javascript">
marqueeInit({
    uniqueid: 'mycrawler',
    style: {
        'padding': '5px',
        'width': '450px',
        'background': 'lightyellow',
        'border': '1px solid #CC3300'
    },
    inc: 8, //speed - pixel increment for each iteration of this marquee's movement
    mouse: 'cursor driven', //mouseover behavior ('pause' 'cursor driven' or false)
    moveatleast: 4,
    neutral: 150,
    savedirection: true
});
</script>
<div class="marquee" id="mycrawler2">
    <!--YOUR SCROLL CONTENT HERE-->
    <?php
    $news 
mysql_query("SELECT id, name, added, post_img FROM ".$db_prefix."_torrents WHERE banned = 'no' AND visible='yes' ORDER BY added DESC")or sqlerr(__FILE____LINE__);

    if (
mysql_num_rows($news) > 0) {

        print(
"<table align=center cellpadding=0 cellspacing=0 width=100% border=0>");

        while (
$row2 mysql_fetch_array($news)) {
            
$tor $row2['0'];
            
$altname $row2['1'];
            
//$date_time=get_date_time(time()-(3600*168)); // the 24 is the hours you want listed change by whatever you want
            
$orderby "ORDER BY ".$db_prefix."_torrents.added ASC"//Order
            
$where "WHERE banned = 'no' AND visible='yes' AND ".$db_prefix."_torrents.id='$tor'";

            
$res mysql_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")or sqlerr(__FILE____LINE__);
            
$row mysql_fetch_array($res);
            
$cat $row['cat_name'];
            
$seed =$row['seeders'];
            
$comments =$row['comments'];
            
$leech =$row['leechers'];
            
$added =$row['added'];

                        
/*$simg1 = $row['screen1'];
                        $simg2 = $row['screen2'];
                        $simg3 = $row['screen3'];
                        $simg4 = $row['screen4'];*/
                        
$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='200' width='160' ></a><br><font color=\"green\"><b>Seeds</font> $seed</b>  <font color=\"red\"><b>Leech</font> $leech </b><br><b>Comments: <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='200' width='160' ></a><br><font color=\"green\"><b>Seeds</font> $seed</b>  <font color=\"red\"><b>Leech</font> $leech </b><br><b>Comments: <a href=\"details.php?id=".$row["id"].$hit."\">" $row["comments"] . "</a></b><br>";
            if (
$row["post_img"] != ""){
                        if (
$row["screen1"]!=''){
                print(
"<tr><td align=center>"$img1 ."<BR></td></tr>");
                        }else{
                                print(
"<tr><td align=center>"$img2 ."<BR></td></tr>");
                         }
            }
                     
        }

        print(
"</table>");

    
//}

        
        
echo'</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/
Reply With Quote