Gangfight by Redjoker(RoterBaron)

#include a_samp
#include a_mysql

#define SQL_HOST		"127.0.0.1" //Host IP
#define SQL_DB 			"hp" //Host Datenbank
#define SQL_USER 		"root" //Host Name
#define SQL_PASS 		"" //Host Passwort

new Text:GF_Anzeige[MAX_PLAYERS], rjTeam[MAX_PLAYERS], Vagos_Points, Ballas_Points, LCN_Points;

#define rj_Ballas 	0
#define rj_Vagos 	1
#define rj_LCN 		2

enum zoneenum
{
	Float:rjminX,
	Float:rjminY,
	Float:rjmaxX,
	Float:rjmaxY,
	zonecolor
};

#define GF_ZNE 1//Anpassen an die Zonen
new Zone[GF_ZNE];
new StaticZone[GF_ZNE][zoneenum]=
{
	//{MinX, MinY, MaxX, MaxY, Farbe der Zone} nach den Ballas ein , setzen wenn es mehr als 2 sind!
	{-2232.45, 949.1086, -2139.745, 1039.843, 0xA349A466} //Ballas
};

public OnFilterScriptInit()
{
	mysql_connect(SQL_HOST, SQL_USER,SQL_DB, SQL_PASS);
	if(mysql_ping() == 1)
	{
	    mysql_query("CREATE TABLE IF NOT EXISTS `Gangfight` (`Name` varchar(255), `Punkte` int(11), PRIMARY KEY (`Name`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
	    LoadGangs();
		print("\n----------------------------------------------");
		print("Gangfight system by RedJoker(RoterBaron) geladen");
		print("----------------------------------------------\n");
	}
	else
	{
		print("\n----------------------------------------------");
		print("Gangfight system by RedJoker(RoterBaron) nicht geladen");
		print("Überprüfe deine MySQL zugangsdaten");
		print("----------------------------------------------\n");
	}
	for(new i;i<GF_ZNE;i++)
	{
		Zone[i]=GangZoneCreate(StaticZone[i][rjminX],StaticZone[i][rjminY],StaticZone[i][rjmaxX],StaticZone[i][rjmaxY]);
	}
	return 1;
}

public OnFilterScriptExit()
{
	new sql[128];
    format(sql, 128, "UPDATE `Gangfight` SET `Punkte` = '%d' WHERE `Name` = 'Ballas'",Ballas_Points);
    mysql_query(sql);
    format(sql, 128, "UPDATE `Gangfight` SET `Punkte` = '%d' WHERE `Name` = 'Vagos'",Vagos_Points);
    mysql_query(sql);
    format(sql, 128, "UPDATE `Gangfight` SET `Punkte` = '%d' WHERE `Name` = 'LCN'",LCN_Points);
    mysql_query(sql);
    print("Ballas/Vango/LCN wurden gespeichert");
	return 1;
}

public OnPlayerConnect(playerid)
{
	for(new i;i<GF_ZNE;i++)
	{
		GangZoneShowForPlayer(playerid, Zone[i], StaticZone[i][zonecolor]);
	}

	GF_Anzeige[playerid] = TextDrawCreate(2.000000, 100.000000, "Ballas: %d Punkte~n~Vagos: %d Punkte~n~LCN: %d Punkte");
	TextDrawBackgroundColor(GF_Anzeige[playerid], 255);
	TextDrawFont(GF_Anzeige[playerid], 1);
	TextDrawLetterSize(GF_Anzeige[playerid], 0.500000, 1.000000);
	TextDrawColor(GF_Anzeige[playerid], -1);
	TextDrawSetOutline(GF_Anzeige[playerid], 0);
	TextDrawSetProportional(GF_Anzeige[playerid], 1);
	TextDrawSetShadow(GF_Anzeige[playerid], 1);
	TextDrawUseBox(GF_Anzeige[playerid], 1);
	TextDrawBoxColor(GF_Anzeige[playerid], 102);
	TextDrawTextSize(GF_Anzeige[playerid], 161.000000, 34.000000);
	TextDrawHideForPlayer(playerid, GF_Anzeige[playerid]);
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    TextDrawHideForPlayer(playerid, GF_Anzeige[playerid]);
	return 1;
}

public OnPlayerSpawn(playerid)
{
	TextDrawHideForPlayer(playerid, GF_Anzeige[playerid]);
	return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
	new string[64];
    for(new z;z<GF_ZNE;z++)
    {
        if(rjTeam[killerid] == rj_Ballas && rjTeam[playerid] == rj_Vagos && IsPlayerInArea(killerid, StaticZone[z][rjminX], StaticZone[z][rjminY], StaticZone[z][rjmaxX], StaticZone[z][rjmaxY]) || rjTeam[killerid] == rj_Ballas && rjTeam[playerid] == rj_LCN && IsPlayerInArea(killerid, StaticZone[z][rjminX], StaticZone[z][rjminY], StaticZone[z][rjmaxX], StaticZone[z][rjmaxY]))
        {
            Ballas_Points ++;
        }
        if(rjTeam[killerid] == rj_Vagos && rjTeam[playerid] == rj_Ballas && IsPlayerInArea(killerid, StaticZone[z][rjminX], StaticZone[z][rjminY], StaticZone[z][rjmaxX], StaticZone[z][rjmaxY]) || rjTeam[killerid] == rj_Vagos && rjTeam[playerid] == rj_LCN && IsPlayerInArea(killerid, StaticZone[z][rjminX], StaticZone[z][rjminY], StaticZone[z][rjmaxX], StaticZone[z][rjmaxY]))
        {
            Vagos_Points ++;
        }
        if(rjTeam[killerid] == rj_LCN && rjTeam[playerid] == rj_Ballas && IsPlayerInArea(killerid, StaticZone[z][rjminX], StaticZone[z][rjminY], StaticZone[z][rjmaxX], StaticZone[z][rjmaxY]) || rjTeam[killerid] == rj_LCN && rjTeam[playerid] == rj_Vagos && IsPlayerInArea(killerid, StaticZone[z][rjminX], StaticZone[z][rjminY], StaticZone[z][rjmaxX], StaticZone[z][rjmaxY]))
        {
            LCN_Points ++;
        }
	}
	format(string,sizeof(string), "[Gangfight]Ballas: %d Punkte / Vagos: %d Punkte / LCN: %d Punkte", Ballas_Points, Vagos_Points, LCN_Points);
 	SendClientMessageToAll(0xFFFF00FF, string);
	format(string, sizeof(string), "Ballas: %d Punkte~n~Vagos: %d Punkte~n~LCN: %d Punkte", Ballas_Points, Vagos_Points, LCN_Points);
	TextDrawSetString(GF_Anzeige[playerid], string);
	TextDrawShowForPlayer(playerid, GF_Anzeige[playerid]);
	TextDrawSetString(GF_Anzeige[killerid], string);
	TextDrawShowForPlayer(killerid, GF_Anzeige[killerid]);
	return 1;
}

stock IsPlayerInArea(playerid,Float:minX,Float:minY,Float:maxX,Float:maxY)
{
	new Float:pX,Float:pY,Float:pZ;
	GetPlayerPos(playerid,pX,pY,pZ);
	if(pX >= minX && pX <= maxX && pY >= minY && pY <= maxY) return 1;
	else return 0;
}

stock LoadGangs()
{
	//Ballas
	if(mysql_CheckBallas()==0)
	{
	    mysql_query("INSERT INTO `Gangfight` (Name, Punkte) VALUES ('Ballas', '0')");
	    mysql_query("SELECT `Punkte` FROM `Gangfight` WHERE `Name` = 'Ballas'");
		mysql_store_result();
		new sqlint = mysql_fetch_int();
		mysql_free_result();
		Ballas_Points = sqlint;
		print("Ballas Punkte erstellt und geladen");
	}
	else if(mysql_CheckBallas()==1)
	{
		mysql_query("SELECT `Punkte` FROM `Gangfight` WHERE `Name` = 'Ballas'");
		mysql_store_result();
		new sqlint = mysql_fetch_int();
		mysql_free_result();
		Ballas_Points = sqlint;
		print("Ballas Punkte geladen");
	}
	//Vagos
	if(mysql_CheckVagos()==0)
	{
	    mysql_query("INSERT INTO `Gangfight` (Name, Punkte) VALUES ('Vagos', '0')");
	    mysql_query("SELECT `Punkte` FROM `Gangfight` WHERE `Name` = 'Vagos'");
		mysql_store_result();
		new sqlint = mysql_fetch_int();
		mysql_free_result();
		Vagos_Points = sqlint;
		print("Vagos Punkte erstellt und geladen");
	}
	else if(mysql_CheckVagos()==1)
	{
		mysql_query("SELECT `Punkte` FROM `Gangfight` WHERE `Name` = 'Vagos'");
		mysql_store_result();
		new sqlint = mysql_fetch_int();
		mysql_free_result();
		Vagos_Points = sqlint;
		print("Vagos Punkte geladen");
	}
	//LCN
	if(mysql_CheckLCN()==0)
	{
	    mysql_query("INSERT INTO `Gangfight` (Name, Punkte) VALUES ('LCN', '0')");
	    mysql_query("SELECT `Punkte` FROM `Gangfight` WHERE `Name` = 'LCN'");
		mysql_store_result();
		new sqlint = mysql_fetch_int();
		mysql_free_result();
		LCN_Points = sqlint;
		print("LCN Punkte erstellt und geladen");
	}
	else if(mysql_CheckLCN()==1)
	{
		mysql_query("SELECT `Punkte` FROM `Gangfight` WHERE `Name` = 'LCN'");
		mysql_store_result();
		new sqlint = mysql_fetch_int();
		mysql_free_result();
		LCN_Points = sqlint;
		print("LCN Punkte geladen");
	}
	return 1;
}

stock mysql_CheckBallas()
{
	new Query[128];
	format(Query, sizeof(Query), "SELECT * FROM Gangfight WHERE Name = 'Ballas'");
	mysql_query(Query);
	mysql_store_result();
	return mysql_num_rows();
}

stock mysql_CheckVagos()
{
	new Query[128];
	format(Query, sizeof(Query), "SELECT * FROM Gangfight WHERE Name = 'Vagos'");
	mysql_query(Query);
	mysql_store_result();
	return mysql_num_rows();
}

stock mysql_CheckLCN()
{
	new Query[128];
	format(Query, sizeof(Query), "SELECT * FROM Gangfight WHERE Name = 'LCN'");
	mysql_query(Query);
	mysql_store_result();
	return mysql_num_rows();
}