API tools faq
paste
Guest User

debug problem

a guest
Oct 16th, 2013
491
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 56.92 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3. pawn]public OnQueryFinish( query[], resultid, extraid, connectionHandle )
  4. {
  5.  
  6. mysql_store_result();
  7. new playerid = resultid;
  8. new rows = 0;
  9. new type = extraid;
  10.  
  11. /************/
  12.  
  13. if(type == QUERY_LOGIN_USER)
  14. {
  15. rows = mysql_num_rows();
  16. if(rows)
  17. {
  18. SendClientMessageA(playerid,COLOR_LIGHTRED,"Bine ai venit pe Modern Roleplay.");
  19. ShowPlayerDialog(playerid,1,DIALOG_STYLE_PASSWORD,"Logare","Introdu Parola:","Logare","Iesi");
  20. registered[playerid] = 1;
  21.  
  22. }
  23. else
  24. {
  25.  
  26. new str[1024];
  27. format(str,sizeof(str),"Salut! Bine ai venit pe Modern Roleplay! Orasul in care are loc actiunea este Red County.\n\nUrmatorul tutorial iti va da cateva informatii despre server!\nFolosim o versiune avansata de UCP dupa creearea contului \neste necesar sa-ti editezi informatiile din UCP.\n\nUrmatoarele informatii sunt necesare , de aceea te rog sa le citesti cu atentie.\n\n\n\nClick pe <Inainte> pentru a continua!");
  28. ShowPlayerDialog(playerid,DIALOG_REG1,DIALOG_STYLE_MSGBOX,"Bine ai venit!",str,"Inainte >>","");
  29. registered[playerid] = 0;
  30.  
  31. }
  32. SetPlayerScreenSaver(playerid);
  33. player_thread_inuse[playerid] = false;
  34.  
  35. }
  36. else if(type == QUERY_LOGIN_SEND)
  37. {
  38.  
  39. rows = mysql_num_rows();
  40. if(rows)
  41. {
  42.  
  43. mysql_retrieve_row();
  44. new secure_check[128];
  45. mysql_fetch_field_row(secure_check,"secure_ip");
  46. if(strlen(secure_check)) { //Secure IP enabled
  47. new ip[128];
  48. GetPlayerIp(playerid,ip,sizeof(ip));
  49. if(!(strcmp(ip,secure_check,true) == 0)) {
  50. ShowPlayerDialog(playerid,999,DIALOG_STYLE_MSGBOX,"Connection Rejected","The account you are trying to login with is protected by Modern Roleplays Secure IP system\n You cannot access this account without first authorising this IP address.\n\n To authorize this IP address please access your settings at: http://modern-rp.ro/site/","Ok","");
  51. new clean_ip[128];
  52. mysql_real_escape_string(ip,clean_ip);
  53. new secure_query[256];
  54. new secure_user_id[32];
  55. mysql_fetch_field_row(secure_user_id,"id");
  56. format(secure_query,sizeof(secure_query),"INSERT INTO rp_secure_ip_logs (user_id,ip) VALUES ('%s','%s')",secure_user_id,clean_ip);
  57. mysql_query(secure_query,player_threads[playerid]);
  58. Kick(playerid);
  59. }
  60. }
  61. screen_saver[playerid] = 0;
  62. if(Audio_IsClientConnected(playerid) && intro_music[playerid] > -1) { Audio_Stop(playerid,intro_music[playerid]); intro_music[playerid] = -1; }
  63. if(screen_saver_timer[playerid] > -1)
  64. {
  65.  
  66. KillTimer(screen_saver_timer[playerid]);
  67.  
  68. }
  69. SendClientMessage(playerid,COLOR_GREEN,"Te-ai logat ! Bine ai venit.");
  70. SendClientMessage(playerid,COLOR_WHITE,"Bine ai venit pe Modern Roleplay , daca ai vreo nelamurire foloseste /assistme");
  71. SendClientMessage(playerid,COLOR_WHITE,"Pentru ati schimba skinul,administrare cont poti intra pe UCP: http://modern-rp.ro/site/");
  72. logged[playerid] = true;
  73. player_thread_inuse[playerid] = false;
  74. LoadStats(playerid);
  75. SetSpawnInfo(playerid,0,177,414.1235,-17.7988,991.8047,90.0,0,0,0,0,0,0);
  76. SendConnectMessage(playerid);
  77. return 1;
  78.  
  79. }
  80. else
  81. {
  82.  
  83. SendClientMessageA(playerid,COLOR_RED,"Login Invalid.");
  84. ShowPlayerDialog(playerid,1,DIALOG_STYLE_PASSWORD,"Login","Introdu Parola:","Logare","Iesi");
  85. logged[playerid] = false;
  86. player_thread_inuse[playerid] = false;
  87. return 1;
  88.  
  89. }
  90.  
  91. }
  92. else if(type == QUERY_LOGIN_STATS)
  93. {
  94.  
  95. new str[256]; new data[17][256];
  96. mysql_fetch_row_format(str);
  97. explode(data,str,"|");
  98. AccountInfo[playerid][aID] = strval(data[0]);
  99. format(AccountInfo[playerid][aName],MAX_PLAYER_NAME,"%s",data[1]);
  100. AccountInfo[playerid][aMaxChars] = strval(data[3]);
  101. AccountInfo[playerid][aAdmin] = strval(data[4]);
  102. AccountInfo[playerid][aJailTime] = strval(data[5]);
  103. AccountInfo[playerid][aTutorial] = strval(data[7]);
  104. AccountInfo[playerid][aAssistant] = strval(data[8]);
  105. AccountInfo[playerid][aBikePerm] = strval(data[14]);
  106. player_thread_inuse[playerid] = QUERY_LOGIN_CHARS;
  107. format(str,sizeof(str),"SELECT * FROM rp_characters WHERE rp_characters.owner = '%d' ORDER BY id DESC LIMIT %d",AccountInfo[playerid][aID],AccountInfo[playerid][aMaxChars]);
  108. mysql_query(str,player_threads[playerid],QUERY_LOGIN_CHARS);
  109.  
  110. }
  111. else if(type == QUERY_LOGIN_CHARS)
  112. {
  113.  
  114. new ii = 0;
  115. new bb[256];
  116. while(mysql_retrieve_row())
  117. {
  118.  
  119. mysql_fetch_field_row(bb,"id");
  120. CharacterInfo[playerid][ii][cID] = strval(bb);
  121. mysql_fetch_field_row(bb,"name");
  122. format(CharacterInfo[playerid][ii][cName],MAX_PLAYER_NAME,"%s",bb);
  123. mysql_fetch_field_row(bb,"skin");
  124. CharacterInfo[playerid][ii][cSkin] = strval(bb);
  125. mysql_fetch_field_row(bb,"spawn_x");
  126. CharacterInfo[playerid][ii][cSpawnX] = floatstr(bb);
  127. mysql_fetch_field_row(bb,"spawn_y");
  128. CharacterInfo[playerid][ii][cSpawnY] = floatstr(bb);
  129. mysql_fetch_field_row(bb,"spawn_z");
  130. CharacterInfo[playerid][ii][cSpawnZ] = floatstr(bb);
  131. mysql_fetch_field_row(bb,"money");
  132. CharacterInfo[playerid][ii][cMoney] = strval(bb);
  133. mysql_fetch_field_row(bb,"spawn_r");
  134. CharacterInfo[playerid][ii][cSpawnR] = floatstr(bb);
  135. mysql_fetch_field_row(bb,"spawn_i");
  136. CharacterInfo[playerid][ii][cSpawnI] = strval(bb);
  137. mysql_fetch_field_row(bb,"renting");
  138. CharacterInfo[playerid][ii][cRenting] = strval(bb);
  139. mysql_fetch_field_row(bb,"faction");
  140. CharacterInfo[playerid][ii][cFaction] = strval(bb);
  141. mysql_fetch_field_row(bb,"phone_number");
  142. CharacterInfo[playerid][ii][cPhone] = strval(bb);
  143. mysql_fetch_field_row(bb,"weapons");
  144. format(CharacterInfo[playerid][ii][cWeapons],256,"%s",bb);
  145. mysql_fetch_field_row(bb,"bank");
  146. CharacterInfo[playerid][ii][cBank] = strval(bb);
  147. mysql_fetch_field_row(bb,"payday");
  148. CharacterInfo[playerid][ii][cPayday] = strval(bb);
  149. mysql_fetch_field_row(bb,"faction_perm");
  150. CharacterInfo[playerid][ii][cFactionPermissions] = strval(bb);
  151. mysql_fetch_field_row(bb,"rank_name");
  152. format(CharacterInfo[playerid][ii][cRankName],64,"%s",bb);
  153. mysql_fetch_field_row(bb,"jail_time");
  154. CharacterInfo[playerid][ii][cJailTime] = strval(bb);
  155. mysql_fetch_field_row(bb,"car_lic");
  156. CharacterInfo[playerid][ii][cCarLic] = strval(bb);
  157. mysql_fetch_field_row(bb,"wep_lic");
  158. CharacterInfo[playerid][ii][cWepLic] = strval(bb);
  159. mysql_fetch_field_row(bb,"pay_time");
  160. CharacterInfo[playerid][ii][cPayTime] = strval(bb);
  161. mysql_fetch_field_row(bb,"level");
  162. CharacterInfo[playerid][ii][cLevel] = strval(bb);
  163. mysql_fetch_field_row(bb,"exp");
  164. CharacterInfo[playerid][ii][cExp] = strval(bb);
  165. mysql_fetch_field_row(bb,"spawn_world");
  166. CharacterInfo[playerid][ii][cSpawnWorld] = strval(bb);
  167. mysql_fetch_field_row(bb,"radio");
  168. CharacterInfo[playerid][ii][cRadio] = strval(bb);
  169. mysql_fetch_field_row(bb,"rc");
  170. CharacterInfo[playerid][ii][cRadioChannel] = strval(bb);
  171. mysql_fetch_field_row(bb,"radio_auth");
  172. format(CharacterInfo[playerid][ii][cRadioAuth],16,"%s",bb);
  173. if(!strlen(CharacterInfo[playerid][ii][cRadioAuth])) { format(CharacterInfo[playerid][ii][cRadioAuth],16,"none"); }
  174. mysql_fetch_field_row(bb,"job");
  175. CharacterInfo[playerid][ii][cJob] = strval(bb);
  176. mysql_fetch_field_row(bb,"jcool");
  177. CharacterInfo[playerid][ii][cJobCooldown] = strval(bb);
  178. mysql_fetch_field_row(bb,"addict");
  179. CharacterInfo[playerid][ii][cAddiction] = strval(bb);
  180. mysql_fetch_field_row(bb,"alvl");
  181. CharacterInfo[playerid][ii][cAddictionLevel] = strval(bb);
  182. mysql_fetch_field_row(bb,"savings");
  183. CharacterInfo[playerid][ii][cSavings] = strval(bb);
  184. mysql_fetch_field_row(bb,"fly_lic");
  185. CharacterInfo[playerid][ii][cFlyLic] = strval(bb);
  186. mysql_fetch_field_row(bb,"duty_skin");
  187. CharacterInfo[playerid][ii][cDutySkin] = strval(bb);
  188. mysql_fetch_field_row(bb,"health");
  189. CharacterInfo[playerid][ii][cHealth] = floatstr(bb);
  190. mysql_fetch_field_row(bb,"armor");
  191. CharacterInfo[playerid][ii][cArmor] = floatstr(bb);
  192. if(CharacterInfo[playerid][ii][cHealth] < 10.0) { CharacterInfo[playerid][ii][cHealth] = 10.0; }
  193. mysql_fetch_field_row(bb,"employed");
  194. CharacterInfo[playerid][ii][cEmployed] = strval(bb);
  195. mysql_fetch_field_row(bb,"hotel");
  196. CharacterInfo[playerid][ii][cHotel] = strval(bb);
  197. mysql_fetch_field_row(bb,"lic_warns");
  198. CharacterInfo[playerid][ii][cCarLicWarnings] = strval(bb);
  199. mysql_fetch_field_row(bb,"dob");
  200. format(CharacterInfo[playerid][ii][cDob],32,"%s",bb);
  201. mysql_fetch_field_row(bb,"duplicate");
  202. CharacterInfo[playerid][ii][cDuplicate] = strval(bb);
  203. mysql_fetch_field_row(bb,"badge");
  204. CharacterInfo[playerid][ii][cBadge] = strval(bb);
  205. mysql_fetch_field_row(bb,"ccool");
  206. CharacterInfo[playerid][ii][cChopCooldown] = strval(bb);
  207. mysql_fetch_field_row(bb,"deaths");
  208. CharacterInfo[playerid][ii][cDeaths] = strval(bb);
  209. mysql_fetch_field_row(bb,"hins");
  210. CharacterInfo[playerid][ii][cHealthInsurance] = strval(bb);
  211. mysql_fetch_field_row(bb,"fstyle");
  212. CharacterInfo[playerid][ii][cFstyle] = strval(bb);
  213. mysql_fetch_field_row(bb,"comp");
  214. CharacterInfo[playerid][ii][cCompany] = strval(bb);
  215. mysql_fetch_field_row(bb,"comp_perms");
  216. CharacterInfo[playerid][ii][cCompanyPerms] = strval(bb);
  217. mysql_fetch_field_row(bb,"comp_rank");
  218. format(CharacterInfo[playerid][ii][cCompanyRank],32,"%s",bb);
  219. mysql_fetch_field_row(bb,"acc");
  220. format(CharacterInfo[playerid][ii][cAccent],16,"%s",bb);
  221. mysql_fetch_field_row(bb,"lang");
  222. CharacterInfo[playerid][ii][cLanguage] = strval(bb);
  223. mysql_fetch_field_row(bb,"skill");
  224. CharacterInfo[playerid][ii][cSkill] = strval(bb);
  225. mysql_fetch_field_row(bb,"skill_lvl");
  226. CharacterInfo[playerid][ii][cSkillLevel] = strval(bb);
  227. mysql_fetch_field_row(bb,"pmodel");
  228. CharacterInfo[playerid][ii][cPhoneModel] = strval(bb);
  229. mysql_fetch_field_row(bb,"bail");
  230. CharacterInfo[playerid][ii][cBail] = strval(bb);
  231. ii ++;
  232.  
  233. }
  234. player_thread_inuse[playerid] = false;
  235. BanCheck(playerid);
  236. SpawnPlayer(playerid);
  237.  
  238. }
  239. else if(type == QUERY_LOGIN_NOTES)
  240. {
  241.  
  242. new i = 0;
  243. new b[256];
  244. while(mysql_retrieve_row())
  245. {
  246.  
  247. mysql_fetch_field_row(b,"id");
  248. NoteInfo[playerid][i][nID] = strval(b);
  249. mysql_fetch_field_row(b,"text");
  250. format(NoteInfo[playerid][i][nText],256,"%s",b);
  251. NoteInfo[playerid][i][nActive] = 1;
  252. i ++;
  253.  
  254. }
  255. for(new w=0; w<100; w++)
  256. {
  257. SendClientMessage(playerid,COLOR_WHITE, " ");
  258. }
  259. format(b,sizeof(b),"* Ai la tine %d nota(e).",i);
  260. SendClientMessage(playerid,COLOR_YELLOW2,b);
  261.  
  262. }
  263. else if(type == QUERY_LOAD_VEHICLES)
  264. {
  265.  
  266. new i = 0;
  267. new b[256];
  268. while(mysql_retrieve_row())
  269. {
  270.  
  271. mysql_fetch_field_row(b,"id");
  272. VehicleInfo[i][vID] = strval(b);
  273. mysql_fetch_field_row(b,"model");
  274. VehicleInfo[i][vModel] = strval(b);
  275. mysql_fetch_field_row(b,"spawn_x");
  276. VehicleInfo[i][vSpawnX] = floatstr(b);
  277. mysql_fetch_field_row(b,"spawn_y");
  278. VehicleInfo[i][vSpawnY] = floatstr(b);
  279. mysql_fetch_field_row(b,"spawn_z");
  280. VehicleInfo[i][vSpawnZ] = floatstr(b);
  281. mysql_fetch_field_row(b,"spawn_r");
  282. VehicleInfo[i][vSpawnR] = floatstr(b);
  283. mysql_fetch_field_row(b,"color1");
  284. VehicleInfo[i][vColor1] = strval(b);
  285. mysql_fetch_field_row(b,"color2");
  286. VehicleInfo[i][vColor2] = strval(b);
  287. mysql_fetch_field_row(b,"owning_character");
  288. VehicleInfo[i][vOwner] = strval(b);
  289. mysql_fetch_field_row(b,"mileage");
  290. VehicleInfo[i][vMileage] = strval(b);
  291. mysql_fetch_field_row(b,"lock");
  292. VehicleInfo[i][vLock] = strval(b);
  293. mysql_fetch_field_row(b,"locked");
  294. VehicleInfo[i][vLocked] = strval(b);
  295. mysql_fetch_field_row(b,"times_destroyed");
  296. VehicleInfo[i][vDestroyed] = strval(b);
  297. VehicleInfo[i][vEngine] = 0;
  298. mysql_fetch_field_row(b,"fuel");
  299. VehicleInfo[i][vFuel] = strval(b);
  300. mysql_fetch_field_row(b,"faction");
  301. VehicleInfo[i][vFaction] = strval(b);
  302. mysql_fetch_field_row(b,"owner_name");
  303. format(VehicleInfo[i][vOwnerName],MAX_PLAYER_NAME,"%s",b);
  304. mysql_fetch_field_row(b,"death_time");
  305. VehicleInfo[i][vDeathTime] = strval(b);
  306. mysql_fetch_field_row(b,"plate");
  307. format(VehicleInfo[i][vPlate],32,"%s",b);
  308. mysql_fetch_field_row(b,"insurance");
  309. VehicleInfo[i][vInsurance] = strval(b);
  310. mysql_fetch_field_row(b,"mods");
  311. format(VehicleInfo[i][vMods],256,"%s",b);
  312. mysql_fetch_field_row(b,"weapons");
  313. AssignVehicleWeapons(i,b);
  314. mysql_fetch_field_row(b,"paintjob");
  315. VehicleInfo[i][vPaintjob] = strval(b);
  316. mysql_fetch_field_row(b,"imp");
  317. VehicleInfo[i][vImpounded] = strval(b);
  318. mysql_fetch_field_row(b,"gps");
  319. VehicleInfo[i][vGps] = strval(b);
  320. mysql_fetch_field_row(b,"comp");
  321. VehicleInfo[i][vCompany] = strval(b);
  322. mysql_fetch_field_row(b,"dmg1");
  323. VehicleInfo[i][vDamage][0] = strval(b);
  324. mysql_fetch_field_row(b,"dmg2");
  325. VehicleInfo[i][vDamage][1] = strval(b);
  326. mysql_fetch_field_row(b,"dmg3");
  327. VehicleInfo[i][vDamage][2] = strval(b);
  328. mysql_fetch_field_row(b,"dmg4");
  329. VehicleInfo[i][vDamage][3] = strval(b);
  330. mysql_fetch_field_row(b,"hp");
  331. VehicleInfo[i][vHealth] = floatstr(b);
  332. mysql_fetch_field_row(b,"neon");
  333. VehicleInfo[i][vNeon] = strval(b);
  334. mysql_fetch_field_row(b,"immob");
  335. VehicleInfo[i][vImmob] = strval(b);
  336. if(!strlen(VehicleInfo[i][vPlate]) && VehicleInfo[i][vModel]) FetchVehiclePlate(i,VehicleInfo[i][vPlate]);
  337. mysql_fetch_field_row(b,"selling");
  338. VehicleInfo[i][vSelling] = strval(b);
  339. mysql_fetch_field_row(b,"sprice");
  340. VehicleInfo[i][vSellingPrice] = strval(b);
  341. mysql_fetch_field_row(b,"sexpire");
  342. VehicleInfo[i][vSellingExpire] = strval(b);
  343. i ++;
  344.  
  345. }
  346. CreateVehicles();
  347.  
  348. }
  349. else if(type == QUERY_LOAD_HOUSES)
  350. {
  351.  
  352. new i = 0;
  353. new b[256];
  354. while(mysql_retrieve_row())
  355. {
  356.  
  357. mysql_fetch_field_row(b,"id");
  358. HouseInfo[i][hID] = strval(b);
  359. mysql_fetch_field_row(b,"owning_character");
  360. HouseInfo[i][hOwner] = strval(b);
  361. mysql_fetch_field_row(b,"owner_name");
  362. format(HouseInfo[i][hOwnerName],MAX_PLAYER_NAME,"%s",b);
  363. mysql_fetch_field_row(b,"price");
  364. HouseInfo[i][hPrice] = strval(b);
  365. mysql_fetch_field_row(b,"spawn_x");
  366. HouseInfo[i][hSpawnX] = floatstr(b);
  367. mysql_fetch_field_row(b,"spawn_y");
  368. HouseInfo[i][hSpawnY] = floatstr(b);
  369. mysql_fetch_field_row(b,"spawn_z");
  370. HouseInfo[i][hSpawnZ] = floatstr(b);
  371. mysql_fetch_field_row(b,"interior_x");
  372. HouseInfo[i][hInteriorX] = floatstr(b);
  373. mysql_fetch_field_row(b,"interior_y");
  374. HouseInfo[i][hInteriorY] = floatstr(b);
  375. mysql_fetch_field_row(b,"interior_z");
  376. HouseInfo[i][hInteriorZ] = floatstr(b);
  377. mysql_fetch_field_row(b,"interior_r");
  378. HouseInfo[i][hInteriorR] = floatstr(b);
  379. mysql_fetch_field_row(b,"interior");
  380. HouseInfo[i][hInterior] = strval(b);
  381. mysql_fetch_field_row(b,"locked");
  382. HouseInfo[i][hLocked] = strval(b);
  383. mysql_fetch_field_row(b,"rent_price");
  384. HouseInfo[i][hRentPrice] = strval(b);
  385. mysql_fetch_field_row(b,"bank");
  386. HouseInfo[i][hBank] = strval(b);
  387. mysql_fetch_field_row(b,"inv");
  388. format(HouseInfo[i][hInventory],256,"%s",b);
  389. LoadHouseInventory(i);
  390. mysql_fetch_field_row(b,"weapons");
  391. AssignHouseWeapons(i,b);
  392. mysql_fetch_field_row(b,"upgrades");
  393. AssignHouseUpgrades(i,b);
  394. mysql_fetch_field_row(b,"rentable");
  395. HouseInfo[i][hRentable] = strval(b);
  396. mysql_fetch_field_row(b,"level");
  397. HouseInfo[i][hLevel] = strval(b);
  398. i ++;
  399.  
  400. }
  401. CreateHouses();
  402.  
  403. }
  404. else if(type == QUERY_LOAD_BIZES)
  405. {
  406.  
  407. new i = 0;
  408. new b[256];
  409. while(mysql_retrieve_row())
  410. {
  411.  
  412. for(new z = 0; z < 5; z ++){ used_vehicle_slots[i][z] = -1; }
  413. mysql_fetch_field_row(b,"id");
  414. BizInfo[i][bID] = strval(b);
  415. mysql_fetch_field_row(b,"owning_character");
  416. BizInfo[i][bOwner] = strval(b);
  417. mysql_fetch_field_row(b,"owner_name");
  418. format(BizInfo[i][bOwnerName],MAX_PLAYER_NAME,"%s",b);
  419. mysql_fetch_field_row(b,"price");
  420. BizInfo[i][bPrice] = strval(b);
  421. mysql_fetch_field_row(b,"spawn_x");
  422. BizInfo[i][bSpawnX] = floatstr(b);
  423. mysql_fetch_field_row(b,"spawn_y");
  424. BizInfo[i][bSpawnY] = floatstr(b);
  425. mysql_fetch_field_row(b,"spawn_z");
  426. BizInfo[i][bSpawnZ] = floatstr(b);
  427. mysql_fetch_field_row(b,"interior_x");
  428. BizInfo[i][bInteriorX] = floatstr(b);
  429. mysql_fetch_field_row(b,"interior_y");
  430. BizInfo[i][bInteriorY] = floatstr(b);
  431. mysql_fetch_field_row(b,"interior_z");
  432. BizInfo[i][bInteriorZ] = floatstr(b);
  433. mysql_fetch_field_row(b,"interior");
  434. BizInfo[i][bInterior] = strval(b);
  435. mysql_fetch_field_row(b,"type");
  436. BizInfo[i][bType] = strval(b);
  437. mysql_fetch_field_row(b,"open");
  438. BizInfo[i][bOpen] = strval(b);
  439. mysql_fetch_field_row(b,"vehicle_spawn_x");
  440. BizInfo[i][bVX] = floatstr(b);
  441. mysql_fetch_field_row(b,"vehicle_spawn_y");
  442. BizInfo[i][bVY] = floatstr(b);
  443. mysql_fetch_field_row(b,"vehicle_spawn_z");
  444. BizInfo[i][bVZ] = floatstr(b);
  445. mysql_fetch_field_row(b,"vehicle_spawn_r");
  446. BizInfo[i][bVR] = floatstr(b);
  447. mysql_fetch_field_row(b,"open");
  448. BizInfo[i][bOpen] = strval(b);
  449. mysql_fetch_field_row(b,"bank");
  450. BizInfo[i][bBank] = strval(b);
  451. mysql_fetch_field_row(b,"fuel_price");
  452. BizInfo[i][bFuelPrice] = strval(b);
  453. mysql_fetch_field_row(b,"name");
  454. format(BizInfo[i][bName],256,"%s",b);
  455. mysql_fetch_field_row(b,"bill_time");
  456. BizInfo[i][bBillTime] = strval(b);
  457. mysql_fetch_field_row(b,"efee");
  458. BizInfo[i][bEntranceFee] = strval(b);
  459. mysql_fetch_field_row(b,"level");
  460. BizInfo[i][bLevel] = strval(b);
  461. stock_value_oldchange[i] = (BizInfo[i][bBank] != 0) ? (BizInfo[i][bBank] / 100) : 0;
  462. i ++;
  463.  
  464. }
  465. CreateBizes();
  466.  
  467. }
  468. else if(type == QUERY_LOAD_MODELS)
  469. {
  470.  
  471. new b[256];
  472. new i = 0;
  473. while(mysql_retrieve_row())
  474. {
  475.  
  476. mysql_fetch_field_row(b,"model");
  477. VehicleModelInfo[i][vmModel] = strval(b);
  478. mysql_fetch_field_row(b,"name");
  479. format(VehicleModelInfo[i][vmName],256,"%s",b);
  480. mysql_fetch_field_row(b,"price");
  481. VehicleModelInfo[i][vmPrice] = strval(b);
  482. mysql_fetch_field_row(b,"emergency_vehicle");
  483. VehicleModelInfo[i][vmEmerVeh] = strval(b);
  484. mysql_fetch_field_row(b,"donator_vehicle");
  485. VehicleModelInfo[i][vmDonatorVeh] = floatstr(b);
  486. mysql_fetch_field_row(b,"vehicle_type");
  487. VehicleModelInfo[i][vmType] = strval(b);
  488. mysql_fetch_field_row(b,"insurance_price");
  489. VehicleModelInfo[i][vmInsurancePrice] = strval(b);
  490. mysql_fetch_field_row(b,"news");
  491. VehicleModelInfo[i][vmNews] = strval(b);
  492. mysql_fetch_field_row(b,"fuel_interval");
  493. VehicleModelInfo[i][vmFuelInterval] = strval(b);
  494. i ++;
  495.  
  496. }
  497. vehicle_creating = 0;
  498. print("Vehicle Models Loaded.");
  499. CreateBuyVehicles();
  500.  
  501. }
  502. else if(type == QUERY_LOAD_FACTIONS)
  503. {
  504.  
  505. new b[256];
  506. new i = 0;
  507. while(mysql_retrieve_row())
  508. {
  509.  
  510. mysql_fetch_field_row(b,"id");
  511. FactionInfo[i][fID] = strval(b);
  512. mysql_fetch_field_row(b,"name");
  513. format(FactionInfo[i][fName],256,"%s",b);
  514. mysql_fetch_field_row(b,"short_name");
  515. format(FactionInfo[i][fShortName],256,"%s",b);
  516. mysql_fetch_field_row(b,"bank");
  517. FactionInfo[i][fBank] = strval(b);
  518. mysql_fetch_field_row(b,"type");
  519. FactionInfo[i][fType] = strval(b);
  520. i ++;
  521.  
  522. }
  523.  
  524. }
  525. else if(type == QUERY_LOGIN_MAIL)
  526. {
  527.  
  528. new b[256];
  529. new i = 0;
  530. while(mysql_retrieve_row())
  531. {
  532.  
  533. mysql_fetch_field_row(b,"id");
  534. MailInfo[playerid][i][mID] = strval(b);
  535. mysql_fetch_field_row(b,"sender");
  536. format(MailInfo[playerid][i][mSender],MAX_PLAYER_NAME,"%s",b);
  537. mysql_fetch_field_row(b,"subject");
  538. format(MailInfo[playerid][i][mSubject],64,"%s",b);
  539. mysql_fetch_field_row(b,"msg");
  540. format(MailInfo[playerid][i][mMsg],256,"%s",b);
  541. mysql_fetch_field_row(b,"active");
  542. MailInfo[playerid][i][mActive] = strval(b);
  543. mysql_fetch_field_row(b,"read");
  544. MailInfo[playerid][i][mRead] = strval(b);
  545. i ++;
  546.  
  547. }
  548. RefreshCharacterMail(GetCharacterID(playerid));
  549.  
  550. }
  551. else if(type == QUERY_FIND_MAIL)
  552. {
  553.  
  554. new id = mysql_retrieve_row();
  555. if(id > -1)
  556. {
  557. composing_mail[playerid] = 2;
  558. composing_mail_to[playerid] = id;
  559. SendClientMessageA(playerid,COLOR_GREEN,"Te rog introdu subiectul mesajului.");
  560.  
  561. }
  562. else
  563. {
  564.  
  565. SendClientMessageA(playerid,COLOR_LIGHTRED,"Nu s-a putat gasi destinatarul. Te rog fi sigur ca ai introdus numele corect.");
  566.  
  567. }
  568.  
  569. }
  570. else if(type == QUERY_SEND_MAIL)
  571. {
  572.  
  573. if(composing_mail[playerid]) { SendClientMessageA(playerid,COLOR_GREEN,"Mesajul tau a fost trimis!"); }
  574. composing_mail[playerid] = 0;
  575. TogglePlayerControllable(playerid,1);
  576.  
  577. }
  578. else if(type == QUERY_LOAD_INTERIORS)
  579. {
  580.  
  581. new b[256];
  582. new i = 0;
  583. while(mysql_retrieve_row())
  584. {
  585.  
  586. mysql_fetch_field_row(b,"id");
  587. InteriorInfo[i][iID] = strval(b);
  588. mysql_fetch_field_row(b,"spawn_x");
  589. InteriorInfo[i][iSpawnX] = floatstr(b);
  590. mysql_fetch_field_row(b,"spawn_y");
  591. InteriorInfo[i][iSpawnY] = floatstr(b);
  592. mysql_fetch_field_row(b,"spawn_z");
  593. InteriorInfo[i][iSpawnZ] = floatstr(b);
  594. mysql_fetch_field_row(b,"interior_x");
  595. InteriorInfo[i][iInteriorX] = floatstr(b);
  596. mysql_fetch_field_row(b,"interior_y");
  597. InteriorInfo[i][iInteriorY] = floatstr(b);
  598. mysql_fetch_field_row(b,"interior_z");
  599. InteriorInfo[i][iInteriorZ] = floatstr(b);
  600. mysql_fetch_field_row(b,"interior");
  601. InteriorInfo[i][iInterior] = strval(b);
  602. mysql_fetch_field_row(b,"lock");
  603. InteriorInfo[i][iLock] = strval(b);
  604. mysql_fetch_field_row(b,"faction");
  605. InteriorInfo[i][iFaction] = strval(b);
  606. mysql_fetch_field_row(b,"inames");
  607. format(InteriorInfo[i][iNames],256,"%s",b);
  608. i ++;
  609.  
  610. }
  611. CreateInteriors();
  612.  
  613. }
  614. else if(type == QUERY_LOGIN_BANCHECK)
  615. {
  616.  
  617. new num = mysql_num_rows();
  618. if(num > 0) { SendClientMessageA(playerid,COLOR_LIGHTRED,"Acest Cont/IP a fost banat! Nu mai poti juca."); Kick(playerid); }
  619.  
  620. }
  621. else if(type == QUERY_HOUSE_SAVE)
  622. {
  623.  
  624. active_house_save ++;
  625. SaveHouses();
  626.  
  627. }
  628. else if(type == QUERY_BIZ_SAVE)
  629. {
  630.  
  631. active_biz_save ++;
  632. SaveBizes();
  633.  
  634. }
  635. else if(type == QUERY_VEHICLES_SAVE)
  636. {
  637.  
  638. SaveVehicles();
  639.  
  640. }
  641. else if(type == QUERY_LOAD_RADIO)
  642. {
  643.  
  644. new b[256];
  645. new i = 0;
  646. while(mysql_retrieve_row())
  647. {
  648.  
  649. mysql_fetch_field_row(b,"id");
  650. RadioInfo[i][rID] = strval(b);
  651. mysql_fetch_field_row(b,"channel");
  652. RadioInfo[i][rChannel] = strval(b);
  653. mysql_fetch_field_row(b,"owning_character");
  654. RadioInfo[i][rOwner] = strval(b);
  655. mysql_fetch_field_row(b,"password");
  656. format(RadioInfo[i][rPassword],16,"%s",b);
  657. i ++;
  658.  
  659. }
  660. print("Radio Channels Loaded.");
  661.  
  662. }
  663. else if(type == QUERY_RADIO_CREATE)
  664. {
  665.  
  666. RadioInfo[playerid][rID] = mysql_insert_id();
  667.  
  668. }
  669. else if(type == QUERY_SAVE_INTERIORS)
  670. {
  671.  
  672. active_interior_save ++;
  673. SaveInteriors();
  674.  
  675. }
  676. else if(type == QUERY_SAVE_PLAYER)
  677. {
  678.  
  679. if(server_restarting) { active_player_saves --; CheckRestartState(); }
  680. if(afk_reset[(playerid - 1000)]) { StopPlayerRadio((playerid - 1000)); character_chosen[(playerid - 1000)] = 0; active_character[(playerid - 1000)] = -1; ResetStats((playerid - 1000)); ProcessSpawn((playerid - 1000)); }
  681.  
  682. }
  683. else if(type == QUERY_CREATE_NOTE)
  684. {
  685.  
  686. if(creating_note[playerid] > -1)
  687. {
  688.  
  689. NoteInfo[playerid][creating_note[playerid]][nID] = mysql_insert_id();
  690. creating_note[playerid] = -1;
  691.  
  692. }
  693.  
  694. }
  695. else if(type == QUERY_LOGIN_INVENTORY)
  696. {
  697.  
  698. new b[256];
  699. new i = 0;
  700. while(mysql_retrieve_row())
  701. {
  702.  
  703. mysql_fetch_field_row(b,"id");
  704. InventoryInfo[playerid][i][inID] = strval(b);
  705. mysql_fetch_field_row(b,"item");
  706. InventoryInfo[playerid][i][inItem] = strval(b);
  707. mysql_fetch_field_row(b,"amount");
  708. InventoryInfo[playerid][i][inAmount] = strval(b);
  709. i ++;
  710.  
  711. }
  712.  
  713. }
  714. else if(type == QUERY_LOAD_DRUGS)
  715. {
  716.  
  717. new b[256];
  718. new i = 0;
  719. while(mysql_retrieve_row())
  720. {
  721.  
  722. mysql_fetch_field_row(b,"id");
  723. DrugInfo[i][dID] = strval(b);
  724. mysql_fetch_field_row(b,"type");
  725. DrugInfo[i][dType] = strval(b);
  726. mysql_fetch_field_row(b,"spawn_x");
  727. DrugInfo[i][dSpawnX] = floatstr(b);
  728. mysql_fetch_field_row(b,"spawn_y");
  729. DrugInfo[i][dSpawnY] = floatstr(b);
  730. mysql_fetch_field_row(b,"spawn_z");
  731. DrugInfo[i][dSpawnZ] = floatstr(b);
  732. mysql_fetch_field_row(b,"planted");
  733. DrugInfo[i][dTime] = strval(b);
  734. i ++;
  735.  
  736. }
  737. CreateDrugs();
  738.  
  739. }
  740. else if(type == QUERY_DRUG_SAVE)
  741. {
  742.  
  743. active_drug_save ++;
  744. SaveDrugs();
  745.  
  746. }
  747. else if(type == QUERY_LOAD_VINVENTORY)
  748. {
  749.  
  750. new b[256];
  751. new i = 0;
  752. while(mysql_retrieve_row())
  753. {
  754.  
  755. mysql_fetch_field_row(b,"owning_vehicle");
  756. new slot = GetVehicleSlotFromID(strval(b));
  757. new a = 0;
  758. new is = -1;
  759. do{
  760.  
  761. if(VehicleInventory[slot][a][vinItem] == -1) { is = a; }
  762. a ++;
  763.  
  764. } while(is == -1 && a < MAX_INVENTORY);
  765. if(is > -1)
  766. {
  767. mysql_fetch_field_row(b,"id");
  768. VehicleInventory[slot][is][vinID] = strval(b);
  769. mysql_fetch_field_row(b,"item");
  770. VehicleInventory[slot][is][vinItem] = strval(b);
  771. mysql_fetch_field_row(b,"amount");
  772. VehicleInventory[slot][is][vinAmount] = strval(b);
  773. }
  774. i ++;
  775.  
  776. }
  777. print("Vehicle Inventory Loaded.");
  778.  
  779. }
  780. else if(type == QUERY_CREATE_VINVENTORY)
  781. {
  782.  
  783. if(adding_vinventory[(playerid - 100000)] > -1)
  784. {
  785.  
  786. VehicleInventory[(playerid - 100000)][adding_vinventory[(playerid - 100000)]][vinID] = mysql_insert_id();
  787. adding_vinventory[(playerid - 100000)] = -1;
  788.  
  789. }
  790.  
  791. }
  792. else if(type == QUERY_SAVE_VINVENTORY)
  793. {
  794.  
  795. if(adding_vinventory[(playerid - 100000)] > -1)
  796. {
  797.  
  798. adding_vinventory[(playerid - 100000)] = -1;
  799.  
  800. }
  801.  
  802. }
  803. else if(type == QUERY_CREATE_ACCOUNT)
  804. {
  805.  
  806. tmp_account_id[playerid] = mysql_insert_id();
  807.  
  808. }
  809. else if(type == QUERY_CREATE_CHAR)
  810. {
  811.  
  812. if(!mysql_num_rows())
  813. {
  814.  
  815. new skin = (strcmp(reg_sex[playerid],"male",true) == 0) ? 177 : 192;
  816. new str3[1024];
  817. format(str3,sizeof(str3),"INSERT INTO rp_characters (name,skin,spawn_x,spawn_y,spawn_z,spawn_r,owner,pay_time,level,gender,dob,ethnicity,radio_auth,health,money,bank) VALUES ('%s','%d','1929.0565','33.6534','33.9817','270','%d','3600','1','%s',NOW(),'White','none',100,'5000','8000')",clean_save_name[playerid],skin,tmp_account_id[playerid],reg_sex[playerid]);
  818. mysql_query(str3,player_threads[playerid]);
  819. format(str3,sizeof(str3),"INSERT INTO ucp_donator_items (User,Type) VALUES ('%d',1)",tmp_account_id[playerid]);
  820. mysql_query(str3,player_threads_alt[playerid]);
  821. tmp_account_id[playerid] = -1;
  822. SendClientMessage(playerid,COLOR_YELLOW,"Iti multumim ca te-ai inregistrat pe Modern Roleplay. Pentru ati schimba detaliile contului intra pe UCP @ http://ucp.modern-rp.ro");
  823. SendClientMessage(playerid,COLOR_YELLOW,"http://ucp.modern-rp.ro");
  824. OnPlayerConnect(playerid);
  825.  
  826. }
  827. else
  828. {
  829.  
  830. SendClientMessage(playerid,COLOR_LIGHTRED,"Acest nume este luat , alege altul.");
  831. ShowPlayerDialog(playerid,DIALOG_REG4,DIALOG_STYLE_INPUT,"Creeare Caracter","Te rog introdu un nume intreg si corect.Ia exemplu dupa acesta: Nume_Prenume(ex: Michael Koperfield)","Confirma","");
  832.  
  833. }
  834.  
  835. }
  836. else if(type == QUERY_REQCALLS)
  837. {
  838.  
  839. new b[256];
  840. SendClientMessage(playerid,COLOR_YELLOW2,"|___Apeluri Recente___|");
  841. if(mysql_num_rows())
  842. {
  843.  
  844. while(mysql_retrieve_row())
  845. {
  846.  
  847. mysql_fetch_field_row(b,"id");
  848. new id = strval(b);
  849. mysql_fetch_field_row(b,"situation");
  850. new sit[64];
  851. strcat(sit,b,sizeof(sit));
  852. mysql_fetch_field_row(b,"stamp2");
  853. new str3[256];
  854. format(str3,sizeof(str3),"Apel %d: %s (%s)",id,sit,b);
  855. SendClientMessageA(playerid,COLOR_YELLOW2,str3);
  856.  
  857. }
  858.  
  859. }
  860. else
  861. {
  862.  
  863. SendClientMessage(playerid,COLOR_LIGHTRED,"Nu ai apeluri");
  864.  
  865. }
  866.  
  867. }
  868. else if(type == QUERY_WARRANTS)
  869. {
  870.  
  871. if(mysql_num_rows())
  872. {
  873.  
  874. new b[256];
  875. while(mysql_retrieve_row())
  876. {
  877.  
  878. new crime[128];
  879. mysql_fetch_field_row(b,"crime");
  880. strcat(crime,b);
  881. mysql_fetch_field_row(b,"stamp");
  882. new str3[256];
  883. format(str3,sizeof(str3),"MANDAT: %s (%s)",crime,b);
  884. SendClientMessageA(playerid,COLOR_LIGHTRED,str3);
  885. PlayerPlaySound(playerid,1085,0.0,0.0,0.0);
  886.  
  887. }
  888.  
  889. }
  890. else
  891. {
  892.  
  893. SendClientMessage(playerid,COLOR_WHITE,"Nu sunt mandate");
  894.  
  895. }
  896. new fine_str[256];
  897. format(fine_str,sizeof(fine_str),"SELECT * FROM rp_fines WHERE suspect = '%d' AND paid = 0",GetPVarInt(playerid,"mdc_otherid"));
  898. mysql_query(fine_str,player_threads[playerid],QUERY_MDC_FINE);
  899.  
  900. }
  901. else if(type == QUERY_GETCALL)
  902. {
  903.  
  904. if(mysql_num_rows())
  905. {
  906.  
  907. while(mysql_retrieve_row())
  908. {
  909.  
  910. new caller[MAX_PLAYER_NAME];
  911. mysql_fetch_field_row(caller,"caller");
  912. new number[64];
  913. mysql_fetch_field_row(number,"phone");
  914. new location[128];
  915. mysql_fetch_field_row(location,"location");
  916. new situation[128];
  917. mysql_fetch_field_row(situation,"situation");
  918. new stamp[64];
  919. mysql_fetch_field_row(stamp,"stamp");
  920. new tmp[256];
  921. SendClientMessage(playerid,COLOR_YELLOW2,"|___Informatii Apel___|");
  922. format(tmp,sizeof(tmp),"{808080}Apelant: {FFFFFF}%s",caller);
  923. SendClientMessage(playerid,COLOR_WHITE,tmp);
  924. format(tmp,sizeof(tmp),"{808080}Telefon: {FFFFFF}%s",number);
  925. SendClientMessage(playerid,COLOR_WHITE,tmp);
  926. format(tmp,sizeof(tmp),"{808080}LOcatie: {FFFFFF}%s",location);
  927. SendClientMessage(playerid,COLOR_WHITE,tmp);
  928. format(tmp,sizeof(tmp),"{808080}Situatie: {FFFFFF}%s",situation);
  929. SendClientMessageA(playerid,COLOR_WHITE,tmp);
  930. format(tmp,sizeof(tmp),"{808080}Apelat: {FFFFFF}%s",stamp);
  931. SendClientMessage(playerid,COLOR_WHITE,tmp);
  932.  
  933. }
  934.  
  935. }
  936. else
  937. {
  938.  
  939. SendClientMessage(playerid,COLOR_LIGHTRED,"Apelul nu a fost gasit");
  940.  
  941. }
  942.  
  943. }
  944. else if(type == QUERY_DELETE_VINVENTORY)
  945. {
  946.  
  947. for(new slot = 0; slot < MAX_INVENTORY; slot ++)
  948. {
  949.  
  950. if(VehicleInventory[(playerid - 100000)][slot][vinID] > 0 && VehicleInventory[(playerid - 100000)][slot][vinItem] == -1) { VehicleInventory[(playerid - 100000)][slot][vinID] = 0; }
  951.  
  952. }
  953.  
  954. }
  955. else if(type == QUERY_REQ_STATIONS)
  956. {
  957.  
  958. if(!mysql_num_rows()) { SendClientMessage(playerid,COLOR_LIGHTRED,"Nu sunt statii radio valabile."); } else {
  959.  
  960. SendClientMessage(playerid,COLOR_YELLOW2,"|___-Radio Stations-___|");
  961. new b[64];
  962. new b2[64];
  963. new str3[128];
  964. while(mysql_retrieve_row())
  965. {
  966.  
  967. mysql_fetch_field_row(b,"radioID");
  968. mysql_fetch_field_row(b2,"Station");
  969. format(str3,sizeof(str3),"Station %s: %s",b,b2);
  970. SendClientMessage(playerid,COLOR_YELLOW2,str3);
  971.  
  972. }
  973. SendClientMessage(playerid,COLOR_YELLOW2,"Foloseste /radio set [Station ID] pentru a seta frecventa.");
  974.  
  975. }
  976.  
  977.  
  978. }
  979. else if(type == QUERY_SET_STATION)
  980. {
  981.  
  982. if(!mysql_num_rows()) { SendErrorMsg(playerid,"Frecventa nu a fost gasita"); } else {
  983.  
  984. Audio_Stop(playerid,radio_handle[playerid]);
  985. new b[256];
  986. new d[3][256];
  987. mysql_fetch_row_format(b);
  988. explode(d,b,"|");
  989. new url[256];
  990. radio_id[playerid] = strval(d[0]);
  991. format(url,sizeof(url),"%s",d[2]);
  992. Audio_StopRadio(playerid);
  993. radio_handle[playerid] = Audio_PlayStreamed(playerid,url);
  994. Audio_SetVolume(playerid,radio_handle[playerid],radio_volume[playerid]);
  995. SendClientMessage(playerid,COLOR_YELLOW2,"Foloseste /radio volume [1-100] pentru a seta volumul, sau /radio pentru a-l opri.");
  996. new veh = GetPlayerVehicleID(playerid);
  997. vehicle_radioid[veh] = radio_id[playerid];
  998. format(vehicle_radio[veh],256,"%s",url);
  999. format(player_radio[playerid],256,"%s",url);
  1000. SyncRadioPassengers(veh);
  1001. SendEmote(playerid,"modifica frecventa statiei lui.");
  1002.  
  1003. }
  1004.  
  1005. }
  1006. else if(type == QUERY_LOAD_INVENTORY)
  1007. {
  1008.  
  1009. mysql_retrieve_row();
  1010. new bb[256];
  1011. mysql_fetch_field_row(bb,"inventory");
  1012. GiveSavedInventory((playerid - 20000),bb);
  1013.  
  1014. }
  1015. else if(type == QUERY_CASH_CHEQUE)
  1016. {
  1017.  
  1018. new i = 1;
  1019. new done = 0;
  1020. while(mysql_retrieve_row())
  1021. {
  1022.  
  1023. if(i == requesting_cheque[playerid])
  1024. {
  1025.  
  1026. new bb[256];
  1027. mysql_fetch_field_row(bb,"id");
  1028. new id = strval(bb);
  1029. mysql_fetch_field_row(bb,"amount");
  1030. new amount = strval(bb);
  1031. mysql_fetch_field_row(bb,"sender");
  1032. new other = strval(bb);
  1033. CompleteChequeCash(id,playerid,other,amount);
  1034. done = 1;
  1035.  
  1036. }
  1037. i ++;
  1038.  
  1039. }
  1040. if(!done) SendClientMessage(playerid,COLOR_LIGHTRED,"Nu sunt cec-uri pe slot.");
  1041.  
  1042. }
  1043. else if(type == QUERY_VIEW_CHEQUES)
  1044. {
  1045.  
  1046. SendClientMessage(playerid,COLOR_YELLOW2,"|___Cecurile dvs.___|");
  1047. new ii = 1;
  1048. while(mysql_retrieve_row())
  1049. {
  1050.  
  1051. new bbb[128];
  1052. mysql_fetch_field_row(bbb,"amount");
  1053. new str3[128];
  1054. format(str3,sizeof(str3),"Cec-uri #%d: $%s",ii,bbb);
  1055. SendClientMessage(playerid,COLOR_YELLOW2,str3);
  1056. ii ++;
  1057.  
  1058. }
  1059.  
  1060. }
  1061. else if(type == QUERY_TENANTS)
  1062. {
  1063.  
  1064. SendClientMessage(playerid,COLOR_YELLOW2,"|___Chiriasii dvs.___|");
  1065. new tid = 1;
  1066. while(mysql_retrieve_row())
  1067. {
  1068.  
  1069. new tstr[MAX_PLAYER_NAME], tstr2[128];
  1070. mysql_fetch_field_row(tstr,"name");
  1071. format(tstr2,sizeof(tstr2),"#%d: %s",tid,tstr);
  1072. SendClientMessage(playerid,COLOR_YELLOW2,tstr2);
  1073.  
  1074. }
  1075. SendClientMessage(playerid,COLOR_YELLOW2,"Usage /evict [tenant #] pentru a da afara chiriasii");
  1076.  
  1077. }
  1078. else if(type == QUERY_EVICT)
  1079. {
  1080.  
  1081. new tid = 1;
  1082. new evict_str[256];
  1083. new evict_tmp[256];
  1084. new evict_int = 0;
  1085. new evict_ustr[128];
  1086. new done = 0;
  1087. while(mysql_retrieve_row())
  1088. {
  1089.  
  1090. if(tid == evicting_tenant[playerid])
  1091. {
  1092.  
  1093. mysql_fetch_field_row(evict_str,"id");
  1094. evict_int = strval(evict_str);
  1095. mysql_fetch_field_row(evict_tmp,"name");
  1096. new other = IsCharacterOnline(evict_int);
  1097. if(other > -1)
  1098. {
  1099.  
  1100. CharacterInfo[other][active_character[other]][cRenting] = 0;
  1101. done = 1;
  1102.  
  1103. }
  1104. else
  1105. {
  1106.  
  1107. format(evict_str,sizeof(evict_str),"UPDATE rp_characters SET renting = '0' WHERE id = '%d' LIMIT 1",evict_int);
  1108. mysql_query(evict_str,player_threads[playerid]);
  1109. done = 1;
  1110.  
  1111. }
  1112. format(evict_ustr,sizeof(evict_ustr),"L-ai dat afara pe %s din casa ta.",evict_tmp);
  1113. SendClientMessage(playerid,COLOR_YELLOW,evict_ustr);
  1114.  
  1115. }
  1116. tid ++;
  1117.  
  1118. }
  1119. if(!done) SendClientMessage(playerid,COLOR_LIGHTRED,"Nu sunt chiriasi.");
  1120. evicting_tenant[playerid] = 0;
  1121.  
  1122. }
  1123. else if(type == QUERY_APB)
  1124. {
  1125.  
  1126. SendClientMessage(playerid,COLOR_LIGHTRED,"|----APBs----|");
  1127. new apb_str[256];
  1128. new apb_id = 0;
  1129. new apb_suspect[64];
  1130. new apb_send[256];
  1131. while(mysql_retrieve_row())
  1132. {
  1133.  
  1134. mysql_fetch_field_row(apb_str,"id");
  1135. apb_id = strval(apb_str);
  1136. mysql_fetch_field_row(apb_str,"suspect");
  1137. format(apb_suspect,sizeof(apb_suspect),"%s",apb_str);
  1138. format(apb_send,sizeof(apb_send),"#%d: %s",apb_id,apb_suspect);
  1139. SendClientMessage(playerid,COLOR_LIGHTRED,apb_send);
  1140.  
  1141. }
  1142. SendClientMessage(playerid,COLOR_LIGHTRED,"Usage /apb read to read an APB");
  1143.  
  1144. }
  1145. else if(type == QUERY_APB_READ)
  1146. {
  1147.  
  1148. if(mysql_num_rows())
  1149. {
  1150.  
  1151. new read_apb_str[256];
  1152. new read_apb_id = 0;
  1153. new read_apb_suspect[128];
  1154. new read_apb_crime[128];
  1155. new read_apb_stamp[128];
  1156. mysql_retrieve_row();
  1157. mysql_fetch_field_row(read_apb_str,"id");
  1158. read_apb_id = strval(read_apb_str);
  1159. mysql_fetch_field_row(read_apb_str,"suspect");
  1160. format(read_apb_suspect,sizeof(read_apb_suspect),"%s",read_apb_str);
  1161. mysql_fetch_field_row(read_apb_str,"crime");
  1162. format(read_apb_crime,sizeof(read_apb_crime),"%s",read_apb_str);
  1163. mysql_fetch_field_row(read_apb_str,"stamp");
  1164. format(read_apb_stamp,sizeof(read_apb_stamp),"%s",read_apb_str);
  1165. SendClientMessage(playerid,COLOR_LIGHTRED,"|___APB Informatii___|");
  1166. format(read_apb_str,sizeof(read_apb_str),"APB #: %d",read_apb_id);
  1167. SendClientMessage(playerid,COLOR_LIGHTRED,read_apb_str);
  1168. format(read_apb_str,sizeof(read_apb_str),"Suspect/Vehicue: %s",read_apb_suspect);
  1169. SendClientMessage(playerid,COLOR_LIGHTRED,read_apb_str);
  1170. format(read_apb_str,sizeof(read_apb_str),"Crima: %s",read_apb_crime);
  1171. SendClientMessage(playerid,COLOR_LIGHTRED,read_apb_str);
  1172. format(read_apb_str,sizeof(read_apb_str),"Creat de: %s",read_apb_stamp);
  1173. SendClientMessage(playerid,COLOR_LIGHTRED,read_apb_str);
  1174.  
  1175. }
  1176. else
  1177. {
  1178.  
  1179. SendClientMessage(playerid,COLOR_LIGHTRED,"Nu exista APB pe acest player.");
  1180.  
  1181. }
  1182.  
  1183. }
  1184. else if(type == QUERY_APB_CREATE)
  1185. {
  1186.  
  1187. new apb_write_name[MAX_PLAYER_NAME];
  1188. GetCharacterName(playerid,apb_write_name);
  1189. new apb_write_str[256];
  1190. new apb_write_id = mysql_insert_id();
  1191. format(apb_write_str,sizeof(apb_write_str),"%s %s a fost creeat un nou APB, foloseste /apb read %d pentru a-l citi.",CharacterInfo[playerid][active_character[playerid]][cRankName],apb_write_name,apb_write_id);
  1192. SendFactionMessage(CharacterInfo[playerid][active_character[playerid]][cFaction],apb_write_str);
  1193.  
  1194. }
  1195. else if(type == QUERY_SAVE_FACTIONS)
  1196. {
  1197.  
  1198. active_faction_save ++;
  1199. if(active_faction_save < sizeof(FactionInfo))
  1200. {
  1201.  
  1202. SaveFactions();
  1203.  
  1204. }
  1205. else
  1206. {
  1207.  
  1208. active_faction_save = 0;
  1209. print("Factions Saved.");
  1210. SendAdminBroadcast("[SERVER] Factiunile au fost salvate cu succes!");
  1211. if(server_restarting) {
  1212. saved_vars ++;
  1213. CheckRestartState();
  1214. }
  1215.  
  1216. }
  1217.  
  1218. }
  1219. else if(type == QUERY_LOAD_COMPANIES)
  1220. {
  1221.  
  1222. new i = 0;
  1223. while(mysql_retrieve_row())
  1224. {
  1225.  
  1226. new comp_str[256];
  1227. mysql_fetch_field_row(comp_str,"id");
  1228. CompanyInfo[i][ciID] = strval(comp_str);
  1229. mysql_fetch_field_row(comp_str,"name");
  1230. format(CompanyInfo[i][ciName],64,"%s",comp_str);
  1231. mysql_fetch_field_row(comp_str,"bank");
  1232. CompanyInfo[i][ciBank] = strval(comp_str);
  1233. mysql_fetch_field_row(comp_str,"jobs_complete");
  1234. CompanyInfo[i][ciJobsComplete] = strval(comp_str);
  1235. mysql_fetch_field_row(comp_str,"type");
  1236. CompanyInfo[i][ciType] = strval(comp_str);
  1237. mysql_fetch_field_row(comp_str,"pay_rate");
  1238. CompanyInfo[i][ciPayRate] = strval(comp_str);
  1239. mysql_fetch_field_row(comp_str,"job_money");
  1240. CompanyInfo[i][ciJobMoney] = strval(comp_str);
  1241. i ++;
  1242.  
  1243. }
  1244. print("Companies Loaded.");
  1245.  
  1246. }
  1247. else if(type == QUERY_WORKLOGS)
  1248. {
  1249.  
  1250. new dialogstr[1024];
  1251. while(mysql_retrieve_row())
  1252. {
  1253.  
  1254. new tmp[128];
  1255. new namestr[MAX_PLAYER_NAME];
  1256. new paystr[128];
  1257. new typestr[128];
  1258. mysql_fetch_field_row(namestr,"name");
  1259. mysql_fetch_field_row(paystr,"pay");
  1260. mysql_fetch_field_row(typestr,"type");
  1261. format(tmp,sizeof(tmp),"%s completate %s | Bani Facuti: $%s\n",namestr,typestr,paystr);
  1262. strins(dialogstr,tmp,strlen(dialogstr));
  1263.  
  1264. }
  1265. ShowPlayerDialog(playerid,999,DIALOG_STYLE_LIST,"Joburi terminate recent",dialogstr,"Ok","Iesi");
  1266.  
  1267. }
  1268. else if(type == QUERY_SAVE_RIGS)
  1269. {
  1270.  
  1271. active_rig_save ++;
  1272. SaveRigs();
  1273.  
  1274. }
  1275. else if(type == QUERY_LOAD_RIGS)
  1276. {
  1277.  
  1278. new i = 0;
  1279. while(mysql_retrieve_row())
  1280. {
  1281.  
  1282. new rig_str[256];
  1283. mysql_fetch_field_row(rig_str,"owner");
  1284. oil_rig_owners[i] = strval(rig_str);
  1285. mysql_fetch_field_row(rig_str,"level");
  1286. oil_rig_levels[i] = strval(rig_str);
  1287. if(oil_rig_owners[i] > 0)
  1288. {
  1289.  
  1290. oil_rig_objects[i] = F_CreateObject(3426,oil_rigs[i][0],oil_rigs[i][1],oil_rigs[i][2],0.0,0.0,0.0);
  1291.  
  1292. }
  1293. i ++;
  1294.  
  1295. }
  1296. print("Rigs Loaded.");
  1297.  
  1298. }
  1299. else if(type == QUERY_SAVE_COMPANY)
  1300. {
  1301.  
  1302. active_company_save ++;
  1303. SaveCompanies();
  1304.  
  1305. }
  1306. else if(type == QUERY_BUY_STOCK)
  1307. {
  1308.  
  1309. new stype = buying_stock[playerid];
  1310. new amount = buying_stock_amount[playerid];
  1311. new bstock_str[256];
  1312. if(!mysql_num_rows())
  1313. {
  1314.  
  1315. format(bstock_str,sizeof(bstock_str),"INSERT INTO rp_stock (owner,type,amount) VALUES ('%d','%d','%d')",CharacterInfo[playerid][active_character[playerid]][cID],stype,amount);
  1316. mysql_query(bstock_str,player_threads[playerid]);
  1317.  
  1318. }
  1319. else
  1320. {
  1321.  
  1322. format(bstock_str,sizeof(bstock_str),"UPDATE rp_stock SET amount = '%d' WHERE owner = '%d' AND type = '%d'",amount,CharacterInfo[playerid][active_character[playerid]][cID],stype);
  1323. mysql_query(bstock_str,player_threads[playerid]);
  1324.  
  1325. }
  1326. buying_stock[playerid] = 0;
  1327. buying_stock_amount[playerid] = 0;
  1328.  
  1329. }
  1330. else if(type == QUERY_STOCK_LIST)
  1331. {
  1332.  
  1333. new i = 1;
  1334. SendClientMessage(playerid,COLOR_YELLOW2,"|___Stoc-ul tau___|");
  1335. while(mysql_retrieve_row())
  1336. {
  1337.  
  1338. new stock_str[256];
  1339. mysql_fetch_field_row(stock_str,"type");
  1340. new stype = strval(stock_str);
  1341. mysql_fetch_field_row(stock_str,"amount");
  1342. new amount = strval(stock_str);
  1343. new stock_send_str[128];
  1344. new name[64];
  1345. GetStockName(stype,name);
  1346. format(stock_send_str,128,"#%d: %d x %s",i,amount,name);
  1347. SendClientMessage(playerid,COLOR_WHITE,stock_send_str);
  1348. i ++;
  1349.  
  1350. }
  1351.  
  1352. }
  1353. else if(type == QUERY_SELL_STOCK)
  1354. {
  1355.  
  1356. new i = 1;
  1357. new sdone = 0;
  1358. while(mysql_retrieve_row())
  1359. {
  1360.  
  1361. new sells_str[256];
  1362. if(i == selling_stock_slot[playerid])
  1363. {
  1364.  
  1365. mysql_fetch_field_row(sells_str,"id");
  1366. new tmpid = strval(sells_str);
  1367. mysql_fetch_field_row(sells_str,"amount");
  1368. new amount = strval(sells_str);
  1369. mysql_fetch_field_row(sells_str,"type");
  1370. new setype = strval(sells_str);
  1371. new name[64];
  1372. GetStockName(setype,name);
  1373. new se_send_str[256];
  1374. new price = (stock_value[setype] * amount);
  1375. sell_stock_price[playerid] = price;
  1376. format(se_send_str,sizeof(se_send_str),"{FFFFFF}Esti aproape sa vinzi stoc-ul in {FF0000}%s {FFFFFF}pentru {FF0000}$%d",name,price);
  1377. SendConfirmationMsg(playerid,se_send_str,DIALOG_SELLSTOCK,tmpid);
  1378. sdone = 1;
  1379.  
  1380. }
  1381. i ++;
  1382.  
  1383. }
  1384. if(!sdone)
  1385. {
  1386.  
  1387. SendClientMessage(playerid,COLOR_LIGHTRED,"Nu sunt stoc-uri pe slot.");
  1388.  
  1389. }
  1390.  
  1391. }
  1392. else if(type == QUERY_COMPMEMBERS)
  1393. {
  1394.  
  1395. while(mysql_retrieve_row())
  1396. {
  1397.  
  1398. new sendstr[128];
  1399. new membstr[MAX_PLAYER_NAME];
  1400. mysql_fetch_field_row(membstr,"name");
  1401. new rankstr[64];
  1402. mysql_fetch_field_row(rankstr,"comp_rank");
  1403. new charstr[16];
  1404. mysql_fetch_field_row(charstr,"id");
  1405. new charid = strval(charstr);
  1406. format(sendstr,sizeof(sendstr),"%s %s",rankstr,membstr);
  1407. new color = (IsCharacterOnline(charid) > -1) ? COLOR_YELLOW2 : COLOR_GRAD1;
  1408. SendClientMessage(playerid,color,sendstr);
  1409.  
  1410. }
  1411.  
  1412. }
  1413. else if(type == QUERY_LOAD_RINGTONE)
  1414. {
  1415.  
  1416. mysql_retrieve_row();
  1417. new ringtone_src[256];
  1418. mysql_fetch_field_row(ringtone_src,"stream");
  1419. format(ringtone_sys_stream[playerid],256,ringtone_src);
  1420.  
  1421. }
  1422. else if(type == QUERY_RINGTONES)
  1423. {
  1424.  
  1425. SendClientMessage(playerid,COLOR_YELLOW2,"|___Melodii valabile___|");
  1426. new ringi = 1;
  1427. while(mysql_retrieve_row())
  1428. {
  1429.  
  1430. new ringtmp1[64];
  1431. mysql_fetch_field_row(ringtmp1,"name");
  1432. new ringsendstr[256];
  1433. format(ringsendstr,sizeof(ringsendstr),"#%d: %s",ringi,ringtmp1);
  1434. SendClientMessage(playerid,COLOR_YELLOW2,ringsendstr);
  1435. ringi ++;
  1436.  
  1437. }
  1438. SendClientMessage(playerid,COLOR_YELLOW2,"Pentru a vedea melodiile, foloseste /ringtone listen [ringtone #]");
  1439.  
  1440. }
  1441. else if(type == QUERY_LISTEN_RINGTONE)
  1442. {
  1443.  
  1444. new ringi = 1;
  1445. while(mysql_retrieve_row())
  1446. {
  1447.  
  1448. if(ringi == listen_ringtone[playerid])
  1449. {
  1450.  
  1451. new ringotmp1[64];
  1452. mysql_fetch_field_row(ringotmp1,"name");
  1453. new ringotmp2[256];
  1454. mysql_fetch_field_row(ringotmp2,"stream");
  1455. SendStrMsg(playerid,COLOR_YELLOW2,"Melodii provenite: %s",ringotmp1);
  1456. new at = Audio_PlayStreamed(playerid,ringotmp2);
  1457. Audio_SetVolume(playerid,at,100);
  1458.  
  1459. }
  1460. ringi ++;
  1461.  
  1462. }
  1463.  
  1464. }
  1465. else if(type == QUERY_SET_RINGTONE)
  1466. {
  1467.  
  1468. new ringi = 1;
  1469. while(mysql_retrieve_row())
  1470. {
  1471.  
  1472. if(ringi == listen_ringtone[playerid])
  1473. {
  1474.  
  1475. new ringatmp1[64];
  1476. mysql_fetch_field_row(ringatmp1,"name");
  1477. new ringatmp2[256];
  1478. mysql_fetch_field_row(ringatmp2,"stream");
  1479. SendStrMsg(playerid,COLOR_YELLOW2,"Ai setat melodia la: %s",ringatmp1);
  1480. format(ringtone_sys_stream[playerid],256,ringatmp2);
  1481. new ringquery[256];
  1482. format(ringquery,sizeof(ringquery),"INSERT INTO rp_active_ringtones (owner,stream) VALUES ('%d','%s')",CharacterInfo[playerid][active_character[playerid]][cID],ringatmp2);
  1483. mysql_query(ringquery,player_threads[playerid]);
  1484.  
  1485. }
  1486. ringi ++;
  1487.  
  1488. }
  1489.  
  1490. }
  1491. else if(type == QUERY_PURCHASE_VEHICLE)
  1492. {
  1493.  
  1494. new slot = purchasing_vehicle[playerid];
  1495. if(slot > -1)
  1496. {
  1497.  
  1498. VehicleInfo[slot][vID] = mysql_insert_id();
  1499.  
  1500. }
  1501. purchasing_vehicle[playerid] = -1;
  1502.  
  1503. }
  1504. else if(type == QUERY_LOG_CON)
  1505. {
  1506.  
  1507. AccountInfo[playerid][aConnectionID] = mysql_insert_id();
  1508.  
  1509. }
  1510. else if(type == QUERY_SIGN)
  1511. {
  1512.  
  1513. new num = mysql_num_rows();
  1514. new sign_str[128];
  1515. format(sign_str,sizeof(sign_str),"Orasul Palomino Creek\nPopulatie: %d",num);
  1516. SetObjectMaterialText(sign_object_text, sign_str, 0, OBJECT_MATERIAL_SIZE_256x128,"Arial",22);
  1517.  
  1518. }
  1519. else if(type == QUERY_TUNE_BOOMBOX)
  1520. {
  1521.  
  1522. if(mysql_num_rows())
  1523. {
  1524.  
  1525. new boom_box_str[256];
  1526. mysql_fetch_row_format(boom_box_str);
  1527. new box = changing_boombox[playerid];
  1528. changing_boombox[playerid] = -1;
  1529. format(BoomBoxInfo[box][boStream],256,"%s",boom_box_str);
  1530. SendEmote(playerid,"modifica ");
  1531. RefreshBoomBoxListeners(box);
  1532.  
  1533. }
  1534. else
  1535. {
  1536.  
  1537. SendClientMessage(playerid,COLOR_LIGHTRED,"This radio station does not exist");
  1538.  
  1539. }
  1540.  
  1541. }
  1542. else if(type == QUERY_UNBAN)
  1543. {
  1544.  
  1545. if(mysql_num_rows())
  1546. {
  1547.  
  1548. new unban_str[256];
  1549. mysql_fetch_row_format(unban_str);
  1550. new unban_id = strval(unban_str);
  1551. new ip[128];
  1552. new unban_ip[128];
  1553. GetPlayerIp(playerid,ip,sizeof(ip));
  1554. mysql_real_escape_string(ip,unban_ip);
  1555. new unban_query[256];
  1556. format(unban_query,sizeof(unban_query),"DELETE FROM rp_bans WHERE banee = '%d' OR ip = '%s'",unban_id,unban_ip);
  1557. mysql_query(unban_query,player_threads[playerid],QUERY_COMPLETE_UNBAN);
  1558.  
  1559. }
  1560. else
  1561. {
  1562.  
  1563. SendClientMessage(playerid,COLOR_LIGHTRED,"Acest cont nu a fost gasit");
  1564.  
  1565. }
  1566.  
  1567. }
  1568. else if(type == QUERY_COMPLETE_UNBAN)
  1569. {
  1570.  
  1571. SendClientMessage(playerid,COLOR_GREEN,"Acest user a fost debanat.");
  1572. new unban_final_query[256];
  1573. format(unban_final_query,sizeof(unban_final_query),"INSERT INTO rp_admin_logs (admin,player,action) VALUES ('%s','%s','Unban')",AccountInfo[playerid][aName],unbanning_player[playerid],player_threads[playerid]);
  1574. mysql_query(unban_final_query,player_threads[playerid]);
  1575.  
  1576. }
  1577. else if(type == QUERY_CHECKCLOTHES)
  1578. {
  1579.  
  1580. SendClientMessage(playerid,COLOR_YELLOW2,"|___Accesoriile tale___|");
  1581. new clstr[128];
  1582. new count = 1;
  1583. while(mysql_retrieve_row())
  1584. {
  1585.  
  1586. new tmp[256];
  1587. new tmp2[256];
  1588. mysql_fetch_field_row(tmp,"name");
  1589. mysql_fetch_field_row(tmp2,"equip");
  1590. new equipped = strval(tmp2);
  1591. if(equipped) { format(tmp2,sizeof(tmp2),"Da"); } else { format(tmp2,sizeof(tmp2),"Nu"); }
  1592. format(clstr,sizeof(clstr),"Slot #%d: %s echipate: %s",count,tmp,tmp2);
  1593. SendClientMessage(playerid,COLOR_YELLOW2,clstr);
  1594. count ++;
  1595.  
  1596. }
  1597. SendClientMessage(playerid,COLOR_YELLOW2,"Foloseste /clothes equip [slot] pentru ati atasa accesoriile.");
  1598.  
  1599. }
  1600. else if(type == QUERY_EQUIPCLOTHING)
  1601. {
  1602.  
  1603. if(mysql_num_rows() > 0)
  1604. {
  1605.  
  1606. new count = 1;
  1607. while(mysql_retrieve_row())
  1608. {
  1609.  
  1610. if(count == cl_equipping[playerid])
  1611. {
  1612.  
  1613. new cl_results[11][64];
  1614. mysql_fetch_field_row(cl_results[0],"object");
  1615. mysql_fetch_field_row(cl_results[1],"x");
  1616. mysql_fetch_field_row(cl_results[2],"y");
  1617. mysql_fetch_field_row(cl_results[3],"z");
  1618. mysql_fetch_field_row(cl_results[4],"rx");
  1619. mysql_fetch_field_row(cl_results[5],"ry");
  1620. mysql_fetch_field_row(cl_results[6],"rz");
  1621. mysql_fetch_field_row(cl_results[7],"bone");
  1622. mysql_fetch_field_row(cl_results[8],"scalex");
  1623. mysql_fetch_field_row(cl_results[9],"scaley");
  1624. mysql_fetch_field_row(cl_results[10],"scalez");
  1625.  
  1626. new cl_result = cl_SetClothing(playerid,CLOTHING_PLAYER,strval(cl_results[0]),strval(cl_results[7]),floatstr(cl_results[1]),floatstr(cl_results[2]),floatstr(cl_results[3]),floatstr(cl_results[4]),floatstr(cl_results[5]),floatstr(cl_results[6]),floatstr(cl_results[8]),floatstr(cl_results[9]),floatstr(cl_results[10]));
  1627. if(cl_result) { SendClientMessage(playerid,COLOR_GREEN,"Clothing Equipped"); } else { SendClientMessage(playerid,COLOR_LIGHTRED,"Unable to equip clothing, you may have too many items equipped already."); }
  1628.  
  1629. new cl_query[256];
  1630. format(cl_query,sizeof(cl_query),"UPDATE rp_clothing SET equip = 1 WHERE owner = '%d'",CharacterInfo[playerid][active_character[playerid]][cID]);
  1631. mysql_query(cl_query,player_threads[playerid]);
  1632.  
  1633. }
  1634. count ++;
  1635.  
  1636. }
  1637.  
  1638. }
  1639. else
  1640. {
  1641.  
  1642. SendClientMessage(playerid,COLOR_LIGHTRED,"Nu ai nimic pe acest slot (/clothes list)");
  1643.  
  1644. }
  1645. cl_equipping[playerid] = 0;
  1646.  
  1647. }
  1648. else if(type == QUERY_AMMEND_LIST)
  1649. {
  1650.  
  1651. new cl_ammend_str[32];
  1652. new cl_ammend_menu[1024];
  1653. while(mysql_retrieve_row())
  1654. {
  1655.  
  1656. mysql_fetch_field_row(cl_ammend_str,"name");
  1657. new tmp[64];
  1658. format(tmp,sizeof(tmp),"%s\n",cl_ammend_str);
  1659. strins(cl_ammend_menu,tmp,strlen(cl_ammend_menu));
  1660.  
  1661. }
  1662. ShowPlayerDialog(playerid,DIALOG_AMMENDMENU,DIALOG_STYLE_LIST,"Te rog alege un accesoriu pentru al adauga",cl_ammend_menu,"Confirma","Anuleaza");
  1663.  
  1664. }
  1665. else if(type == QUERY_REQAMMEND)
  1666. {
  1667.  
  1668. new cl_req_result[32];
  1669. new cl_req_count = 0;
  1670. while(mysql_retrieve_row())
  1671. {
  1672.  
  1673. if(cl_req_count == cl_editingitem[playerid])
  1674. {
  1675.  
  1676. mysql_fetch_field_row(cl_req_result,"id");
  1677. cl_editinguid[playerid] = strval(cl_req_result);
  1678.  
  1679. new cl_req_results[12][64];
  1680. mysql_fetch_field_row(cl_req_results[0],"object");
  1681. mysql_fetch_field_row(cl_req_results[1],"x");
  1682. mysql_fetch_field_row(cl_req_results[2],"y");
  1683. mysql_fetch_field_row(cl_req_results[3],"z");
  1684. mysql_fetch_field_row(cl_req_results[4],"rx");
  1685. mysql_fetch_field_row(cl_req_results[5],"ry");
  1686. mysql_fetch_field_row(cl_req_results[6],"rz");
  1687. mysql_fetch_field_row(cl_req_results[7],"bone");
  1688. mysql_fetch_field_row(cl_req_results[8],"scalex");
  1689. mysql_fetch_field_row(cl_req_results[9],"scaley");
  1690. mysql_fetch_field_row(cl_req_results[10],"scalez");
  1691. mysql_fetch_field_row(cl_req_results[11],"type");
  1692. new cl_type = strval(cl_req_results[11]);
  1693.  
  1694. new Float:X, Float:Y, Float:Z, Float:X2, Float:Y2;
  1695. GetPlayerPos(playerid,X,Y,Z);
  1696. GetPosInFrontOfPlayer(playerid,X2,Y2,1.0);
  1697.  
  1698. cl_SetClothing(playerid,CLOTHING_PLAYER,strval(cl_req_results[0]),strval(cl_req_results[7]),floatstr(cl_req_results[1]),floatstr(cl_req_results[2]),floatstr(cl_req_results[3]),floatstr(cl_req_results[4]),floatstr(cl_req_results[5]),floatstr(cl_req_results[6]),floatstr(cl_req_results[8]),floatstr(cl_req_results[9]),floatstr(cl_req_results[10]));
  1699. new slot = cl_FetchObjectSlotFromObjectId(strval(cl_req_results[0]));
  1700. SetPlayerCameraPos(playerid,(X2 + cl_clothing_cams[cl_type][0]),(Y2 + cl_clothing_cams[cl_type][1]),(Z + cl_clothing_cams[cl_type][2]));
  1701. SetPlayerCameraLookAt(playerid,X,Y,(Z + cl_clothing_cams[cl_type][2]));
  1702. cl_SetPlayerAmmendingClothing(playerid,0,"cl_OnEditAmmendClothes",slot);
  1703.  
  1704. }
  1705. cl_req_count ++;
  1706.  
  1707. }
  1708.  
  1709. }
  1710. else if(type == QUERY_DRESS_PLAYER)
  1711. {
  1712.  
  1713. new cl_dress_count = 1;
  1714. while(mysql_retrieve_row())
  1715. {
  1716.  
  1717. new cl_eq_str[12][64];
  1718. mysql_fetch_field_row(cl_eq_str[0],"object");
  1719. mysql_fetch_field_row(cl_eq_str[1],"x");
  1720. mysql_fetch_field_row(cl_eq_str[2],"y");
  1721. mysql_fetch_field_row(cl_eq_str[3],"z");
  1722. mysql_fetch_field_row(cl_eq_str[4],"rx");
  1723. mysql_fetch_field_row(cl_eq_str[5],"ry");
  1724. mysql_fetch_field_row(cl_eq_str[6],"rz");
  1725. mysql_fetch_field_row(cl_eq_str[7],"bone");
  1726. mysql_fetch_field_row(cl_eq_str[8],"scalex");
  1727. mysql_fetch_field_row(cl_eq_str[9],"scaley");
  1728. mysql_fetch_field_row(cl_eq_str[10],"scalez");
  1729. mysql_fetch_field_row(cl_eq_str[11],"type");
  1730.  
  1731. cl_equipping[playerid] = cl_dress_count;
  1732.  
  1733. cl_SetClothing(playerid,CLOTHING_PLAYER,strval(cl_eq_str[0]),strval(cl_eq_str[7]),floatstr(cl_eq_str[1]),floatstr(cl_eq_str[2]),floatstr(cl_eq_str[3]),floatstr(cl_eq_str[4]),floatstr(cl_eq_str[5]),floatstr(cl_eq_str[6]),floatstr(cl_eq_str[8]),floatstr(cl_eq_str[9]),floatstr(cl_eq_str[10]));
  1734. cl_dress_count ++;
  1735.  
  1736. }
  1737.  
  1738. }
  1739. else if(type == QUERY_LOAD_PRISON)
  1740. {
  1741.  
  1742. new pr_i = 0;
  1743. new pr_str[256];
  1744. while(mysql_retrieve_row())
  1745. {
  1746.  
  1747. mysql_fetch_field_row(pr_str,"id");
  1748. PrisonInfo[pr_i][pID] = strval(pr_str);
  1749. mysql_fetch_field_row(pr_str,"owner");
  1750. PrisonInfo[pr_i][pOwner] = strval(pr_str);
  1751. mysql_fetch_field_row(pr_str,"expire");
  1752. PrisonInfo[pr_i][pExpire] = strval(pr_str);
  1753. pr_i ++;
  1754.  
  1755. }
  1756. print("Prisons Loaded.");
  1757.  
  1758. }
  1759. else if(type == QUERY_FETCH_TICKETS)
  1760. {
  1761.  
  1762. new ti_i = 1;
  1763. new ti_str[256];
  1764. SendClientMessage(playerid,COLOR_FACTION,"|_____Amenzile tale_____|");
  1765. while(mysql_retrieve_row())
  1766. {
  1767.  
  1768. new ti_tmp[3][128];
  1769. mysql_fetch_field_row(ti_str,"issuer");
  1770. format(ti_tmp[0],128,"Amenda #%d: De La: %s ",ti_i,ti_str);
  1771. mysql_fetch_field_row(ti_str,"amount");
  1772. format(ti_tmp[1],128,"Amount: $%s",ti_str);
  1773. format(ti_tmp[2],128,"%s %s",ti_tmp[0],ti_tmp[1]);
  1774. SendClientMessage(playerid,COLOR_FACTION,ti_tmp[2]);
  1775. ti_i ++;
  1776.  
  1777. }
  1778. SendClientMessage(playerid,COLOR_FACTION,"Foloseste /tickets pay [ticket #] cand esti in interiorul departamentului de sheriffi. Sau /ticket view [ticket #].");
  1779.  
  1780. }
  1781. else if(type == QUERY_VIEW_TICKETS)
  1782. {
  1783.  
  1784. new tv_i = 1;
  1785. new tv_done = 0;
  1786. new tv_str[128];
  1787. new tv_print[128];
  1788. while(mysql_retrieve_row())
  1789. {
  1790.  
  1791. if(tv_i == GetPVarInt(playerid,"ticket_slot"))
  1792. {
  1793.  
  1794. SendClientMessage(playerid,COLOR_FACTION,"|_____Informatie Amenda_____|");
  1795. mysql_fetch_field_row(tv_str,"stamp");
  1796. format(tv_print,sizeof(tv_print),"Data Eliberari: %s",tv_str);
  1797. SendClientMessage(playerid,COLOR_WHITE,tv_print);
  1798. mysql_fetch_field_row(tv_str,"issuer");
  1799. format(tv_print,sizeof(tv_print),"Descriere: %s",tv_str);
  1800. SendClientMessage(playerid,COLOR_WHITE,tv_print);
  1801. mysql_fetch_field_row(tv_str,"amount");
  1802. format(tv_print,sizeof(tv_print),"Pret Amenda: $%s",tv_str);
  1803. SendClientMessage(playerid,COLOR_WHITE,tv_print);
  1804. mysql_fetch_field_row(tv_str,"reason");
  1805. format(tv_print,sizeof(tv_print),"Motiv: %s",tv_str);
  1806. SendClientMessage(playerid,COLOR_WHITE,tv_print);
  1807. SendClientMessage(playerid,COLOR_FACTION,"------------------------------------");
  1808. tv_done = 1;
  1809.  
  1810. }
  1811. tv_i ++;
  1812.  
  1813. }
  1814. if(!tv_done) {
  1815.  
  1816. SendClientMessage(playerid,COLOR_LIGHTRED,"Nici o amenda pe acest slot.");
  1817.  
  1818. }
  1819.  
  1820. }
  1821. else if(type == QUERY_PAY_TICKET)
  1822. {
  1823.  
  1824. new tp_i = 1;
  1825. new tp_done = 0;
  1826. new tp_str[128];
  1827. while(mysql_retrieve_row())
  1828. {
  1829.  
  1830. if(tp_i == GetPVarInt(playerid,"ticket_slot"))
  1831. {
  1832.  
  1833. mysql_fetch_field_row(tp_str,"amount");
  1834. new amount = strval(tp_str);
  1835. if(amount > 1)
  1836. {
  1837.  
  1838. mysql_fetch_field_row(tp_str,"id");
  1839. new id = strval(tp_str);
  1840. if(id)
  1841. {
  1842.  
  1843. if(CharacterInfo[playerid][active_character[playerid]][cMoney] >= amount)
  1844. {
  1845.  
  1846. CharacterInfo[playerid][active_character[playerid]][cMoney] -= amount;
  1847. SendClientMessage(playerid,COLOR_FACTION,"Ai platit amenda.");
  1848. FactionInfo[0][fBank] += amount;
  1849. format(tp_str,sizeof(tp_str),"UPDATE rp_fines SET paid = 1 WHERE id = '%d'",id);
  1850. mysql_query(tp_str,player_threads[playerid]);
  1851.  
  1852. }
  1853. else
  1854. {
  1855.  
  1856. SendClientMessage(playerid,COLOR_LIGHTRED,"Nu ai destui bani.");
  1857.  
  1858. }
  1859.  
  1860. }
  1861.  
  1862. }
  1863. tp_done = 1;
  1864.  
  1865. }
  1866. tp_i ++;
  1867.  
  1868. }
  1869. if(!tp_done)
  1870. {
  1871.  
  1872. SendClientMessage(playerid,COLOR_LIGHTRED,"Invalid slot.");
  1873.  
  1874. }
  1875.  
  1876. }
  1877. else if(type == QUERY_MDC_FINE)
  1878. {
  1879.  
  1880. new fw_str[256];
  1881. while(mysql_retrieve_row())
  1882. {
  1883.  
  1884. new fw_tmp[128];
  1885. new fw_print[128];
  1886. mysql_fetch_field_row(fw_str,"stamp");
  1887. format(fw_tmp,sizeof(fw_tmp),"Date Issued: %s",fw_str);
  1888. mysql_fetch_field_row(fw_str,"reason");
  1889. format(fw_print,sizeof(fw_print),"AMENDA NEPLATITA, Motiv: %s, Emisa: %s",fw_tmp,fw_str);
  1890. SendClientMessage(playerid,COLOR_LIGHTRED,fw_print);
  1891.  
  1892. }
  1893.  
  1894. }
  1895. /*****END ON QUERY FINISH*******/
  1896.  
  1897. mysql_free_result();
  1898. return 1;
  1899.  
  1900. }[/pawn]
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!