Auto PkReset/Clear With Mssql (Movie)

[RifleMorre]

Url: http://www.vd0team.com/Guides/%5bGui...0With%20Mssql/
Sql Script Used in The Movie:

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

Guide Creator: Rifle_Morre

[MentaL]

[Domination]

& understand it like there:
PKLevel=1 - Hero lvl2
PKLevel=2 - Hero lvl1
PKLevel=3 - Commoner
PKLevel=4 - PK lvl1
PKLevel=5 - PK lvl2
PKLevel=6 - Merder
Explane plz, what does the PKLevel=0 means?

[HellSing]

wrong link please fix it

"Invalid Key or in use or Missing File"
"Additionally this error may be caused because the file was not found on the server."

[RifleMorre]

Pk Level 0 is Commoner And Its Not The Wrong Link Fix Your Internet Browser

[Domination]

yerh the char with PKLevel=0 seems to be a commoner, but PKLevel=3 its commoner too, i totally sure in this
& this script may be looks like:
Update Character
SET PkLevel = ('3'), PkTime = ('0'), Pk Count = ('0')
Where PkLevel>3
It's easy, but what we are need it for? What is this guide's practical usage? I don't get it.
It's piece of cake to understand it.
But why we sould making all the PK lvl1, PK lvl2 and Murders becaming a commoner? It looks like an Amnesty. If any Player like to kill other player they must be punish & encounter some of restriction (cant use the shop, /move command, attacking by the Guardians, etc). & how can the players becoming a hero since there is no murders?
Plz explane me.
Tnx.

[RifleMorre]

its a plain and simple guide. for noobs that don't know how to do much stuff so if your such a pro just don't post in this thread.

[RifleMorre]

This is How it Goes

Hero (Dark Blue)= -2
Hero (Light Blue)= -1
Commoner= 0
Warning=1
Warning Lvl2= 2
Phonomainia= 3

[yaozz]

WTF is this? not even close

[MagicAce]

at first, the sql script is incorrect. PkCount not Pk Count!

and, if someone played with PkLevel=0, he would turn Red-Name immediately after killed a Red-Name

the correct sql script should be:

Update Character
Set PkLevel=3,PkCount=0,PkTime=0
Where Name='Your Name'

(don't change all the ppl who PKLevel>3, only modify the one who you want to change)