SQL - A lot of guides

[AnHiMiLaToR]

=== Auto PK Reset ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >

Right click on SQL Server Agent > Start

Then open this category,click Jobs
Make Right Click > New Job
Name it AutoPkReset
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :

UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0')
Where PkLevel>2

make parse,click apply then ok,now go to Schedules,click New Schedule
Name : AutoPkReset
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on AutoPkReset job and Start job

=== Auto Reset ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >

Right click on SQL Server Agent > Start

Then open this category,click Jobs
Make Right Click > New Job
Name it AutoReset
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :

UPDATE Character
SET cLevel=('1') , experience=('0')
WHERE cLevel>349

make parse,click apply then ok,now go to Schedules,click New Schedule
Name : AutoReset
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on AutoReset job and Start job

=== Auto Repair Stats ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >

Right click on SQL Server Agent > Start

Then open this category,click Jobs
Make Right Click > New Job
Name it RepairStats
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :

UPDATE Character
SET Strength = '32766'
WHERE Strength < '1'

UPDATE Character
SET Dexterity = '32766'
WHERE Dexterity < '1'

UPDATE Character
SET Vitality = '32766'
WHERE Vitality < '1'

UPDATE Character
SET Energy = '32766'
WHERE Energy < '1'

make parse,click apply then ok,now go to Schedules,click New Schedule
Name : RepairStats
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on RepairStats job and Start job

=== Auto add 2,000,000,000 money and fix if its bugged ===
Open
Start > Programs > Sql Server > Enterprise Manager
Open Microsoft SQL Servers > SQL Server Group > (local) (Windows NT) > Management >

Right click on SQL Server Agent > Start

Then open this category,click Jobs
Make Right Click > New Job
Name it Money
change Owner to 'sa'
Now go to Steps tab,make New Job
Name it step1
database : muonline
command :

UPDATE Character
Set Money=('2000000000')
WHERE Money<1

make parse,click apply then ok,now go to Schedules,click New Schedule
Name : Money
Reccurting > Change
Occurs : Daily,every 1 days
Daily frequerency : occurs every : 1 minute
duration :
start date - make yesterday
then make NO End date,and ok 2 times
now click apply then ok,then right click on Money job and Start job


hope i help to some guys
works @ all versions (but 99.62 not tested)

Auto Class Upgrade:

I know some 99B+ servers have a problem with the class change quests so I wrote a couple of simple (VERY SIMPLE, like, noobishly simple) scripts for you to build on or change however you want.

UPDATE Character
SET Class = ('17')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 16 AND Memb_Stat.ConnectStat = 0 AND clevel>149

DK class change into BK

UPDATE Character
SET Class = ('1')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 0 AND Memb_Stat.ConnectStat = 0 AND clevel>149

DW class change into SM

UPDATE Character
SET Class = ('33')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 32 AND Memb_Stat.ConnectStat = 0 AND clevel>149

Elf class change into Muse Elf


Hope this helps someone :wolfwood:

:note: if you know how to combine 'em all together into one script, I'd like to know, I'm still starting out in SQL script so I'm more than eager to learn ^^

[MentaL]

[andsnake]

thanks anhimilator! I forgot how to make the sql autoreset and i was looking to find it in the forums..

[Skorpijon]

ty :))

[Skorpijon]

can u write hox to make max stats not 32k but 64k or 96k (ty)
:)

[florinabused]

wow so cool, do you think that if you post something that have been already posted you will win something? maybe a warn or something :\

[danse]

how about some credits ?

[HELL_IN_HEAVEN]

can u post how to add items but only once..after the 1st character created.

[AnHiMiLaToR]

auto zen

UPDATE Character
SET Money= 2000000000
WHERE Money < 1

auto zen @ vault

UPDATE Warehouse
SET Money= 2000000000
WHERE Money <1:batman:

[razu3]

Very usefull, thanks.

[bingbingz9]

Thanks AnHiMiLaToR,

CooL guide.

p.s. Keep Them Comin'

[phowa]

Thx man

[checkmate]

can you make a script for vault lock/unlock in game same globalmu

[Alex1414]

thx for the stats repair

[blow^^]

can u write hox to make max stats not 32k but 64k or 96k (ty)
:)

UPDATE Character
SET Strength = '32766'
WHERE Strength < '1'

in ( '32766' ) you can write your own optimal stats.

[Tchekler]

You have the auto reset Per Points ???

Tanks ^^

[ivo2296]

Any idea about Dark Lord commands stat points fix?

[♫Kamui♫]

Any idea about Dark Lord commands stat points fix?

UPDATE Character
SET Leadership = 10000
WHERE Leadership > 10000

If im not wrong, that's the max for DL.

EDIT: You cant go beyond 10k, the client dont allow it (99.62)

[ivo2296]

UPDATE Character
SET Leadership = 10000
WHERE Leadership > 10000

If im not wrong, that's the max for DL.

EDIT: You cant go beyond 10k, the client dont allow it (99.62)

Thanks a lot!

[englezu]

the post command to add ? at 99.6XT ?

[Darkthrone]

ty for autoreset script thats the simplest and best one out there

[cymonik]

thank you!!!! i reli needed the autoreset one but does it clear inventory and personal shop?
and will it update the resets columb to show they hav reset?

[kom75]

Auto Class Upgrade by one command if someone need:

UPDATE Character
SET Class = Class | 1
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class in (0,16,32) AND clevel>149 AND Memb_Stat.ConnectStat = 0