Guest User

Untitled

a guest
Jul 17th, 2018
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.38 KB | None | 0 0
  1. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  2. {
  3. if(dialogid == DIALOG_REGISTER) {
  4. if(strlen(inputtext) == 0) {
  5. ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FF0000}Register","Introdu o parola ca sa creezi un cont!","Register!","");
  6. }
  7. else {
  8. new EscapedText[60], string[256];
  9. mysql_real_escape_string(inputtext, EscapedText);
  10. format(string, sizeof(string), "INSERT INTO `users` (name,password,Level,Money VALUES (`%s`,`%s`,`1`,`15000`)", GetName(playerid), EscapedText[playerid]);
  11. mysql_query(SQL, string);
  12. SendClientMessage(playerid, COLOR_INFO, "Ti-ai creet un cont cu succes!");
  13. GivePlayerMoney(playerid, 15000);
  14. SetPlayerScore(playerid, 1);
  15. }
  16. }
  17. if(dialogid == DIALOG_LOGIN)
  18. {
  19. if(strlen(inputtext) == 0)
  20. {
  21. ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FF0000}Register","Introdu o parola ca sa creezi un cont!","Register!",""); }
  22. }
  23. else
  24. {
  25. LoginPlayer(playerid, inputtext);
  26. }
  27. }
  28. return 1;
  29. }
  30.  
  31. stock si forward:
  32.  
  33. stock ConnectMySQL()
  34. {
  35. mysql_connect(SQL_HOST,SQL_USER,SQL_DB,SQL_PASS);
  36. if(mysql_ping() == 1)
  37. {
  38. mysql_debug(1);
  39. printf("[MYSQL]: Connection to `%s` succesful!",SQL_DB);
  40. }
  41. else
  42. {
  43. printf("[MYSQL]: [ERROR]: Connection to `%s` failed!",SQL_DB);
  44. }
  45. return 1;
  46. }
  47.  
  48. stock GetName(playerid) {
  49. new name[MAX_PLAYER_NAME];
  50. GetPlayerName(playerid, name, sizeof(name));
  51. return name;
  52. }
  53.  
  54. stock LoadStats(playerid)
  55. {
  56. new pName[24],string[128];
  57. GetPlayerName(playerid,pName,24);
  58. format(string, sizeof(string), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
  59. mysql_query(SQL, string);
  60. mysql_store_result();
  61. mysql_fetch_row_format(string, "|");
  62. sscanf(string, "e<p<|>s[24]s[23]i>", PlayerInfo[playerid]);
  63. mysql_free_result();
  64. GivePlayerMoney(playerid,PlayerInfo[playerid][pMoney]);
  65. return 1;
  66. }
  67. forward LoginPlayer(playerid, const password[]);
  68. public LoginPlayer(playerid, const password[])
  69. {
  70. new EscapedText[60], string[256];
  71. mysql_real_escape_string(password, EscapedText);
  72. format(string, sizeof(string), "SELECT * FROM `users` WHERE `name` = '%s' AND `password` = '%s'", GetName(playerid), EscapedText);
  73. mysql_query(SQL, string);
  74. mysql_store_result();
  75. if(mysql_num_rows() != 0)
  76. {
  77. SendClientMessage(playerid, COLOR_INFO, "You have been logged in!");
  78. LoadStats(playerid);
  79. }
  80. else
  81. {
  82. SendClientMessage(playerid, COLOR_RED, "Wrong password!");
  83. Kick(playerid);
  84. }
  85. mysql_free_result();
  86. return 1;
  87. }
  88.  
  89. si la OnPlayerConnect am :
  90.  
  91. public OnPlayerConnect(playerid)
  92. {
  93. new string[128], name[MAX_PLAYER_NAME];
  94. GetPlayerName(playerid, name, sizeof(name));
  95. format(string, sizeof(string), "SELECT `name` FROM `users` WHERE `name`=`%s` LIMIT 1", name);
  96. mysql_query(SQL, string);
  97. if(mysql_num_rows() != 0) {
  98. format(string,sizeof(string),"Salut %s, contul tau este inregistrat!\nIntrodu parola pentru a continua!", name);
  99. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "{FF0000}Login", string, "Login","");
  100. }
  101. else {
  102. format(string,sizeof(string),"Salut %s, contul tau nu este inregistrat!\nIntrodu parola pentru a creea un cont!", name);
  103. ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "{FF0000}Register", string, "Register","");
  104. }
  105. mysql_free_result();
  106.  
  107. InitFly(playerid);
  108. return 1;
  109. }
Advertisement
Add Comment
Please, Sign In to add comment