Código:
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=*** 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)