aiLjWV1p

1#include <amxmodx>
2#include <amxmisc>
3#include <print_color>
4#include <sqlx>
5
6new const SQLINFO[][] = { "db.synhosting.eu", "TuranDR", "Faszombeled12989", "TuranDR" };
7new Handle:g_SqlTuple;
8new g_iQuery[1024];
9#define TABLANEV "ClanMentes"
10enum _:g_eiData{
11	g_ieJoinAccess[64],
12	g_ieInviteAccess[64],
13	g_iePromoteAccess[64],
14	g_ieDemoteAccess[64],
15	g_ieLeader[64],
16	g_ieCoLeader[64],
17	
18}
19new g_sSteamID[32], g_sIP[32], g_sName[32];
20new g_sClanName[128], g_sClanID;
21
22public plugin_init() {
23	register_plugin("Klanrendszer", "0.1", "Turán*");
24	//register_concmd("amx_claninvite", "cmd_clan_invite", ADMIN_ALL, "<Steamid or ip> - STEAMID, IP");
25	register_concmd("amx_clancreate", "cmd_clan_create", ADMIN_ALL, "<name>");
26}
27public plugin_cfg(){
28	g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
29	formatex(g_iQuery, charsmax(g_iQuery), "CREATE TABLE IF NOT EXISTS `ClanMentes` (`ClanName` varchar(512) NOT NULL,`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)")
30	SQL_ThreadQuery(g_SqlTuple,"createTableThread", g_iQuery)
31}
32public createTableThread(FailState, Handle:g_iQuery, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
33	if(FailState == TQUERY_CONNECT_FAILED){
34		set_fail_state("[*HIBA*] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!");
35		return;
36	}
37	else if(FailState == TQUERY_QUERY_FAILED){
38		set_fail_state("[*HIBA*] A LEKERDEZES MEGSZAKADT!");
39		return;
40	}
41	if(Errcode){
42		log_amx("[*HIBA*] PROBLEMA A LEKERDEZESNEL! ( %s )",Error);
43		return;
44	}
45}
46public cmd_clan_create(iId, iLevel, iCid)
47{
48	if(!cmd_access(iId, iLevel, iCid, 1))
49		return PLUGIN_HANDLED;
50	
51	new g_sClanName[128];
52	read_args(g_sClanName, charsmax(g_sClanName));
53	remove_quotes(g_sClanName);
54	
55	if(strlen(g_sClanName) == 0)
56	{
57		console_print(iId, "Nem irtal klan nevet.");
58	}
59	else
60	{
61		sql_clan_create_check(iId);
62	}
63	return PLUGIN_HANDLED;
64}
65public sql_clan_create_check(id)
66{
67	formatex(g_iQuery, charsmax(g_iQuery), "SELECT * FROM `%s` WHERE `ClanName`='%s';",TABLANEV, g_sClanName)
68	new Data[2];
69	Data[0] = id;
70	Data[1] = get_user_userid(id);
71	SQL_ThreadQuery(g_SqlTuple,"sql_clan_create_check_thr", g_iQuery, Data, 2);
72}
73public sql_clan_create_check_thr(FailState, Handle:Query, Error[], Errcode,Data[], DataSize){
74	if(FailState == TQUERY_CONNECT_FAILED){
75		set_fail_state("[*HIBA*] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!");
76		return;
77	}
78	else if(FailState == TQUERY_QUERY_FAILED){
79		set_fail_state("[*HIBA*] A LEKERDEZES MEGSZAKADT!");
80		return;
81	}
82	if(Errcode){
83		log_amx("[*HIBA*] PROBLEMA A LEKERDEZESNEL! ( %s )",Error);
84		return;
85	}
86	new id = Data[0];
87	if (Data[1] != get_user_userid(id))
88		return;
89	new RowsFound = SQL_NumRows(Query);
90	if(RowsFound > 0){
91		console_print(id, "Ez a klan mar letezik.");
92	}
93	else{
94		sql_clan_create_insert(id);
95	}
96}
97public sql_clan_create_insert(id){
98	
99	formatex(g_iQuery, charsmax(g_iQuery), "INSERT INTO `%s` (`ClanName`) VALUES('%s')",TABLANEV, g_sClanName);
100	new Data[2];
101	Data[0] = id;
102	Data[1] = get_user_userid(id);
103	SQL_ThreadQuery(g_SqlTuple,"sql_clan_create_insert_thr", g_iQuery, Data, 2);
104}
105public sql_clan_create_insert_thr(FailState, Handle:Query, Error[], Errcode, Data[], DataSize){
106	if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED){
107		log_amx("%s", Error);
108		return;
109	}
110	new id = Data[0];
111	console_print(id, "Sikeresen letrehoztad a klant");
112	return;
113}
114public plugin_end(){
115	SQL_FreeHandle(g_SqlTuple);
116}