Snaplinks

[Csar]

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...