/*
		Filterscript by Maurice.
		Bitte benutzt es nicht als euers
*/
#include <a_samp>
#include <a_mysql>
#include <ocmd>
#include <sscanf2>

#define SQL_HOST   ""
#define SQL_USER   ""
#define SQL_PASS   ""
#define SQL_DATA   ""


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");
	MySQL_Connect();
	mysql_query("CREATE TABLE IF NOT EXISTS `logs` (`id` int(11)  AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
	mysql_query("ALTER TABLE `logs` ADD `Name` varchar(64)");
	mysql_query("ALTER TABLE `logs` ADD `Grund` varchar(64)");
	mysql_query("ALTER TABLE `logs` ADD `Datum` varchar(64)");
	mysql_query("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);
		mysql_query(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);
		mysql_query(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);
	mysql_query(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);
	mysql_query(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);
	mysql_query(query);
	return 1;
}

stock MySQL_Connect()
{
    mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(mysql_ping() == 1)
    {
        print("Verbindung zur Datenbank wurde erfolgreich hergestellt!");
        return true;
    }
    else
    {
        print("Es konnte keine Verbindung zur Datenbank hergestellt werden!");
        print("Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
        mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
        if(mysql_ping() == 1)
        {
            print("Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
            return true;
        }
        else
        {
            print("Es konnte keine Verbindung zur Datenbank hergestellt werden!");
            print("Der Server wird nun beendet!");
            SendRconCommand("exit");
            return true;
        }
    }
}