public create_klass(id) { if(g_boolsqlOK) { if(!is_user_bot(id) && database_user_created[id]==0) { new name[64] new ip[64] new sid[64] get_user_name(id,name,63) replace_all ( name, 63, "'", "Q" ) replace_all ( name, 63, "`", "Q" ) get_user_ip ( id, ip, 63, 1 ) get_user_authid(id, sid ,63) log_to_file("addons/amxmodx/logs/test_log.log","*** %s %s *** Create Class ***",name,sid) for(new i=1;i<28;i++) { new q_command[512] format(q_command,511,"INSERT INTO `%s` (`nick`,`ip`,`sid`,`klasa`,`lvl`,`exp`) VALUES ('%s','%s','%s',%i,%i,%i ) ",g_sqlTable,name,ip,sid,i,srv_avg[i],LevelXP[srv_avg[i]-1]) SQL_ThreadQuery(g_SqlTuple,"create_klass_Handle",q_command) } database_user_created[id]=1 } } else sql_start() } public create_klass_Handle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { // lots of error checking if(Errcode) { log_to_file("addons/amxmodx/logs/diablo.log","Error on create klass 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","create klass Query failed.") return PLUGIN_CONTINUE } return PLUGIN_CONTINUE } public load_xp(id) { if(g_boolsqlOK /*&& */) { if(!is_user_bot(id)) { new name[64] new data[1] data[0]=id if(get_cvar_num("diablo_sql_save")==0) { get_user_name(id,name,63) replace_all ( name, 63, "'", "Q" ) replace_all ( name, 63, "`", "Q" ) new q_command[512] format(q_command,511,"SELECT `klasa` FROM `%s` WHERE `nick`='%s' ",g_sqlTable,name) SQL_ThreadQuery(g_SqlTuple,"SelectHandle",q_command,data,1) } else if(get_cvar_num("diablo_sql_save")==1) { get_user_ip(id, name ,63,1) new q_command[512] format(q_command,511,"SELECT `klasa` FROM `%s` WHERE `ip`='%s' ",g_sqlTable,name) SQL_ThreadQuery(g_SqlTuple,"SelectHandle",q_command,data,1) } else if(get_cvar_num("diablo_sql_save")==2) { get_user_authid(id, name ,63) new q_command[512] format(q_command,511,"SELECT `klasa` FROM `%s` WHERE `sid`='%s' ",g_sqlTable,name) SQL_ThreadQuery(g_SqlTuple,"SelectHandle",q_command,data,1) } loaded_xp[id]=1 } } else sql_start() }
Myślę , że znajdzie się ktoś kto pomoże