API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 25th, 2018
88
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 12.16 KB | None | 0 0
raw download clone embed print report
  1. <?
  2. $load_reset_settings = simplexml_load_file('engine/config_mods/grandreset_character_settings.xml');
  3. $active = trim($load_reset_settings->active);
  4. if($active == '0'){
  5.    echo msg('0','Sorry, this feature is temporarily unavailable at the moment.');
  6. }else{
  7. $reset_resets_need = trim($load_reset_settings->resets_need);
  8. $reset_level = trim($load_reset_settings->level);
  9. $reset_zen  = trim($load_reset_settings->zen);
  10. $reset_points = trim($load_reset_settings->bpoints);
  11. $reset_points_formula = trim($load_reset_settings->bpoints_formula);
  12. $reset_clear_skills = trim($load_reset_settings->clear_skills);
  13. $reset_clear_inv = trim($load_reset_settings->clear_inv);
  14. $reset_stats = trim($load_reset_settings->reset_stats);
  15. $reset_limit = trim($load_reset_settings->reset_limit);
  16. $reset_credits = trim($load_reset_settings->bcredits);
  17. $reset_credits_formula = trim($load_reset_settings->bcredits_formula);
  18.  
  19. if(isset($_GET['rid'])){
  20.    echo '<div style="margin-top: 10px;">';
  21.    $id = safe_input($_GET['rid'],'');
  22.    if(empty($id) || !is_numeric($id)){
  23.       header('Location: '.$core_run_script.'');
  24.       exit();
  25.    }else{
  26.       if(character_and_account($id,$user_auth_id) === false){
  27.          header('Location: '.$core_run_script.'');
  28.          exit();
  29.       }else {
  30.          if(account_online($user_auth_id) === true){
  31.             echo msg('0','Account is connected on game, please logout.');      
  32.          }else{
  33.             $select_req = $core_db->Execute("select clevel,money,ResetCount,leveluppoint,MasterResetCount from character where mu_id=? and accountid=?",array($id,$user_auth_id));
  34.            
  35.             if($select_req->fields[2] < $reset_resets_need){
  36.                echo msg('0','Unable to reset, reason: lacking '.($reset_resets_need - $select_req->fields[2]).' resets.');
  37.                $no_reset = 1;
  38.             }
  39.            
  40.             if($select_req->fields[0] < $reset_level){
  41.                echo msg('0','Unable to reset, reason: lacking '.($reset_level - $select_req->fields[0]).' levels.');
  42.                $no_reset = 1;
  43.             }
  44.             if($select_req->fields[1] < $reset_zen){
  45.                echo msg('0','Unable to reset, reason: lacking '.number_format($reset_zen - $select_req->fields[1]).' zen.');
  46.                $no_reset = 1;
  47.             }
  48.             if($no_reset != '1'){
  49.                $new_money = $select_req->fields[1] - $reset_zen;
  50.                switch ($reset_points_formula){
  51.                   case '0': $new_bpoints = ($select_req->fields[3]+$reset_points); break;
  52.                   case '1': $new_bpoints = ($select_req->fields[3]+ ($reset_points*($select_req->fields[2]+1))); break;
  53.                }
  54.                
  55.                switch ($reset_credits_formula){
  56.                   case '0': $new_bcredits = ($reset_credits); break;
  57.                   case '1': $new_bcredits = ($reset_credits*($select_req->fields[4]+1)); break;
  58.                }
  59.                switch ($reset_stats){
  60.                   case '1':
  61.                      if($reset_clear_inv == '1' and $reset_clear_skills == '1'){
  62.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[strength]='25',[dexterity]='25',[vitality]='25',[energy]='25',[leadership]='25',[inventory]=CONVERT(varbinary(1080), null),[magiclist]=CONVERT(varbinary(180), null),[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  63.                      }elseif ($reset_clear_inv == '1'){
  64.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[strength]='25',[dexterity]='25',[vitality]='25',[energy]='25',[leadership]='25',[inventory]=CONVERT(varbinary(1080), null),[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  65.                      }elseif ($reset_clear_skills == '1'){
  66.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[strength]='25',[dexterity]='25',[vitality]='25',[energy]='25',[leadership]='25',[magiclist]=CONVERT(varbinary(180), null),[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  67.                      }elseif ($reset_clear_inv == '0' and $reset_clear_skills == '0'){
  68.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[strength]='25',[dexterity]='25',[vitality]='25',[energy]='25',[leadership]='25',[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  69.                      }
  70.                   break;
  71.                   case '0':
  72.                      if($reset_clear_inv == '1' and $reset_clear_skills == '1'){
  73.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[inventory]=CONVERT(varbinary(1080), null),[magiclist]=CONVERT(varbinary(180), null),[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  74.                      }elseif ($reset_clear_inv == '1'){
  75.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[inventory]=CONVERT(varbinary(1080), null),[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  76.                      }elseif ($reset_clear_skills == '1'){
  77.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[magiclist]=CONVERT(varbinary(180), null),[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  78.                      }elseif ($reset_clear_inv == '0' and $reset_clear_skills == '0'){
  79.                         $reset_formula = "Update character set [ResetCount]='0',[clevel]='1',[experience]='0',[leveluppoint]=?,[money]=?,[MasterResetCount]=(MasterResetCount+1),[mapnumber]='0',[mapposx]='125',[mapposy]='125' where mu_id=?";
  80.                      }
  81.                   break;
  82.                }  
  83.                $exc_reset_formula=$core_db->Execute($reset_formula,array($new_bpoints,$new_money,$id));
  84.                
  85.                
  86.                $check_for_memb_id = $core_db2->Execute("Select ".MU_COINS_USERID_COLUMN." from ".MU_COINS_TABLE." where ".MU_COINS_USERID_COLUMN."=?",array($user_auth_id));
  87.                if($check_for_memb_id->EOF){
  88.                   $set_credits = $core_db2->Execute("insert into dbo.DmN_Shop_Credits (memb___id,credits) VALUES (?,?)",array($user_auth_id,$new_bcredits));
  89.                }else{
  90.                   $set_credits = $core_db2->Execute("Update dbo.DmN_Shop_Credits  set credits=(credits+?) WHERE memb___id=?",array($new_bcredits,$user_auth_id));
  91.                }
  92.                                        
  93.                                        
  94.                if($exc_reset_formula && $set_credits){
  95.                   echo msg('1','Character successfully grand reseted.');
  96.                }else{
  97.                   echo msg('0','Unable to grand reset, reason: system error, please contact administrator.');
  98.                }
  99.             }
  100.          }
  101.       }
  102.    }
  103.    echo '</div>';
  104. }
  105.  
  106. echo '<div style="margin-top: 20px;">
  107. <fieldset><legend>Reset Character Requirements</legend>
  108. <table border="0" cellspacing="4" cellpadding="0" width="100%" style="padding-left: 10px;">
  109. <tr>
  110. <td align="left"><b>Resets:</b></td>
  111. <td align="left" width="100%">'.$reset_resets_need.'</td>
  112. </tr>
  113. <tr>
  114. <td align="left"><b>Level:</b></td>
  115. <td align="left" width="100%">'.$reset_level.'</td>
  116. </tr>
  117. <tr>
  118. <td align="left"><b>Zen:</b></td>
  119. <td align="left" width="100%">'.number_format($reset_zen).'</td>
  120. </tr>
  121. <tr>
  122. <td align="left"><b>Resets Limit:</b></td>
  123. <td align="left" width="100%">'.number_format($reset_limit).'</td>
  124. </tr>
  125. </table>
  126. </fieldset>
  127. </div>
  128.  
  129. <div style="margin-top: 10px;">
  130. <fieldset><legend>Reset Forumla</legend>
  131. <table border="0" cellspacing="4" cellpadding="0"  style="padding-left: 10px; padding-right: 10px;">
  132. <tr>
  133. <td align="left" width="130" valign="top"><b>Credits Bonus:</b></td>
  134. <td align="left">';
  135. switch ($reset_credits_formula){
  136.    case '0': echo number_format($reset_credits);  break;
  137.    case '1': echo '('.number_format($reset_credits).'* grand resets number) - The * amount between credits bonus witch is '.number_format($reset_credits).' and number of grand resets that your character have.'; break;
  138. }
  139.  
  140. echo '</td>
  141. </tr>
  142.  
  143. <tr>
  144. <td align="left" width="130" valign="top"><b>Levelup Bonus Points:</b></td>
  145. <td align="left">';
  146. switch ($reset_points_formula){
  147.    case '0': echo number_format($reset_points);  break;
  148.    case '1': echo '('.number_format($reset_points).'* resets number) - The * amount between levelup bonus points witch is '.number_format($reset_points).' and number of resets that your character have.'; break;
  149. }
  150.  
  151. echo '</td>
  152. </tr>
  153. <tr>
  154. <td align="left"><b>Clear Skills:</b></td>
  155. <td align="left">';
  156. switch ($reset_clear_skills){
  157.    case '0': echo 'No'; break;
  158.    case '1': echo 'Yes'; break;
  159. }
  160. echo '</td>
  161. </tr>
  162. <tr>
  163. <td align="left"><b>Clear Inventory:</b></td>
  164. <td align="left">';
  165. switch ($reset_clear_inv){
  166.    case '0': echo 'No'; break;
  167.    case '1': echo 'Yes'; break;
  168. }
  169. echo '</td>
  170. </tr>
  171. <tr>
  172. <td align="left"><b>Reset Stats:</b></td>
  173. <td align="left">';
  174. switch ($reset_stats){
  175.    case '0': echo 'No'; break;
  176.    case '1': echo 'Yes'; break;
  177. }
  178. echo '</td>
  179. </tr>
  180. </table>
  181. </fieldset>
  182. </div>
  183. ';
  184.  
  185. $select_characters = $core_db->Execute("Select mu_id,name,clevel,class,ResetCount,money,MasterResetCount from character where accountid=? order by clevel desc ",array($user_auth_id));
  186.  
  187. echo '<table border="0" cellspacing="4" cellpadding="0" width="100%" style="margin-top: 10px; margin-bottom: 10px;">';
  188. while (!$select_characters->EOF){
  189.    if($select_characters->fields[4] < $reset_resets_need && $select_characters->fields[2] < $reset_level && $select_characters->fields[5] < $reset_zen){
  190.       $lacking_error = '<span class="iR_func_status_lacking">lacking '.($reset_resets_need - $select_characters->fields[5]).' resets, '.($reset_level - $select_characters->fields[2]).' level and '.number_format($reset_zen - $select_characters->fields[5]).' zen</span>';
  191.      
  192.    }elseif ($select_characters->fields[4] < $reset_resets_need){
  193.       $lacking_error = '<span class="iR_func_status_lacking">lacking '.($reset_resets_need - $select_characters->fields[4]).' resets</span>';
  194.    }elseif ($select_characters->fields[2] < $reset_level){
  195.       $lacking_error = '<span class="iR_func_status_lacking">lacking '.($reset_level - $select_characters->fields[2]).' level</span>';
  196.    }elseif ($select_characters->fields[5] < $reset_zen){
  197.       $lacking_error = '<span class="iR_func_status_lacking">lacking '.number_format($reset_zen - $select_characters->fields[5]).' zen</span>';
  198.    }else{
  199.      
  200.       $lacking_error = '<input type="button" value="Grand Reset Character" onclick="ask_url(\'Are you sure?\',\''.$core_run_script.'&rid='.$select_characters->fields[0].'\');">';
  201.    }
  202.    
  203.    echo '
  204.  <tr>
  205.    <td width="66" rowspan="2"><img src="template/'.$core['config']['template'].'/images/class/'.decode_class($select_characters->fields[3],'2').'" width="66" height="66" title="Class"></td>
  206.    <td align="left" class="iR_name" width="100">'.htmlentities($select_characters->fields[1]).'</td>
  207.    <td align="left" class="iR_stats">Level: '.$select_characters->fields[2].'</td>
  208.    <td align="left" class="iR_stats">Zen: '.number_format($select_characters->fields[5]).'</td>
  209.    <td align="left" class="iR_stats">Resets: '.$select_characters->fields[4].'</td>
  210.    <td align="left" class="iR_stats">Grand Resets: '.$select_characters->fields[6].'</td>
  211.  </tr>
  212.  <tr>
  213.    <td algin="left" class="iR_class">'.decode_class($select_characters->fields[3]).'</td>
  214.    <td colspan="4" class="iR_func_status" align="left">'.$lacking_error.'</td>
  215.  </tr>
  216.  <tr>
  217.    <td colspan="6" class="iRg_line_top">&nbsp;</td>
  218.  </tr>
  219.  
  220.  
  221.  
  222.  ';
  223.    
  224.    $select_characters->MoveNext();
  225. }
  226.  
  227. echo '</table>';
  228. }
  229.  
  230. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!