API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.93 KB | None | 0 0
raw download clone embed print report
  1. stock LoadAccount(playerid)
  2. {
  3. new string[64];
  4. new playername[32];
  5. GetPlayerName(playerid,playername,32);
  6. format(query,256, "SELECT * FROM "TABLE_ACCOUNT" WHERE name = '%s' LIMIT 1",playername);
  7. mysql_query(query);
  8. mysql_store_result();
  9. if(mysql_fetch_row(query) == 1)
  10. {
  11. sscanf(query, "p<|>is[32]s[32]s[16]iis[32]s[64]iiiis[16]iiiiiiis[16]s[40]s[80]iiiiis[16]s[20]iiiis[32]s[32]fiiiiis[32]s[32]iiiiiiiiiiiiiiiiiiiiiiifiiiiiiiiiiiiiffffis[64]iiiiiis[64]iiiis[16]iis[100]ii",
  12. PlayerInfo[playerid][pID],//1----
  13. PlayerInfo[playerid][pSendername],//2---------
  14. PlayerInfo[playerid][pPassword],//3---------
  15. PlayerInfo[playerid][pIP],//4----------
  16. PlayerInfo[playerid][pAdminn],//5
  17. PlayerInfo[playerid][pAdmPass],
  18. PlayerInfo[playerid][pIpPassword],//6
  19. PlayerInfo[playerid][pMail],//7
  20. PlayerInfo[playerid][pLevel],//8
  21. PlayerInfo[playerid][pCash],//9
  22. PlayerInfo[playerid][pBank],//10
  23. PlayerInfo[playerid][pExp],//11
  24. PlayerInfo[playerid][pRegData],//12
  25. PlayerInfo[playerid][pLeader],//13
  26. PlayerInfo[playerid][pMember],//14
  27. PlayerInfo[playerid][pRank],//15
  28. PlayerInfo[playerid][pWarn],//16
  29. PlayerInfo[playerid][pSex],//17
  30. PlayerInfo[playerid][pModel],//18
  31. PlayerInfo[playerid][pChar],//19
  32. PlayerInfo[playerid][pLics],//20
  33. PlayerInfo[playerid][pGuns],//21
  34. PlayerInfo[playerid][pAmmos],//22
  35. PlayerInfo[playerid][pGunSkill][6],//23
  36. PlayerInfo[playerid][pMuted],//24
  37. PlayerInfo[playerid][pPick],//25
  38. PlayerInfo[playerid][pCheckTime],//26
  39. PlayerInfo[playerid][pNews],//27
  40. PlayerInfo[playerid][pPhones],//28
  41. PlayerInfo[playerid][pTexts],//29
  42. PlayerInfo[playerid][pMorgan],//30
  43. PlayerInfo[playerid][pMorganTime],//31-------------------------------------
  44. PlayerInfo[playerid][pWanted],//32
  45. PlayerInfo[playerid][pWantedTime],//33
  46. PlayerInfo[playerid][pWantedWho],//34
  47. PlayerInfo[playerid][pWantedReason],//35
  48. PlayerInfo[playerid][pHeal],//36
  49. PlayerInfo[playerid][pDrugs],//37
  50. PlayerInfo[playerid][pMats],//38
  51. PlayerInfo[playerid][pCrimes],//39
  52. PlayerInfo[playerid][pJob],//40
  53. PlayerInfo[playerid][pMarried],//41
  54. PlayerInfo[playerid][pWhoMarried],//42
  55. PlayerInfo[playerid][pReferal],//43
  56. PlayerInfo[playerid][pRefMoney],//44
  57. PlayerInfo[playerid][pPayCheck],//45--------------------
  58. PlayerInfo[playerid][pFish],//46
  59. PlayerInfo[playerid][pLottery],//47
  60. PlayerInfo[playerid][pVIP],//48
  61. PlayerInfo[playerid][pTime],//49
  62. PlayerInfo[playerid][pFightStyle],//50
  63. PlayerInfo[playerid][pCredits],//51
  64. PlayerInfo[playerid][pPromoCode],//51
  65. PlayerInfo[playerid][pSkin1],//52
  66. PlayerInfo[playerid][pSkin2],//53
  67. PlayerInfo[playerid][pSkin3],//54
  68. PlayerInfo[playerid][pSpawnChange],//55
  69. PlayerInfo[playerid][pGunSkill][0],//56
  70. PlayerInfo[playerid][pGunSkill][1],//57
  71. PlayerInfo[playerid][pGunSkill][2],//58
  72. PlayerInfo[playerid][pGunSkill][3],//59
  73. PlayerInfo[playerid][pGunSkill][4],//60
  74. PlayerInfo[playerid][pGunSkill][5],//61
  75. PlayerInfo[playerid][pRPR],//62
  76. PlayerInfo[playerid][pGlasses],//63
  77. PlayerInfo[playerid][pSatiety],//64
  78. PlayerInfo[playerid][pRPRGive],//65
  79. PlayerInfo[playerid][pHealthS],//66
  80. PlayerInfo[playerid][pSportEXP],//67
  81. PlayerInfo[playerid][pOnline],//68
  82. PlayerInfo[playerid][pZakon],//69
  83. PlayerInfo[playerid][pBolezn],//70
  84. PlayerInfo[playerid][ProverkaIP],//71
  85. PlayerInfo[playerid][pHospital],//72
  86. PlayerInfo[playerid][pWatch],//73
  87. PlayerInfo[playerid][pCiggare],//74
  88. PlayerInfo[playerid][pSprunk],//75
  89. PlayerInfo[playerid][pMask],//76
  90. PlayerInfo[playerid][pPhoneBalance],//77
  91. PlayerInfo[playerid][pTruckSkill],//78
  92. PlayerInfo[playerid][cModel],//79
  93. PlayerInfo[playerid][cX],//80
  94. PlayerInfo[playerid][cY],//81
  95. PlayerInfo[playerid][cZ],//82
  96. PlayerInfo[playerid][cFa],//83
  97. PlayerInfo[playerid][cFuel],//85
  98. PlayerInfo[playerid][cNumber],//86
  99. PlayerInfo[playerid][pCReg],
  100. PlayerInfo[playerid][cCarAr],//96
  101. PlayerInfo[playerid][cClass],//84
  102. PlayerInfo[playerid][cColor][0],//87
  103. PlayerInfo[playerid][cColor][1],//88
  104. PlayerInfo[playerid][cLock],//89
  105. PlayerInfo[playerid][cCost],//90
  106. PlayerInfo[playerid][cVehcom],//91
  107. PlayerInfo[playerid][cPaintjob],//92
  108. PlayerInfo[playerid][pSpawn],//93
  109. PlayerInfo[playerid][pVb],//94
  110. PlayerInfo[playerid][pWorkBook],//95
  111. PlayerInfo[playerid][pVIPDate],
  112. PlayerInfo[playerid][pVzlom],
  113. PlayerInfo[playerid][pLastVizit],
  114. PlayerInfo[playerid][pUl],
  115. PlayerInfo[playerid][pFast]);//97
  116. mysql_free_result();
  117. printf("Значение LastVisit загружено: %s", PlayerInfo[playerid][pLastVizit]);
  118. sscanf(PlayerInfo[playerid][cVehcom], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms]);
  119. LoadMyCar(playerid);
  120. PlayerLogged[playerid] = true;
  121. TimeLogged[playerid] = -1;
  122. TextDrawShowForPlayer(playerid, SiteText);
  123.  
  124. sscanf(PlayerInfo[playerid][pTexts], "p<,>a<i>[3]", PlayerInfo[playerid][pText]);
  125. sscanf(PlayerInfo[playerid][pPhones], "p<,>a<i>[3]", PlayerInfo[playerid][pPhone]);
  126. sscanf(PlayerInfo[playerid][pLics], "p<,>a<i>[5]",PlayerInfo[playerid][pLic]);
  127. sscanf(PlayerInfo[playerid][pWorkBook], "p<,>a<i>[6]",PlayerInfo[playerid][pWB]);
  128. new a;
  129. while(a++ < 100) SendClientMessage(playerid, COLOR_LIGHTRED, "");
  130.  
  131. if(X2DAY != 1)
  132. {
  133. SendClientMessage(playerid, COLOR_ORANGE, "{027BEB}Добро пожаловать на Russia RolePlay");
  134. SendClientMessage(playerid, COLOR_RED, "[Подсказка] {FFFFFF}Используйте команду /menu и /gps для управления игровым персонажем.");
  135. SendClientMessage(playerid, COLOR_RED, "[Подсказка] {FFFFFF}Вы можете задать вопрос в нашу техническую поддержку /report.");
  136. }
  137. else if(X2DAY == 1)
  138. {
  139. SendClientMessage(playerid, COLOR_ORANGE, "{027BEB}Добро пожаловать на Russia RolePlay");
  140. SendClientMessage(playerid, COLOR_RED, "[Подсказка] {FFFFFF}Используйте команду /menu и /gps для управления игровым персонажем.");
  141. SendClientMessage(playerid, COLOR_RED, "[Подсказка] {FFFFFF}Вы можете задать вопрос в нашу техническую поддержку /report.");
  142. SendClientMessage(playerid, COLOR_YELLOW, "Сегодня на сервере X2 день! Это значит, что оплата на работах, зарплата во фракциях,");
  143. SendClientMessage(playerid, COLOR_YELLOW, "опыт и т.д начисляются вдвое больше!");
  144. }
  145.  
  146. format(PlayerInfo[playerid][pLastVizit],100,"%s",PlayerInfo[playerid][pLastVizit]);
  147. SendMes(playerid,COLOR_RED,"[Информация] {FFFFFF}Последний раз вход на аккаунт был выполнен:{FFFFFF} %s ",PlayerInfo[playerid][pLastVizit]);
  148. if(PlayerInfo[playerid][pAdminn] > 0) AdminLogged[playerid] = true;
  149. if(gettime() >= PlayerInfo[playerid][pVIPDate])
  150. {
  151. PlayerInfo[playerid][pVIP] = 0;
  152. PlayerInfo[playerid][pVIPDate] = 0;
  153. //SendClientMessage(playerid, COLOR_RED, "[Важно] {FFFFFF}Срок вашего VIP аккаунта истек, уровень VIP был снят.");
  154. }
  155. else SendClientMessage(playerid, COLOR_RED, "[Информация]{FFFFFF} Возможности VIP аккаунта активированы, приятной игры!");
  156. if (PlayerInfo[playerid][pText][0] == 1)
  157. {
  158. SendClientMessage(playerid, COLOR_RED, "[Важно] {FFFFFF}Вы забыли оплатить за кварплату, ваш дом продали!");
  159. SendClientMessage(playerid, COLOR_RED, "{FFFFFF}На ваш банковский счет возвращена стоимость дома по гос-ву");
  160. PlayerInfo[playerid][pText][0] = 0;
  161. format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
  162. format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
  163. mysql_query(query);
  164. }
  165. if(PlayerInfo[playerid][pText][1] == 1)
  166. {
  167. SendClientMessage(playerid, COLOR_RED, "[Важно] {FFFFFF}Ваш бизнес закрыли в связи с нехваткой ресурсов");
  168. SendClientMessage(playerid, COLOR_YELLOW,"{FFFFFF}Бюджет бизнеса зачислен на ваш банковский счет");
  169. PlayerInfo[playerid][pText][1] = 0;
  170. format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
  171. format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
  172. mysql_query(query);
  173. }
  174. if(PlayerInfo[playerid][pText][2] == 1)
  175. {
  176. new p = PlayerInfo[playerid][pRefMoney] / 100000;
  177. for(new i = 1; i <= p; i++)
  178. {
  179. GiveMoney(playerid, 100000);
  180. PlayerInfo[playerid][pRefMoney] -= 100000;
  181. }
  182. PlayerInfo[playerid][pText][2] = 0;
  183. format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
  184. format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s', refmoney WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pRefMoney], PlayerInfo[playerid][pSendername]);
  185. mysql_query(query);
  186. }
  187. if(PlayerInfo[playerid][pGunSkill][6] >= NORM_SKILLS_PLAYER) VehRe[playerid] = true;
  188. SetSpawnInfo(playerid, 255, PlayerInfo[playerid][pModel], 0, 0, 0, 1.0, -1, -1, -1, -1, -1, -1);
  189. SpawnPlayer(playerid);
  190. new str123[12];
  191. GetPlayerIp(playerid,str123,12);
  192. format(string, 64, "%s зашел в аккаунт с ip: %s",PlayerInfo[playerid][pSendername],str123);
  193. Log("LogInfo",string);
  194. DeletePVar(playerid,"Acc");
  195. SetPlayerInt(PlayerInfo[playerid][pSendername], "online", 1);
  196. //LoadMyCar(playerid);
  197. }
  198. return true;
  199. }
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!