Bravo List
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Bravo List (http://www.bvlist.com/index.php)
-   Torrent Trader (http://www.bvlist.com/forumdisplay.php?f=29)
-   -   TorrentBar For TorrentTrader (http://www.bvlist.com/showthread.php?t=12409)

hon 17th August 2021 12:31
TorrentBar For TorrentTrader
 
4 Attachment(s)
Tsted on TorrentTrader-2.08-FINAL.

HOW TO INSTALL:
Just unzip the file in attachment in your site root.

URLs working:
PREWVIEW:
https://www.bvlist.com/attachment.ph...1&d=1629196279

================================================== =========================

account.php

After this line:
Code:
".T_("IP").": " . $CURUSER["ip"] . "\n"); ?>
Add this code:
Code:
"); ?>
PREVIEW:
https://www.bvlist.com/attachment.ph...1&d=1629196749

================================================== =========================

account-details.php

After this line:
Code:
Forum Posts:
Add this code:
Code:
"; ?>
PREVIEW:
https://www.bvlist.com/attachment.ph...1&d=1629197365

================================================== =========================

xblade 17th August 2021 13:01
its old time code not myqsli so how trys this on mysqli not work

hon 17th August 2021 13:08
Quote:
Originally Posted by budgie (Post 55699)
its old time code not myqsli so how trys this on mysqli not work
@budgie:

on all posts today you are saying the same thing.

bot?

papad 17th August 2021 13:12
Quote:
Originally Posted by hon (Post 55700)
@budgie:

on all posts today you are saying the same thing.

bot?
No, he is not a bot hon, it's just something to expect.

hon 17th August 2021 13:15
ok

look here this version of torrent trader working

https://www.bvlist.com/showthread.php?t=12410

xblade 17th August 2021 16:54
i beg to differ its not mysqli coding at all mysql

PHP 4.4 TESTED -- OK
PHP 5.1 TESTED -- OK
PHP 5.6 TESTED -- OK
PHP 7.1 TESTED -- OK
PHP 7.2 TESTED -- OK
PHP 7.3 TESTED -- OK

from down is mysqli

PHP 5.6 TESTED -- OK
PHP 7.1 TESTED -- OK
PHP 7.2 TESTED -- OK
PHP 7.3 TESTED -- OK

also its known in the cleanup this part not working on home torrents on mysqli and mysql

Code:
        //LOCAL TORRENTS - GET PEERS DATA AND UPDATE BROWSE STATS
        //DELETE OLD NON-ACTIVE PEERS
    $deadtime = get_date_time(gmtime() - $site_config['announce_interval']);
    SQL_Query_exec("DELETE FROM peers WHERE last_action < '$deadtime'");

        $torrents = array();
        $res = SQL_Query_exec("SELECT torrent, seeder, COUNT(*) AS c FROM peers GROUP BY torrent, seeder");
        while ($row = mysql_fetch_assoc($res)) {
                if ($row["seeder"] == "yes")
                        $key = "seeders";
                else
                        $key = "leechers";
                $torrents[$row["torrent"]][$key] = $row["c"];
        }

        $res = SQL_Query_exec("SELECT torrent, COUNT(torrent) as c FROM comments WHERE torrent > 0 GROUP BY torrent");
        while ($row = mysql_fetch_assoc($res)) {
                $torrents[$row["torrent"]]["comments"] = $row["c"];
        }

        $fields = explode(":", "comments:leechers:seeders");
        $res = SQL_Query_exec("SELECT id, external, seeders, leechers, comments FROM torrents WHERE banned = 'no'");
        while ($row = mysql_fetch_assoc($res)) {
                $id = $row["id"];
                $torr = $torrents[$id];
                foreach ($fields as $field) {
                        if (!isset($torr[$field]))
                                $torr[$field] = 0;
                }
                $update = array();
                foreach ($fields as $field) {
                        if ($row["external"] == "no" || $field == "comments") {
                                if ($torr[$field] != $row[$field])
                                        $update[] = "$field = " . $torr[$field];
                        }
                }
                if (count($update))
                        SQL_Query_exec("UPDATE torrents SET " . implode(",", $update) . " WHERE id = $id");
        }
basically it telling the database the update is locking the torrent table up till clean up done there be no home nor seedbox working torrents

hon 17th August 2021 19:37
Quote:
Originally Posted by budgie (Post 55705)
i beg to differ its not mysqli coding at all mysql

PHP 4.4 TESTED -- OK
PHP 5.1 TESTED -- OK
PHP 5.6 TESTED -- OK
PHP 7.1 TESTED -- OK
PHP 7.2 TESTED -- OK
PHP 7.3 TESTED -- OK

from down is mysqli

PHP 5.6 TESTED -- OK
PHP 7.1 TESTED -- OK
PHP 7.2 TESTED -- OK
PHP 7.3 TESTED -- OK

also its known in the cleanup this part not working on home torrents on mysqli and mysql

Code:
        //LOCAL TORRENTS - GET PEERS DATA AND UPDATE BROWSE STATS
        //DELETE OLD NON-ACTIVE PEERS
    $deadtime = get_date_time(gmtime() - $site_config['announce_interval']);
    SQL_Query_exec("DELETE FROM peers WHERE last_action < '$deadtime'");

        $torrents = array();
        $res = SQL_Query_exec("SELECT torrent, seeder, COUNT(*) AS c FROM peers GROUP BY torrent, seeder");
        while ($row = mysql_fetch_assoc($res)) {
                if ($row["seeder"] == "yes")
                        $key = "seeders";
                else
                        $key = "leechers";
                $torrents[$row["torrent"]][$key] = $row["c"];
        }

        $res = SQL_Query_exec("SELECT torrent, COUNT(torrent) as c FROM comments WHERE torrent > 0 GROUP BY torrent");
        while ($row = mysql_fetch_assoc($res)) {
                $torrents[$row["torrent"]]["comments"] = $row["c"];
        }

        $fields = explode(":", "comments:leechers:seeders");
        $res = SQL_Query_exec("SELECT id, external, seeders, leechers, comments FROM torrents WHERE banned = 'no'");
        while ($row = mysql_fetch_assoc($res)) {
                $id = $row["id"];
                $torr = $torrents[$id];
                foreach ($fields as $field) {
                        if (!isset($torr[$field]))
                                $torr[$field] = 0;
                }
                $update = array();
                foreach ($fields as $field) {
                        if ($row["external"] == "no" || $field == "comments") {
                                if ($torr[$field] != $row[$field])
                                        $update[] = "$field = " . $torr[$field];
                        }
                }
                if (count($update))
                        SQL_Query_exec("UPDATE torrents SET " . implode(",", $update) . " WHERE id = $id");
        }
basically it telling the database the update is locking the torrent table up till clean up done there be no home nor seedbox working torrents

It's MySQL and not MySQLi but working on all php versions if you want I can send you and the MySQLi version but versions before php 5.6 won't work.

xblade 17th August 2021 19:45
yep send me it love to check it put

hon 17th August 2021 19:57
2 Attachment(s)
Quote:
Originally Posted by budgie (Post 55707)
yep send me it love to check it put
MySQLi File in attachment:)
Just replace MySQL.class.php and functions.php in backend folder

Bump:

xblade 17th August 2021 20:04
Code:
//
//  TorrentTrader v2.x
//  MySQL wrapper
//  Author: TorrentialStorm
//
//    $LastChangedDate: 2012-08-11 11:34:43 +0100 (Sat, 11 Aug 2012) $
//
//    http://www.torrenttrader.org
##    Modified by hon and changed from MySQL to MySQLi
//
//

function &SQL_Query ($query) {
        return new SQL_Query ($query);
}

function &SQL_Query_exec ($query) {
        $sql = new SQL_Query ($query);
        return $sql->execute();
}

class SQL_Query {
        private $query = "";
        private $params = array();

        function &__construct ($query) {
                $this->query = $query;
                return $this;
        }

        function &p ($param) {
                if (is_numeric($param)) {
                        $this->params[] = $param;
                } elseif (is_array($param)) {
                        $this->params[] = implode(", ", array_map(array(&$this, "escape"), $param));
                } else {
                        $this->params[] = $this->escape($param);
                }
                return $this;
        }

        function &p_name ($param) {
                $this->params[] = "`".$mysqli->real_escape_string($param)."`";
                return $this;
        }

        function escape ($s) {
                if (is_numeric($s))
                        return $s;
                return "'".$mysqli->real_escape_string($s)."'";
        }

        function read () {
                $ret = "";
                if (count($this->params)) {
                        reset($this->params);
                        for ($i = 0; $i < strlen($this->query); $i++) {
                                if ($this->query[$i] == "?") {
                                        list(, $val) = each($this->params);
                                        $ret .= $val;
                                } else {
                                        $ret .= $this->query[$i];
                                }
                        }
                        reset($this->params);
                } else {
                        $ret = $this->query;
                }
                return $ret;
        }

        function &execute () {
                $query = $this->read();
                $res = $mysqli->query($query);

                if ($res || $mysqli->errno == 1062) {
                        return $res;
                }
                $mysql_error = $mysqli->error;
                $mysql_errno = $mysqli->errno;

                // If debug_backtrace() is available, we can find exactly where the query was called from
                if (function_exists("debug_backtrace")) {
                        $bt = debug_backtrace();

                        $i = 1;

                        if ($bt[$i]["function"] == "SQL_Query_exec_cached" || $bt[$i]["function"] == "get_row_count_cached" || $bt[$i]["function"] == "get_row_count")
                                $i++;

                        $line = $bt[$i]["line"];
                        $file = str_replace(getcwd().DIRECTORY_SEPARATOR, "", $bt[$i]["file"]);
                        $msg = "Database Error in $file on line $line: $mysql_error. Query was: $query.";
                } else {
                        $file = str_replace(getcwd().DIRECTORY_SEPARATOR, "", $_SERVER["SCRIPT_FILENAME"]);
                        $msg = "Database Error in $file: $mysql_error. Query was: $query";
                }
       
        $mysqli->query("INSERT INTO `sqlerr` (`txt`, `time`)
                    VALUES (".sqlesc($msg).", '".get_date_time()."')");

        if ( function_exists('show_error_msg') )
                    show_error_msg("Database Error", "Database Error. Please report this to an administrator.", 1);
        }
}

/* Example Usage:

// Note: Any values passed to p() or p_name() MUST NOT be escaped, this will be done internally.
// for p() arrays are also taken and imploded with , for use in IN(...)
// p_name() is for field/table names
// p() is for where conditions, insert/update values, etc...

$ids = range(1, 10);
//$res = SQL_Query("SELECT `id`, `username` FROM `users` WHERE ? IN (?) ORDER BY ? ASC")->p_name("id")->p($ids)->p_name("id")->execute();

$q = SQL_Query("SELECT `id`, `username` FROM `users` WHERE ? IN (?) ORDER BY ? ASC")->p_name("id")->p($ids)->p_name("id");

echo "Query: ".$q->read()."\n";
$res = $q->execute();

while ($row = $res->fetch_array()) {
        echo "$row[id] - $row[username]\n";
}

// Trigger a SQL error to test logging
SQL_Query("SELECT")->execute();
*/
?>
Its not mysqli needs PDO as from what i can see not very good at all and the rest of the files to go with this well all the code Lol


All times are GMT +2. The time now is 00:48.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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