Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <a_samp>
- #include <time>
- #include <sscanf2>
- #include <a_mysql>
- #include <zcmd>
- #include <streamer>
- //basejumps 1-16
- //befehle wie /spawn /kill usw
- //countdown
- //login Register Admin System Mysql + Timeban /unban usw usw
- ///ban (playerid) (minutes) (hours) (days) (reason - optional
- //baseJUmps mapps
- #define SERVER_NAME "Base Jump"
- #define BefehlFalsch "Diesen Befehl gibt es nicht."
- #define SERVER_MAP "German Map"
- #define SERVER_WEBSITE "www.google.de"
- //Msql
- #define SQL_HOST "connect.free-db.de"
- #define SQL_USER "d01898bf"
- #define SQL_PASS "SrXL6b9QXnAuJBd9"
- #define SQL_DB "d01898bf"
- //
- // Farben
- #define COLOR_GRAU 0xAFAFAFAA
- #define COLOR_GRUEN 0x33AA33AA
- #define COLOR_ROT 0xFF0000AA
- #define COLOR_GELB 0xFFFF00AA
- #define COLOR_PINK 0xFF66FFAA
- #define COLOR_BLAU 0x3A47DEFF
- #define COLOR_PURPLE 0x800080AA
- #define COLOR_WEISS 0xFFFFFFAA
- #define COLOR_HELLBLAU 0x33CCFFAA
- #define COLOR_ORANGE 0xFF9900AA
- #define COLOR_SCHWARZ 0x00000000
- #define COLOR_DGRAU 0x696969FF
- #define COLOR_GELB 0xFFFF00AA
- #define WARNING (20) )
- #define WARNING_LIMIT (10000)
- #define Blue "{003DF5}"
- #define Red "{FF0000}"
- #define Green "{66FF00}"
- #define White "{FFFFFF}"
- #define DIALOG_REGISTER 100
- #define MAX_HOUSES 100
- #define DIALOG_LOGIN 101
- #define DIALOG_POS 102
- new randommessages[][]=
- {
- "Nachricht1.",
- "hihahalllo.",
- "Werbung",
- "Test",
- "2.",
- "3",
- "4"
- };
- enum pInfo
- {
- pScore,
- pMoney,
- pLevel,
- pVIP,
- pKMA,
- pRank,
- pKills,
- pDeaths,
- pMuted,
- pJailed,
- pFrozen,
- pMutedTimes,
- pJailedTimes,
- pFrozenTimes,
- pLogins,
- Float:pPosX,
- Float:pPosY,
- Float:pPosZ,
- Float:pPosA
- }
- new PlayerInfo[MAX_PLAYERS][pInfo];
- new MoneyGiven[MAX_PLAYERS];
- new IsRegistered[MAX_PLAYERS];
- new Logged[MAX_PLAYERS];
- new JustLogged[MAX_PLAYERS];
- new Otherid;
- new Text:Textdraw1;
- stock IsPlayerBanned(playerid)
- {
- new IP[16], String[128], Query[128], reason[64], admin[32], i[128], seconds;
- GetPlayerIp(playerid, IP, sizeof(IP));
- format(Query, sizeof(Query), "SELECT * FROM `Bans` WHERE (`Username` = '%s' OR `IP` = '%s') AND `Banned` = 1 LIMIT 1", GetName(playerid), IP);
- mysql_query(Query);
- mysql_store_result();
- if(mysql_num_rows() != 0)
- {
- while(mysql_fetch_row_format(Query, "|"))
- {
- mysql_fetch_field_row(i, "Reason"); format(reason, sizeof(reason), i);
- mysql_fetch_field_row(i, "Seconds"); seconds = strval(i);
- mysql_fetch_field_row(i, "Admin"); format(admin, sizeof(admin), i);
- }
- if(seconds > gettime())
- {
- format(String, sizeof(String), "Grund des Bans %s", reason);
- SendClientMessage(playerid, COLOR_ROT, String);
- SendClientMessage(playerid, COLOR_ROT, "Du bist noch Gebannt.");
- format(String, sizeof(String), "Du wirst Entbannt in %s", timec(gettime()-(gettime()-seconds)));
- SendClientMessage(playerid, COLOR_ROT, String);
- SendClientMessage(playerid, COLOR_ROT, "Wenn du es weiter versuchst wirst du gebannt!'");
- SendClientMessage(playerid, COLOR_ROT, "Wenn du zu Unrecht gebannt wurdest, besuch unser Forum.");
- Kick(playerid);
- }
- else
- {
- format(Query, sizeof(Query), "UPDATE `Bans` SET `Banned` = 0 WHERE `Username` = '%s'", GetName(playerid));
- mysql_query(Query);
- format(String, sizeof(String), "%s (%i) Wurde vom Server gebannt!!!", GetName(playerid), playerid);
- SendClientMessageToAll(COLOR_GRUEN, String);
- }
- }
- mysql_free_result();
- return 1;
- }
- stock timec(timestamp, compare = -1)
- {
- if (compare == -1) {
- compare = gettime();
- }
- new
- n,
- Float:d = (timestamp > compare) ? timestamp - compare : compare - timestamp,
- returnstr[32];
- if (d < 60) {
- format(returnstr, sizeof(returnstr), "Weniger als 60 Sekunden. ");
- return returnstr;
- } else if (d < 3600) { // 3600 = 1 Stunde
- n = floatround(floatdiv(d, 60.5), floatround_floor);
- format(returnstr, sizeof(returnstr), "Eine Minute.");
- } else if (d < 86400) { // 86400 = 1 Tag
- n = floatround(floatdiv(d, 3600.5), floatround_floor);
- format(returnstr, sizeof(returnstr), "Eine Stunde.");
- } else if (d < 2592000) { // 2592000 = 1 Monat
- n = floatround(floatdiv(d, 86400.5), floatround_floor);
- format(returnstr, sizeof(returnstr), "Ein Tag.");
- } else if (d < 31536000) { // 31536000 = 1 Jahr
- n = floatround(floatdiv(d, 2592000.5), floatround_floor);
- format(returnstr, sizeof(returnstr), "Ein Monat.");
- } else {
- n = floatround(floatdiv(d, 31536000.5), floatround_floor);
- format(returnstr, sizeof(returnstr), "Ein Jahr, mach dir Urlaub.");
- }
- if (n == 1) {
- format(returnstr, sizeof(returnstr), "%s", returnstr);
- } else {
- format(returnstr, sizeof(returnstr), "%d %ss", n, returnstr);
- }
- return returnstr;
- }
- stock GetIP(Playerid)
- {
- new IP[16];
- GetPlayerIp(Playerid, IP, sizeof(IP));
- return IP;
- }
- stock MySQL_Register(playerid, passwordstring[])
- {
- new query1[350], pname[24];
- new Bannedby[20];
- format(Bannedby, 20, "Not Banned");
- GetPlayerName(playerid, pname, 24);
- format(query1, sizeof(query1), "INSERT INTO spielerdatei (user, password, score, money, level, vip, kma, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, logins, posx, posy, posz, posa, IP) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s')", pname, passwordstring, GetIP(playerid));
- mysql_query(query1);
- SendClientMessage(playerid,COLOR_PINK,"Du hast dich Erfolgreich Registriert Willkommen!!");
- Logged[playerid] = 1;
- new st[128];
- format(st,128,"%s Hat sich Registriert %s!",GetName(playerid),GetName(playerid));
- SendClientMessageToAll(COLOR_HELLBLAU,st);
- return 1;
- }
- stock MySQL_Login(playerid)
- {
- new query2[300], pname[24], savingstring[20];
- GetPlayerName(playerid, pname, 24);
- format(query2, sizeof(query2), "SELECT score, money, level, vip, kma, rank, kills, deaths, muted, jailed, frozen, mutedtimes, jailedtimes, frozentimes, logins, posx, posy, posz, posa FROM spielerdatei WHERE user = '%s'", pname);
- mysql_query(query2);
- mysql_store_result();
- while(mysql_fetch_row_format(query2,"|"))
- {
- mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
- mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][pLevel] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "vip"); PlayerInfo[playerid][pVIP] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "kma"); PlayerInfo[playerid][pKMA] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "rank"); PlayerInfo[playerid][pRank] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "muted"); PlayerInfo[playerid][pMuted] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "jailed"); PlayerInfo[playerid][pJailed] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "frozen"); PlayerInfo[playerid][pFrozen] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "mutedtimes"); PlayerInfo[playerid][pMutedTimes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "jailedtimes"); PlayerInfo[playerid][pJailedTimes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "frozentimes"); PlayerInfo[playerid][pFrozenTimes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "logins"); PlayerInfo[playerid][pLogins] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "posx"); PlayerInfo[playerid][pPosX] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "posy"); PlayerInfo[playerid][pPosY] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "posz"); PlayerInfo[playerid][pPosZ] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "posa"); PlayerInfo[playerid][pPosA] = strval(savingstring);
- }
- mysql_free_result();
- JustLogged[playerid] = 1;
- Logged[playerid] = 1;
- PlayerInfo[playerid][pLogins]++;
- GameTextForPlayer(playerid,"~g~Du hast dich Erfolgreich Eingeloggt",5000,5);
- new st[128];
- format(st,128,"%s Hat den Server betretten %s!",GetName(playerid),GetName(playerid));
- SendClientMessageToAll(COLOR_HELLBLAU,st);
- return 1;
- }
- stock GetName(playerid)
- {
- new pname[24];
- GetPlayerName(playerid, pname, 24);
- return pname;
- }
- forward Eins();
- forward Zwei();
- forward Drei();
- forward Start();
- main()
- {
- print("\n----------------------------------");
- print(" Base Jump by Weihnachtsferien ");
- print("----------------------------------\n");
- }
- public OnGameModeInit()
- {
- SetTimer("randommsgs",25000,1);
- DisableInteriorEnterExits();
- mysql_debug(1);
- UsePlayerPedAnims();
- SetGameModeText("BaseJump");
- AddPlayerClass(1,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(10,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(33,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(190,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(55,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(60,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(292,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(296,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(140,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(15,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(18,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(19,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(29,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(111,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(144,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(70,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(71,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(72,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(73,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJump
- AddPlayerClass(74,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(75,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(76,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(77,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(78,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(79,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(90,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(199,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- AddPlayerClass(290,-1638.8668,902.6663,139.9747,0.0000,0,0,0,0,0,0); // BaseJumpSpawn
- Textdraw1 = TextDrawCreate(139.000000, 428.000000, "Einzigartiger BaseJump Server ");
- TextDrawBackgroundColor(Textdraw1, -1);
- TextDrawFont(Textdraw1, 1);
- TextDrawLetterSize(Textdraw1, 0.620000, 1.900000);
- TextDrawColor(Textdraw1, 255);
- TextDrawSetOutline(Textdraw1, 1);
- TextDrawSetProportional(Textdraw1, 1);
- //================================================================//
- // MySQL //
- //================================================================//
- mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
- mysql_query("CREATE TABLE IF NOT EXISTS spielerdatei(user VARCHAR(24), password VARCHAR(40), score INT(20), money INT(20), level INT(1), vip INT(20), kma INT(20), rank INT(20), kills INT(20), deaths INT(20), muted INT(20), jailed INT(20), frozen INT(20), mutedtimes INT(20), jailedtimes INT(20), frozentimes INT(20), logins INT(20), posx INT(20), posy INT(20), posz INT(20), posa INT(20), IP VARCHAR(16) )");
- mysql_query("CREATE TABLE IF NOT EXISTS Bans(Username VARCHAR(32), Admin VARCHAR(32), IP VARCHAR(16), Reason VARCHAR(64), Seconds INT(12), Banned INT(5) )");
- mysql_debug(1);
- if(mysql_ping()>2)
- print("Verbindung mit der Datenbank Fehlgeschlagen");
- else print("Verbindung mit der Datenbank Erfolgreich");
- return 1;
- }
- public OnPlayerRequestSpawn(playerid)
- {
- if(!Logged[playerid])
- {
- if(!IsRegistered[playerid])
- {
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Bitte Registrieren",""White"Willkommen auf "Red""SERVER_NAME""White"!\n"White"Um zu Spielen musst du dich Registrieren!\n\n"White"Bitte gebe ein Passwort ein:", "Register", "raus");
- return 0;
- }
- if(IsRegistered[playerid] == 1)
- {
- ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Bitte Einloggen", ""White"Willkommen zurueck auf "Red""SERVER_NAME""White"!\n"White"Um zu Spielen musst du dich Einloggen!\n\n"White"Bitte gebe "Red"dein"White" passwort ein", "Login", "raus");
- return 0;
- }
- }
- return 1;
- }
- public OnPlayerConnect(playerid)
- {
- PlayAudioStreamForPlayer(playerid, "http://listen.technobase.fm/dsl.pls");
- IsPlayerBanned(playerid);
- EnableStuntBonusForPlayer(playerid, 0);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessageToAll(COLOR_HELLBLAU,string);
- MoneyGiven[playerid] = -1;
- JustLogged[playerid] = 0;
- new query[300], pname[24];
- GetPlayerName(playerid, pname, 24);
- format(query, sizeof(query), "SELECT IP FROM `spielerdatei` WHERE user = '%s' LIMIT 1", pname);
- mysql_query(query);
- mysql_store_result();
- new rows = mysql_num_rows();
- if(!rows)
- {
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Bitte Registrieren",""White"Willkommen auf"Red""SERVER_NAME""White"!\n"White"Um zu Spielen musst du dich Registrieren\n\n"White"Bitte gebe ein Passwort ein", "Register", "Raus");
- }
- if(rows == 1)
- {
- new IP[2][15];
- mysql_fetch_field_row(IP[0],"IP");
- GetPlayerIp(playerid, IP[1], 15);
- if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
- {
- MySQL_Login(playerid);
- }
- else if(!strlen(IP[0]) || strcmp(IP[0], IP[1], true))
- {
- ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Bitte Einloggen", ""White"Willkommen zurueck bei "Red""SERVER_NAME""White"!\n"White"Um zu spielen Logge dich ein.\n\n"White"Bitte gebe "Red"dein"White" Passwort ein:", "Login", "Raus");
- IsRegistered[playerid] = 1;
- }
- }
- mysql_free_result();
- return 1;
- }
- public OnPlayerDisconnect(playerid, reason)
- {
- new string[64],
- name[MAX_PLAYER_NAME];
- GetPlayerName(playerid,name,MAX_PLAYER_NAME);
- switch(reason)
- {
- case 0: format(string,sizeof string,"%s hat den Server verlassen. (Crash)",name);
- case 1: format(string,sizeof string,"%s hat den Server verlassen. (Left)",name);
- case 2: format(string,sizeof string,"%s hat den Server verlassen. (Kicked/Banned)",name);
- }
- SendClientMessageToAll(COLOR_GRUEN,string);
- if(Logged[playerid] == 1)
- {
- new Float:x, Float:y, Float:z, Float:a;
- GetPlayerPos(playerid, x, y, z);
- GetPlayerFacingAngle(playerid, a);
- PlayerInfo[playerid][pPosX] = x;
- PlayerInfo[playerid][pPosY] = y;
- PlayerInfo[playerid][pPosZ] = z;
- PlayerInfo[playerid][pPosA] = a;
- new score = GetPlayerScore(playerid);
- new money = GetPlayerMoney(playerid);
- new query[300], pname[24]; new nquery[300];
- GetPlayerName(playerid, pname, 24);
- format(query, sizeof(query), "UPDATE `spielerdatei` SET score='%d', money='%d', level='%d', vip='%d', kma='%d', rank='%d', kills='%d', deaths='%d', muted='%d', jailed='%d', frozen='%d' WHERE user='%s'",
- score,
- money,
- PlayerInfo[playerid][pLevel],
- PlayerInfo[playerid][pVIP],
- PlayerInfo[playerid][pKMA],
- PlayerInfo[playerid][pRank],
- PlayerInfo[playerid][pKills],
- PlayerInfo[playerid][pDeaths],
- PlayerInfo[playerid][pMuted],
- PlayerInfo[playerid][pJailed],
- PlayerInfo[playerid][pFrozen],
- pname);
- format(nquery,300,"UPDATE `spielerdatei` SET mutedtimes='%d', jailedtimes='%d', frozentimes='%d', logins='%d', posx='%f', posy='%f', posz='%f', posa='%f' WHERE user='%s'",PlayerInfo[playerid][pMutedTimes],
- PlayerInfo[playerid][pJailedTimes],
- PlayerInfo[playerid][pFrozenTimes],
- PlayerInfo[playerid][pLogins],
- PlayerInfo[playerid][pPosX],
- PlayerInfo[playerid][pPosY],
- PlayerInfo[playerid][pPosZ],
- PlayerInfo[playerid][pPosA],
- pname);
- mysql_query(query);
- mysql_query(nquery);
- }
- return 1;
- }
- public OnPlayerCommandPerformed(playerid, cmdtext[], success)
- {
- if(!success) return SendClientMessage(playerid, COLOR_ROT, BefehlFalsch);
- return 1;
- }
- forward SaveStats(playerid);
- public SaveStats(playerid)
- {
- if(Logged[playerid] == 1)
- {
- new Float:x, Float:y, Float:z, Float:a;
- GetPlayerPos(playerid, x, y, z);
- GetPlayerFacingAngle(playerid, a);
- PlayerInfo[playerid][pPosX] = x;
- PlayerInfo[playerid][pPosY] = y;
- PlayerInfo[playerid][pPosZ] = z;
- PlayerInfo[playerid][pPosA] = a;
- new score = GetPlayerScore(playerid);
- new money = GetPlayerMoney(playerid);
- new query[300], pname[24]; new nquery[300];
- GetPlayerName(playerid, pname, 24);
- format(query, sizeof(query), "UPDATE `spielerdatei` SET score='%d', money='%d', level='%d', vip='%d', kma='%d', rank='%d', kills='%d', deaths='%d', muted='%d', jailed='%d', frozen='%d WHERE user='%s'",
- score,
- money,
- PlayerInfo[playerid][pLevel],
- PlayerInfo[playerid][pVIP],
- PlayerInfo[playerid][pKMA],
- PlayerInfo[playerid][pRank],
- PlayerInfo[playerid][pKills],
- PlayerInfo[playerid][pDeaths],
- PlayerInfo[playerid][pMuted],
- PlayerInfo[playerid][pJailed],
- PlayerInfo[playerid][pFrozen],
- pname);
- format(nquery,300,"UPDATE `spielerdatei` SET mutedtimes='%d', jailedtimes='%d', frozentimes='%d', logins='%d', posx='%f', posy='%f', posz='%f', posa='%f', IP=%d WHERE user='%s'",PlayerInfo[playerid][pMutedTimes],
- PlayerInfo[playerid][pJailedTimes],
- PlayerInfo[playerid][pFrozenTimes],
- PlayerInfo[playerid][pLogins],
- PlayerInfo[playerid][pPosX],
- PlayerInfo[playerid][pPosY],
- PlayerInfo[playerid][pPosZ],
- PlayerInfo[playerid][pPosA],
- GetIP(playerid),
- pname
- );
- mysql_query(query);
- mysql_query(nquery);
- }
- return 1;
- }
- public OnPlayerSpawn(playerid)
- {
- GivePlayerWeapon(playerid,46,1);
- TextDrawShowForPlayer(playerid, Textdraw1);
- SetPlayerPos(playerid,-2314.5305,-1660.8696,483.3223);
- StopAudioStreamForPlayer(playerid);
- // SetPlayerPos(playerid, PlayerInfo[playerid][pPosX], PlayerInfo[playerid][pPosY], PlayerInfo[playerid][pPosZ]);
- // SetPlayerFacingAngle(playerid, PlayerInfo[playerid][pPosA]);
- // SendClientMessage(playerid,COLOR_HELLBLAU,"Deine letzte Gespeicherte Position wurde geladen.");
- if(MoneyGiven[playerid] != -1)
- {
- GivePlayerMoney(playerid, MoneyGiven[playerid]);
- MoneyGiven[playerid] = -1;
- }
- if(JustLogged[playerid] == 1)
- {
- new s[64];
- format(s,64,"Willkommen zurueck.",GetName(playerid));
- SendClientMessage(playerid,COLOR_GRUEN,s);
- JustLogged[playerid] = 0;
- }
- return 1;
- }
- public OnPlayerDeath(playerid, killerid, reason)
- {
- GameTextForPlayer(playerid, "~r~TOD!Versuche es nochmal",7000,6);
- SendDeathMessage(killerid,playerid,reason);
- if(killerid!=INVALID_PLAYER_ID)
- PlayerInfo[killerid][pKills]++;
- PlayerInfo[playerid][pDeaths]++;
- return 1;
- }
- public OnPlayerUpdate(playerid)
- {
- if(GetPlayerPing(playerid)>400)
- {
- SendClientMessage(playerid,COLOR_ROT,"Dein Ping ist zu Hoch, sorry du kannst nicht Spielen.");
- Kick(playerid);
- }
- return 1;
- }
- public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
- {
- if(dialogid == DIALOG_POS)
- {
- if(response)
- {
- }
- else if(response)
- {
- return 1;
- }
- }
- //================================================================//
- // MySQL //
- //================================================================//
- if(dialogid == DIALOG_REGISTER)
- {
- if(response)
- {
- if(!strlen(inputtext) || strlen(inputtext) > 100)
- {
- SendClientMessage(playerid,COLOR_ROT,"Bitte gebe ein Passwort ein zwischen 1-100 Zeichen");
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Bitte Registrieren",""White"Willkommen auf "Red""SERVER_NAME""White"!\n""Um zu Spielen musst du dich Registrieren\n\n"White"Bitte gebe dein Passwort ein", "Register", "Raus");
- }
- else if(strlen(inputtext) > 0 && strlen(inputtext) < 100)
- {
- new escpass[100];
- mysql_real_escape_string(inputtext, escpass);
- MySQL_Register(playerid, escpass);
- }
- }
- if(!response)
- {
- SendClientMessage(playerid, COLOR_ROT, "Du musst dich Einloggen um zu Spielen");
- Kick(playerid);
- }
- }
- if(dialogid == DIALOG_LOGIN)
- {
- if(!response)
- {
- SendClientMessage(playerid, COLOR_ROT, "Du musst dich Einloggen um zu Spielen");
- Kick(playerid);
- }
- if(response)
- {
- new query[200], pname[24], escapepass[100];
- GetPlayerName(playerid, pname, 24);
- mysql_real_escape_string(inputtext, escapepass);
- format(query, sizeof(query), "SELECT `user` FROM spielerdatei WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
- mysql_query(query);
- mysql_store_result();
- new numrows = mysql_num_rows();
- if(numrows == 1) MySQL_Login(playerid);
- if(!numrows)
- {
- ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Bitte Einloggen", ""White"Willkommen zurueck auf "Red""SERVER_NAME""White"!\n"White"Um zu Spielen musst du Eingeloggt sein\n\n"White"Bitte gebe "Red"dein"White" Passwort ein:", "Login", "Raus");
- GameTextForPlayer(playerid,"~r~Falsches Passwort.",2000,6);
- }
- mysql_free_result();
- }
- }
- return 1;
- }
- ///////////Admin Befehle Mysql ///////////////
- CMD:ban(playerid,params[])
- {
- new reason[64], Reason[64], Mins, Hours, Days, Query[256], String[128];
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(sscanf(params, "uiiis[64]", Otherid, Mins, Hours, Days, reason)) return SendClientMessage(playerid, COLOR_ROT, "Benutze: /ban (Spielerid) (Minuten) (Stunden) (Tage)");
- {
- if(!IsPlayerConnected(Otherid)) return SendClientMessage(playerid, COLOR_ROT, "Diesen Spieler gibt es nicht");
- {
- if(strlen(reason) > 64) return SendClientMessage(playerid, COLOR_ROT, "Tippe einen Bangrund [ Max ] 64 Zeichen");
- {
- new CTS = ((Mins*60) + (Hours*3600) + (Days*86400));
- mysql_real_escape_string(reason, Reason);
- format(Query, sizeof(Query), "INSERT INTO `Bans` (Username, Admin, IP, Reason, Seconds, Banned) VALUES ('%s', '%s', '%s', '%s', '%d', 1)", GetName(Otherid), GetName(playerid), GetIP(Otherid), Reason, (CTS+gettime()));
- mysql_query(Query);
- format(String, sizeof(String), "%s Wurde vom Server Gebannt Grund: %s.", GetName(Otherid), Reason);
- SendClientMessageToAll(COLOR_ORANGE, String);
- SetPlayerPos(Otherid,193.5177,176.2223,1003.0234);
- SetPlayerInterior(Otherid,3);
- GameTextForPlayer(Otherid,"~r~Du wurdest aus dem ~p~server gebannt.",5000,5);
- format(String,128,"Sie wurde gebannt, Melden sie sich im Forum um den Grund zu wissen.",Reason);
- SendClientMessage(Otherid,COLOR_ROT,String);
- Kick(Otherid);
- }
- }
- }
- }
- else SendClientMessage(playerid,COLOR_ROT,BefehlFalsch);
- return 1;
- }
- CMD:checkban(playerid,params[])
- {
- new account[24], Query[128], String[128];
- new reason[64], user[32], admin[24], IP[16], i[128];
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(sscanf(params, "s", account)) return SendClientMessage(playerid, COLOR_ROT, "Benutze: /checkban [Spielername/id]");
- {
- if(strlen(account) > 24) return SendClientMessage(playerid, COLOR_ROT, "Spielername darf Max. 24 Zeichen haben.");
- {
- format(Query, sizeof(Query), "SELECT Username, Reason, Admin, IP FROM `Bans` WHERE `Username` = '%s' AND `Banned` = 1 LIMIT 1", account);
- mysql_query(Query);
- mysql_store_result();
- if(mysql_num_rows() == 0)
- {
- mysql_free_result();
- format(String, sizeof(String), "Diesen Spieler gibt es nicht!", account);
- SendClientMessage(playerid, COLOR_ROT, String);
- return 1;
- }
- else if(mysql_num_rows() != 0)
- {
- while(mysql_fetch_row_format(Query, "|"))
- {
- mysql_fetch_field_row(i, "Username"); format(user, sizeof(user), i);
- mysql_fetch_field_row(i, "Reason"); format(reason, sizeof(reason), i);
- mysql_fetch_field_row(i, "Admin"); format(admin, sizeof(admin), i);
- mysql_fetch_field_row(i, "IP"); format(IP, sizeof(IP), i);
- }
- format(String, sizeof(String), "%s (IP: %s) ist gebannt %s. Grund:: %s", user, IP, admin, reason);
- SendClientMessage(playerid, COLOR_HELLBLAU, String);
- }
- mysql_free_result();
- }
- }
- }
- else return SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- new isgod[MAX_PLAYERS];
- CMD:veh(playerid,params[])
- {
- new vehid; new color1; new color2;
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=3)
- {
- if(sscanf(params,"iii",vehid,color1,color2)) return SendClientMessage(playerid,COLOR_PINK,"Benutze: /veh [Fahrzeug ID] [Farbe 1] [Farbe 2].");
- {
- new Float:x, Float:y, Float:z;
- GetPlayerPos(playerid,x,y,z);
- CreateVehicle(vehid,x+2,y+2,z+2,0,color1,color2,0);
- PutPlayerInVehicle(playerid, vehid, 0);
- SendClientMessage(playerid,COLOR_PINK,"Fahrzeug gespawnt!");
- }
- }
- else SendClientMessage(playerid,COLOR_ROT,BefehlFalsch);
- return 1;
- }
- CMD:aduty(playerid,params[])
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(isgod[playerid]==0)
- {
- SetPlayerColor(playerid,COLOR_PINK);
- SetPlayerHealth(playerid,9999);
- SetPlayerArmour(playerid,9999);
- new Text3D:a = Create3DTextLabel("Admin - On duty! Bitte nicht stoeren!", COLOR_PINK, 30.0, 40.0, 50.0, 40.0, 0);
- Attach3DTextLabelToPlayer(a, playerid, 0.0, 0.0, 0.2);
- isgod[playerid] =1;
- }
- else if(isgod[playerid] == 1)
- {
- SetPlayerColor(playerid,COLOR_WEISS);
- SetPlayerHealth(playerid,100);
- SetPlayerArmour(playerid,100);
- }
- }
- else return SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- CMD:slap(playerid,params[])
- {
- new targetid; new Float:x, Float:y, Float:z;
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(sscanf(params,"u",targetid)) return SendClientMessage(playerid,COLOR_PINK,"Benutze: /slap [Spieler id]");
- {
- GetPlayerPos(targetid,x,y,z);
- SetPlayerPos(targetid,x,y,z+20);
- new PlayerName[MAX_PLAYER_NAME];
- GetPlayerName(targetid,PlayerName,MAX_PLAYER_NAME);
- new string[128];
- format(string,sizeof(string),"Du hast geschlagen %s.",PlayerName);
- SendClientMessage(playerid,COLOR_PINK,string);
- SendClientMessage(targetid,COLOR_ROT,"Du wurdest von jemanden geschlagen");
- }
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- new isplayerspectating[MAX_PLAYERS] = 0;
- CMD:tv(playerid,params[])
- {
- new targetid;
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=1)
- {
- if(IsPlayerConnected(targetid))
- {
- if(sscanf(params,"u",targetid)) return SendClientMessage(playerid,COLOR_PINK,"Benutze: /tv [Spieler id]");
- {
- if(playerid==targetid) return SendClientMessage(playerid,COLOR_ROT,"Warum in Gottes Namen, möchtest du dir selbst zuschauen?");
- {
- new Float:x, Float:y, Float:z;
- isplayerspectating[playerid] =1;
- SetPVarFloat(playerid,"locx",x);
- SetPVarFloat(playerid,"locy",x);
- SetPVarFloat(playerid,"locz",x);
- GetPlayerPos(playerid,x,y,z);
- new lol = GetPlayerState(targetid);
- if (lol == 1)
- {
- TogglePlayerSpectating(playerid,1);
- PlayerSpectatePlayer(playerid,targetid);
- }
- if(lol == 2 || lol == 3)
- {
- TogglePlayerSpectating(playerid,1);
- new vehid = GetPlayerVehicleID(targetid);
- PlayerSpectateVehicle(playerid,vehid);
- }
- if(lol == 7 || lol == 8 || lol == 9)
- {
- SendClientMessage(playerid,COLOR_ROT,"Der Spieler den du Beobachtest ist entwieder Tod oder nicht mehr auf dem Server.");
- }
- if(lol == 4)
- {
- TogglePlayerSpectating(playerid,1);
- PlayerSpectatePlayer(playerid,targetid);
- }
- if(lol == 5 || lol == 6)
- {
- TogglePlayerSpectating(playerid,1);
- new vehid = GetPlayerVehicleID(targetid);
- PlayerSpectateVehicle(playerid,vehid);
- }
- }
- }
- }
- else SendClientMessage(playerid,0xFF7800FF, "Spieler ist Offline");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:tvoff(playerid,params[])
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel] >=1)
- {
- if(isplayerspectating[playerid]==1)
- {
- TogglePlayerSpectating(playerid,0);
- SetPlayerPos(playerid,GetPVarFloat(playerid,"locx"),GetPVarFloat(playerid,"locy"),GetPVarFloat(playerid,"locz"));
- }
- else return SendClientMessage(playerid,COLOR_ROT,"Richtig du schaust niemanden zu.");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- CMD:freeze(playerid,params[])
- {
- new targetid; new reason[128];new PlayerName[MAX_PLAYER_NAME];
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel] >=2)
- {
- if(IsPlayerConnected(targetid))
- {
- if(sscanf(params,"us",targetid,reason)) return SendClientMessage(playerid,COLOR_PINK,"Benutze: /freeze [Spieler id] [Grund]");
- {
- TogglePlayerControllable(targetid,0);
- GetPlayerName(targetid,PlayerName,MAX_PLAYER_NAME);
- new string[128];
- format(string,sizeof(string),"Du Frierst %s.",PlayerName);
- SendClientMessage(playerid,COLOR_PINK,string);
- new string2[128];
- format(string2,sizeof(string2),"Du wurdest gefreezd Grund: %s",reason);
- SendClientMessage(targetid,COLOR_PINK,string2);
- new string3[128];
- format(string3,sizeof(string3),"%s wurdest von jemanden gefreezd Grund: %s",PlayerName,reason);
- SendClientMessageToAll(COLOR_PINK,string3);
- }
- }
- else SendClientMessage(playerid,0xFF7800FF, "Spieler Offline");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:unfreeze(playerid,params[])
- {
- new targetid;
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(IsPlayerConnected(targetid))
- {
- if(sscanf(params,"u",targetid)) SendClientMessage(playerid,COLOR_PINK,"Usage: /unfreeze [Spieler id]");
- {
- TogglePlayerControllable(targetid,1);
- SendClientMessage(playerid,COLOR_PINK,"Du hast den Spieler unfreezd");
- SendClientMessage(targetid, COLOR_GRUEN,"Du wurdest unfreezd");
- }
- }
- else SendClientMessage(playerid,0xFF7800FF, "Spieler Offline!");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:jail(playerid,params[])
- {
- new targetid;
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>= 2)
- {
- if(IsPlayerConnected(targetid))
- {
- if(sscanf(params,"u",targetid)) return SendClientMessage(playerid,COLOR_PINK,"Benutze: /jail [Spieler id]");
- {
- new Float:x1, Float:y1, Float:z1;
- GetPlayerPos(targetid,x1,y1,z1);
- SetPVarFloat(targetid,"loc1",x1);
- SetPVarFloat(targetid,"loc2",y1);
- SetPVarFloat(targetid,"loc3",z1);
- SetPlayerInterior(targetid,6);
- SendClientMessage(targetid,COLOR_PINK,"Du wurdest verhaftet");
- SendClientMessage(playerid,COLOR_PINK,"Du hast eine Persion verhaftet");
- SetPlayerPos(targetid,264.2620,77.8714,1001.0391);
- }
- }
- else SendClientMessage(playerid,0xFF7800FF, "Spieler Offline");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:unjail(playerid,params[])
- {
- new targetid;
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(IsPlayerConnected(targetid))
- {
- if(sscanf(params,"u",targetid)) SendClientMessage(playerid,COLOR_PINK,"Benutze: /jail [Spieler id]");
- {
- SetPlayerInterior(targetid, 0);
- SetPlayerPos(targetid,GetPVarFloat(targetid,"loc1"),GetPVarFloat(targetid,"loc2"),GetPVarFloat(targetid,"loc3"));
- SendClientMessage(targetid,COLOR_PINK,"Sie sind draussen!");
- SendClientMessage(playerid,COLOR_PINK,"Du hast den Spieler befreit");
- }
- }
- else SendClientMessage(playerid,0xFF7800FF, "Specified Player offline!");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:dveh(playerid,params[])
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=3)
- {
- new vehid;
- if(IsPlayerInAnyVehicle(playerid))
- {
- vehid = GetPlayerVehicleID(playerid);
- DestroyVehicle(vehid);
- SendClientMessage(playerid,COLOR_PINK,"Fahrzeug zerstoert!");
- }
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- CMD:kill(playerid,params[])
- {
- new targetid;
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(IsPlayerConnected(targetid))
- {
- if(sscanf(params,"u",targetid)) SendClientMessage(playerid,COLOR_PINK,"Benutze: /kill [Spieler id]");
- {
- SetPlayerHealth(targetid,0.0);
- GivePlayerMoney(targetid,-1000);
- SendClientMessage(playerid,COLOR_PINK,"Du hast die Person Gekillt");
- SendClientMessage(targetid,COLOR_PINK,"Sie wurden Getotet");
- }
- }
- else SendClientMessage(playerid,0xFF7800FF, "Spieler ist Offline");
- }
- SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:ckill(playerid,params[])
- {
- new targetid;
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=3)
- {
- if(IsPlayerConnected(targetid))
- {
- if(sscanf(params,"u",targetid)) return SendClientMessage(playerid,COLOR_PINK,"Benutze: /ckill [Spieler id]");
- else
- {
- ForceClassSelection(targetid);
- SendClientMessage(playerid,COLOR_PINK,"Du hast den Spieler in die Skinauswahl geschmissen");
- SendClientMessage(targetid,COLOR_PINK,"Du wurdest in die Skinauswahl geschmissen");
- }
- }
- else SendClientMessage(playerid,0xFF7800FF, "Spieler ist Offline");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:setweather(playerid,params[])
- {
- new weather;
- {
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=3)
- {
- if(weather<45 || weather>0)
- {
- if(sscanf(params,"i",weather)) SendClientMessage(playerid,COLOR_PINK,"Benutze: /setweather [Wetter ID (0-45)]");
- {
- SetWeather(weather);
- SendClientMessageToAll(COLOR_GRUEN,"Wetter wurde geandert");
- }
- }
- else SendClientMessage(playerid,COLOR_ROT,"Unbekannte Wetter ID");
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- }
- return 1;
- }
- CMD:fixveh(playerid,params[])
- {
- new vehid;new targetid;
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=3)
- {
- if(IsPlayerInAnyVehicle(targetid))
- vehid = GetPlayerVehicleID(targetid);
- {
- RepairVehicle(vehid);
- SendClientMessage(playerid,COLOR_PINK,"Fahrzeug wurde Repairt + Nitro eingebaut");
- }
- }
- else SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- CMD:admins(playerid,params[])
- {
- SendClientMessage(playerid,COLOR_GRUEN,"Sie sind da keine sorge ;) Falls du ein Hacker bist hau Lieber ab.");
- return 1;
- }
- CMD:setadmin(playerid,params[])
- {
- new targetid; new l;
- if(PlayerInfo[playerid][pLevel] >= 4 || IsPlayerAdmin(playerid))
- {
- if(sscanf(params,"ui",targetid,l)) return SendClientMessage(playerid,COLOR_ROT,"Benutze: /setadmin (Spielerid) (Level)");
- {
- PlayerInfo[targetid][pLevel] = l;
- new st[128];
- format(st,128,"UPDATE `spielerdatei` SET level='%d' WHERE user='%s'",l,GetName(targetid));
- mysql_query(st);
- format(st,128,"SELECT level='%d' FROM `spielerdatei`",PlayerInfo[playerid][pLevel]);
- mysql_query(st);
- GameTextForPlayer(playerid,"Aufgestiegen auf ein ~g~Admin.",10000,5);
- }
- }
- else return SendClientMessage(targetid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- CMD:kick(playerid,params[])
- {
- new targetid; new reason[128];
- if(PlayerInfo[playerid][pLevel] >= 1 || IsPlayerAdmin(playerid))
- {
- if(sscanf(params,"us",targetid,reason)) return SendClientMessage(playerid,COLOR_ROT,"Benutze: /kick (Spielerid) (Grund)");
- {
- new str[128];
- format(str,128,"%s Wurde vom Server gekickt Grund: %s",GetName(targetid),reason);
- SendClientMessageToAll(COLOR_HELLBLAU,str);
- SetPlayerPos(targetid,193.5177,176.2223,1003.0234);
- SetPlayerInterior(targetid,3);
- GameTextForPlayer(targetid,"~r~Du wurdest gekickt vom ~p~server.",5000,5);
- format(str,128,"Du wurdest vom Server gekickt Grund: %s. Lese die Regeln und komm wieder.",reason);
- SendClientMessage(targetid,COLOR_ROT,str);
- Kick(targetid);
- }
- }
- else
- return SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- CMD:unban(playerid,params[])
- {
- new account[24], Query[128], String[128];
- if(IsPlayerAdmin(playerid) || PlayerInfo[playerid][pLevel]>=2)
- {
- if(sscanf(params, "s", account)) return SendClientMessage(playerid, COLOR_ROT, "Benutze: /unban (Spielerid/Name)");
- {
- if(strlen(account) > 24) return SendClientMessage(playerid, COLOR_ROT, "Der Spielername darf Max. 24 Zeichen haben.");
- {
- format(Query, sizeof(Query), "SELECT `Username` FROM `Bans` WHERE `Username` = '%s' AND `Banned` = 1 LIMIT 1", account);
- mysql_query(Query);
- mysql_store_result();
- if(!mysql_num_rows())
- {
- mysql_free_result();
- format(String, sizeof(String), "Diesen user gibt es nicht.", account);
- return SendClientMessage(playerid, COLOR_ROT, String);
- }
- else if(mysql_num_rows() != 0)
- {
- format(Query, sizeof(Query), "UPDATE `Bans` SET `Banned` = 0 WHERE `Username` = '%s'", account);
- mysql_query(Query);
- format(String, sizeof(String), "Du hast %s! Entbannt ", account);
- SendClientMessage(playerid, COLOR_GRUEN, String);
- }
- }
- }
- }
- else
- return SendClientMessage(playerid,COLOR_ORANGE,BefehlFalsch);
- return 1;
- }
- ///////////Mysql Admin Befehle Ende///////////////////
- public OnPlayerCommandText(playerid, cmdtext[])
- {
- if (strcmp(cmdtext, "/countdown", true, 10)==0)
- {
- SetTimer("Drei", 1000, 0);
- SetTimer("Zwei", 2000, 0);
- SetTimer("Eins", 3000, 0);
- SetTimer("Start", 4000, 0);
- return 1;
- }
- if(strcmp(cmdtext,"/pa",true) == 0)
- {
- SendClientMessage(playerid,COLOR_GRUEN,"Faltschirm erfolgreich gespawnt!");
- GivePlayerWeapon(playerid,46,1);
- return 1;
- }
- if(strcmp(cmdtext,"/killme",true) == 0)
- {
- SendClientMessage(playerid,0xFF0000AA,"Du bist Tod!");
- SetPlayerHealth(playerid,0.00);
- return 1;
- }
- if(strcmp(cmdtext,"/spawnme",true) == 0)
- {
- SpawnPlayer(playerid);
- SendClientMessage(playerid,COLOR_GELB,"Du bist gespawnt!");
- return 1;
- }
- if(strcmp(cmdtext,"/bj15",true) == 0)
- {
- SetPlayerPos(playerid,2067.9290,2437.1096,165.6172);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid,COLOR_PINK, "Willkommen bei BaseJump 15");
- GivePlayerWeapon(playerid,46,1);
- format(string,sizeof string,"%s ging nach BaseJump 15.",pName);
- return 1;
- }
- if(strcmp(cmdtext,"/bj14",true) == 0)
- {
- SetPlayerPos(playerid,1670.7603,-1343.0720,158.4766);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid,COLOR_PINK, "Willkommen bei BaseJump 14");
- GivePlayerWeapon(playerid,46,1);
- format(string,sizeof string,"%s ging nach BaseJump 14.",pName);
- return 1;
- }
- if(strcmp(cmdtext,"/bj13",true) == 0)
- {
- SetPlayerPos(playerid,-1280.4670,49.5875,70.5295);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid,COLOR_PINK, "Willkommen bei BaseJump 13");
- GivePlayerWeapon(playerid,46,1);
- format(string,sizeof string,"%s ging nach BaseJump 13.",pName);
- return 1;
- }
- if(strcmp(cmdtext,"/bj12",true) == 0)
- {
- SetPlayerPos(playerid,-1013.4426,-703.5352,136.3203);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid,COLOR_PINK, "Willkommen bei BaseJump 12");
- GivePlayerWeapon(playerid,46,1);
- format(string,sizeof string,"%s ging nach BaseJump 12.",pName);
- return 1;
- }
- if(strcmp(cmdtext,"/bj11",true) == 0)
- {
- SetPlayerPos(playerid,-2662.2515,1933.5365,225.7578);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid,COLOR_GRUEN,"Willkommen bei BaseJump 11");
- GivePlayerWeapon(playerid,46,1);
- format(string,sizeof string,"%s ging nach BaseJump 11.",pName);
- return 1;
- }
- if(strcmp(cmdtext,"/bj10",true) == 0)
- {
- SetPlayerPos(playerid,-1792.2056,569.6980,332.8047);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid,COLOR_PINK, "Willkommen bei BaseJump 10");
- GivePlayerWeapon(playerid,46,1);
- format(string,sizeof string,"%s ging nach BaseJump 10.",pName);
- return 1;
- }
- if(strcmp(cmdtext,"/bj9",true) == 0)
- {
- SetPlayerPos(playerid, 1666.7014,-1218.3112,233.3750);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 9");
- format(string,sizeof string,"%s ging nach BaseJump 9,/BJ9.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj8",true) == 0)
- {
- SetPlayerPos(playerid, -1812.7672,559.2889,273.1258);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 8");
- format(string,sizeof string,"%s ging nach BaseJump 8,/BJ8.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj7",true) == 0)
- {
- SetPlayerPos(playerid, -2336.2686,1531.8396,1416.5114);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 7");
- format(string,sizeof string,"%s has joined the BaseJump 7,/BJ7.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj6",true) == 0)
- {
- SetPlayerPos(playerid, -1753.7478,885.7360,295.8750);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei Base Jump 6");
- format(string,sizeof string,"%s ging nach BaseJump 6, /BJ6 ",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj5",true) == 0)
- {
- SetPlayerPos(playerid, -1473.1982,861.9119,778.8239);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 5");
- format(string,sizeof string,"%s ging nach BaseJump 5, /BJ5.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj4",true) == 0)
- {
- SetPlayerPos(playerid, 1868.2814,2198.4353,795.6274);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 4");
- format(string,sizeof string,"%s ging nach BaseJump 4,/BJ4.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj3",true) == 0)
- {
- SetPlayerPos(playerid, 1376.8594,-1203.8457,202.4453);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 3");
- format(string,sizeof string,"%s ging nach BaseJump 3,/BJ3.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj2",true) == 0)
- {
- SetPlayerPos(playerid, 1509.0198,-1295.7421,352.0222);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 2");
- format(string,sizeof string,"%s ging nach BaseJump 2,/BJ2.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- if(strcmp(cmdtext,"/bj1",true) == 0)
- {
- SetPlayerPos(playerid, -2081.0242,-1730.7247,427.3749);
- new string[64], pName[MAX_PLAYER_NAME];
- GetPlayerName(playerid,pName,MAX_PLAYER_NAME);
- SendClientMessage(playerid, COLOR_GELB, "Willkommen bei BaseJump 1");
- format(string,sizeof string,"%s ging nach BaseJump 1,/BJ1.",pName);
- SendClientMessageToAll(COLOR_BLAU,string);
- GivePlayerWeapon(playerid, 46, 1);
- return 1;
- }
- return 1;
- }
- SoundForAll(sound)
- {
- for (new i = 0, j = GetMaxPlayers(); i < j; i ++)
- if (IsPlayerConnected(i))
- PlayerPlaySound(i,sound,0.0,0.0,0.0);
- }
- public Drei()
- {
- GameTextForAll("~b~3",3000,4);
- SoundForAll(1056);
- return true;
- }
- public Zwei()
- {
- GameTextForAll("~b~2",3000,4);
- SoundForAll(1056);
- return true;
- }
- public Eins()
- {
- GameTextForAll("~b~1",3000,4);
- SoundForAll(1056);
- return true;
- }
- public Start()
- {
- GameTextForAll("~r~Start!",3000,4);
- SoundForAll(1057);
- return 1;
- }
- forward randommsgs();
- public randommsgs()
- {
- new rand=random(sizeof(randommessages));
- SendClientMessageToAll(0xEFEFF7AA,randommessages[rand]);
- return 1;
- }
- /*stock sscanf(sstring[], format[], {Float,_}:...)
- {
- #if defined isnull
- if (isnull(sstring))
- #else
- if (sstring[0] == 0 || (sstring[0] == 1 && sstring[1] == 0))
- #endif
- {
- return format[0];
- }
- #pragma tabsize 4
- new
- formatPos = 0,
- sstringPos = 0,
- paramPos = 2,
- paramCount = numargs(),
- delim = ' ';
- while (sstring[sstringPos] && sstring[sstringPos] <= ' ')
- {
- sstringPos++;
- }
- while (paramPos < paramCount && sstring[sstringPos])
- {
- switch (format[formatPos++])
- {
- case '\0':
- {
- return 0;
- }
- case 'i', 'd':
- {
- new
- neg = 1,
- num = 0,
- ch = sstring[sstringPos];
- if (ch == '-')
- {
- neg = -1;
- ch = sstring[++sstringPos];
- }
- do
- {
- sstringPos++;
- if ('0' <= ch <= '9')
- {
- num = (num * 10) + (ch - '0');
- }
- else
- {
- return -1;
- }
- }
- while ((ch = sstring[sstringPos]) > ' ' && ch != delim);
- setarg(paramPos, 0, num * neg);
- }
- case 'h', 'x':
- {
- new
- num = 0,
- ch = sstring[sstringPos];
- do
- {
- sstringPos++;
- switch (ch)
- {
- case 'x', 'X':
- {
- num = 0;
- continue;
- }
- case '0' .. '9':
- {
- num = (num << 4) | (ch - '0');
- }
- case 'a' .. 'f':
- {
- num = (num << 4) | (ch - ('a' - 10));
- }
- case 'A' .. 'F':
- {
- num = (num << 4) | (ch - ('A' - 10));
- }
- default:
- {
- return -1;
- }
- }
- }
- while ((ch = sstring[sstringPos]) > ' ' && ch != delim);
- setarg(paramPos, 0, num);
- }
- case 'c':
- {
- setarg(paramPos, 0, sstring[sstringPos++]);
- }
- case 'f':
- {
- new changestr[16], changepos = 0, strpos = sstringPos;
- while(changepos < 16 && sstring[strpos] && sstring[strpos] != delim)
- {
- changestr[changepos++] = sstring[strpos++];
- }
- changestr[changepos] = '\0';
- setarg(paramPos,0,_:floatstr(changestr));
- }
- case 'p':
- {
- delim = format[formatPos++];
- continue;
- }
- case '\'':
- {
- new
- end = formatPos - 1,
- ch;
- while ((ch = format[++end]) && ch != '\'') {}
- if (!ch)
- {
- return -1;
- }
- format[end] = '\0';
- if ((ch = strfind(sstring, format[formatPos], false, sstringPos)) == -1)
- {
- if (format[end + 1])
- {
- return -1;
- }
- return 0;
- }
- format[end] = '\'';
- sstringPos = ch + (end - formatPos);
- formatPos = end + 1;
- }
- case 'u':
- {
- new
- end = sstringPos - 1,
- id = 0,
- bool:num = true,
- ch;
- while ((ch = sstring[++end]) && ch != delim)
- {
- if (num)
- {
- if ('0' <= ch <= '9')
- {
- id = (id * 10) + (ch - '0');
- }
- else
- {
- num = false;
- }
- }
- }
- if (num && IsPlayerConnected(id))
- {
- setarg(paramPos, 0, id);
- }
- else
- {
- #if !defined foreach
- #define foreach(%1,%2) for (new %2 = 0; %2 < MAX_PLAYERS; %2++) if (IsPlayerConnected(%2))
- #define __SSCANF_FOREACH__
- #endif
- sstring[end] = '\0';
- num = false;
- new
- name[MAX_PLAYER_NAME];
- id = end - sstringPos;
- foreach (Player, playerid)
- {
- GetPlayerName(playerid, name, sizeof (name));
- if (!strcmp(name, sstring[sstringPos], true, id))
- {
- setarg(paramPos, 0, playerid);
- num = true;
- break;
- }
- }
- if (!num)
- {
- setarg(paramPos, 0, INVALID_PLAYER_ID);
- }
- sstring[end] = ch;
- #if defined __SSCANF_FOREACH__
- #undef foreach
- #undef __SSCANF_FOREACH__
- #endif
- }
- sstringPos = end;
- }
- case 's', 'z':
- {
- new
- i = 0,
- ch;
- if (format[formatPos])
- {
- while ((ch = sstring[sstringPos++]) && ch != delim)
- {
- setarg(paramPos, i++, ch);
- }
- if (!i)
- {
- return -1;
- }
- }
- else
- {
- while ((ch = sstring[sstringPos++]))
- {
- setarg(paramPos, i++, ch);
- }
- }
- sstringPos--;
- setarg(paramPos, i, '\0');
- }
- default:
- {
- continue;
- }
- }
- while (sstring[sstringPos] && sstring[sstringPos] != delim && sstring[sstringPos] > ' ')
- {
- sstringPos++;
- }
- while (sstring[sstringPos] && (sstring[sstringPos] == delim || sstring[sstringPos] <= ' '))
- {
- sstringPos++;
- }
- paramPos++;
- }
- do
- {
- if ((delim = format[formatPos++]) > ' ')
- {
- if (delim == '\'')
- {
- while ((delim = format[formatPos++]) && delim != '\'') {}
- }
- else if (delim != 'z')
- {
- return delim;
- }
- }
- }
- while (delim > ' ');
- return 0;
- }
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement