Mysidia Adoptables Support Forum  

Home Community Mys-Script Creative Off-Topic
Go Back   Mysidia Adoptables Support Forum > Mysidia Adoptables > Questions and Supports

Notices

Reply
 
Thread Tools Display Modes
  #1  
Old 11-08-2011, 11:14 PM
TheShadow TheShadow is offline
Member
 
Join Date: Apr 2011
Posts: 17
Gender: Female
Credits: 2,807
TheShadow is on a distinguished road
Default

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

I'm offering a $50 reward to whomever helps us fix this. It's a very serious issue D:
Reply With Quote
  #2  
Old 11-13-2011, 02:15 PM
Csar Csar is offline
Member
 
Join Date: Oct 2011
Posts: 7
Gender: Male
Credits: 787
Csar is on a distinguished road
Default

Quote:
Originally Posted by TheShadow View Post
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...

Last edited by Csar; 11-13-2011 at 02:18 PM.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 06:55 PM.

Currently Active Users: 695 (0 members and 695 guests)
Threads: 4,080, Posts: 32,024, Members: 2,016
Welcome to our newest members, jolob.
BETA





What's New?

What's Hot?

What's Popular?


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
vBCommerce I v2.0.0 Gold ©2010, PixelFX Studios
vBCredits I v2.0.0 Gold ©2010, PixelFX Studios
Emoticons by darkmoon3636