SHARE
TWEET

exile.ini

twisted87 Nov 25th, 2016 110 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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 deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  234. SQL1_1 = DELETE FROM vehicle WHERE territory_id IS NULL AND deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  235. Number Of Inputs = 1
  236. SQL1_INPUTS = 1
  237.  
  238. [loadVehicleIdPage]
  239. ;SQL1_1 = SELECT id FROM vehicle LIMIT ?,?
  240. SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL AND territory_id IS NULL LIMIT ?,?
  241. Number Of Inputs = 2
  242. SQL1_INPUTS = 1,2
  243. OUTPUT = 1 
  244.  
  245. [loadVehicle]
  246. 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 = ?
  247. Number Of Inputs = 1
  248. SQL1_INPUTS = 1
  249. 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
  250.  
  251. [loadVehicleContainer]
  252. SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ?
  253. Number Of Inputs = 1
  254. SQL1_INPUTS = 1
  255. OUTPUT = 1
  256.  
  257. [updateVehicle]
  258. SQL1_1 = UPDATE vehicle SET
  259. SQL1_2 = is_locked = ?,
  260. SQL1_3 = fuel = ?,
  261. SQL1_4 = damage = ?,
  262. SQL1_5 = hitpoints = ?,
  263. SQL1_6 = position_x = ?,
  264. SQL1_7 = position_y = ?,
  265. SQL1_8 = position_z = ?,
  266. SQL1_9 = direction_x = ?,
  267. SQL1_10 = direction_y = ?,
  268. SQL1_11 = direction_z = ?,
  269. SQL1_12 = up_x = ?,
  270. SQL1_13 = up_y = ?,
  271. SQL1_14 = up_z = ?,
  272. SQL1_15 = cargo_items = ?,
  273. SQL1_16 = cargo_magazines = ?,
  274. SQL1_17 = cargo_weapons = ?,
  275. SQL1_18 = cargo_container = ?,
  276. SQL1_19 = money = ?
  277. SQL1_20 = WHERE id = ?
  278. Number of Inputs = 19
  279. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19
  280.  
  281. [updateVehicleSkin]
  282. SQL1_1 = UPDATE vehicle SET vehicle_texture = ? WHERE id = ?
  283. Number of Inputs = 2
  284. SQL1_INPUTS = 1,2
  285.  
  286. [vehicleSetPinCode]
  287. SQL1_1 = UPDATE vehicle SET pin_code = ? WHERE id = ?
  288. Number of Inputs = 2
  289. SQL1_INPUTS = 1,2
  290.  
  291.  
  292. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  293. ;; Construction related queries
  294. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  295.  
  296. [insertConstruction]
  297. SQL1_1 = INSERT INTO construction SET
  298. SQL1_2 = class = ?,
  299. SQL1_3 = account_uid = ?,
  300. SQL1_4 = position_x = ?,
  301. SQL1_5 = position_y = ?,
  302. SQL1_6 = position_z = ?,
  303. SQL1_7 = direction_x = ?,
  304. SQL1_8 = direction_y = ?,
  305. SQL1_9 = direction_z = ?,
  306. SQL1_10 = up_x = ?,
  307. SQL1_11 = up_y = ?,
  308. SQL1_12 = up_z = ?,
  309. SQL1_13 = territory_id = $CUSTOM_1$
  310. Number of Inputs = 11
  311. Number of Custom Inputs = 1
  312. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11
  313. Return InsertID = true
  314.  
  315. [deleteConstruction]
  316. SQL1_1 = DELETE FROM construction WHERE id = ?
  317. Number Of Inputs = 1
  318. SQL1_INPUTS = 1
  319.  
  320. [loadConstructionIdPage]
  321. SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,?
  322. Number Of Inputs = 2
  323. SQL1_INPUTS = 1,2
  324. OUTPUT = 1
  325.  
  326. [loadConstruction]
  327. 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 = ?
  328. Number Of Inputs = 1
  329. SQL1_INPUTS = 1
  330. OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15-STRING,16,17,18
  331.  
  332. [countConstruction]
  333. SQL1_1 = SELECT COUNT(*) FROM construction
  334. Number Of Inputs = 0
  335. OUTPUT = 1
  336.  
  337. [constructionSetPinCode]
  338. SQL1_1 = UPDATE construction SET pin_code= ? WHERE id = ?
  339. Number of Inputs = 2
  340. SQL1_INPUTS = 1,2
  341.  
  342. [upgradeObject]
  343. SQL1_1 = UPDATE construction SET class=? WHERE id = ?
  344. Number of Inputs = 2
  345. SQL1_INPUTS = 1,2
  346.  
  347. [addDoorLock]
  348. SQL1_1 = UPDATE construction SET pin_code = ?,is_locked = -1 WHERE id = ?
  349. Number of Inputs = 2
  350. SQL1_INPUTS = 1,2
  351.  
  352. [updateLock]
  353. SQL1_1 = UPDATE construction SET is_locked = ? WHERE id = ?
  354. Number of Inputs = 2
  355. SQL1_INPUTS = 1,2
  356.  
  357. [updateConstructionTerritoryIDs]
  358. SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?)
  359. Number of Inputs = 2
  360. SQL1_INPUTS = 1,2
  361.  
  362. [updateDamage]
  363. SQL1_1 = UPDATE construction SET damage = ? WHERE id = ?
  364. Number of Inputs = 2
  365. SQL1_INPUTS = 1,2
  366.  
  367. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  368. ;; Containers related queries
  369. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  370.  
  371. [insertContainer]
  372. SQL1_1 = INSERT INTO container SET
  373. SQL1_2 = class = ?,
  374. SQL1_3 = account_uid = ?,
  375. SQL1_4 = position_x = ?,
  376. SQL1_5 = position_y = ?,
  377. SQL1_6 = position_z = ?,
  378. SQL1_7 = direction_x = ?,
  379. SQL1_8 = direction_y = ?,
  380. SQL1_9 = direction_z = ?,
  381. SQL1_10 = up_x = ?,
  382. SQL1_11 = up_y = ?,
  383. SQL1_12 = up_z = ?,
  384. SQL1_13 = cargo_items = ?,
  385. SQL1_14 = cargo_magazines = ?,
  386. SQL1_15 = cargo_weapons = ?,
  387. SQL1_16 = cargo_container = ?,
  388. SQL1_17 = money = ?,
  389. SQL1_18 = pin_code = ?,
  390. SQL1_19 = territory_id = $CUSTOM_1$
  391. Number of Inputs = 17
  392. Number of Custom Inputs = 1
  393. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17
  394. Return InsertID = true
  395.  
  396. [deleteContainer]
  397. SQL1_1 = DELETE FROM container WHERE id = ?
  398. Number Of Inputs = 1
  399. SQL1_INPUTS = 1
  400.  
  401. [loadContainerIdPage]
  402. SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,?
  403. Number Of Inputs = 2
  404. SQL1_INPUTS = 1,2
  405. OUTPUT = 1
  406.  
  407. [loadContainer]
  408. 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 = ?
  409. Number Of Inputs = 1
  410. SQL1_INPUTS = 1
  411. 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
  412.  
  413. [loadContainerCargo]
  414. SQL1_1 = SELECT cargo_container FROM container WHERE id = ?
  415. Number Of Inputs = 1
  416. SQL1_INPUTS = 1
  417. OUTPUT = 1
  418.  
  419. [updateContainer]
  420. SQL1_1 = UPDATE container SET
  421. SQL1_2 = is_locked = ?,
  422. SQL1_3 = position_x = ?,
  423. SQL1_4 = position_y = ?,
  424. SQL1_5 = position_z = ?,
  425. SQL1_6 = direction_x = ?,
  426. SQL1_7 = direction_y = ?,
  427. SQL1_8 = direction_z = ?,
  428. SQL1_9 = up_x = ?,
  429. SQL1_10 = up_y = ?,
  430. SQL1_11 = up_z = ?,
  431. SQL1_12 = cargo_items = ?,
  432. SQL1_13 = cargo_magazines = ?,
  433. SQL1_14 = cargo_weapons = ?,
  434. SQL1_15 = cargo_container = ?,
  435. SQL1_16 = territory_id = $CUSTOM_1$,
  436. SQL1_17 = money = ?
  437. SQL1_18 = WHERE id = ?
  438. Number of Inputs = 16
  439. Number of Custom Inputs = 1
  440. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16
  441.  
  442. [containerSetPinCode]
  443. SQL1_1 = UPDATE container SET pin_code= ? WHERE id = ?
  444. Number of Inputs = 2
  445. SQL1_INPUTS = 1,2
  446.  
  447. [updateContainerTerritoryIDs]
  448. SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?)
  449. Number of Inputs = 2
  450. SQL1_INPUTS = 1,2
  451.  
  452. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  453. ;; Clan related queries
  454. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  455.  
  456. [createClan]
  457. SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ?
  458. Number Of Inputs = 2
  459. SQL1_INPUTS = 1,2
  460. Return InsertID = true
  461.  
  462. [setAccountClanLink]
  463. SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ?
  464. Number Of Inputs = 2
  465. SQL1_INPUTS = 1,2
  466.  
  467. [unLinkClanLink]
  468. SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ?
  469. Number Of Inputs = 1
  470. SQL1_INPUTS = 1
  471.  
  472. [updateClanLeader]
  473. SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ?
  474. Number Of Inputs = 2
  475. SQL1_INPUTS = 1,2
  476.  
  477. [deleteClan]
  478. SQL1_1 = DELETE FROM clan WHERE id = ?
  479. Number Of Inputs = 1
  480. SQL1_INPUTS = 1
  481.  
  482. [loadClansIdPage]
  483. SQL1_1 = SELECT id FROM clan LIMIT ?,?
  484. Number Of Inputs = 2
  485. SQL1_INPUTS = 1,2
  486. OUTPUT = 1
  487.  
  488. [getClanInfo]
  489. SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ?
  490. Number Of Inputs = 1
  491. SQL1_INPUTS = 1
  492. OUTPUT = 1-STRING,2-STRING
  493.  
  494. [getClanMembers]
  495. SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ?
  496. Number Of Inputs = 1
  497. SQL1_INPUTS = 1
  498. OUTPUT = 1-STRING,2-STRING
  499.  
  500. [getClanMarkers]
  501. SQL1_1 = SELECT id,markerType,positionArr,color,icon,iconSize,label,labelSize FROM clan_map_marker WHERE clan_id = ?
  502. Number Of Inputs = 1
  503. SQL1_INPUTS = 1
  504. OUTPUT = 1,2,3,4,5-STRING,6,7-STRING,8
  505.  
  506. [addMarker]
  507. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 0, positionArr = ?, color = ?, icon = ?, iconSize = ?, label = ?, labelSize = ?
  508. Number Of Inputs = 7
  509. SQL1_INPUTS = 1,2,3,4,5,6,7
  510. Return InsertID = true
  511.  
  512. [addPoly]
  513. SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 1, positionArr = ?, color = ?
  514. Number Of Inputs = 3
  515. SQL1_INPUTS = 1,2,3
  516. Return InsertID = true
  517.  
  518. [deleteMarker]
  519. SQL1_1 = DELETE FROM clan_map_marker WHERE id = ?
  520. Number Of Inputs = 1
  521. SQL1_INPUTS = 1
  522.  
  523. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  524. ;; Territory related queries
  525. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  526.  
  527. [createTerritory]
  528. 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 = ?
  529. Number Of Inputs = 11
  530. Number Of Custom Inputs = 1
  531. SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11
  532. Return InsertID = true
  533.  
  534. [loadTerriotryIdPage]
  535. SQL1_1 = SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,?
  536. Number Of Inputs = 2
  537. SQL1_INPUTS = 1,2
  538. OUTPUT = 1
  539.  
  540. [loadTerritory]
  541. SQL1_1 = SET @connector = ?;
  542. 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
  543. Number Of Inputs = 1
  544. SQL1_INPUTS = 1
  545. OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12-DateTime_ISO8601,13,14,15,16
  546.  
  547. [setTerritoryLevel]
  548. SQL1_1 = UPDATE territory SET level = ? WHERE id = ?
  549. Number Of Inputs = 2
  550. SQL1_INPUTS = 1,2
  551.  
  552. [setTerritorySize]
  553. SQL1_1 = UPDATE territory SET radius = ? WHERE id = ?
  554. Number Of Inputs = 2
  555. SQL1_INPUTS = 1,2
  556.  
  557. [updateTerritoryBuildRights]
  558. SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ?
  559. Number Of Inputs = 2
  560. SQL1_INPUTS = 1,2
  561.  
  562. [updateTerritoryModerators]
  563. SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ?
  564. Number Of Inputs = 2
  565. SQL1_INPUTS = 1,2
  566.  
  567. [maintainTerritory]
  568. SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ?
  569. Number Of Inputs = 1
  570. SQL1_INPUTS = 1
  571.  
  572. [deleteTerritory]
  573. SQL1_1 = DELETE FROM territory WHERE id = ?
  574. Number Of Inputs = 1
  575. SQL1_INPUTS = 1
  576.  
  577. [flagStolen]
  578. SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ?
  579. Number of Inputs = 2
  580. SQL1_INPUTS = 1,2
  581.  
  582. [flagRestore]
  583. SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ?
  584. Number of Inputs = 1
  585. SQL1_INPUTS = 1
  586.  
  587. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  588. ;; Garbage Collector
  589. ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
  590.  
  591. ; Marks for deletion containers outside territories that were not accessed within ? days
  592. [markDeleteOldContainers]
  593. 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
  594. Number Of Inputs = 1
  595. SQL1_INPUTS = 1
  596.  
  597. ; Removes containers outside territories that were not accessed within ? days
  598. [deleteOldContainers]
  599. SQL1_1 = DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  600. Number Of Inputs = 1
  601. SQL1_INPUTS = 1
  602.  
  603. ; Marks contructions outside territories deleted after ? days
  604. [markDeleteOldConstructions]
  605. 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
  606. Number Of Inputs = 1
  607. SQL1_INPUTS = 1
  608.  
  609. ; Removes contructions outside territories after ? days
  610. [deleteOldConstructions]
  611. SQL1_1 = DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  612. Number Of Inputs = 1
  613. SQL1_INPUTS = 1
  614.  
  615. ; Marks for deletion vehicles that were not used within ? days
  616. [markDeleteOldVehicles]
  617. ; SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY)
  618. SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL
  619. Number Of Inputs = 1
  620. SQL1_INPUTS = 1
  621.  
  622. ; Removes vehicles that were not used within ? days
  623. [deleteOldVehicles]
  624. SQL1_1 = DELETE FROM vehicle WHERE 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) AND deleted_at IS NULL
  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.  
  701. [loadTerritoryVehicles]
  702. SQL1_1 = SELECT id, class FROM vehicle WHERE territory_id = ?
  703. Number Of Inputs = 1
  704. SQL1_INPUTS = 1
  705. OUTPUT = 1,2-STRING
  706.  
  707. [loadVehFromVG]
  708. SQL1_1 = UPDATE vehicle SET territory_id = NULL WHERE id = ?
  709. Number Of Inputs = 1
  710. SQL1_INPUTS = 1
  711.  
  712. [loadVehToVG]
  713. SQL1_1 = UPDATE vehicle SET territory_id = ? WHERE id = ?
  714. Number Of Inputs = 2
  715. SQL1_INPUTS = 1,2
RAW Paste Data
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
 
Top