Moduły i rzeczy typu dostęp itd są poprawne.
/* Plugin generated by AMXX-Studio */ #include <amxmodx> #include <amxmisc> #include <engine> #include <fakemeta> #include <cstrike> #include <fun> #include <fakemeta_util> #include <fakemeta> #include <sqlx> #include <csx> #include <hamsandwich> #include <colorchat> #include <xs> #include <tutorek> #include <vault> #define PLUGIN "New Plug-In" #define VERSION "1.0" #define AUTHOR "KariiO" new wybrana_klasa[33] new sqlstart new g_SqlTuple new opis_klasy[512] public plugin_init() { register_plugin(PLUGIN, VERSION, AUTHOR) register_clcmd("say test","test") register_cvar("diablo_sql_host","localhost",FCVAR_PROTECTED) register_cvar("diablo_sql_user","root",FCVAR_PROTECTED) register_cvar("diablo_sql_pass","root",FCVAR_PROTECTED) register_cvar("diablo_sql_database","dbmod",FCVAR_PROTECTED) register_cvar("diablo_sql_tableopisy","dbmod",FCVAR_PROTECTED) sql_start() } new Race[8][18] = { "Brak", "Lowca", "Barbarzynca", "Bandyta", "Asasyn", "Vampir", "Zabojca", "Straznik"} public sql_start() { if(sqlstart<0) return sqlstart=1 new host[128] new user[64] new pass[64] new database[64] get_cvar_string("diablo_sql_database",database,63) get_cvar_string("diablo_sql_host",host,127) get_cvar_string("diablo_sql_user",user,63) get_cvar_string("diablo_sql_pass",pass,63) g_SqlTuple = SQL_MakeDbTuple(host,user,pass,database) new g_sqlTable[64] = "dbmod_tables" get_cvar_string("diablo_sql_tableopisy",g_sqlTable,63) new q_command[512] for(new i;i<8;i++) format(q_command,511,"CREATE TABLE IF NOT EXISTS `OPISY` ( `%s` VARCHAR( 512 ), DEFAULT 1, `opis` VARCHAR( 512 ), DEFAULT 1) ",Race[i]) SQL_ThreadQuery(g_SqlTuple,"TableHandle",q_command) } public load_xp(id) { if(!is_user_bot(id)) { new name[64] new data[1] data[0]=id new q_command[512] format(q_command,511,"SELECT * FROM `OPISY` WHERE `%s`='%s' ",Race[wybrana_klasa[id]],name) SQL_ThreadQuery(g_SqlTuple,"SelectHandle",q_command,data,1) } else sql_start() } public SelectHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { if(Errcode) { log_to_file("addons/amxmodx/logs/diablo.log","Error on load_xp query: %s",Error) } if(FailState == TQUERY_CONNECT_FAILED) { log_to_file("addons/amxmodx/logs/diablo.log","Could not connect to SQL database.") return PLUGIN_CONTINUE } else if(FailState == TQUERY_QUERY_FAILED) { log_to_file("addons/amxmodx/logs/diablo.log","load_xp Query failed.") return PLUGIN_CONTINUE } new id=Data[0] new i,p new klasy = 8-1 while(SQL_MoreResults(Query)) { i = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "klasa")) if (i>klasy) break opis_klasy[id]= SQL_ReadResult(Query,SQL_FieldNameToNum(Query, "opis")) SQL_NextRow(Query) } return PLUGIN_CONTINUE } public test(id) client_print(id,print_chat,"Test: %s,%i",opis_klasy[id],opis_klasy[id])