Advertisement
Guest User

Why ?

a guest
Aug 16th, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.49 KB | None | 0 0
  1. #include <a_samp>
  2. #include <a_mysql>
  3. #include <foreach>
  4. #include <sscanf2>
  5. #include <zcmd>
  6.  
  7. #define mysql_host "localhost"
  8. #define mysql_db "server3"
  9. #define mysql_user "root"
  10. #define mysql_pass ""
  11.  
  12. #define SCM SendClientMessage
  13. #define SCMALL SendClientMessageToAll
  14.  
  15. enum
  16. {
  17. DIALOG_REGISTER,
  18. DIALOG_LOGIN,
  19. DIALOG_AGE,
  20. DIALOG_SEX,
  21. DIALOG_EMAIL
  22. };
  23.  
  24. enum pInfo
  25. {
  26. pSQLID,
  27. pPassword,
  28. pAdmin,
  29. pHelper,
  30. pMoney
  31. };
  32.  
  33. new PlayerInfo[MAX_PLAYERS][pInfo];
  34. new MySQL:g_Sql, query[255];
  35.  
  36. AntiDeAMX()
  37. {
  38. new a[][] =
  39. {
  40. "Unarmed (Fist)",
  41. "Brass K"
  42. };
  43. #pragma unused a
  44. }
  45.  
  46. main()
  47. {
  48. }
  49.  
  50. public OnGameModeInit()
  51. {
  52. MySQLConnect();
  53. mysql_log(ERROR | WARNING);
  54.  
  55. SetGameModeText("GM v0.1");
  56.  
  57. AntiDeAMX();
  58. DisableInteriorEnterExits();
  59. ShowPlayerMarkers(0);
  60. EnableStuntBonusForAll(0);
  61. ManualVehicleEngineAndLights();
  62. UsePlayerPedAnims();
  63. SetNameTagDrawDistance(30);
  64. return 1;
  65. }
  66.  
  67. public OnGameModeExit()
  68. {
  69. mysql_close(g_Sql);
  70. return 1;
  71. }
  72.  
  73. public OnPlayerConnect(playerid)
  74. {
  75. mysql_format(g_Sql, query, sizeof(query), "SELECT * FROM users WHERE Name = '%s'", GetName(playerid));
  76. mysql_tquery(g_Sql, query, "OnPlayerLogin", "i", playerid);
  77.  
  78. InterpolateCameraPos(playerid,-2598.7400, 1692.5800, 26.3600, -2612.3101, 1729.8500, 35.0100, 20000, CAMERA_MOVE);
  79. InterpolateCameraLookAt(playerid,-2599.1101, 1693.5000, 26.6500,-2612.6399, 1730.7900, 35.2200, 20000, CAMERA_MOVE);
  80. SetPlayerCameraPos(playerid, -2317.1001, 2667.8899, 118.0400);
  81. SetPlayerCameraLookAt(playerid, -2317.3899, 2666.9299, 117.5900);
  82. return 1;
  83. }
  84.  
  85. public OnPlayerSpawn(playerid)
  86. {
  87. SetPlayerPos(playerid, 1529.6, -1691.2, 13.3);
  88. return 1;
  89. }
  90.  
  91. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  92. {
  93. new ip[25];
  94. switch(dialogid)
  95. {
  96. case DIALOG_REGISTER:
  97. {
  98. if(!response) return Kick(playerid);
  99. if(response)
  100. {
  101. if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Parola Incorecta!", "Introdu-ti o parola pentru a te inregistra pe server!", "Inregistreaza", "Exit");
  102. GetPlayerIp(playerid, ip, sizeof(ip));
  103. SCM(playerid, -1, "Te rog sa-ti introduci varsta.");
  104. mysql_format(g_Sql, query, sizeof(query), "INSERT INTO users (Name, Password, IP, Admin, Helper, Money) VALUES ('%s', '%e', '%s', '0','0','1500')", GetName(playerid), inputtext, ip);
  105. mysql_query(g_Sql, query);
  106. ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "Varsta!", "Te rog sa-ti introduci mai jos varsta.", "Continua", "Exit");
  107. }
  108. return 1;
  109. }
  110. case DIALOG_LOGIN:
  111. {
  112. if(!response) return Kick(playerid);
  113. if(response)
  114. {
  115. if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Parola Incorecta!", "Te rog sa-ti introduci parola corecta mai jos\nDaca ai uitat parola o poti recupera pe panel.", "Login", "Exit");
  116. mysql_format(g_Sql, query, sizeof(query), "SELECT * FROM `users` WHERE `Name`='%e' AND `Password`='%s'", GetName(playerid), inputtext);
  117. mysql_tquery(g_Sql, query, "OnLogin", "i", playerid);
  118. }
  119. return 1;
  120. }
  121. case DIALOG_AGE:
  122. {
  123. if(!response) return ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "Varsta!", "Te rog sa-ti introduci mai jos varsta.", "Continua", "Exit");
  124. if(response)
  125. {
  126. if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "Varsta!", "Te rog sa-ti introduci mai jos varsta.", "Continua", "Exit");
  127. SCM(playerid, -1, "Te rog sa-ti introduci email-ul, pentru contact si a pentru a-ti putea recupera contul.");
  128. mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Age`='%e' WHERE `Name`='%e'", inputtext, GetName(playerid));
  129. mysql_query(g_Sql, query);
  130. ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Ă‹mail", "Te rog sa-ti introduci email-ul mai jos.", "Continua", "Exit");
  131. }
  132. return 1;
  133. }
  134. case DIALOG_EMAIL:
  135. {
  136. if(!response) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Ă‹mail", "Te rog sa-ti introduci email-ul mai jos.", "Continua", "Exit");
  137. if(response)
  138. {
  139. if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "Ă‹mail", "Te rog sa-ti introduci email-ul mai jos.", "Continua", "Exit");
  140. SCM(playerid, -1, "Te rog sa-ti alegi sexul.");
  141. mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Email`='%e' WHERE `Name`='%e'", inputtext, GetName(playerid));
  142. mysql_query(g_Sql, query);
  143. ShowPlayerDialog(playerid, DIALOG_SEX, DIALOG_STYLE_MSGBOX, "Gen", "Te rog sa-ti alegi genul de mai jos.", "Masculin", "Feminin");
  144. }
  145. return 1;
  146. }
  147. case DIALOG_SEX:
  148. {
  149. if(response)
  150. {
  151. mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Sex`='1' WHERE `Name`='%e'", GetName(playerid));
  152. mysql_query(g_Sql, query);
  153. SCM(playerid, -1, "Inregistrarea a fost un succes!");
  154. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logheaza-te!", "Te rog sa-ti introduci parola mai jos", "Login", "Exit");
  155. }
  156. if(!response)
  157. {
  158. mysql_format(g_Sql, query, sizeof(query), "UPDATE `users` SET `Sex`='0' WHERE `Name`='%e'", GetName(playerid));
  159. mysql_query(g_Sql, query);
  160. SCM(playerid, -1, "Inregistrarea a fost un succes!");
  161. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logheaza-te!", "Te rog sa-ti introduci parola mai jos", "Login", "Exit");
  162. }
  163. return 1;
  164. }
  165. }
  166. return 1;
  167. }
  168.  
  169. forward OnPlayerLogin(playerid);
  170. public OnPlayerLogin(playerid)
  171. {
  172. new rows, fields;
  173. cache_get_row_count(rows);
  174. cache_get_field_count(fields);
  175. if(rows)
  176. {
  177. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logheaza-te!", "Te rog sa-ti introduci parola mai jos", "Login", "Exit");
  178. }
  179. else
  180. {
  181. ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Inregistrare", "Trebuie sa iti creezi un cont pentru a juca pe server. \nTasteaza mai jos o paorla pentru a te inregistra.", "Inregistrare", "Exit");
  182. }
  183. return 1;
  184. }
  185.  
  186. forward OnLogin(playerid);
  187. public OnLogin(playerid)
  188. {
  189. new rows, fields, temporar[200];
  190. cache_get_row_count(rows);
  191. cache_get_field_count(fields);
  192. if(rows)
  193. {
  194. PlayerInfo[playerid][pPassword] = cache_get_value_name(0, "Password", temporar);
  195. PlayerInfo[playerid][pSQLID] = cache_get_value_name(0, "ID", temporar);
  196. cache_get_value_int(0, "Money", PlayerInfo[playerid][pMoney]);
  197. cache_get_value_int(0, "Admin", PlayerInfo[playerid][pAdmin]);
  198. SpawnPlayer(playerid);
  199. }
  200. else
  201. {
  202. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Parola Incorecta", "Te rog sa-ti introduci parola corecta mai jos\nDaca ai uitat parola o poti recupera pe panel.", "Login", "Exit");
  203. }
  204. GivePlayerMoney(playerid, PlayerInfo[playerid][pMoney]);
  205. return 1;
  206. }
  207.  
  208. forward MySQLConnect();
  209. public MySQLConnect()
  210. {
  211. g_Sql = mysql_connect("localhost", "root", "", "server3");
  212. if(mysql_errno() != 0)
  213. {
  214. printf("Connexiunea la baza de date '%s' nu a reusit", mysql_db);
  215. SendRconCommand("exit");
  216. }
  217. else
  218. {
  219. printf("Conexiunea la baza de date '%s' a reusit", mysql_db, mysql_user);
  220. }
  221. return 1;
  222. }
  223.  
  224. stock GetName(playerid)
  225. {
  226. new Name[MAX_PLAYER_NAME];
  227. GetPlayerName(playerid, Name, sizeof(Name));
  228. return Name;
  229. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement