· 8 years ago · Apr 15, 2018, 05:46 PM
1#include <a_samp>
2#include <sscanf2>
3#include <a_mysql>
4
5
6// -------------------------------
7#define HOST "127.0.0.1"
8#define USER "root"
9#define SENHA ""
10#define DATABASE "samp"
11
12new MySQL: MYSQLConnected;
13// -------------------------------
14#define DIALOG_LOGIN 1
15#define DIALOG_REGISTRO 2
16// -------------------------------
17#define TEMPO_LOGIN 30
18
19#define DEFAULTPOSX 1139.4064
20#define DEFAULTPOSY -1761.9249
21#define DEFAULTPOSZ 13.5955
22#define DEFAULTPOSA 4.5833
23// -------------------------------
24enum E_PLAYERS{
25 ID, // MYSQL ID, int
26 Nome[MAX_PLAYER_NAME], // string
27 Senha, // string
28 Money, // int
29 Skin, // int
30 Score, // int
31 Float: PosX, // float
32 Float: PosY, // float
33 Float: PosZ, // float
34 Float: PosA, // float
35 Interior, // int
36 VirtualWorld, // int
37
38 bool: pLogado, // se o player estiver logado
39}
40new Player[MAX_PLAYERS][E_PLAYERS];
41// --------------------------------
42
43main() {}
44
45public OnGameModeInit()
46{
47 MySQLConnect(); // Verifica se o banco de dados está ligado
48 CriarTabela(); // Crias as tabelas
49 return 1;
50}
51
52public OnGameModeExit()
53{
54 FecharServidor(); // Quando o servidor fechar todos os jogadores onlines vão sair como se fosse por contra propria
55 return 1;
56}
57
58public OnPlayerRequestClass(playerid, classid)
59{
60 SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
61 SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
62 SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
63 return 1;
64}
65
66public OnPlayerConnect(playerid)
67{
68 MYSQLConnected = mysql_connect(HOST, USER, SENHA, DATABASE);
69 GetPlayerName(playerid, Player[playerid][Nome], 20);
70
71 new Query[90];
72 mysql_format(MYSQLConnected, Query, sizeof(Query), "SELECT `ID`, `SENHA` FROM `Jogadores` WHERE `Player`='%e' ",Player[playerid][Nome]);
73 mysql_tquery(MYSQLConnected, Query, "VerificarContas", "i", playerid);
74
75 return 1;
76}
77
78public OnPlayerDisconnect(playerid, reason)
79{
80 SalvarDados(playerid);
81 return 1;
82}
83
84public OnPlayerSpawn(playerid)
85{
86 return 1;
87}
88
89public OnPlayerDeath(playerid, killerid, reason)
90{
91 return 1;
92}
93
94public OnVehicleSpawn(vehicleid)
95{
96 return 1;
97}
98
99public OnVehicleDeath(vehicleid, killerid)
100{
101 return 1;
102}
103
104public OnPlayerText(playerid, text[])
105{
106 return 1;
107}
108
109public OnPlayerCommandText(playerid, cmdtext[])
110{
111 if (strcmp("/mycommand", cmdtext, true, 10) == 0)
112 {
113 // Do something here
114 return 1;
115 }
116 return 0;
117}
118
119public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
120{
121 return 1;
122}
123
124public OnPlayerExitVehicle(playerid, vehicleid)
125{
126 return 1;
127}
128
129public OnPlayerStateChange(playerid, newstate, oldstate)
130{
131 return 1;
132}
133
134public OnPlayerEnterCheckpoint(playerid)
135{
136 return 1;
137}
138
139public OnPlayerLeaveCheckpoint(playerid)
140{
141 return 1;
142}
143
144public OnPlayerEnterRaceCheckpoint(playerid)
145{
146 return 1;
147}
148
149public OnPlayerLeaveRaceCheckpoint(playerid)
150{
151 return 1;
152}
153
154public OnRconCommand(cmd[])
155{
156 return 1;
157}
158
159public OnPlayerRequestSpawn(playerid)
160{
161 return 1;
162}
163
164public OnObjectMoved(objectid)
165{
166 return 1;
167}
168
169public OnPlayerObjectMoved(playerid, objectid)
170{
171 return 1;
172}
173
174public OnPlayerPickUpPickup(playerid, pickupid)
175{
176 return 1;
177}
178
179public OnVehicleMod(playerid, vehicleid, componentid)
180{
181 return 1;
182}
183
184public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
185{
186 return 1;
187}
188
189public OnVehicleRespray(playerid, vehicleid, color1, color2)
190{
191 return 1;
192}
193
194public OnPlayerSelectedMenuRow(playerid, row)
195{
196 return 1;
197}
198
199public OnPlayerExitedMenu(playerid)
200{
201 return 1;
202}
203
204public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
205{
206 return 1;
207}
208
209public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
210{
211 return 1;
212}
213
214public OnRconLoginAttempt(ip[], password[], success)
215{
216 return 1;
217}
218
219public OnPlayerUpdate(playerid)
220{
221 return 1;
222}
223
224public OnPlayerStreamIn(playerid, forplayerid)
225{
226 return 1;
227}
228
229public OnPlayerStreamOut(playerid, forplayerid)
230{
231 return 1;
232}
233
234public OnVehicleStreamIn(vehicleid, forplayerid)
235{
236 return 1;
237}
238
239public OnVehicleStreamOut(vehicleid, forplayerid)
240{
241 return 1;
242}
243
244public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
245{
246 new Dialog[240];
247 switch(dialogid)
248 {
249 case DIALOG_REGISTRO:
250 {
251 if(!response) return Kick(playerid);
252 if(strlen(inputtext) < 4 || strlen(inputtext) > 20)
253 {
254 SendClientMessage(playerid, -1, "ERRO:{FFFFFF} A senha deve conter de 4 a 20 caracteres!");
255 format(Dialog, sizeof(Dialog), "{0xFFFFFFAA}%e\n{0x80FF00AA}STATUS: NÃO REGISTRADA", Player[playerid][Nome]);
256 ShowPlayerDialog(playerid, DIALOG_REGISTRO, DIALOG_STYLE_INPUT, "Registro", Dialog, "Confirmar", "Sair");
257
258 }else{
259 new Query[100];
260 mysql_format(MYSQLConnected, Query, sizeof(Query), "INSERT INTO `Jogadores`(`Player`, `Senha`) VALUES ('%e', '%e')", Player[playerid][Nome], inputtext);
261 mysql_tquery(MYSQLConnected, Query, "DadosRegistrados", "i", playerid);
262
263 RegistrarDados(playerid);
264 }
265 }
266
267 case DIALOG_LOGIN:
268 {
269 if(!response) return Kick(playerid);
270 if(!strcmp(Player[playerid][Senha], inputtext, true, 20))
271 {
272 new Query[70];
273 mysql_format(MYSQLConnected, Query, sizeof(Query), "SELECT * FROM `Jogadores` WHERE Nome='%e'", Player[playerid][Nome]);
274 mysql_tquery(MYSQLConnected, Query, "CarregarContas", "d", playerid);
275 }else{
276 SendClientMessage(playerid, -1, "ERRO:{FFFFFF} Senha incorreta !");
277 format(Dialog, sizeof(Dialog), "{0xFFFFFFAA}%e\n{0xFF0000AA}STATUS: Registrado", Player[playerid][Nome]);
278 ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", Dialog, "Confirmar", "Sair");
279 }
280 }
281
282 // == //
283 }
284 return 1;
285}
286
287public OnPlayerClickPlayer(playerid, clickedplayerid, source)
288{
289 return 1;
290}
291
292//=========================
293forward MySQLConnect();
294public MySQLConnect(){
295
296
297 MYSQLConnected = mysql_connect(HOST, USER, SENHA, DATABASE);
298 if (MYSQLConnected == MYSQL_INVALID_HANDLE || mysql_errno(MYSQLConnected) != 0){
299 printf("[MySQL]Conexão com o banco de dados falhou");
300 SendRconCommand("exit");
301 }else{
302 printf("[MySQL]Conectado ao banco de dados com sucesso");
303 }
304 return 1;
305}
306
307// --------------------------
308forward FecharServidor();
309public FecharServidor(){
310
311 for (new i = 0, j = GetPlayerPoolSize(); i <= j; i++){
312 if (IsPlayerConnected(i)){
313 OnPlayerDisconnect(i, 1);
314 }
315 }
316 mysql_close(MYSQLConnected);
317 return 1;
318}
319// -------------------------
320forward CriarTabela();
321public CriarTabela(){
322 MYSQLConnected = mysql_connect(HOST, USER, SENHA, DATABASE);
323 mysql_query(MYSQLConnected ,"CREATE TABLE IF NOT EXISTS Jogadores(ID INT AUTO_INCREMENT PRIMARY KEY,Player VARCHAR(24),Senha VARCHAR(24), Dinheiro INT(20), Skin INT(20), Score INT(20), PosX FLOAT(20), PosY FLOAT(20), PosZ FLOAT(20), PosA FLOAT(20), Interior INT(10), VirtualWorld INT(10))");
324 return 1;
325}
326// -------------------------
327forward VerificarContas(playerid);
328public VerificarContas(playerid){
329 new Dialog[240];
330
331 if(cache_num_rows() > 0){
332 cache_get_value(0, "Senha", Player[playerid][Senha]);
333 format(Dialog, sizeof(Dialog), "{0xFFFFFFAA}%e\n{0xFF0000AA}STATUS: Registrado", Player[playerid][Nome]);
334 ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", Dialog, "Confirmar", "Sair");
335 }else{
336 format(Dialog, sizeof(Dialog), "{0xFFFFFFAA}%e\n{0x80FF00AA}STATUS: NÃO REGISTRADA", Player[playerid][Nome]);
337 ShowPlayerDialog(playerid, DIALOG_REGISTRO, DIALOG_STYLE_INPUT, "Registro", Dialog, "Confirmar", "Sair");
338 }
339 return 1;
340}
341// --------------------------
342forward DadosRegistrados(playerid);
343public DadosRegistrados(playerid){
344 Player[playerid][ID] = cache_insert_id();
345 printf("CONTA ID %d REGISTRADA", Player[playerid][ID]);
346 return 1;
347}
348// --------------------------
349forward CarregarContas(playerid);
350public CarregarContas(playerid){
351 cache_get_value_int(0, "ID", Player[playerid][ID]);
352 cache_get_value_int(0, "Skin", Player[playerid][Skin]);
353 cache_get_value_int(0, "Score", Player[playerid][Score]);
354 cache_get_value_int(0, "Dinheiro", Player[playerid][Money]);
355 cache_get_value_int(0, "Interior", Player[playerid][Interior]);
356 cache_get_value_int(0, "VirtualWorld", Player[playerid][VirtualWorld]);
357
358 cache_get_value_float(0, "PosX", Player[playerid][PosX]);
359 cache_get_value_float(0, "PosY", Player[playerid][PosY]);
360 cache_get_value_float(0, "PosZ", Player[playerid][PosZ]);
361 cache_get_value_float(0, "PosA", Player[playerid][PosA]);
362
363 CarregarDados(playerid);
364 return 1;
365}
366// ----------------------------
367stock RegistrarDados(playerid){
368 Player[playerid][Skin] = 23;
369 Player[playerid][Score] = 0;
370 Player[playerid][Money] = 1500;
371 Player[playerid][Interior] = 0;
372 Player[playerid][VirtualWorld] = 0;
373
374 Player[playerid][PosX] = DEFAULTPOSX;
375 Player[playerid][PosY] = DEFAULTPOSY;
376 Player[playerid][PosZ] = DEFAULTPOSZ;
377 Player[playerid][PosA] = DEFAULTPOSA;
378 CarregarDados(playerid);
379 return 1;
380}
381// -----------------------------
382stock CarregarDados(playerid){
383 Player[playerid][pLogado] = true;
384 SetPlayerScore(playerid, Player[playerid][Score]);
385 GivePlayerMoney(playerid, Player[playerid][Money]);
386 SetPlayerInterior(playerid, Player[playerid][Interior]);
387 SetPlayerVirtualWorld(playerid, Player[playerid][VirtualWorld]);
388
389 SetSpawnInfo(playerid, 0, Player[playerid][Skin], Player[playerid][PosX], Player[playerid][PosY], Player[playerid][PosZ], Player[playerid][PosA], 0, 0, 0, 0, 0, 0);
390 return 1;
391}
392// ------------------------------
393stock SalvarDados(playerid){
394 Player[playerid][Score] = GetPlayerScore(playerid);
395 Player[playerid][Skin] = GetPlayerSkin(playerid);
396 Player[playerid][Money] = GetPlayerMoney(playerid);
397 Player[playerid][Interior] = GetPlayerInterior(playerid);
398 Player[playerid][VirtualWorld] = GetPlayerVirtualWorld(playerid);
399
400 GetPlayerPos(playerid ,Player[playerid][PosX], Player[playerid][PosY], Player[playerid][PosZ]);
401 GetPlayerFacingAngle(playerid, Player[playerid][PosA]);
402 GetPlayerName(playerid, Player[playerid][Nome], 20);
403
404 new Query[350];
405 mysql_format(MYSQLConnected, Query, sizeof(Query), "UPDATE `Jogadores` SET `Player`='%e', `Dinheiro`=%d, `Skin`=%d, `Score`=%d, `PosY`='%f',`PosZ`='%f',`PosX`='%f',`PosA`='%f', `Interior`=%d, `VirtualWorld`=%d WHERE `ID`=%d",
406 Player[playerid][Nome],
407 Player[playerid][Money],
408 Player[playerid][Skin],
409 Player[playerid][Score],
410 Player[playerid][PosX],
411 Player[playerid][PosY],
412 Player[playerid][PosZ],
413 Player[playerid][PosA],
414 Player[playerid][Interior],
415 Player[playerid][VirtualWorld],
416 Player[playerid][ID]);
417
418 mysql_tquery(MYSQLConnected, Query, "DadosSalvos", "d", playerid);
419
420 Player[playerid][Money] = 0;
421 Player[playerid][Score] = 0;
422 Player[playerid][Skin] = 0;
423 Player[playerid][PosX] = 0;
424 Player[playerid][PosY] = 0;
425 Player[playerid][PosZ] = 0;
426 Player[playerid][PosA] = 0;
427 Player[playerid][Interior] = 0;
428 Player[playerid][VirtualWorld] = 0;
429 Player[playerid][pLogado] = false;
430 DadosSalvos(playerid);
431 return 1;
432
433}
434// --------------------------------------------------
435forward DadosSalvos(playerid);
436public DadosSalvos(playerid) return printf("-> Conta salva ID: %d", Player[playerid][ID]);