Auto Grand Reset made for MuWebShop

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

PHP Code:

---

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
end 


---

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: only me.
bb.

Nice script :)

Approved

geez, too many genious making this awesome things xD, gj mate :kisss:

Wow, this is revolutionary. Good Job.

Great JOB!

Wow thanks for this script !

wow great job!100/10

rate the thread ;p

awsome release :) 10/10

How can I create a MSSQL Job?

good job mean....!!

How can i make this Grand Reset only for vips ?

No One Knows how to Change this Job Only for Vips?

not work...

if it doesn't work for someone, it means he can't setup.
p.s its not made only to copy/past and run it, first follow the instructions .

good idea, but this is becoming => 200, I mean, 201 and 202 and 203, etc.
and >= 800, 801, 900, 1000, etc.
so, I make this:
if => 200 and <= 299 u give 100 credits (100 x 99=10000)
if => 300 and <= 399 u give 200 credits (200 x 99=20000)
the same for 800.
if anyone has a better idea, i give 50000 credits xD.
anyway thank you :)

hm...good but what about character class,skills, quest's...because after Grand Reset they also should be on default ;)

in 200 reset its do outo grand reset?
and if i want to chage the value of my credits to another table i can change "memb_credits" to "ew_credits" and its work fine?

Quote:

---

Originally Posted by SantaAna

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

PHP Code:

---

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
end 


---

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: only me.
bb.

---

I Just Saw This Post, Even Thou Its Been Posted Like, 2008?! Or Somthin'...

But Thanks Mate! :thumb:

Gonna Try It On 2k5...

I dont have MuWeb wat can i use ?

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

Thanks downloading :D

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

Quote:

---

Originally Posted by Richmeen

not work...

---

Code:

---

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.Grand_Resets = chr.Grand_Resets + 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
end

---

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

Quote:

---

Originally Posted by 251255

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

---

Code:

---

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
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

Good for Server+Player+Admin or Game Master :)