How to clean frags? REP++

[rodrigosch]

Help, in my server, I need to reset frags, i reset red skull on database, but frags continue!

Helpp!

How I do it;?

REP++

Thx to now

 

[Helga]

I need this too ;/

If i go in to database and set skull and skulltime to 0, if the player get one more frag he get the skull back, because the frags was not removed

 

[Xeikh]

UPDATE `players` SET `redskulltime`=0;

Rep ++ ?

 

[SpiderOT]

open your phpmyadmin and empty table (killers)

 

[Xeikh]

open your phpmyadmin and empty table (killers)

Ahmm... what a noob way

i prefer my

UPDATE `players` SET `redskulltime`=0;

:thumbup:

 

[Bam]

Ahmm... what a noob way

i prefer my

UPDATE `players` SET `redskulltime`=0;

:thumbup:

That way the frags will still remain and the frags on the homepage wont go away either


So yea phpmyadmin and reset the killers table.

 

[Xeikh]

That way the frags will still remain and the frags on the homepage wont go away either


So yea phpmyadmin and reset the killers table.

...

 

[Helga]

Redskulltime thing wont work no, red skull will be removed, but when you get another frag u'll get it back ;P

If i empty the killers table, the death list will be kinda fucked up right?

 

[SpiderOT]

If i empty the killers table, the death list will be kinda fucked up right?

no :thumbup:

 

[Xampy]

Yes, It will delete all the frags and deaths of everybody (last kills subtopic will me empty )...
You must execute this query in phpmyadmin (SQL tab):

UPDATE `killers` SET `unjustified` = 0 WHERE `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = [COLOR="Red"][B]XXXX[/B][/COLOR]);

Change XXXX by the id of the player.

 

[Xexza]

Ahmm... what a noob way

i prefer my

UPDATE `players` SET `redskulltime`=0;

:thumbup:

Your way will just remove the red skulls..