Advertisement
Guest User

Untitled

a guest
Mar 29th, 2017
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.34 KB | None | 0 0
  1. [Default]
  2.  
  3. Version = 1
  4.  
  5. Strip Chars = "\/\|;{}<>\'"
  6.  
  7. Strip Chars Mode = 0
  8.  
  9. Input SQF Parser = false
  10. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  11. ;; Account related queries
  12. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  13.  
  14. [isKnownAccount]
  15. SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END
  16.  
  17. SQL1_INPUTS = 1
  18. OUTPUT = 1
  19.  
  20. [createAccount]
  21. SQL1_1 = INSERT INTO account SET uid = ?, name = ?
  22.  
  23. SQL1_INPUTS = 1,2
  24.  
  25. [startAccountSession]
  26. SQL1_1 = UPDATE account SET name = ?, last_connect_at = NOW(), total_connections = total_connections + 1 WHERE uid = ?
  27.  
  28. SQL1_INPUTS = 2,1
  29.  
  30. [endAccountSession]
  31. SQL1_1 = UPDATE account SET last_disconnect_at = NOW() WHERE uid = ?
  32.  
  33. SQL1_INPUTS = 1
  34.  
  35. [getAccountStats]
  36. SQL1_1 = SELECT score, kills, deaths, clan_id, locker FROM account WHERE uid = ?
  37. SQL1_INPUTS = 1
  38. OUTPUT = 1,2,3,4,5
  39.  
  40. [addAccountKill]
  41. SQL1_1 = UPDATE account SET kills = kills + 1 WHERE uid = ?
  42.  
  43. SQL1_INPUTS = 1
  44.  
  45. [addAccountDeath]
  46. SQL1_1 = UPDATE account SET deaths = deaths + 1 WHERE uid = ?
  47.  
  48. SQL1_INPUTS = 1
  49.  
  50. [getAccountScore]
  51. SQL1_1 = SELECT score FROM account WHERE uid = ?
  52.  
  53. SQL1_INPUTS = 1
  54. OUTPUT = 1
  55.  
  56. [setAccountScore]
  57. SQL1_1 = UPDATE account SET score = ? WHERE uid = ?
  58.  
  59. SQL1_INPUTS = 1,2
  60.  
  61. [modifyAccountScore]
  62. SQL1_1 = UPDATE account SET score = score + ? WHERE uid = ?
  63.  
  64. SQL1_INPUTS = 1,2
  65.  
  66. [updateLocker]
  67. SQL1_1 = UPDATE account SET locker = ? WHERE uid = ?
  68.  
  69. SQL1_INPUTS = 1,2
  70.  
  71. [getLocker]
  72. SQL1_1 = SELECT locker FROM account WHERE uid = ?
  73.  
  74. SQL1_INPUTS = 1
  75. OUTPUT = 1
  76.  
  77. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  78. ;; Player related queries
  79. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  80.  
  81. [hasAlivePlayer]
  82. SQL1_1 = SELECT CASE WHEN EXISTS(SELECT account_uid FROM player WHERE account_uid = ? AND damage < 1) THEN 'true' ELSE 'false' END
  83.  
  84. SQL1_INPUTS = 1
  85. OUTPUT = 1
  86.  
  87. [createPlayer]
  88. SQL1_1 = DELETE FROM player WHERE account_uid = ?
  89. SQL2_1 = INSERT INTO player SET account_uid = ?, name = ?
  90. SQL1_INPUTS = 1
  91. SQL2_INPUTS = 1,2
  92.  
  93. Return InsertID = true
  94.  
  95. [insertPlayerHistory]
  96. SQL1_1 = INSERT INTO player_history SET account_uid = ?, name = ?, position_x = ?, position_y = ?, position_z = ?
  97.  
  98. SQL1_INPUTS = 1,2,3,4,5
  99.  
  100. [deletePlayer]
  101. SQL1_1 = DELETE FROM player WHERE id = ?
  102.  
  103. SQL1_INPUTS = 1
  104.  
  105. [loadPlayer]
  106. SQL1_1 = SELECT p.id,
  107. SQL1_2 = p.name,
  108. SQL1_3 = p.account_uid,
  109. SQL1_4 = p.damage,
  110. SQL1_5 = p.hunger,
  111. SQL1_6 = p.thirst,
  112. SQL1_7 = p.alcohol,
  113. SQL1_8 = p.oxygen_remaining,
  114. SQL1_9 = p.bleeding_remaining,
  115. SQL1_10 = p.hitpoints,
  116. SQL1_11 = p.direction,
  117. SQL1_12 = p.position_x,
  118. SQL1_13 = p.position_y,
  119. SQL1_14 = p.position_z,
  120. SQL1_15 = p.assigned_items,
  121. SQL1_16 = p.backpack,
  122. SQL1_17 = p.backpack_items,
  123. SQL1_18 = p.backpack_magazines,
  124. SQL1_19 = p.backpack_weapons,
  125. SQL1_20 = p.current_weapon,
  126. SQL1_21 = p.goggles,
  127. SQL1_22 = p.handgun_items,
  128. SQL1_23 = p.handgun_weapon,
  129. SQL1_24 = p.headgear,
  130. SQL1_25 = p.binocular,
  131. SQL1_26 = p.loaded_magazines,
  132. SQL1_27 = p.primary_weapon,
  133. SQL1_28 = p.primary_weapon_items,
  134. SQL1_29 = p.secondary_weapon,
  135. SQL1_30 = p.secondary_weapon_items,
  136. SQL1_31 = p.uniform,
  137. SQL1_32 = p.uniform_items,
  138. SQL1_33 = p.uniform_magazines,
  139. SQL1_34 = p.uniform_weapons,
  140. SQL1_35 = p.vest,
  141. SQL1_36 = p.vest_items,
  142. SQL1_37 = p.vest_magazines,
  143. SQL1_38 = p.vest_weapons,
  144. SQL1_39 = p.money,
  145. SQL1_40 = a.score,
  146. SQL1_41 = a.kills,
  147. SQL1_42 = a.deaths,
  148. SQL1_43 = c.id,
  149. SQL1_44 = c.name,
  150. SQL1_45 = p.temperature,
  151. SQL1_46 = p.wetness,
  152. SQL1_47 = a.locker
  153. SQL1_48 = FROM player p
  154. SQL1_49 = INNER JOIN account a
  155. SQL1_50 = ON a.uid = p.account_uid
  156. SQL1_51 = LEFT JOIN clan c
  157. SQL1_52 = ON c.id = a.clan_id
  158. SQL1_53 = WHERE p.account_uid = ?
  159. SQL1_INPUTS = 1
  160. 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
  161.  
  162. [updatePlayer]
  163. SQL1_1 = UPDATE player SET
  164. SQL1_2 = name = ?,
  165. SQL1_3 = damage = ?,
  166. SQL1_4 = hunger = ?,
  167. SQL1_5 = thirst = ?,
  168. SQL1_6 = alcohol = ?,
  169. SQL1_7 = oxygen_remaining = ?,
  170. SQL1_8 = bleeding_remaining = ?,
  171. SQL1_9 = hitpoints = ?,
  172. SQL1_10 = direction = ?,
  173. SQL1_11 = position_x = ?,
  174. SQL1_12 = position_y = ?,
  175. SQL1_13 = position_z = ?,
  176. SQL1_14 = assigned_items = ?,
  177. SQL1_15 = backpack = ?,
  178. SQL1_16 = backpack_items = ?,
  179. SQL1_17 = backpack_magazines = ?,
  180. SQL1_18 = backpack_weapons = ?,
  181. SQL1_19 = current_weapon = ?,
  182. SQL1_20 = goggles = ?,
  183. SQL1_21 = handgun_items = ?,
  184. SQL1_22 = handgun_weapon = ?,
  185. SQL1_23 = headgear = ?,
  186. SQL1_24 = binocular = ?,
  187. SQL1_25 = loaded_magazines = ?,
  188. SQL1_26 = primary_weapon = ?,
  189. SQL1_27 = primary_weapon_items = ?,
  190. SQL1_28 = secondary_weapon = ?,
  191. SQL1_29 = secondary_weapon_items = ?,
  192. SQL1_30 = uniform = ?,
  193. SQL1_31 = uniform_items = ?,
  194. SQL1_32 = uniform_magazines = ?,
  195. SQL1_33 = uniform_weapons = ?,
  196. SQL1_34 = vest = ?,
  197. SQL1_35 = vest_items = ?,
  198. SQL1_36 = vest_magazines = ?,
  199. SQL1_37 = vest_weapons = ?,
  200. SQL1_38 = temperature = ?,
  201. SQL1_39 = wetness = ?
  202. SQL1_40 = WHERE id = ?
  203.  
  204. 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
  205.  
  206. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  207. ;; Vehicle related queries
  208. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  209. [insertVehicle]
  210. SQL1_1 = INSERT INTO vehicle SET
  211. SQL1_2 = class = ?,
  212. SQL1_3 = account_uid = ?,
  213. SQL1_4 = is_locked = ?,
  214. SQL1_5 = position_x = ?,
  215. SQL1_6 = position_y = ?,
  216. SQL1_7 = position_z = ?,
  217. SQL1_8 = direction_x = ?,
  218. SQL1_9 = direction_y = ?,
  219. SQL1_10 = direction_z = ?,
  220. SQL1_11 = up_x = ?,
  221. SQL1_12 = up_y = ?,
  222. SQL1_13 = up_z = ?,
  223. SQL1_14 = pin_code = ?
  224. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13
  225. Return InsertID = true
  226.  
  227. [deleteVehicle]
  228. SQL1_1 = DELETE FROM vehicle WHERE id = ?
  229.  
  230. SQL1_INPUTS = 1
  231.  
  232. [loadVehicleIdPage]
  233. SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL LIMIT ?,?
  234.  
  235. SQL1_INPUTS = 1,2
  236. OUTPUT = 1
  237.  
  238. [loadVehicle]
  239. 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 = ?
  240. SQL1_INPUTS = 1
  241. 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
  242.  
  243. [loadVehicleContainer]
  244. SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ?
  245.  
  246. SQL1_INPUTS = 1
  247. OUTPUT = 1
  248.  
  249. [updateVehicle]
  250. SQL1_1 = UPDATE vehicle SET
  251. SQL1_2 = is_locked = ?,
  252. SQL1_3 = fuel = ?,
  253. SQL1_4 = damage = ?,
  254. SQL1_5 = hitpoints = ?,
  255. SQL1_6 = position_x = ?,
  256. SQL1_7 = position_y = ?,
  257. SQL1_8 = position_z = ?,
  258. SQL1_9 = direction_x = ?,
  259. SQL1_10 = direction_y = ?,
  260. SQL1_11 = direction_z = ?,
  261. SQL1_12 = up_x = ?,
  262. SQL1_13 = up_y = ?,
  263. SQL1_14 = up_z = ?,
  264. SQL1_15 = cargo_items = ?,
  265. SQL1_16 = cargo_magazines = ?,
  266. SQL1_17 = cargo_weapons = ?,
  267. SQL1_18 = cargo_container = ?,
  268. SQL1_19 = money = ?
  269. SQL1_20 = WHERE id = ?
  270. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19
  271.  
  272. [updateVehicleSkin]
  273. SQL1_1 = UPDATE vehicle SET vehicle_texture = ? WHERE id = ?
  274.  
  275. SQL1_INPUTS = 1,2
  276.  
  277. [vehicleSetPinCode]
  278. SQL1_1 = UPDATE vehicle SET pin_code = ? WHERE id = ?
  279.  
  280. SQL1_INPUTS = 1,2
  281.  
  282.  
  283. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  284. ;; Construction related queries
  285. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  286.  
  287. [insertConstruction]
  288. SQL1_1 = INSERT INTO construction SET
  289. SQL1_2 = class = ?,
  290. SQL1_3 = account_uid = ?,
  291. SQL1_4 = position_x = ?,
  292. SQL1_5 = position_y = ?,
  293. SQL1_6 = position_z = ?,
  294. SQL1_7 = direction_x = ?,
  295. SQL1_8 = direction_y = ?,
  296. SQL1_9 = direction_z = ?,
  297. SQL1_10 = up_x = ?,
  298. SQL1_11 = up_y = ?,
  299. SQL1_12 = up_z = ?,
  300. SQL1_13 = territory_id = ?
  301.  
  302. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12-NULL
  303. Return InsertID = true
  304.  
  305. [deleteConstruction]
  306. SQL1_1 = DELETE FROM construction WHERE id = ?
  307.  
  308. SQL1_INPUTS = 1
  309.  
  310. [loadConstructionIdPage]
  311. SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,?
  312.  
  313. SQL1_INPUTS = 1,2
  314. OUTPUT = 1
  315.  
  316. [loadConstruction]
  317. 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 = ?
  318.  
  319. SQL1_INPUTS = 1
  320. OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15-STRING,16,17,18
  321.  
  322. [countConstruction]
  323. SQL1_1 = SELECT COUNT(*) FROM construction
  324.  
  325. OUTPUT = 1
  326.  
  327. [constructionSetPinCode]
  328. SQL1_1 = UPDATE construction SET pin_code= ? WHERE id = ?
  329.  
  330. SQL1_INPUTS = 1,2
  331.  
  332. [upgradeObject]
  333. SQL1_1 = UPDATE construction SET class=? WHERE id = ?
  334.  
  335. SQL1_INPUTS = 1,2
  336.  
  337. [addDoorLock]
  338. SQL1_1 = UPDATE construction SET pin_code = ?,is_locked = -1 WHERE id = ?
  339.  
  340. SQL1_INPUTS = 1,2
  341.  
  342. [updateLock]
  343. SQL1_1 = UPDATE construction SET is_locked = ? WHERE id = ?
  344.  
  345. SQL1_INPUTS = 1,2
  346.  
  347. [updateConstructionTerritoryIDs]
  348. SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?)
  349.  
  350. SQL1_INPUTS = 1,2
  351.  
  352. [updateDamage]
  353. SQL1_1 = UPDATE construction SET damage = ? WHERE id = ?
  354.  
  355. SQL1_INPUTS = 1,2
  356.  
  357. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  358. ;; Containers related queries
  359. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  360.  
  361. [insertContainer]
  362. SQL1_1 = INSERT INTO container SET
  363. SQL1_2 = class = ?,
  364. SQL1_3 = account_uid = ?,
  365. SQL1_4 = position_x = ?,
  366. SQL1_5 = position_y = ?,
  367. SQL1_6 = position_z = ?,
  368. SQL1_7 = direction_x = ?,
  369. SQL1_8 = direction_y = ?,
  370. SQL1_9 = direction_z = ?,
  371. SQL1_10 = up_x = ?,
  372. SQL1_11 = up_y = ?,
  373. SQL1_12 = up_z = ?,
  374. SQL1_13 = cargo_items = ?,
  375. SQL1_14 = cargo_magazines = ?,
  376. SQL1_15 = cargo_weapons = ?,
  377. SQL1_16 = cargo_container = ?,
  378. SQL1_17 = money = ?,
  379. SQL1_18 = pin_code = ?,
  380. SQL1_19 = territory_id = ?
  381.  
  382. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18-NULL
  383. Return InsertID = true
  384.  
  385. [deleteContainer]
  386. SQL1_1 = DELETE FROM container WHERE id = ?
  387.  
  388. SQL1_INPUTS = 1
  389.  
  390. [loadContainerIdPage]
  391. SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,?
  392.  
  393. SQL1_INPUTS = 1,2
  394. OUTPUT = 1
  395.  
  396. [loadContainer]
  397. 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 = ?
  398.  
  399. SQL1_INPUTS = 1
  400. 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
  401.  
  402. [loadContainerCargo]
  403. SQL1_1 = SELECT cargo_container FROM container WHERE id = ?
  404.  
  405. SQL1_INPUTS = 1
  406. OUTPUT = 1
  407.  
  408. [updateContainer]
  409. SQL1_1 = UPDATE container SET
  410. SQL1_2 = is_locked = ?,
  411. SQL1_3 = position_x = ?,
  412. SQL1_4 = position_y = ?,
  413. SQL1_5 = position_z = ?,
  414. SQL1_6 = direction_x = ?,
  415. SQL1_7 = direction_y = ?,
  416. SQL1_8 = direction_z = ?,
  417. SQL1_9 = up_x = ?,
  418. SQL1_10 = up_y = ?,
  419. SQL1_11 = up_z = ?,
  420. SQL1_12 = cargo_items = ?,
  421. SQL1_13 = cargo_magazines = ?,
  422. SQL1_14 = cargo_weapons = ?,
  423. SQL1_15 = cargo_container = ?,
  424. SQL1_16 = territory_id = ?,
  425. SQL1_17 = money = ?
  426. SQL1_18 = WHERE id = ?
  427. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15-NULL,16,17
  428.  
  429. [containerSetPinCode]
  430. SQL1_1 = UPDATE container SET pin_code= ? WHERE id = ?
  431.  
  432. SQL1_INPUTS = 1,2
  433.  
  434. [updateContainerTerritoryIDs]
  435. SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?)
  436.  
  437. SQL1_INPUTS = 1,2
  438.  
  439. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  440. ;; Clan related queries
  441. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  442.  
  443. [createClan]
  444. SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ?
  445.  
  446. SQL1_INPUTS = 1,2
  447. Return InsertID = true
  448.  
  449. [setAccountClanLink]
  450. SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ?
  451.  
  452. SQL1_INPUTS = 1,2
  453.  
  454. [unLinkClanLink]
  455. SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ?
  456.  
  457. SQL1_INPUTS = 1
  458.  
  459. [updateClanLeader]
  460. SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ?
  461.  
  462. SQL1_INPUTS = 1,2
  463.  
  464. [deleteClan]
  465. SQL1_1 = DELETE FROM clan WHERE id = ?
  466.  
  467. SQL1_INPUTS = 1
  468.  
  469. [loadClansIdPage]
  470. SQL1_1 = SELECT id FROM clan LIMIT ?,?
  471.  
  472. SQL1_INPUTS = 1,2
  473. OUTPUT = 1
  474.  
  475. [getClanInfo]
  476. SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ?
  477.  
  478. SQL1_INPUTS = 1
  479. OUTPUT = 1-STRING,2-STRING
  480.  
  481. [getClanMembers]
  482. SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ?
  483.  
  484. SQL1_INPUTS = 1
  485. OUTPUT = 1-STRING,2-STRING
  486.  
  487. [getClanMarkers]
  488. SQL1_1 = SELECT id,markerType,positionArr,color,icon,iconSize,label,labelSize FROM clan_map_marker WHERE clan_id = ?
  489.  
  490. SQL1_INPUTS = 1
  491. OUTPUT = 1,2,3,4,5-STRING,6,7-STRING,8
  492.  
  493. [addMarker]
  494. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 0, positionArr = ?, color = ?, icon = ?, iconSize = ?, label = ?, labelSize = ?
  495.  
  496. SQL1_INPUTS = 1,2,3,4,5,6,7
  497. Return InsertID = true
  498.  
  499. [addPoly]
  500. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 1, positionArr = ?, color = ?
  501.  
  502. SQL1_INPUTS = 1,2,3
  503. Return InsertID = true
  504.  
  505. [deleteMarker]
  506. SQL1_1 = DELETE FROM clan_map_marker WHERE id = ?
  507.  
  508. SQL1_INPUTS = 1
  509.  
  510. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  511. ;; Territory related queries
  512. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  513.  
  514. [createTerritory]
  515. 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 =? , build_rights = ? , moderators = ?
  516.  
  517. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,12-NULL,10,11
  518. Return InsertID = true
  519.  
  520. [loadTerriotryIdPage]
  521. SQL1_1 = SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,?
  522.  
  523. SQL1_INPUTS = 1,2
  524. OUTPUT = 1
  525.  
  526. [loadTerritory]
  527. SQL1_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 = ?) FROM territory WHERE id = ?
  528.  
  529. SQL1_INPUTS = 1,1
  530. OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12,13,14,15,16
  531.  
  532. [setTerritoryLevel]
  533. SQL1_1 = UPDATE territory SET level = ? WHERE id = ?
  534.  
  535. SQL1_INPUTS = 1,2
  536.  
  537. [setTerritorySize]
  538. SQL1_1 = UPDATE territory SET radius = ? WHERE id = ?
  539.  
  540. SQL1_INPUTS = 1,2
  541.  
  542. [updateTerritoryBuildRights]
  543. SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ?
  544.  
  545. SQL1_INPUTS = 1,2
  546.  
  547. [updateTerritoryModerators]
  548. SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ?
  549.  
  550. SQL1_INPUTS = 1,2
  551.  
  552. [maintainTerritory]
  553. SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ?
  554.  
  555. SQL1_INPUTS = 1
  556.  
  557. [deleteTerritory]
  558. SQL1_1 = DELETE FROM territory WHERE id = ?
  559.  
  560. SQL1_INPUTS = 1
  561.  
  562. [flagStolen]
  563. SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ?
  564.  
  565. SQL1_INPUTS = 1,2
  566.  
  567. [flagRestore]
  568. SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ?
  569.  
  570. SQL1_INPUTS = 1
  571.  
  572. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  573. ;; Garbage Collector
  574. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  575.  
  576. ; Marks for deletion containers outside territories that were not accessed within ? days
  577. [markDeleteOldContainers]
  578. 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
  579.  
  580. SQL1_INPUTS = 1
  581.  
  582. ; Removes containers outside territories that were not accessed within ? days
  583. [deleteOldContainers]
  584. SQL1_1 = DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  585.  
  586. SQL1_INPUTS = 1
  587.  
  588. ; Marks contructions outside territories deleted after ? days
  589. [markDeleteOldConstructions]
  590. SQL1_1 = UPDATE construction SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL
  591.  
  592. SQL1_INPUTS = 1
  593.  
  594. ; Removes contructions outside territories after ? days
  595. [deleteOldConstructions]
  596. SQL1_1 = DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  597.  
  598. SQL1_INPUTS = 1
  599.  
  600. ; Marks for deletion vehicles that were not used within ? days
  601. [markDeleteOldVehicles]
  602. SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL
  603.  
  604. SQL1_INPUTS = 1
  605.  
  606. ; Removes vehicles that were not used within ? days
  607. [deleteOldVehicles]
  608. SQL1_1 = DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  609.  
  610. SQL1_INPUTS = 1
  611.  
  612. ; Marks territories (and all containers/constructions) that were not paid within ? days as deleted
  613. [markDeleteUnpaidTerritories]
  614. SQL1_1 = UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL
  615. 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)
  616. 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)
  617. SQL1_INPUTS = 1
  618.  
  619. ; Removes territories (and all containers/constructions) that were not paid within ? days
  620. [deleteUnpaidTerritories]
  621. SQL1_1 = DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  622.  
  623. SQL1_INPUTS = 1
  624.  
  625. [addAbandonedSafes]
  626. 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
  627.  
  628. SQL1_INPUTS = 1
  629.  
  630. [deleteBaseFlagStolen]
  631. SQL1_1 = DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  632.  
  633. SQL1_INPUTS = 1
  634.  
  635. ; Unlock doors and mark safes as abandoned if flag stolen for X days
  636. [setAbandonedUnlocked]
  637. 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));
  638. 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'
  639.  
  640. SQL1_INPUTS = 1
  641. SQL2_INPUTS = 1
  642.  
  643. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  644. ;; Moneh moneh moneh
  645. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  646.  
  647. [setPlayerMoney]
  648. SQL1_1 = UPDATE player SET money = ? WHERE id = ?
  649.  
  650. SQL1_INPUTS = 1,2
  651.  
  652. [getPlayerMoney]
  653. SQL1_1 = SELECT money FROM player WHERE id = ?
  654.  
  655. SQL1_INPUTS = 1
  656. OUTPUT = 1
  657.  
  658. [setContainerMoney]
  659. SQL1_1 = UPDATE container SET money = ? WHERE id = ?
  660.  
  661. SQL1_INPUTS = 1,2
  662.  
  663. [setVehicleMoney]
  664. SQL1_1 = UPDATE vehicle SET money = ? WHERE id = ?
  665.  
  666. SQL1_INPUTS = 1,2
  667.  
  668. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  669. ;; XM8
  670. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  671.  
  672. [getAllNotifTerritory]
  673. SQL1_1 = SELECT id FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? - 1 DAY) and xm8_protectionmoney_notified = 0
  674.  
  675. SQL1_INPUTS = 1
  676.  
  677. [setTerritoryNotified]
  678. SQL1_1 = UPDATE territory SET xm8_protectionmoney_notified = ? WHERE id = ?
  679.  
  680. SQL1_INPUTS = 1,2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement