Files
naut 55f4e12614 Codeside Cargo Refactor (#20030)
**NOTE TO SYSADMINS: See "SQL Details" section below for information on
SQL modifications.**

Moves the data containing cargo items (i.e. the ones you order from ops
and get in the cargo shuttle) from the online database to the codebase.
Everything from suppliers to categories to individual items is now
code-side and editable by developers/contributors.

Refactors cargo items to use `singletons` instead of `datums` for
`cargo_supplier`, `cargo_category`, and `cargo_item`. Multiple-instnace
things like cargo_orders, etc. still use `datums`.

Fixed a bunch of strange discrepancies in categories, suppliers, and
pricing for various cargo items. I did a little bit, but it's exhausting
to go through all of it right now.

Clicking the 'Details' button on the Cargo Order app now actually gives
you details instead of bluescreening. Also added some UI elements to the
Cargo Order app - Cargo Control and Delivery remain untouched.

Overhauled the Cargo Order console TGUI window. It now has tabs on the
left, displays restricted access, supplier information, and boasts
search functionality.

### SQL Details
<details>
<summary>SQL Details [Click to Expand]</summary>

The following SQL tables should be deleted or deprecated from the server
database, as they are no longer in use:

- `ss13_cargo_items`
- `ss13_cargo_categories`
- `ss13_cargo_suppliers`

The included migration file, `V011__codeside_cargo`, creates a new table
`ss13_cargo_item_orderlog` to the DB. This **replaces**
`ss13_cargo_orderlog_items`. Because of this,
`ss13_cargo_orderlog_items` is deprecated and should either be deleted
or locked & preserved for logging purposes.

</details>

## Screenshots


![image](https://github.com/user-attachments/assets/79129923-1fb6-4cee-ac8d-5505a52270a4)

![image](https://github.com/user-attachments/assets/a323be35-8ce6-4ec4-98f7-ee701d0931a3)

![image](https://github.com/user-attachments/assets/5ddb02c5-152f-4715-b2da-20903fa11c93)

![image](https://github.com/user-attachments/assets/420e45b0-6a9f-4420-beb8-a2c8423a5be4)

![image](https://github.com/user-attachments/assets/114f4755-ee51-41e6-8670-07aacc5326ae)

---------

Signed-off-by: naut <55491249+nauticall@users.noreply.github.com>
Co-authored-by: Fluffy <65877598+FluffyGhoster@users.noreply.github.com>
2025-03-04 18:18:00 +00:00

138 lines
6.3 KiB
Plaintext

/datum/space_sector/tau_ceti
name = SECTOR_TAU_CETI
description = "Tau Ceti is a system located in close proximity of Sol, and serves as the main base of operation for the megacorporation NanoTrasen. Tau Ceti is governed by the \
Republic of Biesel, a young Republic that became independent of the economically troubled Sol Alliance in 2452 due to heavy pressure by NanoTrasen. There is still resentment in \
the Sol Alliance over the loss of such a wealthy system, while NanoTrasen continues to have a heavy hand in all levels of Tau Ceti."
cargo_price_coef = list(
"nanotrasen" = 0.8,
"orion" = 1,
"getmore" = 0.7,
"arizi" = 1.2,
"vysoka" = 1.2,
)
guaranteed_exoplanets = list(/obj/effect/overmap/visitable/sector/exoplanet/biesel)
possible_exoplanets = list(/obj/effect/overmap/visitable/sector/exoplanet/lava/caprice, /obj/effect/overmap/visitable/sector/exoplanet/desert/luthien, /obj/effect/overmap/visitable/sector/exoplanet/barren/valkyrie,
/obj/effect/overmap/visitable/sector/exoplanet/snow/new_gibson, /obj/effect/overmap/visitable/sector/exoplanet/barren/asteroid/ice/chandras, /obj/effect/overmap/visitable/sector/exoplanet/barren/asteroid/dumas)
ports_of_call = list("the city of Mendell, Republic's Landing")
scheduled_port_visits = list("Saturday", "Sunday")
starlight_color = "#9cd0fd"
starlight_power = 5
starlight_range = 2
lore_radio_stations = list(
"87.5 Mendell City Bugle Radio" = 'texts/lore_radio/tauceti/87.5_Mendell_City_Bugle.txt',
"90.7 Hi-Fi Sports FM" = 'texts/lore_radio/tauceti/90.7_Hi_Fi_Sports.txt',
"93.1 Phoenix FM" = 'texts/lore_radio/tauceti/93.1_PhoenixFM.txt',
"17.9 Adhomai Ceti-Connection" = 'texts/lore_radio/tauceti/17.9_Adhomai_Ceti-Connection.txt',
"28.1 D6 Citizen Radio" = 'texts/lore_radio/tauceti/28.1_D6_Citizen_Radio.txt',
"95.3 QRCC" = 'texts/lore_radio/tauceti/95.3_QRCC.txt',
"93.8 Biesellian Song Broadcast" = 'texts/lore_radio/tauceti/93.8_Biesellian_Song_Broadcast.txt',
"113.7 ZOTH-FM Vaurca Radio Station" = 'texts/lore_radio/tauceti/113.7_ZOTH_F_Vaurca_Radio_Station.txt',
"52.4 Raging Tides" = 'texts/lore_radio/tauceti/52.4_Raging_Tides.txt'
)
/datum/space_sector/romanovich
name = SECTOR_ROMANOVICH
description = "The Romanovich Cloud is a shell of icy, rocky and metallic bodies that orbit very distant Tau Ceti, past even the Dust Belt. Rich in deposits of precious and \
semi-precious metals as well as radioactive elements, the Romanovich Cloud is the source of nearly all the raw materials used within Tau Ceti. The cloud is also one of the few \
sources of Phoron, a volatile but highly-sought after compound, known for its uses in the biomedical and energy industries. Most of the sources of Phoron within the Romanovich \
Cloud are under control of NanoTrasen, which has consequently established many high-tech research facilities in the area in the past few years."
possible_exoplanets = list(/obj/effect/overmap/visitable/sector/exoplanet/barren/asteroid, /obj/effect/overmap/visitable/sector/exoplanet/barren/asteroid/romanovich)
starlight_color = "#9cd0fd"
starlight_power = 5
starlight_range = 2
meteors_minor = list(
/obj/effect/meteor/medium = 80,
/obj/effect/meteor/dust = 30,
/obj/effect/meteor/irradiated = 30,
/obj/effect/meteor/big = 30,
/obj/effect/meteor/flaming = 10,
/obj/effect/meteor/golden = 10,
/obj/effect/meteor/silver = 10
)
meteors_moderate = list(
/obj/effect/meteor/medium = 80,
/obj/effect/meteor/big = 30,
/obj/effect/meteor/dust = 30,
/obj/effect/meteor/irradiated = 30,
/obj/effect/meteor/flaming = 10,
/obj/effect/meteor/golden = 10,
/obj/effect/meteor/silver = 10,
/obj/effect/meteor/emp = 10
)
meteors_major = list(
/obj/effect/meteor/medium = 80,
/obj/effect/meteor/big = 30,
/obj/effect/meteor/dust = 30,
/obj/effect/meteor/irradiated = 30,
/obj/effect/meteor/emp = 30,
/obj/effect/meteor/flaming = 10,
/obj/effect/meteor/golden = 10,
/obj/effect/meteor/silver = 10
)
meteors_normal = list(\
/obj/effect/meteor/medium=8,\
/obj/effect/meteor/dust=3,\
/obj/effect/meteor/irradiated=3,\
/obj/effect/meteor/big=3,\
/obj/effect/meteor/flaming=1,\
/obj/effect/meteor/golden=1,\
/obj/effect/meteor/silver=1\
)
meteors_threatening = list(\
/obj/effect/meteor/big=10,\
/obj/effect/meteor/medium=5,\
/obj/effect/meteor/golden=3,\
/obj/effect/meteor/silver=3,\
/obj/effect/meteor/flaming=3,\
/obj/effect/meteor/irradiated=3,\
/obj/effect/meteor/emp=3\
)
meteors_catastrophic = list(\
/obj/effect/meteor/big=75,\
/obj/effect/meteor/flaming=10,\
/obj/effect/meteor/irradiated=10,\
/obj/effect/meteor/emp=10,\
/obj/effect/meteor/medium=5,\
/obj/effect/meteor/golden=4,\
/obj/effect/meteor/silver=4
)
meteors_armageddon = list(\
/obj/effect/meteor/big=25,\
/obj/effect/meteor/flaming=10,\
/obj/effect/meteor/irradiated=10,\
/obj/effect/meteor/emp=10,\
/obj/effect/meteor/medium=3,\
/obj/effect/meteor/golden=2,\
/obj/effect/meteor/silver=2\
)
meteors_cataclysm = list(\
/obj/effect/meteor/big=40,\
/obj/effect/meteor/emp=20,\
/obj/effect/meteor/irradiated=10,\
/obj/effect/meteor/golden=10,\
/obj/effect/meteor/silver=10,\
/obj/effect/meteor/flaming=10,\
/obj/effect/meteor/supermatter=1\
)
/datum/space_sector/corp_zone
name = SECTOR_CORP_ZONE
description = "Formerly Solarian space, the Corporate Reconstruction Zone is the name for all systems occupied by the Republic of Biesel that are not within Tau Ceti's gravity well. \
The Zone, or the CRZ, is an area of instability and logistical chaos where once-Alliance colonies exist in relative peace compared to the adjacent Human Wildlands. This is owed to \
two factors: the presence of the lingering Stellar Corporate Conglomerate, and the federal authority of the Republic of Biesel backing them up. Warlords and major antagonistic \
factions (to Biesel) generally refrain from entering these territories to avoid the ire of the Conglomerate, much less the repercussions of engaging its allies."
possible_exoplanets = list(/obj/effect/overmap/visitable/sector/exoplanet/barren/asteroid, /obj/effect/overmap/visitable/sector/exoplanet/barren, /obj/effect/overmap/visitable/sector/exoplanet/grass/grove)
starlight_color = "#9cd0fd"
starlight_power = 5
starlight_range = 2