Sql Auto script's for 97d+99 version

[kenoby]

AutoReset
Start>Programs>MicrosoftSql Server>Enterprise Manager>make sure that you started the sql service manager...all 3 formes ...sql agent .etc>Microsoft Sql Server >Sql srv group>local(NT)>Management>
>Sql Server Agent>Jobs>Add new job>General/Name it AutoReset/>database sa>go to Steps>Add new
Step>Name it step1>DataBase MuOnline>At command enter code>
Code:

UPDATE Character

SET cLevel=('1') , experience=('0') , reset=(reset+1)
WHERE cLevel>300

Select Parse>click ok>apply>go tu schedules>new schedule>name it AutoReset>Go to change>Select daily>ocours every minutes>and set tha date ...uswaly is alredy set >ok>ok>aply>And then click 2 on AutoReset Job >Start Job or Refresh...and there you go ...you have autoreset ...100% working..:kisss:

AutoPkReset

Start>Programs>MicrosoftSql Server>Enterprise Manager>make sure that you started the sql service manager...all 3 formes ...sql agent .etc>Microsoft Sql Server >Sql srv group>local(NT)>Management>
>Sql Server Agent>Jobs>Add new job>General/Name it AutoPkReset>/>database sa>go to Steps>Add new
Step>Name it step1>DataBase MuOnline>At command enter code>
Code:

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

Select Parse>click ok>apply>go tu schedules>new schedule>name it AutoPkReset>Go to change>Select daily>ocours every minutes>and set tha date ...uswaly is alredy set >ok>ok>aply>And then click right on AutoPkReset Job >Start Job or Refresh...and there you go ...you have autopkreset ...100%...working

RepairStats

Start>Programs>MicrosoftSql Server>Enterprise Manager>make sure that you started the sql service manager...all 3 formes ...sql agent .etc>Microsoft Sql Server >Sql srv group>local(NT)>Management>
>Sql Server Agent>Jobs>Add new job>General/Name it RepairStats/>database sa>go to Steps>Add new
Step>Name it step1>DataBase MuOnline>At command enter code>

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'

Select Parse>click ok>apply>go tu schedules>new schedule>name it RepairStats>Go to change>Select daily>ocours every minutes>and set tha date ...uswaly is alredy set >ok>ok>aply>And then click right on RepairStats Job >Start Job or Refresh...and there you go ...you have RepairStats ...100%...working

ZenBugRepair

Start>Programs>MicrosoftSql Server>Enterprise Manager>make sure that you started the sql service manager...all 3 formes ...sql agent .etc>Microsoft Sql Server >Sql srv group>local(NT)>Management>
>Sql Server Agent>Jobs>Add new job>General/Name it Money/>database sa>go to Steps>Add new
Step>Name it step1>DataBase MuOnline>At command enter code>

Code:

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

Select Parse>click ok>apply>go tu schedules>new schedule>name it Money>Go to change>Select daily>ocours every minutes>and set tha date ...uswaly is alredy set >ok>ok>aply>And then click right on Money Job >Start Job or Refresh...and there you go ...you have ZenBugRepair ...100%...working

Thouse sql scripts work perfectly on version 97d+99...i didn t tested them on other versions...

Have Fun

 

[SHANG]

I've tried this

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

But when someone create new char, then logout and login, he gets 2000000000 zen! it should be

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

TESED!

 

[brumi]

nice worke man thx all worke 100%

 

[razu3]

Xremelly hekpfull, thx