Solution to fix the glitch in Mys/RA v1.10

[Hall of Famer]

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(5, 15); 
                      $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(5, 15);
                      $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_