/*
		Filterscript by Maurice.
		Bitte benutzt es nicht als euers
		In SQLlite umgeschrieben
		von Azure Jr. / Exod_Martinez
*/
#include <a_samp>
#include <ocmd>

new DB:logs;

enum SPAM
{
	pCmdspam,
	pChatspam,
	pChatmuted
}
new Spam[MAX_PLAYERS][SPAM];
forward ChatSpam(playerid);

public OnFilterScriptInit()
{
	print("\n--------------------------------------");
	print("Anti Spam / CMD + Log system by Maurice.");
	print("--------------------------------------\n");
	logs = db_open("logs");
	db_query(logs,"CREATE TABLE IF NOT EXISTS `logs` (`id` int(11)  AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
	db_query(logs,"ALTER TABLE `logs` ADD `Name` varchar(64)");
	db_query(logs,"ALTER TABLE `logs` ADD `Grund` varchar(64)");
	db_query(logs,"ALTER TABLE `logs` ADD `Datum` varchar(64)");
	db_query(logs,"ALTER TABLE `logs` ADD `Uhrzeit` varchar(64)");

	return 1;
}

public OnFilterScriptExit()
{
	return 1;
}

public OnPlayerText(playerid, text[])
{
	new name[40];
	GetPlayerName(playerid,name,sizeof(name));
	Spam[playerid][pChatspam]++;
	if(Spam[playerid][pChatspam] == 3)
    {
        new pID,Grund[128] = "Chat-Spam",query[128];
		new name2[MAX_PLAYER_NAME];
		Spam[playerid][pChatmuted] = 1;
		GetPlayerName(pID,name2,sizeof(name2));
		LogsSpeichern(name2,Grund);
		SendClientMessage(playerid,-1,"CHAT SPAM 3/3");
		format(query,sizeof(query),"INSERT TO logs (Grund) VALUES ('%s')",Grund);
		db_query(logs,query);
	    Kick(playerid);
	   	return 0;
	}
	if(Spam[playerid][pChatmuted]==1)
	{
	    SendClientMessage(playerid,-1,"Du hast gespamt du kannst erst in 1-2 Minuten wieder schreiben.");
		SetTimerEx("ChatSpam",15000,0,"i",playerid);
	}
	return 1;
}

public ChatSpam(playerid)
{
	Spam[playerid][pChatmuted] = 0;
	return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
	new name[40];
	GetPlayerName(playerid,name,sizeof(name));
	Spam[playerid][pCmdspam]++;
	if(Spam[playerid][pCmdspam] == 3)
    {
    	new pID,Grund[128] = "CMD-Spam",query[128];
		new name2[MAX_PLAYER_NAME];
		Spam[playerid][pChatmuted] = 1;
		GetPlayerName(pID,name2,sizeof(name2));
		LogsSpeichern(name2,Grund);
		SendClientMessage(playerid,-1,"CMD SPAM 3/3");
		format(query,sizeof(query),"INSERT TO logs (Grund) VALUES ('%s')",Grund);
		db_query(logs,query);
	    Kick(playerid);
	    return 0;
    }
    if(Spam[playerid][pChatmuted]==1)
	{
	    SendClientMessage(playerid,-1,"Du hast gespamt du kannst erst in 1-2 Minuten wieder schreiben.");
		SetTimerEx("ChatSpam",15000,0,"i",playerid);
	}
	return 0;
}

ocmd:kick(playerid,params[])
{
	new pID,Grund[128] = "Kick",query[128];
	new name2[MAX_PLAYER_NAME];
	GetPlayerName(pID,name2,sizeof(name2));
	LogsSpeichern(name2,Grund);
	format(query,sizeof(query),"INSERT TO logs (Grund) VALUES ('%s')",Grund);
	db_query(logs,query);
	return 1;
}

ocmd:ban(playerid,params[])
{
	new pID,Grund[128] = "Ban",query[128];
	new name2[MAX_PLAYER_NAME];
	GetPlayerName(pID,name2,sizeof(name2));
	LogsSpeichern(name2,Grund);
	format(query,sizeof(query),"INSERT TO logs (Grund) VALUES ('%s')",Grund);
	db_query(logs,query);
	return 1;
}

stock LogsSpeichern(name[MAX_PLAYER_NAME],grund[128])
{
	new date[14],time[8];
	new th,tm,ts,dy,dm,dd;
	getdate(dy,dm,dd);
	format(date,sizeof(date),"%02d.%02d.%02d",dd,dm,dy);
	gettime(th,tm,ts);
	format(time,sizeof(time),"%02d:%02d:%02d",th,tm,ts);
	new query[512];
	format(query,sizeof(query),"INSERT INTO logs (Name,Grund,Datum,Uhrzeit) VALUES ('%s','%s','%s','%s')",	name,	grund,	date,	time);
	db_query(logs,query);
	return 1;
}