Bravo List

Bravo List (http://www.bvlist.com/index.php)
-   BT.Manager (phpMyBitTorrent) (http://www.bvlist.com/forumdisplay.php?f=23)
-   -   xbTiT Latest torrents mod for pmbt? (http://www.bvlist.com/showthread.php?t=8226)

Giorgatzelos 25th August 2012 21:57
xbTiT Latest torrents mod for pmbt?
 
i found this latest torrent function from xbtit...can it be ported to pmbt? http://www.bvlist.com/attachment.php...4&d=1294264579

joeroberts 25th August 2012 23:47
you can find one like that here
https://www.phpmybittorrent.com/foru...&start=0&rid=6

Giorgatzelos 27th August 2012 12:20
i did exactly what the link you gave me says but i get this error:

Code:
SQL Error
Σφάλμα κατά την εκτέλεση SQL Αιτήματος /home/a8696442/public_html/blocks/latestimages_block.php
Σφάλμα ID: 1054
Σφάλμα Μηνύματος: Unknown column 'torrent_torrents.screen1' in 'field list'

joeroberts 27th August 2012 13:34
can you please put that in English?

did you run this sql query in your data base?
Code:
ALTER TABLE `torrent_torrents` ADD `post_img` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL AFTER `descr` , ADD `screen1` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL AFTER `post_img` , ADD `screen2` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL AFTER `screen1` , ADD `screen3` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL AFTER `screen2` , ADD `screen4` TEXT CHARACTER SET utf8 COLLATE utf8_bin NULL AFTER `screen3` ;

Giorgatzelos 27th August 2012 13:54
Yes i did run the sql command and everything seems to bee ok with the database...i thought you will get the point no matter part of it was in greek...




Quote:
SQL Error
Σφάλμα κατά την εκτέλεση SQL Αιτήματος /home/a8696442/public_html/blocks/latestimages_block.php
Σφάλμα ID: 1054
Σφάλμα Μηνύματος: Unknown column 'torrent_torrents.screen1' in 'field list'
this message is what i get when i paste:

Quote:
if ($user->user) {
include("blocks/latestimages_block.php");
}

in my index.php edited for horizontal show of the latest torrents....

joeroberts 27th August 2012 13:58
can you check your data base and make sure the rows are screen1 screen2 screen3 screen4 and not screan1..4

Giorgatzelos 27th August 2012 14:11
1 Attachment(s)
This is what i have....

joeroberts 27th August 2012 14:21
You must have gotten to the code before I changed it because everyone was
complaining about the fact screans was miss spelled so I fixed it to be screens
can you please update your data base and files?

Giorgatzelos 27th August 2012 14:27
1 Attachment(s)
It always is a typo! :suicide:

:lol:

Thank you...but i still get an error...how can i correct it or remove the hover functions when i take my mouse over the picture?

i believe these are the lines that are responsible:

Code:
            $img1 = "\"$altname

screen Shots:

', CENTER, HEIGHT, 250, WIDTH, 300);\" onmouseout=\"return nd();\">S $seed and L $leech ";
                        $img2 = "\"$altname

screen Shots:

Sorry no screens available
', CENTER, HEIGHT, 250, WIDTH, 300);\" onmouseout=\"return nd();\">S $seed and L $leech ";

joeroberts 28th August 2012 03:15
the hover is not ment to show if there is no screen shots I well take a look and see if I can fix it.

Giorgatzelos 28th August 2012 03:26
nevermind i removed it so it doesnt show...i have an othe issue though...the glossy effect mod at the poster doesn't work, it shows just my picture...idid everything the glossy effect mod said but nothing...wasn't it supposed to work with this mod too?

joeroberts 28th August 2012 03:48
I my self don't know anything about the glossy mod so could not say for sure.

Giorgatzelos 28th August 2012 04:15
ok...one more thing why the picture hides before it should...horizontal right to left...not as the youtube video that hides bit by bit at the end?and if set border the border is way too big horizontal?
i did kinda fix it but i had to set marging or padding to 200...

joeroberts 28th August 2012 06:11
can you please post the code your using for latestimages_block.php so I can look at it?

Giorgatzelos 28th August 2012 13:46
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><a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" height='120' width='180' ></a><font color=\"green\"><b>Τροφοδότες</font> $seed</b>  <font color=\"red\"><b>Αποδέκτες</font> $leech </b><b>Σχόλια: <a href=\"details.php?id=".$row["id"].$hit."\">" . $row["comments"] . "</a></b>"; 
                        $img2 = "<b>".$row["added"]."</b><a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" height='120' width='180' ></a><font color=\"green\"><b>Τροφοδότες</font> $seed</b>  <font color=\"red\"><b>Αποδέκτες</font> $leech </b><b>Σχόλια: <a href=\"details.php?id=".$row["id"].$hit."\">" . $row["comments"] . "</a></b>"; 
            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();              
?>

joeroberts 29th August 2012 00:13
try removing the
PHP Code:
        print("</div></div>"); 
from that code see if it helps

Giorgatzelos 29th August 2012 01:05
No difference...nevermind...it works just fine as it is...
How can i add the torrent's name above the upload date?...and also add something like the news funcion you have here in bvlist above the shoutbox?just saw it!..

joeroberts 29th August 2012 01:15
for the news part you talking about the scroling banner?
try this
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'];
                $dispname = htmlspecialchars($row2["name"]);
                $dispname = str_replace("_", " ", $dispname);
                $dispname = str_replace(".", " ", $dispname);

                        $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>" . $dispname . "</b><b>".$row["added"]."</b><a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" height='120' width='180' ></a><font color=\"green\"><b>Τροφοδότες</font> $seed</b>  <font color=\"red\"><b>Αποδέκτες</font> $leech </b><b>Σχόλια: <a href=\"details.php?id=".$row["id"].$hit."\">" . $row["comments"] . "</a></b>"; 
                        $img2 = "<b>" . $dispname . "</b><b>".$row["added"]."</b><a href='$siteurl/details.php?id=$row[id]'><img border='0' src='$row[post_img]' alt=\"$altname / $cat\" height='120' width='180' ></a><font color=\"green\"><b>Τροφοδότες</font> $seed</b>  <font color=\"red\"><b>Αποδέκτες</font> $leech </b><b>Σχόλια: <a href=\"details.php?id=".$row["id"].$hit."\">" . $row["comments"] . "</a></b>"; 
            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>");
}
CloseTable();              
?>

Giorgatzelos 29th August 2012 01:39
Thank you now it works just the way i want it to...
I think yes...the thing thats scrolling right to left and talks about dropbox and megaupload in the begining...can it be done?i liked it very much...


All times are GMT +2. The time now is 06:32.

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