Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
- {
- if(dialogid == DIALOG_REGISTER) {
- if(strlen(inputtext) == 0) {
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FF0000}Register","Introdu o parola ca sa creezi un cont!","Register!","");
- }
- else {
- new EscapedText[60], string[256];
- mysql_real_escape_string(inputtext, EscapedText);
- format(string, sizeof(string), "INSERT INTO `users` (name,password,Level,Money VALUES (`%s`,`%s`,`1`,`15000`)", GetName(playerid), EscapedText[playerid]);
- mysql_query(SQL, string);
- SendClientMessage(playerid, COLOR_INFO, "Ti-ai creet un cont cu succes!");
- GivePlayerMoney(playerid, 15000);
- SetPlayerScore(playerid, 1);
- }
- }
- if(dialogid == DIALOG_LOGIN)
- {
- if(strlen(inputtext) == 0)
- {
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FF0000}Register","Introdu o parola ca sa creezi un cont!","Register!",""); }
- }
- else
- {
- LoginPlayer(playerid, inputtext);
- }
- }
- return 1;
- }
- stock si forward:
- stock ConnectMySQL()
- {
- mysql_connect(SQL_HOST,SQL_USER,SQL_DB,SQL_PASS);
- if(mysql_ping() == 1)
- {
- mysql_debug(1);
- printf("[MYSQL]: Connection to `%s` succesful!",SQL_DB);
- }
- else
- {
- printf("[MYSQL]: [ERROR]: Connection to `%s` failed!",SQL_DB);
- }
- return 1;
- }
- stock GetName(playerid) {
- new name[MAX_PLAYER_NAME];
- GetPlayerName(playerid, name, sizeof(name));
- return name;
- }
- stock LoadStats(playerid)
- {
- new pName[24],string[128];
- GetPlayerName(playerid,pName,24);
- format(string, sizeof(string), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
- mysql_query(SQL, string);
- mysql_store_result();
- mysql_fetch_row_format(string, "|");
- sscanf(string, "e<p<|>s[24]s[23]i>", PlayerInfo[playerid]);
- mysql_free_result();
- GivePlayerMoney(playerid,PlayerInfo[playerid][pMoney]);
- return 1;
- }
- forward LoginPlayer(playerid, const password[]);
- public LoginPlayer(playerid, const password[])
- {
- new EscapedText[60], string[256];
- mysql_real_escape_string(password, EscapedText);
- format(string, sizeof(string), "SELECT * FROM `users` WHERE `name` = '%s' AND `password` = '%s'", GetName(playerid), EscapedText);
- mysql_query(SQL, string);
- mysql_store_result();
- if(mysql_num_rows() != 0)
- {
- SendClientMessage(playerid, COLOR_INFO, "You have been logged in!");
- LoadStats(playerid);
- }
- else
- {
- SendClientMessage(playerid, COLOR_RED, "Wrong password!");
- Kick(playerid);
- }
- mysql_free_result();
- return 1;
- }
- si la OnPlayerConnect am :
- public OnPlayerConnect(playerid)
- {
- new string[128], name[MAX_PLAYER_NAME];
- GetPlayerName(playerid, name, sizeof(name));
- format(string, sizeof(string), "SELECT `name` FROM `users` WHERE `name`=`%s` LIMIT 1", name);
- mysql_query(SQL, string);
- if(mysql_num_rows() != 0) {
- format(string,sizeof(string),"Salut %s, contul tau este inregistrat!\nIntrodu parola pentru a continua!", name);
- ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "{FF0000}Login", string, "Login","");
- }
- else {
- format(string,sizeof(string),"Salut %s, contul tau nu este inregistrat!\nIntrodu parola pentru a creea un cont!", name);
- ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "{FF0000}Register", string, "Register","");
- }
- mysql_free_result();
- InitFly(playerid);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment