API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
57
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.93 KB | None | 0 0
raw download clone embed print report
  1. stock SaveAccount(playerid)
  2. {
  3. if(PlayerLogged[playerid] == 0) return true;
  4. new src[128];
  5. /////////////////////////////////
  6. format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
  7. format(src,sizeof(src),"ip='%s',", PlayerInfo[playerid][pPlIP]);
  8. strcat(query,src,sizeof(query));
  9. format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
  10. strcat(query,src,sizeof(query));
  11. format(src,sizeof(src),"adminn=%d,",PlayerInfo[playerid][pAdminn]);
  12. strcat(query,src,sizeof(query));
  13. format(src,sizeof(src),"admpass=%d,",PlayerInfo[playerid][pAdmPass]);
  14. strcat(query,src,sizeof(query));
  15. format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
  16. strcat(query,src,sizeof(query));
  17. format(src,sizeof(src),"ippassword='%s',",PlayerInfo[playerid][pIpPassword]);
  18. strcat(query,src,sizeof(query));
  19. format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
  20. strcat(query,src,sizeof(query));
  21.  
  22. format(src,sizeof(src),"ul=%d,",PlayerInfo[playerid][pUl]);
  23. strcat(query,src,sizeof(query));
  24. format(src,sizeof(src),"fast=%d,",PlayerInfo[playerid][pFast]);
  25. strcat(query,src,sizeof(query));
  26.  
  27. format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
  28. strcat(query,src,sizeof(query));
  29. format(src,sizeof(src),"cash=%d,",GetMoney(playerid));
  30. strcat(query,src,sizeof(query));
  31. format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
  32. strcat(query,src,sizeof(query));
  33. format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
  34. strcat(query,src,sizeof(query));
  35. format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
  36. strcat(query,src,sizeof(query));
  37. format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
  38. strcat(query,src,sizeof(query));
  39. format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
  40. strcat(query,src,sizeof(query));
  41. format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
  42. strcat(query,src,sizeof(query));
  43. format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
  44. strcat(query,src,sizeof(query));
  45. format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
  46. strcat(query,src,sizeof(query));
  47. format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
  48. strcat(query,src,sizeof(query));
  49. format(src,sizeof(src),"morgan='%i',",PlayerInfo[playerid][pMorgan]);
  50. strcat(query,src,sizeof(query));
  51. format(src,sizeof(src),"morgantime='%i',",PlayerInfo[playerid][pMorganTime]);
  52. strcat(query,src,sizeof(query));
  53. format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
  54. strcat(query,src,sizeof(query));
  55. format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
  56. strcat(query,src,sizeof(query));
  57. format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
  58. strcat(query,src,sizeof(query));
  59. format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
  60. strcat(query,src,sizeof(query));
  61. format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
  62. strcat(query,src,sizeof(query));
  63. format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
  64. strcat(query,src,sizeof(query));
  65. format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
  66. strcat(query,src,sizeof(query));
  67. format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
  68. strcat(query,src,sizeof(query));
  69. format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
  70. strcat(query,src,sizeof(query));
  71. format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
  72. strcat(query,src,sizeof(query));
  73. format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
  74. strcat(query,src,sizeof(query));
  75. format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
  76. strcat(query,src,sizeof(query));
  77. format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
  78. strcat(query,src,sizeof(query));
  79. format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
  80. strcat(query,src,sizeof(query));
  81. format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
  82. strcat(query,src,sizeof(query));
  83. format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
  84. strcat(query,src,sizeof(query));
  85. format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
  86. strcat(query,src,sizeof(query));
  87. format(src,sizeof(src),"fstyle='%i',",PlayerInfo[playerid][pFightStyle]);
  88. strcat(query,src,sizeof(query));
  89. format(src,sizeof(src),"credits='%i',",PlayerInfo[playerid][pCredits]);
  90. strcat(query,src,sizeof(query));
  91. format(src,sizeof(src),"promocode='%i',",PlayerInfo[playerid][pPromoCode]);
  92. strcat(query,src,sizeof(query));
  93. format(src,sizeof(src),"skin1='%i',",PlayerInfo[playerid][pSkin1]);
  94. strcat(query,src,sizeof(query));
  95. format(src,sizeof(src),"skin2='%i',",PlayerInfo[playerid][pSkin2]);
  96. strcat(query,src,sizeof(query));
  97. format(src,sizeof(src),"skin3='%i',",PlayerInfo[playerid][pSkin3]);
  98. strcat(query,src,sizeof(query));
  99. format(src,sizeof(src),"spawnchange='%i',",PlayerInfo[playerid][pSpawnChange]);
  100. strcat(query,src,sizeof(query));
  101. format(src,sizeof(src),"sdpistol='%i',",PlayerInfo[playerid][pGunSkill][0]);
  102. strcat(query,src,sizeof(query));
  103. format(src,sizeof(src),"deserteagle='%i',",PlayerInfo[playerid][pGunSkill][1]);
  104. strcat(query,src,sizeof(query));
  105. format(src,sizeof(src),"shotgun='%i',",PlayerInfo[playerid][pGunSkill][2]);
  106. strcat(query,src,sizeof(query));
  107. format(src,sizeof(src),"mp5='%i',",PlayerInfo[playerid][pGunSkill][3]);
  108. strcat(query,src,sizeof(query));
  109. format(src,sizeof(src),"ak47='%i',",PlayerInfo[playerid][pGunSkill][4]);
  110. strcat(query,src,sizeof(query));
  111. format(src,sizeof(src),"m4='%i',",PlayerInfo[playerid][pGunSkill][5]);
  112. strcat(query,src,sizeof(query));
  113. format(src,sizeof(src),"rpr='%i',",PlayerInfo[playerid][pRPR]);
  114. strcat(query,src,sizeof(query));
  115. format(src,sizeof(src),"glasses='%i',",PlayerInfo[playerid][pGlasses]);
  116. strcat(query,src,sizeof(query));
  117. format(src,sizeof(src),"satiety='%i',",PlayerInfo[playerid][pSatiety]);
  118. strcat(query,src,sizeof(query));
  119. format(src,sizeof(src),"rprgive='%i',",PlayerInfo[playerid][pRPRGive]);
  120. strcat(query,src,sizeof(query));
  121. format(src,sizeof(src),"healths='%f',",PlayerInfo[playerid][pHealthS]);
  122. strcat(query,src,sizeof(query));
  123. format(src,sizeof(src),"sportexp='%i',",PlayerInfo[playerid][pSportEXP]);
  124. strcat(query,src,sizeof(query));
  125. format(src,sizeof(src),"online='%i',",PlayerInfo[playerid][pOnline]);
  126. strcat(query,src,sizeof(query));
  127. format(src,sizeof(src),"zakon='%i',",PlayerInfo[playerid][pZakon]);
  128. strcat(query,src,sizeof(query));
  129. format(src,sizeof(src),"bolezn='%i',",PlayerInfo[playerid][pBolezn]);
  130. strcat(query,src,sizeof(query));
  131. format(src,sizeof(src),"ipcheck='%i',",PlayerInfo[playerid][ProverkaIP]);
  132. strcat(query,src,sizeof(query));
  133. format(src,sizeof(src),"hospital='%i',",PlayerInfo[playerid][pHospital]);
  134. strcat(query,src,sizeof(query));
  135. format(src,sizeof(src),"watch='%i',",PlayerInfo[playerid][pWatch]);
  136. strcat(query,src,sizeof(query));
  137. format(src,sizeof(src),"ciggare='%i',",PlayerInfo[playerid][pCiggare]);
  138. strcat(query,src,sizeof(query));
  139. format(src,sizeof(src),"sprunk='%i',",PlayerInfo[playerid][pSprunk]);
  140. strcat(query,src,sizeof(query));
  141. format(src,sizeof(src),"mask='%i',",PlayerInfo[playerid][pMask]);
  142. strcat(query,src,sizeof(query));
  143. format(src,sizeof(src),"phonebalance='%i',",PlayerInfo[playerid][pPhoneBalance]);
  144. strcat(query,src,sizeof(query));
  145. format(src,sizeof(src),"truckskill='%i',",PlayerInfo[playerid][pTruckSkill]);
  146. strcat(query,src,sizeof(query));
  147. format(src,sizeof(src),"cModel='%i',",PlayerInfo[playerid][cModel]);
  148. strcat(query,src,sizeof(query));
  149. format(src,sizeof(src),"cX='%f',",PlayerInfo[playerid][cX]);
  150. strcat(query,src,sizeof(query));
  151. format(src,sizeof(src),"cY='%f',",PlayerInfo[playerid][cY]);
  152. strcat(query,src,sizeof(query));
  153. format(src,sizeof(src),"cZ='%f',",PlayerInfo[playerid][cZ]);
  154. strcat(query,src,sizeof(query));
  155. format(src,sizeof(src),"cFa='%f',",PlayerInfo[playerid][cFa]);
  156. strcat(query,src,sizeof(query));
  157. format(src,sizeof(src),"cFuel='%i',",PlayerInfo[playerid][cFuel]);
  158. strcat(query,src,sizeof(query));
  159. format(src,sizeof(src),"cNumber='%s',",PlayerInfo[playerid][cNumber]);
  160. strcat(query,src,sizeof(query));
  161. format(src,sizeof(src),"CReg='%i',",PlayerInfo[playerid][pCReg]);
  162. strcat(query,src,sizeof(query));
  163. format(src,sizeof(src),"cCarAr='%i',",PlayerInfo[playerid][cCarAr]);
  164. strcat(query,src,sizeof(query));
  165. format(src,sizeof(src),"cClass='%i',",PlayerInfo[playerid][cClass]);
  166. strcat(query,src,sizeof(query));
  167. format(src,sizeof(src),"cColor1='%i',",PlayerInfo[playerid][cColor][0]);
  168. strcat(query,src,sizeof(query));
  169. format(src,sizeof(src),"cColor2='%i',",PlayerInfo[playerid][cColor][1]);
  170. strcat(query,src,sizeof(query));
  171. format(src,sizeof(src),"cLock='%i',",PlayerInfo[playerid][cLock]);
  172. strcat(query,src,sizeof(query));
  173. format(src,sizeof(src),"cCost='%i',",PlayerInfo[playerid][cCost]);
  174. strcat(query,src,sizeof(query));
  175. format(src,sizeof(src),"cVehcom='%s',",PlayerInfo[playerid][cVehcom]);
  176. strcat(query,src,sizeof(query));
  177. format(src,sizeof(src),"cPaintjob='%i',",PlayerInfo[playerid][cPaintjob]);
  178. strcat(query,src,sizeof(query));
  179. format(src,sizeof(src),"vzlom='%i',",PlayerInfo[playerid][pVzlom]);
  180. strcat(query,src,sizeof(query));
  181. format(src,sizeof(src),"spawn='%i',",PlayerInfo[playerid][pSpawn]);
  182. strcat(query,src,sizeof(query));
  183. format(src,sizeof(src),"vb='%i',",PlayerInfo[playerid][pVb]);
  184. strcat(query,src,sizeof(query));
  185. format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
  186. PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
  187. format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
  188. strcat(query,src,sizeof(query));
  189. format(PlayerInfo[playerid][pLics],40,"%i, %i, %i, %i, %i",
  190. PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
  191. ,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
  192. format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLics]);
  193. strcat(query,src,sizeof(query));
  194. format(PlayerInfo[playerid][pWorkBook], 40, "%i, %i, %i, %i, %i, %i",
  195. PlayerInfo[playerid][pWB][0], PlayerInfo[playerid][pWB][1],PlayerInfo[playerid][pWB][2]
  196. ,PlayerInfo[playerid][pWB][3],PlayerInfo[playerid][pWB][4], PlayerInfo[playerid][pWB][5]);
  197. format(src,sizeof(src),"workbook='%s',",PlayerInfo[playerid][pWorkBook]);
  198. strcat(query,src,sizeof(query));
  199. if(GetPVarInt(playerid, "GunCheat") == 0)
  200. {
  201. for(new i = 0; i < 13; i++)
  202. {
  203. GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun][i], PlayerInfo[playerid][pAmmo][i]);
  204. }
  205. format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
  206. PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
  207. PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
  208. PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
  209. PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
  210. format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
  211. strcat(query,src,sizeof(query));
  212. format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
  213. PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
  214. PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
  215. PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
  216. PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
  217. format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
  218. }
  219. strcat(query,src,sizeof(query));
  220. format(src,sizeof(src),"skills='%d'",PlayerInfo[playerid][pGunSkill][6]);
  221. strcat(query,src,sizeof(query));
  222. new playername[32];
  223. GetPlayerName(playerid,playername,32);
  224. format(src,sizeof(src)," WHERE name='%s'",playername);
  225. strcat(query,src,sizeof(query));
  226. mysql_query(query);
  227. return true;
  228. }
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!