Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ////////////////////////////////////////////////////////////////////////////////
- // //
- // Dieses Script wurde von Buzzy gescriptet und ist Copyright (c) //
- // geschützt. Das weitergeben/verkaufen wird zu einer Anzeige //
- // Gebracht //
- // //
- // //
- // (c) Copyright by Buzzy //
- ////////////////////////////////////////////////////////////////////////////////
- //==============================================================================
- //============================> Includes <======================================
- #include <a_samp>
- #include <a_mysql>
- #include <streamer>
- #include <sscanf2>
- //==============================================================================
- //============================> ServerDaten <===================================
- #define ServerName "NewLife-Roleplay"
- #define ServerMode "German Roleplay"
- #define ServerTag "[NLR]"
- #define ServerFarbe ""
- #define ServerOwner "Buzzy und Saaltofreak"
- #define ServerScripter "Buzzy"
- #define ServerCopyright"(c) by Buzzy"
- //MySQL
- #define SQL_HOST "127.0.0.1"
- #define SQL_USER "root"
- #define SQL_DATA "samp"
- #define SQL_PASS ""
- //==============================================================================
- //============================> Defines <=======================================
- //Dialoge
- #define DIALOG_REGISTER (1)
- #define DIALOG_LOGIN (2)
- //==============================================================================
- //============================> Enums <=========================================
- enum SpielerDaten {
- pEingeloggt,
- pLevel,
- pGeld
- };
- //==============================================================================
- //============================> Globare Variabeln <=============================
- new Handle;
- new sInfo[MAX_PLAYERS][SpielerDaten];
- //==============================================================================
- //============================> ScriptBeginn <==================================
- main() {}
- public OnGameModeInit()
- {
- SetGameModeText(ServerMode);
- //MySQL
- Connect_To_Database();
- return 1;
- }
- public OnGameModeExit()
- {
- //MySQL
- mysql_close(Handle);
- return 1;
- }
- public OnPlayerRequestClass(playerid, classid)
- {
- return 1;
- }
- public OnPlayerConnect(playerid)
- {
- //MySQL Login/Register
- new query[256];
- format(query, sizeof(query), "SELECT id FROM user WHERE username='%s'", SpielerName(playerid));
- mysql_function_query(Handle, query, true, "OnUserCheck", "i", playerid);
- return 1;
- }
- public OnPlayerDisconnect(playerid, reason)
- {
- return 1;
- }
- public OnPlayerSpawn(playerid)
- {
- return 1;
- }
- public OnPlayerDeath(playerid, killerid, reason)
- {
- return 1;
- }
- public OnVehicleSpawn(vehicleid)
- {
- return 1;
- }
- public OnVehicleDeath(vehicleid, killerid)
- {
- return 1;
- }
- public OnPlayerText(playerid, text[])
- {
- return 1;
- }
- public OnPlayerCommandText(playerid, cmdtext[])
- {
- if (strcmp("/mycommand", cmdtext, true, 10) == 0)
- {
- 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)
- {
- 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[])
- {
- if(dialogid == DIALOG_REGISTER)
- {
- if(response)
- {
- if(strlen(inputtext) >= 5)
- {
- //Regestrierung
- new query[256], passwort[32];
- mysql_escape_string(inputtext, passwort, Handle);
- format(query, sizeof(query), "INSERT INTO user (username, password) VALUES ('%s', '%s')", SpielerName(playerid), passwort);
- mysql_function_query(Handle, query, false, "", "");
- }
- else
- {
- SendClientMessage(playerid, -1, "Dein Passwort muss mindestens 5 Zeichen lang sein!");
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""ServerTag"Regestrierung", "Bitte gebe ein Passwort ein:", "Anmelden", "Abbrechen");
- return 1;
- }
- }
- else
- {
- Kick(playerid);
- return 1;
- }
- return 1;
- }
- if(dialogid == DIALOG_LOGIN)
- {
- if(response)
- {
- new query[128], passwort[32];
- if(strlen(inputtext) > 0)
- {
- mysql_escape_string(inputtext, passwort, Handle);
- format(query, sizeof(query), "SELECT * FROM user WHERE username='%s' AND password='%s'", SpielerName(playerid), passwort);
- mysql_function_query(Handle, query, true, "OnPasswortResponse", "i", SpielerName(playerid));
- }
- else
- {
- //Keine Eingabe
- SendClientMessage(playerid, -1, "Gib bitte dein Passwort ein!");
- ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, ""ServerTag"Login", "Bitte gebe ein Passwort ein:", "Login", "Abbrechen");
- return 1;
- }
- }
- else
- {
- Kick(playerid);
- return 1;
- }
- return 1;
- }
- return 1;
- }
- public OnPlayerClickPlayer(playerid, clickedplayerid, source)
- {
- return 1;
- }
- //==============================================================================
- //============================> Public's <=======================================
- forward OnUserCheck(playerid);
- public OnUserCheck(playerid)
- {
- new num_rows, num_fields;
- cache_get_data(num_rows, num_fields, Handle);
- if(num_fields == 1)
- {
- //Registrierung
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""ServerTag"Regestrierung", "Bitte gebe ein Passwort ein:", "Anmelden", "Abbrechen");
- }
- else
- {
- //Login
- ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, ""ServerTag"Login", "Bitte gebe ein Passwort ein:", "Login", "Abbrechen");
- }
- return 1;
- }
- forward OnPasswortResponse(playerid);
- public OnPasswortResponse(playerid)
- {
- new num_rows, num_fields;
- cache_get_data(num_rows, num_fields, Handle);
- if(num_rows == 1)
- {
- //Passwort richtig
- SpielerLaden(playerid);
- }
- else
- {
- //Passwort falsch
- SendClientMessage(playerid, -1, "Das eingegebene Passwort ist falsch!");
- ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, ""ServerTag"Login", "Bitte gebe ein Passwort ein:", "Login", "Abbrechen");
- }
- return 1;
- }
- //==============================================================================
- //============================> Stock's <=======================================
- stock Connect_To_Database()
- {
- Handle = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
- if(mysql_errno(Handle) == 0)
- {
- printf("|>MySQL<| - Es konnte Verbindung zur der Datenbank "SQL_DATA" aufgebaut werden");
- }
- else
- {
- printf("|>MySQL<| - Es konnte keine Verbindung aufgebaut werden!");
- SendRconCommand("exit");
- }
- return 1;
- }
- stock SpielerName(playerid)
- {
- new name[MAX_PLAYERS];
- GetPlayerName(playerid,name,sizeof(name));
- return name;
- }
- stock SpielerLaden(playerid)
- {
- sInfo[playerid][pEingeloggt] = 1;
- sInfo[playerid][pLevel] = cache_get_field_content_int(0,"Level",Handle);
- printf("Der Spieler %s hat das Level %i", SpielerName(playerid), sInfo[playerid][pLevel]);
- return 1;
- }
- stock SpielerSpeichern(playerid)
- {
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement