v0.1.1

Start date 10/08/2023
Finish date 10/15/2023

about 23 months late

Automated skin code distribution

96% Total progress

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