Hey guys!
I need some help, I have a rank system which is connected to a mysql database.
The thing I need help with, is to reset certain coulumns in the mysql table.
Lets say for example I have these tables: kills, deaths, rounds. And I want to set the "kills" and "deaths" for everyone who is stored in the database to 0.
How can I do this through a plugin?
I tried these:
PHP Code:
SQL_ThreadQuery(g_sql_tuple, "qh_IgnoreHandle", "UPDATE `rank_system` SET `kills=NULL`,`deaths=NULL`;");
PHP Code:
SQL_ThreadQuery(g_sql_tuple, "qh_IgnoreHandle", "EMPTY FROM `rank_system` WHERE `kills=NULL`,`deaths=NULL`;");
PHP Code:
SQL_ThreadQuery(g_sql_tuple, "qh_IgnoreHandle", "DELETE FROM `rank_system` WHERE `kills=NULL`,`deaths=NULL`;");
But it doesnt affect any of the players' score.
I really appreciate some help!