Szevasztok annyi lenne a gond a pluginnal hogy tábla rész ilyesmi müködik. viszont ha valaki fent van a szerveren mindegy mit ir be eljön ez az 1 hiba
Kód: L 10/13/2015 - 10:16:49: [chat_log_sql.amxx] Chat log SQL: Query failed L 10/13/2015 - 10:16:49: [chat_log_sql.amxx] Chat log SQL: Query failed L 10/13/2015 - 10:16:49: [chat_log_sql.amxx] Chat log SQL: Query failed L 10/13/2015 - 10:16:50: [chat_log_sql.amxx] Chat log SQL: Query failed
és forditonál is jelez 1 hibát
Kód: AMX Mod X Compiler 1.8.3-manual Copyright (c) 1997-2006 ITB CompuPhase Copyright (c) 2004-2013 AMX Mod X Team
Modified for www.Freakz.ro / amx.freakz.ro
chat_log_sql.sma(157) : warning 225: unreachable code Header size: 904 bytes Code size: 4244 bytes Data size: 21044 bytes Stack/heap size: 16384 bytes; estimated max. usage=1301 cells (5204 bytes) Total requirements: 42576 bytes
1 Warning. Done.
Kód: #include <amxmodx> #include <amxmisc> #include <cstrike> #include <sqlx>
#define PLUGINNAME "Chat Logger SQL" #define VERSION "0.8b" #define AUTHOR "naputtaja" #define table "amx_chat_log" #define MAXLEN 511 #define MAX_WORDS 150
#pragma tabsize 0
// SQL Settings new log_db new log_sql new log_user new log_pass public plugin_init() { register_plugin(PLUGINNAME, VERSION, AUTHOR) register_cvar("amx_chat_logger",VERSION,FCVAR_SERVER|FCVAR_EXTDLL|FCVAR_UNLOGGED|FCVAR_SPONLY) log_sql = register_cvar("amx_log_sql","") log_user = register_cvar("amx_log_user","") log_pass = register_cvar("amx_log_pass","") log_db = register_cvar("amx_log_db","")
register_clcmd("say", "chat_log_sql") register_clcmd("say_team", "chat_log_sql") readList() set_task(0.1, "check_sql") return PLUGIN_CONTINUE }
new Handle:g_SqlX new Handle:g_SqlConnection new g_error[512] new g_No_Save_Words[MAX_WORDS][20] new g_No_Save_Num
new const TEAMNAME[_:CsTeams][] = {"*DEAD*", "(Terrorist)", "(Counter-Terrorist)", "*SPEC*"}
public check_sql() { new host[64], user[64], pass[64], db[64],errorcode
get_pcvar_string(log_sql,host,63) get_pcvar_string(log_user, user, 63) get_pcvar_string(log_pass, pass, 63) get_pcvar_string(log_db, db, 63)
g_SqlX = SQL_MakeDbTuple(host, user, pass, db) g_SqlConnection = SQL_Connect(g_SqlX,errorcode,g_error,511); if (!g_SqlConnection) { console_print(0,"Chat log SQL: Could not connect to SQL database.!") return log_amx("Chat log SQL: Could not connect to SQL database.") } new query_create[1001] format(query_create,1000,"CREATE TABLE IF NOT EXISTS `%s`(`id` int(11) NOT NULL auto_increment,`name` varchar(100) NOT NULL default '',`authid` varchar(100) NOT NULL default '',`ip` varchar(100) NOT NULL default '',`alive` int(11) NOT NULL default '0', `team` varchar(100) NOT NULL default '',`date` date NOT NULL default '0000-00-00',`time` time NOT NULL default '00:00:00',`cmd` varchar(100) NOT NULL default '',`message` text NOT NULL,PRIMARY KEY (`id`));",table) SQL_ThreadQuery(g_SqlX,"QueryHandle",query_create) console_print(0,"[AMXX SQL] Connected!") return PLUGIN_CONTINUE }
public chat_log_sql(id) { if(is_user_bot(id)) return
static datestr[11] new authid[16],name[32],ip[16],timestr[9] new cmd[9] if(!is_user_connected(id)) return read_argv(0,cmd,8) new message[192] read_args(message,191) remove_quotes(message) new i = 0 while ( i < g_No_Save_Num ) { if ( containi ( message, g_No_Save_Words[i++] ) != -1 )return }
new CsTeams:team = cs_get_user_team(id) get_user_authid(id,authid,15) get_user_name(id,name,31) get_user_ip(id, ip, 15, 1) get_time("%Y.%m.%d", datestr, 10) get_time("%H:%M:%S", timestr, 8)
new query[1001] format(query,1000,"INSERT into %s (name,authid,ip,alive,team,date,time,message,cmd) values ('%s','%s','%s','%d','%s','%s','%s','%s','%s')",table,name,authid,ip,is_user_alive(id),TEAMNAME[_:team],datestr,timestr,message,cmd) SQL_ThreadQuery(g_SqlX,"QueryHandle",query) }
public QueryHandle(FailState,Handle:Query,Error[],Errcode,Data[],DataSize) { if(FailState == TQUERY_CONNECT_FAILED) return log_amx("Chat log SQL: Could not connect to SQL database.") else if(FailState == TQUERY_QUERY_FAILED) return log_amx("Chat log SQL: Query failed") if(Errcode) return log_amx("Chat log SQL: Error on query: %s",Error) new DataNum while(SQL_MoreResults(Query)) { DataNum = SQL_ReadResult(Query,0) server_print("zomg, some data: %s",DataNum) SQL_NextRow(Query) } return PLUGIN_CONTINUE }
readList() { new Configsdir[64] new NoSaveWords_file[64] get_configsdir( Configsdir, 63 ) format(NoSaveWords_file, 63, "%s/ChatLoggerSQL_NoSaveWords.ini", Configsdir ) if ( !file_exists(NoSaveWords_file) ) { return log_amx("Chat log SQL: ChatLoggerSQL_NoSaveWords.ini File not found") server_print ( "====================================================================" ) server_print ( "[Chat Logger Sql] loaded ChatLoggerSQL_NoSaveWords.ini File not found", g_No_Save_Num ) server_print ( "====================================================================" ) } new len, i=0 while( i < MAX_WORDS && read_file( NoSaveWords_file, i , g_No_Save_Words[g_No_Save_Num], 19, len ) ) { i++ if( g_No_Save_Words[g_No_Save_Num][0] == ';' || len == 0 ) continue g_No_Save_Num++ } i=0 server_print ( "======================================================" ) server_print ( "[Chat Logger Sql] loaded %d No Save words", g_No_Save_Num ) server_print ( "======================================================" ) return PLUGIN_CONTINUE } public plugin_end() { if (g_SqlConnection) SQL_FreeHandle(g_SqlConnection) return; }
|