API tools faq
paste
Guest User

Saugojimas+Krovimas

a guest
Nov 4th, 2014
204
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.65 KB | None | 0 0
raw download clone embed print report
  1. //Saugojimas + krovimas
  2. stock zKrovimas(playerid)
  3. {
  4. new query[200], lastconnect[50], lastip[50];
  5. format(query, sizeof(query), "SELECT * FROM `vartotojai` WHERE `Vardas` = '%s'", zVardas(playerid));
  6. mysql_query(query);
  7. mysql_store_result();
  8. while(mysql_retrieve_row())
  9. {
  10. new
  11. Float:zPos[3],
  12. result[50]
  13. ;
  14. mysql_fetch_field_row(result, "xPos");
  15. zPos[0] = floatstr(result);
  16. mysql_fetch_field_row(result, "yPos");
  17. zPos[1] = floatstr(result);
  18. mysql_fetch_field_row(result, "zPos");
  19. zPos[2] = floatstr(result);
  20. _SetPlayerPos(playerid, zPos[0], zPos[1], zPos[2] + 0.1);
  21. mysql_fetch_field_row(result, "Pinigai");
  22. _SetPlayerMoney(playerid, strval(result));
  23. mysql_fetch_field_row(result, "Gaudomas");
  24. SetPlayerWantedLevel(playerid, strval(result));
  25. mysql_fetch_field_row(result, "Darbas");
  26. zInfo[playerid][Darbas] = strval(result);
  27. mysql_fetch_field_row(result, "Gauja");
  28. zInfo[playerid][Gauja] = strval(result);
  29. mysql_fetch_field_row(result, "DarboIspejimai");
  30. zInfo[playerid][DarboIspejimai] = strval(result);
  31. mysql_fetch_field_row(result, "Direktorius");
  32. zInfo[playerid][Direktorius] = strval(result);
  33. mysql_fetch_field_row(result, "GValdovas");
  34. zInfo[playerid][GValdovas] = strval(result);
  35. mysql_fetch_field_row(result, "DarboRangas");
  36. zInfo[playerid][DarboRangas] = strval(result);
  37. mysql_fetch_field_row(result, "GaujosRangas");
  38. zInfo[playerid][GaujosRangas] = strval(result);
  39. mysql_fetch_field_row(result, "Patirtis");
  40. SetPlayerScore(playerid, strval(result));
  41. mysql_fetch_field_row(result, "Lytis");
  42. zInfo[playerid][Lytis] = strval(result);
  43. mysql_fetch_field_row(result, "Gyvybes");
  44. _SetPlayerHealth(playerid, floatstr(result));
  45. mysql_fetch_field_row(result, "Sarvai");
  46. _SetPlayerArmour(playerid, floatstr(result));
  47. mysql_fetch_field_row(result, "Alkis");
  48. zInfo[playerid][Alkis] = floatstr(result);
  49. mysql_fetch_field_row(result, "Troskulys");
  50. zInfo[playerid][Troskulys] = floatstr(result);
  51. mysql_fetch_field_row(result, "Mute");
  52. zInfo[playerid][MuteLaikas] = strval(result);
  53. mysql_fetch_field_row(result, "Admin");
  54. zInfo[playerid][Admin] = strval(result);
  55. mysql_fetch_field_row(result, "AdminLaikas");
  56. zInfo[playerid][AdminLaikas] = strval(result);
  57. mysql_fetch_field_row(result, "VIP");
  58. zInfo[playerid][VIP] = strval(result);
  59. mysql_fetch_field_row(result, "VIPLaikas");
  60. zInfo[playerid][VIPLaikas] = strval(result);
  61. mysql_fetch_field_row(result, "Kreditai");
  62. zInfo[playerid][Kreditai] = strval(result);
  63. mysql_fetch_field_row(result, "JailLaikas");
  64. zInfo[playerid][JailLaikas] = strval(result);
  65. mysql_fetch_field_row(result, "GautosSMS");
  66. telInfo[playerid][GautosSMS] = strval(result);
  67. mysql_fetch_field_row(result, "IsiustosSMS");
  68. telInfo[playerid][IsiustosSMS] = strval(result);
  69. mysql_fetch_field_row(result, "Telefonas");
  70. telInfo[playerid][Telefonas] = strval(result);
  71. mysql_fetch_field_row(result, "Kortele");
  72. telInfo[playerid][Kortele] = strval(result);
  73. mysql_fetch_field_row(result, "TelSaskaita");
  74. telInfo[playerid][Saskaita] = strval(result);
  75. mysql_fetch_field_row(result, "TelPapildymas");
  76. telInfo[playerid][Papildymas] = strval(result);
  77. mysql_fetch_field_row(result, "TelBaterija");
  78. telInfo[playerid][Baterija] = strval(result);
  79. mysql_fetch_field_row(result, "PinigaiBanke");
  80. zInfo[playerid][PinigaiBanke] = strval(result);
  81. mysql_fetch_field_row(result, "BankoPin");
  82. zInfo[playerid][BankoPin] = strval(result);
  83. mysql_fetch_field_row(result, "Drabuziai");
  84. zInfo[playerid][Drabuziai] = strval(result);
  85. mysql_fetch_field_row(result, "Uniforma");
  86. zInfo[playerid][Uniforma] = strval(result);
  87. mysql_fetch_field_row(result, "Interieras");
  88. SetPlayerInterior(playerid, strval(result));
  89. mysql_fetch_field_row(result, "VirtualWorld");
  90. _SetPlayerVirtualWorld(playerid, strval(result));
  91. mysql_fetch_field_row(result, "NamoID");
  92. zInfo[playerid][NamoID] = strval(result);
  93. mysql_fetch_field_row(result, "Amfetaminas");
  94. zInfo[playerid][Amfetaminas] = strval(result);
  95. mysql_fetch_field_row(result, "Heroinas");
  96. zInfo[playerid][Heroinas] = strval(result);
  97. mysql_fetch_field_row(result, "ZiuriCar");
  98. ZiuriCar[playerid] = strval(result);
  99. mysql_fetch_field_row(result, "BoulingoTaskai");
  100. B_Taskai[playerid] = strval(result);
  101.  
  102. mysql_fetch_field_row(result, "AdminIspejimai");
  103. zInfo[playerid][aIspejimai] = strval(result);
  104. mysql_fetch_field_row(result, "VIPIspejimai");
  105. zInfo[playerid][vIspejimai] = strval(result);
  106.  
  107. mysql_fetch_field_row(result, "PaskutinisPrisijungimas");
  108. format(lastconnect, sizeof(lastconnect), "%s", result);
  109. mysql_fetch_field_row(result, "PaskutinisIP");
  110. format(lastip, sizeof(lastip), "%s", result);
  111.  
  112. mysql_fetch_field_row(result, "EPastas");
  113. format(zInfo[playerid][EPastas], 50, "%s", result);
  114.  
  115. mysql_fetch_field_row(result, "SiandienPrazaide");
  116. zInfo[playerid][SiandienPrazaide] = strval(result);
  117. mysql_fetch_field_row(result, "ServeryjePrazaide");
  118. zInfo[playerid][ServeryjePraleista] = strval(result);
  119.  
  120. mysql_fetch_field_row(result, "Savininkas");
  121. if(strval(result)) zInfo[playerid][Savininkas] = true;
  122. else zInfo[playerid][Savininkas] = false;
  123. mysql_fetch_field_row(result, "GunLic");
  124. if(strval(result)) zInfo[playerid][GunLic] = true;
  125. else zInfo[playerid][GunLic] = false;
  126. mysql_fetch_field_row(result, "Surakintas");
  127. if(strval(result)) zInfo[playerid][Surakintas] = true;
  128. else zInfo[playerid][Surakintas] = false;
  129. mysql_fetch_field_row(result, "GaliTureti3");
  130. if(strval(result)) zInfo[playerid][GaliTureti3] = true;
  131. else zInfo[playerid][GaliTureti3] = false;
  132. mysql_fetch_field_row(result, "Bakelis");
  133. if(strval(result)) zInfo[playerid][Bakelis] = true;
  134. else zInfo[playerid][Bakelis] = false;
  135. mysql_fetch_field_row(result, "Darbas");
  136. if(strval(result)) zInfo[playerid][Darbas] = true;
  137. else zInfo[playerid][Darbas] = false;
  138. mysql_fetch_field_row(result, "BankoSaskaita");
  139. if(strval(result)) zInfo[playerid][BankoSaskaita] = true;
  140. else zInfo[playerid][BankoSaskaita] = false;
  141. mysql_fetch_field_row(result, "DeviUniforma");
  142. if(strval(result)) zInfo[playerid][DeviUniforma] = true;
  143. else zInfo[playerid][DeviUniforma] = false;
  144. mysql_fetch_field_row(result, "DeviGUniforma");
  145. if(strval(result)) zInfo[playerid][DeviGUniforma] = true;
  146. else zInfo[playerid][DeviGUniforma] = false;
  147. mysql_fetch_field_row(result, "TuriGPS");
  148. if(strval(result)) zInfo[playerid][HaveGPS] = true;
  149. else zInfo[playerid][HaveGPS] = false;
  150. mysql_fetch_field_row(result, "TuriMP3");
  151. if(strval(result)) zInfo[playerid][HaveMP3] = true;
  152. else zInfo[playerid][HaveMP3] = false;
  153. mysql_fetch_field_row(result, "TelStatusas");
  154. if(strval(result)) telInfo[playerid][Statusas] = true;
  155. else zInfo[playerid][Statusas] = false;
  156. mysql_fetch_field_row(result, "Teorija");
  157. if(strval(result)) zInfo[playerid][Teorija] = true;
  158. else zInfo[playerid][Teorija] = false;
  159. mysql_fetch_field_row(result, "TeisesA");
  160. if(strval(result)) zInfo[playerid][TeisesA] = true;
  161. else zInfo[playerid][TeisesA] = false;
  162. mysql_fetch_field_row(result, "TeisesB");
  163. if(strval(result)) zInfo[playerid][TeisesB] = true;
  164. else zInfo[playerid][TeisesB] = false;
  165. mysql_fetch_field_row(result, "TeisesC");
  166. if(strval(result)) zInfo[playerid][TeisesC] = true;
  167. else zInfo[playerid][TeisesC] = false;
  168. new
  169. ginklas,
  170. ammo
  171. ;
  172. mysql_fetch_field_row(result, "Gun0"); ginklas = strval(result);
  173. mysql_fetch_field_row(result, "Ammo0"); ammo = strval(result);
  174. GivePlayerWeapon(playerid, ginklas, ammo);
  175. mysql_fetch_field_row(result, "Gun1"); ginklas = strval(result);
  176. mysql_fetch_field_row(result, "Ammo1"); ammo = strval(result);
  177. GivePlayerWeapon(playerid, ginklas, ammo);
  178. mysql_fetch_field_row(result, "Gun2"); ginklas = strval(result);
  179. mysql_fetch_field_row(result, "Ammo2"); ammo = strval(result);
  180. GivePlayerWeapon(playerid, ginklas, ammo);
  181. mysql_fetch_field_row(result, "Gun3"); ginklas = strval(result);
  182. mysql_fetch_field_row(result, "Ammo3"); ammo = strval(result);
  183. GivePlayerWeapon(playerid, ginklas, ammo);
  184. mysql_fetch_field_row(result, "Gun4"); ginklas = strval(result);
  185. mysql_fetch_field_row(result, "Ammo4"); ammo = strval(result);
  186. GivePlayerWeapon(playerid, ginklas, ammo);
  187. mysql_fetch_field_row(result, "Gun5"); ginklas = strval(result);
  188. mysql_fetch_field_row(result, "Ammo5"); ammo = strval(result);
  189. GivePlayerWeapon(playerid, ginklas, ammo);
  190. mysql_fetch_field_row(result, "Gun6"); ginklas = strval(result);
  191. mysql_fetch_field_row(result, "Ammo6"); ammo = strval(result);
  192. GivePlayerWeapon(playerid, ginklas, ammo);
  193. mysql_fetch_field_row(result, "Gun7"); ginklas = strval(result);
  194. mysql_fetch_field_row(result, "Ammo7"); ammo = strval(result);
  195. GivePlayerWeapon(playerid, ginklas, ammo);
  196. mysql_fetch_field_row(result, "Gun8"); ginklas = strval(result);
  197. mysql_fetch_field_row(result, "Ammo8"); ammo = strval(result);
  198. GivePlayerWeapon(playerid, ginklas, ammo);
  199. mysql_fetch_field_row(result, "Gun9"); ginklas = strval(result);
  200. mysql_fetch_field_row(result, "Ammo9"); ammo = strval(result);
  201. GivePlayerWeapon(playerid, ginklas, ammo);
  202. mysql_fetch_field_row(result, "Gun10"); ginklas = strval(result);
  203. mysql_fetch_field_row(result, "Ammo10"); ammo = strval(result);
  204. GivePlayerWeapon(playerid, ginklas, ammo);
  205. mysql_fetch_field_row(result, "Gun11"); ginklas = strval(result);
  206. mysql_fetch_field_row(result, "Ammo11"); ammo = strval(result);
  207. GivePlayerWeapon(playerid, ginklas, ammo);
  208. }
  209. mysql_free_result();
  210. new pData[3], msgs[50];
  211. getdate(pData[0], pData[1], pData[2]);
  212. format(msgs, sizeof(msgs), "%02i.%02i.%02i", pData[0], pData[1], pData[2]);
  213. if(strcmp(lastconnect, msgs, true))
  214. {
  215. zInfo[playerid][SiandienPrazaide] = 0;
  216. }
  217. format(query, sizeof(query), "SELECT * FROM `kuprines` WHERE `Vardas` = '%s'", zVardas(playerid));
  218. mysql_query(query);
  219. mysql_store_result();
  220. while(mysql_retrieve_row())
  221. {
  222. new result[50];
  223. for(new i = 0; i < MAX_ITEMS; i++)
  224. {
  225. format(query, sizeof(query), "Daiktas%i", i);
  226. mysql_fetch_field_row(result, query); Inventorius[playerid][i][DaiktoID] = strval(result);
  227. format(query, sizeof(query), "Kiekis%i", i);
  228. mysql_fetch_field_row(result, query); Inventorius[playerid][i][DaiktoKiekis] = strval(result);
  229. }
  230. }
  231. mysql_free_result();
  232. format(query, sizeof(query), "SELECT * FROM `uzduotys` WHERE `Vardas` = '%s'", zVardas(playerid));
  233. mysql_query(query);
  234. mysql_store_result();
  235. while(mysql_retrieve_row())
  236. {
  237. new result[50], msg[50];
  238. for(new i = 0; i < MAX_MISSIONS; i++)
  239. {
  240. format(msg, 50, "Uzduotis%i", i);
  241. mysql_fetch_field_row(result, msg);
  242. if(strval(result)) zInfo[playerid][Uzduotis][i] = true;
  243. else zInfo[playerid][Uzduotis][i] = false;
  244. }
  245. }
  246. mysql_free_result();
  247. CarShopCar[playerid] = INVALID_VEHICLE_ID;
  248. AtnaujinamePinigus(playerid);
  249. if(ZiuriCar[playerid] > 0)
  250. {
  251. _SetPlayerVirtualWorld(playerid, 0);
  252. }
  253. if(!zInfo[playerid][DeviUniforma])
  254. {
  255. _SetPlayerSkin(playerid, zInfo[playerid][Drabuziai]);
  256. }
  257. else
  258. {
  259. _SetPlayerUniform(playerid, zInfo[playerid][Uniforma]);
  260. }
  261. if(zInfo[playerid][MuteLaikas] > 0)
  262. {
  263. MuteTimer[playerid] = SetTimerEx("UnmutePlayer", 1000, true, "i", playerid);
  264. }
  265. if(zInfo[playerid][JailLaikas] > 0)
  266. {
  267. JailTimer[playerid] = SetTimerEx("JailPlayer", 1000, true, "i", playerid);
  268. new const randPos = random(sizeof(JailSpawn));
  269. _SetPlayerPos(playerid, JailSpawn[randPos][0], JailSpawn[randPos][1], JailSpawn[randPos][2]);
  270. }
  271. if(zInfo[playerid][Surakintas])
  272. {
  273. zInfo[playerid][JailLaikas] = 1200;
  274. JailTimer[playerid] = SetTimerEx("JailPlayer", 1000, true, "i", playerid);
  275. new const randPos = random(sizeof(JailSpawn));
  276. _SetPlayerPos(playerid, JailSpawn[randPos][0], JailSpawn[randPos][1], JailSpawn[randPos][2]);
  277. zInfo[playerid][Surakintas] = false;
  278. }
  279. zInfo[playerid][Statusas] = 3;
  280. if(zInfo[playerid][Darbas] == 1) SetPlayerColor(playerid, 0x009BFF00);
  281. else if(zInfo[playerid][Darbas] == 2) SetPlayerColor(playerid, 0xFF000000);
  282. else if(zInfo[playerid][Darbas] == 3) SetPlayerColor(playerid, 0xFFFF0000);
  283. else if(zInfo[playerid][Darbas] == 4) SetPlayerColor(playerid, 0xFFFF8000);
  284. else if(zInfo[playerid][Darbas] == 5) SetPlayerColor(playerid, 0xDC00FF00);
  285. new msg[256];
  286. format(msg, sizeof(msg), "%s{FFFFFF} [ {FF0000}ID: %i{FFFFFF} ] {8C8C8C}prisijungë", zVardas(playerid), playerid);
  287. foreach(Player, i)
  288. if(zInfo[i][Admin] > 0 || zInfo[playerid][VIP] == 1)
  289. if(i != playerid)
  290. SendClientMessage(i, 0xFFA000FF, msg);
  291. if(zInfo[playerid][Admin] > 0)
  292. {
  293. format(msg, sizeof(msg), "{FFAA00}Administratorius {FF3200}%s {FF7800}prisijungë", zVardas(playerid));
  294. MSGForAll(msg);
  295. }
  296. return (true);
  297. }
  298. stock zSaugojimas(playerid)
  299. {
  300. new
  301. query[500],
  302. Float:zPos[3],
  303. weps[2][12],
  304. msg[128],
  305. pData[3]
  306. ;
  307. getdate(pData[0], pData[1], pData[2]);
  308. format(msg, sizeof(msg), "%02i.%02i.%02i", pData[0], pData[1], pData[2]);
  309. for (new i = 0; i < 12; i ++)
  310. GetPlayerWeaponData(playerid, i, weps[0][i], weps[1][i]);
  311. GetPlayerPos(playerid, zPos[0], zPos[1], zPos[2]);
  312. format(query, sizeof(query), "UPDATE `vartotojai` SET `Pinigai`='%i', `Patirtis`='%i', `Lytis`='%i', `xPos`='%f', `yPos`='%f', `zPos`='%f' WHERE ( `Vardas` = '%s' )", zInfo[playerid][Pinigai], GetPlayerScore(playerid), zInfo[playerid][Lytis], zPos[0], zPos[1], zPos[2], zVardas(playerid));
  313. mysql_query(query);
  314. format(query, sizeof(query), "UPDATE `vartotojai` SET `GautosSMS`='%i', `IsiustosSMS`='%i', `Telefonas`='%i', `Kortele`='%i', `TelSaskaita`='%i', `TelPapildymas`='%i' WHERE ( `Vardas` = '%s' )", telInfo[playerid][GautosSMS], telInfo[playerid][IsiustosSMS], telInfo[playerid][Telefonas], telInfo[playerid][Kortele], telInfo[playerid][Saskaita], telInfo[playerid][Papildymas], zVardas(playerid));
  315. mysql_query(query);
  316. format(query, sizeof(query), "UPDATE `vartotojai` SET `TelBaterija`='%i', `PinigaiBanke`='%i', `BankoPin`='%i', `Drabuziai`='%i', `Uniforma`='%i', `Interieras`='%i' WHERE ( `Vardas` = '%s' )", telInfo[playerid][Baterija], zInfo[playerid][PinigaiBanke], zInfo[playerid][BankoPin], zInfo[playerid][Drabuziai], zInfo[playerid][Uniforma], GetPlayerInterior(playerid), zVardas(playerid));
  317. mysql_query(query);
  318. format(query, sizeof(query), "UPDATE `vartotojai` SET `VirtualWorld`='%i', `NamoID`='%i', `ZiuriCar`='%i', `BankoSaskaita`='%i', `DeviUniforma`='%i', `DeviGUniforma`='%i', `TuriGPS`='%i' WHERE ( `Vardas` = '%s' )", GetPlayerVirtualWorld(playerid), zInfo[playerid][NamoID], ZiuriCar[playerid], zInfo[playerid][BankoSaskaita], zInfo[playerid][DeviUniforma], zInfo[playerid][DeviGUniforma], zInfo[playerid][HaveGPS], zVardas(playerid));
  319. mysql_query(query);
  320. format(query, sizeof(query), "UPDATE `vartotojai` SET `TuriMP3`='%i', `TelStatusas`='%i', `Teorija`='%i', `TeisesA`='%i', `TeisesB`='%i', `TeisesC`='%i' WHERE ( `Vardas` = '%s' )", zInfo[playerid][HaveMP3], telInfo[playerid][Statusas], zInfo[playerid][Teorija], zInfo[playerid][TeisesA], zInfo[playerid][TeisesB], zInfo[playerid][TeisesC], zVardas(playerid));
  321. mysql_query(query);
  322. format(query, sizeof(query), "UPDATE `vartotojai` SET `Gun0`='%i', `Gun1`='%i', `Gun2`='%i', `Gun3`='%i', `Gun4`='%i', `Gun5`='%i', `Gun6`='%i', `Gun7`='%i' WHERE ( `Vardas` = '%s' )", weps[0][0], weps[0][1], weps[0][2], weps[0][3], weps[0][4], weps[0][5], weps[0][6], weps[0][7], zVardas(playerid));
  323. mysql_query(query);
  324. format(query, sizeof(query), "UPDATE `vartotojai` SET `Gun8`='%i', `Gun9`='%i', `Gun10`='%i', `Gun11`='%i' WHERE ( `Vardas` = '%s' )", weps[0][8], weps[0][9], weps[0][10], weps[0][11], zVardas(playerid));
  325. mysql_query(query);
  326. format(query, sizeof(query), "UPDATE `vartotojai` SET `Ammo0`='%i', `Ammo1`='%i', `Ammo2`='%i', `Ammo3`='%i', `Ammo4`='%i', `Ammo5`='%i', `Ammo6`='%i', `Ammo7`='%i' WHERE ( `Vardas` = '%s' )",weps[1][0], weps[1][1], weps[1][2], weps[1][3], weps[1][4], weps[1][5], weps[1][6], weps[1][7], zVardas(playerid));
  327. mysql_query(query);
  328. format(query, sizeof(query), "UPDATE `vartotojai` SET `Ammo8`='%i', `Ammo9`='%i', `Ammo10`='%i', `Ammo11`='%i' WHERE ( `Vardas` = '%s' )", weps[1][8], weps[1][9], weps[1][10], weps[1][11], zVardas(playerid));
  329. mysql_query(query);
  330. format(query, sizeof(query), "UPDATE `vartotojai` SET `Darbas`='%i', `Gauja`='%i', `Direktorius`='%i', `GValdovas`='%i', `DarboRangas`='%i', `GaujosRangas`='%i', `Surakintas`='%i', `DarboIspejimai`='%i' WHERE ( `Vardas` = '%s' )", zInfo[playerid][Darbas], zInfo[playerid][Gauja], zInfo[playerid][Direktorius], zInfo[playerid][GValdovas], zInfo[playerid][DarboRangas], zInfo[playerid][GaujosRangas], zInfo[playerid][Surakintas], zInfo[playerid][DarboIspejimai], zVardas(playerid));
  331. mysql_query(query);
  332. format(query, sizeof(query), "UPDATE `vartotojai` SET `Gaudomas`='%i', `Bakelis`='%i', `Admin`='%i', `AdminLaikas`='%i', `VIP`='%i', `VIPLaikas`='%i', `Kreditai`='%i' WHERE ( `Vardas` = '%s' )", GetPlayerWantedLevel(playerid), zInfo[playerid][Bakelis], zInfo[playerid][Admin], zInfo[playerid][AdminLaikas], zInfo[playerid][VIP], zInfo[playerid][VIPLaikas], zInfo[playerid][Kreditai], zVardas(playerid));
  333. mysql_query(query);
  334. format(query, sizeof(query), "UPDATE `vartotojai` SET `GaliTureti3`='%i', `Amfetaminas`='%i', `Heroinas`='%i', `GunLic`='%i', `Gyvybes`='%f', `Sarvai`='%f' WHERE ( `Vardas` = '%s' )", zInfo[playerid][GaliTureti3], zInfo[playerid][Amfetaminas], zInfo[playerid][Heroinas], zInfo[playerid][GunLic], ACHealth[playerid], ACArmour[playerid], zVardas(playerid));
  335. mysql_query(query);
  336. format(query, sizeof(query), "UPDATE `vartotojai` SET `Alkis`='%.1f', `Troskulys`='%.1f', `JailLaikas`='%i', `Savininkas`='%i' WHERE ( `Vardas` = '%s' )", zInfo[playerid][Alkis], zInfo[playerid][Troskulys], zInfo[playerid][JailLaikas], zInfo[playerid][Savininkas], zVardas(playerid));
  337. mysql_query(query);
  338. format(query, sizeof(query), "UPDATE `vartotojai` SET `Mute`='%i', `PaskutinisIP`='%s', `PaskutinisPrisijungimas`='%s', `SiandienPrazaide`='%i', `ServeryjePrazaide`='%i' WHERE ( `Vardas` = '%s' )", zInfo[playerid][MuteLaikas], zInfo[playerid][IPAdress], msg, zInfo[playerid][SiandienPrazaide], zInfo[playerid][ServeryjePraleista], zVardas(playerid));
  339. mysql_query(query);
  340. format(query, sizeof(query), "UPDATE `vartotojai` SET `EPastas`='%s', `BoulingoTaskai`='%s', `AdminIspejimai`='%i', `VIPIspejimai`='%i' WHERE ( `Vardas` = '%s' )", zInfo[playerid][EPastas], B_Taskai[playerid], zInfo[playerid][aIspejimai], zInfo[playerid][vIspejimai], zVardas(playerid));
  341. mysql_query(query);
  342.  
  343. format(query, sizeof(query), "SELECT * FROM `kuprines` WHERE `Vardas` = '%s'", zVardas(playerid));
  344. mysql_query(query);
  345. mysql_store_result();
  346. if(!mysql_retrieve_row())
  347. {
  348. format(query, sizeof(query), "INSERT INTO `kuprines` (Vardas) VALUES ('%s')", zVardas(playerid));
  349. mysql_query(query);
  350. }
  351. mysql_free_result();
  352. format(query, sizeof(query), "SELECT * FROM `uzduotys` WHERE `Vardas` = '%s'", zVardas(playerid));
  353. mysql_query(query);
  354. mysql_store_result();
  355. if(!mysql_num_rows())
  356. {
  357. format(query, sizeof(query), "INSERT INTO `uzduotys` (Vardas) VALUES ('%s')", zVardas(playerid));
  358. mysql_query(query);
  359. }
  360. mysql_free_result();
  361. for(new i = 0; i < MAX_ITEMS; i++)
  362. {
  363. format(query, sizeof(query), "UPDATE `kuprines` SET `Daiktas%i`='%i' WHERE ( `Vardas` = '%s' )", i, Inventorius[playerid][i][DaiktoID], zVardas(playerid));
  364. mysql_query(query);
  365. format(query, sizeof(query), "UPDATE `kuprines` SET `Kiekis%i`='%i' WHERE ( `Vardas` = '%s' )", i, Inventorius[playerid][i][DaiktoKiekis], zVardas(playerid));
  366. mysql_query(query);
  367. }
  368. for(new i = 0; i < MAX_MISSIONS; i++)
  369. {
  370. format(query, sizeof(query), "UPDATE `uzduotys` SET `Uzduotis%i`='%i' WHERE ( `Vardas` = '%s' )", i, zInfo[playerid][Uzduotis][i], zVardas(playerid));
  371. mysql_query(query);
  372. }
  373. }
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!