how to mass reset player variable

[daim 6]

Hi there,

 

Is there any way to MASS reset players variables. For example i would like to reset KILL variable in pvp ghost npc script to default = 0 whithout needs player online.

 

let say 10 player attached with KILL variable, i needs to reset KILL to all player without they online.

 

is this posibble?

[Angelmelody 221]

addrid(0); //attached all onine players , you have to install addrid command

KILL variable = 0; // reset all online players' varaible

query_sql ("UPDATE `char_reg_num_db` SET  `value` =0 WHERE  `key` = 'KILL variable' " ); //reset offline players' variable

Edited November 19, 2014 by Angelmelody

[Zeiyan 4]

DELETE FROM `char_reg_num_db` WHERE `key` = "KILL";DELETE FROM `char_reg_num_db` WHERE `key` = "Death";DELETE FROM `char_reg_num_db` WHERE `key` = "KillingStreak";DELETE FROM `char_reg_num_db` WHERE `key` = "MultiKill";DELETE FROM `char_reg_num_db` WHERE `key` = "KillingSpree";DELETE FROM `char_reg_num_db` WHERE `key` = "Dominating";DELETE FROM `char_reg_num_db` WHERE `key` = "MegaKill";DELETE FROM `char_reg_num_db` WHERE `key` = "Unstoppable";DELETE FROM `char_reg_num_db` WHERE `key` = "WickedSick";DELETE FROM `char_reg_num_db` WHERE `key` = "MonsterKill";DELETE FROM `char_reg_num_db` WHERE `key` = "Godlike";DELETE FROM `char_reg_num_db` WHERE `key` = "BeyondGodlike";DELETE FROM `char_reg_num_db` WHERE `key` = "DoubleKill";DELETE FROM `char_reg_num_db` WHERE `key` = "TripleKill";DELETE FROM `char_reg_num_db` WHERE `key` = "UltraKill";DELETE FROM `char_reg_num_db` WHERE `key` = "Rampage";DELETE FROM `char_reg_num_db` WHERE `key` = "Ownage";DELETE FROM `char_reg_num_db` WHERE `key` = "NemesisKill";DELETE FROM `char_reg_num_db` WHERE `key` = "FeedCount";

This is what i use to clean my pvp table (using ghost's pvp script)

[daim 6]

addrid(0); //attached all onine players , you have to install addrid command

KILL variable = 0; // reset all online players' varaible

query_sql ("UPDATE `char_reg_num_db` SET  `value` =0 WHERE  `key` = 'KILL variable' " ); //reset offline players' variable

thanks. This made handy.