Quote:
<?PHP
if (!isset($_config)) die('Ops!');
$rs = $db2->Execute('Select Lev, Style, Alz, STR, DEX, INT, PNT, isnull('.$_config['ucp_lvl_col'].',0) as RESETS, CharacterIdx, Name from cabal_character_table where CharacterIdx = ?', array($this->id));
$char = $rs->GetArray();
$rs = $char[0];
$style = decode_style($rs['Style']);
if ($style['Class'] > 8) $style['Class'] = $style['Class']-8;
if ($rs[$_config['ucp_lvl_col']] == null) $rs[$_config['ucp_lvl_col']] = 0;
$rs2 = $db->Execute('select * from cabal_newchardata_table where classtype=? and lev = 1 and DataIdx=1',array($style['Class']));
$char = $rs2->GetArray();
$rs2 = $char[0];
$msg2 = char_list($this->id);
if (online_check($db2,$this->id) == false && isset($rs['Lev'])) {
if ($_config['ucp_lvl_allow'] == true ) {
if ($rs['Lev'] >= $_config['ucp_lvl_level']) {
if ($rs['Alz'] >= $_config['ucp_lvl_payment']) {
if ($_config['ucp_lvl_inv_check'] == false) {
if ($rs[$_config['ucp_lvl_col']] < $_config['ucp_lvl_limit'] ) {
// writelog("[ $name ] Level Reset","Level Reset");
if ($_config['ucp_lvl_keep_stat'] == true) {
$form .= '<table width="100%" cellpadding="5"><tr>';
$form .= '<td><fieldset><legend>Before</legend>
<label>Level:</label> '.$rs['LEV'].'<br/>
<label>STR:</label> '.$rs['STR'].'<br/>
<label>DEX:</label> '.$rs['DEX'].'<br/>
<label>INT:</label> '.$rs['INT'].'<br/>
<label>PNT:</label> '.$rs['PNT'].'<br/>
<label>'.$_config['ucp_lvl_col'].':</label> '.$rs[$_config['ucp_lvl_col']].'<br/>
</fieldset></td>';
$form .= '<td><fieldset><legend>After</legend>
<label>Level:</label> 1<br/>
<label>STR:</label> '.$rs['STR'].'<br/>
<label>DEX:</label> '.$rs['DEX'].'<br/>
<label>INT:</label> '.$rs['INT'].'<br/>
<label>PNT:</label> '.($rs['PNT']+$_config['ucp_lvl_bonus']).'<br/>
<label>'.$_config['ucp_lvl_col'].':</label> '.($rs[$_config['ucp_lvl_col']]+1).'<br/></fieldset></td>';
$form .= '</tr></table>';
if ($this->opt1 == 'do_reset' && ctype_digit($rs2['LEV'])) {
alert('You are now being reseted, Press OK to confirm');
$do = $db2->Execute('UPDATE cabal_character_table SET LEV=?,PNT=?,EXP=0,WorldIdx=?,Position=?,Nation=0,Alz=?,'.$_config['ucp_lvl_col'].'=? where CharacterIdx = ? and Lev >= ?',
array($rs2['LEV'],($rs['PNT']+$_config['ucp_lvl_bonus']),$rs2['WorldIdx'],$rs2['Position'],($rs['Alz']-$_config['ucp_lvl_payment']),($rs[$_config['ucp_lvl_col']]+1),$this->id,$_config['ucp_lvl_level']));
}
} else {
$form .= '<table width="100%" cellpadding="5"><tr>';
$form .= '<td><fieldset><legend>Before</legend>
<label>Level:</label> '.$rs['LEV'].'<br/>
<label>STR:</label> '.$rs['STR'].'<br/>
<label>DEX:</label> '.$rs['DEX'].'<br/>
<label>INT:</label> '.$rs['INT'].'<br/>
<label>PNT:</label> '.$rs['PNT'].'<br/>
<label>'.$_config['ucp_lvl_col'].':</label> '.$rs[$_config['ucp_lvl_col']].'<br/>
</fieldset></td>';
$bonus = (($rs[$_config['ucp_lvl_col']]+1) * 10) +$_config['ucp_lvl_bonus'];
$form .= '<td><fieldset><legend>After</legend>
<label>Level:</label> '.$rs2['LEV'].'<br/>
<label>STR:</label> '.$rs2['STR'].'<br/>
<label>DEX:</label> '.$rs2['DEX'].'<br/>
<label>INT:</label> '.$rs2['INT'].'<br/>
<label>PNT:</label> <b>'.$bonus.'</b><br/>
<label>'.$_config['ucp_lvl_col'].':</label> '.($rs[$_config['ucp_lvl_col']]+1).'<br/></fieldset></td>';
$form .= '</tr></table>';
if ($this->opt1 == 'do_reset' && ctype_digit($rs2['LEV'])) {
alert('You are now being reseted, Press OK to confirm');
// $db2->debug=1;
$do = $db2->Execute('update cabal_character_table set LEV=?,STR=?,DEX=?,INT=?,PNT=?,EXP=0,WorldIdx=?,Position=?,HP=?,MP=?,Nation=0,Alz=?,'.$_config['ucp_lvl_col'].'=? where CharacterIdx = ? and Lev >= ?',
array($rs2['LEV'], $rs2['STR'], $rs2['DEX'], $rs2['INT'],($bonus),$rs2['WorldIdx'],$rs2['Position'],$rs2['HP'],$rs2['MP'],($rs['Alz']-$_config['ucp_lvl_payment']),($rs[$_config['ucp_lvl_col']]+1),$this->id,$_config['ucp_lvl_level']));
}
}
$form .= '<center><input type="button" value="Click Here to Reset Your Hero" onclick="javascript:char_do('.$this->id.',\'Reset\',\'do_reset\')"></center>';
//if ($_config['lvl_magic_clear'] == true) $db->Execute('update Character SET MagicList = Null where and mu_id = ?', array($this->id));
} else $msg = _Reset_limit.' ('.$_config['ucp_lvl_limit'].')';
} else $msg = _Reset_inv.' <a href="javascript:char_do('.$this->id.',\'cls_inv\');"> CLEAR INVENTORY! </a>';
} else $msg = _Reset_money_r;
} else $msg = _Reset_lvl_r;
} else $msg = _Reset_not_allowed;
} else $msg = _Reset_online;
$msg .= '<br><br><center><a href="javascript:form_read(\'Hero\')"><img border=0 src="includes/back.png"><br>'._Back_Hero.'</a></center>';
$msg2 .= '<hr> Inventory Empty Check: '.($_config['ucp_lvl_inv_check'] == false ? 'Remove all your inventory and equiped item first.' : 'Needed' ).'
<br> Money in Hand: '.$rs['Alz'].' <br> Money Needed for Reset: '. ($_config['ucp_lvl_payment']).' <hr><b> '.$msg .'</b>';
aprint('tabs-content', $form .$msg2);
?>
Here is my config.php