Reset Script Error

Can anybody help me figure out what wrong it this code?.

i used john_d's web. And theres something wrong with user.resets.php because i cant reset.

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'].' 
<label>STR:</label> '.$rs['STR'].' 
<label>DEX:</label> '.$rs['DEX'].' 
<label>INT:</label> '.$rs['INT'].' 
<label>PNT:</label> '.$rs['PNT'].' 
<label>'.$_config['ucp_lvl_col'].':</label> '.$rs[$_config['ucp_lvl_col']].' 
</fieldset></td>';
$form .= '<td><fieldset><legend>After</legend>
<label>Level:</label> 1 
<label>STR:</label> '.$rs['STR'].' 
<label>DEX:</label> '.$rs['DEX'].' 
<label>INT:</label> '.$rs['INT'].' 
<label>PNT:</label> '.($rs['PNT']+$_config['ucp_lvl_bonus']).' 
<label>'.$_config['ucp_lvl_col'].':</label> '.($rs[$_config['ucp_lvl_col']]+1).' </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'].' 
<label>STR:</label> '.$rs['STR'].' 
<label>DEX:</label> '.$rs['DEX'].' 
<label>INT:</label> '.$rs['INT'].' 
<label>PNT:</label> '.$rs['PNT'].' 
<label>'.$_config['ucp_lvl_col'].':</label> '.$rs[$_config['ucp_lvl_col']].' 
</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'].' 
<label>STR:</label> '.$rs2['STR'].' 
<label>DEX:</label> '.$rs2['DEX'].' 
<label>INT:</label> '.$rs2['INT'].' 
<label>PNT:</label> '.$bonus.' 
<label>'.$_config['ucp_lvl_col'].':</label> '.($rs[$_config['ucp_lvl_col']]+1).' </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 .= ' <center><a href="javascript:form_read(\'Hero\')"><img border=0 src="includes/back.png"> '._Back_Hero.'</a></center>';

$msg2 .= '<hr> Inventory Empty Check: '.($_config['ucp_lvl_inv_check'] == false ? 'Remove all your inventory and equiped item first.' : 'Needed' ).'
 Money in Hand: '.$rs['Alz'].' Money Needed for Reset: '. ($_config['ucp_lvl_payment']).' <hr> '.$msg .'';
aprint('tabs-content', $form .$msg2);
?>

Here is my config.php

Quote:

// LEvel Reset config
$_config['ucp_lvl_allow'] = true; // true of false
$_config['ucp_lvl_level'] = 200;
$_config['ucp_lvl_payment'] = 100000000;
$_config['ucp_lvl_inv_check'] = false; // if true will check if inventory and equipments are empty
$_config['ucp_lvl_keep_stat'] = TRUE; // if true keep stats is enabled
$_config['ucp_lvl_bonus'] = 200; // Bonus per reset
$_config['ucp_lvl_magic_clear'] = true; // if true will remove magic list
$_config['ucp_lvl_limit'] = 10; // Limit number for resets
$_config['ucp_lvl_col'] = 'RESETS'; // name of the column

Thanks.

Re: Reset Script Error

Why can't you reset, errors? If so we need to know what they are.

Re: Reset Script Error

i really dunno know chumpy, i read the script many times but i cant see whats wrong.

actualy the user.resets.php is ok as it load well. but when i press Click Here To Reset Your Hero nothing happens...

i think theres something wrong with this line chumpy, sorry i a php noob. >.<

Quote:

$form .= '<center><input type="button" value="Click Here to Reset Your Hero" onclick="javascript:char_do('.$this->id.',\'Reset\',\'do_reset\')"></center>';

Re: Reset Script Error

here is my user.reset.php you can see that it is all fine.

http://img8.imageshack.us/img8/3884/69179686.jpg

but when i press Click Here To Reset Your Hero it shows only this.

http://img391.imageshack.us/img391/5268/66379553.jpg

and after that comes back to this.

http://img8.imageshack.us/img8/3884/69179686.jpg

http://img386.imageshack.us/img386/6127/97709459.jpg

Re: Reset Script Error

Try to delete inventory check, then will be works fine!