Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   Mods & Themes (http://www.bvlist.com/forumdisplay.php?f=87)
-   -   Scroll Block (http://www.bvlist.com/showthread.php?t=4688)

matrix78 17th March 2010 07:26

Scroll Block
 
Create lastups-scroll_block.php


Code:



if ($CURUSER){
begin_block("HTk Images");

    ?>
   





   

   


   
   
    $news = mysql_query("SELECT id, name, added, image1, image2 FROM torrents WHERE banned = 'no' AND visible='yes'");

    if (mysql_num_rows($news) > 0) {

        print("");

        while ($row2 = mysql_fetch_array($news, MYSQL_NUM)) {
            $tor = $row2['0'];
            $altname = $row2['1'];
            $date_time=get_date_time(time()-(3200*25)); // the 24 is the hours you want listed change by whatever you want
            $orderby = "ORDER BY torrents.id DESC"; //Order

            $limit = "LIMIT 15"; //Limit

            $where = "WHERE banned = 'no' AND visible='yes' AND torrents.id='$tor'";

            $res = mysql_query("SELECT torrents.id, torrents.image1, torrents.image2, torrents.added, categories.name AS cat_name FROM torrents LEFT JOIN categories ON torrents.category = categories.id $where AND torrents.added >='$date_time' $orderby $limit");
            $row = mysql_fetch_array($res);
            $cat = $row['cat_name'];

            $img1 = "\"$altname";

            if ($row["image1"] != ""){
                print("");
            }
        }

        print("
". $img1 ."
");

    }
        ?>
       

       


       
end_block();
}
?>

sorry french

http://img502.imageshack.us/img502/3593/captureoy.png

Legend2000 20th May 2012 17:33

Hi,can you tell me how to make the block scroll horizontally?.Please help?:sos::sos:

gogo999 6th September 2012 00:24

hi
 
Quote:

Originally Posted by Legend2000 (Post 34868)
Hi,can you tell me how to make the block scroll horizontally?.Please help?:sos::sos:



good..... Sourcecode

08DR 25th December 2015 08:36

cheers
 
1 Attachment(s)
thanks very much for this, i have a slight problem you may be able to help me with,

my tt version is 208 afaik & running on windows wamp,

only edits ive done which started the exterior frame and the scrolling error message were changing all
the line the error is moaning about is:- if (mysql_num_rows($news) > 0) {

cheers op and subbed to thread :-)

Bump: edit, have it working now, found 2x errors,

love to have this running horizontally, any ideas or examples of existing ideas

cheers op:drink::drink:

EagleLake 6th June 2016 12:55

update
 
2 Attachment(s)
work

Bump: udate

Bump: bug fix


All times are GMT +2. The time now is 10:58.

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.