View Single Post
  #10  
Old 11th February 2012, 00:01
joeroberts's Avatar
joeroberts joeroberts is offline
BT.Manager Owner
 
Join Date: Jan 2008
United States
Posts: 2,113
Default
try this one
HTML 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 id="vmarquee" style="position: absolute; width: 98%;">
    <!--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