API tools faq
paste
Advertisement
Guest User

samp.ro

a guest
Apr 12th, 2015
217
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.16 KB | None | 0 0
raw download clone embed print report
  1. public OnPlayerLogin(playerid,password[]) //
  2. {
  3. new hour,minute,second;
  4. gettime(hour,minute,second);
  5. MySQLCheckConnection();
  6. new string2[256];
  7. new tmp2[182];
  8. MySQLFetchAcctSingle(PlayerData[playerid][pSQLID], "Password", PlayerData[playerid][pKey]);
  9. //format(string2, sizeof(string2), "DEBUG: PASSED1 , Password from MySQL : %s", PlayerData[playerid][pKey]);
  10. //SendClientMessage(playerid, -1, string2);
  11. if(!strcmp(PlayerData[playerid][pKey],password, false) && strlen(password) != 0)
  12. {
  13. //format(string2, sizeof(string2), "DEBUG: PASSED2 , Password from MySQL : %s", password);
  14. //SendClientMessage(playerid, -1, string2);
  15. new Query[256];
  16. format(Query, sizeof(Query), "SELECT * FROM players WHERE id= %d", PlayerData[playerid][pSQLID]);
  17. mysql_query(Query); // Querys the "Query" Variable.
  18. mysql_store_result(); // Stores the result from Query
  19. if(mysql_num_rows()) // Checks if theres anyrow.
  20. if(mysql_fetch_row_format(Query,"|")) // Splits the row
  21. {
  22. sscanf(Query, "p<|>e<is[182]s[182]iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii>",PlayerData[playerid]);
  23. }
  24. MySQLUltLog(PlayerData[playerid][pSQLID], "MarriedTo", PlayerData[playerid][pMarriedTo]);
  25. mysql_store_result();
  26. MySQLUltLog(PlayerData[playerid][pSQLID], "Email", PlayerData[playerid][pEmail]);
  27. mysql_store_result();
  28. }
  29. else
  30. {
  31. new loginstring[182];
  32. new loginname[182];
  33. GetPlayerName(playerid,loginname,sizeof(loginname));
  34. format(loginstring,sizeof(loginstring),"PAROLA GRESITA\nTe rog baga parola corecta:",loginname);
  35. ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"{1E90FF}L{FFFFFF}ogeaza-te",loginstring,"Login","Exit");
  36. gPlayerLogTries[playerid] += 1;
  37. if(gPlayerLogTries[playerid] == 4) { Kick(playerid); }
  38. return 1;
  39. }
  40. new year, month,day;
  41. getdate(year, month, day);
  42. new string[182];
  43. new query[MAX_STRING];
  44. new zero1[5];
  45. new zero2[5];
  46. new zero3[5];
  47. new zero4[5];
  48. if(hour < 10)
  49. {
  50. zero1 = "0";
  51. }
  52. if(minute < 10)
  53. {
  54. zero2 = "0";
  55. }
  56. if(day < 10)
  57. {
  58. zero3 = "0";
  59. }
  60. if(month < 10)
  61. {
  62. zero4 = "0";
  63. }
  64. format(string, sizeof(string), "%s%d:%s%d %s%d.%s%d.%d",zero1,hour,zero2,minute,zero3,day,zero4,month,year);
  65. strmid(PlayerData[playerid][pUltLog], string, 0, strlen(string), 255);
  66. format(query, sizeof(query), "UPDATE players SET UltLog='%s' WHERE id=%d", PlayerData[playerid][pUltLog], PlayerData[playerid][pSQLID]);
  67. mysql_query(query);
  68. if(PlayerData[playerid][pPcarkey] == 0)
  69. {
  70. PlayerData[playerid][pPcarkey] = 999;
  71. format(query, sizeof(query), "UPDATE players SET Car='%d' WHERE id=%d", PlayerData[playerid][pPcarkey], PlayerData[playerid][pSQLID]);
  72. mysql_query(query);
  73. }
  74. if(PlayerData[playerid][pPcarkey2] == 0)
  75. {
  76. PlayerData[playerid][pPcarkey2] = 999;
  77. format(query, sizeof(query), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerData[playerid][pPcarkey2], PlayerData[playerid][pSQLID]);
  78. mysql_query(query);
  79. }
  80. if(PlayerData[playerid][pPcarkey3] == 0)
  81. {
  82. PlayerData[playerid][pPcarkey3] = 999;
  83. format(query, sizeof(query), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerData[playerid][pPcarkey3], PlayerData[playerid][pSQLID]);
  84. mysql_query(query);
  85. }
  86. //mysql_free_result();
  87. PlayerData[playerid][pAdjustable] = 0;
  88. ConsumingMoney[playerid] = 1;
  89. if(PlayerData[playerid][pReg] == 0)
  90. {
  91. PlayerData[playerid][pLevel] = 1;
  92. PlayerData[playerid][pSHealth] = 0.0;
  93. PlayerData[playerid][pHealth] = 50.0;
  94. PlayerData[playerid][pArmour] = 0.0;
  95. PlayerData[playerid][pPos_x] = 2246.6;
  96. PlayerData[playerid][pPos_y] = -1161.9;
  97. PlayerData[playerid][pPos_z] = 1029.7;
  98. PlayerData[playerid][pInt] = 15;
  99. PlayerData[playerid][pLocal] = 255;
  100. PlayerData[playerid][pTeam] = 3;
  101. PlayerData[playerid][pModel] = 264;
  102. new randphone = 1000 + random(8999);//minimum 1000 max 9999 //giving one at the start
  103. PlayerData[playerid][pPnumber] = randphone;
  104. PlayerData[playerid][pPhousekey] = 255;
  105. PlayerData[playerid][pPbiskey] = 255;
  106. PlayerData[playerid][pPcarkey] = 999;
  107. PlayerData[playerid][pPcarkey2] = 999;
  108. PlayerData[playerid][pPcarkey3] = 999;
  109. PlayerData[playerid][pPcarkey4] = 999;
  110. PlayerData[playerid][pPcarkey5] = 999;
  111. PlayerData[playerid][pAccount] = 5000;
  112. PlayerData[playerid][pReg] = 1;
  113. PlayerData[playerid][pLocked] = 0;
  114. GivePlayerCash(playerid, 1000);
  115. format(string, sizeof(string), "UPDATE players SET Registered='%d' WHERE id=%d", PlayerData[playerid][pReg], PlayerData[playerid][pSQLID]);
  116. mysql_query(string);
  117. format(string, sizeof(string), "UPDATE players SET PhoneNr='%d' WHERE id=%d", PlayerData[playerid][pPnumber], PlayerData[playerid][pSQLID]);
  118. mysql_query(string);
  119. format(string, sizeof(string), "UPDATE players SET House='%d' WHERE id=%d", PlayerData[playerid][pPhousekey], PlayerData[playerid][pSQLID]);
  120. mysql_query(string);
  121. format(string, sizeof(string), "UPDATE players SET Car='%d' WHERE id=%d", PlayerData[playerid][pPcarkey], PlayerData[playerid][pSQLID]);
  122. mysql_query(string);
  123. format(string, sizeof(string), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerData[playerid][pPcarkey2], PlayerData[playerid][pSQLID]);
  124. mysql_query(string);
  125. format(string, sizeof(string), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerData[playerid][pPcarkey3], PlayerData[playerid][pSQLID]);
  126. mysql_query(string);
  127. format(string, sizeof(string), "UPDATE players SET Car4='%d' WHERE id=%d", PlayerData[playerid][pPcarkey4], PlayerData[playerid][pSQLID]);
  128. mysql_query(string);
  129. format(string, sizeof(string), "UPDATE players SET Car5='%d' WHERE id=%d", PlayerData[playerid][pPcarkey5], PlayerData[playerid][pSQLID]);
  130. mysql_query(string);
  131. format(string, sizeof(string), "UPDATE players SET Bank='%d' WHERE id=%d", PlayerData[playerid][pAccount], PlayerData[playerid][pSQLID]);
  132. mysql_query(string);
  133. format(string, sizeof(string), "UPDATE players SET Locked='%d' WHERE id=%d", PlayerData[playerid][pLocked], PlayerData[playerid][pSQLID]);
  134. mysql_query(string);
  135. }
  136. printf(" %s has logged in.", PlayerData[playerid][pNume]);
  137. new playersip[182];
  138. getdate(year, month, day);
  139. gettime(hour,minute,second);
  140. GetPlayerIp(playerid,playersip,sizeof(playersip));
  141. //format(string, sizeof(string), "AdmCmd: %s s-a logat astazi %d/%d/%d ora %d:%d, de pe ip %s",PlayerData[playerid][pNume],month,day,year,hour,minute,playersip);
  142. //ConnectLog(string);
  143. format(string, sizeof(string), "INSERT INTO ConnectLog (Nume, Data, IP, Tip) VALUES ('%s', '%s', '%s', 'Logare')", PlayerData[playerid][pNume], PlayerData[playerid][pUltLog], playersip);
  144. mysql_query(string);
  145. PlayerData[playerid][pStatus] = 1;
  146. format(string, sizeof(string), "UPDATE players SET Status='%d' WHERE id=%d", PlayerData[playerid][pStatus], PlayerData[playerid][pSQLID]);
  147. mysql_query(string);
  148. if(PlayerData[playerid][pAllowed] == 0)
  149. {
  150. for(new i=1; i<=maxim;i++)
  151. {
  152. if(strfind(playersip, BanData[i][xIp], true) != -1)
  153. {
  154. SendClientMessage(playerid, COLOR_WHITE, "Server: {FF0000}Ai primit ban pe aceasta clasa de ip.");
  155. SendClientMessage(playerid, COLOR_LIGHTRED, "Pentru unban viziteaza www.gPCommunity.in");
  156. Kick(playerid);
  157. return 1;
  158. }
  159. }
  160. }
  161. getdate(year, month, day);
  162. new hourr,minutee,secondd;
  163. gettime(hourr,minutee,secondd);
  164. if(Registerr[playerid] == 2)
  165. {
  166. new stringg[182];
  167. format(stringg, sizeof(stringg), "%d %d %d",day,month,year);
  168. strmid(PlayerData[playerid][pDateReg], stringg, 0, strlen(stringg), 255);
  169. format(query, sizeof(query), "UPDATE players SET DateReg='%s' WHERE id=%d", stringg, PlayerData[playerid][pSQLID]);
  170. Registerr[playerid] = 0;
  171. mysql_query(query);
  172. //mysql_free_result();
  173. }
  174. SendClientMessage(playerid, COLOR_LIGHTGREEN, "|===============================================================================|");
  175. //
  176. if (PlayerData[playerid][pDonateRank] > 0 && PlayerData[playerid][pAdmin] < 1 && PlayerData[playerid][pAgent] < 1)
  177. {
  178. SendClientMessage(playerid, COLOR_LIGHTBLUE, "[Server]: Esti donator.");
  179. }
  180. if (PlayerData[playerid][pAdmin] >= 1 && PlayerData[playerid][pDonateRank] < 1 && PlayerData[playerid][pAgent] < 1)
  181. {
  182. format(string2, sizeof(string2), "[Server]: Te-ai logat. Esti admin level %d.", PlayerData[playerid][pAdmin]);
  183. SendClientMessage(playerid, COLOR_LIGHTBLUE,string2);
  184. }
  185. if (PlayerData[playerid][pAdmin] >= 1 && PlayerData[playerid][pDonateRank] > 0 && PlayerData[playerid][pAgent] < 1)
  186. {
  187. format(string2, sizeof(string2), "[Server]: Te-ai logat. Esti donator si admin level %d.", PlayerData[playerid][pAdmin]);
  188. SendClientMessage(playerid, COLOR_LIGHTBLUE,string2);
  189. }
  190. if (PlayerData[playerid][pAdmin] >= 1 && PlayerData[playerid][pDonateRank] > 0 && PlayerData[playerid][pAgent] > 0)
  191. {
  192. format(string2, sizeof(string2), "[Server]: Te-ai logat. Esti donator,Helper si admin level %d.", PlayerData[playerid][pAdmin]);
  193. SendClientMessage(playerid, COLOR_LIGHTBLUE,string2);
  194. }
  195. if (PlayerData[playerid][pAgent] >= 1 && PlayerData[playerid][pDonateRank] < 1 && PlayerData[playerid][pAdmin] < 1)
  196. {
  197. format(string2, sizeof(string2), "[Server]: Te-ai logat. Esti Helper.");
  198. SendClientMessage(playerid, COLOR_LIGHTBLUE,string2);
  199. }
  200. if (PlayerData[playerid][pAgent] >= 1 && PlayerData[playerid][pDonateRank] > 0 && PlayerData[playerid][pAdmin] < 1)
  201. {
  202. format(string2, sizeof(string2), "[Server]: Te-ai logat. Esti donator si Helper.");
  203. SendClientMessage(playerid, COLOR_LIGHTBLUE,string2);
  204. }
  205. WantedLevel[playerid] = PlayerData[playerid][pWantedLevel];
  206. WantedPoints[playerid] = PlayerData[playerid][pWantedPoints];
  207. SetPlayerWantedLevel(playerid, PlayerData[playerid][pWantedLevel]);
  208. if (PlayerData[playerid][pWantedLevel] > 0)
  209. {
  210. format(string2, sizeof(string2), "SERVER: Ai primit inapoi %d stele!",WantedLevel[playerid]);
  211. SendClientMessage(playerid, COLOR_LIGHTRED, string2);
  212. }
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!