API tools faq
paste
Guest User

Untitled

a guest
Apr 21st, 2014
119
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.56 KB | None | 0 0
raw download clone embed print report
  1. stock LoadProperty(Houseid)
  2. {
  3. new string[256] ,query[300];
  4.  
  5.  
  6. switch (CURRENT_GAMEMODE)
  7. {
  8.  
  9. case LOS_SANTOS:
  10. {
  11.  
  12. format(query, sizeof(query), "SELECT * FROM lshousedata WHERE Houseid = '%d'", Houseid);
  13. //We only select the variables that we want to use.
  14. mysql_query(query); //Queries the result
  15. mysql_store_result(); //Store a result because it's a SELECT statement.
  16.  
  17. if(mysql_num_rows() > 0) //If the houseid is found
  18. {
  19.  
  20. while(mysql_retrieve_row()) //it will be running until there are no more rows to be retrieved
  21. {
  22.  
  23. mysql_fetch_field_row(string, "OwnerName");
  24. strmid(HouseData[Houseid][h_OwnerName], string, 0, strlen(string), 256);
  25. //HouseInfo[Houseid][h_OwnerName] = strval(string);
  26.  
  27. mysql_fetch_field_row(string, "OwnerID");
  28. HouseData[Houseid][h_OwnerID] = strval(string);
  29.  
  30. mysql_fetch_field_row(string, "RenterName");
  31. strmid(HouseData[Houseid][h_RenterName], string, 0, strlen(string), 256);
  32. //HouseInfo[Houseid][h_RenterName] = strval(string);
  33.  
  34. mysql_fetch_field_row(string, "RenterID");
  35. HouseData[Houseid][h_RenterID] = strval(string);
  36.  
  37. mysql_fetch_field_row(string, "HouseName");
  38. strmid(HouseInfo[Houseid][h_HouseIntName], string, 0, strlen(string), 256);
  39. //HouseInfo[Houseid][h_HouseName] = strval(string);
  40.  
  41. mysql_fetch_field_row(string, "Value");
  42. HouseData[Houseid][h_Value] = strval(string);
  43.  
  44. mysql_fetch_field_row(string, "Rent");
  45. HouseData[Houseid][h_Rent] = strval(string);
  46.  
  47. mysql_fetch_field_row(string, "ForSale");
  48. HouseData[Houseid][h_ForSale] = strval(string);
  49.  
  50. mysql_fetch_field_row(string, "Alarm");
  51. HouseData[Houseid][h_Alarm] = strval(string);
  52.  
  53. mysql_fetch_field_row(string, "Lock");
  54. HouseData[Houseid][h_Lock] = strval(string);
  55.  
  56. mysql_fetch_field_row(string, "Money");
  57. HouseData[Houseid][h_Money] = strval(string);
  58.  
  59. mysql_fetch_field_row(string, "Drugs");
  60. HouseData[Houseid][h_Drugs] = strval(string);
  61.  
  62. mysql_fetch_field_row(string, "Condoms");
  63. HouseData[Houseid][h_Condoms] = strval(string);
  64.  
  65. mysql_fetch_field_row(string, "Flowers");
  66. HouseData[Houseid][h_Flowers] = strval(string);
  67.  
  68. mysql_fetch_field_row(string, "Robberies");
  69. HouseData[Houseid][h_Robberies] = strval(string);
  70.  
  71. mysql_fetch_field_row(string, "Breakins");
  72. HouseData[Houseid][h_Breakins] = strval(string);
  73.  
  74. mysql_fetch_field_row(string, "OwnerVisits");
  75. HouseData[Houseid][h_OwnerVisits] = strval(string);
  76.  
  77. mysql_fetch_field_row(string, "OtherVisits");
  78. HouseData[Houseid][h_OtherVisits] = strval(string);
  79.  
  80. mysql_fetch_field_row(string, "Purchasers");
  81. HouseData[Houseid][h_Purchasers] = strval(string);
  82.  
  83. mysql_fetch_field_row(string, "Rented");
  84. HouseData[Houseid][h_Rented] = strval(string);
  85. }
  86.  
  87. }
  88. }
  89.  
  90. case LAS_VENTURAS:
  91. {
  92.  
  93. format(query, sizeof(query), "SELECT * FROM lvhousedata WHERE Houseid = '%d'", Houseid);
  94. //We only select the variables that we want to use.
  95. mysql_query(query); //Queries the result
  96. mysql_store_result(); //Store a result because it's a SELECT statement.
  97.  
  98. if(mysql_num_rows() > 0) //If the houseid is found
  99. {
  100.  
  101. while(mysql_retrieve_row()) //it will be running until there are no more rows to be retrieved
  102. {
  103.  
  104. mysql_fetch_field_row(string, "OwnerName");
  105. strmid(HouseData[Houseid][h_OwnerName], string, 0, strlen(string), 256);
  106. //HouseInfo[Houseid][h_OwnerName] = strval(string);
  107.  
  108. mysql_fetch_field_row(string, "OwnerID");
  109. HouseData[Houseid][h_OwnerID] = strval(string);
  110.  
  111. mysql_fetch_field_row(string, "RenterName");
  112. strmid(HouseData[Houseid][h_RenterName], string, 0, strlen(string), 256);
  113. //HouseInfo[Houseid][h_RenterName] = strval(string);
  114.  
  115. mysql_fetch_field_row(string, "RenterID");
  116. HouseData[Houseid][h_RenterID] = strval(string);
  117.  
  118. mysql_fetch_field_row(string, "HouseName");
  119. strmid(HouseInfo[Houseid][h_HouseIntName], string, 0, strlen(string), 256);
  120. //HouseInfo[Houseid][h_HouseName] = strval(string);
  121.  
  122. mysql_fetch_field_row(string, "Value");
  123. HouseData[Houseid][h_Value] = strval(string);
  124.  
  125. mysql_fetch_field_row(string, "Rent");
  126. HouseData[Houseid][h_Rent] = strval(string);
  127.  
  128. mysql_fetch_field_row(string, "ForSale");
  129. HouseData[Houseid][h_ForSale] = strval(string);
  130.  
  131. mysql_fetch_field_row(string, "Alarm");
  132. HouseData[Houseid][h_Alarm] = strval(string);
  133.  
  134. mysql_fetch_field_row(string, "Lock");
  135. HouseData[Houseid][h_Lock] = strval(string);
  136.  
  137. mysql_fetch_field_row(string, "Money");
  138. HouseData[Houseid][h_Money] = strval(string);
  139.  
  140. mysql_fetch_field_row(string, "Drugs");
  141. HouseData[Houseid][h_Drugs] = strval(string);
  142.  
  143. mysql_fetch_field_row(string, "Condoms");
  144. HouseData[Houseid][h_Condoms] = strval(string);
  145.  
  146. mysql_fetch_field_row(string, "Flowers");
  147. HouseData[Houseid][h_Flowers] = strval(string);
  148.  
  149. mysql_fetch_field_row(string, "Robberies");
  150. HouseData[Houseid][h_Robberies] = strval(string);
  151.  
  152. mysql_fetch_field_row(string, "Breakins");
  153. HouseData[Houseid][h_Breakins] = strval(string);
  154.  
  155. mysql_fetch_field_row(string, "OwnerVisits");
  156. HouseData[Houseid][h_OwnerVisits] = strval(string);
  157.  
  158. mysql_fetch_field_row(string, "OtherVisits");
  159. HouseData[Houseid][h_OtherVisits] = strval(string);
  160.  
  161. mysql_fetch_field_row(string, "Purchasers");
  162. HouseData[Houseid][h_Purchasers] = strval(string);
  163.  
  164. mysql_fetch_field_row(string, "Rented");
  165. HouseData[Houseid][h_Rented] = strval(string);
  166.  
  167.  
  168. }
  169.  
  170. }
  171.  
  172. }
  173.  
  174. case SAN_FIERRO:
  175. {
  176.  
  177. format(query, sizeof(query), "SELECT * FROM sfhousedata WHERE Houseid = '%d'", Houseid);
  178. //We only select the variables that we want to use.
  179. mysql_query(query); //Queries the result
  180. mysql_store_result(); //Store a result because it's a SELECT statement.
  181.  
  182. if(mysql_num_rows() > 0) //If the houseid is found
  183. {
  184.  
  185. while(mysql_retrieve_row()) //it will be running until there are no more rows to be retrieved
  186. {
  187.  
  188. //We use while so that it does a single query, not multiple
  189. //Especially when we have more variables. If there is more
  190. //Variables, you should just split the line with sscanf. To
  191. //Make it easier.
  192.  
  193. mysql_fetch_field_row(string, "OwnerName");
  194. strmid(HouseData[Houseid][h_OwnerName], string, 0, strlen(string), 256);
  195. //HouseInfo[Houseid][h_OwnerName] = strval(string);
  196.  
  197. mysql_fetch_field_row(string, "OwnerID");
  198. HouseData[Houseid][h_OwnerID] = strval(string);
  199.  
  200. mysql_fetch_field_row(string, "RenterName");
  201. strmid(HouseData[Houseid][h_RenterName], string, 0, strlen(string), 256);
  202. //HouseInfo[Houseid][h_RenterName] = strval(string);
  203.  
  204. mysql_fetch_field_row(string, "RenterID");
  205. HouseData[Houseid][h_RenterID] = strval(string);
  206.  
  207. mysql_fetch_field_row(string, "HouseName");
  208. strmid(HouseInfo[Houseid][h_HouseIntName], string, 0, strlen(string), 256);
  209. //HouseInfo[Houseid][h_HouseName] = strval(string);
  210.  
  211. mysql_fetch_field_row(string, "Value");
  212. HouseData[Houseid][h_Value] = strval(string);
  213.  
  214. mysql_fetch_field_row(string, "Rent");
  215. HouseData[Houseid][h_Rent] = strval(string);
  216.  
  217. mysql_fetch_field_row(string, "ForSale");
  218. HouseData[Houseid][h_ForSale] = strval(string);
  219.  
  220. mysql_fetch_field_row(string, "Alarm");
  221. HouseData[Houseid][h_Alarm] = strval(string);
  222.  
  223. mysql_fetch_field_row(string, "Lock");
  224. HouseData[Houseid][h_Lock] = strval(string);
  225.  
  226. mysql_fetch_field_row(string, "Money");
  227. HouseData[Houseid][h_Money] = strval(string);
  228.  
  229. mysql_fetch_field_row(string, "Drugs");
  230. HouseData[Houseid][h_Drugs] = strval(string);
  231.  
  232. mysql_fetch_field_row(string, "Condoms");
  233. HouseData[Houseid][h_Condoms] = strval(string);
  234.  
  235. mysql_fetch_field_row(string, "Flowers");
  236. HouseData[Houseid][h_Flowers] = strval(string);
  237.  
  238. mysql_fetch_field_row(string, "Robberies");
  239. HouseData[Houseid][h_Robberies] = strval(string);
  240.  
  241. mysql_fetch_field_row(string, "Breakins");
  242. HouseData[Houseid][h_Breakins] = strval(string);
  243.  
  244. mysql_fetch_field_row(string, "OwnerVisits");
  245. HouseData[Houseid][h_OwnerVisits] = strval(string);
  246.  
  247. mysql_fetch_field_row(string, "OtherVisits");
  248. HouseData[Houseid][h_OtherVisits] = strval(string);
  249.  
  250. mysql_fetch_field_row(string, "Purchasers");
  251. HouseData[Houseid][h_Purchasers] = strval(string);
  252.  
  253. mysql_fetch_field_row(string, "Rented");
  254. HouseData[Houseid][h_Rented] = strval(string);
  255.  
  256.  
  257. //mysql_fetch_field_row requires a string.
  258. }
  259.  
  260. }
  261.  
  262. }
  263.  
  264.  
  265.  
  266.  
  267. }//End Of Switch
  268.  
  269. mysql_free_result(); //We must always free a stored result
  270. return 1;
  271. }
  272. //==============================================================================
  273. stock SaveProperty(Houseid)
  274. {
  275. new query[300];
  276.  
  277. switch (CURRENT_GAMEMODE)
  278. {
  279.  
  280. case LOS_SANTOS:
  281. {
  282. format(query, sizeof(query), "SELECT * FROM lshousedata WHERE Houseid = '%d'", Houseid);
  283. mysql_query(query); //Queries the result
  284. mysql_store_result(); //Store a result because it's a SELECT statement.
  285.  
  286. if(mysql_num_rows() == 0) //If the houseid is not found
  287. {
  288.  
  289. if (CREATE_PLAYER_DATABASE == 1)
  290. {
  291.  
  292. format(query, sizeof(query), "INSERT INTO lshousedata (Houseid) VALUES ('%d')",Houseid); //Insert string
  293. mysql_query(query);
  294.  
  295. }else{
  296.  
  297. mysql_query("ALTER TABLE lshousedata ADD OwnerName VARCHAR(128) NOT NULL default 'The Bank'");
  298. mysql_query("ALTER TABLE lshousedata ADD OwnerID INT(11) NOT NULL default -1");
  299. mysql_query("ALTER TABLE lshousedata ADD RenterName VARCHAR(128) NOT NULL default 'None'");
  300. mysql_query("ALTER TABLE lshousedata ADD RenterID INT(11) NOT NULL default -1");
  301. mysql_query("ALTER TABLE lshousedata ADD HouseName VARCHAR(128) NOT NULL default 'House'");
  302. mysql_query("ALTER TABLE lshousedata ADD Value INT(11) NOT NULL default 200000");
  303. mysql_query("ALTER TABLE lshousedata ADD Rent INT(11) NOT NULL default 0");
  304. mysql_query("ALTER TABLE lshousedata ADD ForSale INT(11) NOT NULL default 0");
  305. mysql_query("ALTER TABLE lshousedata ADD Alarm INT(11) NOT NULL default 0");
  306. mysql_query("ALTER TABLE lshousedata ADD Lock INT(11) NOT NULL default 0");
  307. mysql_query("ALTER TABLE lshousedata ADD Money INT(11) NOT NULL default 0");
  308. mysql_query("ALTER TABLE lshousedata ADD Drugs INT(11) NOT NULL default 0");
  309. mysql_query("ALTER TABLE lshousedata ADD Condoms INT(11) NOT NULL default 0");
  310. mysql_query("ALTER TABLE lshousedata ADD Flowers INT(11) NOT NULL default 0");
  311. mysql_query("ALTER TABLE lshousedata ADD Robberies INT(11) NOT NULL default 0");
  312. mysql_query("ALTER TABLE lshousedata ADD Breakins INT(11) NOT NULL default 0");
  313. mysql_query("ALTER TABLE lshousedata ADD OwnerVisits INT(11) NOT NULL default 0");
  314. mysql_query("ALTER TABLE lshousedata ADD OtherVisits INT(11) NOT NULL default 0");
  315. mysql_query("ALTER TABLE lshousedata ADD Purchasers INT(11) NOT NULL default 0");
  316. mysql_query("ALTER TABLE lshousedata ADD Rented INT(11) NOT NULL default 0");
  317.  
  318. }
  319.  
  320.  
  321. }else{
  322.  
  323.  
  324. format(query, sizeof(query), "UPDATE lshousedata SET OwnerName = '%s' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerName],Houseid);
  325. mysql_query(query);
  326.  
  327. format(query, sizeof(query), "UPDATE lshousedata SET OwnerID = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerID],Houseid);
  328. mysql_query(query);
  329.  
  330. format(query, sizeof(query), "UPDATE lshousedata SET RenterName = '%s' WHERE Houseid = '%d'",HouseData[Houseid][h_RenterName],Houseid);
  331. mysql_query(query);
  332.  
  333. format(query, sizeof(query), "UPDATE lshousedata SET RenterID = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_RenterID],Houseid);
  334. mysql_query(query);
  335.  
  336. format(query, sizeof(query), "UPDATE lshousedata SET HouseName = '%s' WHERE Houseid = '%s'",HouseInfo[Houseid][h_HouseIntName],Houseid);
  337. mysql_query(query);
  338.  
  339. format(query, sizeof(query), "UPDATE lshousedata SET Value = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Value],Houseid);
  340. mysql_query(query);
  341.  
  342. format(query, sizeof(query), "UPDATE lshousedata SET Rent = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Rent],Houseid);
  343. mysql_query(query);
  344.  
  345. format(query, sizeof(query), "UPDATE lshousedata SET ForSale = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_ForSale],Houseid);
  346. mysql_query(query);
  347.  
  348. format(query, sizeof(query), "UPDATE lshousedata SET Alarm = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Alarm],Houseid);
  349. mysql_query(query);
  350.  
  351. format(query, sizeof(query), "UPDATE lshousedata SET Lock = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Lock],Houseid);
  352. mysql_query(query);
  353.  
  354. format(query, sizeof(query), "UPDATE lshousedata SET Money = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Money],Houseid);
  355. mysql_query(query);
  356.  
  357. format(query, sizeof(query), "UPDATE lshousedata SET Drugs = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Drugs],Houseid);
  358. mysql_query(query);
  359.  
  360. format(query, sizeof(query), "UPDATE lshousedata SET Condoms = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Condoms],Houseid);
  361. mysql_query(query);
  362.  
  363. format(query, sizeof(query), "UPDATE lshousedata SET Flowers = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Flowers],Houseid);
  364. mysql_query(query);
  365.  
  366. format(query, sizeof(query), "UPDATE lshousedata SET Robberies = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Robberies],Houseid);
  367. mysql_query(query);
  368.  
  369. format(query, sizeof(query), "UPDATE lshousedata SET Breakins = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Breakins],Houseid);
  370. mysql_query(query);
  371.  
  372. format(query, sizeof(query), "UPDATE lshousedata SET OwnerVisits = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerVisits],Houseid);
  373. mysql_query(query);
  374.  
  375. format(query, sizeof(query), "UPDATE lshousedata SET OtherVisits = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OtherVisits],Houseid);
  376. mysql_query(query);
  377.  
  378. format(query, sizeof(query), "UPDATE lshousedata SET Purchasers = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Purchasers],Houseid);
  379. mysql_query(query);
  380.  
  381. format(query, sizeof(query), "UPDATE lshousedata SET Rented = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Rented],Houseid);
  382. mysql_query(query);
  383.  
  384. }
  385.  
  386. }
  387.  
  388.  
  389. case LAS_VENTURAS:
  390. {
  391. format(query, sizeof(query), "SELECT * FROM lvhousedata WHERE Houseid = '%d'", Houseid);
  392. mysql_query(query); //Queries the result
  393. mysql_store_result(); //Store a result because it's a SELECT statement.
  394.  
  395. if(mysql_num_rows() == 0) //If the houseid is not found
  396. {
  397.  
  398. if (CREATE_PLAYER_DATABASE == 1)
  399. {
  400.  
  401. format(query, sizeof(query), "INSERT INTO lvhousedata (Houseid) VALUES ('%d')",Houseid); //Insert string
  402. mysql_query(query);
  403.  
  404. }else{
  405.  
  406. mysql_query("ALTER TABLE lvhousedata ADD OwnerName VARCHAR(128) NOT NULL default 'The Bank'");
  407. mysql_query("ALTER TABLE lvhousedata ADD OwnerID INT(11) NOT NULL default -1");
  408. mysql_query("ALTER TABLE lvhousedata ADD RenterName VARCHAR(128) NOT NULL default 'None'");
  409. mysql_query("ALTER TABLE lvhousedata ADD RenterID INT(11) NOT NULL default -1");
  410. mysql_query("ALTER TABLE lvhousedata ADD HouseName VARCHAR(128) NOT NULL default 'House'");
  411. mysql_query("ALTER TABLE lvhousedata ADD Value INT(11) NOT NULL default 200000");
  412. mysql_query("ALTER TABLE lvhousedata ADD Rent INT(11) NOT NULL default 0");
  413. mysql_query("ALTER TABLE lvhousedata ADD ForSale INT(11) NOT NULL default 0");
  414. mysql_query("ALTER TABLE lvhousedata ADD Alarm INT(11) NOT NULL default 0");
  415. mysql_query("ALTER TABLE lvhousedata ADD Lock INT(11) NOT NULL default 0");
  416. mysql_query("ALTER TABLE lvhousedata ADD Money INT(11) NOT NULL default 0");
  417. mysql_query("ALTER TABLE lvhousedata ADD Drugs INT(11) NOT NULL default 0");
  418. mysql_query("ALTER TABLE lvhousedata ADD Condoms INT(11) NOT NULL default 0");
  419. mysql_query("ALTER TABLE lvhousedata ADD Flowers INT(11) NOT NULL default 0");
  420. mysql_query("ALTER TABLE lvhousedata ADD Robberies INT(11) NOT NULL default 0");
  421. mysql_query("ALTER TABLE lvhousedata ADD Breakins INT(11) NOT NULL default 0");
  422. mysql_query("ALTER TABLE lvhousedata ADD OwnerVisits INT(11) NOT NULL default 0");
  423. mysql_query("ALTER TABLE lvhousedata ADD OtherVisits INT(11) NOT NULL default 0");
  424. mysql_query("ALTER TABLE lvhousedata ADD Purchasers INT(11) NOT NULL default 0");
  425. mysql_query("ALTER TABLE lvhousedata ADD Rented INT(11) NOT NULL default 0");
  426.  
  427. }
  428.  
  429.  
  430. }else{
  431.  
  432. format(query, sizeof(query), "UPDATE lvhousedata SET OwnerName = '%s' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerName],Houseid);
  433. mysql_query(query);
  434.  
  435. format(query, sizeof(query), "UPDATE lvhousedata SET OwnerID = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerID],Houseid);
  436. mysql_query(query);
  437.  
  438. format(query, sizeof(query), "UPDATE lvhousedata SET RenterName = '%s' WHERE Houseid = '%d'",HouseData[Houseid][h_RenterName],Houseid);
  439. mysql_query(query);
  440.  
  441. format(query, sizeof(query), "UPDATE lvhousedata SET RenterID = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_RenterID],Houseid);
  442. mysql_query(query);
  443.  
  444. format(query, sizeof(query), "UPDATE lvhousedata SET HouseName = '%s' WHERE Houseid = '%s'",HouseInfo[Houseid][h_HouseIntName],Houseid);
  445. mysql_query(query);
  446.  
  447. format(query, sizeof(query), "UPDATE lvhousedata SET Value = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Value],Houseid);
  448. mysql_query(query);
  449.  
  450. format(query, sizeof(query), "UPDATE lvhousedata SET Rent = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Rent],Houseid);
  451. mysql_query(query);
  452.  
  453. format(query, sizeof(query), "UPDATE lvhousedata SET ForSale = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_ForSale],Houseid);
  454. mysql_query(query);
  455.  
  456. format(query, sizeof(query), "UPDATE lvhousedata SET Alarm = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Alarm],Houseid);
  457. mysql_query(query);
  458.  
  459. format(query, sizeof(query), "UPDATE lvhousedata SET Lock = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Lock],Houseid);
  460. mysql_query(query);
  461.  
  462. format(query, sizeof(query), "UPDATE lvhousedata SET Money = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Money],Houseid);
  463. mysql_query(query);
  464.  
  465. format(query, sizeof(query), "UPDATE lvhousedata SET Drugs = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Drugs],Houseid);
  466. mysql_query(query);
  467.  
  468. format(query, sizeof(query), "UPDATE lvhousedata SET Condoms = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Condoms],Houseid);
  469. mysql_query(query);
  470.  
  471. format(query, sizeof(query), "UPDATE lvhousedata SET Flowers = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Flowers],Houseid);
  472. mysql_query(query);
  473.  
  474. format(query, sizeof(query), "UPDATE lvhousedata SET Robberies = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Robberies],Houseid);
  475. mysql_query(query);
  476.  
  477. format(query, sizeof(query), "UPDATE lvhousedata SET Breakins = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Breakins],Houseid);
  478. mysql_query(query);
  479.  
  480. format(query, sizeof(query), "UPDATE lvhousedata SET OwnerVisits = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerVisits],Houseid);
  481. mysql_query(query);
  482.  
  483. format(query, sizeof(query), "UPDATE lvhousedata SET OtherVisits = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OtherVisits],Houseid);
  484. mysql_query(query);
  485.  
  486. format(query, sizeof(query), "UPDATE lvhousedata SET Purchasers = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Purchasers],Houseid);
  487. mysql_query(query);
  488.  
  489. format(query, sizeof(query), "UPDATE lvhousedata SET Rented = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Rented],Houseid);
  490. mysql_query(query);
  491.  
  492. }
  493.  
  494. }
  495.  
  496.  
  497.  
  498. case SAN_FIERRO:
  499. {
  500. format(query, sizeof(query), "SELECT * FROM sfhousedata WHERE Houseid = '%d'", Houseid);
  501. mysql_query(query); //Queries the result
  502. mysql_store_result(); //Store a result because it's a SELECT statement.
  503.  
  504. if(mysql_num_rows() == 0) //If the houseid is not found
  505. {
  506.  
  507.  
  508. if (CREATE_PLAYER_DATABASE == 1)
  509. {
  510.  
  511. format(query, sizeof(query), "INSERT INTO sfhousedata (Houseid) VALUES ('%d')",Houseid); //Insert string
  512. mysql_query(query);
  513.  
  514. }else{
  515.  
  516. mysql_query("ALTER TABLE sfhousedata ADD OwnerName VARCHAR(128) NOT NULL default 'The Bank'");
  517. mysql_query("ALTER TABLE sfhousedata ADD OwnerID INT(11) NOT NULL default -1");
  518. mysql_query("ALTER TABLE sfhousedata ADD RenterName VARCHAR(128) NOT NULL default 'None'");
  519. mysql_query("ALTER TABLE sfhousedata ADD RenterID INT(11) NOT NULL default -1");
  520. mysql_query("ALTER TABLE sfhousedata ADD HouseName VARCHAR(128) NOT NULL default 'House'");
  521. mysql_query("ALTER TABLE sfhousedata ADD Value INT(11) NOT NULL default 200000");
  522. mysql_query("ALTER TABLE sfhousedata ADD Rent INT(11) NOT NULL default 0");
  523. mysql_query("ALTER TABLE sfhousedata ADD ForSale INT(11) NOT NULL default 0");
  524. mysql_query("ALTER TABLE sfhousedata ADD Alarm INT(11) NOT NULL default 0");
  525. mysql_query("ALTER TABLE sfhousedata ADD Lock INT(11) NOT NULL default 0");
  526. mysql_query("ALTER TABLE sfhousedata ADD Money INT(11) NOT NULL default 0");
  527. mysql_query("ALTER TABLE sfhousedata ADD Drugs INT(11) NOT NULL default 0");
  528. mysql_query("ALTER TABLE sfhousedata ADD Condoms INT(11) NOT NULL default 0");
  529. mysql_query("ALTER TABLE sfhousedata ADD Flowers INT(11) NOT NULL default 0");
  530. mysql_query("ALTER TABLE sfhousedata ADD Robberies INT(11) NOT NULL default 0");
  531. mysql_query("ALTER TABLE sfhousedata ADD Breakins INT(11) NOT NULL default 0");
  532. mysql_query("ALTER TABLE sfhousedata ADD OwnerVisits INT(11) NOT NULL default 0");
  533. mysql_query("ALTER TABLE sfhousedata ADD OtherVisits INT(11) NOT NULL default 0");
  534. mysql_query("ALTER TABLE sfhousedata ADD Purchasers INT(11) NOT NULL default 0");
  535. mysql_query("ALTER TABLE sfhousedata ADD Rented INT(11) NOT NULL default 0");
  536.  
  537. }
  538.  
  539. }else{
  540.  
  541.  
  542. format(query, sizeof(query), "UPDATE sfhousedata SET OwnerName = '%s' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerName],Houseid);
  543. mysql_query(query);
  544.  
  545. format(query, sizeof(query), "UPDATE sfhousedata SET OwnerID = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerID],Houseid);
  546. mysql_query(query);
  547.  
  548. format(query, sizeof(query), "UPDATE sfhousedata SET RenterName = '%s' WHERE Houseid = '%d'",HouseData[Houseid][h_RenterName],Houseid);
  549. mysql_query(query);
  550.  
  551. format(query, sizeof(query), "UPDATE sfhousedata SET RenterID = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_RenterID],Houseid);
  552. mysql_query(query);
  553.  
  554. format(query, sizeof(query), "UPDATE sfhousedata SET HouseName = '%s' WHERE Houseid = '%s'",HouseInfo[Houseid][h_HouseIntName],Houseid);
  555. mysql_query(query);
  556.  
  557. format(query, sizeof(query), "UPDATE sfhousedata SET Value = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Value],Houseid);
  558. mysql_query(query);
  559.  
  560. format(query, sizeof(query), "UPDATE sfhousedata SET Rent = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Rent],Houseid);
  561. mysql_query(query);
  562.  
  563. format(query, sizeof(query), "UPDATE sfhousedata SET ForSale = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_ForSale],Houseid);
  564. mysql_query(query);
  565.  
  566. format(query, sizeof(query), "UPDATE sfhousedata SET Alarm = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Alarm],Houseid);
  567. mysql_query(query);
  568.  
  569. format(query, sizeof(query), "UPDATE sfhousedata SET Lock = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Lock],Houseid);
  570. mysql_query(query);
  571.  
  572. format(query, sizeof(query), "UPDATE sfhousedata SET Money = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Money],Houseid);
  573. mysql_query(query);
  574.  
  575. format(query, sizeof(query), "UPDATE sfhousedata SET Drugs = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Drugs],Houseid);
  576. mysql_query(query);
  577.  
  578. format(query, sizeof(query), "UPDATE sfhousedata SET Condoms = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Condoms],Houseid);
  579. mysql_query(query);
  580.  
  581. format(query, sizeof(query), "UPDATE sfhousedata SET Flowers = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Flowers],Houseid);
  582. mysql_query(query);
  583.  
  584. format(query, sizeof(query), "UPDATE sfhousedata SET Robberies = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Robberies],Houseid);
  585. mysql_query(query);
  586.  
  587. format(query, sizeof(query), "UPDATE sfhousedata SET Breakins = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Breakins],Houseid);
  588. mysql_query(query);
  589.  
  590. format(query, sizeof(query), "UPDATE sfhousedata SET OwnerVisits = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OwnerVisits],Houseid);
  591. mysql_query(query);
  592.  
  593. format(query, sizeof(query), "UPDATE sfhousedata SET OtherVisits = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_OtherVisits],Houseid);
  594. mysql_query(query);
  595.  
  596. format(query, sizeof(query), "UPDATE sfhousedata SET Purchasers = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Purchasers],Houseid);
  597. mysql_query(query);
  598.  
  599. format(query, sizeof(query), "UPDATE sfhousedata SET Rented = '%d' WHERE Houseid = '%d'",HouseData[Houseid][h_Rented],Houseid);
  600. mysql_query(query);
  601.  
  602.  
  603.  
  604. }
  605.  
  606. }
  607.  
  608.  
  609. }//End Of Switch
  610.  
  611. mysql_free_result(); //Frees the result
  612.  
  613. return 1;
  614. }
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!