SQL - A lot of guides

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

Code:

---

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 :

Code:

---

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 :

Code:

---

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 :

Code:

---

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:

Quote:

---

Originally Posted by Wahooka

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.

Code:

---

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

Code:

---

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

Code:

---

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

---

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

ty :))

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

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

how about some credits ?

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

auto zen

UPDATE Character
SET Money= 2000000000
WHERE Money < 1

auto zen @ vault

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

Very usefull, thanks.

Thanks AnHiMiLaToR,

CooL guide.

p.s. Keep Them Comin'

Thx man

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

thx for the stats repair

Quote:

---

Originally Posted by Skorpijon

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.

You have the auto reset Per Points ???

Tanks ^^

Any idea about Dark Lord commands stat points fix?

Quote:

---

Originally Posted by ivo2296

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)

Quote:

---

Originally Posted by ♫Kamui♫

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!

the post command to add ? at 99.6XT ?

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

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?

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