How To Make Auto PK Reset

[deniedkid]

I know Rifle_Morre posted 1 more thanks for code.. i made it on a easy way :) rate this trade if u want :D

How to make Auto PK Clear :

Open Enterprise Manager -> Start->Programs->Microsoft SQL Server->Enterprise Manager

And now u go to Management at SQL Server Agent and use other click and select New Job !

There will be 4 steps General , Steps , Schedules , Notification .

In General u'll set this things : Name Auto_PkClear , Category [Uncategorized (Local)]

The owner need to be sa and Description : Creates Auto Pk Clear

Now .. next steps named Steps :)) here u do this : click New and There will be another 2 steps

named General and Advanced .. on General u'll do this : Step Name : Step 1 , Type Transact-SQL Script (TSQL)

Database MuOnline and Command :

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

Guide by DeniedKiD ! Thanks to Rifle_Morre for code i made it more easy :)

[MentaL]

[thedark123]

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

do i need to change anything here?

[thedark123]

eh then how about the timing, i mean the frequency?

[Josh]

dsaafwdvwdfvfvewd

[Andos]

UPDATE Character
SET PKLevel=('3'), PKTime=('0'), PKCount=('0'), Money=Money-(PKcount*PKTime*('20000'))
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE PKLevel>=3 and Money>(PKcount*PKTime*('20000')) AND Memb_Stat.ConnectStat = 0

[[BLooZerr]Dimon]

It's not working, man! Enterprise Manager said that this shit have errors!:ranting2:

[[BLooZerr]Dimon]

Update Character
Set PkLevel=3,PkCount=0,PkTime=0
Where Name='Your Name'
This is how it needs to be! Not this shit which you wrote! Be more careful with suck stupid posts

[indounit]

its PkCount not Pk Count :)

[devilboy06]

I need sql reset code for muonline it work for resets and get 10M for per resets + + +

and when character resets be 100 set money to 1K dont if character will be at resets 101

get same money! 1K anyone know this code or find for me please!!