Auto Grand Reset made for MuWebShop

[palco]

You need Savoy's MuWebShop, not MuWeb. You can use any MU site.

 

[k3ff0]

Thanks downloading

 

[251255]

What I do and me a script in Query Analyzer to 100 reset = 1 grand reset = 2000 credit

 

[jazzbert]

Re: [Release] Auto Grand Reset made for MuWebShop

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

the color green text was already edited.... working for me....Thanks

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

I think you have to change the red color number to your desired value Change 50000 into 2000 credits change 800 into 100 resets

 

[GoldbertGTR]

Good for Server+Player+Admin or Game Master