Code:
#include <amxmodx>
#include <sqlx>
#define MYSQL_HOST ""
#define MYSQL_USER ""
#define MYSQL_PASSWORD ""
#define MYSQL_DATABASE ""
#define MYSQL_TABLE ""
new Handle:MYSQL_CONNECTION
/*
Id int
SteamID var unique
Nick var
PlayedTime int
LastSeen int
*/
new Id,
SteamID[32],
Nick[32],
PlayedTime,
LastSeen
public plugin_init()
register_srvcmd("swap", "swap")
public plugin_cfg()
MYSQL_Init()
public MYSQL_Init(){
MYSQL_CONNECTION = SQL_MakeDbTuple(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE)
}
public swap(){
new query[64]
formatex(query, charsmax(query), "SELECT * FROM `%s`", MYSQL_TABLE)
SQL_ThreadQuery(MYSQL_CONNECTION, "DataOutput", query)
}
public DataOutput(failState, Handle:query, error[], errNum){
if(SQL_NumResults(query)){
while(SQL_MoreResults(query)) {
Id = SQL_ReadResult(query, 0)
SQL_ReadResult(query, 1, SteamID, charsmax(SteamID))
SQL_ReadResult(query, 2, Nick, charsmax(Nick))
PlayedTime = SQL_ReadResult(query, 3)
LastSeen = SQL_ReadResult(query, 4)
server_print("Id!%d SteamID!%s Nick!%s PlayedTime!%d LastSeen!%d", Id, SteamID, Nick, PlayedTime, LastSeen)
SQL_NextRow(query)
}
}
}