· 8 years ago · Mar 14, 2018, 09:00 PM
1#include <a_samp>
2#include <a_mysql>
3#include <Pawn.CMD>
4#include <sscanf2>
5
6#undef MAX_PLAYERS
7#define MAX_PLAYERS 50
8
9#define MYSQL_HOST "127.0.0.1"
10#define MYSQL_USER "root"
11#define MYSQL_PASSWORD ""
12#define MYSQL_DATABASE "server"
13
14#define SCM SendClientMessage
15#define SPD ShowPlayerDialog
16#define DSP DIALOG_STYLE_PASSWORD
17#define DSI DIALOG_STYLE_INPUT
18#define DSM DIALOG_STYLE_MSGBOX
19
20#define func%0(%1) forward%0(%1); public%0(%1)
21
22new MySQL: g_SQL;
23
24enum E_PLAYERS
25{
26 ID,
27 Name[MAX_PLAYER_NAME],
28 Password[65],
29 Salt[17],
30 Kills,
31 Deaths,
32
33 Cache: Cache_ID,
34};
35new PI[MAX_PLAYERS][E_PLAYERS];
36
37new g_MysqlRaceCheck[MAX_PLAYERS];
38
39enum
40{
41
42 DIALOG_LOGIN,
43 DIALOG_REGISTER
44};
45
46static Test;
47
48main() {}
49
50
51public OnGameModeInit()
52{
53 new MySQLOpt: option_id = mysql_init_options();
54
55 mysql_set_option(option_id, AUTO_RECONNECT, true);
56
57 g_SQL = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, option_id); // AUTO_RECONNECT is enabled for this connection handle only
58 if (g_SQL == MYSQL_INVALID_HANDLE || mysql_errno(g_SQL) != 0)
59 {
60 print("MySQL konekcija neuspesna. Proverite podatke i databazu");
61 SendRconCommand("exit");
62 return 1;
63 }
64
65 print("MySQL konekcija, uspesna");
66
67 SetupPlayerTable();
68 return 1;
69}
70
71public OnGameModeExit()
72{
73 mysql_close(g_SQL);
74 return 1;
75}
76
77public OnPlayerConnect(playerid)
78{
79 g_MysqlRaceCheck[playerid]++;
80
81 static const empty_player[E_PLAYERS];
82 PI[playerid] = empty_player;
83
84 GetPlayerName(playerid, PI[playerid][Name], MAX_PLAYER_NAME);
85
86 new query[103];
87 mysql_format(g_SQL, query, sizeof query, "SELECT * FROM `players` WHERE `username` = '%e' LIMIT 1", PI[playerid][Name]);
88 mysql_tquery(g_SQL, query, "OnPlayerDataLoaded", "dd", playerid, g_MysqlRaceCheck[playerid]);
89 return 1;
90}
91
92public OnPlayerDisconnect(playerid, reason)
93{
94 g_MysqlRaceCheck[playerid]++;
95
96 if (cache_is_valid(PI[playerid][Cache_ID]))
97 {
98 cache_delete(PI[playerid][Cache_ID]);
99 PI[playerid][Cache_ID] = MYSQL_INVALID_CACHE;
100 }
101 return 1;
102}
103
104public OnPlayerDeath(playerid, killerid, reason)
105{
106 new query[125];
107 mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `kills` = %d, `deaths` = %d WHERE `id` = %d", PI[playerid][Kills], PI[playerid][Deaths], PI[playerid][ID]);
108 mysql_tquery(g_SQL, query);
109
110 mysql_format(g_SQL, query, sizeof query, "UPDATE `players` SET `kills` = %d, `deaths` = %d WHERE `id` = %d", PI[killerid][Kills], PI[killerid][Deaths], PI[killerid][ID]);
111 mysql_tquery(g_SQL, query);
112 return 1;
113}
114
115public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
116{
117 switch (dialogid)
118 {
119 case DIALOG_LOGIN:
120 {
121 if (!response) return Kick(playerid);
122
123 new hashed_pass[65];
124 SHA256_PassHash(inputtext, PI[playerid][Salt], hashed_pass, 65);
125
126 if (strcmp(hashed_pass, PI[playerid][Password]) == 0)
127 {
128 SCM(playerid, -1, "Uspesno ste se ulogovali");
129
130 cache_set_active(PI[playerid][Cache_ID]);
131
132 AssignPlayerData(playerid);
133
134 cache_delete(PI[playerid][Cache_ID]);
135 PI[playerid][Cache_ID] = MYSQL_INVALID_CACHE;
136
137 SpawnPlayer(playerid);
138 }
139 else
140 {
141 SPD(playerid, DIALOG_LOGIN, DSP, "Login", "Pogresna lozinka!\nUnesite vasu lozinku ispod", "Login", "Izlaz");
142 }
143 }
144 case DIALOG_REGISTER:
145 {
146 if (!response) return Kick(playerid);
147
148 if (strlen(inputtext) <= 5) return SPD(playerid, DIALOG_REGISTER, DSP, "Registracija", "Vasa lozinka ne sme biti ispod 5 karaktera", "Registruj se", "Izlaz");
149
150 for (new i = 0; i < 16; i++) PI[playerid][Salt][i] = random(94) + 33;
151 SHA256_PassHash(inputtext, PI[playerid][Salt], PI[playerid][Password], 65);
152
153 new query[221];
154 mysql_format(g_SQL, query, sizeof query, "INSERT INTO `players` (`username`, `password`, `salt`) VALUES ('%e', '%s', '%e')", PI[playerid][Name], PI[playerid][Password], PI[playerid][Salt]);
155 mysql_tquery(g_SQL, query, "OnPlayerRegister", "d", playerid);
156 }
157 }
158 return 1;
159}
160
161//-----------------------------------------------------
162
163func OnPlayerDataLoaded(playerid, race_check)
164{
165 if (race_check != g_MysqlRaceCheck[playerid]) return Kick(playerid);
166
167 if(cache_num_rows() > 0)
168 {
169 cache_get_value(0, "password", PI[playerid][Password], 65);
170 cache_get_value(0, "salt", PI[playerid][Salt], 17);
171
172 PI[playerid][Cache_ID] = cache_save();
173
174 SPD(playerid, DIALOG_LOGIN, DSP, "Login", "Vas nalog postoji", "Login", "Izlaz");
175
176 }
177 else
178 {
179 SPD(playerid, DIALOG_REGISTER, DSP, "Registracija", "Vas nalog ne postoji\nUnesite lozinku", "Registracija", "Izlaz");
180 }
181 return 1;
182}
183
184func OnPlayerRegister(playerid)
185{
186 PI[playerid][ID] = cache_insert_id();
187
188 SpawnPlayer(playerid);
189 return 1;
190}
191
192//-----------------------------------------------------
193
194AssignPlayerData(playerid)
195{
196 cache_get_value_int(0, "id", PI[playerid][ID]);
197
198 cache_get_value_int(0, "kills", PI[playerid][Kills]);
199 cache_get_value_int(0, "deaths", PI[playerid][Deaths]);
200
201 return 1;
202}
203
204SetupPlayerTable()
205{
206 mysql_tquery(g_SQL, "CREATE TABLE IF NOT EXISTS `players` (`id` int(11) NOT NULL AUTO_INCREMENT,`username` varchar(24) NOT NULL,`password` char(64) NOT NULL,`salt` char(16) NOT NULL,`kills` mediumint(8) NOT NULL DEFAULT '0',`deaths` mediumint(8) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`))");
207 return 1;
208}