1. #include <a_samp>
2. #include <a_mysql>
3. #include <zcmd>
4. #include <md5>
5.  
6. //Modules
7. #include "libraries/mysql_functions.inc"
8. #include "libraries/config.inc"
9. #include "libraries/functions.inc"
10.  
11. main(){}
12.  
13. public OnGameModeInit()
14. {
15.         if(!MySQL_Init()) return printf("[MySQL] Error while trying to connect with database. [ID: %d].", mysql_errno(m_sql));
16.         else print("[MySQL] Successfully connected to the database.");
17.  
18.         return 1;
19. }
20.  
21. public OnPlayerRequestClass(playerid, classid)
22. {
23.     new Cache:result;
24.     result = mysql_query(m_sql, sprintf("SELECT COUNT(*) as total_rows FROM `players` WHERE `player_name` = '%s'", PlayerName(playerid)));
25.    
26.     SpawnPlayer(playerid);
27.     TogglePlayerSpectating(playerid, 1);
28.  
29.     if(cache_num_rows() > 1) ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Logowanie", "Wpisz ponizej haslo ktorego chcesz uzywac, aby ZALOGOWAC sie na serwerze!", "Logowanie", "Anuluj");
30.     else ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Rejestracja", "Wpisz ponizej haslo ktorego chcesz uzywac, aby ZAREJESTROWAC sie na serwerze!", "Rejestruj", "Anuluj");
31.    
32.     cache_delete(result);
33.  
34.     return 1;
35. }
36.  
37. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
38. {
39.     if(dialogid == DIALOG_LOGIN)
40.     {
41.         if(!response) return Kick(playerid);
42.  
43.         new Cache:result, password[32];
44.  
45.         result = mysql_query(m_sql, sprintf("SELECT `player_password` FROM `players` WHERE `player_name` = '%s'", PlayerName(playerid)));
46.         cache_get(0, "player_password", password);
47.         cache_delete(result);
48.  
49.         if(!strcmp(MD5_Hash(inputtext), password)) {
50.             OnPlayerLogin(playerid);
51.         } else {
52.             ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "Logowanie", "Podales bledne haslo\n\nWpisz ponizej haslo ktorego chcesz uzywac, aby ZALOGOWAC sie na serwerze!", "Logowanie", "Anuluj");
53.         }
54.     }
55.     else if(dialogid == DIALOG_REGISTER)
56.     {
57.         if(!response) return Kick(playerid);
58.  
59.         if(strlen(inputtext) == 0) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Rejestracja", "Wpisz ponizej haslo ktorego chcesz uzywac, aby ZAREJESTROWAC sie na serwerze!", "Rejestruj", "Anuluj");
60.  
61.         mysql_query(m_sql, sprintf("INSERT INTO `players` VALUES (NULL, '%s', '%s', '%d')", PlayerName(playerid), MD5_Hash(inputtext), random(250)));
62.  
63.         OnPlayerLogin(playerid);
64.     }
65.     return 1;
66. }