View Single Post
  #1  
Old 01-16-2011, 10:34 PM
Hall of Famer's Avatar
Hall of Famer Hall of Famer is offline
Administrator, Lead Coder
 
Join Date: Dec 2008
Location: South Brunswick
Posts: 4,448
Gender: Male
Credits: 615,992
Hall of Famer is on a distinguished road
Default Solution to fix the glitch in Mys/RA v1.10

If you have a heavily modified version of Mys/RA v1.10 and cannot upgrade to Mys v1.11 at this moment, I have an alternative solution for you. Just open levelup.php and find the lines below:

PHP Code:
// Start Rewards 
                   
                  // ************************************************   
                   
                   
                  //Get currency on level up 
                   
                  
$query "SELECT * FROM `adopts_users` WHERE `username`='$loggedinname'"
                  
$result mysql_query($query); 
                  
$num mysql_numrows($result); 
                   
                  
$i 0
                  while (
$i 1) { 
                      
$dollar = @mysql_result($result$i"dollar"); 
                       
                      
// Change this number 10 to the number of currency you want users to earn on level up   
                      
$amount rand(515); 
                      
$newbalance $dollar $amount
                       
                      
$i++; 
                  } 
                   
                  
mysql_query("UPDATE `adopts_users` SET `dollar`='" $newbalance "' WHERE `username`='$loggedinname'"); 


Replace with:

PHP Code:
// Start Rewards
                  
                  // ************************************************  
                  
                  
                  //Get currency on level up
                  
                  
$query "SELECT * FROM `".$prefix."users` WHERE `username`='$loggedinname'";
                  
$result mysql_query($query);
                  
$num mysql_numrows($result);
                  
                  
$i 0;
                  while (
$i 1) {
                      
$dollar = @mysql_result($result$i"dollar");
                      
                      
// Change this number 10 to the number of currency you want users to earn on level up  
                      
$amount rand(515);
                      
$newbalance $dollar $amount;
                      
                      
$i++;
                  }
                  
                  
mysql_query("UPDATE `".$prefix."users` SET `dollar`='" $newbalance "' WHERE `username`='$loggedinname'"); 
This should solve all your problem if you do not use the default prefix adopts_
__________________


Mysidia Adoptables, a free and ever-improving script for aspiring adoptables/pets site.
Reply With Quote