y4Xtm6a3

1#include <amxmodx>
2#include <cstrike>
3#include <fun>
4#include <sqlx>
5#include <chatcolor>
6
7new const g_dbUser[] = ""
8new const g_dbPasswd[] = ""
9new const g_dbHost[] = ""
10new const g_dbBase[] = ""
11
12new const g_createQuery[] = "CREATE TABLE IF NOT EXISTS `rs_test` (`count` INT(11) NOT NULL DEFAULT '1', PRIMARY KEY (`count`))"
13
14new Handle:g_SQLTuple
15
16public plugin_init()
17{
18	register_plugin("Rs + MySql", "1.0", "pokibob")
19
20	register_clcmd("say /rs", "resscor")
21	register_clcmd("say /resetscore", "resscor")
22
23	initSQL()
24}
25
26public initSQL()
27{
28	g_SQLTuple = SQL_MakeDbTuple(g_dbHost, g_dbUser, g_dbPasswd, g_dbBase)
29	SQL_ThreadQuery(g_SQLTuple, "threadQueryHandler", g_createQuery)
30}
31
32public writeWeapon(id)
33{
34	if(!is_user_connected(id))
35		return
36	
37	static query[256]
38	formatex(query, charsmax(query), 
39	"UPDATE `rs_test` SET `count` = `count` + 1")
40	SQL_ThreadQuery(g_SQLTuple, "threadQueryHandler", query)
41}
42
43public threadQueryHandler(failState, Handle:query, error[], err, data[], size, Float:querytime)
44{
45	if(failState != TQUERY_SUCCESS)
46	{
47		log_amx("SQL Error: %s", error)
48	}
49}
50
51public resscor(id)
52{
53        if(is_user_connected(id))
54        {
55        	set_user_frags(id, 0)
56        	cs_set_user_deaths(id, 0)
57 		client_print_color(id, Blue, "^4[Инфо] ^1Ваш счёт ^4успешно обнулён^1!")
58		writeWeapon(id)
59	}
60	return PLUGIN_HANDLED
61}