Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #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;
- }
- public OnPlayerCommandText(playerid, cmdtext[])
- {
- if (strcmp("/savegf", cmdtext, true, 10) == 0)
- {
- if(IsPlayerAdmin(playerid))return SendClientMessage(playerid,0xFFFF00FF,"Du bist nicht RCON online");
- {
- 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);
- SendClientMessage(playerid,0xFFFF00FF,"[Gangfight] erfolgreich Gespeichert");
- }
- return 1;
- }
- return 0;
- }
- 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_CheckVagos()
- {
- return mysql_query("SELECT * FROM Gangfight WHERE Name = 'Vagos'");
- }
- stock mysql_CheckBallas()
- {
- return mysql_query("SELECT * FROM Gangfight WHERE Name = 'Ballas'");
- }
- stock mysql_CheckLCN()
- {
- return mysql_query("SELECT * FROM Gangfight WHERE Name = 'LCN'");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement