API tools faq
paste
Guest User

Untitled

a guest
Dec 20th, 2014
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.21 KB | None | 0 0
raw download clone embed print report
  1. #include <a_samp>
  2. #include <a_mysql> // SQL Include
  3.  
  4. /* - PF: Public Forward -
  5. Places the global public and forward all in one.
  6. Inestead of using more lines of code then needed.
  7. */
  8. #define PF:%0(%1) forward %0(%1); \
  9. public %0(%1)
  10.  
  11. /* DIALOGS */
  12. #define D_REG 1000
  13. #define DIALOG_REGISTER 1100
  14. #define DIALOG_LOGIN 1200
  15.  
  16. /* COLOR DEFINES */
  17. #define C_YELLOW 0xFFFF00FF
  18. #define C_WHITE 0xFFFFFFAA
  19.  
  20. // LOCAL DATABASE
  21. #define mysql_host "localhost" //
  22. #define mysql_user "root" //
  23. #define mysql_password "" //
  24. #define mysql_database "playerdata"
  25.  
  26. new Text:ServerText2;
  27.  
  28.  
  29. new MoneyGiven[MAX_PLAYERS];
  30. new bool: Logged[MAX_PLAYERS] = false;
  31. new IsRegistered[MAX_PLAYERS];
  32.  
  33.  
  34. /* ENUM'S */
  35. /* PLAYER STATISTICS */
  36. enum PlayerStats
  37. {
  38. N_Admin,
  39. N_Kills,
  40. N_Deaths,
  41. N_Rank,
  42. N_Vehicle,
  43. N_Rounds,
  44. N_Gun,
  45. Text3D:Nametag
  46. }
  47. new P_Info[MAX_PLAYERS][PlayerStats];
  48.  
  49.  
  50. main()
  51. {
  52. print("\n----------------------------------");
  53. print(" Intense Roleplay - by Lynn");
  54. print("----------------------------------\n");
  55. }
  56.  
  57. public OnGameModeInit()
  58. {
  59. SetGameModeText("I:RP");
  60. AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
  61.  
  62. mysql_debug(1); // If there is a issue with SQL, this will report it.
  63. mysql_connect(mysql_host, mysql_user, mysql_database, mysql_password); // Connects to our Database
  64. mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(41), score INT(20), money INT(20), IP VARCHAR(16) )");
  65.  
  66. ServerText2 = TextDrawCreate(167.000000, 16.000000, "Intense Roleplay");
  67. TextDrawBackgroundColor(ServerText2, -1);
  68. TextDrawFont(ServerText2, 0);
  69. TextDrawLetterSize(ServerText2, 1.000000, 5.000000);
  70. TextDrawColor(ServerText2, 255);
  71. TextDrawSetOutline(ServerText2, 1);
  72. TextDrawSetProportional(ServerText2, 1);
  73.  
  74. return 1;
  75. }
  76.  
  77. PF:OnGameModeExit()
  78. {
  79. TextDrawHideForAll(ServerText2);
  80. TextDrawDestroy(ServerText2);
  81. return 1;
  82. }
  83.  
  84. public OnPlayerRequestClass(playerid, classid)
  85. {
  86. SetPlayerHealth(playerid, 100);
  87. SetPlayerSkin(playerid, 299);
  88. SetPlayerPos(playerid, 1111.4846,-2037.5078,74.4297);
  89. SetPlayerFacingAngle(playerid, 0.00);
  90. SetPlayerInterior(playerid, 0);
  91. SetPlayerVirtualWorld(playerid, 0);
  92. InterpolateCameraLookAt(playerid, 1123.4022,-2037.4523,69.8870,2162.6526,-1566.7651,102.1234, 50000);
  93. InterpolateCameraPos(playerid, 1126.9851,-2037.2881,69.8835,2162.6526,-1566.7651,102.1234, 50000, CAMERA_MOVE);
  94. return 1;
  95. }
  96.  
  97. public OnPlayerConnect(playerid)
  98. {
  99. P_Info[playerid][N_Admin] = 0;
  100. P_Info[playerid][N_Kills] = 0;
  101. P_Info[playerid][N_Deaths] = 0;
  102. P_Info[playerid][N_Rank] = 0;
  103. P_Info[playerid][N_Vehicle] = 0;
  104. P_Info[playerid][N_Rounds] = 0;
  105. P_Info[playerid][N_Gun] = 0;
  106.  
  107. MoneyGiven[playerid] = -1;
  108. new query[200], pname[24];
  109. GetPlayerName(playerid, pname, 24);
  110. format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
  111. mysql_query(query);
  112. mysql_store_result();
  113. if(!mysql_num_rows()) // or if(mysql_num_rows() == 0)
  114. {
  115. ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "Register","This account is unregistered.\nInput desired password below.","Register","Cancel"); //Shows our register dialog :).
  116. }
  117. else
  118. {
  119.  
  120. new IP[2][16];
  121. mysql_fetch_field_row(IP[0],"IP");
  122. GetPlayerIp(playerid, IP[1], 16);
  123. if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
  124. {
  125. MySQL_Login(playerid);
  126. }
  127. else
  128. {
  129. ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_INPUT, "Login","This account is registered.\nPlease Login input your login credentials.","Login","Cancel"); //Shows our login dialog :).
  130. IsRegistered[playerid] = 1;
  131. }
  132. }
  133. mysql_free_result();
  134.  
  135. SetPlayerColor(playerid, C_WHITE);
  136. SendClientMessage(playerid, C_YELLOW, " *** NOTICE: Player accounts are frequently delete during Beta-Stage.");
  137. SetPlayerSkillLevel(playerid, 6, 100);
  138. TextDrawShowForPlayer(playerid, ServerText2);
  139. SetPlayerHealth(playerid, 100);
  140. return 1;
  141. }
  142.  
  143. PF: OnPlayerDisconnect(playerid, reason)
  144. {
  145. if(Logged[playerid] == true)
  146. {
  147. new query[200], pname[MAX_PLAYER_NAME];
  148. GetPlayerName(playerid, pname, sizeof(pname));
  149. format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d WHERE user='%s'", GetPlayerScore(playerid), GetPlayerMoney(playerid), pname);
  150. mysql_query(query);
  151.  
  152. }
  153. return 1;
  154. }
  155. public OnPlayerSpawn(playerid)
  156. {
  157. if(MoneyGiven[playerid] != -1)
  158. {
  159. GivePlayerMoney(playerid, MoneyGiven[playerid]);
  160. MoneyGiven[playerid] = -1;
  161. }
  162. // ShowPlayerDialog(playerid, D_REG, DIALOG_STYLE_LIST, "{FFFFFF}Gender Selection", "{F3FF02}Male\n{F3FF02}Female", #Select, #Quit);
  163. TextDrawHideForPlayer(playerid, ServerText2);
  164. return 1;
  165. }
  166.  
  167. public OnPlayerCommandText(playerid, cmdtext[])
  168. {
  169. if (strcmp("/mycommand", cmdtext, true, 10) == 0)
  170. {
  171. // Do something here
  172. return 1;
  173. }
  174. return 0;
  175. }
  176.  
  177. public OnPlayerRequestSpawn(playerid)
  178. {
  179. if(!Logged[playerid])
  180. {
  181. if(!IsRegistered[playerid])
  182. {
  183. ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "Register","This account is unregistered.\nInput desired password below.","Register","Cancel");
  184. return 0;
  185. }
  186. if(IsRegistered[playerid] == 1)
  187. {
  188. ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_INPUT, "Login","This account is registered.\nPlease Login input your login credentials.","Login","Cancel");
  189. return 0;
  190. }
  191. }
  192. return 1;
  193. }
  194.  
  195. public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
  196. {
  197. if(dialogid == 15000) // register dialog
  198. {
  199. if(response)
  200. {
  201. if(!(1 <= strlen(inputtext) <= 100))
  202. {
  203. SendClientMessage(playerid, -1, "You must insert a password between 1-100 characters!");
  204. ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "Register","This account is unregistered.\nInput desired password below.","Register","Cancel");
  205. }
  206. else
  207. {
  208. new escpass[100];
  209. mysql_real_escape_string(inputtext, escpass);
  210. MySQL_Register(playerid, escpass);
  211. }
  212. }
  213. if(!response)
  214. {
  215. SendClientMessage(playerid, -1, "You may not proceed until you register your account in our system.");
  216. ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_INPUT, "Register","This account is unregistered.\nInput desired password below.","Register","Cancel");
  217. }
  218. }
  219. if(dialogid == 15500) //Dialog login
  220. {
  221. if(!response)
  222. {
  223. SendClientMessage(playerid, -1, "Please login before proceeding.");
  224. ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_INPUT, "Login","This account is registered.\nPlease Login input your login credentials.","Login","Cancel");
  225. }
  226. else
  227. {
  228. new query[200], pname[24], escapepass[100]; //
  229. GetPlayerName(playerid, pname, 24);
  230. mysql_real_escape_string(inputtext, escapepass);
  231. format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
  232. mysql_query(query);
  233. mysql_store_result();
  234. new numrows = mysql_num_rows();
  235. if(numrows == 1) MySQL_Login(playerid);
  236.  
  237. if(!numrows)
  238. {
  239. ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_INPUT, "Login","This account is registered.\nPlease Login input your login credentials.","Login","Cancel");
  240. SendClientMessage(playerid, -1, "ERROR: Invalid password entry.");
  241. }
  242. mysql_free_result();
  243. }
  244. }
  245. if(dialogid == D_REG)
  246. {
  247. if(!response) Kick(playerid);
  248. else
  249. {
  250. switch(listitem)
  251. {
  252. case 0: ShowPlayerDialog(playerid, D_REG+1, DIALOG_STYLE_INPUT, "{FFFFFF}Character Age Selection", " {F3FF02}Input your desired In-game age. ( 1 - 80 ) ", #Select, #Quit);
  253. case 1: ShowPlayerDialog(playerid, D_REG+1, DIALOG_STYLE_INPUT, "{FFFFFF}Character Age Selection", " {F3FF02}Input your desired In-game age. ( 1 - 80 ) ", #Select, #Quit);
  254. }
  255. }
  256. }
  257. if(dialogid == D_REG+1)
  258. {
  259. if(!response) Kick(playerid);
  260. else
  261. {
  262. ShowPlayerDialog(playerid, D_REG+2, DIALOG_STYLE_MSGBOX, "{FFFFFF}I:RP Information", "{F3FF02}Welcome to I:RP.\n{F3FF02}We look forward to your time with us.\n{F3FF02}Please register at www.Intense-rp.com", #Select, #Quit);
  263. }
  264. }
  265. return 1;
  266. }
  267.  
  268. public OnPlayerClickPlayer(playerid, clickedplayerid, source)
  269. {
  270. return 1;
  271. }
  272. /* STOCK GLOBALS */
  273. stock MySQL_Register(playerid, passwordstring[])
  274. {
  275. new query[200], pname[24], IP[16];
  276. GetPlayerName(playerid, pname, 24);
  277. GetPlayerIp(playerid, IP, 16);
  278. format(query, sizeof(query), "INSERT INTO playerdata (user, password, score, money, IP) VALUES('%s', SHA1('%s'), 0, 0, '%s')", pname, passwordstring, IP);
  279. mysql_query(query);
  280.  
  281. SendClientMessage(playerid, -1, "Your account has been registered.");
  282. Logged[playerid] = true;
  283. return 1;
  284. }
  285.  
  286. stock MySQL_Login(playerid)
  287. {
  288. new query[300], pname[24], savingstring[20];
  289. GetPlayerName(playerid, pname, 24);
  290. format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s'", pname);
  291.  
  292. mysql_query(query);
  293. mysql_store_result();
  294. while(mysql_fetch_row_format(query,"|"))
  295. {
  296. mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
  297. mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
  298. }
  299. mysql_free_result();
  300. SendClientMessage(playerid, -1, "Your account is now logged in.");
  301. Logged[playerid] = true;
  302. return 1;
  303. }
  304. stock pName(playerid)
  305. {
  306. new name[MAX_PLAYER_NAME];
  307. GetPlayerName(playerid,name,sizeof(name));
  308. strreplacee(name, '_', ' ');
  309. return name;
  310. }
  311. stock strreplacee(string[], find, replace)
  312. {
  313. for(new i=0; string[i]; i++)
  314. {
  315. if(string[i] == find)
  316. {
  317. string[i] = replace;
  318. }
  319. }
  320. }
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!