API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 25th, 2018
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.92 KB | None | 0 0
raw download clone embed print report
  1. stock SaveAccount(playerid)
  2. {
  3. if(!PlayerLogged[playerid]) return true;
  4. new src[128];
  5. format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
  6. format(src,sizeof(src),"ip='%s',", PlayerInfo[playerid][pPlIP]);
  7. strcat(query,src,sizeof(query));
  8. format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
  9. strcat(query,src,sizeof(query));
  10. format(src,sizeof(src),"admin=%d,",PlayerInfo[playerid][pAdmin]);
  11. strcat(query,src,sizeof(query));
  12. format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
  13. strcat(query,src,sizeof(query));
  14. format(src,sizeof(src),"ippassword='%s',",PlayerInfo[playerid][pIpPassword]);
  15. strcat(query,src,sizeof(query));
  16. format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
  17. strcat(query,src,sizeof(query));
  18. format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
  19. strcat(query,src,sizeof(query));
  20. format(src,sizeof(src),"cash=%d,",GetMoney(playerid));
  21. strcat(query,src,sizeof(query));
  22. format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
  23. strcat(query,src,sizeof(query));
  24. format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
  25. strcat(query,src,sizeof(query));
  26. format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
  27. strcat(query,src,sizeof(query));
  28. format(src,sizeof(src),"avig=%d,",PlayerInfo[playerid][pAvig]);
  29. strcat(query,src,sizeof(query));
  30. format(src,sizeof(src),"quest=%d,",PlayerInfo[playerid][pQuest]);
  31. strcat(query,src,sizeof(query));
  32. format(src,sizeof(src),"progress=%d,",PlayerInfo[playerid][pProgress]);
  33. strcat(query,src,sizeof(query));
  34. format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
  35. strcat(query,src,sizeof(query));
  36. format(src,sizeof(src),"templeader=%d,",PlayerInfo[playerid][pTempleader]);
  37. strcat(query,src,sizeof(query));
  38. format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
  39. strcat(query,src,sizeof(query));
  40. format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
  41. strcat(query,src,sizeof(query));
  42. format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
  43. strcat(query,src,sizeof(query));
  44. format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
  45. strcat(query,src,sizeof(query));
  46. format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
  47. strcat(query,src,sizeof(query));
  48. format(src,sizeof(src),"morgan='%i',",PlayerInfo[playerid][pMorgan]);
  49. strcat(query,src,sizeof(query));
  50. format(src,sizeof(src),"morgantime='%i',",PlayerInfo[playerid][pMorganTime]);
  51. strcat(query,src,sizeof(query));
  52. format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
  53. strcat(query,src,sizeof(query));
  54. format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
  55. strcat(query,src,sizeof(query));
  56. format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
  57. strcat(query,src,sizeof(query));
  58. format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
  59. strcat(query,src,sizeof(query));
  60. format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
  61. strcat(query,src,sizeof(query));
  62. format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
  63. strcat(query,src,sizeof(query));
  64. format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
  65. strcat(query,src,sizeof(query));
  66. format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
  67. strcat(query,src,sizeof(query));
  68. format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
  69. strcat(query,src,sizeof(query));
  70. format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
  71. strcat(query,src,sizeof(query));
  72. format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
  73. strcat(query,src,sizeof(query));
  74. format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
  75. strcat(query,src,sizeof(query));
  76. format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
  77. strcat(query,src,sizeof(query));
  78. format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
  79. strcat(query,src,sizeof(query));
  80. format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
  81. strcat(query,src,sizeof(query));
  82. format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
  83. strcat(query,src,sizeof(query));
  84. format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
  85. strcat(query,src,sizeof(query));
  86. format(src,sizeof(src),"fstyle='%i',",PlayerInfo[playerid][pFightStyle]);
  87. strcat(query,src,sizeof(query));
  88. format(src,sizeof(src),"credits='%i',",PlayerInfo[playerid][pCredits]);
  89. strcat(query,src,sizeof(query));
  90. format(src,sizeof(src),"totalcredits='%i',",PlayerInfo[playerid][pTotalCredits]);
  91. strcat(query,src,sizeof(query));
  92. format(src,sizeof(src),"skin1='%i',",PlayerInfo[playerid][pSkin1]);
  93. strcat(query,src,sizeof(query));
  94. format(src,sizeof(src),"skin2='%i',",PlayerInfo[playerid][pSkin2]);
  95. strcat(query,src,sizeof(query));
  96. format(src,sizeof(src),"skin3='%i',",PlayerInfo[playerid][pSkin3]);
  97. strcat(query,src,sizeof(query));
  98. format(src,sizeof(src),"spawnchange='%i',",PlayerInfo[playerid][pSpawnChange]);
  99. strcat(query,src,sizeof(query));
  100. format(src,sizeof(src),"sdpistol='%i',",PlayerInfo[playerid][pGunSkill][0]);
  101. strcat(query,src,sizeof(query));
  102. format(src,sizeof(src),"deserteagle='%i',",PlayerInfo[playerid][pGunSkill][1]);
  103. strcat(query,src,sizeof(query));
  104. format(src,sizeof(src),"shotgun='%i',",PlayerInfo[playerid][pGunSkill][2]);
  105. strcat(query,src,sizeof(query));
  106. format(src,sizeof(src),"mp5='%i',",PlayerInfo[playerid][pGunSkill][3]);
  107. strcat(query,src,sizeof(query));
  108. format(src,sizeof(src),"ak47='%i',",PlayerInfo[playerid][pGunSkill][4]);
  109. strcat(query,src,sizeof(query));
  110. format(src,sizeof(src),"m4='%i',",PlayerInfo[playerid][pGunSkill][5]);
  111. strcat(query,src,sizeof(query));
  112. format(src,sizeof(src),"rpr='%i',",PlayerInfo[playerid][pRPR]);
  113. strcat(query,src,sizeof(query));
  114. format(src,sizeof(src),"glasses='%d',",PlayerInfo[playerid][pGlasses]);
  115. strcat(query,src,sizeof(query));
  116. format(src,sizeof(src),"satiety='%i',",PlayerInfo[playerid][pSatiety]);
  117. strcat(query,src,sizeof(query));
  118. format(src,sizeof(src),"rprgive='%i',",PlayerInfo[playerid][pRPRGive]);
  119. strcat(query,src,sizeof(query));
  120. format(src,sizeof(src),"healths='%f',",PlayerInfo[playerid][pHealthS]);
  121. strcat(query,src,sizeof(query));
  122. format(src,sizeof(src),"sportexp='%i',",PlayerInfo[playerid][pSportEXP]);
  123. strcat(query,src,sizeof(query));
  124. format(src,sizeof(src),"online='%i',",PlayerInfo[playerid][pOnline]);
  125. strcat(query,src,sizeof(query));
  126. format(src,sizeof(src),"zakon='%i',",PlayerInfo[playerid][pZakon]);
  127. strcat(query,src,sizeof(query));
  128. format(src,sizeof(src),"bolezn='%i',",PlayerInfo[playerid][pBolezn]);
  129. strcat(query,src,sizeof(query));
  130. format(src,sizeof(src),"ipcheck='%i',",PlayerInfo[playerid][ProverkaIP]);
  131. strcat(query,src,sizeof(query));
  132. format(src,sizeof(src),"hospital='%i',",PlayerInfo[playerid][pHospital]);
  133. strcat(query,src,sizeof(query));
  134. format(src,sizeof(src),"watch='%i',",PlayerInfo[playerid][pWatch]);
  135. strcat(query,src,sizeof(query));
  136. format(src,sizeof(src),"ciggare='%i',",PlayerInfo[playerid][pCiggare]);
  137. strcat(query,src,sizeof(query));
  138. format(src,sizeof(src),"sprunk='%i',",PlayerInfo[playerid][pSprunk]);
  139. strcat(query,src,sizeof(query));
  140. format(src,sizeof(src),"mask='%i',",PlayerInfo[playerid][pMask]);
  141. strcat(query,src,sizeof(query));
  142. format(src,sizeof(src),"phonebalance='%i',",PlayerInfo[playerid][pPhoneBalance]);
  143. strcat(query,src,sizeof(query));
  144. format(src,sizeof(src),"truckskill='%i',",PlayerInfo[playerid][pTruckSkill]);
  145. strcat(query,src,sizeof(query));
  146. format(src,sizeof(src),"spawn='%i',",PlayerInfo[playerid][pSpawn]);
  147. strcat(query,src,sizeof(query));
  148. format(src,sizeof(src),"vb='%i',",PlayerInfo[playerid][pVb]);
  149. strcat(query,src,sizeof(query));
  150. format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
  151. PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
  152. format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
  153. strcat(query,src,sizeof(query));
  154. format(PlayerInfo[playerid][pLics],40,"%i, %i, %i, %i, %i",
  155. PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
  156. ,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
  157. format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLics]);
  158. strcat(query,src,sizeof(query));
  159. format(PlayerInfo[playerid][pWorkBook], 40, "%i, %i, %i, %i, %i, %i",
  160. PlayerInfo[playerid][pWB][0], PlayerInfo[playerid][pWB][1],PlayerInfo[playerid][pWB][2]
  161. ,PlayerInfo[playerid][pWB][3],PlayerInfo[playerid][pWB][4], PlayerInfo[playerid][pWB][5]);
  162. format(src,sizeof(src),"workbook='%s',",PlayerInfo[playerid][pWorkBook]);
  163. strcat(query,src,sizeof(query));
  164. if(GetPVarInt(playerid, "GunCheat") == 0)
  165. {
  166. for(new i = 0; i < 13; i++)
  167. {
  168. GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun][i], PlayerInfo[playerid][pAmmo][i]);
  169. }
  170. format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
  171. PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
  172. PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
  173. PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
  174. PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
  175. format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
  176. strcat(query,src,sizeof(query));
  177. format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
  178. PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
  179. PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
  180. PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
  181. PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
  182. format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
  183. }
  184. strcat(query,src,sizeof(query));
  185. format(src,sizeof(src),"skills='%d'",PlayerInfo[playerid][pGunSkill][6]);
  186. strcat(query,src,sizeof(query));
  187. new playername[32];
  188. GetPlayerName(playerid,playername,32);
  189. format(src,sizeof(src)," WHERE name='%s'",playername);
  190. strcat(query,src,sizeof(query));
  191. mysql_function_query(ConBD, query, true, "", "");
  192. SaveAllMyCar(playerid);
  193. return true;
  194. }
  195.  
  196. //
  197.  
  198. public SaveAcc()
  199. {
  200. new timeUser = GetTickCount();
  201. SendAdminMessage(COLOR_GOLD, "[A] {DEB887}>> {3399FF}Выполняется сохранение всех аккаунтов");
  202. for(new j = 0; j <= MAX_PLAYERS; j++)
  203. {
  204. if(!IsPlayerConnected(j) || PlayerLogged[j] == 0) continue;
  205. SaveAccount(j);
  206. SetPlayerSkills(j);
  207. }
  208. format(totalstring, 128, "[A] {DEB887}>> {3399FF}Сохранение прошло успешно, следующее через 5 минут. ({FF8C00} %i {3399FF}мс)", GetTickCount() - timeUser);
  209. SendAdminMessage(COLOR_GOLD, totalstring); return true;
  210. }
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!