Experienced Elementalist
- Joined
- Jun 3, 2006
- Messages
- 203
- Reaction score
- 33
You need Savoy's MuWebShop, not MuWeb. You can use any MU site.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
not work...
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.[COLOR="#00FF00"]ConnectStat[/COLOR] = 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.[COLOR="#00FF00"]Grand_Resets[/COLOR] = chr.[COLOR="#00FF00"]Grand_Resets[/COLOR] + 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.[COLOR="#00FF00"]ConnectStat[/COLOR] = 0
where
chr.Resets >= 800 AND chr.money > 1000000
end
What I do and me a script in Query Analyzer to 100 reset = 1 grand reset = 2000 credit
update mc
set mc.CREDITS = mc.CREDITS + [COLOR="#FF0000"]50000[/COLOR]
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 >= [COLOR="#FF0000"]800[/COLOR] AND chr.money > 1000000
end