
Spoiler
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
#define PLUGIN "plug"
#define VERSION "1.0"
#define AUTHOR "author"
new Handle:Tuple; // uchwyt dla mysql
public plugin_init() {
register_plugin(PLUGIN, VERSION, AUTHOR)
Tuple = SQL_MakeDbTuple("mysql.cba.pl", "testamxx_cba_pl", "****", "testamxx_cba_pl");
register_clcmd("say /test", "test"); // Wywolanie funkcji test
}
public test()
{
new qCommand[512];
format(qCommand, sizeof qCommand-1, "INSERT INTO test VALUES(NULL, 'Test1', 'Test2');");
SQL_ThreadQuery(Tuple, "SaveHandler", qCommand);
}
public SaveHandler(FailState, Handle:Query, Errorcode, Error[], Data[], DataSize)
{
if(Errorcode){
client_print(0,print_chat, "Blad w zapytaniu: %s [SaveData]", Error)
}
if(FailState == TQUERY_CONNECT_FAILED)
{
client_print(0,print_chat,"Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED)
{
client_print(0,print_chat,"Zapytanie anulowane [SaveData]")
return PLUGIN_CONTINUE
}
return PLUGIN_CONTINUE
}