- Joined
- Aug 21, 2008
- Messages
- 2,110
- Reaction score
- 496
This works with last savoy webshop (0.9 if i remember right) , also its made for MSSQL 2000, didnt test on 2k5/8
1. create column name GrandResets with default value (0) in table character,
2. create MSSQL Job which runs per 1-2 hours or more if u want.
3. mssql job config > use db muonline, put this in command window
This script will add 50 000 credits to a character which is level 800 or more and have more than 1 000 000 zen.,
it will also "GrandReset" the character backing the stats to 100 , level to 1, resets to 1, and level up points to 500. if the account is not connected.
Credits:
SantaAna
crazyboy
1. create column name GrandResets with default value (0) in table character,
2. create MSSQL Job which runs per 1-2 hours or more if u want.
3. mssql job config > use db muonline, put this in command window
PHP:
update mc
set mc.CREDITS = mc.CREDITS + 50000
from MEMB_CREDITS mc
inner join dbo.Character ch with (nolock) on
ch.accountid COLLATE DATABASE_DEFAULT = mc.memb___id COLLATE DATABASE_DEFAULT and
ch.Resets >= 200
inner join memb_stat ms with (nolock) on
ms.memb___id COLLATE DATABASE_DEFAULT = ch.accountid COLLATE DATABASE_DEFAULT and
ms.connectstat = 0
if @@rowcount > 0 begin
update chr set
chr.clevel = 1,
chr.Experience = 5000,
chr.LevelUpPoint = 500,
chr.MapNumber = 0,
chr.MapPosX = 130,
chr.MapPosY = 130,
chr.PkTime = 0,
chr.PkCount = 0,
chr.PkLevel = 3,
chr.strength = 100,
chr.Dexterity = 100,
chr.vitality = 100,
chr.energy = 100,
chr.Leadership = 100,
chr.Resets = 1,
chr.GrandResets = chr.GrandResets + 1
from Character chr
inner join memb_stat ms with (nolock) on
ms.memb___id COLLATE DATABASE_DEFAULT = chr.accountid COLLATE DATABASE_DEFAULT and
ms.connectstat = 0
where
chr.Resets >= 800 AND chr.money > 1000000
endThis script will add 50 000 credits to a character which is level 800 or more and have more than 1 000 000 zen.,
it will also "GrandReset" the character backing the stats to 100 , level to 1, resets to 1, and level up points to 500. if the account is not connected.
Credits:
SantaAna
crazyboy
