reset credits

I made script in PHP to get players webshop credits for each reset.
I just know it for muweb 0.8.
you need to find character.class.php it's lokated in "C:\xampp\htdocs\includes" for me. now find "function reset".
then you need the query codes. looks like this

Code:

---

if($error!=1){

                                    if(($muweb['resetmode']=='keep') AND ($muweb['levelupmode']=='normal')){
                                        $sql_reset_script="Update character set [clevel]='1',[experience]='0',[money]='$resetmoeny',[LevelUpPoint]='$resetpt',[resets]='$resetup' where name=?";}
                                    elseif(($muweb['resetmode']=='reset') AND ($muweb['levelupmode']=='extra')){
                                        $sql_reset_script="Update character set [strength]='25',[dexterity]='25',[vitality]='25',[energy]='25',[clevel]='1',[experience]='0',[money]='$resetmoeny',[LevelUpPoint]='$resetpt1',[resets]='$resetup' where name=?";}
                                    elseif(($muweb['resetmode']=='keep') AND ($muweb['levelupmode']=='extra')){
                                        $sql_reset_script="Update character set [clevel]='1',[experience]='0',[money]='$resetmoeny',[LevelUpPoint]='$resetpt1',[resets]='$resetup' where name=?";}
                                    elseif(($muweb['resetmode']=='reset') AND ($muweb['levelupmode']=='normal')){
                                        $sql_reset_script="Update character set [strength]='25',[dexterity]='25',[vitality]='25',[energy]='25',[clevel]='1',[experience]='0',[money]='$resetmoeny',[LevelUpPoint]='$resetpt',[resets]='$resetup' where name=?";}
                                    if($muweb['clean_inventory']=='yes' && $muweb['clean_skills']=='yes'){
                                        $sql_reset_script2="UPDATE character Set [inventory]=CONVERT(varbinary(1080), null),[magiclist]= CONVERT(varbinary(180), null) Where name=?";}
                                    elseif($muweb['clean_inventory']=='no' && $muweb['clean_skills']=='no'){
                                        $sql_reset_script2="Select name from character where name=?";}
                                    elseif($muweb['clean_inventory']=='yes' && $muweb['clean_skills']=='no'){
                                        $sql_reset_script2="UPDATE character Set [inventory]=CONVERT(varbinary(1080), null) Where name=?";}
                                    elseif($muweb['clean_inventory']=='no' && $muweb['clean_skills']=='yes'){
                                        $sql_reset_script2="UPDATE character Set [magiclist]= CONVERT(varbinary(180), null) Where name=?";}


                                    $sql_reset_exec = $db->Execute($sql_reset_script,array($charactername));
                                    $sql_reset_exec2 = $db->Execute($sql_reset_script2,array($charactername));

---

"$sql_reset_exec = $db->Execute($sql_reset_script"
"$sql_reset_exec2 = $db->Execute($sql_reset_script2"

these queries are executed when character is reseted.
we need to add new one. in my case "$sql_reset_script3" wich will add aditional credits... here it is>>

Code:

---

$sql_reset_script3="Update MEMB_CREDITS set credits=credits+5 where memb___id=?";

---

this will add 5 credits when char resets, if you want more just change "credits=credits+..." and whatever you want.

script is done and need to excute him with this command "$sql_reset_exec3 = $db->Execute($sql_reset_script3"
here the code

Code:

---

$sql_reset_exec3 = $db->Execute($sql_reset_script3,array($loginid));

---

don't forget, there was "array($charactername)" because levels and etc need to change on character, and here is "array($loginid)
because credits need to change in account... that's all. sorry bad english :):)

thanks for sharing :) hopefully there will be somethin like this for muweb 9 :D