agent911

Untitled

Mar 10th, 2018
2,108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
INI file 29.55 KB | None | 0 0
  1. [Default]
  2. Version = 12
  3. Number of Inputs = 0
  4. Sanitize Input Value Check = false
  5. Sanitize Output Value Check = false
  6. Prepared Statement Cache = true
  7. Return InsertID = false
  8. Strip = true
  9. Strip Chars Action = STRIP
  10. Strip Chars = \/\|;{}<>\'
  11. Strip Custom Chars = \/\|;{}<>\'
  12.  
  13. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  14. ;; Account related queries
  15. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  16.  
  17. [isKnownAccount]
  18. SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END
  19. Number of Inputs = 1
  20. SQL1_INPUTS = 1
  21. OUTPUT = 1
  22.  
  23. [createAccount]
  24. SQL1_1 = INSERT INTO account SET uid = ?, name = ?
  25. Number Of Inputs = 2
  26. SQL1_INPUTS = 1,2
  27.  
  28. [startAccountSession]
  29. SQL1_1 = UPDATE account SET name = ?, last_connect_at = NOW(), total_connections = total_connections + 1 WHERE uid = ?
  30. Number Of Inputs = 2
  31. SQL1_INPUTS = 2,1
  32.  
  33. [endAccountSession]
  34. SQL1_1 = UPDATE account SET last_disconnect_at = NOW() WHERE uid = ?
  35. Number Of Inputs = 1
  36. SQL1_INPUTS = 1
  37.  
  38. [getAccountStats]
  39. SQL1_1 = SELECT score, kills, deaths, clan_id, locker FROM account WHERE uid = ?
  40. Number of Inputs = 1
  41. SQL1_INPUTS = 1
  42. OUTPUT = 1,2,3,4,5
  43.  
  44. [addAccountKill]
  45. SQL1_1 = UPDATE account SET kills = kills + 1 WHERE uid = ?
  46. Number Of Inputs = 1
  47. SQL1_INPUTS = 1
  48.  
  49. [addAccountDeath]
  50. SQL1_1 = UPDATE account SET deaths = deaths + 1 WHERE uid = ?
  51. Number Of Inputs = 1
  52. SQL1_INPUTS = 1
  53.  
  54. [getAccountScore]
  55. SQL1_1 = SELECT score FROM account WHERE uid = ?
  56. Number of Inputs = 1
  57. SQL1_INPUTS = 1
  58. OUTPUT = 1
  59.  
  60. [setAccountScore]
  61. SQL1_1 = UPDATE account SET score = ? WHERE uid = ?
  62. Number of Inputs = 2
  63. SQL1_INPUTS = 1,2
  64.  
  65. [modifyAccountScore]
  66. SQL1_1 = UPDATE account SET score = score + ? WHERE uid = ?
  67. Number of Inputs = 2
  68. SQL1_INPUTS = 1,2
  69.  
  70. [updateLocker]
  71. SQL1_1 = UPDATE account SET locker = ? WHERE uid = ?
  72. Number of Inputs = 2
  73. SQL1_INPUTS = 1,2
  74.  
  75. [getLocker]
  76. SQL1_1 = SELECT locker FROM account WHERE uid = ?
  77. Number of Inputs = 1
  78. SQL1_INPUTS = 1
  79. OUTPUT = 1
  80.  
  81. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  82. ;; Player related queries
  83. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  84.  
  85. [hasAlivePlayer]
  86. SQL1_1 = SELECT CASE WHEN EXISTS(SELECT account_uid FROM player WHERE account_uid = ? AND damage < 1) THEN 'true' ELSE 'false' END
  87. Number of Inputs = 1
  88. SQL1_INPUTS = 1
  89. OUTPUT = 1
  90.  
  91. [createPlayer]
  92. SQL1_1 = INSERT INTO player SET account_uid = ?, name = ?
  93. Number Of Inputs = 2
  94. SQL1_INPUTS = 1,2
  95. Return InsertID = true
  96.  
  97. [insertPlayerHistory]
  98. SQL1_1 = INSERT INTO player_history SET account_uid = ?, name = ?, position_x = ?, position_y = ?, position_z = ?
  99. Number Of Inputs = 5
  100. SQL1_INPUTS = 1,2,3,4,5
  101.  
  102. [deletePlayer]
  103. SQL1_1 = DELETE FROM player WHERE id = ?
  104. Number Of Inputs = 1
  105. SQL1_INPUTS = 1
  106.  
  107. [loadPlayer]
  108. SQL1_1 = SELECT p.id,
  109. SQL1_2 = p.name,
  110. SQL1_3 = p.account_uid,
  111. SQL1_4 = p.damage,
  112. SQL1_5 = p.hunger,
  113. SQL1_6 = p.thirst,
  114. SQL1_7 = p.alcohol,
  115. SQL1_8 = p.oxygen_remaining,
  116. SQL1_9 = p.bleeding_remaining,
  117. SQL1_10 = p.hitpoints,
  118. SQL1_11 = p.direction,
  119. SQL1_12 = p.position_x,
  120. SQL1_13 = p.position_y,
  121. SQL1_14 = p.position_z,
  122. SQL1_15 = p.assigned_items,
  123. SQL1_16 = p.backpack,
  124. SQL1_17 = p.backpack_items,
  125. SQL1_18 = p.backpack_magazines,
  126. SQL1_19 = p.backpack_weapons,
  127. SQL1_20 = p.current_weapon,
  128. SQL1_21 = p.goggles,
  129. SQL1_22 = p.handgun_items,
  130. SQL1_23 = p.handgun_weapon,
  131. SQL1_24 = p.headgear,
  132. SQL1_25 = p.binocular,
  133. SQL1_26 = p.loaded_magazines,
  134. SQL1_27 = p.primary_weapon,
  135. SQL1_28 = p.primary_weapon_items,
  136. SQL1_29 = p.secondary_weapon,
  137. SQL1_30 = p.secondary_weapon_items,
  138. SQL1_31 = p.uniform,
  139. SQL1_32 = p.uniform_items,
  140. SQL1_33 = p.uniform_magazines,
  141. SQL1_34 = p.uniform_weapons,
  142. SQL1_35 = p.vest,
  143. SQL1_36 = p.vest_items,
  144. SQL1_37 = p.vest_magazines,
  145. SQL1_38 = p.vest_weapons,
  146. SQL1_39 = p.money,
  147. SQL1_40 = a.score,
  148. SQL1_41 = a.kills,
  149. SQL1_42 = a.deaths,
  150. SQL1_43 = c.id,
  151. SQL1_44 = c.name,
  152. SQL1_45 = p.temperature,
  153. SQL1_46 = p.wetness,
  154. SQL1_47 = a.locker
  155. SQL1_48 = FROM player p
  156. SQL1_49 = INNER JOIN account a
  157. SQL1_50 = ON a.uid = p.account_uid
  158. SQL1_51 = LEFT JOIN clan c
  159. SQL1_52 = ON c.id = a.clan_id
  160. SQL1_53 = WHERE p.account_uid = ?
  161. Number of Inputs = 1
  162. SQL1_INPUTS = 1
  163. OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16-STRING,17,18,19,20-STRING,21-STRING,22,23-STRING,24-STRING,25-STRING,26,27-STRING,28,29-STRING,30,31-STRING,32,33,34,35-STRING,36,37,38,39,40,41,42,43,44-STRING,45,46,47
  164.  
  165. [updatePlayer]
  166. SQL1_1 = UPDATE player SET
  167. SQL1_2 = name = ?,
  168. SQL1_3 = damage  = ?,
  169. SQL1_4 = hunger = ?,
  170. SQL1_5 = thirst = ?,
  171. SQL1_6 = alcohol = ?,
  172. SQL1_7 = oxygen_remaining  = ?,
  173. SQL1_8 = bleeding_remaining = ?,
  174. SQL1_9 = hitpoints = ?,
  175. SQL1_10 = direction = ?,
  176. SQL1_11 = position_x = ?,
  177. SQL1_12 = position_y = ?,
  178. SQL1_13 = position_z = ?,
  179. SQL1_14 = assigned_items = ?,
  180. SQL1_15 = backpack = ?,
  181. SQL1_16 = backpack_items = ?,
  182. SQL1_17 = backpack_magazines = ?,
  183. SQL1_18 = backpack_weapons = ?,
  184. SQL1_19 = current_weapon = ?,
  185. SQL1_20 = goggles = ?,
  186. SQL1_21 = handgun_items = ?,
  187. SQL1_22 = handgun_weapon = ?,
  188. SQL1_23 = headgear = ?,
  189. SQL1_24 = binocular = ?,
  190. SQL1_25 = loaded_magazines = ?,
  191. SQL1_26 = primary_weapon = ?,
  192. SQL1_27 = primary_weapon_items = ?,
  193. SQL1_28 = secondary_weapon = ?,
  194. SQL1_29 = secondary_weapon_items = ?,
  195. SQL1_30 = uniform = ?,
  196. SQL1_31 = uniform_items = ?,
  197. SQL1_32 = uniform_magazines = ?,
  198. SQL1_33 = uniform_weapons = ?,
  199. SQL1_34 = vest = ?,
  200. SQL1_35 = vest_items = ?,
  201. SQL1_36 = vest_magazines = ?,
  202. SQL1_37 = vest_weapons = ?,
  203. SQL1_38 = temperature = ?,
  204. SQL1_39 = wetness = ?
  205. SQL1_40 = WHERE id = ?
  206. Number Of Inputs = 39
  207. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39
  208.  
  209. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  210. ;; Vehicle related queries
  211. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  212.  
  213. [insertVehicle]
  214. SQL1_1 = INSERT INTO vehicle SET
  215. SQL1_2 = class = ?,
  216. SQL1_3 = account_uid = ?,
  217. SQL1_4 = is_locked = ?,
  218. SQL1_5 = position_x = ?,
  219. SQL1_6 = position_y = ?,
  220. SQL1_7 = position_z = ?,
  221. SQL1_8 = direction_x = ?,
  222. SQL1_9 = direction_y = ?,
  223. SQL1_10 = direction_z = ?,
  224. SQL1_11 = up_x = ?,
  225. SQL1_12 = up_y = ?,
  226. SQL1_13 = up_z = ?,
  227. SQL1_14 = pin_code = ?
  228. Number of Inputs = 13
  229. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13
  230. Return InsertID = true
  231.  
  232. [deleteVehicle]
  233. SQL1_1 = DELETE FROM vehicle WHERE id = ?
  234. Number Of Inputs = 1
  235. SQL1_INPUTS = 1
  236.  
  237. [loadVehicleIdPage]
  238. SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL AND territory_id IS NULL LIMIT ?,?
  239. Number Of Inputs = 2
  240. SQL1_INPUTS = 1,2
  241. OUTPUT = 1
  242.  
  243. [loadVehicle]
  244. SQL1_1 = SELECT id,class,spawned_at,account_uid,is_locked,fuel,damage,hitpoints,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,vehicle_texture,deleted_at,money FROM vehicle WHERE id = ?
  245. Number Of Inputs = 1
  246. SQL1_INPUTS = 1
  247. OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21-STRING,22,23,24
  248.  
  249. [loadVehicleContainer]
  250. SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ?
  251. Number Of Inputs = 1
  252. SQL1_INPUTS = 1
  253. OUTPUT = 1
  254.  
  255. [updateVehicle]
  256. SQL1_1 = UPDATE vehicle SET
  257. SQL1_2 = is_locked = ?,
  258. SQL1_3 = fuel = ?,
  259. SQL1_4 = damage = ?,
  260. SQL1_5 = hitpoints = ?,
  261. SQL1_6 = position_x = ?,
  262. SQL1_7 = position_y = ?,
  263. SQL1_8 = position_z = ?,
  264. SQL1_9 = direction_x = ?,
  265. SQL1_10 = direction_y = ?,
  266. SQL1_11 = direction_z = ?,
  267. SQL1_12 = up_x = ?,
  268. SQL1_13 = up_y = ?,
  269. SQL1_14 = up_z = ?,
  270. SQL1_15 = cargo_items = ?,
  271. SQL1_16 = cargo_magazines = ?,
  272. SQL1_17 = cargo_weapons = ?,
  273. SQL1_18 = cargo_container = ?,
  274. SQL1_19 = money = ?,
  275. SQL1_20 = last_updated_at = NOW()
  276. SQL1_21 = WHERE id = ?
  277. Number of Inputs = 19
  278. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19
  279.  
  280. [updateVehicleSkin]
  281. SQL1_1 = UPDATE vehicle SET vehicle_texture = ?, last_updated_at = NOW() WHERE id = ?
  282. Number of Inputs = 2
  283. SQL1_INPUTS = 1,2
  284.  
  285. [vehicleSetPinCode]
  286. SQL1_1 = UPDATE vehicle SET pin_code = ?, last_updated_at = NOW() WHERE id = ?
  287. Number of Inputs = 2
  288. SQL1_INPUTS = 1,2
  289.  
  290. [storeVehicle]
  291. SQL1_1 = UPDATE vehicle SET territory_id = ?, nickname = ?, last_updated_at = NOW() WHERE id = ?
  292. Number of Inputs = 3
  293. SQL1_INPUTS = 1,2,3
  294.  
  295. [retrieveVehicle]
  296. SQL1_1 = UPDATE vehicle SET territory_id = NULL, last_updated_at = NOW(), nickname = '' WHERE id = ?
  297. Number of Inputs = 1
  298. SQL1_INPUTS = 1
  299.  
  300. [confirmVehicleOwnership]
  301. SQL1_1 = SELECT id, territory_id FROM vehicle WHERE nickname = ?
  302. Number of Inputs = 1
  303. SQL1_INPUTS = 1
  304. OUTPUT = 1,2
  305.  
  306. [loadTerritoryVirtualGarage]
  307. SQL1_1 = SELECT class, nickname FROM vehicle WHERE territory_id = ?
  308. Number of Inputs = 1
  309. SQL1_INPUTS = 1
  310. OUTPUT = 1-STRING,2-STRING
  311. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  312. ;; Construction related queries
  313. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  314.  
  315. [insertConstruction]
  316. SQL1_1 = INSERT INTO construction SET
  317. SQL1_2 = class = ?,
  318. SQL1_3 = account_uid = ?,
  319. SQL1_4 = position_x = ?,
  320. SQL1_5 = position_y = ?,
  321. SQL1_6 = position_z = ?,
  322. SQL1_7 = direction_x = ?,
  323. SQL1_8 = direction_y = ?,
  324. SQL1_9 = direction_z = ?,
  325. SQL1_10 = up_x = ?,
  326. SQL1_11 = up_y = ?,
  327. SQL1_12 = up_z = ?,
  328. SQL1_13 = texture = ?,
  329. SQL1_14 = territory_id = ?
  330. Number of Inputs = 13
  331. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13
  332. Return InsertID = true
  333.  
  334. [deleteConstruction]
  335. SQL1_1 = DELETE FROM construction WHERE id = ?
  336. Number Of Inputs = 1
  337. SQL1_INPUTS = 1
  338.  
  339. [loadConstructionIdPage]
  340. SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,?
  341. Number Of Inputs = 2
  342. SQL1_INPUTS = 1,2
  343. OUTPUT = 1
  344.  
  345. [loadConstruction]
  346. SQL1_1 = SELECT id,class,account_uid,spawned_at,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,is_locked,pin_code,territory_id,deleted_at,damage,texture FROM construction WHERE id = ?
  347. Number Of Inputs = 1
  348. SQL1_INPUTS = 1
  349. OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15-STRING,16,17,18,19
  350.  
  351. [countConstruction]
  352. SQL1_1 = SELECT COUNT(*) FROM construction
  353. Number Of Inputs = 0
  354. OUTPUT = 1
  355.  
  356. [constructionSetPinCode]
  357. SQL1_1 = UPDATE construction SET pin_code= ?, last_updated_at = NOW() WHERE id = ?
  358. Number of Inputs = 2
  359. SQL1_INPUTS = 1,2
  360.  
  361. [upgradeObject]
  362. SQL1_1 = UPDATE construction SET class = ?, last_updated_at = NOW() WHERE id = ?
  363. Number of Inputs = 2
  364. SQL1_INPUTS = 1,2
  365.  
  366. [addDoorLock]
  367. SQL1_1 = UPDATE construction SET pin_code = ?, is_locked = -1, last_updated_at = NOW() WHERE id = ?
  368. Number of Inputs = 2
  369. SQL1_INPUTS = 1,2
  370.  
  371. [removeDoorLock]
  372. SQL1_1 = UPDATE construction SET pin_code = '000000', is_locked = 0, last_updated_at = NOW() WHERE id = ?
  373. Number of Inputs = 1
  374. SQL1_INPUTS = 1
  375. [updateLock]
  376. SQL1_1 = UPDATE construction SET is_locked = ?, last_updated_at = NOW() WHERE id = ?
  377. Number of Inputs = 2
  378. SQL1_INPUTS = 1,2
  379.  
  380. [updateConstructionTerritoryIDs]
  381. SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?)
  382. Number of Inputs = 2
  383. SQL1_INPUTS = 1,2
  384.  
  385. [updateDamage]
  386. SQL1_1 = UPDATE construction SET damage = ?, last_updated_at = NOW() WHERE id = ?
  387. Number of Inputs = 2
  388. SQL1_INPUTS = 1,2
  389.  
  390. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  391. ;; Containers related queries
  392. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  393.  
  394. [insertContainer]
  395. SQL1_1 = INSERT INTO container SET
  396. SQL1_2 = class = ?,
  397. SQL1_3 = account_uid = ?,
  398. SQL1_4 = position_x = ?,
  399. SQL1_5 = position_y = ?,
  400. SQL1_6 = position_z = ?,
  401. SQL1_7 = direction_x = ?,
  402. SQL1_8 = direction_y = ?,
  403. SQL1_9 = direction_z = ?,
  404. SQL1_10 = up_x = ?,
  405. SQL1_11 = up_y = ?,
  406. SQL1_12 = up_z = ?,
  407. SQL1_13 = cargo_items = ?,
  408. SQL1_14 = cargo_magazines = ?,
  409. SQL1_15 = cargo_weapons = ?,
  410. SQL1_16 = cargo_container = ?,
  411. SQL1_17 = money = ?,
  412. SQL1_18 = pin_code = ?,
  413. SQL1_19 = territory_id = $CUSTOM_1$
  414. Number of Inputs = 17
  415. Number of Custom Inputs = 1
  416. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17
  417. Return InsertID = true
  418.  
  419. [deleteContainer]
  420. SQL1_1 = DELETE FROM container WHERE id = ?
  421. Number Of Inputs = 1
  422. SQL1_INPUTS = 1
  423.  
  424. [loadContainerIdPage]
  425. SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,?
  426. Number Of Inputs = 2
  427. SQL1_INPUTS = 1,2
  428. OUTPUT = 1
  429.  
  430. [loadContainer]
  431. SQL1_1 = SELECT id,class,account_uid,is_locked,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,territory_id,abandoned,deleted_at,money FROM container WHERE id = ?
  432. Number Of Inputs = 1
  433. SQL1_INPUTS = 1
  434. OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16,17-STRING,18,19-STRING,20,21
  435.  
  436. [loadContainerCargo]
  437. SQL1_1 = SELECT cargo_container FROM container WHERE id = ?
  438. Number Of Inputs = 1
  439. SQL1_INPUTS = 1
  440. OUTPUT = 1
  441.  
  442. [updateContainer]
  443. SQL1_1 = UPDATE container SET
  444. SQL1_2 = is_locked = ?,
  445. SQL1_3 = position_x = ?,
  446. SQL1_4 = position_y = ?,
  447. SQL1_5 = position_z = ?,
  448. SQL1_6 = direction_x = ?,
  449. SQL1_7 = direction_y = ?,
  450. SQL1_8 = direction_z = ?,
  451. SQL1_9 = up_x = ?,
  452. SQL1_10 = up_y = ?,
  453. SQL1_11 = up_z = ?,
  454. SQL1_12 = cargo_items = ?,
  455. SQL1_13 = cargo_magazines = ?,
  456. SQL1_14 = cargo_weapons = ?,
  457. SQL1_15 = cargo_container = ?,
  458. SQL1_16 = territory_id = $CUSTOM_1$,
  459. SQL1_17 = money = ?,
  460. SQL1_18 = last_updated_at = NOW()
  461. SQL1_19 = WHERE id = ?
  462. Number of Inputs = 16
  463. Number of Custom Inputs = 1
  464. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16
  465.  
  466. [containerSetPinCode]
  467. SQL1_1 = UPDATE container SET pin_code= ?, last_updated_at = NOW() WHERE id = ?
  468. Number of Inputs = 2
  469. SQL1_INPUTS = 1,2
  470.  
  471. [updateContainerTerritoryIDs]
  472. SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?)
  473. Number of Inputs = 2
  474. SQL1_INPUTS = 1,2
  475.  
  476. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  477. ;; Clan related queries
  478. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  479.  
  480. [createClan]
  481. SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ?
  482. Number Of Inputs = 2
  483. SQL1_INPUTS = 1,2
  484. Return InsertID = true
  485.  
  486. [setAccountClanLink]
  487. SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ?
  488. Number Of Inputs = 2
  489. SQL1_INPUTS = 1,2
  490.  
  491. [unLinkClanLink]
  492. SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ?
  493. Number Of Inputs = 1
  494. SQL1_INPUTS = 1
  495.  
  496. [updateClanLeader]
  497. SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ?
  498. Number Of Inputs = 2
  499. SQL1_INPUTS = 1,2
  500.  
  501. [deleteClan]
  502. SQL1_1 = DELETE FROM clan WHERE id = ?
  503. Number Of Inputs = 1
  504. SQL1_INPUTS = 1
  505.  
  506. [loadClansIdPage]
  507. SQL1_1 = SELECT id FROM clan LIMIT ?,?
  508. Number Of Inputs = 2
  509. SQL1_INPUTS = 1,2
  510. OUTPUT = 1
  511.  
  512. [getClanInfo]
  513. SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ?
  514. Number Of Inputs = 1
  515. SQL1_INPUTS = 1
  516. OUTPUT = 1-STRING,2-STRING
  517.  
  518. [getClanMembers]
  519. SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ?
  520. Number Of Inputs = 1
  521. SQL1_INPUTS = 1
  522. OUTPUT = 1-STRING,2-STRING
  523.  
  524. [getClanMarkers]
  525. SQL1_1 = SELECT id,markerType,positionArr,color,icon,iconSize,label,labelSize FROM clan_map_marker WHERE clan_id = ?
  526. Number Of Inputs = 1
  527. SQL1_INPUTS = 1
  528. OUTPUT = 1,2,3,4,5-STRING,6,7-STRING,8
  529.  
  530. [addMarker]
  531. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 0, positionArr = ?, color = ?, icon = ?, iconSize = ?, label = ?, labelSize = ?
  532. Number Of Inputs = 7
  533. SQL1_INPUTS = 1,2,3,4,5,6,7
  534. Return InsertID = true
  535.  
  536. [addPoly]
  537. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 1, positionArr = ?, color = ?
  538. Number Of Inputs = 3
  539. SQL1_INPUTS = 1,2,3
  540. Return InsertID = true
  541.  
  542. [deleteMarker]
  543. SQL1_1 = DELETE FROM clan_map_marker WHERE id = ?
  544. Number Of Inputs = 1
  545. SQL1_INPUTS = 1
  546.  
  547. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  548. ;; Territory related queries
  549. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  550.  
  551. [createTerritory]
  552. SQL1_1 = INSERT INTO territory SET owner_uid = ?, name = ?, position_x = ? , position_y = ? , position_z = ?, radius = ? , level = ? , flag_texture = ? , flag_stolen = ? , flag_stolen_by_uid =$CUSTOM_1$ , build_rights = ? , moderators = ?
  553. Number Of Inputs = 11
  554. Number Of Custom Inputs = 1
  555. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11
  556. Return InsertID = true
  557.  
  558. [loadTerriotryIdPage]
  559. SQL1_1 = SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,?
  560. Number Of Inputs = 2
  561. SQL1_INPUTS = 1,2
  562. OUTPUT = 1
  563.  
  564. [loadTerritory]
  565. SQL1_1 = SET @connector = ?;
  566. SQL2_1 = SELECT id,owner_uid,name,position_x,position_y,position_z,radius, level,flag_texture,flag_stolen,flag_stolen_by_uid,last_paid_at,build_rights,moderators,deleted_at,(SELECT COUNT(*)FROM construction c WHERE c.territory_id = @connector) FROM territory WHERE id = @connector
  567. Number Of Inputs = 1
  568. SQL1_INPUTS = 1
  569. OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12-DateTime_ISO8601,13,14,15,16
  570.  
  571. [setTerritoryLevel]
  572. SQL1_1 = UPDATE territory SET level = ? WHERE id = ?
  573. Number Of Inputs = 2
  574. SQL1_INPUTS = 1,2
  575.  
  576. [setTerritorySize]
  577. SQL1_1 = UPDATE territory SET radius = ? WHERE id = ?
  578. Number Of Inputs = 2
  579. SQL1_INPUTS = 1,2
  580.  
  581. [updateTerritoryBuildRights]
  582. SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ?
  583. Number Of Inputs = 2
  584. SQL1_INPUTS = 1,2
  585.  
  586. [updateTerritoryModerators]
  587. SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ?
  588. Number Of Inputs = 2
  589. SQL1_INPUTS = 1,2
  590.  
  591. [maintainTerritory]
  592. SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ?
  593. Number Of Inputs = 1
  594. SQL1_INPUTS = 1
  595.  
  596. [deleteTerritory]
  597. SQL1_1 = DELETE FROM territory WHERE id = ?
  598. Number Of Inputs = 1
  599. SQL1_INPUTS = 1
  600.  
  601. [flagStolen]
  602. SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ?
  603. Number of Inputs = 2
  604. SQL1_INPUTS = 1,2
  605.  
  606. [flagRestore]
  607. SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ?
  608. Number of Inputs = 1
  609. SQL1_INPUTS = 1
  610.  
  611. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  612. ;; Garbage Collector
  613. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  614.  
  615. ; Marks for deletion containers outside territories that were not accessed within ? days
  616. [markDeleteOldContainers]
  617. SQL1_1 = UPDATE container SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL
  618. Number Of Inputs = 1
  619. SQL1_INPUTS = 1
  620.  
  621. ; Removes containers outside territories that were not accessed within ? days
  622. [deleteOldContainers]
  623. SQL1_1 = DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  624. Number Of Inputs = 1
  625. SQL1_INPUTS = 1
  626.  
  627. ; Marks contructions outside territories deleted after ? days
  628. [markDeleteOldConstructions]
  629. SQL1_1 = UPDATE construction SET deleted_at = NOW() WHERE spawned_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL
  630. Number Of Inputs = 1
  631. SQL1_INPUTS = 1
  632.  
  633. ; Removes contructions outside territories after ? days
  634. [deleteOldConstructions]
  635. SQL1_1 = DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  636. Number Of Inputs = 1
  637. SQL1_INPUTS = 1
  638.  
  639. ; Marks for deletion vehicles that were not used within ? days
  640. [markDeleteOldVehicles]
  641. SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL
  642. Number Of Inputs = 1
  643. SQL1_INPUTS = 1
  644.  
  645. ; Removes vehicles that were not used within ? days
  646. [deleteOldVehicles]
  647. SQL1_1 = DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  648. Number Of Inputs = 1
  649. SQL1_INPUTS = 1
  650.  
  651. ; Marks territories (and all containers/constructions) that were not paid within ? days as deleted
  652. [markDeleteUnpaidTerritories]
  653. SQL1_1 = UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL
  654. SQl2_1 = UPDATE construction SET deleted_at = (SELECT deleted_at FROM territory WHERE territory.id = construction.territory_id AND territory.deleted_at IS NOT NULL) WHERE construction.territory_id IS NOT NULL
  655. SQL3_1 = UPDATE container SET deleted_at = (SELECT deleted_at FROM territory WHERE territory.id = container.territory_id AND territory.deleted_at IS NOT NULL) WHERE container.territory_id IS NOT NULL
  656. Number Of Inputs = 1
  657. SQL1_INPUTS = 1
  658.  
  659. ; Removes territories (and all containers/constructions) that were not paid within ? days
  660. [deleteUnpaidTerritories]
  661. SQL1_1 = DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  662. Number Of Inputs = 1
  663. SQL1_INPUTS = 1
  664.  
  665. [addAbandonedSafes]
  666. SQL1_1 = UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND class = "Exile_Container_Safe" AND territory_id IS NULL
  667. Number Of Inputs = 1
  668. SQL1_INPUTS = 1
  669.  
  670. [deleteBaseFlagStolen]
  671. SQL1_1 = DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  672. Number Of Inputs = 1
  673. SQL1_INPUTS = 1
  674.  
  675. ; Unlock doors and mark safes as abandoned if flag stolen for X days
  676. [setAbandonedUnlocked]
  677. SQL1_1 = UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE (SELECT flag_stolen_at FROM territory WHERE territory.id = container.territory_id AND territory.flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY));
  678. SQL2_1 = UPDATE construction SET pin_code = '0000' WHERE (SELECT flag_stolen_at FROM territory WHERE territory.id = construction.territory_id AND territory.flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)) AND pin_code != '000000'
  679. Number Of Inputs = 1
  680. SQL1_INPUTS = 1
  681. SQL2_INPUTS = 1
  682.  
  683. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  684. ;; Moneh moneh moneh
  685. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  686.  
  687. [setPlayerMoney]
  688. SQL1_1 = UPDATE player SET money = ? WHERE id = ?
  689. Number of Inputs = 2
  690. SQL1_INPUTS = 1,2
  691.  
  692. [getPlayerMoney]
  693. SQL1_1 = SELECT money FROM player WHERE id = ?
  694. Number of Inputs = 1
  695. SQL1_INPUTS = 1
  696. OUTPUT = 1
  697.  
  698. [setContainerMoney]
  699. SQL1_1 = UPDATE container SET money = ?, last_updated_at = NOW() WHERE id = ?
  700. Number of Inputs = 2
  701. SQL1_INPUTS = 1,2
  702.  
  703. [setVehicleMoney]
  704. SQL1_1 = UPDATE vehicle SET money = ?, last_updated_at = NOW() WHERE id = ?
  705. Number of Inputs = 2
  706. SQL1_INPUTS = 1,2
  707.  
  708. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  709. ;;  XM8
  710. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  711.  
  712. [getAllNotifTerritory]
  713. SQL1_1 = SELECT id FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? - 1 DAY) and xm8_protectionmoney_notified = 0
  714. Number of Inputs = 1
  715. SQL1_INPUTS = 1
  716.  
  717. [setTerritoryNotified]
  718. SQL1_1 = UPDATE territory SET xm8_protectionmoney_notified = ? WHERE id = ?
  719. Number of Inputs = 2
  720. SQL1_INPUTS = 1,2
  721.  
  722. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  723. ;;  Exile Escape
  724. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  725.  
  726. [addAccountWin]
  727. SQL1_1 = UPDATE account SET wins = wins + 1 WHERE uid = ?
  728. Number Of Inputs = 1
  729. SQL1_INPUTS = 1                
  730.  
  731. [addAccountMatches]
  732. SQL1_1 = UPDATE account SET matches = matches + 1 WHERE uid = ?
  733. Number Of Inputs = 1
  734. SQL1_INPUTS = 1
  735.  
  736. [createMatch]
  737. SQL1_1 = INSERT INTO game_data SET players = ?, total_players = ?
  738. Number Of Inputs = 2
  739. SQL1_INPUTS = 1,2
  740. Return InsertID = true
  741.  
  742. [setMatchWinner]
  743. SQL1_1 = UPDATE game_data SET winner_uid = ?, win_type = ? WHERE id = ?
  744. Number Of Inputs = 3
  745. SQL1_INPUTS = 1,2,3
  746.  
  747. [getEscapeAccountStats]
  748. SQL1_1 = SELECT wins, matches FROM account WHERE uid = ?
  749. Number of Inputs = 1
  750. SQL1_INPUTS = 1
  751. OUTPUT = 1,2
  752.  
  753.                  
  754.                                                              
  755.                    
  756.  
  757. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  758. ;;  Most Wanted by Mezo, Shix and WolfkillArcadia
  759. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  760.  
  761. [hasBountyAccount]
  762. SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM bounties WHERE uid = ?) THEN 'true' ELSE 'false' END
  763. Number of Inputs = 1
  764. SQL1_INPUTS = 1
  765. OUTPUT = 1
  766.  
  767. [createBountyAccount]
  768. SQL1_1 = INSERT INTO bounties SET uid = ?, name = ?, bounty = '[]', bountyLock = 0, bountyContract = '[]', bountyContractCompleted = '[]', friends = '[]'
  769. Number Of Inputs = 2
  770. SQL1_INPUTS = 1,2
  771.  
  772. [hasImmunity]
  773. SQL1_1 = SELECT CASE WHEN (SELECT uid FROM bounties WHERE uid = ? AND last_immunity_applied_at < DATE_SUB(NOW(),INTERVAL ? DAY)) THEN 'false' ELSE 'true' END
  774. Number of Inputs = 2
  775. SQL1_INPUTS = 1,2
  776. OUTPUT = 1
  777.  
  778. [getBounty]
  779. SQL1_1 = SELECT bounty, bountyLock, bountyContract, bountyContractCompleted, friends FROM bounties WHERE uid = ?
  780. Number Of Inputs = 1
  781. SQL1_INPUTS = 1
  782. OUTPUT = 1,2,3,4,5
  783.  
  784. [getAllBounties]
  785. SQL1_1 = SELECT name, uid, bounty FROM bounties
  786. Number Of Inputs = 0
  787. OUTPUT = 1-STRING,2-STRING,3
  788.  
  789. [setBounty]
  790. SQL1_1 = UPDATE bounties SET bounty = ? WHERE uid = ?
  791. Number Of Inputs = 2
  792. SQL1_INPUTS = 1,2
  793.  
  794. [setImmunityTime]
  795. SQL1_1 = UPDATE bounties SET last_immunity_applied_at = NOW() WHERE uid = ?
  796. Number Of Inputs = 1
  797. SQL1_INPUTS = 1
  798.  
  799. [updateBountyLock]
  800. SQL1_1 = UPDATE bounties SET bountyLock = ? WHERE uid = ?
  801. Number Of Inputs = 2
  802. SQL1_INPUTS = 1,2
  803.  
  804. [nullContract]
  805. SQL1_1 = UPDATE bounties SET bountyContract = '[]' WHERE bountyContract LIKE ?
  806. Number Of Inputs = 1
  807. SQL1_INPUTS = 1
  808.  
  809. [updateContract]
  810. SQL1_1 = UPDATE bounties SET bountyContract = ? WHERE uid = ?
  811. Number Of Inputs = 2
  812. SQL1_INPUTS = 1,2
  813.  
  814. [updateCompletedContracts]
  815. SQL1_1 = UPDATE bounties SET bountyContractCompleted = ? WHERE uid = ?
  816. Number Of Inputs = 2
  817. SQL1_INPUTS = 1,2
  818.  
  819. [updateFriends]
  820. SQL1_1 = UPDATE bounties SET friends = ? WHERE uid = ?
  821. Number Of Inputs = 2
  822. SQL1_INPUTS = 1,2
  823.  
  824. [resetFriends]
  825. SQL1_1 = UPDATE bounties SET friends = '[]' WHERE friend_last_reset_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  826. Number Of Inputs = 1
  827. SQL1_INPUTS = 1
  828. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  829. ;; infiSTAR Territory Management
  830. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  831.  
  832. [setTerritoryName]
  833. SQL1_1 = UPDATE territory SET name = ? WHERE id = ?
  834. Number Of Inputs = 2
  835. SQL1_INPUTS = 1,2
  836.  
  837. [setTerritoryFlagTexture]
  838. SQL1_1 = UPDATE territory SET flag_texture = ? WHERE id = ?
  839. Number Of Inputs = 2
  840. SQL1_INPUTS = 1,2
  841.  
  842. [setTerritoryPos]
  843. SQL1_1 = UPDATE territory SET position_x = ? , position_y = ? , position_z = ? WHERE id = ?
  844. Number Of Inputs = 4
  845. SQL1_INPUTS = 1,2,3,4
  846.  
  847. [getAccountName]
  848. SQL1_1 = SELECT name FROM account WHERE uid = ?
  849. Number of Inputs = 1
  850. SQL1_INPUTS = 1
  851. OUTPUT = 1
  852.  
  853. [getFlagStolenBy]
  854. SQL1_1 = SELECT flag_stolen_by_uid FROM territory WHERE id = ?
  855. Number of Inputs = 1
  856. SQL1_INPUTS = 1
  857. OUTPUT = 1
  858.  
  859. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  860. ;;  MarXet by WolfkillArcadia
  861. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  862.  
  863. [createNewListing]
  864. SQL1_1 = INSERT INTO marxet SET listingID = ?, itemAvailable = ?, itemArray = ?, price = ?, sellerUID = ?
  865. Number Of Inputs = 5
  866. SQL1_INPUTS = 1,2,3,4,5
  867.  
  868. [getListings]
  869. SQL1_1 = SELECT listingID, itemAvailable, itemArray, price, sellerUID FROM marxet
  870. Number Of Inputs = 0
  871. OUTPUT = 1-STRING,2,3,4-STRING,5-STRING
  872.  
  873. [updateListing]
  874. SQL1_1 = UPDATE marxet SET itemAvailable = 0 WHERE listingID = ?
  875. Number Of Inputs = 1
  876. SQL1_INPUTS = 1
  877.  
  878. [deleteListing]
  879. SQL1_1 = DELETE FROM marxet WHERE listingID = ?
  880. Number Of Inputs = 1
  881. SQL1_INPUTS = 1
  882.  
  883. [restrictOldListings]
  884. SQL1_1 = UPDATE marxet SET sellerUID = 0 WHERE created_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND sellerUID != 0
  885. Number of Inputs = 1
  886. SQL1_INPUTS = 1
  887.  
  888. [deleteOldListings]
  889. SQL1_1 = DELETE FROM marxet WHERE created_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND sellerUID = 0
  890. Number of Inputs = 1
  891. SQL1_INPUTS = 1
  892.  
  893. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  894. ;; BASE PAINTING
  895. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  896.  
  897. [setObjectTexture]
  898. SQL1_1 = UPDATE construction SET texture=? WHERE id = ?
  899. Number of Inputs = 2
  900. SQL1_INPUTS = 1,2
  901.  
  902. [countConstruction]
  903. SQL1_1 = SELECT COUNT(*) FROM construction
  904. Number Of Inputs = 0
  905. OUTPUT = 1
  906.  
  907. [constructionSetPinCode]
  908. SQL1_1 = UPDATE construction SET pin_code= ?, last_updated_at = NOW() WHERE id = ?
  909. Number of Inputs = 2
  910. SQL1_INPUTS = 1,2
  911.  
  912. [upgradeObject]
  913. SQL1_1 = UPDATE construction SET class = ?, last_updated_at = NOW() WHERE id = ?
  914. Number of Inputs = 2
  915. SQL1_INPUTS = 1,2
  916.  
  917. [addDoorLock]
  918. SQL1_1 = UPDATE construction SET pin_code = ?, is_locked = -1, last_updated_at = NOW() WHERE id = ?
  919. Number of Inputs = 2
  920. SQL1_INPUTS = 1,2
  921.  
  922. [updateLock]
  923. SQL1_1 = UPDATE construction SET is_locked = ?, last_updated_at = NOW() WHERE id = ?
  924. Number of Inputs = 2
  925. SQL1_INPUTS = 1,2
  926.  
  927. [updateConstructionTerritoryIDs]
  928. SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?)
  929. Number of Inputs = 2
  930. SQL1_INPUTS = 1,2
  931.  
  932. [updateDamage]
  933. SQL1_1 = UPDATE construction SET damage = ?, last_updated_at = NOW() WHERE id = ?
  934. Number of Inputs = 2
  935. SQL1_INPUTS = 1,2
  936.  
  937. [addAccountZombieKill]
  938. SQL1_1 = UPDATE account SET zedkills = zedkills + 1 WHERE uid = ?
  939. Number Of Inputs = 1
  940. SQL1_INPUTS = 1
  941.  
  942. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  943. ;; infiSTAR Logs
  944. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  945.  
  946. [insert_infiSTARLog]
  947. SQL1_1 = INSERT INTO infistar_logs SET servername = ?, logname = ?, logentry = ?
  948. Number Of Inputs = 3
  949. SQL1_INPUTS = 1,2,3
  950.  
  951. [getTotalConnections]
  952. SQL1_1 = SELECT first_connect_at,last_connect_at,total_connections FROM account WHERE uid = ?
  953. Number Of Inputs = 1
  954. SQL1_INPUTS = 1
  955. OUTPUT = 1
  956.  
  957. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  958. ;; infiSTAR WhiteList
  959. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  960.  
  961. [getAccountWhitelisted]
  962. SQL1_1 = SELECT whitelisted FROM account WHERE uid = ?
  963. Number Of Inputs = 1
  964. SQL1_INPUTS = 1
  965. OUTPUT = 1
Advertisement