• 0
Admiral EliteSuicide

ADK Base Painting dont load saved Texture

Question

Hello Guys,

Like the Title says the ADK Base Painting dont save any Textures on Constructions. If I paint for example a Floor in Camo Texture the Texture will be there until a Restart comes. After the Restart the Texture is gone and the Floor has its normal Texture again. I looked in my Database in the construction section and there are the Textures saved for the Floor I painted so I really dont know wheres the Problem there...

May someone of you got an idea, would be very great :)

 

ADK Textures Pack 1 (Mod)

https://steamcommunity.com/sharedfiles/filedetails/?id=731499177

Edited by Admiral EliteSuicide

Share this post


Link to post
Share on other sites

9 answers to this question

  • 0

 

You must make changes in your database and exile.ini . All instructions are inside the mod folder: @ADK Texture pack 1\Instructions

Edited by Sna[KE]

Share this post


Link to post
Share on other sites
  • 0
On 11/24/2018 at 7:37 PM, Sna[KE] said:

 

You must make changes in your database and exile.ini . All instructions are inside the mod folder: @ADK Texture pack 1\Instructions

Yes I have done this all..

Heres my exile.ini (64-Bit extDB3)

Spoiler

[Default]

Version = 1
Strip Chars = "\/\|;{}<>\'"
Strip Chars Mode = 0
Input SQF Parser = false
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; Exile Version 1.0.4
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;


;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;; 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

;;TEMP FIX FOR DUPLICATE ENTIRES
[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 = ? AND p.damage < 1

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 = ? AND territory_id = ?

SQL1_INPUTS = 1,2
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

[updateConstructionSkin]
SQL1_1 = UPDATE construction SET texture = ? WHERE id = ?

SQL1_INPUTS = 1,2

[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 = ? , build_rights = ? , moderators = ?

SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,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
SQL2_1 = SET SQL_SAFE_UPDATES=0;
SQL3_1 = DELETE FROM container WHERE id IN (SELECT id FROM (SELECT * FROM container WHERE NOT EXISTS (SELECT NULL FROM territory WHERE  territory.id = container.territory_id)) AS c)
SQL4_1 = SET SQL_SAFE_UPDATES=1;

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

 

And for the database I runned this sql command:

Spoiler

ALTER table construction ADD `texture` TEXT NOT NULL;

ExileServer_object_construction_database_load.sqf override: (Overrides for 64-Bit included)

Spoiler

/**
 * ExileServer_object_construction_database_load
 * + ADK Mod Pack Override
 * Exile Mod
 * www.exilemod.com
 * © 2015 Exile Mod Team
 *
 * This work is licensed under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. 
 * To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-nd/4.0/.
 * 64Bit Conversion File Header (Extdb3) - Validatior
 */
 
private["_constructionID", "_data", "_position", "_vectorDirection", "_vectorUp", "_constructionObject", "_damageLevel", "_public", "_pinCode"];
_constructionID = _this;
_data = format ["loadConstruction:%1", _constructionID] call ExileServer_system_database_query_selectSingle;
_position = [_data select 4, _data select 5, _data select 6];
_vectorDirection = [_data select 7, _data select 8, _data select 9];
_vectorUp = [_data select 10, _data select 11, _data select 12];
_constructionObject = createVehicle [(_data select 1), _position, [], 0, "CAN_COLLIDE"];
_constructionObject setPosATL _position;
_constructionObject setVectorDirAndUp [_vectorDirection, _vectorUp];
_constructionObject setVariable ["ExileDatabaseID", _data select 0];
_constructionObject setVariable ["ExileOwnerUID", (_data select 2)];
_constructionObject setVariable ["ExileIsPersistent", true];
_constructionObject setVariable ["ExileTerritoryID", (_data select 15)];
_damageLevel = (_data select 17);
_public = _damageLevel > 0;
_constructionObject setVariable ["ExileConstructionDamage",_damageLevel,_public];
if(_public)then
{
    _constructionObject call ExileServer_util_setDamageTexture;
};
_pinCode = _data select 14;
if !(_pinCode isEqualTo "000000") then
{
    _constructionObject setVariable ["ExileAccessCode", _pinCode];
    _constructionObject setVariable ["ExileIsLocked", (_data select 13), true];
};
// ADK Texture Pack Override
_texture = (_data select 18);
if !(_texture isEqualTo "") then
{
        {
            _constructionObject setObjectTextureGlobal [_forEachIndex, _texture select _forEachIndex];
        }
    forEach _texture;
};
// Override End
if (getNumber(configFile >> "CfgVehicles" >> (_data select 1) >> "exileRequiresSimulation") isEqualTo 1) then
{
    if (getNumber(missionConfigFile >> "CfgSimulation" >> "enableDynamicSimulation") isEqualTo 1) then 
    {
        _constructionObject enableDynamicSimulation true;
    }
    else
    {
        _constructionObject enableSimulationGlobal true;
        _constructionObject call ExileServer_system_simulationMonitor_addVehicle;
    };
}
else 
{
    _constructionObject enableSimulationGlobal false;
};
_constructionObject setVelocity [0, 0, 0];
_constructionObject setPosATL _position;
_constructionObject setVelocity [0, 0, 0];
_constructionObject setVectorDirAndUp [_vectorDirection, _vectorUp];
_constructionObject setVelocity [0, 0, 0];
_constructionObject
 

1754332714_DesktopScreenshot2018_11.25-06_16_22_79.thumb.png.15f9bde994ab1d0ac6c58b6d72ba2a6a.png

The database is saving the Texture for the construction, but the Texture dont load on the Construction back after a Restart.

Edited by Admiral EliteSuicide

Share this post


Link to post
Share on other sites
Advertisement
  • 0

Hello @Admiral EliteSuicide,

There are 3 POSSIBILITIES going on:

#1 - This package is almost 2 years old!  It may not be compatible any longer with Exile.  The last post was on 7/2017.  This is a DEAD MOD.

#2 - You may THINK you set it up, but you might not have set it up PROPERLY.

#3 - This is what I think it is -> You have some other script/override that is over writing this paint one!

 

:)

 

Share this post


Link to post
Share on other sites
  • 0

Hey, thanks for you answer @Z80CPU I have thinked about that too... :)

 

I have looked my whole rpt logs yesterday and found this:

Spoiler


 4:53:26 "ExileServer - Loading constructions from database..."
 4:53:26 Error in expression <
};

_texture = (_data select 18);
if !(_texture isEqualTo "") then
{
{
_constru>
 4:53:26   Error position: <_texture isEqualTo "") then
{
{
_constru>
 4:53:26   Error Undefined variable in expression: _texture
 4:53:26 File mpmissions\__cur_mp.Chernarus\Custom\Exile_Server_Overrides\Custom\x64_ADK_Base_Paint\ExileServer_object_construction_database_load.sqf, line 41

 

So the failure should be in the ExileServer_object_construction_database_load.sqf override in line 41:

Spoiler

// ADK Texture Pack Override
_texture = (_data select 18);
if !(_texture isEqualTo "") then       // THATS LINE 41
{
        {
            _constructionObject setObjectTextureGlobal [_forEachIndex, _texture select _forEachIndex];
        }
    forEach _texture;
};
// Override End

But thats exactly written like in the Install Instruction... 

Spoiler

10. Edit "ExileServer_object_construction_database_load" in (\@ExileServer\addons\exile_server\code)

Search for this line:
    if (getNumber(configFile >> "CfgVehicles" >> (_data select 1) >> "exileRequiresSimulation") isEqualTo 1) then

Add this before it:

    _texture = (_data select 18);
    if !(_texture isEqualTo "") then
    {
        {
            _constructionObject setObjectTextureGlobal [_forEachIndex, _texture select _forEachIndex];
        }
        forEach _texture;
    };

So it looks like this:

    if !(_pinCode isEqualTo "000000") then
    {
        _constructionObject setVariable ["ExileAccessCode", _pinCode];
        _constructionObject setVariable ["ExileIsLocked", (_data select 13), true];
    };
    _texture = (_data select 18);
        
    if !(_texture isEqualTo "") then
    {
        {
            _constructionObject setObjectTextureGlobal [_forEachIndex, _texture select _forEachIndex];
        }
        forEach _texture;
    };
    if (getNumber(configFile >> "CfgVehicles" >> (_data select 1) >> "exileRequiresSimulation") isEqualTo 1) then
 

I saw this Mod running with Base Paint on some Servers, so normaly it should work. 

In this Line 41 can it be that there should something be in the "" ?

Or can it be that this Mod isnt working with 64-Bit/ExtDB3 ?

 

Edited by Admiral EliteSuicide

Share this post


Link to post
Share on other sites
  • 0
8 hours ago, Admiral EliteSuicide said:

In this Line 41 can it be that there should something be in the "" ?

No. When working with Arma code, and other various computer languages, we use "" to tell the system that anything in-between "" should be read and subjected to the function associated to its call. I'll need to download this mod and look at it but it seems to be an issue with the variable _texture.

Share this post


Link to post
Share on other sites
  • 0

So looking at the associated error code and the reference to installation, you have missed one of two steps in the installation instructions. Look at the folder labeled New_Server_Owners

  • Like 1

Share this post


Link to post
Share on other sites
  • 0

***** New Server Owner Instruction's *****

1. Naviagte to \SteamLibrary\steamapps\common\Arma 3\!Workshop\
2. Copy folder @ADK Texture Pack
3. Paste it in your root server directory
4. In your server start-up batch file or whereever you have "-mod=" add @ADK Texture Pack; to that list. For example "-mod=@Exile;@ADK Texture Pack;"
5. Copy the server key from the key folder inside "@ADK Texture Pack/key/adk_*.bikey" place it inside your server root directory key folder

All done.

 

6. Run the "New_Server_Owner_Database.sql" on your database

Runned this sql command:

ALTER table construction ADD `texture` TEXT NOT NULL;

 

7. Now set up the uniforms and vehicles to be purchased from traders and the custon paint section. Examples are provided in @ADK Texture Pack\Instructions/Trader_Items_config.cpp (inside your mission config.cpp file)

All inserted and woks great.

 

8. Add to mission config.cpp the interaction paint menu option under class CfgInteractionMenus. Example provided in file: Panit_Menu_config.cpp

That works great too.

 

9. Edit your exile.ini located is server root directory (\@ExileServer\extDB\sql_custom_v2). Search for "[loadConstruction]" and then edit it to look like below:

    [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,texture FROM construction WHERE id = ?
    Number Of Inputs = 1
    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,19

Add this below the [loadConstruction] section:
    
    [updateConstructionSkin]
    SQL1_1 = UPDATE construction SET texture = ? WHERE id = ?
    Number of Inputs = 2
    SQL1_INPUTS = 1,2

Done it like this:

[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

[updateConstructionSkin]
SQL1_1 = UPDATE construction SET texture = ? WHERE id = ?
Number of Inputs = 2
SQL1_INPUTS = 1,2

[countConstruction]
SQL1_1 = SELECT COUNT(*) FROM construction

OUTPUT = 1

 

10. Edit "ExileServer_object_construction_database_load" in (\@ExileServer\addons\exile_server\code)

Search for this line:
	if (getNumber(configFile >> "CfgVehicles" >> (_data select 1) >> "exileRequiresSimulation") isEqualTo 1) then

Add this before it:

	_texture = (_data select 18);
	if !(_texture isEqualTo "") then
	{
		{
			_constructionObject setObjectTextureGlobal [_forEachIndex, _texture select _forEachIndex];
		}
		forEach _texture;
	};

So it looks like this:

	if !(_pinCode isEqualTo "000000") then
	{
		_constructionObject setVariable ["ExileAccessCode", _pinCode];
		_constructionObject setVariable ["ExileIsLocked", (_data select 13), true];
	};
	_texture = (_data select 18);
		
	if !(_texture isEqualTo "") then
	{
		{
			_constructionObject setObjectTextureGlobal [_forEachIndex, _texture select _forEachIndex];
		}
		forEach _texture;
	};
	if (getNumber(configFile >> "CfgVehicles" >> (_data select 1) >> "exileRequiresSimulation") isEqualTo 1) then

Done it:

_pinCode = _data select 14;
if !(_pinCode isEqualTo "000000") then
{
	_constructionObject setVariable ["ExileAccessCode", _pinCode];
	_constructionObject setVariable ["ExileIsLocked", (_data select 13), true];
};
// ADK Texture Pack Override
_texture = (_data select 18);
if !(_texture isEqualTo "") then
{
		{
			_constructionObject setObjectTextureGlobal [_forEachIndex, _texture select _forEachIndex];
		}
	forEach _texture;
};
// Override End
if (getNumber(configFile >> "CfgVehicles" >> (_data select 1) >> "exileRequiresSimulation") isEqualTo 1) then
{
	if (getNumber(missionConfigFile >> "CfgSimulation" >> "enableDynamicSimulation") isEqualTo 1) then 
	{
		_constructionObject enableDynamicSimulation true;
	}
	else

That should it be, but the Textures still dont want to load.. :/ 

Edited by Admiral EliteSuicide

Share this post


Link to post
Share on other sites
  • 0

Follow and EXAMINE what I stated...

IF you have SOME OTHER SCRIPT/OVERRIDE in place - IT WILL NOT WORK!

You need to VERIFY that this is NOT THE CASE!

 

AND if you HAVE done this and there is NO CONFLICTS AND YOU HAVE INSTALLED IT CORRECTLY, then this is a NON-WORKING MOD!

 

It's really pretty simple to see this...

 

AGAIN, I think you have some OTHER override which is 'OVERRIDING' THIS OVERRIDE!

The ARE scripts which WILL modify these SAME AREAS OF CODE!  You MUST COMBINE them into one!  I had to do it MYSELF!  I am 99% sure THIS IS THE ISSUE!

Scripts modifying the SAME LINE is COMMON IN EXILE!!!!!!

 

:P

 

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.