Czy kod jest prawidłowy? Chcę aby sprawdzał czy nasze steamid jest w bazie, jeśli jest robi x, jeśli nie to y.
/* Plugin generated by AMXX-Studio */
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
#define PLUGIN "Sql"
#define VERSION "1.0"
#define AUTHOR "Ja"
new Handle:g_SqlHandle
new g_Query[512]
new g_Host[] = x
new g_User[] = x
new g_Pass[] = x
new g_Db[] = x
public plugin_init() {
register_plugin(PLUGIN, VERSION, AUTHOR)
set_task(1.0,"sql_init")
}
public sql_init() {
g_SqlHandle = SQL_MakeDbTuple(g_Host,g_User,g_Pass,g_Db)
return PLUGIN_HANDLED
}
public client_putinserver(id) {
new authid[36]
new Data[1]
Data[0] = id
get_user_authid(id,authid,35)
format(g_Query,511,"SELECT * FROM `x` WHERE `steamid` = '%s'",authid)
SQL_ThreadQuery(g_SqlHandle,"register_client",g_Query,Data,1)
return PLUGIN_HANDLED
}
public register_client(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
new id
id = Data[0]
new authid[36]
get_user_authid(id,authid,35)
if(SQL_NumResults(Query) < 1) {
//nie ma jeszcze naszego steamid w bazie
} else {
//nasze steamid jest juz w bazie
}
return PLUGIN_HANDLED
}
public IgnoreHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) {
SQL_FreeHandle(Query)
return PLUGIN_HANDLED
}