Re: [Release] ResetMode DEMO by Kamui
How to add the condition?:
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>399 AND Character.Resets BETWEEN 15 AND 99 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>409 AND Character.Resets BETWEEN 100 AND 149 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>419 AND Character.Resets BETWEEN 150 AND 199 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>384 AND Character.Resets BETWEEN 5 AND 14 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>349 AND Character.Resets <5 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>429 AND Character.Resets BETWEEN 200 AND 249 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>439 AND Character.Resets BETWEEN 250 AND 299 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
UPDATE Character SET clevel= 1 , Character.Experience= 0 ,Money = Money - 100000000, Character.LevelUpPoint= (300)+(300)*Character.Resets , Character.Resets = Character.Resets+1 , Character.Strength= (30) , Character.Dexterity= (26) , 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>449 AND Character.Resets >300 AND Money >= 105000000 AND MEMB_STAT.ConnectStat = 0
Thanks!