-- ==================================
-- WWW.GUIAMUONLINE.K6.COM.BR
-- ==================================
--
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=250+250*Character.Resets, Character.Resets=Character.Resets+1,Strength=('25'), Dexterity=('25'), Vitality=('25'),Energy=('25')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 0 and Money>('0')
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=500+500*Character.Resets, Character.Resets=Character.Resets+1,Strength=('50'), Dexterity=('50'), Vitality=('50'),Energy=('50')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>299 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 1 and Money>('0')
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=700+700*Character.Resets, Character.Resets=Character.Resets+1,Strength=('70'), Dexterity=('70'), Vitality=('70'),Energy=('70')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>279 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 2 and Money>('0')
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=1000+1000*Character.Resets, Character.Resets=Character.Resets+1,Strength=('100'), Dexterity=('100'), Vitality=('100'),Energy=('100')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>249 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 3 and Money>('0')
Já configurado para:
Free: Reset 350 / Pontos por Reset: 250 / Status: 25
Vip 1:Reset 300 / Pontos por Reset: 500 / Status: 50
Vip 2:Reset 280 / Pontos por Reset: 700 / Status: 70
Vip 3:Reset 250 / Pontos por Reset: 1000 / Status: 100
Você pode mudar para de acordo com seu gosto.
-- WWW.GUIAMUONLINE.K6.COM.BR
-- ==================================
--
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=250+250*Character.Resets, Character.Resets=Character.Resets+1,Strength=('25'), Dexterity=('25'), Vitality=('25'),Energy=('25')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 0 and Money>('0')
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=500+500*Character.Resets, Character.Resets=Character.Resets+1,Strength=('50'), Dexterity=('50'), Vitality=('50'),Energy=('50')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>299 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 1 and Money>('0')
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=700+700*Character.Resets, Character.Resets=Character.Resets+1,Strength=('70'), Dexterity=('70'), Vitality=('70'),Energy=('70')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>279 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 2 and Money>('0')
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=1000+1000*Character.Resets, Character.Resets=Character.Resets+1,Strength=('100'), Dexterity=('100'), Vitality=('100'),Energy=('100')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>249 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 3 and Money>('0')
Já configurado para:
Free: Reset 350 / Pontos por Reset: 250 / Status: 25
Vip 1:Reset 300 / Pontos por Reset: 500 / Status: 50
Vip 2:Reset 280 / Pontos por Reset: 700 / Status: 70
Vip 3:Reset 250 / Pontos por Reset: 1000 / Status: 100
Você pode mudar para de acordo com seu gosto.