próbuje napisać plugin, który wymaga połączenia z bazą danych, lecz nie wychodzi mi
mój kod
#include <amxmodx> #include <amxmisc> #include <sqlx> #define PLUGIN "booyaka test" #define AUTHOR "booyaka" #define VERSION "0.1" #define szHost "86.***.***.***" #define szUser "t*****" #define szPass "******" #define szDB "t*****" new Handle:g_hTuple; new Handle:query new Handle:hConnection public plugin_init() { new iError, szError[ 128 ]; register_plugin(PLUGIN, VERSION, AUTHOR) register_clcmd("say", "HandleSay", 0, "N/A") g_hTuple = SQL_MakeDbTuple( szHost, szUser, szPass, szDB ); hConnection = SQL_Connect( g_hTuple, iError, szError, 127 ); if( hConnection == Empty_Handle ) { log_amx("nie dziala") } } public HandleSay(id) { new args[256] read_argv(1, args, 256) if(containi(args, "/karol")!=-1 || containi(args, "/ja")!=-1) { log_amx("komenda dziala") Handle:query = SQL_PrepareQuery(hConnection, "CREATE TABLE `dziala_amx`( nr LONG, dane CHAR)") SQL_Execute(query) SQL_FreeHandle(query) return PLUGIN_HANDLED } }
konsola
L 10/13/2009 - 14:44:05: Info (map "de_corruption_cz") (file "addons/amxmodx/logs/error_20091013.log") L 10/13/2009 - 14:44:05: [MySQL] Invalid database handle: 0 L 10/13/2009 - 14:44:05: [AMXX] Run time error 10 (plugin "2.amxx") (native "SQL_PrepareQuery") - debug not enabled! L 10/13/2009 - 14:44:05: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes). L 10/13/2009 - 14:44:07: [MySQL] Invalid database handle: 0 L 10/13/2009 - 14:44:07: [AMXX] Run time error 10 (plugin "2.amxx") (native "SQL_PrepareQuery") - debug not enabled! L 10/13/2009 - 14:44:07: [AMXX] To enable debug mode, add "debug" after the plugin name in plugins.ini (without quotes). L 10/13/2009 - 14:46:14: Start of error session. L 10/13/2009 - 14:46:14: Info (map "de_corruption_cz") (file "addons/amxmodx/logs/error_20091013.log") L 10/13/2009 - 14:46:14: [MySQL] Invalid database handle: 0 L 10/13/2009 - 14:46:14: [AMXX] Displaying debug trace (plugin "2.amxx") L 10/13/2009 - 14:46:14: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery") L 10/13/2009 - 14:46:14: [AMXX] [0] 2.sma::HandleSay (line 39)
konsola 2
10/13/2009 - 14:51:51: -------- Mapchange to de_corruption_cz -------- L 10/13/2009 - 14:52:07: [2.amxx] nie dziala L 10/13/2009 - 14:52:08: [admin.amxx] Login: "booyaka<1><VALVE_ID_LOOPBACK><>" became an admin (account "loopback") (access "bcdefghijklmnopqrstu") (address "loopback") L 10/13/2009 - 14:52:14: [admin.amxx] Login: "booyaka<1><VALVE_ID_LOOPBACK><>" became an admin (account "loopback") (access "bcdefghijklmnopqrstu") (address "loopback") L 10/13/2009 - 14:52:14: [amxbans.amxx] [AMXBANS] Nie zaladowano przyczyn banow z bazy danych. Satyczne przyczyny banowa zostaly zaladowane L 10/13/2009 - 14:52:14: [amxbans.amxx] [AMXBANS] AMXBans 5.0 jest online L 10/13/2009 - 14:52:41: [2.amxx]komenda dzialadane w #define podaje NA PEWNO dobrze, nie wiem dlaczego to nie działa
proszę o pomoc