Last active
April 1, 2018 14:46
-
-
Save BrettNordin/384861480a91591e547170156e04534b to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[Default] | |
Version = 1 | |
Strip Chars = "\/\|;{}<>\'" | |
Strip Chars Mode = 0 | |
Input SQF Parser = false | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Account related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Account related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[isKnownAccount] | |
SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END | |
SQL1_INPUTS = 1 | |
OUTPUT = 1 | |
[createAccount] | |
SQL1_1 = INSERT INTO account SET uid = ?, name = ? | |
SQL1_INPUTS = 1,2 | |
[startAccountSession] | |
SQL1_1 = UPDATE account SET name = ?, last_connect_at = NOW(), total_connections = total_connections + 1 WHERE uid = ? | |
SQL1_INPUTS = 2,1 | |
[endAccountSession] | |
SQL1_1 = UPDATE account SET last_disconnect_at = NOW() WHERE uid = ? | |
SQL1_INPUTS = 1 | |
[getAccountStats] | |
SQL1_1 = SELECT score, kills, deaths, clan_id, locker FROM account WHERE uid = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1,2,3,4,5 | |
[addAccountKill] | |
SQL1_1 = UPDATE account SET kills = kills + 1 WHERE uid = ? | |
SQL1_INPUTS = 1 | |
[addAccountDeath] | |
SQL1_1 = UPDATE account SET deaths = deaths + 1 WHERE uid = ? | |
SQL1_INPUTS = 1 | |
[getAccountScore] | |
SQL1_1 = SELECT score FROM account WHERE uid = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1 | |
[setAccountScore] | |
SQL1_1 = UPDATE account SET score = ? WHERE uid = ? | |
SQL1_INPUTS = 1,2 | |
[modifyAccountScore] | |
SQL1_1 = UPDATE account SET score = score + ? WHERE uid = ? | |
SQL1_INPUTS = 1,2 | |
[updateLocker] | |
SQL1_1 = UPDATE account SET locker = ? WHERE uid = ? | |
SQL1_INPUTS = 1,2 | |
[getLocker] | |
SQL1_1 = SELECT locker FROM account WHERE uid = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Player related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[hasAlivePlayer] | |
SQL1_1 = SELECT CASE WHEN EXISTS(SELECT account_uid FROM player WHERE account_uid = ? AND damage < 1) THEN 'true' ELSE 'false' END | |
SQL1_INPUTS = 1 | |
OUTPUT = 1 | |
[createPlayer] | |
SQL1_1 = INSERT INTO player SET account_uid = ?, name = ? | |
SQL1_INPUTS = 1,2 | |
Return InsertID = true | |
[insertPlayerHistory] | |
SQL1_1 = INSERT INTO player_history SET account_uid = ?, name = ?, position_x = ?, position_y = ?, position_z = ? | |
SQL1_INPUTS = 1,2,3,4,5 | |
[deletePlayer] | |
SQL1_1 = DELETE FROM player WHERE id = ? | |
SQL1_INPUTS = 1 | |
[loadPlayer] | |
SQL1_1 = SELECT p.id, | |
SQL1_2 = p.name, | |
SQL1_3 = p.account_uid, | |
SQL1_4 = p.damage, | |
SQL1_5 = p.hunger, | |
SQL1_6 = p.thirst, | |
SQL1_7 = p.alcohol, | |
SQL1_8 = p.oxygen_remaining, | |
SQL1_9 = p.bleeding_remaining, | |
SQL1_10 = p.hitpoints, | |
SQL1_11 = p.direction, | |
SQL1_12 = p.position_x, | |
SQL1_13 = p.position_y, | |
SQL1_14 = p.position_z, | |
SQL1_15 = p.assigned_items, | |
SQL1_16 = p.backpack, | |
SQL1_17 = p.backpack_items, | |
SQL1_18 = p.backpack_magazines, | |
SQL1_19 = p.backpack_weapons, | |
SQL1_20 = p.current_weapon, | |
SQL1_21 = p.goggles, | |
SQL1_22 = p.handgun_items, | |
SQL1_23 = p.handgun_weapon, | |
SQL1_24 = p.headgear, | |
SQL1_25 = p.binocular, | |
SQL1_26 = p.loaded_magazines, | |
SQL1_27 = p.primary_weapon, | |
SQL1_28 = p.primary_weapon_items, | |
SQL1_29 = p.secondary_weapon, | |
SQL1_30 = p.secondary_weapon_items, | |
SQL1_31 = p.uniform, | |
SQL1_32 = p.uniform_items, | |
SQL1_33 = p.uniform_magazines, | |
SQL1_34 = p.uniform_weapons, | |
SQL1_35 = p.vest, | |
SQL1_36 = p.vest_items, | |
SQL1_37 = p.vest_magazines, | |
SQL1_38 = p.vest_weapons, | |
SQL1_39 = p.money, | |
SQL1_40 = a.score, | |
SQL1_41 = a.kills, | |
SQL1_42 = a.deaths, | |
SQL1_43 = c.id, | |
SQL1_44 = c.name, | |
SQL1_45 = p.temperature, | |
SQL1_46 = p.wetness, | |
SQL1_47 = a.locker | |
SQL1_48 = FROM player p | |
SQL1_49 = INNER JOIN account a | |
SQL1_50 = ON a.uid = p.account_uid | |
SQL1_51 = LEFT JOIN clan c | |
SQL1_52 = ON c.id = a.clan_id | |
SQL1_53 = WHERE p.account_uid = ? | |
SQL1_INPUTS = 1 | |
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 | |
[updatePlayer] | |
SQL1_1 = UPDATE player SET | |
SQL1_2 = name = ?, | |
SQL1_3 = damage = ?, | |
SQL1_4 = hunger = ?, | |
SQL1_5 = thirst = ?, | |
SQL1_6 = alcohol = ?, | |
SQL1_7 = oxygen_remaining = ?, | |
SQL1_8 = bleeding_remaining = ?, | |
SQL1_9 = hitpoints = ?, | |
SQL1_10 = direction = ?, | |
SQL1_11 = position_x = ?, | |
SQL1_12 = position_y = ?, | |
SQL1_13 = position_z = ?, | |
SQL1_14 = assigned_items = ?, | |
SQL1_15 = backpack = ?, | |
SQL1_16 = backpack_items = ?, | |
SQL1_17 = backpack_magazines = ?, | |
SQL1_18 = backpack_weapons = ?, | |
SQL1_19 = current_weapon = ?, | |
SQL1_20 = goggles = ?, | |
SQL1_21 = handgun_items = ?, | |
SQL1_22 = handgun_weapon = ?, | |
SQL1_23 = headgear = ?, | |
SQL1_24 = binocular = ?, | |
SQL1_25 = loaded_magazines = ?, | |
SQL1_26 = primary_weapon = ?, | |
SQL1_27 = primary_weapon_items = ?, | |
SQL1_28 = secondary_weapon = ?, | |
SQL1_29 = secondary_weapon_items = ?, | |
SQL1_30 = uniform = ?, | |
SQL1_31 = uniform_items = ?, | |
SQL1_32 = uniform_magazines = ?, | |
SQL1_33 = uniform_weapons = ?, | |
SQL1_34 = vest = ?, | |
SQL1_35 = vest_items = ?, | |
SQL1_36 = vest_magazines = ?, | |
SQL1_37 = vest_weapons = ?, | |
SQL1_38 = temperature = ?, | |
SQL1_39 = wetness = ? | |
SQL1_40 = WHERE id = ? | |
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 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Vehicle related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[insertVehicle] | |
SQL1_1 = INSERT INTO vehicle SET | |
SQL1_2 = class = ?, | |
SQL1_3 = account_uid = ?, | |
SQL1_4 = is_locked = ?, | |
SQL1_5 = position_x = ?, | |
SQL1_6 = position_y = ?, | |
SQL1_7 = position_z = ?, | |
SQL1_8 = direction_x = ?, | |
SQL1_9 = direction_y = ?, | |
SQL1_10 = direction_z = ?, | |
SQL1_11 = up_x = ?, | |
SQL1_12 = up_y = ?, | |
SQL1_13 = up_z = ?, | |
SQL1_14 = pin_code = ? | |
SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13 | |
Return InsertID = true | |
[deleteVehicle] | |
SQL1_1 = DELETE FROM vehicle WHERE id = ? | |
SQL1_INPUTS = 1 | |
[loadVehicleIdPage] | |
SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL AND territory_id IS NULL LIMIT ?,? | |
SQL1_INPUTS = 1,2 | |
OUTPUT = 1 | |
[loadVehicle] | |
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 = ? | |
SQL1_INPUTS = 1 | |
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 | |
[loadVehicleContainer] | |
SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1 | |
[updateVehicle] | |
SQL1_1 = UPDATE vehicle SET | |
SQL1_2 = is_locked = ?, | |
SQL1_3 = fuel = ?, | |
SQL1_4 = damage = ?, | |
SQL1_5 = hitpoints = ?, | |
SQL1_6 = position_x = ?, | |
SQL1_7 = position_y = ?, | |
SQL1_8 = position_z = ?, | |
SQL1_9 = direction_x = ?, | |
SQL1_10 = direction_y = ?, | |
SQL1_11 = direction_z = ?, | |
SQL1_12 = up_x = ?, | |
SQL1_13 = up_y = ?, | |
SQL1_14 = up_z = ?, | |
SQL1_15 = cargo_items = ?, | |
SQL1_16 = cargo_magazines = ?, | |
SQL1_17 = cargo_weapons = ?, | |
SQL1_18 = cargo_container = ?, | |
SQL1_19 = money = ?, | |
SQL1_20 = last_updated_at = NOW() | |
SQL1_21 = WHERE id = ? | |
SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19 | |
[updateVehicleSkin] | |
SQL1_1 = UPDATE vehicle SET vehicle_texture = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[vehicleSetPinCode] | |
SQL1_1 = UPDATE vehicle SET pin_code = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[storeVehicle] | |
SQL1_1 = UPDATE vehicle SET territory_id = ?, nickname = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2,3 | |
[retrieveVehicle] | |
SQL1_1 = UPDATE vehicle SET territory_id = NULL, last_updated_at = NOW(), nickname = '' WHERE id = ? | |
SQL1_INPUTS = 1 | |
[confirmVehicleOwnership] | |
SQL1_1 = SELECT id, territory_id FROM vehicle WHERE nickname = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1,2 | |
[loadTerritoryVirtualGarage] | |
SQL1_1 = SELECT class, nickname FROM vehicle WHERE territory_id = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1-STRING,2-STRING | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Construction related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[insertConstruction] | |
SQL1_1 = INSERT INTO construction SET | |
SQL1_2 = class = ?, | |
SQL1_3 = account_uid = ?, | |
SQL1_4 = position_x = ?, | |
SQL1_5 = position_y = ?, | |
SQL1_6 = position_z = ?, | |
SQL1_7 = direction_x = ?, | |
SQL1_8 = direction_y = ?, | |
SQL1_9 = direction_z = ?, | |
SQL1_10 = up_x = ?, | |
SQL1_11 = up_y = ?, | |
SQL1_12 = up_z = ?, | |
SQL1_13 = territory_id = ? | |
SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12-NULL | |
Return InsertID = true | |
[deleteConstruction] | |
SQL1_1 = DELETE FROM construction WHERE id = ? | |
SQL1_INPUTS = 1 | |
[loadConstructionIdPage] | |
SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,? | |
SQL1_INPUTS = 1,2 | |
OUTPUT = 1 | |
[loadConstruction] | |
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 = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15-STRING,16,17,18 | |
[countConstruction] | |
SQL1_1 = SELECT COUNT(*) FROM construction | |
OUTPUT = 1 | |
[constructionSetPinCode] | |
SQL1_1 = UPDATE construction SET pin_code= ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[upgradeObject] | |
SQL1_1 = UPDATE construction SET class = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[addDoorLock] | |
SQL1_1 = UPDATE construction SET pin_code = ?, is_locked = -1, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[removeDoorLock] | |
SQL1_1 = UPDATE construction SET pin_code = '000000', is_locked = 0, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1 | |
[updateLock] | |
SQL1_1 = UPDATE construction SET is_locked = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[updateConstructionTerritoryIDs] | |
SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?) | |
SQL1_INPUTS = 1,2 | |
[updateDamage] | |
SQL1_1 = UPDATE construction SET damage = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Containers related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[insertContainer] | |
SQL1_1 = INSERT INTO container SET | |
SQL1_2 = class = ?, | |
SQL1_3 = account_uid = ?, | |
SQL1_4 = position_x = ?, | |
SQL1_5 = position_y = ?, | |
SQL1_6 = position_z = ?, | |
SQL1_7 = direction_x = ?, | |
SQL1_8 = direction_y = ?, | |
SQL1_9 = direction_z = ?, | |
SQL1_10 = up_x = ?, | |
SQL1_11 = up_y = ?, | |
SQL1_12 = up_z = ?, | |
SQL1_13 = cargo_items = ?, | |
SQL1_14 = cargo_magazines = ?, | |
SQL1_15 = cargo_weapons = ?, | |
SQL1_16 = cargo_container = ?, | |
SQL1_17 = money = ?, | |
SQL1_18 = pin_code = ?, | |
SQL1_19 = territory_id = ? | |
SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18-NULL | |
Return InsertID = true | |
[deleteContainer] | |
SQL1_1 = DELETE FROM container WHERE id = ? | |
SQL1_INPUTS = 1 | |
[loadContainerIdPage] | |
SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,? | |
SQL1_INPUTS = 1,2 | |
OUTPUT = 1 | |
[loadContainer] | |
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 = ? | |
SQL1_INPUTS = 1 | |
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 | |
[loadContainerCargo] | |
SQL1_1 = SELECT cargo_container FROM container WHERE id = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1 | |
[updateContainer] | |
SQL1_1 = UPDATE container SET | |
SQL1_2 = is_locked = ?, | |
SQL1_3 = position_x = ?, | |
SQL1_4 = position_y = ?, | |
SQL1_5 = position_z = ?, | |
SQL1_6 = direction_x = ?, | |
SQL1_7 = direction_y = ?, | |
SQL1_8 = direction_z = ?, | |
SQL1_9 = up_x = ?, | |
SQL1_10 = up_y = ?, | |
SQL1_11 = up_z = ?, | |
SQL1_12 = cargo_items = ?, | |
SQL1_13 = cargo_magazines = ?, | |
SQL1_14 = cargo_weapons = ?, | |
SQL1_15 = cargo_container = ?, | |
SQL1_16 = territory_id = ?, | |
SQL1_17 = money = ?, | |
SQL1_18 = last_updated_at = NOW() | |
SQL1_19 = WHERE id = ? | |
SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15-NULL,16,17 | |
[containerSetPinCode] | |
SQL1_1 = UPDATE container SET pin_code= ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[updateContainerTerritoryIDs] | |
SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?) | |
SQL1_INPUTS = 1,2 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Clan related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[createClan] | |
SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ? | |
SQL1_INPUTS = 1,2 | |
Return InsertID = true | |
[setAccountClanLink] | |
SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ? | |
SQL1_INPUTS = 1,2 | |
[unLinkClanLink] | |
SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ? | |
SQL1_INPUTS = 1 | |
[updateClanLeader] | |
SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[deleteClan] | |
SQL1_1 = DELETE FROM clan WHERE id = ? | |
SQL1_INPUTS = 1 | |
[loadClansIdPage] | |
SQL1_1 = SELECT id FROM clan LIMIT ?,? | |
SQL1_INPUTS = 1,2 | |
OUTPUT = 1 | |
[getClanInfo] | |
SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1-STRING,2-STRING | |
[getClanMembers] | |
SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1-STRING,2-STRING | |
[getClanMarkers] | |
SQL1_1 = SELECT id,markerType,positionArr,color,icon,iconSize,label,labelSize FROM clan_map_marker WHERE clan_id = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1,2,3,4,5-STRING,6,7-STRING,8 | |
[addMarker] | |
SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 0, positionArr = ?, color = ?, icon = ?, iconSize = ?, label = ?, labelSize = ? | |
SQL1_INPUTS = 1,2,3,4,5,6,7 | |
Return InsertID = true | |
[addPoly] | |
SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 1, positionArr = ?, color = ? | |
SQL1_INPUTS = 1,2,3 | |
Return InsertID = true | |
[deleteMarker] | |
SQL1_1 = DELETE FROM clan_map_marker WHERE id = ? | |
SQL1_INPUTS = 1 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Territory related queries | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[createTerritory] | |
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 = ? | |
SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12 | |
Return InsertID = true | |
[loadTerriotryIdPage] | |
SQL1_1 = SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,? | |
SQL1_INPUTS = 1,2 | |
OUTPUT = 1 | |
[loadTerritory] | |
SQL1_1 = SET @connector = ?; | |
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 | |
SQL1_INPUTS = 1 | |
OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12,13,14,15,16 | |
[setTerritoryLevel] | |
SQL1_1 = UPDATE territory SET level = ? WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[setTerritorySize] | |
SQL1_1 = UPDATE territory SET radius = ? WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[updateTerritoryBuildRights] | |
SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[updateTerritoryModerators] | |
SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[maintainTerritory] | |
SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ? | |
SQL1_INPUTS = 1 | |
[deleteTerritory] | |
SQL1_1 = DELETE FROM territory WHERE id = ? | |
SQL1_INPUTS = 1 | |
[flagStolen] | |
SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[flagRestore] | |
SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ? | |
SQL1_INPUTS = 1 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Garbage Collector | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
; Marks for deletion containers outside territories that were not accessed within ? days | |
[markDeleteOldContainers] | |
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 | |
SQL1_INPUTS = 1 | |
; Removes containers outside territories that were not accessed within ? days | |
[deleteOldContainers] | |
SQL1_1 = DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL | |
SQL1_INPUTS = 1 | |
; Marks contructions outside territories deleted after ? days | |
[markDeleteOldConstructions] | |
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 | |
SQL1_INPUTS = 1 | |
; Removes contructions outside territories after ? days | |
[deleteOldConstructions] | |
SQL1_1 = DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL | |
SQL2_1 = SET SQL_SAFE_UPDATES=0; | |
SQL3_1 = DELETE FROM construction WHERE id IN (SELECT id FROM (SELECT * FROM construction WHERE NOT EXISTS (SELECT NULL FROM territory WHERE territory.id = construction.territory_id)) AS c) | |
SQL4_1 = SET SQL_SAFE_UPDATES=1; | |
SQL1_INPUTS = 1 | |
; Marks for deletion vehicles that were not used within ? days | |
[markDeleteOldVehicles] | |
SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL | |
SQL1_INPUTS = 1 | |
; Removes vehicles that were not used within ? days | |
[deleteOldVehicles] | |
SQL1_1 = DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) | |
SQL1_INPUTS = 1 | |
; Marks territories (and all containers/constructions) that were not paid within ? days as deleted | |
[markDeleteUnpaidTerritories] | |
SQL1_1 = UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL | |
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 | |
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 | |
SQL1_INPUTS = 1 | |
; Removes territories (and all containers/constructions) that were not paid within ? days | |
[deleteUnpaidTerritories] | |
SQL1_1 = DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) | |
SQL1_INPUTS = 1 | |
[addAbandonedSafes] | |
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 | |
SQL1_INPUTS = 1 | |
[deleteBaseFlagStolen] | |
SQL1_1 = DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY) | |
SQL1_INPUTS = 1 | |
; Unlock doors and mark safes as abandoned if flag stolen for X days | |
[setAbandonedUnlocked] | |
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)); | |
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' | |
SQL1_INPUTS = 1 | |
SQL2_INPUTS = 1 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Moneh moneh moneh | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[setPlayerMoney] | |
SQL1_1 = UPDATE player SET money = ? WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[getPlayerMoney] | |
SQL1_1 = SELECT money FROM player WHERE id = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1 | |
[setContainerMoney] | |
SQL1_1 = UPDATE container SET money = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
[setVehicleMoney] | |
SQL1_1 = UPDATE vehicle SET money = ?, last_updated_at = NOW() WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; XM8 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[getAllNotifTerritory] | |
SQL1_1 = SELECT id FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? - 1 DAY) and xm8_protectionmoney_notified = 0 | |
SQL1_INPUTS = 1 | |
[setTerritoryNotified] | |
SQL1_1 = UPDATE territory SET xm8_protectionmoney_notified = ? WHERE id = ? | |
SQL1_INPUTS = 1,2 | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
;; Exile Escape | |
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; | |
[addAccountWin] | |
SQL1_1 = UPDATE account SET wins = wins + 1 WHERE uid = ? | |
SQL1_INPUTS = 1 | |
[addAccountMatches] | |
SQL1_1 = UPDATE account SET matches = matches + 1 WHERE uid = ? | |
SQL1_INPUTS = 1 | |
[createMatch] | |
SQL1_1 = INSERT INTO game_data SET players = ?, total_players = ? | |
SQL1_INPUTS = 1,2 | |
Return InsertID = true | |
[setMatchWinner] | |
SQL1_1 = UPDATE game_data SET winner_uid = ?, win_type = ? WHERE id = ? | |
SQL1_INPUTS = 1,2,3 | |
[getEscapeAccountStats] | |
SQL1_1 = SELECT wins, matches FROM account WHERE uid = ? | |
SQL1_INPUTS = 1 | |
OUTPUT = 1,2 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment