Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Folgende Datein müssen vorhanden sein:
- kicks.log
- bans.log
- Du darfst dieses Script nicht verkaufen.
- Du darfst das Script nicht als dein eigenes ausgeben.
- */
- #include <a_samp>
- #include <utils>
- #include <morphinc>
- #include <a_mysql>
- enum SpielerDaten
- {
- pName[MAX_PLAYER_NAME],
- pLevel,
- pGeld,
- pKills,
- pTode,
- Float:pHealth,
- pAdmin,
- pGebannt
- }
- new SpielerInfo[MAX_PLAYERS][SpielerDaten];
- #define SQL_HOST "127.0.0.1"
- #define SQL_USER "User"
- #define SQL_PASS "Passwort"
- #define SQL_DATA "Datenbank"
- #undef MAX_PLAYERS
- #define MAX_PLAYERS 50 //Mit Slots anpassen
- //Dialoge
- #define DIALOG_REGISTER (1)
- #define DIALOG_LOGIN (2)
- //Farben
- #define COLOR_GRAD1 0xB4B5B7FF
- #define COLOR_GRAD2 0xBFC0C2FF
- #define COLOR_GRAD3 0xCBCCCEFF
- #define COLOR_GRAD4 0xD8D8D8FF
- #define COLOR_GRAD5 0xE3E3E3FF
- #define COLOR_GRAD6 0xF0F0F0FF
- #define COLOR_GREY 0xAFAFAFAA
- #define COLOR_GREEN 0x33AA33AA
- #define COLOR_RED 0xAA3333AA
- #define COLOR_LIGHTRED 0xFF6347AA
- #define COLOR_LIGHTBLUE 0x33CCFFAA
- #define COLOR_LIGHTGREEN 0x9ACD32AA
- #define COLOR_YELLOW 0xFFFF00AA
- #define COLOR_YELLOW2 0xF5DEB3AA
- #define COLOR_WHITE 0xFFFFFFAA
- #define COLOR_FADE1 0xE6E6E6E6
- #define COLOR_FADE2 0xC8C8C8C8
- #define COLOR_FADE3 0xAAAAAAAA
- #define COLOR_FADE4 0x8C8C8C8C
- #define COLOR_FADE5 0x6E6E6E6E
- #define COLOR_PURPLE 0xC2A2DAAA
- #define TUTBLUE 0x00C3FFFF
- #define COLOR_DBLUE 0x2641FEAA
- #define COLOR_ALLDEPT 0xFF8282AA
- #define RESTART_HOUR 4
- #define RESTART_MINS 30
- forward BanLog(string[]);
- forward KickLog(string[]);
- forward CheckForRestart();
- forward UpdateZeit();
- new Text:Uhr;
- new Stunde, Minute;
- new UhrString[32];
- main()
- {
- print("\n----------------------------------");
- print(" Cal44");
- print("----------------------------------\n");
- }
- public OnGameModeInit()
- {
- Connect_To_Database();
- ShowPlayerMarkers(false);
- AllowAdminTeleport(true);
- EnableZoneNames(true);
- DisableInteriorEnterExits();
- LimitGlobalChatRadius(30.0);
- ManualVehicleEngineAndLights();
- EnableStuntBonusForAll(false);
- //Autos
- //TextDraws
- Uhr = TextDrawCreate(605.0,25.0,"00:00");
- TextDrawUseBox(Uhr,0);
- TextDrawFont(Uhr,3);
- TextDrawSetShadow(Uhr,0);
- TextDrawSetOutline(Uhr,2);
- TextDrawBackgroundColor(Uhr,0x000000FF);
- TextDrawColor(Uhr,0xFFFFFFFF);
- TextDrawAlignment(Uhr,3);
- TextDrawLetterSize(Uhr,0.5,1.5);
- //Timer
- UpdateZeit();
- SetTimer("CheckForRestart",60000,1);
- SetTimer("UpdateZeit",1000 * 60,1);
- return 1;
- }
- public OnGameModeExit()
- {
- return 1;
- }
- public OnPlayerRequestClass(playerid, classid)
- {
- if(GetPVarInt(playerid,"Eingeloggt") == 0)
- {
- if(mysql_CheckAccount(playerid) == 0)
- {
- SendClientMessage(playerid, 0xFFFFFFFF,"________-> Willkommen auf auf meinem Server <-________");
- SendClientMessage(playerid, 0xFFFFFFFF,"Dein Account wurde nicht gefunden, bitte Registriere dich!");
- ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Register","Bitte Gib ein Passwort an:","Register","Exit");
- }
- else if(mysql_CheckAccount(playerid) == 1)
- {
- SendClientMessage(playerid, 0xFFFFFFFF,"________-> Willkommen auf auf meinem Server <-________");
- SendClientMessage(playerid, 0xFFFFFFFF,"Dein Account wurde gefunden, bitte Log dich nun ein!");
- ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Bitte gib dein Passwort ein:","Login","Abbrechen");
- }
- }
- return 1;
- }
- public OnPlayerConnect(playerid)
- {
- return 1;
- }
- public OnPlayerDisconnect(playerid, reason)
- {
- SavePlayer(playerid);
- DeletePVar(playerid,"Eingeloggt");
- return 1;
- }
- public OnPlayerSpawn(playerid)
- {
- TextDrawShowForPlayer(playerid,Uhr);
- gettime(Stunde, Minute);
- SetPlayerTime(playerid, Stunde, Minute);
- return 1;
- }
- public OnPlayerDeath(playerid, killerid, reason)
- {
- TextDrawHideForPlayer(playerid,Uhr);
- return 1;
- }
- public OnVehicleSpawn(vehicleid)
- {
- return 1;
- }
- public OnVehicleDeath(vehicleid, killerid)
- {
- return 1;
- }
- public OnPlayerText(playerid, text[])
- {
- return 1;
- }
- public OnPlayerCommandText(playerid, cmdtext[])
- {
- new string[256];
- new sendername[MAX_PLAYER_NAME];
- new giveplayer[MAX_PLAYER_NAME];
- new cmd[256];
- new tmp[256];
- new giveplayerid, idx;
- cmd = strtok(cmdtext, idx);
- if(strcmp(cmd, "/ban", true) == 0)
- {
- if(IsPlayerConnected(playerid))
- {
- tmp = strtok(cmdtext, idx);
- if(!strlen(tmp))
- {
- SendClientMessage(playerid, COLOR_GRAD2, "Verwendung: /ban [Spielerid/Name] [Grund]");
- return 1;
- }
- giveplayerid = ReturnUser(tmp);
- if (SpielerInfo[playerid][pAdmin] >= 1)
- {
- if(IsPlayerConnected(giveplayerid))
- {
- if(giveplayerid != INVALID_PLAYER_ID)
- {
- GetPlayerName(giveplayerid, giveplayer, sizeof(giveplayer));
- GetPlayerName(playerid, sendername, sizeof(sendername));
- new length = strlen(cmdtext);
- while ((idx < length) && (cmdtext[idx] <= ' '))
- {
- idx++;
- }
- new offset = idx;
- new result[64];
- while ((idx < length) && ((idx - offset) < (sizeof(result) - 1)))
- {
- result[idx - offset] = cmdtext[idx];
- idx++;
- }
- result[idx - offset] = EOS;
- if(!strlen(result))
- {
- SendClientMessage(playerid, COLOR_GRAD2, "Verwendung: /ban [Spielerid/Name] [Grund]");
- return 1;
- }
- new year, month,day;
- getdate(year, month, day);
- format(string, sizeof(string), "AdmCmd: %s hat %s gebannt. Grund: %s (%d-%d-%d)", giveplayer, sendername, (result),month,day,year);
- BanLog(string);
- format(string, sizeof(string), "AdmCmd: %s wurde von %s gebannt. Grund: %s", giveplayer, sendername, (result));
- SendClientMessageToAll(COLOR_LIGHTRED, string);
- SpielerInfo[giveplayerid][pGebannt] = 1;
- SavePlayer(giveplayerid);
- Ban(giveplayerid);
- return 1;
- }
- }//not connected
- }
- else
- {
- format(string, sizeof(string), "%d ist nicht Online.", giveplayerid);
- SendClientMessage(playerid, COLOR_GRAD1, string);
- }
- }
- return 1;
- }
- if(strcmp(cmd, "/kick", true) == 0)
- {
- if(IsPlayerConnected(playerid))
- {
- tmp = strtok(cmdtext, idx);
- if(!strlen(tmp))
- {
- SendClientMessage(playerid, COLOR_GRAD2, "Verwendung: /kick [Spielerid/Name] [Grund]");
- return 1;
- }
- giveplayerid = ReturnUser(tmp);
- if (SpielerInfo[playerid][pAdmin] >= 1)
- {
- if(IsPlayerConnected(giveplayerid))
- {
- if(giveplayerid != INVALID_PLAYER_ID)
- {
- GetPlayerName(giveplayerid, giveplayer, sizeof(giveplayer));
- GetPlayerName(playerid, sendername, sizeof(sendername));
- new length = strlen(cmdtext);
- while ((idx < length) && (cmdtext[idx] <= ' '))
- {
- idx++;
- }
- new offset = idx;
- new result[64];
- while ((idx < length) && ((idx - offset) < (sizeof(result) - 1)))
- {
- result[idx - offset] = cmdtext[idx];
- idx++;
- }
- result[idx - offset] = EOS;
- if(!strlen(result))
- {
- SendClientMessage(playerid, COLOR_GRAD2, "Verwendung: /kick [Spielerid/Name] [Grund]");
- return 1;
- }
- new year, month,day;
- getdate(year, month, day);
- format(string, sizeof(string), "AdmCmd: %s wurde von %s gekickt. Grund: %s (%d-%d-%d)", giveplayer, sendername, (result),month,day,year);
- KickLog(string);
- format(string, sizeof(string), "AdmCmd: %s wurde von %s gekickt. Grund: %s", giveplayer, sendername, (result));
- SendClientMessageToAll(COLOR_LIGHTRED, string);
- Kick(giveplayerid);
- return 1;
- }
- }
- }
- else
- {
- format(string, sizeof(string), "%d ist nicht Online.", giveplayerid);
- SendClientMessage(playerid, COLOR_GRAD1, string);
- }
- }
- return 1;
- }
- if(strcmp(cmd, "/freeze", true) == 0)
- {
- if(IsPlayerConnected(playerid))
- {
- tmp = strtok(cmdtext, idx);
- if(!strlen(tmp))
- {
- SendClientMessage(playerid, COLOR_GRAD2, "Verwendung: /freeze [Spielerid]");
- return 1;
- }
- new playa;
- playa = ReturnUser(tmp);
- if(SpielerInfo[playa][pAdmin] > 0)
- {
- SendClientMessage(playerid, COLOR_GRAD2, "Admins können nicht eingefrohen werden");
- return 1;
- }
- if (SpielerInfo[playerid][pAdmin] >= 2)
- {
- if(IsPlayerConnected(playa))
- {
- if(playa != INVALID_PLAYER_ID)
- {
- GetPlayerName(playa, giveplayer, sizeof(giveplayer));
- GetPlayerName(playerid, sendername, sizeof(sendername));
- TogglePlayerControllable(playa, 0);
- format(string, sizeof(string), "AdmCmd: %s hat %s eingefrohen.",sendername, giveplayer);
- printf("%s",string);
- format(string, sizeof(string), "AdmCmd: %s wurde von %s eingefrohen.",giveplayer ,sendername);
- }
- }
- }
- else
- {
- SendClientMessage(playerid, COLOR_GRAD1, "Du bist kein Admin!");
- }
- }
- return 1;
- }
- if(strcmp(cmd, "/unfreeze", true) == 0)
- {
- if(IsPlayerConnected(playerid))
- {
- tmp = strtok(cmdtext, idx);
- if(!strlen(tmp))
- {
- SendClientMessage(playerid, COLOR_GRAD2, "Verwendung: /unfreeze [Spielerid]");
- return 1;
- }
- new playa;
- playa = ReturnUser(tmp);
- if (SpielerInfo[playerid][pAdmin] >= 1)
- {
- if(IsPlayerConnected(playa))
- {
- if(playa != INVALID_PLAYER_ID)
- {
- GetPlayerName(playa, giveplayer, sizeof(giveplayer));
- GetPlayerName(playerid, sendername, sizeof(sendername));
- TogglePlayerControllable(playa, 1);
- format(string, sizeof(string), "AdmCmd: %s hat %s entfrohen",sendername, giveplayer);
- printf("%s",string);
- format(string, sizeof(string), "AdmCmd: %s wurde von %s entfrohen",giveplayer ,sendername);
- }
- }
- }
- else
- {
- SendClientMessage(playerid, COLOR_GRAD1, "Du bist kein Admin!");
- }
- }
- return 1;
- }
- if(strcmp(cmd, "/cveh",true) == 0)
- {
- new x_nr[256];
- x_nr = strtok(cmdtext, idx);
- if(!strlen(x_nr))
- {
- SendClientMessage(playerid, COLOR_WHITE, "|__________________ Fahrzeug System __________________|");
- SendClientMessage(playerid, COLOR_WHITE, "Verwendung: /cveh Motor | Lichter | Kofferraum | Motorhaube");
- return 1;
- }
- if(strcmp(x_nr,"Motor",true) == 0)
- {
- if(GetPlayerState(playerid) != PLAYER_STATE_DRIVER)
- {
- return 1;
- }
- new engine,lights,alarm,doors,bonnet,boot,objective;
- new vid = GetPlayerVehicleID(playerid);
- GetVehicleParamsEx(vid,engine,lights,alarm,doors,bonnet,boot,objective);
- if(vid != INVALID_VEHICLE_ID)
- {
- if(engine == VEHICLE_PARAMS_ON)
- {
- SetVehicleParamsEx(vid,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Motor ~r~aus!", 2000, 5);
- }
- else
- {
- SetVehicleParamsEx(vid,VEHICLE_PARAMS_ON,lights,alarm,doors,bonnet,boot,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Motor ~g~an!", 2000, 5);
- }
- }
- }
- else if(strcmp(x_nr,"Lichter",true) == 0)
- {
- if(GetPlayerState(playerid) != PLAYER_STATE_DRIVER)
- {
- return 1;
- }
- new engine,lights,alarm,doors,bonnet,boot,objective;
- new vid = GetPlayerVehicleID(playerid);
- GetVehicleParamsEx(vid,engine,lights,alarm,doors,bonnet,boot,objective);
- if(vid != INVALID_VEHICLE_ID)
- {
- if(lights == VEHICLE_PARAMS_ON)
- {
- SetVehicleParamsEx(vid,engine,VEHICLE_PARAMS_OFF,alarm,doors,bonnet,boot,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Lichter ~r~aus!", 2000, 5);
- }
- else
- {
- SetVehicleParamsEx(vid,engine,VEHICLE_PARAMS_ON,alarm,doors,bonnet,boot,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Lichter ~g~an!", 2000, 5);
- }
- }
- }
- else if(strcmp(x_nr,"Kofferraum",true) == 0)
- {
- if(GetPlayerState(playerid) != PLAYER_STATE_DRIVER)
- {
- return 1;
- }
- new engine,lights,alarm,doors,bonnet,boot,objective;
- new vid = GetPlayerVehicleID(playerid);
- GetVehicleParamsEx(vid,engine,lights,alarm,doors,bonnet,boot,objective);
- if(vid != INVALID_VEHICLE_ID)
- {
- if(boot == VEHICLE_PARAMS_ON)
- {
- SetVehicleParamsEx(vid,engine,lights,alarm,doors,bonnet,VEHICLE_PARAMS_OFF,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Kofferraum ~r~geschlossen!", 2000, 5);
- }
- else
- {
- SetVehicleParamsEx(vid,engine,lights,alarm,doors,bonnet,VEHICLE_PARAMS_ON,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Kofferraum ~g~geoeffnet!", 2000, 5);
- }
- }
- }
- else if(strcmp(x_nr,"Motorhaube",true) == 0)
- {
- if(GetPlayerState(playerid) != PLAYER_STATE_DRIVER)
- {
- return 1;
- }
- new engine,lights,alarm,doors,bonnet,boot,objective;
- new vid = GetPlayerVehicleID(playerid);
- GetVehicleParamsEx(vid,engine,lights,alarm,doors,bonnet,boot,objective);
- if(vid != INVALID_VEHICLE_ID)
- {
- if(bonnet == VEHICLE_PARAMS_ON)
- {
- SetVehicleParamsEx(vid,engine,lights,alarm,doors,VEHICLE_PARAMS_OFF,boot,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Motorhaube ~r~geschlossen!", 2000, 5);
- }
- else
- {
- SetVehicleParamsEx(vid,engine,lights,alarm,doors,VEHICLE_PARAMS_ON,boot,objective);
- GameTextForPlayer(playerid, "~n~~n~~n~~n~~n~~n~~W~Motorhaube ~g~geoeffnet!", 2000, 5);
- }
- }
- }
- return 1;
- }
- if(strcmp(cmd,"/gmx",true)==0)
- {
- if(SpielerInfo[playerid][pAdmin] >= 1337)
- {
- SendRconCommand("gmx");
- return 1;
- }
- }
- if(strcmp(cmd,"/shutdown",true)==0)
- {
- if(SpielerInfo[playerid][pAdmin] >= 2000)
- {
- SendClientMessage(playerid,COLOR_GREY,"Server wird ausgeschaltet!");
- SendClientMessageToAll(COLOR_GREY,"Der Server wird ausgeschaltet!");
- SendRconCommand("exit");
- return 1;
- }
- }
- if(strcmp(cmd,"/help",true)==0)
- {
- SendClientMessage(playerid,COLOR_GREY,"Verfügbare Commands:");
- SendClientMessage(playerid,COLOR_GREY,"/cveh");
- return 1;
- }
- if(strcmp(cmd,"/ahelp",true)==0)
- {
- SendClientMessage(playerid,COLOR_GREY,"Verfügbare Commands:");
- if(SpielerInfo[playerid][pAdmin] >= 1)
- {
- SendClientMessage(playerid,COLOR_GREY,"**Supporter** /repairveh /kick /ban");
- }
- if(SpielerInfo[playerid][pAdmin] >= 2)
- {
- SendClientMessage(playerid,COLOR_GREY,"**Moderator** /unfreeze /freeze");
- }
- if(SpielerInfo[playerid][pAdmin] >= 3)
- {
- SendClientMessage(playerid,COLOR_GREY,"**Admin** ");
- }
- if(SpielerInfo[playerid][pAdmin] >= 4)
- {
- SendClientMessage(playerid,COLOR_GREY,"**Super Admin** ");
- }
- if(SpielerInfo[playerid][pAdmin] >= 1337)
- {
- SendClientMessage(playerid,COLOR_GREY,"**Server Manager** /gmx ");
- }
- if(SpielerInfo[playerid][pAdmin] >= 2000)
- {
- SendClientMessage(playerid,COLOR_GREY,"**Server Owner** /shutdown");
- }
- return 1;
- }
- if(strcmp(cmd,"/repairveh",true)==0)
- {
- if(SpielerInfo[playerid][pAdmin] >= 1)
- {
- new tmpcar = GetPlayerVehicleID(playerid);
- RepairVehicle(tmpcar);
- return 1;
- }
- }
- if(strcmp(cmd,"/getadmin",true)==0)
- {
- if(IsPlayerAdmin(playerid))
- {
- SpielerInfo[playerid][pAdmin] = 2000;
- SendClientMessage(playerid,COLOR_GREY,"Admin erfolgreich erhalten");
- return 1;
- }
- }
- return 0;
- }
- public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
- {
- return 1;
- }
- public OnPlayerExitVehicle(playerid, vehicleid)
- {
- return 1;
- }
- public OnPlayerStateChange(playerid, newstate, oldstate)
- {
- return 1;
- }
- public OnPlayerEnterCheckpoint(playerid)
- {
- return 1;
- }
- public OnPlayerLeaveCheckpoint(playerid)
- {
- return 1;
- }
- public OnPlayerEnterRaceCheckpoint(playerid)
- {
- return 1;
- }
- public OnPlayerLeaveRaceCheckpoint(playerid)
- {
- return 1;
- }
- public OnRconCommand(cmd[])
- {
- return 1;
- }
- public OnPlayerRequestSpawn(playerid)
- {
- return 1;
- }
- public OnObjectMoved(objectid)
- {
- return 1;
- }
- public OnPlayerObjectMoved(playerid, objectid)
- {
- return 1;
- }
- public OnPlayerPickUpPickup(playerid, pickupid)
- {
- return 1;
- }
- public OnVehicleMod(playerid, vehicleid, componentid)
- {
- return 1;
- }
- public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
- {
- return 1;
- }
- public OnVehicleRespray(playerid, vehicleid, color1, color2)
- {
- return 1;
- }
- public OnPlayerSelectedMenuRow(playerid, row)
- {
- return 1;
- }
- public OnPlayerExitedMenu(playerid)
- {
- return 1;
- }
- public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
- {
- return 1;
- }
- public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
- {
- return 1;
- }
- public OnRconLoginAttempt(ip[], password[], success)
- {
- return 1;
- }
- public OnPlayerUpdate(playerid)
- {
- if(GetPlayerSpecialAction(playerid) == SPECIAL_ACTION_USEJETPACK)
- {
- new tname[MAX_PLAYER_NAME], string[128];
- GetPlayerName(playerid, tname, sizeof(tname));
- format(string, sizeof(string), "Anticheatsystem: %s(%d) wurde gebannt. Grund: Jetpack",tname,playerid);
- SendClientMessageToAll(COLOR_RED, string);
- Ban(playerid);
- }
- return 1;
- }
- public OnPlayerStreamIn(playerid, forplayerid)
- {
- return 1;
- }
- public OnPlayerStreamOut(playerid, forplayerid)
- {
- return 1;
- }
- public OnVehicleStreamIn(vehicleid, forplayerid)
- {
- return 1;
- }
- public OnVehicleStreamOut(vehicleid, forplayerid)
- {
- return 1;
- }
- public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
- {
- switch(dialogid)
- {
- case DIALOG_REGISTER:
- {
- if(response)
- {
- if(strlen(inputtext) == 0)
- {
- ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Register","Das angegebene Passwort war zu Kurz...\nBitte Registrier dich jetzt mit einem Passwort:","Register","Abbrechen");
- return 1;
- }
- else
- {
- CreateAccount(playerid, inputtext);
- SetPVarInt(playerid,"Eingeloggt",1);
- SpawnPlayer(playerid);
- return 1;
- }
- }
- else
- {
- Kick(playerid);
- }
- }
- case DIALOG_LOGIN:
- {
- if(response)
- {
- if(strlen(inputtext) == 0)
- {
- ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Das Angegebene Passwort war Falsch.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
- return 1;
- }
- else
- {
- new SpielerName[MAX_PLAYER_NAME];
- GetPlayerName(playerid, SpielerName, MAX_PLAYER_NAME);
- if(!strcmp(inputtext, mysql_ReturnPasswort(SpielerName), true))
- {
- SetPVarInt(playerid,"Eingeloggt",1);
- LoadPlayer(playerid);
- SpawnPlayer(playerid);
- return 1;
- }
- else
- {
- ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Das war das Falsche Passwort.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
- return 1;
- }
- }
- }
- else
- {
- Kick(playerid);
- }
- }
- }
- return 1;
- }
- public OnPlayerClickPlayer(playerid, clickedplayerid, source)
- {
- return 1;
- }
- public UpdateZeit()
- {
- gettime(Stunde, Minute);
- format(UhrString,32,"%02d:%02d",Stunde, Minute);
- TextDrawSetString(Uhr,UhrString);
- SetWorldTime(Stunde);
- new x=0;
- while(x!=MAX_PLAYERS)
- {
- if(IsPlayerConnected(x) && GetPlayerState(x) != PLAYER_STATE_NONE)
- {
- SetPlayerTime(x,Stunde,Minute);
- }
- x++;
- }
- }
- public CheckForRestart()
- {
- new thour, tmin, tsec;
- gettime(thour,tmin,tsec);
- if(thour == RESTART_HOUR && tmin == RESTART_MINS)
- {
- print(" Automatischer GMX ");
- SendRconCommand("gmx");
- }
- return 1;
- }
- stock Connect_To_Database()
- {
- mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
- if(mysql_ping() == 1)
- {
- print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
- return true;
- }
- else
- {
- print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
- print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
- mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
- if(mysql_ping() == 1)
- {
- print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
- return true;
- }
- else
- {
- print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
- print("<-| [MYSQL] Der Server wird nun beendet!");
- SendRconCommand("exit");
- return true;
- }
- }
- }
- stock mysql_CheckAccount(playerid)
- {
- new Query[128],Name[MAX_PLAYER_NAME];
- GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
- mysql_real_escape_string(Name, Name);
- format(Query, sizeof(Query), "SELECT * FROM accounts WHERE Name = '%s'", Name);
- mysql_query(Query);
- mysql_store_result();
- return mysql_num_rows();
- }
- stock CreateAccount(playerid, pass[])
- {
- new query[256],Name[MAX_PLAYER_NAME];
- GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
- mysql_real_escape_string(Name,Name);
- mysql_real_escape_string(pass,pass);
- format(query, sizeof(query), "INSERT INTO accounts (Name, Passwort) VALUES ('%s', '%s')", Name, pass);
- mysql_query(query);
- return true;
- }
- stock mysql_ReturnPasswort(Name[])
- {
- new query[130], Get[130];
- mysql_real_escape_string(Name, Name);
- format(query, 128, "SELECT passwort FROM accounts WHERE Name = '%s'", Name);
- mysql_query(query);
- mysql_store_result();
- mysql_fetch_row(Get);
- mysql_free_result();
- return Get;
- }
- stock LoadPlayer(playerid)
- {
- if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
- {
- GetPlayerName(playerid, SpielerInfo[playerid][pName], MAX_PLAYER_NAME);
- SpielerInfo[playerid][pLevel] = mysql_GetInt("accounts", "Level", "Name", SpielerInfo[playerid][pName]);
- SpielerInfo[playerid][pGeld] = mysql_GetInt("accounts", "Geld", "Name", SpielerInfo[playerid][pName]);
- SpielerInfo[playerid][pKills] = mysql_GetInt("accounts", "Kills", "Name", SpielerInfo[playerid][pName]);
- SpielerInfo[playerid][pTode] = mysql_GetInt("accounts", "Tode", "Name", SpielerInfo[playerid][pName]);
- SpielerInfo[playerid][pAdmin] = mysql_GetInt("accounts", "Admin", "Name", SpielerInfo[playerid][pName]);
- SpielerInfo[playerid][pGebannt] = mysql_GetInt("accounts", "Gebannt", "Name", SpielerInfo[playerid][pName]);
- if(SpielerInfo[playerid][pGebannt] == 1)
- {
- Ban(playerid);
- }
- }
- return 1;
- }
- stock mysql_GetInt(Table[], Field[], Where[], Is[])
- {
- new query[128];
- mysql_real_escape_string(Table, Table);
- mysql_real_escape_string(Field, Field);
- mysql_real_escape_string(Where, Where);
- mysql_real_escape_string(Is, Is);
- format(query, 128, "SELECT %s FROM %s WHERE %s = '%s'", Field, Table, Where, Is);
- mysql_query(query);
- mysql_store_result();
- new sqlint = mysql_fetch_int();
- mysql_free_result();
- return sqlint;
- }
- stock mysql_GetString(Table[], Field[], Where[], Is[])
- {
- new query[128], Get[128];
- mysql_real_escape_string(Table, Table);
- mysql_real_escape_string(Field, Field);
- mysql_real_escape_string(Where, Where);
- mysql_real_escape_string(Is, Is);
- format(query, 128, "SELECT %s FROM %s WHERE %s = '%s'", Field, Table, Where, Is);
- mysql_query(query);
- mysql_store_result();
- mysql_fetch_row(Get);
- return Get;
- }
- stock Flaot:mysql_GetFloat(Table[], Field[], Where[], Is[])
- {
- new query[128], Float:sqlfloat;
- mysql_real_escape_string(Table, Table);
- mysql_real_escape_string(Field, Field);
- mysql_real_escape_string(Where, Where);
- mysql_real_escape_string(Is, Is);
- format(query, 128, "SELECT %s FROM %s WHERE %s = '%s'", Field, Table, Where, Is);
- mysql_query(query);
- mysql_store_result();
- mysql_fetch_float(sqlfloat);
- mysql_free_result();
- return sqlfloat;
- }
- stock SavePlayer(playerid)
- {
- if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
- {
- if(GetPVarInt(playerid,"Eingeloggt") == 1)
- {
- mysql_SetInt("accounts", "Level", SpielerInfo[playerid][pLevel], "Name", SpielerInfo[playerid][pName]);
- mysql_SetInt("accounts", "Geld", SpielerInfo[playerid][pGeld], "Name", SpielerInfo[playerid][pName]);
- mysql_SetInt("accounts", "Kills", SpielerInfo[playerid][pKills], "Name", SpielerInfo[playerid][pName]);
- mysql_SetInt("accounts", "Tode", SpielerInfo[playerid][pTode], "Name", SpielerInfo[playerid][pName]);
- mysql_SetFloat("accounts", "Health", SpielerInfo[playerid][pHealth], "Name", SpielerInfo[playerid][pName]);
- mysql_SetInt("accounts", "Admin", SpielerInfo[playerid][pAdmin], "Name", SpielerInfo[playerid][pName]);
- mysql_SetInt("accounts", "Gebannt", SpielerInfo[playerid][pGebannt], "Name", SpielerInfo[playerid][pName]);
- }
- }
- return 1;
- }
- stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
- {
- new query[128];
- mysql_real_escape_string(Table, Table);
- mysql_real_escape_string(Field, Field);
- mysql_real_escape_string(Where, Where);
- mysql_real_escape_string(Where2, Where2);
- format(query, 128, "UPDATE %s SET %s = '%d' WHERE %s = '%s'", Table, Field, To, Where, Where2);
- mysql_query(query);
- return true;
- }
- stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
- {
- new query[128];
- mysql_real_escape_string(Table, Table);
- mysql_real_escape_string(Field, Field);
- mysql_real_escape_string(To, To);
- mysql_real_escape_string(Where, Where);
- mysql_real_escape_string(Where2, Where2);
- format(query, 128, "UPDATE %s SET %s = '%s' WHERE %s = '%s'", Table, Field, To, Where, Where2);
- mysql_query(query);
- return true;
- }
- stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
- {
- new query[128];
- mysql_real_escape_string(Table, Table);
- mysql_real_escape_string(Field, Field);
- mysql_real_escape_string(Where, Where);
- mysql_real_escape_string(Where2, Where2);
- format(query, 128, "UPDATE %s SET %s = '%.1f' WHERE %s = '%s'", Table, Field, To, Where, Where2);
- mysql_query(query);
- return true;
- }
- stock strtok(const string[], &index)
- {
- new length = strlen(string);
- while ((index < length) && (string[index] <= ' '))
- {
- index++;
- }
- new offset = index;
- new result[20];
- while ((index < length) && (string[index] > ' ') && ((index - offset) < (sizeof(result) - 1)))
- {
- result[index - offset] = string[index];
- index++;
- }
- result[index - offset] = EOS;
- return result;
- }
- public KickLog(string[])
- {
- new entry[256];
- format(entry, sizeof(entry), "%s\n",string);
- new File:hFile;
- hFile = fopen("kicks.log", io_append);
- fwrite(hFile, entry);
- fclose(hFile);
- }
- public BanLog(string[])
- {
- new entry[256];
- format(entry, sizeof(entry), "%s\n",string);
- new File:hFile;
- hFile = fopen("bans.log", io_append);
- fwrite(hFile, entry);
- fclose(hFile);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement