-
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.
-
Re: [Release] Auto Grand Reset made for MuWebShop
-
Re: [Release] Auto Grand Reset made for MuWebShop
geez, too many genious making this awesome things xD, gj mate :kisss:
-
Re: [Release] Auto Grand Reset made for MuWebShop
Wow, this is revolutionary. Good Job.
-
Re: [Release] Auto Grand Reset made for MuWebShop
-
Re: [Release] Auto Grand Reset made for MuWebShop
Wow thanks for this script !
-
Re: [Release] Auto Grand Reset made for MuWebShop
-
Re: [Release] Auto Grand Reset made for MuWebShop
-
Re: [Release] Auto Grand Reset made for MuWebShop
-
Re: [Release] Auto Grand Reset made for MuWebShop
How can I create a MSSQL Job?
-
Re: [Release] Auto Grand Reset made for MuWebShop
-
Re: [Release] Auto Grand Reset made for MuWebShop
How can i make this Grand Reset only for vips ?
-
Re: [Release] Auto Grand Reset made for MuWebShop
No One Knows how to Change this Job Only for Vips?
-
Re: [Release] Auto Grand Reset made for MuWebShop
-
Re: [Release] Auto Grand Reset made for MuWebShop
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 .
-
Re: [Release] Auto Grand Reset made for MuWebShop
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 :)
-
Re: [Release] Auto Grand Reset made for MuWebShop
hm...good but what about character class,skills, quest's...because after Grand Reset they also should be on default ;)
-
Re: [Release] Auto Grand Reset made for MuWebShop
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?
-
Re: Auto Grand Reset made for MuWebShop
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...
-
Re: Auto Grand Reset made for MuWebShop
I dont have MuWeb wat can i use ?
-
Re: Auto Grand Reset made for MuWebShop
You need Savoy's MuWebShop, not MuWeb. You can use any MU site.
-
Re: Auto Grand Reset made for MuWebShop
-
Re: Auto Grand Reset made for MuWebShop
What I do and me a script in Query Analyzer to 100 reset = 1 grand reset = 2000 credit
-
Re: [Release] Auto Grand Reset made for MuWebShop
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
-
Re: Auto Grand Reset made for MuWebShop
Good for Server+Player+Admin or Game Master :)