__FLYERS__

der brocken is drin dankee lag wohl an der description ^^

Ich bin am verzweiflen mit der Virtual Garage von ExAd...... Habe mir die XM8 und Statusbar erfolgreich drauf gemacht, nur die garage will nicht so ganz habe das Icon im XM8 und die fahrzeuge werden angezeigt wo ich einlagern könnte nur es passiert nichts wenn ich auf einlagern klicke.... dazu kommt ich bin nicht der hellste wenn es um my sql geht^^ daran wird es auch warscheindlich liegen.... was ich gemacht habe: exile.ini [Default] Version = 12 Number of Inputs = 0 Sanitize Input Value Check = false Sanitize Output Value Check = false Prepared Statement Cache = true Return InsertID = false Strip = true Strip Chars Action = STRIP Strip Chars = \/\|;{}<>\' Strip Custom Chars = \/\|;{}<>\' ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Account related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [isKnownAccount] SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [createAccount] SQL1_1 = INSERT INTO account SET uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [startAccountSession] SQL1_1 = UPDATE account SET name = ?, last_connect_at = NOW(), total_connections = total_connections + 1 WHERE uid = ? Number Of Inputs = 2 SQL1_INPUTS = 2,1 [endAccountSession] SQL1_1 = UPDATE account SET last_disconnect_at = NOW() WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [getAccountStats] SQL1_1 = SELECT score, kills, deaths, clan_id, locker FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2,3,4,5 [addAccountKill] SQL1_1 = UPDATE account SET kills = kills + 1 WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [addAccountDeath] SQL1_1 = UPDATE account SET deaths = deaths + 1 WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [getAccountScore] SQL1_1 = SELECT score FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [setAccountScore] SQL1_1 = UPDATE account SET score = ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [modifyAccountScore] SQL1_1 = UPDATE account SET score = score + ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateLocker] SQL1_1 = UPDATE account SET locker = ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [getLocker] SQL1_1 = SELECT locker FROM account WHERE uid = ? Number of Inputs = 1 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 Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [createPlayer] SQL1_1 = INSERT INTO player SET account_uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 Return InsertID = true [insertPlayerHistory] SQL1_1 = INSERT INTO player_history SET account_uid = ?, name = ?, position_x = ?, position_y = ?, position_z = ? Number Of Inputs = 5 SQL1_INPUTS = 1,2,3,4,5 [deletePlayer] SQL1_1 = DELETE FROM player WHERE id = ? Number Of Inputs = 1 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 = ? Number of Inputs = 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 = ? Number Of Inputs = 39 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 = ? Number of Inputs = 13 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 = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [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 ?,? Number Of Inputs = 2 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 = ? 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,16,17,18,19,20,21-STRING,22,23,24 [loadVehicleContainer] SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ? Number Of Inputs = 1 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 = WHERE id = ? Number of Inputs = 19 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 = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [vehicleSetPinCode] SQL1_1 = UPDATE vehicle SET pin_code = ? WHERE id = ? Number of Inputs = 2 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 = $CUSTOM_1$ Number of Inputs = 11 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11 Return InsertID = true [deleteConstruction] SQL1_1 = DELETE FROM construction WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadConstructionIdPage] SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 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 = ? 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 [countConstruction] SQL1_1 = SELECT COUNT(*) FROM construction Number Of Inputs = 0 OUTPUT = 1 [constructionSetPinCode] SQL1_1 = UPDATE construction SET pin_code= ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [upgradeObject] SQL1_1 = UPDATE construction SET class=? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [addDoorLock] SQL1_1 = UPDATE construction SET pin_code = ?,is_locked = -1 WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateLock] SQL1_1 = UPDATE construction SET is_locked = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateConstructionTerritoryIDs] SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?) Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateDamage] SQL1_1 = UPDATE construction SET damage = ? WHERE id = ? Number of Inputs = 2 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 = $CUSTOM_1$ Number of Inputs = 17 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 Return InsertID = true [deleteContainer] SQL1_1 = DELETE FROM container WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadContainerIdPage] SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 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 = ? Number Of Inputs = 1 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 = ? Number Of Inputs = 1 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 = $CUSTOM_1$, SQL1_17 = money = ? SQL1_18 = WHERE id = ? Number of Inputs = 16 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16 [containerSetPinCode] SQL1_1 = UPDATE container SET pin_code= ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateContainerTerritoryIDs] SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?) Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Clan related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [createClan] SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 Return InsertID = true [setAccountClanLink] SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [unLinkClanLink] SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [updateClanLeader] SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [deleteClan] SQL1_1 = DELETE FROM clan WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadClansIdPage] SQL1_1 = SELECT id FROM clan LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [getClanInfo] SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1-STRING,2-STRING [getClanMembers] SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ? Number Of Inputs = 1 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 = ? Number Of Inputs = 1 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 = ? Number Of Inputs = 7 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 = ? Number Of Inputs = 3 SQL1_INPUTS = 1,2,3 Return InsertID = true [deleteMarker] SQL1_1 = DELETE FROM clan_map_marker WHERE id = ? Number Of Inputs = 1 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 =$CUSTOM_1$ , build_rights = ? , moderators = ? Number Of Inputs = 11 Number Of Custom Inputs = 1 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 ?,? Number Of Inputs = 2 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 Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12-DateTime_ISO8601,13,14,15,16 [setTerritoryLevel] SQL1_1 = UPDATE territory SET level = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [setTerritorySize] SQL1_1 = UPDATE territory SET radius = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [updateTerritoryBuildRights] SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [updateTerritoryModerators] SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [maintainTerritory] SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [deleteTerritory] SQL1_1 = DELETE FROM territory WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [flagStolen] SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [flagRestore] SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ? Number of Inputs = 1 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 Number Of Inputs = 1 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 Number Of Inputs = 1 SQL1_INPUTS = 1 ; Marks contructions outside territories deleted after ? days [markDeleteOldConstructions] 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 Number Of Inputs = 1 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 Number Of Inputs = 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) SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL Number Of Inputs = 1 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_1 = DELETE FROM vehicle WHERE territory_id IS NULL AND deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 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) 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) Number Of Inputs = 1 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) Number Of Inputs = 1 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 Number Of Inputs = 1 SQL1_INPUTS = 1 [deleteBaseFlagStolen] SQL1_1 = DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 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' Number Of Inputs = 1 SQL1_INPUTS = 1 SQL2_INPUTS = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Moneh moneh moneh ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [setPlayerMoney] SQL1_1 = UPDATE player SET money = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [getPlayerMoney] SQL1_1 = SELECT money FROM player WHERE id = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [setContainerMoney] SQL1_1 = UPDATE container SET money = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [setVehicleMoney] SQL1_1 = UPDATE vehicle SET money = ? WHERE id = ? Number of Inputs = 2 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 Number of Inputs = 1 SQL1_INPUTS = 1 [setTerritoryNotified] SQL1_1 = UPDATE territory SET xm8_protectionmoney_notified = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Virtual Garage related queries | ADDED BY [ExAd]Jan ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [loadTerritoryVehicles] SQL1_1 = SELECT id, class FROM vehicle WHERE territory_id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING [loadVehFromVG] SQL1_1 = UPDATE vehicle SET territory_id = NULL WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadVehToVG] SQL1_1 = UPDATE vehicle SET territory_id = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Virtual Garage related queries | ADDED BY [ExAd]Jan ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [loadTerritoryVehicles] SQL1_1 = SELECT id, class FROM vehicle WHERE territory_id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING [loadVehFromVG] SQL1_1 = UPDATE vehicle SET territory_id = NULL WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadVehToVG] SQL1_1 = UPDATE vehicle SET territory_id = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 Und das SQL zeugs ALTER TABLE `vehicle` ADD `territory_id` INT(11) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `vehicle` ADD CONSTRAINT `vehicle_ibfk_2` FOREIGN KEY (`territory_id`) REFERENCES `territory`(`id`) ON DELETE CASCADE ON UPDATE RESTRICT; habe ich auf php my admin reingemacht: Datenbank angeklickt dann auf SQL eingefügt oke gedrückt wenn ich es wiederhole kommt und die extDB log sagt extDB2: Found extdb-conf.ini extDB2: Detected 12 Cores, Setting up 6 Worker Threads [22:44:43:788230 +02:00] [Thread 4184] extDB2: Database Type: MySQL [22:44:43:789326 +02:00] [Thread 4184] extDB2: Database Session Pool Started [22:44:43:790503 +02:00] [Thread 4184] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\Users\Administrator\Desktop\Arma3_Server2\arma3\@ExileServer\extDB\sql_custom_v2\exile.ini [22:44:43:790626 +02:00] [Thread 4184] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available [22:52:50:084274 +02:00] [Thread 4184] extDB2: Stopping ... also stimmt was an der exile.ini nicht? .... danke

sorry war ne dumme frage da drauf hätte ich selbst kommen sollen^^ aber danke

Hallo zusammen, Habe mir die Extended Base Mod auf den Server gemacht funktioniert auch alles so weit wunderbar. zu meinem kleinem Problem... wenn ich auf meinem Server im Ladebildschirm bin kommt jedes mal File mpmissions\__CUR_MP.Tanoa\EBM\prices.hpp, line 1: .Land_HBarrier_1_F_Kit: Member already defined. weiss evt. wer was ich ändern muss? danke...

Danke Für die Infos

Moin, Ja alles was ich im Eden Editor selbst baue verschiebt sich Tische buggen auf einmal in wände rein, also egal was ich baue die dinge machen immer was sie wollen! Wo ich den Tisch will!! copy paste :)) initServer Und hier ist das tolle Endergebnis Mache ich was falsch? Oder ist das normal? Hilfeee...

hat sich erledigt

Hallo zusammen ich brauch da mal eure Hilfe, ich habe einen Server erstellt mit Verschiedenen mods. Funzt auch alles soweit nur das mich Infistar immer kickt nach 10-20 Sekunden, was da los ich komm nicht drauf finde auch nichts schlaues zum nachlesen. Geladene mods: Und der Kicklog

Hallo zusammen ist es möglich dem Spieler zu verbieten mit Taucherbrille oder Masken auf dem Server zu spawnen? Danke für eure Hilfe :))

taskkill /IM arma3server.exe /F C:\XXX\XXX\XXX\arma3server.exe -mod=@XXX;@XXX;@XXX; -config=C:\XXX\XXX\XXX\config.cfg -port=XXXX -cfg=C:\XXX\XXX\XXX\basic.cfg

Danke dir

Versuchs mal damit habe überall loOt

Ich habe es mit verschiedenen editoren versucht immer das selbe, der einzige editor der die dinge richtig stellt ist Xcam nur fliegen mir da die kleinen Objekte rum auch ohne Simulation...Evt mache oder vergesse ich da auch was ^^.

Hallo zusammen Wenn ich im m3eden editor zB. ein Haus stelle und ein Tisch an die Wand, und es nachher auf den Server lade dann steht das Haus nicht mehr da wo es sollte es verschiebt sich warum? oder mach ich was falsch^^