- Joined
- Apr 27, 2007
- Messages
- 135
- Reaction score
- 134
QA script for Reset
For each personage apart
Is it Below presented script Reset for each personage apart!
# Information:
--------------------
Reset lvl: '400'
Reset point: '300'
Reset money: 100'000'000 zen
Vault: 'NOT NULL'
Inventoty: 'NULL'
MagicList: 'NULL'
Quest: 'NULL' (It Is Zeroized)
Class: 'NULL' (It Is Zeroized)
LevelUpPoint: '0' (It Is Zeroized)
Reset Map: 'Lorencia'
PkLevel: '3'
PkTime: '0'
Reset script for: DK/BK, DW/SM, FE/ME, MG, DL.
P.S. -> Now under Reset, LevelUpPoint from old Reset will not remain!
-
-
Code:
Use MuOnline;
UPDATE Character SET LevelUpPoint=0
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=0) or (Class=1) or (Class=16) or (Class=17) or (Class=32) or (Class=33) or (Class=48) or (Class=64)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)
UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=0, Experience=0, Strength=18, Dexterity=18, Vitality=15, Energy=30, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=0) or (Class=1)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)
UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=16, Experience=0, Strength=28, Dexterity=20, Vitality=25, Energy=10, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=16) or (Class=17)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)
UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=32, Experience=0, Strength=22, Dexterity=25, Vitality=20, Energy=15, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE ((Class=32) or (Class=33)) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)
UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=48, Experience=0, Strength=26, Dexterity=26, Vitality=26, Energy=26, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (Class=48) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)
UPDATE Character SET cLevel=1, LevelUpPoint=300*(Resets+1), Class=64, Experience=0, Strength=26, Dexterity=26, Vitality=26, Energy=26, Inventory=NULL, MagicList=NULL, Money=Money-(100000000), MapNumber=0, MapPosX=125, MapPosY=123, PkLevel=3, PkTime=0, Quest=NULL, Leadership=26, Resets=Resets+(1)
FROM Character JOIN MEMB_STAT ON Character.AccountID = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
WHERE (Class=64) and (cLevel>399) and (Money>100000000) and (PkLevel<4) and (ConnectStat=0)
P.S. -> Can whomever to be necessary!
------
Credits go to S@nek.
Last edited: