Bravo List - function dbconn

Bravo List (http://www.bvlist.com/index.php)

- TBDev (http://www.bvlist.com/forumdisplay.php?f=20)

- - function dbconn (http://www.bvlist.com/showthread.php?t=12357)

What source are u using? The cleanup should work out the box so I find the issue u are having very strange. Did u change something down the line?

i was on Debian 8 was working fine seeding and all, and all then they removed it so i had to go with Debian 9 and that when it all started on cleanup.. all the code base is mysqli nps on that everything works on but that part in clean up
also says seeding on seedbox and home pc no errors at all just clean up sending it dead to all to see but you can download the dead torrent lol
TBDev 09
And fully working on all PHP7 7.0 7.1 7.2 so on but same probs with clean ups
--------------------------------------------------------------------------------------------
In the U-232 master its all mysqli too only probs with that is announce
on line

PHP Code:


		
			
 mysqli_query($GLOBALS["___mysqli_ston"], "INSERT INTO peers (torrent, userid, peer_id, ip, port, connectable, uploaded, downloaded, to_go, started, last_action, seeder, agent, downloadoffset, uploadoffset, passkey) VALUES ($torrentid, {$user['id']}, ".sqlesc($peer_id).", ".sqlesc($ip).", $port, '$connectable', $uploaded, $downloaded, $left, ".time().", ".time().", '$seeder', ".sqlesc($agent).", $downloaded, $uploaded, ".sqlesc($passkey).")") or err("PL Err 2");

now ive looked in to this in depth checked DB and all the inputs are there so that dose your head in when its all there in seedbox and home pc the announce errors out on this like torrent dead error PL Err 2 not telling where look in longs and server longs nothing
Also i installed on my pc still same error

Ahhh I remember getting the same error (PL Err 2) some time ago but I cant remember what i did to fix the issue. I think I did something in the announce but I could be mistaken.

Edit:

Hard to fix without actually looking at the code. If u haven't fixed the issue and I have the time I will think about installing u232

IVE have been at this for months on it mate i just removed the the xampp-win32-7.0.33-0-VC14-installer
from pc and server too as the error would not fix at all not even on seedbox same error

so if you would like to give ago please do mate would love the fix for it too mate

Quote:

Originally Posted by budgie (Post 55469)

also this will not work on seedbox and home pc torrents On cleanups
you will get DB locks on it via mysqli it will only work on PHP 5.6 NOT 7.0 SO ON

PHP Code:


		
			
    $fields = explode(":", "comments:leechers:seeders");

    $res = sql_query("SELECT id, seeders, leechers, comments FROM torrents");

    while ($row = mysqli_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 ($torr[$field] != $row[$field])

                $update[] = "$field = " . $torr[$field];

        }

        if (count($update))

            sql_query("UPDATE torrents SET " . implode(",", $update) . " WHERE id = $id");

    }

Which query gives the lock? Is your table myisam or innodb?

MyISAM locks the entire table on update, InnoDB on locks the effected rows.

It is the MyISAM on updates it only done it from moving from Debian 8 to Debian 9 as the server hosting removed the Debian 8

Quote:

Originally Posted by budgie (Post 55505)

It is the MyISAM on updates it only done it from moving from Debian 8 to Debian 9 as the server hosting removed the Debian 8

The table lock happens no matter what is you are using. The difference would be MySQL version you are using.

Apache/2.4.46 (Ubuntu)
Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 24568906d452ec590732a93b051f3827e02749b83 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.0.33-0+deb9u10
Debian 9
Version information: 4.6.6deb4+deb9u2