<?php if($mvcore['reset_pageMod'] != 'on') { echo'<div class="e_note">For the moment this page is disabled, come back later!</div>'; } ?>
<?php if($_SESSION['user_login'] != 'ok') { echo'<div class="e_note">Please login to use this page!</div>'; } ?>
<?php if($mvcore['reset_pageMod'] == 'on') { ?>
<?php if($_SESSION['user_login'] == 'ok') { ?>
<?php
//Other Configs
$mvcore['reset_lvl_reset'] = "yes"; //Reset Character level to 1 ? ( Yes / No )
//end
if($_GET['op3'] != ''){
$character_name = $_GET['op3'];
$useracc = $_SESSION['username']; // Get username
$sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where name = '".$character_name."'");
$drop_info = mssql_fetch_row($sys_start);
[COLOR=#ff0000]if($mvcore['reset_lvl_reset'] == 'yes'){ $new_level = '1'; } else { $new_level = $drop_info[1]; };
[/COLOR]
[COLOR=#ff0000]if($mvcore['reset_bonus'] >= '1'){ $new_lvlupp = $mvcore['reset_bonus'] * $drop_info[2] + $mvcore['reset_bonus'] ; } else { $new_lvlupp = '0'; };
if($mvcore['reset_back_points'] == 'yes') { $new_lvlupp = $new_lvlupp + $drop_info[10] + $drop_info[11] + $drop_info[12] + $drop_info[13]; } else { $new_lvlupp = $new_lvlupp; };[/COLOR]
//checking system
$acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
$acc_statusx[0] == 0 ? $useron=1 : $useron=0; //Username
if($acc_statusx[0] == 1) { echo'<div class="e_note">Character is online, exit game!</div>'; };
$drop_info[15] == $useracc ? $usern=1 : $usern=0; //Username
$drop_info[0] == $character_name ? $name=1 : $name=0; //Name
$drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
if($mvcore['reset_item_check'] == 'yes') {
$sqll= mssql_query("declare @items varbinary(1728);
set @items = (select [Inventory] from [Character] where [name]='".$drop_info[0]."');
print @items;");
$sqll=mssql_get_last_message();
$sqlls = substr($sqll,2);
$item_check0 = substr($sqlls,(32*0), 32); //Item 0
$item_check1 = substr($sqlls,(32*1), 32); //Item 1
$item_check2 = substr($sqlls,(32*2), 32); //Item 2
$item_check3 = substr($sqlls,(32*3), 32); //Item 3
$item_check4 = substr($sqlls,(32*4), 32); //Item 4
$item_check5 = substr($sqlls,(32*5), 32); //Item 5
$item_check6 = substr($sqlls,(32*6), 32); //Item 6
$item_check7 = substr($sqlls,(32*7), 32); //Item 7
$item_check8 = substr($sqlls,(32*8), 32); //Item 8
$item_check9 = substr($sqlls,(32*9), 32); //Item 9
$item_check10 = substr($sqlls,(32*10), 32); //Item 10
$item_check11 = substr($sqlls,(32*11), 32); //Item 11
if($item_check0 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check1 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check2 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check3 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check4 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check5 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check6 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check7 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check8 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check9 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check10 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF' && $item_check11 == 'FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF') { $items_on_char = 1; }
else { echo'<div class="e_note">You can not reset if you have items on character!</div>'; $items_on_char = 0; };
} else { $items_on_char = 1; };
if($useron == '1' && $level == '1' && $zen == '1' && $name == '1' && $usern == '1' && $items_on_char == '1') {
if($mvcore['reset_stats'] == 'yes'){ $run_update = mssql_query("Update character set strength = '25', dexterity = '25', vitality = '25', energy = '25' where name = '".$character_name."'"); }; //Reset Stats
$run_update = mssql_query("Update character set LevelUpPoint = LevelUpPoint + '".$new_lvlupp."', resets = resets + '1', money = money - '".$mvcore['reset_zen']."', clevel = '".$new_level."' where name = '".$character_name."'"); //Update character
//Reset Reward
if($mvcore['reset_rew_cred'] == '1') {
$run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits_column']." = ".$mvcore['credits_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'");
}
elseif($mvcore['reset_rew_cred'] == '2') {
$run = mssql_query("update ".$mvcore['credits_table']." set ".$mvcore['credits2_column']." = ".$mvcore['credits2_column']." + '".$mvcore['reset_reward']."' where ".$mvcore['user_column']." ='".$useracc."'");
};
//end
echo'<div class="s_note">Character successfully reseted.</div>';
} else { echo'<div class="e_note">Some requirements are not respected.!</div>'; } ;
};
?>
<?php
if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td>Req. Zen</td>'; } else { $zen_on_off = ''; }; //Req. Zen
if($mvcore['reset_reward'] >= '1') { $reward_on_off = '<td>Reward</td>'; } else { $reward_on_off = ''; }; //Reset Reward
if($mvcore['reset_bonus'] >= '1'){ $new_lvlupps = '<td>Bonus</td>'; } else { $new_lvlupps = ''; }; //Bonus system
echo'
<table class="info-table" cellpadding="0" cellspacing="0">
<tbody><tr class="header">
<td>Name</td>
'.$reward_on_off.'
'.$zen_on_off.'
'.$new_lvlupps.'
<td>Req. Level</td>
<td>Req. Offline</td>
<td>Reset</td>
</tr>
';
$useracc = $_SESSION['username']; // Get username
$sys_start = mssql_query("select name,clevel,resets,grand_resets,money,LevelUpPoint,class,Inventory,MapNumber,PkLevel,strength,dexterity,vitality,energy,Leadership,accountid from character where AccountID = '".$useracc."' order by grand_resets desc, resets desc, clevel desc");
for($i=0;$i < mssql_num_rows($sys_start);++$i) {
$drop_info = mssql_fetch_row($sys_start);
//Static things
$acc_status = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='".$useracc."'"); $acc_statusx = mssql_fetch_row($acc_status);
switch ($drop_info[9]) { case 0: $pk_level="Phonoman"; break; Case 3: $pk_level="Commoner"; break; Case 6: $pk_level="Hero"; break;};
switch ($acc_statusx[0]) { case 0: $is_on_off="<font color='#58FA58'>Offline</font>"; break; case 1: $is_on_off="<font color='#FE2E2E'>Online</font>"; break; };
//checking system
$drop_info[1] >= $mvcore['reset_level'] ? $level=1 : $level=0; //Level
if($mvcore['reset_zen'] == '0') { $zen=1; } else { $drop_info[4] >= $mvcore['reset_zen'] ? $zen=1 : $zen=0; }; //Zen
if($level == '1' && $zen == '1') { $module_ok = '<a href="MVCore_user_cpMVCore_reset_characterMVCore_'.$drop_info[0].'.html" class="input-main"><img src="sys/images/gear.png" width="11px"> <b>Reset</b></a>'; }
else { $module_ok = "<font color='red'>N/A</font>"; };
//Coloring ifs
if($drop_info[1] >= $mvcore['reset_level']) { $level_color = '#58FA58'; } else { $level_color = '#FE2E2E'; }; // Req. Level Color
if($drop_info[4] >= $mvcore['reset_zen']) { $zen_color = '#58FA58'; } else { $zen_color = '#FE2E2E'; }; // Req. Zen Color
//Extra options
if($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '1') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name1'].'</td>'; }
elseif($mvcore['reset_reward'] >= '1' && $mvcore['reset_rew_cred'] == '2') { $reward2_on_off = '<td style="padding:0;">'.$mvcore['reset_reward'].' '.$mvcore['money_name2'].'</td>'; } else { $reward2_on_off = ''; }; //Reset Reward
if($mvcore['reset_zen'] >= '1') { $zen_on_off = '<td style="padding:0;"><font color="'.$zen_color.'">'.number_format($mvcore['reset_zen'], 0, '', ',').' Zen </font></td>'; } else { $zen_on_off = ''; }; //Req. Zen
if($mvcore['reset_bonus'] >= '1'){ $new_lvluppss = '<td style="padding:0;">'.$mvcore['reset_bonus'].' LvlUpPoints</td>'; } else { $new_lvluppss = ''; }; //Bonus system
echo'
<tr style="border-collapse: collapse; border-spacing: 0px;">
<td style="padding: 6px 3px 6px 3px;"><a href="MVCore_character_viewMVCore_'.$drop_info[0].'.html"><b>'.$drop_info[0].'</b></a></td>
'.$reward2_on_off.'
'.$zen_on_off.'
'.$new_lvluppss.'
<td style="padding:0;"><font color="'.$level_color.'">'.$drop_info[1].' / '.$mvcore['reset_level'].'</font></td>
<td style="padding:0;">'.$is_on_off.'</td>
<td style="padding:0;">'.$module_ok.'</td>
</tr>
';
};
?>
</table>
<?php }; ?>
<?php }; ?>