API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 5th, 2020
28
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.15 KB | None | 0 0
raw download clone embed print report
  1. //===================Include=============================
  2. #include <a_samp>
  3. #include <a_mysql>
  4. //====================Simple News========================
  5. new MySQL:g_Sql; // sa nu cumva sa il stergeti face conecsiunea dintre server si baza de date
  6. //===================Defined=============================
  7. #if defined FILTERSCRIPT
  8. #define SCM SendClientMessage
  9. //===============Database Connect========================
  10. #define mysql_host "127.0.0.1" // ip baza de date
  11. #define mysql_db "server" // nume baza de date
  12. #define mysql_user "root" // user baza de date
  13. #define mysql_pass "" // parola baza de date
  14. //================Player detalies========================
  15. enum
  16. {
  17. DIALOG_REGISTER,
  18. DIALOG_LOGIN,
  19. DIALOG_AGE,
  20. DIALOG_SEX,
  21. DIALOG_EMAIL
  22. };
  23. enum pInfo
  24. {
  25. pID,
  26. pPassword,
  27. pAdmin
  28. pMoney,
  29. pHelper
  30. };
  31. //====================Simple News 2======================
  32. new PlayerInfo[MAX_PLAYERS][pInfo];
  33. //=======================================================
  34. public OnFilterScriptInit()
  35. {
  36. print("\n--------------------------------------");
  37. print(" Blank Filterscript by your name here");
  38. print("--------------------------------------\n");
  39. return 1;
  40. }
  41.  
  42. public OnFilterScriptExit()
  43. {
  44. return 1;
  45. }
  46.  
  47. #else
  48.  
  49. main()
  50. {
  51. print("\n----------------------------------");
  52. print(" Blank Gamemode by your name here");
  53. print("----------------------------------\n");
  54. }
  55.  
  56. #endif
  57.  
  58. public OnGameModeInit()
  59. {
  60. MySQLConnect();
  61. // Don't use these lines if it's a filterscript
  62. SetGameModeText("Revolution V[1.0]");
  63. AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
  64. return 1;
  65. }
  66.  
  67. public OnGameModeExit()
  68. {
  69. mysql_close( g_SqL );
  70. return 1;
  71. }
  72.  
  73. public OnPlayerRequestClass(playerid, classid)
  74. {
  75. SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
  76. SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
  77. SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
  78. return 1;
  79. }
  80.  
  81. public OnPlayerConnect(playerid)
  82. {
  83. new query[100];
  84. mysql_fomat(g_Sql, query, sizeof(query), "SELECT * FROM 'users' WHERE Name = '%s LIMIT 1' ", GetName(playerid));
  85. mysql_tquery(g_Sql, query, "OnPlayerLogin", "i", playerid);
  86. return 1;
  87. }
  88.  
  89. public OnPlayerDisconnect(playerid, reason)
  90. {
  91. return 1;
  92. }
  93.  
  94. public OnPlayerSpawn(playerid)
  95. {
  96. return 1;
  97. }
  98.  
  99. public OnPlayerDeath(playerid, killerid, reason)
  100. {
  101. return 1;
  102. }
  103.  
  104. public OnVehicleSpawn(vehicleid)
  105. {
  106. return 1;
  107. }
  108.  
  109. public OnVehicleDeath(vehicleid, killerid)
  110. {
  111. return 1;
  112. }
  113.  
  114. public OnPlayerText(playerid, text[])
  115. {
  116. return 1;
  117. }
  118.  
  119. public OnPlayerCommandText(playerid, cmdtext[])
  120. {
  121. if (strcmp("/mycommand", cmdtext, true, 10) == 0)
  122. {
  123. // Do something here
  124. return 1;
  125. }
  126. return 0;
  127. }
  128.  
  129. public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
  130. {
  131. return 1;
  132. }
  133.  
  134. public OnPlayerExitVehicle(playerid, vehicleid)
  135. {
  136. return 1;
  137. }
  138.  
  139. public OnPlayerStateChange(playerid, newstate, oldstate)
  140. {
  141. return 1;
  142. }
  143.  
  144. public OnPlayerEnterCheckpoint(playerid)
  145. {
  146. return 1;
  147. }
  148.  
  149. public OnPlayerLeaveCheckpoint(playerid)
  150. {
  151. return 1;
  152. }
  153.  
  154. public OnPlayerEnterRaceCheckpoint(playerid)
  155. {
  156. return 1;
  157. }
  158.  
  159. public OnPlayerLeaveRaceCheckpoint(playerid)
  160. {
  161. return 1;
  162. }
  163.  
  164. public OnRconCommand(cmd[])
  165. {
  166. return 1;
  167. }
  168.  
  169. public OnPlayerRequestSpawn(playerid)
  170. {
  171. return 1;
  172. }
  173.  
  174. public OnObjectMoved(objectid)
  175. {
  176. return 1;
  177. }
  178.  
  179. public OnPlayerObjectMoved(playerid, objectid)
  180. {
  181. return 1;
  182. }
  183.  
  184. public OnPlayerPickUpPickup(playerid, pickupid)
  185. {
  186. return 1;
  187. }
  188.  
  189. public OnVehicleMod(playerid, vehicleid, componentid)
  190. {
  191. return 1;
  192. }
  193.  
  194. public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
  195. {
  196. return 1;
  197. }
  198.  
  199. public OnVehicleRespray(playerid, vehicleid, color1, color2)
  200. {
  201. return 1;
  202. }
  203.  
  204. public OnPlayerSelectedMenuRow(playerid, row)
  205. {
  206. return 1;
  207. }
  208.  
  209. public OnPlayerExitedMenu(playerid)
  210. {
  211. return 1;
  212. }
  213.  
  214. public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
  215. {
  216. return 1;
  217. }
  218.  
  219. public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
  220. {
  221. return 1;
  222. }
  223.  
  224. public OnRconLoginAttempt(ip[], password[], success)
  225. {
  226. return 1;
  227. }
  228.  
  229. public OnPlayerUpdate(playerid)
  230. {
  231. return 1;
  232. }
  233.  
  234. public OnPlayerStreamIn(playerid, forplayerid)
  235. {
  236. return 1;
  237. }
  238.  
  239. public OnPlayerStreamOut(playerid, forplayerid)
  240. {
  241. return 1;
  242. }
  243.  
  244. public OnVehicleStreamIn(vehicleid, forplayerid)
  245. {
  246. return 1;
  247. }
  248.  
  249. public OnVehicleStreamOut(vehicleid, forplayerid)
  250. {
  251. return 1;
  252. }
  253.  
  254. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  255. {
  256. //=================================================Baza de date================================================
  257. new query[128], ip[25];
  258. switch(dialogid)
  259. {
  260. case DIALOG_REGISTER:
  261. {
  262. if(!response) return Kick(playerid);
  263. if(response)
  264. {
  265. if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FF0000}Parola Incorecta!", "{FFFFFF}Introdu-ti o parola pentru a te inregistra pe serverul nostru!", "{00FF00}Inregistrare", "Exit");
  266. GetPlayerIp(playerid, ip, sizeof(ip));
  267. SCM(playerid, COLOR_LIGHTBLUE, "{FF0000}Te rog sa-ti introduci varsta.\n(Dorim sa vedem media de varsta a jucatorilor nostrii.");
  268. mysql_format(g_Sql, query, sizeof(query), " INSERT INTO users (Name, Password, IP, Admin, Helper, Money) VALUES ('%s', '%e', '%s', '0', '0', '10000')", GetName(playerid), inputtext, ip);
  269. mysql_query(g_Sql, query);
  270. ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "{FF0000}Varsta", "{FFFFFF}Te rog sa-ti introduci mai jos varsta.", "{00FF00}Continua", "{FF0000}Exit");
  271. }
  272. return 1;
  273. }
  274. case DIALOG_LOGIN:
  275. {
  276. if(!response) return Kick(playerid);
  277. if(response)
  278. {
  279. if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FF0000}Parola Incorecta!", "{FFFFFF}Te rog sa-ti introduci parola corecta mai jos.\n{FFFFFF}Daca ai uitat parola o poti recupera pe panel.", "{00FF00}Logare", "{FF0000}Exit");
  280. mysql_format(g_Sql, query, sizeof(query), "Select * FROM 'users' WHERE 'Name'='%e' AND 'Password'='%s'", GetName(playerid, inputtext);
  281. mysql_tquery(g_Sql, query, "OnLogin", "i", playerid);
  282. }
  283. return 1;
  284. }
  285. case DIALOG_AGE
  286. {
  287. if (!response) return ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, " {FF0000}Varsta", "{FFFFFF}Te rog sa-ti introduci mai jos varsta.", "{00FF00}Continua", "{FF0000}Exit"
  288. if(response)
  289. {
  290. if(!strlen(inputtext)) return ShowPlayerDialog(playerid, DIALOG_AGE, DIALOG_STYLE_INPUT, "{FF0000}Varsta", "{FFFFFF}Te rog sa-ti introduci mai jos varsta.", "{00FF00}Continua", "{FF0000}Exit");
  291. SCM(playerid, COLOR_LIGHTBLUE, "{FFFFFF}Te rog sa-ti introduci email-ul, pentru consta si pentru a-ti putea recupera contul.");
  292. mysql_format(g_Sql, query, sizeof(query), "UPDATE 'users' SET 'Age'='%e' WHERE 'Name'='%e'", inputtext, GetName(playerid));
  293. mysql_query(g_Sql, query);
  294. ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "{FF0000}Ëmail", "{FFFFFF}Te rog sa-ti introduci email-ul mai jos.\n{CC0000}Este necesar pentru ati recupera contul pe panel in caz ca ti-ai uitat parola!!.", "{00FF00}Continua", "{FF0000}Exit");
  295. }
  296. return 1;
  297. }
  298. case DIALOG_EMAIL:
  299. {
  300. if(!response) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIaLOG_STYLE_INPUT, "{FF0000}Ëmail", "{FFFFFF}Te rog sa-ti introduci email-ul mai jos.\n{CC0000}Este necesar pentru ati recupera contul pe panel in caz ca ti-ai uitat parola!!.", "{00FF00}Continua", "{FF0000}Exit");
  301. if(response)
  302. {
  303. if(!strlen(inputtext)) return ShowPlayerDialog(layerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "{FF0000}Ëmail", "{FFFFFF}Te rog sa-ti introduci email-ul mai jos.\n{CC0000}Este necesar pentru ati recupera contul pe panel in caz ca ti-ai uitat parola!!.", "{00FF00}Continua", "{FF0000}Exit");
  304. SCM(playerID, COLOR_LIGHTBLUE, "Te rog sa-ti alegi sexul.");
  305. mysql_fomat(g_Sql, query, sizeof(query), "UPDATE 'users' SET 'Email'='%e' WHERE 'Name'='%e'", inputtext, GetName(playerid));
  306. mysql_query(g_Sql_ query);
  307. ShowPlayerDialog(playerid, DIALOG_SEX, DIALOG_STYLE_MSGBOX, "{FF0000}Sexul dumneavoastra", "{FFFFFF}Te rog sa-ti alegi sexul selectand din cele de mai jos", "{00FFFF}Masculin", "{FF00FF}Feminin");
  308. }
  309. return 1;
  310. }
  311. case DIALOG_SEX:
  312. {
  313. if(response)
  314. {
  315. mysql_format(g_Sql, query, sizeof(query), "UPDATE 'users' SET 'Sex'='1' WHERE 'Name'='%e', GetName(playerid));
  316. mysql_quuery(g_Sql, query);
  317. SCM(playerid, COLOR_LIGHTBLUE, "{FF0000}Felicitari %s, {FFFFFF}te-ai inregistrat cu succes!");
  318. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FF0000}Logare", "{FFFFFF}Esti nevoit sa iti introduci parola pentru a intra pe contul tau sa te joci!\n{FFFFFF}Prin aceasta masura ne asiguram ca nu iti fura nimeni averea sau chiar contul.", "{00FF00}Logare", "{FF0000}Exit");
  319. }
  320. if(!response)
  321. {
  322. mysql_format(g_Sql, query, sizeof(query), "UPDATE 'users' SET 'Sex'='0' WHERE 'Name'='%e', GetName(playerid));
  323. mysql_quuery(g_Sql, query);
  324. SCM(playerid, COLOR_LIGHTBLUE, "{FF0000}Felicitari %s, {FFFFFF}te-ai inregistrat cu succes!");
  325. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FF0000}Logare", "{FFFFFF}Esti nevoit sa iti introduci parola pentru a intra pe contul tau sa te joci!\n{FFFFFF}Prin aceasta masura ne asiguram ca nu iti fura nimeni averea sau chiar contul.", "{00FF00}Logare", "{FF0000}Exit");
  326. }
  327. return 1;
  328. }
  329. //========================================================================================================
  330.  
  331. return 1;
  332. }
  333.  
  334. public OnPlayerClickPlayer(playerid, clickedplayerid, source)
  335. {
  336. return 1;
  337. }
  338. //=======================================================
  339. forward MySQLConnect();
  340. public MySQLConnect()
  341. {
  342. g_Sql = mysql_connect(mysql_host, mysql_user, mysql_pass, mysql_db);
  343. if(mysql_errno() != 0)
  344. {
  345. printf("Conecsiunea la baza de date '%s' nu a reusit. --> Server ShutDown!", mysql_db);
  346. SendRconCommand("exit")
  347. }
  348. else
  349. {
  350. printf("Conecsiunea la baza de date '%s' a reusit", mysql_db, mysql_user);
  351. }
  352. return 1;
  353. }
  354. //=======================================================
  355. stock GetName(playerid)
  356. {
  357. new Name[MAX_PLAYER_NAME];
  358. GetPlayerName(playerid, Name, Sizeof(Name));
  359. return Name;
  360. }
  361. //=======================================================
  362. forward OnPlayerLogin(playerid);
  363. public OnPlayerLogin(playerid)
  364. {
  365. new rows, fields;
  366. cache_get_row_count(rows);
  367. cache_get_field_count(fields);
  368. if(rows)
  369. {
  370. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FF0000}Logare", "{CC0000}Bine ai revenit!\n{FFFFFF}Esti nevoit sa-ti introduci parola mai jos.\n{FFFFFF}Doresc sa verific daca esti tu detinatorule pentru a nu exista neplaceri...", "{00FF00}Logare", "{FF0000}Exit");
  371. }
  372. else
  373. {
  374. ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{FF0000}Inregistrare", "{CC0000}Bun venit!!\n{FFFFFF}Esti nevoit sa iti creezi un cont pentru a juca.\n{FFFFFF}Seteaza-ti ce parola doresti tu mai jos.\n{FF0000}ATENTIE!! {FFFFFF}Nu da parola nimanui!!!", "{00FF00}Inregistrare", "{FF0000}Exit);
  375. }
  376. return 1;
  377. }
  378. //=======================================================
  379. forward OnLogin(playerid);
  380. public OnLogin(playerid)
  381. {
  382. new rows, fields, temporar[200];
  383. cache_get_row_count(rows);
  384. cache_get_field_count(fields);
  385. if(rows)
  386. {
  387. PlayerInfo[playerid][pPassword] = chache_get_value_name(0, "Password", temporar);
  388. PlayerInfo[playerid][pID] = cache_get_value_name(0, "ID", temporar);
  389. cache_get_value_int(0, "Money", PlayerInfo[playerid][pMoney]);
  390. SpawnPlayer(playerid);
  391. }
  392. else
  393. {
  394. ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FF0000}Parola Incorecta!", "{FFFFFF}Te rog sa-ti introduci parola corecta mai jos.\n{FFFFFF}Daca ai uitat parola o poti recupera pe panel.", "{00FF00}Logare", "{FF0000}Exit");
  395. }
  396. SetPlayerCash(playerid, PlayerInfo[playerid][pMoney];
  397. return 1;
  398. }
  399. //==============================================================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!