This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| $files = explode(' ', './scripts/map_sql_to_api.php ./scripts/whmcs_import.php ./scripts/map_everything_to_my.php ./scripts/whmcs_import2.php ./phpunit/class_tests/db_mdb2Test.php ./phpunit/class_tests/db_PDOTest.php ./phpunit/class_tests/db_mysqlTest.php ./phpunit/class_tests/db_mysqliTest.php ./include/preconfig.functions.inc.php ./include/accounts/accounts.inc.php ./include/dns/pdns.functions.inc.php ./include/db/class.db_mdb2.functions.inc.php ./include/functions.inc.php ./monitord.php ./monitord_new.php'); | |
| foreach ($files as $file) | |
| { | |
| echo "Working on file $file\n"; | |
| $txt = file_get_contents($file); | |
| $regex = '/([\s]+)(\$[\w\[\]\'_]+) = new db;\n[\s]+\$[\w\[\]\'_]+->Host = ([^;]+);\n[\s]+\$[\w\[\]\'_]+->Database = ([^;]+);\n[\s]+\$[\w\[\]\'_]+->User = ([^;]+);\n[\s]+\$[\w\[\]\'_]+->Password = ([^;]+);\n[\s]+\$[\w\[\]\'_]+->Type = ([^;]+);/m'; | |
| if (preg_match($regex, $txt)) | |
| { | |
| $txt = preg_replace($regex, '\1\2 = new db(\4, \5, \6, \3);\1\2->Type = \ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| # mytop.sh - (Monitor mysql process list with top like screen updates and adiditonal stats like cpu/io usage) | |
| # | |
| # Sample Output: | |
| # | |
| # CPU Usage 3.29% user 1.60% system 3.37% io wait 0.00% steal 91.59% idle | |
| # Up 17 days 10 hours Load Avg 0.43 0.36 0.35 Processes 1(running) 408(total) Last PID 17825 | |
| # +----------+------+-----------+----+---------+------+-------+------------------+ | |
| # | Id | User | Host | db | Command | Time | State | Info | | |
| # +----------+------+-----------+----+---------+------+-------+------------------+ |
NewerOlder