/* Plugin generated by AMXX-Studio */
 
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
 
 
#define PLUGIN "New Plugin"
#define VERSION "1.0"
#define AUTHOR "qKKKJ"
 
new Handle:g_SqlTuple
new g_Error[512]
 
 
 
new kivalasztottip[15]
 
 
 
new Host[]     = "host"
new User[]    = "user"
new Pass[]     = "password"
new Db[]     = "database"
 
public plugin_init() {
	register_plugin(PLUGIN, VERSION, AUTHOR)
 
	register_clcmd("say /leker", "menusssss")
 
	set_task(1.0, "MySql_Init")
	set_task(60.0, "tabla_frissites",_,_,_,"b");
}
public MySql_Init()
{
	g_SqlTuple = SQL_MakeDbTuple(Host,User,Pass,Db)
	new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error))
	if(SqlConnection == Empty_Handle)
		set_fail_state(g_Error)
 
	new Handle:Queries
	Queries = SQL_PrepareQuery(SqlConnection,"CREATE TABLE IF NOT EXISTS szerver_info (ip varchar(32),map varchar(32), jatekosok INT(11))")
 
	if(!SQL_Execute(Queries))
	{
		SQL_QueryError(Queries,g_Error,charsmax(g_Error))
		set_fail_state(g_Error)
 
	}
	SQL_FreeHandle(Queries)
	SQL_FreeHandle(SqlConnection) 
}
public plugin_end()
{
	SQL_FreeHandle(g_SqlTuple)
}
public tabla_frissites()
{
	new szTemp[512]
	new ip[17]
	get_user_ip(0,ip,16,1)
	new map[32]
	get_mapname(map, 31)
 
	format(szTemp,charsmax(szTemp),"UPDATE `szerver_info` SET `map` = '%s', `jatekosok` = '%d' WHERE `szerver_info`.`ip` = '%s';",map, get_playersnum(),ip)
}
public menusssss(id)
{
	new menu = menu_create("Menu neve", "menu_handler")
	menu_additem(menu, "\wIP \ride jon 1 ip", "1", 0);
	menu_additem(menu, "\wIP \ride jon 1 ip", "2", 0);
	menu_additem(menu, "\wIP \ride jon 1 ip", "3", 0);
	menu_setprop(menu, MPROP_EXIT, MEXIT_ALL);
	menu_display(id, menu, 0)
	return PLUGIN_HANDLED;
}
public menu_handler(id, menu, item)
{
	if( item == MENU_EXIT )
	{
		menu_destroy(menu);
		return PLUGIN_HANDLED;
	}
	new data[6],szName[64]
	new acces,callback;
	menu_item_getinfo(menu,item,acces,data,charsmax(data),szName,charsmax(szName),callback)
	new key = str_to_num(data)
	switch(key)
	{
		case 1: {
			kivalasztottip = "ide 1 ip"
			lekeres(id)
		}
		case 2: {
			kivalasztottip = "ide 1 ip"
			lekeres(id)
		}
		case 3:{
			kivalasztottip = "ide 1 ip"
			lekeres(id)
		}
	}
	return PLUGIN_CONTINUE
}
 
 
 
public lekeres(id)
{
	new ErrorCode
	new Error[512]
	new Handle:SqlConnection = SQL_Connect(g_SqlTuple, ErrorCode, Error, 511)
	new Handle:Query = SQL_PrepareQuery(SqlConnection, "SELECT * FROM `szerver_info` WHERE `ip` = '%s'",kivalasztottip)
	if(!SQL_Execute(Query))
	{
		SQL_QueryError(Query, Error, 511)
		set_fail_state(Error)
	}	
	new iRowsFound = SQL_NumRows(Query)
	if(iRowsFound >= 1)
	{
		new map = SQL_FieldNameToNum(Query, "map")
		new ip = SQL_FieldNameToNum(Query, "ip")
		new jatekosok = SQL_FieldNameToNum(Query, "jatekosok")
 
		client_print(id, print_chat, "Szerver ip: %s Map: %s Jatekosok: %s",SQL_ReadResult(Query, ip),SQL_ReadResult(Query, map),SQL_ReadResult(Query, jatekosok))
	}
}