|
#1
|
||||
|
||||
function dbconn
Hello all,
need little help here, so these fuctions need to be mysqli Code:
function dbconn_announce() { global $mysql_host, $mysql_user, $mysql_pass, $mysql_db; if (!@mysql_connect($mysql_host, $mysql_user, $mysql_pass)) { die('dbconn: mysql_connect: ' . mysql_error()); } mysql_query("SET NAMES UTF8"); mysql_query("SET collation_connection = 'utf8_general_ci'"); mysql_query("SET sql_mode=''"); mysql_select_db($mysql_db) or die('dbconn: mysql_select_db: ' + mysql_error()); } and this one Code:
function dbconn($autoclean = false) { global $lang_functions; global $mysql_host, $mysql_user, $mysql_pass, $mysql_db; global $useCronTriggerCleanUp; if (!mysql_connect($mysql_host, $mysql_user, $mysql_pass)) { switch (mysql_errno()) { case 1040: case 2002: die("<html><head><meta http-equiv=refresh content=\"10 $_SERVER[REQUEST_URI]\"><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"></head><body><table border=0 width=100% height=100%><tr><td><h3 align=center>".$lang_functions['std_server_load_very_high']."</h3></td></tr></table></body></html>"); default: die("[" . mysql_errno() . "] dbconn: mysql_connect: " . mysql_error()); } } mysql_query("SET NAMES UTF8"); mysql_query("SET collation_connection = 'utf8_general_ci'"); mysql_query("SET sql_mode=''"); mysql_select_db($mysql_db) or die('dbconn: mysql_select_db: ' + mysql_error()); userlogin(); if (!$useCronTriggerCleanUp && $autoclean) { register_shutdown_function("autoclean"); } } Code:
function sql_query($query) { global $query_name; $query_name[] = $query; return mysql_query($query); } Last edited by elvira; 29th April 2021 at 20:16. |
#2
|
|||
|
|||
Without doing the rewrite for you, start by changing mysql to mysqli, in the code.
The connection signature changes to this: Code:
mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_db); Code:
mysql_query("SET NAMES UTF8"); mysql_query("SET collation_connection = 'utf8_general_ci'"); mysql_query("SET sql_mode=''"); Code:
mysql_select_db($mysql_db) or die('dbconn: mysql_select_db: ' + mysql_error()); Code:
mysqli_query($db, $query); |
#3
|
||||
|
||||
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:
|
#4
|
||||
|
||||
I have something like this
Code:
function dbconn($autoclean = false) { global $lang_functions; global $mysql_host, $mysql_user, $mysql_pass, $mysql_db; global $useCronTriggerCleanUp; if (!@($GLOBALS["___mysqli_ston"] = mysqli_connect($mysql_host, $mysql_user, $mysql_pass, $mysql_db))) { switch (((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_errno($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_errno()) ? $___mysqli_res : false))) { case 1040: case 2002: die("<html><head><meta http-equiv=refresh content=\"10 $_SERVER[REQUEST_URI]\"><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"></head><body><table border=0 width=100% height=100%><tr><td><h3 align=center>".$lang_functions['std_server_load_very_high']."</h3></td></tr></table></body></html>"); default: die("[" . ((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_errno($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_errno()) ? $___mysqli_res : false)) . "] dbconn: mysql_connect: " . ((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false))); } } mysqli_query($GLOBALS['___mysqli_ston'], "SET NAMES UTF8"); mysqli_query($GLOBALS['___mysqli_ston'], "SET collation_connection = 'utf8_general_ci'"); mysqli_query($GLOBALS['___mysqli_ston'], "SET sql_mode=''"); //mysql_select_db($mysql_db) or die('dbconn: mysql_select_db: ' + mysql_error()); ((bool)mysqli_query($GLOBALS['___mysqli_ston'], "USE " . $mysql_db)) or die('dbconn: mysql_select_db: ' . ((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false))); userlogin(); if (!$useCronTriggerCleanUp && $autoclean) { register_shutdown_function("autoclean"); } } |
#5
|
||||
|
||||
what TBDev are u using this would help me with you ?
|
#6
|
|||
|
|||
Quote:
|
#7
|
||||
|
||||
Quote:
Good luck!
__________________
Please Support Majority Report You can contact me on Skype live:phesadent.elect but please let me know first. If you are ever need me desperately then please email me at dan.oak44@gmail.com and I will contact u within a week. Due to free time I'm able to help interested member's with their tracker. Please Note! Depending on your requests I will charge you for my assistance for Tracker installs and mods. All my mods are custom and prices will very depending on the request. I'm able to install any tracker and mods including themes. Please PM me |
#8
|
||||
|
||||
i do get where u are coming from i use mysqli all the time in the code base its set to mysqli but this part not working at all well when it first uploader works ok till clean up.. as someone said above its could be the memory so on but its not nor table locking ive done my checks on this in DB to no locking at all and the memory is all good
i could add this to backend PHP Code:
works ok then stop seeding its still there no good like this |
#9
|
||||
|
||||
I presume you have enough space on the partition? DB can lockup if there's no space Look I will have to have a look to really find what is going on.
__________________
Please Support Majority Report You can contact me on Skype live:phesadent.elect but please let me know first. If you are ever need me desperately then please email me at dan.oak44@gmail.com and I will contact u within a week. Due to free time I'm able to help interested member's with their tracker. Please Note! Depending on your requests I will charge you for my assistance for Tracker installs and mods. All my mods are custom and prices will very depending on the request. I'm able to install any tracker and mods including themes. Please PM me |
#10
|
||||
|
||||
yes i do a alot of it
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 |
|
|