[ Auto Reset - Free ]
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=300+300*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and Resets<50
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=250+250*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and resets>= 50 and resets<150
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=200+200*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and resets>= 150 and resets<200
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=150+150*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and resets>= 200 and resets<250
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=100+100*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and resets>= 250 and resets<300
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=75+75*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and resets>= 300 and resets<350
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=50+50*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and resets>= 350 and resets<400
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=25+25*Resets , Resets=Resets+1 , Strength=('20') , Dexterity=('20') , Vitality=('20') , Energy=('20')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>399 and MEMB_INFO.vip=0 and Money>('50000000') and MEMB_STAT.ConnectStat=0 and resets>= 400 and resets<9999
[ Reset Free - Level 400 ]
de 1 a 50 resets gana 300 puntos. 50000000 zen.
de 51 a 150 resets gana 250 puntos. 50000000 zen.
de 151 a 200 resets gana 200 puntos. 50000000 zen.
de 201 a 250 resets gana 150 puntos. 50000000 zen.
de 251 a 300 resets gana 100 puntos. 50000000 zen.
de 301 a 350 resets gana 75 puntos. 50000000 zen.
de 351 a 400 resets gana 25 puntos. 50000000 zen.
de 400 resets en adelante gana 25 puntos. 50000000 zen.
[ Auto Reset - Vip ]
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=400+400*Resets , Resets=Resets+1 , Strength=('150') , Dexterity=('150') , Vitality=('150') , Energy=('150')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>349 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat=0 and Resets<50
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=350+350*Resets , Resets=Resets+1 , Strength=('150') , Dexterity=('150') , Vitality=('150') , Energy=('150')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>349 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat=0 and resets>= 50 and resets<150
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=300+300*Resets , Resets=Resets+1 , Strength=('150') , Dexterity=('150') , Vitality=('150') , Energy=('150')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>349 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat=0 and resets>= 150 and resets<200
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=250+250*Resets , Resets=Resets+1 , Strength=('150') , Dexterity=('150') , Vitality=('150') , Energy=('150')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>349 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat=0 and resets>= 200 and resets<250
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=200+200*Resets , Resets=Resets+1 , Strength=('150') , Dexterity=('150') , Vitality=('150') , Energy=('150')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>349 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat=0 and resets>= 250 and resets<300
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=150+150*Resets , Resets=Resets+1 , Strength=('150') , Dexterity=('150') , Vitality=('150') , Energy=('150')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>349 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat=0 and resets>= 300 and resets<350
UPDATE Character
SET clevel=('1') , experience=('0') , LevelUpPoint=100+100*Resets , Resets=Resets+1 , Strength=('150') , Dexterity=('150') , Vitality=('150') , Energy=('150')
FROM Character join Memb_Stat on Character.Accountid = Memb_Stat.memb___id COLLATE Latin1_General_CS_AS
JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
WHERE clevel>349 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat=0 and resets>= 350 and resets<9999
[ Reset Vip - Level 350 ]
de 1 a 50 resets gana 400 puntos. 0 zen.
de 51 a 150 resets gana 350 puntos. 0 zen.
de 151 a 200 resets gana 300 puntos. 0 zen.
de 201 a 250 resets gana 250 puntos. 0 zen.
de 251 a 300 resets gana 200 puntos. 0 zen.
de 301 a 350 resets gana 150 puntos. 0 zen.
de 351 a 400 resets gana 100 puntos. 0 zen.
de 400 resets en adelante gana 100 puntos. 0 zen.
Espero que les sirva...