Quote:
Originally Posted by TheShadow
Which is why I'm inclined to think it's not a server issue. It's now starting to affect adopts getting clicks as well, so pretty much everything is breaking down :c
|
Maybe the problem is caused by mysql queues... Just try this:
Go to levelup.php [145] there should be 2 lines like this:
PHP Code:
$newamount = $GLOBALS['money'] + $reward;
runquery("UPDATE {$GLOBALS['prefix']}users SET `money` = '{$newamount}' WHERE `username` = '{$loggedinname}'");
Try replacing with this:
PHP Code:
$newamount = $GLOBALS['money'] + $reward;
runquery("UPDATE {$GLOBALS['prefix']}users SET `money` = `money`+{$reward} WHERE `username` = '{$loggedinname}'");
This will probably cause Mysql to just increase instead of overwriting. Worth a try?
EDIT: Is money a string? If so it'll probably not work... Hope it isn't like this. Otherwise you'll have to try adding a field that is called "lock" and that is changed to 1 at the beginning of the script and changed to 0 at the end. We'll also have to add some code to detect if the lock is activated and "sleep" 0.1 seconds and repeat the query...