[andrzN]

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!

[Phant]

Why not TRUNCATE TABLE?

[wickedd]

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", "UPDATE `rank_system` SET `kills` = 0,`deaths` = 0;"); 


[Bugsy]

You are enclosing the field AND value in quotes, you should only enclose the field; it should be 'Field'=NULL, not 'Field=NULL'. Quotes aren't really needed at all, unless there are spaces in the field, but that's not a good naming practice to begin with.

UPDATE `rank_system` SET `kills=NULL`,`deaths=NULL`;");

UPDATE `rank_system` SET `kills'=NULL,`deaths'=NULL;");