Auto reset with points

it is working for me..i manage to get it..however...the level did change to lvl 1...but no extra points..I copy all the command.Can i know where i go wrong?

Anywhere post one link to download one database for reset funtcionaly? Please ...

I knowledge the resolution for my problem!

ODBC!! my odbc not 100% functionaly .. im download new ODBC and this problem go away ...

well here is mine resets to defualt stats to each char class

for lvl 1k servers with maginc list deleted as a should be making them relearning skills plus inv clear it wont delete mony left on char tho also not u will need to edit PkLevel=2 to 1 cause my server has auto hero system :P anyways here my code

Code:

---

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('18') , Character.Dexterity= ('18') , Character.Vitality= ('15') , Character.Energy= ('30') , Character.Inventory=null , Character.MagicList=null

FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=1 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('22') , Character.Dexterity= ('25') , Character.Vitality= ('20') , Character.Energy= ('15') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=33 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('26') , Character.Dexterity= ('26') , Character.Vitality= ('26') , Character.Energy= ('26') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=48 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('28') , Character.Dexterity= ('20') , Character.Vitality= ('25') , Character.Energy= ('10') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=17 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10

---

Quote:

---

Originally Posted by Brianbio

well here is mine resets to defualt stats to each char class

for lvl 1k servers with maginc list deleted as a should be making them relearning skills plus inv clear it wont delete mony left on char tho also not u will need to edit PkLevel=2 to 1 cause my server has auto hero system :P anyways here my code

Code:

---

UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('18') , Character.Dexterity= ('18') , Character.Vitality= ('15') , Character.Energy= ('30') , Character.Inventory=null , Character.MagicList=null

FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=1 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('22') , Character.Dexterity= ('25') , Character.Vitality= ('20') , Character.Energy= ('15') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=33 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('26') , Character.Dexterity= ('26') , Character.Vitality= ('26') , Character.Energy= ('26') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=48 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0
UPDATE Character
SET clevel= ('1') , Character.Experience= ('0') , Character.LevelUpPoint= ('1000')+('1000')*Character.resets , Character.resets = Character.resets+1 , Character.Strength= ('28') , Character.Dexterity= ('20') , Character.Vitality= ('25') , Character.Energy= ('10') , Character.Inventory=null , Character.MagicList=null
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Character.clevel>999 and Character.Class=17 and Character.LevelUpPoint=0 and Character.PkLevel=2 AND Memb_Stat.ConnectStat = 0 And Character.Resets !> 10

---

---

better remove the invenotry clear.cuz imagine user gets connection problems and is for reset and blam..all items gone ^^

yep your right

Good idea.

[N]asser` ~ Out

XiaoXin faster on the server.........