[HELP]Auto removed IP/PK

08/21/2012 07:08 yepee22#1
Can anyone tell me how to do the Automatic Removal of PK/IP of a player?

like when you log out and log in back your killer will disapear?

just like Crystal DK

Ty.
08/21/2012 07:52 Xapphire#2
Can you rephrase that. I haven't played crystal I'm assuming you mean remove all Ip when you relog?
08/21/2012 07:59 yepee22#3
i mean.

for example you pk a player and your name is red.

if you logout and login back in game again your red name will be gone.
08/21/2012 09:13 janvier123#4
simple sql job
08/21/2012 10:12 yepee22#5
javier123,

can you teach me? how?
08/22/2012 05:23 kokamentos#6
Update dbo.user_character set wPkcount = '0'
08/22/2012 09:30 Ultimo ☼#7
Quote:
Originally Posted by kokamentos View Post
Update dbo.user_character set wPkcount = '0'
should be "wChaoticLevel" instead of "wPkcount"

I suggest you to make a job in SQL for it. Take a look at the reborn system to understand how create a job. You can make a job to reset IPs every minute(1), so you dont need to repeat this every time.

You can learn a lot if you read and understand the scripts that other people have created.
08/22/2012 11:52 conquer93#8
u cud also change in maplist i remember .. thersa colum about how much ip u lose every minute in that map u cud also make this higher if u dont know how to do the sql job
08/22/2012 14:33 HellSpider#9
I've never checked, but the most efficient way could be to edit SP_CHAR_CHECK_IN stored procedure.