#include <amxmodx>
#include <sqlx>
new Handle:SqlConnection
#define CREATE_DB "CREATE TABLE IF NOT EXISTS `test` (`id` INT(12) NOT NULL AUTO_INCREMENT PRIMARY KEY ,`szMapName` VARCHAR(255) NOT NULL ,`Name` VARCHAR(255) NOT NULL ,`SteamID` VARCHAR(30) NOT NULL ,`IP` VARCHAR(30) NOT NULL ,`Data` date NOT NULL default '0000-00-00',`Czas` time NOT NULL default '00:00:00')"
#define IMPORRT_DB "INSERT INTO `test` (szMapName,Name,SteamID,IP,Data,Czas) VALUES ('%s','%s','%s','%s','%s','%s')"
#define szHost "--"
#define szUser "--"
#define szPass "--"
#define szDb "--"
public plugin_cfg ( )
{
SqlConnection = SQL_MakeDbTuple(szHost,szUser,szPass,szDb)
new QueryCache[1024]
formatex(QueryCache,1023,CREATE_DB)
SQL_ThreadQuery(SqlConnection,"QueryCreateTable",QueryCache)
}
public client_authorized(id)
{
new query[1001]
format(query,1000,IMPORRT_DB,szMapName,Name,SteamID,IP,Data,Czas)
SQL_ThreadQuery(SqlConnection,"QueryCreateTable",query)
return PLUGIN_CONTINUE;
}
public plugin_end()
{
SQL_FreeHandle(SqlConnection);
}
public QueryCreateTable(iFailState,Handle:hQuery,szError[],iError,iData[],iDataSize,Float:flQueueTime)
{
switch(iFailState)
{
case TQUERY_CONNECT_FAILED:
{
log_amx("Blad nie mozna polaczyc sie z baza (%i): %s", iError, szError);
}
case TQUERY_QUERY_FAILED:
{
log_amx("Blad nie mozna stworzyc tabelki() (%i): %s", iError, szError);
}
default:
{
/*Stworzono tabelke*/
}
}
}
Oczywiście pominąlem fragmenty z wyciąganiem danych gracza.