Auto Pk(Player Kill) clear

nightx · Admin Data inscrierii: 17/Aug/2007 Mesaje: 159

First whe go in Start\All Programs\Microsoft SQL Server\Enterprise Manager
Now acces Microsoft SQL Servers \Sql Server Group\(local) (Windows NT)\Management
Right click on SQL Agent Server\Start
Open Sql Server Agent\Jobs
Right click on Jobs and select New Job
Name : AutoPkClear
Owner : sa (or the user what u selected on SQL install)
Now select User from up menu
Select New...from down
Name AutoPkClear
Database MuOnlnie
Command : put this code :
UPDATE Character
SET PkLevel = ('0'), PkTime = ('0'), PkCount = ('0')
Where PkLevel>2

Now Click on Parse,Apply,Ok
Next click on New Schedule from down
Click Change ... right down
Occurs: Select Daily
Daily Frequency : Select Occurs every
Where is selected Hours select Daily
Daily Frequency : Occurs every
Where is Hours change selecting minutes
Now click ok two times
Click Apply and Ok