• Announcements

    • Flosstradamus

      Official Discord   03/15/17

      https://discord.gg/FMkqWpF Click the link above and join our Official Discord!  Chat with developers and get quicker support!
    • Vishpala

      New XM8 Discord Bot   05/15/17

      Our new XM8 Discord Bot will send you notifications about events happening in-game, even if you are not online!  Read about it on the Devblog:  
    • WolfkillArcadia

      1.0.4 "Pineapple" Release   03/08/18

      Inmates! We have launched 1.0.4 update for Exile. You can read about the release here:   
    • WolfkillArcadia

      Exile Server 1.0.4a hotfix out!   03/09/18

      Server owners! We pushed out 1.0.4a hotfix for Exile server. You will need to merge/replace the following files:
      ExileServer_object_lock_network_grindNotificationRequest.sqf
      ExileServer_object_construction_network_*.sqf

      Just download the server files from the downloads section. 

Super Jerome

Donator
  • Content count

    600
  • Joined

  • Last visited

Community Reputation

350 Excellent

About Super Jerome

  • Rank
    Underboss
  • Birthday January 16

Personal Information

Recent Profile Visitors

3864 profile views
  1. Sorry, been on a Military training exercise for last 3 months. I will be home around the 10th of July. I can work with you then.
  2. I'm confused are you saying that players can not respawn at the same point twice? If so this is normal as Exile has a cooldown on spawn points.
  3. This Git is locked so we cannot make any changes to it. As for you Linux problem well....use windows . Seriously though, I currently don't have the time to be working on scripts.
  4. @Falcon911 Sorry, about the long post. I am in the Mohave desert and my internet blows out here.
  5. [Default] Version = 1 Strip Chars = "\/\|;{}<>\'" Strip Chars Mode = 0 Input SQF Parser = false ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; 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 [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 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; 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 [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 = 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,12-NULL,10,11 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 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 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Virtual Garage related queries | ADDED BY [ExAd]Jan ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [loadVehicleIdPage] ;SQL1_1 = SELECT id FROM vehicle LIMIT ?,? SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL AND territory_id IS NULL LIMIT ?,? SQL1_INPUTS = 1,2 OUTPUT = 1 ; Removes vehicles that were not used within ? days [deleteOldVehicles] ;SQL1_1 = DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) SQL1_1 = DELETE FROM vehicle WHERE territory_id IS NULL AND deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) 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) SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL SQL1_INPUTS = 1 [loadTerritoryVehicles] SQL1_1 = SELECT id, class FROM vehicle WHERE territory_id = ? SQL1_INPUTS = 1 OUTPUT = 1,2-STRING [loadVehFromVG] SQL1_1 = UPDATE vehicle SET territory_id = NULL WHERE id = ? SQL1_INPUTS = 1 [loadVehToVG] SQL1_1 = UPDATE vehicle SET territory_id = ? WHERE id = ? SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; PTWS ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [createDate] SQL1_1 = INSERT INTO ptws SET DateID = ? SQL1_INPUTS = 1 [getDate] SQL1_1 = SELECT date FROM ptws WHERE DateID = ? SQL1_INPUTS = 1 OUTPUT = 1 [getWeather] SQL1_1 = SELECT weather FROM ptws WHERE DateID = ? SQL1_INPUTS = 1 OUTPUT = 1 [setDate] SQL1_1= UPDATE ptws SET date = ? WHERE DateID = ? SQL1_INPUTS = 1,2 [setWeather] SQL1_1= UPDATE ptws SET weather = ? WHERE DateID = ? SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; infiSTAR Logs ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [insert_infiSTARLog] SQL1_1 = INSERT INTO infistar_logs SET servername = ?, logname = ?, logentry = ? SQL1_INPUTS = 1,2,3 [getTotalConnections] SQL1_1 = SELECT first_connect_at,last_connect_at,total_connections FROM account WHERE uid = ? SQL1_INPUTS = 1 OUTPUT = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; infiSTAR WhiteList ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [getAccountWhitelisted] SQL1_1 = SELECT whitelisted FROM account WHERE uid = ? SQL1_INPUTS = 1 OUTPUT = 1
  6. Ok, this appears to be definately a problem with your exile.ini. Carefully go through and make sure you don't have duplicate lines.
  7. @Falcon911 Did you run the Query in Step 10?
  8. Hasn't happened yet
  9. That usually is the best way to upgrade. Just remember ARMA is the king of exploiting GPU and CPU relationships.
  10. I am not nor will not explain anything for a child. If you can't get it done correctly then don't use it. Over 400 people have downloaded this script and you are the only one complaining about install instructions. Had you come across diferently on your first post, I may have been more forthcoming to assist you. Next time you want some help you might want to try to be more polite.
  11. Ok, start here: Then once you get that going go here: That should get you pointed in the right direction.
  12. Did you remove any of the apps that come with the ExAd download?
  13. I am currently running a 1060 but anything 1050 or higher should be good.
  14. No one cares if you use the script or not. If you don't have the IQ to get it running then don't use it simple as that. Don't make negative posts just because you can't comprehend. You can't even spell correctly so you obviously can't read simple instructions.
  15. I have had a GTX 970 in the past. It doesn't do well with Exile in general. Once I upgraded I was fine.