Content
Roadmap
v0.1.1
Start date 10/08/2023
Finish date 10/15/2023
over 2 years late
Automated skin code distribution
126 closed (86%) 21 open (14%)
Related work packages
- closedFeature #101: Create a skin code DB table
- Feature #104: Modify quiz script for skin database
- closedFeature #115: Assign past won quizzes to prizes
- closedFeature #120: Quizz guess - Formating of future hints
- closedFeature #129: Move zkill import to cron container
- closedFeature #133: Mirror doc.tools4eve.com
- closedFeature #137: Patreon - Import Patron list
- closedFeature #138: Patreon - Add patron name to Patreon bar
- closedFeature #139: Patreon - Display top patrons
- closedFeature #142: Bugtracker - Import closed tickets to DB
- closedFeature #143: Bugtracker - Replace changelog source with new ticket system
- closedFeature #157: Calc cron - price_refresher_region.php
- closedFeature #158: Calc cron - price_refresher_station.php
- closedFeature #159: Calc cron - calc_market_history.php
- closedFeature #160: calc_trade_30d.php
- closedFeature #161: calc_contract_prices.php
- closedFeature #162: calc_contract_7d_price.php
- closedFeature #163: calc_contract_profit.php
- closedFeature #164: calc_market_metrics.php
- closedFeature #165: calc_trade_metrics.php
- closedFeature #167: calc_market_7d_price.php
- closedFeature #168: calc_a4e_trade_7d.php
- closedFeature #169: calc_market_52w.php
- closedFeature #170: calc_market_trends.php
- closedFeature #171: calc_trade_hubs.php
- closedFeature #172: calc_market_activity.php
- closedFeature #173: calc_market_activity_history.php
- closedFeature #174: calc_market_percentile.php
- closedFeature #175: calc_market_percentile_history.php
- closedFeature #179: Ban ClaudeBot hammering A4E
- closedFeature #196: DB lib - Catch deadlocks
- closedFeature #197: Move Calc DB into container
- closedFeature #198: Decom old Calc VM
- closedFeature #200: Setup tracker script container
- closedFeature #201: Move market_order_tracker
- closedFeature #202: Move market_order_refresher
- closedFeature #203: Move imp_ESI_players
- closedFeature #204: Move check_ESI
- closedFeature #205: Move imp_market_history
- closedFeature #206: Move imp_ESI_market_price
- closedFeature #207: Move imp_ESI_contracts
- closedFeature #208: Move imp_ESI_corporations_null
- closedFeature #209: Move imp_ESI_corporations
- closedFeature #210: Move imp_ESI_characters
- closedFeature #211: Move imp_ESI_costIndex
- closedFeature #212: Move imp_ESI_killsJumps
- closedFeature #213: Move imp_ESI_structure
- closedFeature #214: Move imp_ECB_buildCost
- closedFeature #215: Move imp_EVE_warzone
- closedFeature #216: Move imp_ESI_UL_orders
- Feature #217: Move imp_ESI_UL_wallet
- Feature #218: Move imp_ESI_UL_journal
- Feature #219: Move imp_ESI_UL_transactions
- Feature #220: Move imp_ESI_UL_corpOrders
- Feature #221: Move imp_ESI_UL_corpWallet
- Feature #222: Move imp_ESI_UL_corpJournal
- Feature #223: Move imp_ESI_UL_corpTransactions
- closedFeature #228: Update PRD CCP SDE
- Feature #230: Tracker - Import character order history
- Feature #231: Tracker - Import corporate order history
- closedFeature #241: Import latest CCP-Partner Skin Codes
- closedFeature #242: Add CCP creator code support hint
- closedFeature #243: Update Monitoring CheckMK
- closedFeature #251: Migrate Website Monitoring
- closedFeature #252: Add monitoring of the DEV webservers
- closedFeature #253: Move material influence page to DEV
- closedFeature #254: Material Influence - Improvements
- Feature #258: Import script for character assets
- Feature #259: Import script for corp assets
- Feature #260: Calculate daily asset inventory levels
- Feature #261: Create an API management page
- closedFeature #267: Frontier - API Import - Endpoint Types
- closedFeature #268: Frontier - API Import - Endpoint SolarSystems
- closedFeature #269: Frontier - API Import - Endpoint Characters
- closedFeature #270: Frontier - API Import - Endpoint Kills
- closedFeature #271: Show Alias instead of Patreon name
- closedFeature #274: Set failing API keys to error state
- closedFeature #306: Add months of partner skins codes to quiz pool
- closedFeature #320: Skin Codes - Import March 2025
- closedFeature #322: A4E BI - Anonymous User reset script
- closedFeature #323: A4E BI - Automatically update MER
- closedFeature #325: Skin Codes - Import April 2025
- closedFeature #346: Change User-Agent to CCPs specifications
- closedFeature #351: EVE-Frontier: Import SmartAssemblies
- closedFeature #352: EVE-Frontier: Capture daily player and SmartAssembly counts
- Feature #354: Move Archive database into Homelab
- Epic #100: Quiz reward automation
- closedEpic #110: ESI type check - Repair & reactivate
- closedEpic #126: Move Calc Scripts to Docker
- Epic #199: Move Tracker VM to Docker
- closedBug #109: Market Quizzes - Selected item and submission failing
- closedBug #118: Mail on A4E docker host
- closedBug #122: Backup-space 100% used
- closedBug #123: SDE Import - Fails to copy table to calc/tracker instances
- closedBug #124: Static export - Failed due to filled disk
- closedBug #130: Type Category: Module doesnt work on the dev. site
- closedBug #140: Top menu - Fix icon color
- closedBug #141: Homepage - Mastodon viewer dark mode
- closedBug #144: Script log function didn't create 2024 table
- closedBug #145: Margin finder - Switched columns SfB BfS
- closedBug #180: Pages unreachable due to mod_security
- closedBug #181: Market metric calc - Variable issue
- closedBug #225: Margin Finder - Hek not working in <DEV>
- closedBug #232: Margin finder not showing any data
- closedBug #234: Margin Finder Broken? - No data found (Amarr,Rens,Doxidie,Hek)
- closedBug #244: Monitoring docker databases
- Bug #246: Mastodon A4E Quiz News Script error
- closedBug #247: Market hub calculation fails
- closedBug #248: A4E quiz - No "high" value prizes anymore
- closedBug #249: Static Export fails after tracker DB migration
- closedBug #250: SDE import fails after tracker DB migration
- closedBug #255: Table sort icons - Can't be seen in dark mode
- closedBug #256: MER import fails to connect to DB
- closedBug #257: Market hubs - Structures are not listed
- closedBug #262: Too many DB connections
- closedBug #272: Contract 7D price script issue - Out of range value
- Bug #273: Contract import - Unexpected identifier
- closedBug #275: Corporation import: Out of range value for column 'member_count'
- closedBug #285: frontier_cron - imp_api_playerDetails - Incorrect integer value
- closedBug #293: MarketCCPTradeHistory for nonHub no data since July
- Bug #295: Price History - Help graph old and wrong + Title missing
- closedBug #296: Static export failed due to No disc space
- closedBug #298: Frontier - API failing? Moved
- closedBug #299: MarketCCPTradeHistory_2025 table does not exist
- closedBug #301: Contract profit - Contract tables missing
- closedBug #302: UL Orders - Unknown collation: 'utf8mb4_0900_ai_ci'
- closedBug #303: UL Assets - Data too long for column 'location_flag'
- closedBug #304: Adding primary key to 2025 table of MarketPricesPercentile failed
- closedBug #305: Quiz selection - Failed to fetch quiz item
- closedBug #321: Static Exports - MarketPricesStationHistory monthly fails
- closedBug #326: PRD - MySQL server has gone away
- closedBug #327: Quiz - Prediction quiz script failing
- closedBug #328: Redeem code not working
- closedBug #329: Market 30d avg calc - Deletion of old entries fails
- closedBug #330: Contract 7d avg price - Deleting old rows fails
- closedBug #331: Market price 7d average - Deletion old rows dails
- closedBug #332: Market price 52w avg - Deletion of old rows fails and some queries
- closedBug #334: DEV version of Margin Finder is broken except for Jita
- closedBug #338: Archive database is down
- closedBug #339: Restore MarketCCPTradeHistory_2019_rest table to ARCHIVE DB
- closedBug #340: PRD Database: Too many connection
- closedBug #343: Calc DB - MarketPricesStationCache table not being cleaned up
- closedBug #345: Manufacturing Profitability shows no products
- closedBug #347: Static Exports - Script failing due to empty DB result
- Bug #348: Data import failing due to authentication
- closedBug #349: EVE-Frontier: Player import failing due to API change
- closedBug #350: EVE-Frontier: Various imports failing due to API change