Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //SQLite LOGIN/REGISTER SCRIPT
- //Es ist NICHTS besonderes, es soll nur leuten helfen, die mit SQLite arbeiten wollen, aber keine idee haben wie sie mit einem login system anfangen soll
- //Schaut doch mal auf meinem Youtube Kanal vorbei. http://www.youtube.com/user/Music4You43
- //================ INCLUDES ================
- #include <a_samp>
- #include <ocmd>
- #include <Limit>
- #include <md5>
- //================ SERVERDEFINES ================
- #define servername Reallife
- #define SCM SendClientMessage
- #define rot 0xFF0A00FF
- #define gruen 0x4BB400FF
- #define orange 0xFF9600FF
- #define grau 0xB4B4B4FF
- //================ NEWS ================
- new DB:Data;
- //================ ENUMS ================
- enum user
- {
- pName[MAX_PLAYER_NAME],
- pLogged,
- }
- new UserInfo[MAX_PLAYERS][user];
- enum
- {
- DIALOG_REG,
- DIALOG_LOG,
- DIALOG_START,
- }
- main()
- {
- return 1;
- }
- public OnGameModeInit()
- {
- Data = db_open("Script.db");
- SetGameModeText(#servername);
- AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
- createtable();
- print("====================================================");
- print("SQLite Grundscript by Items4Landwird aka. Music4You");
- print("====================================================\n");
- return 1;
- }
- public OnGameModeExit()
- {
- new i=0;
- for(;i<MAX_PLAYERS;i++)
- {
- SavePlayer(i);
- }
- return 1;
- }
- public OnPlayerRequestClass(playerid, classid)
- {
- new DBResult:Result,str[75],rows,string[400];
- #pragma unused rows
- format(str,sizeof(str),"SELECT * FROM `accounts` WHERE Name = '%s'",SpielerName(playerid));
- Result=db_query(Data,str);
- if(db_num_rows(Result) > 0)
- {
- format(string,sizeof(string),"Herzlich Willkommen Zurück %s, auf ["#servername"]\n\nGebe dein Passwort ein\nBitte halte dich an die Regeln\n\nViel spaß wünscht dir das Adminteam von ["#servername"]",SpielerName(playerid));
- ShowPlayerDialog(playerid,DIALOG_LOG,DIALOG_STYLE_PASSWORD,"Login",string,"Weiter","");
- }
- else
- {
- format(string,sizeof(string),"Herzlich Willkommen %s, auf ["#servername"]\n\nUm auf unseren Server spielen zu können benötigst du ein Sicheres Passwort\nBitte halte dich an die Regeln\n\nViel spaß wünscht dir das Adminteam von ["#servername"]",SpielerName(playerid));
- ShowPlayerDialog(playerid,DIALOG_REG,DIALOG_STYLE_PASSWORD,"Register",string,"Weiter","");
- }
- db_free_result(Result);
- return 1;
- }
- public OnPlayerConnect(playerid)
- {
- return 1;
- }
- public OnPlayerDisconnect(playerid, reason)
- {
- SavePlayer(playerid);
- UserInfo[playerid][pLogged]=0;
- return 1;
- }
- public OnPlayerSpawn(playerid)
- {
- if(UserInfo[playerid][pLogged]!=1)return 0;
- 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[])
- {
- return 1;
- }
- 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[])
- {
- switch(dialogid)
- {
- case DIALOG_REG:
- {
- if(response)
- {
- new string[400],query[400];
- if(!strlen(inputtext))
- {
- format(string,sizeof(string),"%s, Gebe ein Passwort ein\n\nUm auf unseren Server spielen zu können benötigst du ein Sicheres Passwort\nBitte halte dich an die Regeln\n\nViel spaß wünscht dir das Adminteam von ["#servername"]",SpielerName(playerid));
- ShowPlayerDialog(playerid,DIALOG_REG,DIALOG_STYLE_PASSWORD,"Register",string,"Weiter","");
- }
- format(query,sizeof(query),"INSERT INTO `accounts` (`Name`,`Passwort`,`Geld`,`Level`) VALUES ('%s','%s','1000','1')",SpielerName(playerid),MD5_Hash(inputtext));
- db_query(Data,query);
- GivePlayerMoney(playerid,1000);
- SetPlayerScore(playerid,1);
- SpawnPlayer(playerid);
- }
- else return Kick(playerid);
- }
- case DIALOG_LOG:
- {
- if(response)
- {
- new DBResult:Result,str[75],rows,string[400],query[128];
- #pragma unused rows
- format(str,sizeof(str),"SELECT * FROM `accounts` WHERE Name = '%s' AND Passwort='%s'",SpielerName(playerid),MD5_Hash(inputtext));
- Result=db_query(Data,str);
- if(db_num_rows(Result) > 0)
- {
- db_get_field_assoc(Result,"Level",str,sizeof(str));
- SetPlayerScore(playerid,strval(str));
- db_get_field_assoc(Result,"Geld",str,sizeof(str));
- GivePlayerMoney(playerid,strval(str));
- SpawnPlayer(playerid);
- UserInfo[playerid][pLogged]=1;
- SCM(playerid,gruen,"Erfolgreich eingeloggt");
- format(query,sizeof(query),"UPDATE `accounts` SET `IP`='%s' WHERE `Name`='%s'",SpielerIP(playerid),SpielerName(playerid));
- db_query(Data,query);
- }
- else
- {
- format(string,sizeof(string),"%s, Gebe dein Passwort ein\n\nBitte halte dich an die Regeln\n\nViel spaß wünscht dir das Adminteam von ["#servername"]",SpielerName(playerid));
- ShowPlayerDialog(playerid,DIALOG_LOG,DIALOG_STYLE_PASSWORD,"Login",string,"Weiter","");
- }
- }
- }
- }
- return 1;
- }
- public OnPlayerClickPlayer(playerid, clickedplayerid, source)
- {
- return 1;
- }
- stock createtable()
- {
- db_query(Data,"CREATE TABLE IF NOT EXISTS `accounts`(`Name`,`Passwort`,`IP`,`Geld`,`Level`)");
- print("Tabellen erstellt");
- return 1;
- }
- stock SpielerName(playerid)
- {
- new name[MAX_PLAYER_NAME];
- GetPlayerName(playerid,name,sizeof(name));
- return name;
- }
- stock SpielerIP(playerid)
- {
- new getip[16];
- GetPlayerIp(playerid,getip,sizeof(getip));
- return getip;
- }
- stock SavePlayer(playerid)
- {
- new query[400];
- format(query,sizeof(query),"UPDATE `accounts` SET `Level`='%d',`Geld`='%d',`IP`='%s' WHERE `Name`='%s'",
- GetPlayerScore(playerid),GetPlayerMoney(playerid),SpielerIP(playerid),SpielerName(playerid));
- db_query(Data,query);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement