Page 14 of 27

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Sun Oct 08, 2023 8:39 pm
by hiran
timer wrote: Sun Oct 08, 2023 8:10 pm
hiran wrote: Sun Oct 08, 2023 7:53 pm
I recreated the structure. And with that the website looks nice again. :-)
Amazing!

I need to think about how to improve management (without breaking the current mechanism) - editing a text file in Git is probably still not the most convenient way (IMHO).
I assumed that the primary source of data would be the database (CF D1), and we would receive information from it using the created API. But adding information into the database is possible either by loading the extension manifest.plist, or (the lazy way) by adding the download URL (I think this method is acceptable for relatively small archive sizes). This will allow us to validate the manifest when adding it.
Validation is necessary. Otherwise expansion authors could add whatever and create a lot of trouble.
Validation is even necessary after the first publishing. After all the files behind the download urls may be changed or removed, and the expansion index would be invalid.

And I believe an expansion author shall not be required to copy data from the expansion's manifest into a web form as it used to be.

So if we had a web application that takes the URL, downloads the archive and validates it, and only when that is good would add it to the catalog I'd be very glad. Also if that validation would kick in regularly.

Should we join forces and work together?

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Sun Oct 08, 2023 9:19 pm
by phkb
hiran wrote: Sun Oct 08, 2023 7:53 pm
I recreated the structure. And with that the website looks nice again.
Nice!

Question (and apologies if this has been explained earlier): Is the "DB" for this list now the content of each of the OXP's manifest file?

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Sun Oct 08, 2023 10:12 pm
by hiran
phkb wrote: Sun Oct 08, 2023 9:19 pm
hiran wrote: Sun Oct 08, 2023 7:53 pm
I recreated the structure. And with that the website looks nice again.
Nice!

Question (and apologies if this has been explained earlier): Is the "DB" for this list now the content of each of the OXP's manifest file?
Yes, that is true.

The git repo just contains the urls where to find the expansions. OoliteAddonScanner downloads the expansion and extracts the manifest information.
As an advantage there are no more discrepancies: In the old system the expansion catalog would not announce what the expansion actually contained. A WYSIWYG problem for users. Now that the data is taken directly from the OXPs this gap has been closed.

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Sun Oct 08, 2023 11:41 pm
by phkb
hiran wrote: Sun Oct 08, 2023 10:12 pm
Yes, that is true.

The git repo just contains the urls where to find the expansions. OoliteAddonScanner downloads the expansion and extracts the manifest information.
As an advantage there are no more discrepancies: In the old system the expansion catalog would not announce what the expansion actually contained. A WYSIWYG problem for users. Now that the data is taken directly from the OXPs this gap has been closed.
I can see lots of benefits for data consistency. I have a few questions about access control, how new data will be added, how OXP's can be "retired" (ie previously there was an option to "delete" an OXP, which removes it entirely from the DB, or to set it to "draft" which keeps the DB entries but hides it from the OXP list). But as long as these things are being included in the design, I can wait until things are more fleshed out.

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 4:15 am
by hiran
phkb wrote: Sun Oct 08, 2023 11:41 pm
hiran wrote: Sun Oct 08, 2023 10:12 pm
Yes, that is true.

The git repo just contains the urls where to find the expansions. OoliteAddonScanner downloads the expansion and extracts the manifest information.
As an advantage there are no more discrepancies: In the old system the expansion catalog would not announce what the expansion actually contained. A WYSIWYG problem for users. Now that the data is taken directly from the OXPs this gap has been closed.
I can see lots of benefits for data consistency. I have a few questions about access control, how new data will be added, how OXP's can be "retired" (ie previously there was an option to "delete" an OXP, which removes it entirely from the DB, or to set it to "draft" which keeps the DB entries but hides it from the OXP list). But as long as these things are being included in the design, I can wait until things are more fleshed out.
It all boils down to maintaining one file:
create: add a URL
read: well, tead the URL
update: modify the URL
delete: remove the URL
deactivate: comment out the URL (if you like use more comments to give a reason)

We also have version control so we can track who changed what when and commit messages.

Access control is via Github. What we do not have is that an author can edit only his entries. Either you can modify the repo or you cannot.

Oh btw, there is no secret infrastructure in the background. Everything runs in the freely available functions of Github.

What use cases do we need?

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 8:15 am
by Switeck
hiran wrote: Mon Oct 09, 2023 4:15 am
read: well, tead the URL
You lost me on this step. :?

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 8:44 am
by hiran
Switeck wrote: Mon Oct 09, 2023 8:15 am
hiran wrote: Mon Oct 09, 2023 4:15 am
read: well, tead the URL
You lost me on this step. :?
Sorry, a typo. It should have been
read: well, read the URL

Often software needs to provide CRUD functionality: create, read, update, delete.
Reading urls from a simple text file is so straightforward I am not surprised to have lost you.

But at least now I know you are reading... ;-)

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 12:36 pm
by phkb
Looking at the list of expansions you've currently got here, expansionUrls.txt, I think it needs some filtering.

For instance, the "HyperCargo" expansion is listed twice, for version 1.10 (http://wiki.alioth.net/img_auth.php/b/b ... o_1.10.oxz) and for version 1.11 (http://wiki.alioth.net/img_auth.php/1/1 ... o_1.11.oxz). However, according to the DB, the first one (1.10) has a status of "Deleted".

This then results in there being 2 entries on the expansion list web page and in OoliteStarter, with nothing to tell them apart except for the version number.

If anything in the original DB was flagged as "Deleted" or "Draft", it shouldn't be visible to players.

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 12:44 pm
by phkb
Here is a CSV dataset of all records that were "Deleted" or "Draft" in the DB:

Code: Select all

"version","identifier","download_url"
"2.5","uk.org.rockthehalo.oolite.oxp.Tricky.Jaguar_Company","http://rockthehalo.org.uk/oolite/OXPs/Jaguar_Company_2.5.oxz"
"1.2","oolite.oxp.cim.skilled-npcs","http://cim.sotl.org.uk/games/files/oolite/Skilled_NPCs_1.2.oxz"
"1.2","oolite.oxp.cim.systemfeatures.rings","http://cim.sotl.org.uk/games/files/oolite/System_Features_Rings_1.2.oxz"
"1.8.1","oolite.oxp.spara.navigation_mfd","http://wiki.alioth.net/img_auth.php/1/14/Navigation_mfd_1.8.1.oxz"
"0.103","oolite.oxp.Norby.Towbar","http://wiki.alioth.net/img_auth.php/e/e5/Towbar_0.103.oxz"
"1.24","oolite.oxp.Norby.ShipVersion","http://wiki.alioth.net/img_auth.php/6/64/ShipVersion_1.24.oxz"
"1.6.2","oolite.oxp.CaptMurphy.EscortContracts","http://wiki.alioth.net/img_auth.php/b/bc/Escort_Contracts_1.6.2.oxz"
"1.8.4","oolite.oxp.EricWalch.UPSCourier","http://wiki.alioth.net/img_auth.php/c/c2/UPS-Courier_1.8.4.oxz"
"1.30","oolite.oxp.Thargoid.Vortex","http://wiki.alioth.net/img_auth.php/b/b2/Vortex_1.30.oxz"
"2.2.2","oolite.oxp.spara.trophy_collector","http://wiki.alioth.net/img_auth.php/a/ac/Trophy_collector_2.2.2.oxz"
"1.2","oolite.oxp.EricWalch.TionislaReporter","http://wiki.alioth.net/img_auth.php/6/62/TionislaReporter_1.2.oxz"
"1.36","oolite.oxp.Thargoid.FuelStation","http://wiki.alioth.net/img_auth.php/8/8e/Fuel_Station_1.36.oxz"
"1.10","oolite.oxp.Thargoid.HyperCargo","http://wiki.alioth.net/img_auth.php/b/b4/HyperCargo_1.10.oxz"
"1.1","oolite.oxp.Norby.SafetyCatch","http://wiki.alioth.net/img_auth.php/8/82/SafetyCatch_1.2.oxz"
"2.3.1","oolite.oxp.Svengali.OXPConfig","http://wiki.alioth.net/img_auth.php/1/12/OXPConfig_2.3.1.oxz"
"1.10.7","oolite.oxp.Svengali.BGS","http://rockthehalo.org.uk/oolite/OXPs/BGS-A_1.10.7.oxz"
"1.4.1","oolite.oxp.CaptMurphy.ExplorersClub","http://wiki.alioth.net/img_auth.php/b/b2/ExplorersClub_1.4.1.oxz"
"1.00","oolite.oxp.Thargoid.NavalGrid","http://wiki.alioth.net/img_auth.php/7/75/Naval_Grid_1.00.oxz"
"1.3","oolite.oxp.spara.in-system_market_restore","http://wiki.alioth.net/img_auth.php//0/02/In-system_market_restore_1.3.oxz"
"1.5","oolite.oxp.Ramirez.Dictators","http://wiki.alioth.net/img_auth.php/1/14/Dictators_1.5.oxz"
"1.9.7","oolite.oxp.spara.random_hits_resources","http://wiki.alioth.net/img_auth.php/6/67/RandomHits_resources_1.9.7.oxz"
"1.51","oolite.oxp.Thargoid.Liners","http://wiki.alioth.net/img_auth.php/b/b1/Liners_v1.5.oxz"
"1.10.1","oolite.oxp.spara.market_inquirer","http://wiki.alioth.net/img_auth.php/0/0a/Market_inquirer_1.10.1.oxz"
"1.1","oolite.oxp.smivs.aliens","http://wiki.alioth.net/img_auth.php/4/46/Aliens_v1.1.oxz"
"1.2","oolite.oxp.smivs.contractor","http://wiki.alioth.net/img_auth.php/c/c8/Contractor_v1.2.oxz"
"1.1","oolite.oxp.smivs.cup_of_tea","http://wiki.alioth.net/img_auth.php/c/c4/Cup_of_Tea-v1.1.oxz"
"1.0","oolite.oxp.smivs.delightfulDocking","http://wiki.alioth.net/img_auth.php/4/40/Delightful-Docking.oxz"
"1.0","oolite.oxp.smivs.cloakRepair","http://wiki.alioth.net/img_auth.php/d/d0/CloakRepair.oxz"
"1.4.1","oolite.oxp.smivs.ExtraFuelTanks","http://wiki.alioth.net/img_auth.php/4/42/ExtraFuelTanks-v1.4.1.oxz"
"1.3","oolite.oxp.smivs.GalDrivePod","http://wiki.alioth.net/img_auth.php/2/28/GalDrivePod_v1.3.oxz"
"1.1","oolite.oxp.smivs.jellybabyDispenser","http://wiki.alioth.net/img_auth.php/0/0a/JellybabyDispenser.oxz"
"2.3","oolite.oxp.smivs.yellooCabs","http://wiki.alioth.net/img_auth.php/2/2a/YellOoCabs_v2.3.oxz"
"1.0","oolite.oxp.spara.asteroid_respawn","http://wiki.alioth.net/img_auth.php/a/ad/Asteroid_respawn.oxz"
"1.0","oolite.oxp.smivs.BetterBuoys","http://wiki.alioth.net/img_auth.php/2/2b/BetterBuoys.oxz"
"1.1","oolite.oxp.smivs.betterBuoys_v1.1","http://wiki.alioth.net/img_auth.php/b/bb/BetterBuoys_v1.1.oxz"
"1.4","oolite.oxp.smivs.ContractorMkII_v1.4","http://wiki.alioth.net/img_auth.php/1/18/ContractorMkII_v1.4.oxz"
"3.0","oolite.oxp.smivs.CombatHUD_v3.0","http://wiki.alioth.net/img_auth.php/4/4d/CombatHUD_v3.0.oxz"
"1.2","oolite.oxp.smivs.BetterBuoys","http://wiki.alioth.net/img_auth.php/f/ff/BetterBuoys_v1.2.oxz"
"1.1","oolite.oxp.smivs.BattleDamage","http://wiki.alioth.net/img_auth.php/7/78/BattleDamage_v1.1.oxz"
"1.12","oolite.oxp.Norby.CombatMFD","http://wiki.alioth.net/img_auth.php/f/fd/CombatMFD_1.12.oxz"
"1.3.3","oolite.oxp.smivs.Clippers","http://wiki.alioth.net/img_auth.php/8/86/Clippers_v1.3.3.oxz"
"0.5","oolite.oxp.zygougo.zygotraffic",
"4.0","oolite.oxp.smivs.CombatHUD_v3.0","http://wiki.alioth.net/img_auth.php/d/d6/CombatHUD_v4.0.oxz"
"4.0","oolite.oxp.smivs.CombatHUD-Widescreen","http://wiki.alioth.net/img_auth.php/0/0c/CombatHUD-WS_v4.0.oxz"
"4.1","oolite.oxp.smivs.CombatHUD-Widescreen","http://wiki.alioth.net/img_auth.php/0/07/CombatHUD-WS_v4.1.oxz"
"1.0","oolite.oxp.smivs.SmartHUD-WS","http://wiki.alioth.net/img_auth.php/3/3c/SmartHUD-WS_v1.0.oxz"
"1.0","oolite.oxp.author-name.oxp-name","For the manifest INSIDE the OXZ this isn't recessary."
"1.5","oolite.oxp.smivs.contractor","http://wiki.alioth.net/img_auth.php/a/a4/ContractorMkII_v1.5.oxz"
"2.15","oolite.oxp.Wildeblood.ai_trading","http://wiki.alioth.net/img_auth.php/0/0c/AI_Trading_Assistant_2.15.oxz"
"2.12.3","oolite.oxp.Wildeblood.ai_trading_datalogger","http://wiki.alioth.net/img_auth.php/b/ba/AI_Trading_Backup_Datalogger_2.12.3.oxz"
"1.0.1","oolite.oxp.Wildeblood.SelectableCrosshairs","http://wiki.alioth.net/img_auth.php/4/49/Selecto-o-matic_Crosshairs_1.0.1.oxz"
"0.2","oolite.oxp.Wildeblood.ActiveCrosshairs","http://wiki.alioth.net/img_auth.php/c/c6/Active_Crosshairs.oxz"
"3.0","oolite.oxp.smivs.GiantSpacePizza","http://wiki.alioth.net/img_auth.php/8/83/GiantSpacePizza_v3.0.oxz"
"1.0.1","oolite.oxp.Wildeblood.ai_trading_turbotrader","http://wiki.alioth.net/img_auth.php/6/6a/AI_Trading_Turbotrader.oxz"
"1.0","oolite.oxp.timer.BountyScanner",
"0.4.1","oolite.oxp.zireael.engine-trails","http://wiki.alioth.net/img_auth.php/1/19/Engine_Trails_0.4.1.oxz"
"0.1","oolite.oxp.cim.balance-test",
"1.0.1","oolite.oxp.Wildeblood.ai_trading_with_yoda","http://wiki.alioth.net/img_auth.php/f/f1/AI_Trading_with_Yoda.oxz"
"2.12","oolite.oxp.Wildeblood.ai_trading_purchase_book","http://wiki.alioth.net/img_auth.php/3/33/AI_Trading_Purchase_Book_2.12.oxz"
"2.0","oolite.oxp.cim.risk-based-economy",
"1.0.1","oolite.oxp.captain_beatnik.coluber_hud_ch01","http://wiki.alioth.net/img_auth.php/8/89/Coluber_HUD_CH01_v1.0.1.oxz"
"1.12","oolite.oxp.Norby.ILS","http://wiki.alioth.net/img_auth.php/6/64/ILS.1.12.oxz"
"1.21","oolite.oxp.captsolo.shadydeepspaceships1.21","http://wiki.alioth.net/img_auth.php/0/09/shadydeepspaceships1.21.oxz"
"0.96","oolite.oxp.amah.noshaders_ZGrOovy_stations_resources","http://wiki.alioth.net/img_auth.php/2/24/Oolite.oxp.amah.noshaders_ZGrOovy_stations_resources.oxz"
"0.98","oolite.oxp.amah.noshaders_ZGrOovy_stations_addon","http://wiki.alioth.net/img_auth.php/0/0e/Oolite.oxp.amah.noshaders_ZGrOovy_stations_addon.oxz"
"0.97","oolite.oxp.amah.noshaders_ZGrOovy_stations_replace","http://wiki.alioth.net/img_auth.php/a/a4/Oolite.oxp.amah.noshaders_ZGrOovy_stations_replace.oxz"
"0.1","oolite.oxp.cim.sotw.main",
"1.0","oolite.oxp.smivs.retroRefit","http://wiki.alioth.net/img_auth.php/a/a2/RetroRefit_v1.0.oxz"
"1.11","oolite.oxp.Norby.EscortDeck","http://wiki.alioth.net/img_auth.php/3/35/EscortDeck_1.11.oxz"
"0.6","oolite.oxp.Wildeblood.ai_autotrade_report_screen","http://wiki.alioth.net/img_auth.php/4/48/Autotrade_Report_Screen.oxz"
"0.1","oolite.oxp.cim.sotw.scenario",
"0.9","oolite.oxp.Wolfsstar BH.MilHUD_Refit",
"0.1.1","oolite.oxp.QCS.QTHI_AuxEnergyGenerators","http://wiki.alioth.net/img_auth.php/e/e9/Oolite.oxp.QCS.QTHI_AuxEnergyGenerators_0.1.1.oxz"
"2.4","oolite.oxp.Stormrider.Stormbrewer","http://wiki.alioth.net/img_auth.php/7/77/Stormbrewer_2.4.oxz"
"1.6.1","oolite.oxp.Layne.DockingFees","http://wiki.alioth.net/img_auth.php/9/9f/Oolite.oxp.Layne.DockingFees.oxz"
"0.4.2","oolite.oxp.zireael.engine-trails","http://wiki.alioth.net/img_auth.php/1/19/Engine_Trails_0.4.1.oxz"
"1.14.9","oolite.oxp.Ramen.Hyperspace_Hangar","http://wiki.alioth.net/img_auth.php/6/61/Hyperspace_Hangar-1.14.9.oxz"
"0.10","oolite.oxp.Lone_Wolf.MD5",
"1.0","oolite.oxp.Norby.HDBG-B",
"1.0","oolite.oxp.Norby.HDBG-C",
"1.1","oolite.oxp.Norby.Superhub_for_Extra_Planets","http://wiki.alioth.net/img_auth.php/5/53/Superhub_for_Extra_Planets_1.1.oxz"
"1.6.2","oolite.oxp.Pagroove.Superhub","http://wiki.alioth.net/img_auth.php/3/30/Superhub_1.6.2.oxz"
"0.9.2","oolite.oxp.ace\\56.NightAdder","http://wiki.alioth.net/img_auth.php/4/47/Ace_NightAdder.oxz"
"0.9.5","oolite.oxp.ace\\56.Cruzer","http://wiki.alioth.net/img_auth.php/2/23/Ace_Cruzer.oxz"
"0.9.3","oolite.oxp.ace\\56.Hornet","http://wiki.alioth.net/img_auth.php/7/7c/Ace_Hornet.oxz"
"1.03","oolite.oxp.Missile_Spoof",
"1.2","oolite.oxp.Turret_Toggler",
"1.3","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/3/39/MiningContracts_1.3.oxz"
"1.3","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/3/39/MiningContracts_1.3.oxz"
"1.4","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/8/87/MiningContracts_1.4.oxz"
"1.5","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/2/22/MiningContracts_1.5.oxz"
"1.6","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/a/a9/MiningContracts_1.6.oxz"
"1.7","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/f/f5/MiningContracts_1.7.oxz"
"1.8","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/d/d6/MiningContracts_1.8.oxz"
"1.9","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/d/d9/MiningContracts_1.9.oxz"
"1.10","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/d/de/MiningContracts_1.10.oxz"
"1.11","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/0/02/MiningContracts_1.11.oxz"
"1.0.2_alpha","oolite.oxp.ocz.AdditionalCargoSpaceAdjustments","http://wiki.alioth.net/img_auth.php/7/71/AdditionalCargoSpaceAdjustments-1.0.2_alpha.oxz"
"1.0","oolite.oxp.UK_Eliter.CloakVsMissiles","http://wiki.alioth.net/img_auth.php/3/37/CloakVersusMissiles.oxz\";"
"1.2","oolite.oxp.Norby.Separated_Lasers","http://wiki.alioth.net/img_auth.php/0/05/Separated_Lasers_1.2.oxz"
"2.11","oolite.oxp.Lone_Wolf.repairbotsnext",
"2.0.0","oolite.oxp.Lone_Wolf.CCL2_Common",
"1.0","oolite.oxp.Lone_Wolf.CCL2_UI",
"0.0.5","oolite.oxp.Rustem.DistantStar","http://wiki.alioth.net/img_auth.php/2/21/Distant_Stars_0.0.5.oxz"
"1.0","oolite.oxp.Ramen.stations_for_extra_planets_npc_trade",
"1.6.1","oolite.oxp.smivs.Liners","http://wiki.alioth.net/img_auth.php/e/e2/Liners_v1.6.1.oxz"
"1.0.1","oolite.oxp.cheyd.DHI_nav_buoy","http://wiki.alioth.net/img_auth.php/0/02/Oolite.oxp.cheyd.dhi_nav_buoy.oxz"
"1.46","oolite.oxp.Thargoid.Pods","http://wiki.alioth.net/img_auth.php/d/d3/Pods.oxz"
"1.6","oolite.oxp.Norby.ReverseControl","http://wiki.alioth.net/img_auth.php/c/c5/ReverseControl_1.6.oxz"
"1.15","oolite.oxp.Thargoid.Armoury","http://wiki.alioth.net/img_auth.php/1/14/Armoury_1.20.oxz"
"0.5.1","oolite.oxp.stranger.InSystemCargoDelivery","http://wiki.alioth.net/img_auth.php/6/61/InSystemCargoDelivery.oxz"
"4.3.0","oolite.oxp.stranger.SunGear","http://wiki.alioth.net/img_auth.php/2/28/SunGear.oxz"
"0.6","oolite.oxp.redspear.laser_combat_reimagined","http://wiki.alioth.net/img_auth.php/d/d0/Oolite.oxp.redspear.laser_combat_reimagined.oxz"
"0.1","oolite.oxp.Day.DiplomacyDebugger","https://github.com/DaymareOn/Diplomacy/blob/master/oolite.oxp.Day.DiplomacyDebugger.oxz?raw=true"
"4.3.0","oolite.oxp.stranger.SunGear","http://wiki.alioth.net/img_auth.php/2/28/SunGear.oxz"
"1.0","oolite.oxp.dybal.ChimeraGunship_Fix","http://wiki.alioth.net/img_auth.php/4/42/ChimeraGunship_Fix-1.0.oxz"
"1.0","oolite.oxp.dybal.CylonRaiderMk1_Fix","http://wiki.alioth.net/img_auth.php/a/a3/CylonRaiderMk1_Fix-1.0.oxz"
"1.0","oolite.oxp.dybal.GalTechEscortFighter_Fix","http://wiki.alioth.net/img_auth.php/d/d5/GalTechEscortFighter_Fix-1.0.oxz"
"1.2","oolite.oxp.Reval.Goods_Container","http://wiki.alioth.net/img_auth.php/b/b1/Goods_Container.oxz"
"1.2","oolite.oxp.Reval.Goods_Container2","http://wiki.alioth.net/img_auth.php/7/75/Goods_Container1.oxz"
"1.2","oolite.oxp.Reval.Goods_Container20","https://wiki.alioth.net/img_auth.php/c/c4/Goods_Container20.oxz"
"0.1","oolite.oxp.stranger.ComboF7Layout","https://wiki.alioth.net/index.php/File:ComboF7Layout.oxz"
"5.4.3","oolite.oxp.Matt634.Galactic_Navy","https://wiki.alioth.net/index.php/File:Oolite.oxp.Matt634.Galactic_Navy.oxz"

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 2:07 pm
by hiran
phkb wrote: Mon Oct 09, 2023 12:44 pm
Here is a CSV dataset of all records that were "Deleted" or "Draft" in the DB:

Code: Select all

"version","identifier","download_url"
"2.5","uk.org.rockthehalo.oolite.oxp.Tricky.Jaguar_Company","http://rockthehalo.org.uk/oolite/OXPs/Jaguar_Company_2.5.oxz"
"1.2","oolite.oxp.cim.skilled-npcs","http://cim.sotl.org.uk/games/files/oolite/Skilled_NPCs_1.2.oxz"
"1.2","oolite.oxp.cim.systemfeatures.rings","http://cim.sotl.org.uk/games/files/oolite/System_Features_Rings_1.2.oxz"
"1.8.1","oolite.oxp.spara.navigation_mfd","http://wiki.alioth.net/img_auth.php/1/14/Navigation_mfd_1.8.1.oxz"
"0.103","oolite.oxp.Norby.Towbar","http://wiki.alioth.net/img_auth.php/e/e5/Towbar_0.103.oxz"
"1.24","oolite.oxp.Norby.ShipVersion","http://wiki.alioth.net/img_auth.php/6/64/ShipVersion_1.24.oxz"
"1.6.2","oolite.oxp.CaptMurphy.EscortContracts","http://wiki.alioth.net/img_auth.php/b/bc/Escort_Contracts_1.6.2.oxz"
"1.8.4","oolite.oxp.EricWalch.UPSCourier","http://wiki.alioth.net/img_auth.php/c/c2/UPS-Courier_1.8.4.oxz"
"1.30","oolite.oxp.Thargoid.Vortex","http://wiki.alioth.net/img_auth.php/b/b2/Vortex_1.30.oxz"
"2.2.2","oolite.oxp.spara.trophy_collector","http://wiki.alioth.net/img_auth.php/a/ac/Trophy_collector_2.2.2.oxz"
"1.2","oolite.oxp.EricWalch.TionislaReporter","http://wiki.alioth.net/img_auth.php/6/62/TionislaReporter_1.2.oxz"
"1.36","oolite.oxp.Thargoid.FuelStation","http://wiki.alioth.net/img_auth.php/8/8e/Fuel_Station_1.36.oxz"
"1.10","oolite.oxp.Thargoid.HyperCargo","http://wiki.alioth.net/img_auth.php/b/b4/HyperCargo_1.10.oxz"
"1.1","oolite.oxp.Norby.SafetyCatch","http://wiki.alioth.net/img_auth.php/8/82/SafetyCatch_1.2.oxz"
"2.3.1","oolite.oxp.Svengali.OXPConfig","http://wiki.alioth.net/img_auth.php/1/12/OXPConfig_2.3.1.oxz"
"1.10.7","oolite.oxp.Svengali.BGS","http://rockthehalo.org.uk/oolite/OXPs/BGS-A_1.10.7.oxz"
"1.4.1","oolite.oxp.CaptMurphy.ExplorersClub","http://wiki.alioth.net/img_auth.php/b/b2/ExplorersClub_1.4.1.oxz"
"1.00","oolite.oxp.Thargoid.NavalGrid","http://wiki.alioth.net/img_auth.php/7/75/Naval_Grid_1.00.oxz"
"1.3","oolite.oxp.spara.in-system_market_restore","http://wiki.alioth.net/img_auth.php//0/02/In-system_market_restore_1.3.oxz"
"1.5","oolite.oxp.Ramirez.Dictators","http://wiki.alioth.net/img_auth.php/1/14/Dictators_1.5.oxz"
"1.9.7","oolite.oxp.spara.random_hits_resources","http://wiki.alioth.net/img_auth.php/6/67/RandomHits_resources_1.9.7.oxz"
"1.51","oolite.oxp.Thargoid.Liners","http://wiki.alioth.net/img_auth.php/b/b1/Liners_v1.5.oxz"
"1.10.1","oolite.oxp.spara.market_inquirer","http://wiki.alioth.net/img_auth.php/0/0a/Market_inquirer_1.10.1.oxz"
"1.1","oolite.oxp.smivs.aliens","http://wiki.alioth.net/img_auth.php/4/46/Aliens_v1.1.oxz"
"1.2","oolite.oxp.smivs.contractor","http://wiki.alioth.net/img_auth.php/c/c8/Contractor_v1.2.oxz"
"1.1","oolite.oxp.smivs.cup_of_tea","http://wiki.alioth.net/img_auth.php/c/c4/Cup_of_Tea-v1.1.oxz"
"1.0","oolite.oxp.smivs.delightfulDocking","http://wiki.alioth.net/img_auth.php/4/40/Delightful-Docking.oxz"
"1.0","oolite.oxp.smivs.cloakRepair","http://wiki.alioth.net/img_auth.php/d/d0/CloakRepair.oxz"
"1.4.1","oolite.oxp.smivs.ExtraFuelTanks","http://wiki.alioth.net/img_auth.php/4/42/ExtraFuelTanks-v1.4.1.oxz"
"1.3","oolite.oxp.smivs.GalDrivePod","http://wiki.alioth.net/img_auth.php/2/28/GalDrivePod_v1.3.oxz"
"1.1","oolite.oxp.smivs.jellybabyDispenser","http://wiki.alioth.net/img_auth.php/0/0a/JellybabyDispenser.oxz"
"2.3","oolite.oxp.smivs.yellooCabs","http://wiki.alioth.net/img_auth.php/2/2a/YellOoCabs_v2.3.oxz"
"1.0","oolite.oxp.spara.asteroid_respawn","http://wiki.alioth.net/img_auth.php/a/ad/Asteroid_respawn.oxz"
"1.0","oolite.oxp.smivs.BetterBuoys","http://wiki.alioth.net/img_auth.php/2/2b/BetterBuoys.oxz"
"1.1","oolite.oxp.smivs.betterBuoys_v1.1","http://wiki.alioth.net/img_auth.php/b/bb/BetterBuoys_v1.1.oxz"
"1.4","oolite.oxp.smivs.ContractorMkII_v1.4","http://wiki.alioth.net/img_auth.php/1/18/ContractorMkII_v1.4.oxz"
"3.0","oolite.oxp.smivs.CombatHUD_v3.0","http://wiki.alioth.net/img_auth.php/4/4d/CombatHUD_v3.0.oxz"
"1.2","oolite.oxp.smivs.BetterBuoys","http://wiki.alioth.net/img_auth.php/f/ff/BetterBuoys_v1.2.oxz"
"1.1","oolite.oxp.smivs.BattleDamage","http://wiki.alioth.net/img_auth.php/7/78/BattleDamage_v1.1.oxz"
"1.12","oolite.oxp.Norby.CombatMFD","http://wiki.alioth.net/img_auth.php/f/fd/CombatMFD_1.12.oxz"
"1.3.3","oolite.oxp.smivs.Clippers","http://wiki.alioth.net/img_auth.php/8/86/Clippers_v1.3.3.oxz"
"0.5","oolite.oxp.zygougo.zygotraffic",
"4.0","oolite.oxp.smivs.CombatHUD_v3.0","http://wiki.alioth.net/img_auth.php/d/d6/CombatHUD_v4.0.oxz"
"4.0","oolite.oxp.smivs.CombatHUD-Widescreen","http://wiki.alioth.net/img_auth.php/0/0c/CombatHUD-WS_v4.0.oxz"
"4.1","oolite.oxp.smivs.CombatHUD-Widescreen","http://wiki.alioth.net/img_auth.php/0/07/CombatHUD-WS_v4.1.oxz"
"1.0","oolite.oxp.smivs.SmartHUD-WS","http://wiki.alioth.net/img_auth.php/3/3c/SmartHUD-WS_v1.0.oxz"
"1.0","oolite.oxp.author-name.oxp-name","For the manifest INSIDE the OXZ this isn't recessary."
"1.5","oolite.oxp.smivs.contractor","http://wiki.alioth.net/img_auth.php/a/a4/ContractorMkII_v1.5.oxz"
"2.15","oolite.oxp.Wildeblood.ai_trading","http://wiki.alioth.net/img_auth.php/0/0c/AI_Trading_Assistant_2.15.oxz"
"2.12.3","oolite.oxp.Wildeblood.ai_trading_datalogger","http://wiki.alioth.net/img_auth.php/b/ba/AI_Trading_Backup_Datalogger_2.12.3.oxz"
"1.0.1","oolite.oxp.Wildeblood.SelectableCrosshairs","http://wiki.alioth.net/img_auth.php/4/49/Selecto-o-matic_Crosshairs_1.0.1.oxz"
"0.2","oolite.oxp.Wildeblood.ActiveCrosshairs","http://wiki.alioth.net/img_auth.php/c/c6/Active_Crosshairs.oxz"
"3.0","oolite.oxp.smivs.GiantSpacePizza","http://wiki.alioth.net/img_auth.php/8/83/GiantSpacePizza_v3.0.oxz"
"1.0.1","oolite.oxp.Wildeblood.ai_trading_turbotrader","http://wiki.alioth.net/img_auth.php/6/6a/AI_Trading_Turbotrader.oxz"
"1.0","oolite.oxp.timer.BountyScanner",
"0.4.1","oolite.oxp.zireael.engine-trails","http://wiki.alioth.net/img_auth.php/1/19/Engine_Trails_0.4.1.oxz"
"0.1","oolite.oxp.cim.balance-test",
"1.0.1","oolite.oxp.Wildeblood.ai_trading_with_yoda","http://wiki.alioth.net/img_auth.php/f/f1/AI_Trading_with_Yoda.oxz"
"2.12","oolite.oxp.Wildeblood.ai_trading_purchase_book","http://wiki.alioth.net/img_auth.php/3/33/AI_Trading_Purchase_Book_2.12.oxz"
"2.0","oolite.oxp.cim.risk-based-economy",
"1.0.1","oolite.oxp.captain_beatnik.coluber_hud_ch01","http://wiki.alioth.net/img_auth.php/8/89/Coluber_HUD_CH01_v1.0.1.oxz"
"1.12","oolite.oxp.Norby.ILS","http://wiki.alioth.net/img_auth.php/6/64/ILS.1.12.oxz"
"1.21","oolite.oxp.captsolo.shadydeepspaceships1.21","http://wiki.alioth.net/img_auth.php/0/09/shadydeepspaceships1.21.oxz"
"0.96","oolite.oxp.amah.noshaders_ZGrOovy_stations_resources","http://wiki.alioth.net/img_auth.php/2/24/Oolite.oxp.amah.noshaders_ZGrOovy_stations_resources.oxz"
"0.98","oolite.oxp.amah.noshaders_ZGrOovy_stations_addon","http://wiki.alioth.net/img_auth.php/0/0e/Oolite.oxp.amah.noshaders_ZGrOovy_stations_addon.oxz"
"0.97","oolite.oxp.amah.noshaders_ZGrOovy_stations_replace","http://wiki.alioth.net/img_auth.php/a/a4/Oolite.oxp.amah.noshaders_ZGrOovy_stations_replace.oxz"
"0.1","oolite.oxp.cim.sotw.main",
"1.0","oolite.oxp.smivs.retroRefit","http://wiki.alioth.net/img_auth.php/a/a2/RetroRefit_v1.0.oxz"
"1.11","oolite.oxp.Norby.EscortDeck","http://wiki.alioth.net/img_auth.php/3/35/EscortDeck_1.11.oxz"
"0.6","oolite.oxp.Wildeblood.ai_autotrade_report_screen","http://wiki.alioth.net/img_auth.php/4/48/Autotrade_Report_Screen.oxz"
"0.1","oolite.oxp.cim.sotw.scenario",
"0.9","oolite.oxp.Wolfsstar BH.MilHUD_Refit",
"0.1.1","oolite.oxp.QCS.QTHI_AuxEnergyGenerators","http://wiki.alioth.net/img_auth.php/e/e9/Oolite.oxp.QCS.QTHI_AuxEnergyGenerators_0.1.1.oxz"
"2.4","oolite.oxp.Stormrider.Stormbrewer","http://wiki.alioth.net/img_auth.php/7/77/Stormbrewer_2.4.oxz"
"1.6.1","oolite.oxp.Layne.DockingFees","http://wiki.alioth.net/img_auth.php/9/9f/Oolite.oxp.Layne.DockingFees.oxz"
"0.4.2","oolite.oxp.zireael.engine-trails","http://wiki.alioth.net/img_auth.php/1/19/Engine_Trails_0.4.1.oxz"
"1.14.9","oolite.oxp.Ramen.Hyperspace_Hangar","http://wiki.alioth.net/img_auth.php/6/61/Hyperspace_Hangar-1.14.9.oxz"
"0.10","oolite.oxp.Lone_Wolf.MD5",
"1.0","oolite.oxp.Norby.HDBG-B",
"1.0","oolite.oxp.Norby.HDBG-C",
"1.1","oolite.oxp.Norby.Superhub_for_Extra_Planets","http://wiki.alioth.net/img_auth.php/5/53/Superhub_for_Extra_Planets_1.1.oxz"
"1.6.2","oolite.oxp.Pagroove.Superhub","http://wiki.alioth.net/img_auth.php/3/30/Superhub_1.6.2.oxz"
"0.9.2","oolite.oxp.ace\\56.NightAdder","http://wiki.alioth.net/img_auth.php/4/47/Ace_NightAdder.oxz"
"0.9.5","oolite.oxp.ace\\56.Cruzer","http://wiki.alioth.net/img_auth.php/2/23/Ace_Cruzer.oxz"
"0.9.3","oolite.oxp.ace\\56.Hornet","http://wiki.alioth.net/img_auth.php/7/7c/Ace_Hornet.oxz"
"1.03","oolite.oxp.Missile_Spoof",
"1.2","oolite.oxp.Turret_Toggler",
"1.3","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/3/39/MiningContracts_1.3.oxz"
"1.3","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/3/39/MiningContracts_1.3.oxz"
"1.4","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/8/87/MiningContracts_1.4.oxz"
"1.5","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/2/22/MiningContracts_1.5.oxz"
"1.6","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/a/a9/MiningContracts_1.6.oxz"
"1.7","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/f/f5/MiningContracts_1.7.oxz"
"1.8","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/d/d6/MiningContracts_1.8.oxz"
"1.9","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/d/d9/MiningContracts_1.9.oxz"
"1.10","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/d/de/MiningContracts_1.10.oxz"
"1.11","oolite.oxp.Diagoras.MiningContracts","http://wiki.alioth.net/img_auth.php/0/02/MiningContracts_1.11.oxz"
"1.0.2_alpha","oolite.oxp.ocz.AdditionalCargoSpaceAdjustments","http://wiki.alioth.net/img_auth.php/7/71/AdditionalCargoSpaceAdjustments-1.0.2_alpha.oxz"
"1.0","oolite.oxp.UK_Eliter.CloakVsMissiles","http://wiki.alioth.net/img_auth.php/3/37/CloakVersusMissiles.oxz\";"
"1.2","oolite.oxp.Norby.Separated_Lasers","http://wiki.alioth.net/img_auth.php/0/05/Separated_Lasers_1.2.oxz"
"2.11","oolite.oxp.Lone_Wolf.repairbotsnext",
"2.0.0","oolite.oxp.Lone_Wolf.CCL2_Common",
"1.0","oolite.oxp.Lone_Wolf.CCL2_UI",
"0.0.5","oolite.oxp.Rustem.DistantStar","http://wiki.alioth.net/img_auth.php/2/21/Distant_Stars_0.0.5.oxz"
"1.0","oolite.oxp.Ramen.stations_for_extra_planets_npc_trade",
"1.6.1","oolite.oxp.smivs.Liners","http://wiki.alioth.net/img_auth.php/e/e2/Liners_v1.6.1.oxz"
"1.0.1","oolite.oxp.cheyd.DHI_nav_buoy","http://wiki.alioth.net/img_auth.php/0/02/Oolite.oxp.cheyd.dhi_nav_buoy.oxz"
"1.46","oolite.oxp.Thargoid.Pods","http://wiki.alioth.net/img_auth.php/d/d3/Pods.oxz"
"1.6","oolite.oxp.Norby.ReverseControl","http://wiki.alioth.net/img_auth.php/c/c5/ReverseControl_1.6.oxz"
"1.15","oolite.oxp.Thargoid.Armoury","http://wiki.alioth.net/img_auth.php/1/14/Armoury_1.20.oxz"
"0.5.1","oolite.oxp.stranger.InSystemCargoDelivery","http://wiki.alioth.net/img_auth.php/6/61/InSystemCargoDelivery.oxz"
"4.3.0","oolite.oxp.stranger.SunGear","http://wiki.alioth.net/img_auth.php/2/28/SunGear.oxz"
"0.6","oolite.oxp.redspear.laser_combat_reimagined","http://wiki.alioth.net/img_auth.php/d/d0/Oolite.oxp.redspear.laser_combat_reimagined.oxz"
"0.1","oolite.oxp.Day.DiplomacyDebugger","https://github.com/DaymareOn/Diplomacy/blob/master/oolite.oxp.Day.DiplomacyDebugger.oxz?raw=true"
"4.3.0","oolite.oxp.stranger.SunGear","http://wiki.alioth.net/img_auth.php/2/28/SunGear.oxz"
"1.0","oolite.oxp.dybal.ChimeraGunship_Fix","http://wiki.alioth.net/img_auth.php/4/42/ChimeraGunship_Fix-1.0.oxz"
"1.0","oolite.oxp.dybal.CylonRaiderMk1_Fix","http://wiki.alioth.net/img_auth.php/a/a3/CylonRaiderMk1_Fix-1.0.oxz"
"1.0","oolite.oxp.dybal.GalTechEscortFighter_Fix","http://wiki.alioth.net/img_auth.php/d/d5/GalTechEscortFighter_Fix-1.0.oxz"
"1.2","oolite.oxp.Reval.Goods_Container","http://wiki.alioth.net/img_auth.php/b/b1/Goods_Container.oxz"
"1.2","oolite.oxp.Reval.Goods_Container2","http://wiki.alioth.net/img_auth.php/7/75/Goods_Container1.oxz"
"1.2","oolite.oxp.Reval.Goods_Container20","https://wiki.alioth.net/img_auth.php/c/c4/Goods_Container20.oxz"
"0.1","oolite.oxp.stranger.ComboF7Layout","https://wiki.alioth.net/index.php/File:ComboF7Layout.oxz"
"5.4.3","oolite.oxp.Matt634.Galactic_Navy","https://wiki.alioth.net/index.php/File:Oolite.oxp.Matt634.Galactic_Navy.oxz"
Hmmm. If you can still use the DB...
How about creating the list of active URLs and replacing the content of expansionUrls.txt with that?

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 4:44 pm
by Nite Owl
My guess is that this great work you are doing will eventually solve the issue of the wiki and/or download links for Expansions looping back to the Main Page of the web site? The looping occurs with the links on both the Main Page and the Expansion Packs page.

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 4:58 pm
by hiran
Nite Owl wrote: Mon Oct 09, 2023 4:44 pm
My guess is that this great work you are doing will eventually solve the issue of the wiki and/or download links for Expansions looping back to the Main Page of the web site? The looping occurs with the links on both the Main Page and the Expansion Packs page.
I'm not sure I understand.
Could you describe that loop in more detail or show an example?

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 7:30 pm
by timer
Nite Owl wrote: Mon Oct 09, 2023 4:44 pm
My guess is that this great work you are doing will eventually solve the issue of the wiki and/or download links for Expansions looping back to the Main Page of the web site? The looping occurs with the links on both the Main Page and the Expansion Packs page.
At the moment the site OXP page is fixed - download links work, or are you asking about something else?

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 7:33 pm
by timer
hiran wrote: Sun Oct 08, 2023 8:39 pm
Should we join forces and work together?
Of course, we shouldn’t do it any other way :)
but I kindly ask you to give me a little more time to formulate how I see the management process.

Re: Oolite Website Domain & Fixing the Expansions Manager

Posted: Mon Oct 09, 2023 7:39 pm
by timer
timer wrote: Mon Oct 09, 2023 7:30 pm
Nite Owl wrote: Mon Oct 09, 2023 4:44 pm
My guess is that this great work you are doing will eventually solve the issue of the wiki and/or download links for Expansions looping back to the Main Page of the web site? The looping occurs with the links on both the Main Page and the Expansion Packs page.
At the moment the site OXP page is fixed - download links work, or are you asking about something else?
but...
@hiran, we have a problem: if the information_url is empty - the link point on the main page of the site. The "right download" link (icon) works, but if you click on the package name itself, it redirect you to the main page.
Perhaps I should disable displaying the name as a link if information_url is empty?