Auto Pk Clear Using SQL

[SkylineMaster]

1. Go to: Start -> All Programs -> Microsoft SQL Server -> Enterprise Manager.
   --
2. Open tree like this: Microsoft SQL Servers -> SQL Server Group -> (local) (Windows NT) -> Management.
   --
   
   • Right Click in SQL Server Agent -> Start.
   • Open open tree: SQL Server Agent -> Jobs.
   
   --
3. Right click in the blank space at the right and choose New Job...
   --
   
   • Name: AutoPkClear
   • Owner: Select sa
   
   --
4. Select Steps at the Top.
   
   • Click New... at the bottom.
   • Step Name: AutoPkClear.
   • Database: MuOnline
   • Command:

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

   • Click: Parse, Apply, Ok.
   
   --
5. Select Schedules at the top.
   
   • Click New Schedule... at the bottom.
   • Name: AutoPkClear.
   • Click Change..., right bottom.
   • Occurs: Select Daily.
   • Daily Frequency: Select Occurs every.
   • Where: Hours select Minutes.
   • Click: Ok 2 times.
   • Click: Apply then Ok.
   
   --
6. You have already done AutoPkClear every 1 minutes when some1 is Phono , you can use this script in any muserver version. Have Fun!!

[MentaL]

[alter]

thanks man i needed this btw this is Yubba hehehe

[squallzell]

well i thought it been posted anyway gj ;)

[alter]

Thanks man agaiin^^

Hehehehe

Cheers FOr 19

[Dorin1]

lol for noobs :D

[elitechar]

yep... i wrote one myself :P

[SkylineMaster]

lol for noobs :D

ooo im sorry then like u are a pro why u post.

same as the other one this is not for u so dont post shit here.

[DigY^B]

Yep i was looking for this :D thx WArrior :)

[hermes]

lol, dont bumb 2 year old threads man !

[Vengeful]

lol this guide is old and sux.....
and u can make that auto reset too

[WAIF]

nice one bro.