public SaveXP(id) { if(g_boolsqlOK) { if(!is_user_bot(id) && player_xp[id]!=player_xp_old[id]) { 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) if(get_cvar_num("diablo_sql_save")==0) { new q_command[512] new kl[4] new klucz[65] = "klasy" switch(player_class[id]){ case 1: kl = "1__" case 2: kl = "2__" case 3: kl = "3__" case 4: kl = "4__" case 5: kl = "5__" case 6: kl = "6__" case 7: kl = "7__" case 8: kl = "8__" case 9: kl = "9__" case 10: kl = "10_" case 11: kl = "11_" case 12: kl = "12_" case 13: kl = "13_" case 14: kl = "14_" case 15: kl = "15_" case 16: kl = "16_" case 17: kl = "17_" case 18: kl = "18_" case 19: kl = "19_" case 20: kl = "20_" case 21: kl = "21_" case 22: kl = "22_" case 23: kl = "23_" case 24: kl = "24_" case 25: kl = "25_" case 26: kl = "26_" case 27: kl = "27_" case 28: kl = "28_" } strcat(klucz,kl,65) strcat(klucz,name,65) // client_print(id,print_console,"klucz %s", klucz) format(q_command,511,"UPDATE `%s` SET `ip`='%s',`sid`='%s',`lvl`='%i',`exp`='%i',`str`='%i',`int`='%i',`dex`='%i',`agi`='%i' WHERE `nick`='%s' AND `klasa`='%i' ",g_sqlTable,ip,sid,player_lvl[id],player_xp[id],player_strength[id],player_intelligence[id],player_dextery[id],player_agility[id],name,player_class[id], player_timestamp[id]) SQL_ThreadQuery(g_SqlTuple,"Save_xp_handle",q_command) } player_xp_old[id]=player_xp[id] } } else sql_start() return PLUGIN_HANDLED } public Save_xp_handle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { if(Errcode) { log_to_file("addons/amxmodx/logs/diablo.log","Error on Save_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","Save_xp Query failed.") return PLUGIN_CONTINUE } return PLUGIN_CONTINUE }