Advertisement
Guest User

Untitled

a guest
Aug 12th, 2016
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.47 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 LIMIT ?,?
  239. SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL AND territory_id IS NULL LIMIT ?,?
  240. Number Of Inputs = 2
  241. SQL1_INPUTS = 1,2
  242. OUTPUT = 1
  243.  
  244. [loadVehicle]
  245. 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 = ?
  246. Number Of Inputs = 1
  247. SQL1_INPUTS = 1
  248. 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
  249.  
  250. [loadVehicleContainer]
  251. SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ?
  252. Number Of Inputs = 1
  253. SQL1_INPUTS = 1
  254. OUTPUT = 1
  255.  
  256. [updateVehicle]
  257. SQL1_1 = UPDATE vehicle SET
  258. SQL1_2 = is_locked = ?,
  259. SQL1_3 = fuel = ?,
  260. SQL1_4 = damage = ?,
  261. SQL1_5 = hitpoints = ?,
  262. SQL1_6 = position_x = ?,
  263. SQL1_7 = position_y = ?,
  264. SQL1_8 = position_z = ?,
  265. SQL1_9 = direction_x = ?,
  266. SQL1_10 = direction_y = ?,
  267. SQL1_11 = direction_z = ?,
  268. SQL1_12 = up_x = ?,
  269. SQL1_13 = up_y = ?,
  270. SQL1_14 = up_z = ?,
  271. SQL1_15 = cargo_items = ?,
  272. SQL1_16 = cargo_magazines = ?,
  273. SQL1_17 = cargo_weapons = ?,
  274. SQL1_18 = cargo_container = ?,
  275. SQL1_19 = money = ?
  276. SQL1_20 = 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 = ? WHERE id = ?
  282. Number of Inputs = 2
  283. SQL1_INPUTS = 1,2
  284.  
  285. [vehicleSetPinCode]
  286. SQL1_1 = UPDATE vehicle SET pin_code = ? WHERE id = ?
  287. Number of Inputs = 2
  288. SQL1_INPUTS = 1,2
  289.  
  290.  
  291. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  292. ;; Construction related queries
  293. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  294.  
  295. [insertConstruction]
  296. SQL1_1 = INSERT INTO construction SET
  297. SQL1_2 = class = ?,
  298. SQL1_3 = account_uid = ?,
  299. SQL1_4 = position_x = ?,
  300. SQL1_5 = position_y = ?,
  301. SQL1_6 = position_z = ?,
  302. SQL1_7 = direction_x = ?,
  303. SQL1_8 = direction_y = ?,
  304. SQL1_9 = direction_z = ?,
  305. SQL1_10 = up_x = ?,
  306. SQL1_11 = up_y = ?,
  307. SQL1_12 = up_z = ?,
  308. SQL1_13 = territory_id = $CUSTOM_1$
  309. Number of Inputs = 11
  310. Number of Custom Inputs = 1
  311. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11
  312. Return InsertID = true
  313.  
  314. [deleteConstruction]
  315. SQL1_1 = DELETE FROM construction WHERE id = ?
  316. Number Of Inputs = 1
  317. SQL1_INPUTS = 1
  318.  
  319. [loadConstructionIdPage]
  320. SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,?
  321. Number Of Inputs = 2
  322. SQL1_INPUTS = 1,2
  323. OUTPUT = 1
  324.  
  325. [loadConstruction]
  326. 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 FROM construction WHERE id = ?
  327. Number Of Inputs = 1
  328. SQL1_INPUTS = 1
  329. OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15-STRING,16,17,18
  330.  
  331. [countConstruction]
  332. SQL1_1 = SELECT COUNT(*) FROM construction
  333. Number Of Inputs = 0
  334. OUTPUT = 1
  335.  
  336. [constructionSetPinCode]
  337. SQL1_1 = UPDATE construction SET pin_code= ? WHERE id = ?
  338. Number of Inputs = 2
  339. SQL1_INPUTS = 1,2
  340.  
  341. [upgradeObject]
  342. SQL1_1 = UPDATE construction SET class=? WHERE id = ?
  343. Number of Inputs = 2
  344. SQL1_INPUTS = 1,2
  345.  
  346. [addDoorLock]
  347. SQL1_1 = UPDATE construction SET pin_code = ?,is_locked = -1 WHERE id = ?
  348. Number of Inputs = 2
  349. SQL1_INPUTS = 1,2
  350.  
  351. [updateLock]
  352. SQL1_1 = UPDATE construction SET is_locked = ? WHERE id = ?
  353. Number of Inputs = 2
  354. SQL1_INPUTS = 1,2
  355.  
  356. [updateConstructionTerritoryIDs]
  357. SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?)
  358. Number of Inputs = 2
  359. SQL1_INPUTS = 1,2
  360.  
  361. [updateDamage]
  362. SQL1_1 = UPDATE construction SET damage = ? WHERE id = ?
  363. Number of Inputs = 2
  364. SQL1_INPUTS = 1,2
  365.  
  366. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  367. ;; Containers related queries
  368. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  369.  
  370. [insertContainer]
  371. SQL1_1 = INSERT INTO container SET
  372. SQL1_2 = class = ?,
  373. SQL1_3 = account_uid = ?,
  374. SQL1_4 = position_x = ?,
  375. SQL1_5 = position_y = ?,
  376. SQL1_6 = position_z = ?,
  377. SQL1_7 = direction_x = ?,
  378. SQL1_8 = direction_y = ?,
  379. SQL1_9 = direction_z = ?,
  380. SQL1_10 = up_x = ?,
  381. SQL1_11 = up_y = ?,
  382. SQL1_12 = up_z = ?,
  383. SQL1_13 = cargo_items = ?,
  384. SQL1_14 = cargo_magazines = ?,
  385. SQL1_15 = cargo_weapons = ?,
  386. SQL1_16 = cargo_container = ?,
  387. SQL1_17 = money = ?,
  388. SQL1_18 = pin_code = ?,
  389. SQL1_19 = territory_id = $CUSTOM_1$
  390. Number of Inputs = 17
  391. Number of Custom Inputs = 1
  392. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17
  393. Return InsertID = true
  394.  
  395. [deleteContainer]
  396. SQL1_1 = DELETE FROM container WHERE id = ?
  397. Number Of Inputs = 1
  398. SQL1_INPUTS = 1
  399.  
  400. [loadContainerIdPage]
  401. SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,?
  402. Number Of Inputs = 2
  403. SQL1_INPUTS = 1,2
  404. OUTPUT = 1
  405.  
  406. [loadContainer]
  407. 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 = ?
  408. Number Of Inputs = 1
  409. SQL1_INPUTS = 1
  410. 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
  411.  
  412. [loadContainerCargo]
  413. SQL1_1 = SELECT cargo_container FROM container WHERE id = ?
  414. Number Of Inputs = 1
  415. SQL1_INPUTS = 1
  416. OUTPUT = 1
  417.  
  418. [updateContainer]
  419. SQL1_1 = UPDATE container SET
  420. SQL1_2 = is_locked = ?,
  421. SQL1_3 = position_x = ?,
  422. SQL1_4 = position_y = ?,
  423. SQL1_5 = position_z = ?,
  424. SQL1_6 = direction_x = ?,
  425. SQL1_7 = direction_y = ?,
  426. SQL1_8 = direction_z = ?,
  427. SQL1_9 = up_x = ?,
  428. SQL1_10 = up_y = ?,
  429. SQL1_11 = up_z = ?,
  430. SQL1_12 = cargo_items = ?,
  431. SQL1_13 = cargo_magazines = ?,
  432. SQL1_14 = cargo_weapons = ?,
  433. SQL1_15 = cargo_container = ?,
  434. SQL1_16 = territory_id = $CUSTOM_1$,
  435. SQL1_17 = money = ?
  436. SQL1_18 = WHERE id = ?
  437. Number of Inputs = 16
  438. Number of Custom Inputs = 1
  439. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16
  440.  
  441. [containerSetPinCode]
  442. SQL1_1 = UPDATE container SET pin_code= ? WHERE id = ?
  443. Number of Inputs = 2
  444. SQL1_INPUTS = 1,2
  445.  
  446. [updateContainerTerritoryIDs]
  447. SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?)
  448. Number of Inputs = 2
  449. SQL1_INPUTS = 1,2
  450.  
  451. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  452. ;; Clan related queries
  453. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  454.  
  455. [createClan]
  456. SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ?
  457. Number Of Inputs = 2
  458. SQL1_INPUTS = 1,2
  459. Return InsertID = true
  460.  
  461. [setAccountClanLink]
  462. SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ?
  463. Number Of Inputs = 2
  464. SQL1_INPUTS = 1,2
  465.  
  466. [unLinkClanLink]
  467. SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ?
  468. Number Of Inputs = 1
  469. SQL1_INPUTS = 1
  470.  
  471. [updateClanLeader]
  472. SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ?
  473. Number Of Inputs = 2
  474. SQL1_INPUTS = 1,2
  475.  
  476. [deleteClan]
  477. SQL1_1 = DELETE FROM clan WHERE id = ?
  478. Number Of Inputs = 1
  479. SQL1_INPUTS = 1
  480.  
  481. [loadClansIdPage]
  482. SQL1_1 = SELECT id FROM clan LIMIT ?,?
  483. Number Of Inputs = 2
  484. SQL1_INPUTS = 1,2
  485. OUTPUT = 1
  486.  
  487. [getClanInfo]
  488. SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ?
  489. Number Of Inputs = 1
  490. SQL1_INPUTS = 1
  491. OUTPUT = 1-STRING,2-STRING
  492.  
  493. [getClanMembers]
  494. SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ?
  495. Number Of Inputs = 1
  496. SQL1_INPUTS = 1
  497. OUTPUT = 1-STRING,2-STRING
  498.  
  499. [getClanMarkers]
  500. SQL1_1 = SELECT id,markerType,positionArr,color,icon,iconSize,label,labelSize FROM clan_map_marker WHERE clan_id = ?
  501. Number Of Inputs = 1
  502. SQL1_INPUTS = 1
  503. OUTPUT = 1,2,3,4,5-STRING,6,7-STRING,8
  504.  
  505. [addMarker]
  506. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 0, positionArr = ?, color = ?, icon = ?, iconSize = ?, label = ?, labelSize = ?
  507. Number Of Inputs = 7
  508. SQL1_INPUTS = 1,2,3,4,5,6,7
  509. Return InsertID = true
  510.  
  511. [addPoly]
  512. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 1, positionArr = ?, color = ?
  513. Number Of Inputs = 3
  514. SQL1_INPUTS = 1,2,3
  515. Return InsertID = true
  516.  
  517. [deleteMarker]
  518. SQL1_1 = DELETE FROM clan_map_marker WHERE id = ?
  519. Number Of Inputs = 1
  520. SQL1_INPUTS = 1
  521.  
  522. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  523. ;; Territory related queries
  524. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  525.  
  526. [createTerritory]
  527. 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 = ?
  528. Number Of Inputs = 11
  529. Number Of Custom Inputs = 1
  530. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11
  531. Return InsertID = true
  532.  
  533. [loadTerriotryIdPage]
  534. SQL1_1 = SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,?
  535. Number Of Inputs = 2
  536. SQL1_INPUTS = 1,2
  537. OUTPUT = 1
  538.  
  539. [loadTerritory]
  540. SQL1_1 = SET @connector = ?;
  541. 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
  542. Number Of Inputs = 1
  543. SQL1_INPUTS = 1
  544. OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12-DateTime_ISO8601,13,14,15,16
  545.  
  546. [setTerritoryLevel]
  547. SQL1_1 = UPDATE territory SET level = ? WHERE id = ?
  548. Number Of Inputs = 2
  549. SQL1_INPUTS = 1,2
  550.  
  551. [setTerritorySize]
  552. SQL1_1 = UPDATE territory SET radius = ? WHERE id = ?
  553. Number Of Inputs = 2
  554. SQL1_INPUTS = 1,2
  555.  
  556. [updateTerritoryBuildRights]
  557. SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ?
  558. Number Of Inputs = 2
  559. SQL1_INPUTS = 1,2
  560.  
  561. [updateTerritoryModerators]
  562. SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ?
  563. Number Of Inputs = 2
  564. SQL1_INPUTS = 1,2
  565.  
  566. [maintainTerritory]
  567. SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ?
  568. Number Of Inputs = 1
  569. SQL1_INPUTS = 1
  570.  
  571. [deleteTerritory]
  572. SQL1_1 = DELETE FROM territory WHERE id = ?
  573. Number Of Inputs = 1
  574. SQL1_INPUTS = 1
  575.  
  576. [flagStolen]
  577. SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ?
  578. Number of Inputs = 2
  579. SQL1_INPUTS = 1,2
  580.  
  581. [flagRestore]
  582. SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ?
  583. Number of Inputs = 1
  584. SQL1_INPUTS = 1
  585.  
  586. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  587. ;; Garbage Collector
  588. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  589.  
  590. ; Marks for deletion containers outside territories that were not accessed within ? days
  591. [markDeleteOldContainers]
  592. SQL1_1 = UPDATE container SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  593. Number Of Inputs = 1
  594. SQL1_INPUTS = 1
  595.  
  596. ; Removes containers outside territories that were not accessed within ? days
  597. [deleteOldContainers]
  598. SQL1_1 = DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  599. Number Of Inputs = 1
  600. SQL1_INPUTS = 1
  601.  
  602. ; Marks contructions outside territories deleted after ? days
  603. [markDeleteOldConstructions]
  604. SQL1_1 = UPDATE construction SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  605. Number Of Inputs = 1
  606. SQL1_INPUTS = 1
  607.  
  608. ; Removes contructions outside territories after ? days
  609. [deleteOldConstructions]
  610. SQL1_1 = DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  611. Number Of Inputs = 1
  612. SQL1_INPUTS = 1
  613.  
  614. ; Marks for deletion vehicles that were not used within ? days
  615. [markDeleteOldVehicles]
  616. ; SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  617. SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  618. Number Of Inputs = 1
  619. SQL1_INPUTS = 1
  620.  
  621. ; Removes vehicles that were not used within ? days
  622. [deleteOldVehicles]
  623. ;SQL1_1 = DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  624. SQL1_1 = DELETE FROM vehicle WHERE territory_id IS NULL AND deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  625. Number Of Inputs = 1
  626. SQL1_INPUTS = 1
  627.  
  628. ; Marks territories (and all containers/constructions) that were not paid within ? days as deleted
  629. [markDeleteUnpaidTerritories]
  630. SQL1_1 = UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  631. 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)
  632. 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)
  633. Number Of Inputs = 1
  634. SQL1_INPUTS = 1
  635.  
  636. ; Removes territories (and all containers/constructions) that were not paid within ? days
  637. [deleteUnpaidTerritories]
  638. SQL1_1 = DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  639. Number Of Inputs = 1
  640. SQL1_INPUTS = 1
  641.  
  642. [addAbandonedSafes]
  643. 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
  644. Number Of Inputs = 1
  645. SQL1_INPUTS = 1
  646.  
  647. [deleteBaseFlagStolen]
  648. SQL1_1 = DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  649. Number Of Inputs = 1
  650. SQL1_INPUTS = 1
  651.  
  652. ; Unlock doors and mark safes as abandoned if flag stolen for X days
  653. [setAbandonedUnlocked]
  654. 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));
  655. 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'
  656. Number Of Inputs = 1
  657. SQL1_INPUTS = 1
  658. SQL2_INPUTS = 1
  659.  
  660. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  661. ;; Moneh moneh moneh
  662. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  663.  
  664. [setPlayerMoney]
  665. SQL1_1 = UPDATE player SET money = ? WHERE id = ?
  666. Number of Inputs = 2
  667. SQL1_INPUTS = 1,2
  668.  
  669. [getPlayerMoney]
  670. SQL1_1 = SELECT money FROM player WHERE id = ?
  671. Number of Inputs = 1
  672. SQL1_INPUTS = 1
  673. OUTPUT = 1
  674.  
  675. [setContainerMoney]
  676. SQL1_1 = UPDATE container SET money = ? WHERE id = ?
  677. Number of Inputs = 2
  678. SQL1_INPUTS = 1,2
  679.  
  680. [setVehicleMoney]
  681. SQL1_1 = UPDATE vehicle SET money = ? WHERE id = ?
  682. Number of Inputs = 2
  683. SQL1_INPUTS = 1,2
  684.  
  685. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  686. ;; XM8
  687. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  688.  
  689. [getAllNotifTerritory]
  690. SQL1_1 = SELECT id FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? - 1 DAY) and xm8_protectionmoney_notified = 0
  691. Number of Inputs = 1
  692. SQL1_INPUTS = 1
  693.  
  694. [setTerritoryNotified]
  695. SQL1_1 = UPDATE territory SET xm8_protectionmoney_notified = ? WHERE id = ?
  696. Number of Inputs = 2
  697. SQL1_INPUTS = 1,2
  698.  
  699. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  700. ;; Virtual Garage related queries | ADDED BY [ExAd]Jan
  701. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  702.  
  703. [loadTerritoryVehicles]
  704. SQL1_1 = SELECT id, class FROM vehicle WHERE territory_id = ?
  705. Number Of Inputs = 1
  706. SQL1_INPUTS = 1
  707. OUTPUT = 1,2-STRING
  708.  
  709. [loadVehFromVG]
  710. SQL1_1 = UPDATE vehicle SET territory_id = NULL WHERE id = ?
  711. Number Of Inputs = 1
  712. SQL1_INPUTS = 1
  713.  
  714. [loadVehToVG]
  715. SQL1_1 = UPDATE vehicle SET territory_id = ? WHERE id = ?
  716. Number Of Inputs = 2
  717. SQL1_INPUTS = 1,2
  718.  
  719. ;;;;;;;;;;;;;;;;;
  720. ;; XG_DATABASE
  721. ;;;;;;;;;;;;;;;;;
  722. [XG_LogKill]
  723. SQL1_1 = INSERT INTO xg_logkill SET
  724. SQL1_2 = victimUID = ?,
  725. SQL1_3 = victimName = ?,
  726. SQL1_4 = killerUID = ?,
  727. SQL1_5 = killerName = ?,
  728. SQL1_6 = killerWeapon = ?,
  729. SQL1_7 = killerVehicle = ?,
  730. SQL1_8 = distance = ?
  731. Number of Inputs = 7
  732. SQL1_INPUTS = 1,2,3,4,5,6,7
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement