UntouchedWagons

I go to a random post, read some comments, collapse them then upvotes another comment. All the comments I collapsed are uncollapsed! Why?! What is the point of that?! Is that something I can turn off?

A couple of days ago I asked about using my xbox one controller with my steam deck. I did get it working via bluetooth but I'd prefer something I could plug into my dock. I have an old xbox 360 controller that still works but the PC receiver I had no longer works. If I get a replacement 360 receiver (or maybe a different receiver for an xbox one controller) will that work out of the box on my steam deck?

I know there's a project for the xbox one receiver I've got but due to the way SteamOS is set up I'd need to reinstall those drivers whenever there's an update which I don't really want to bother with.

This is the receiver I have: https://www.amazon.ca/gp/product/B00ZB7W4QU/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1

And this is the controller I have: https://www.amazon.ca/gp/product/B08DF26MXW/ref=ppx_yo_dt_b_search_asin_title?ie=UTF8&psc=1

If I try to connect the controller using bluetooth my deck can see the controller but can't establish a connection. Is there an addon I can install so that I can use the usb receiver I currently have?

The title is indeed terrible but I have no idea what to put. I am working on a Bill of Materials app and I'm starting out with the database layout and the REST API to interact with the database.

I currently have four tables but the query I want to write involves three of them

CREATE TABLE `components` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `price` float unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `products` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `description` text DEFAULT NULL,
  `tax_code` varchar(8) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_UNIQUE` (`name`),
  KEY `name_idx` (`tax_code`),
  CONSTRAINT `name` FOREIGN KEY (`tax_code`) REFERENCES `tax_codes` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE `product_components` (
  `product_id` int(10) unsigned NOT NULL,
  `component_id` int(10) unsigned NOT NULL,
  `count` int(10) unsigned NOT NULL,
  PRIMARY KEY (`product_id`,`component_id`),
  KEY `fk_component_id_idx` (`component_id`),
  CONSTRAINT `fk_component_id` FOREIGN KEY (`component_id`) REFERENCES `components` (`id`),
  CONSTRAINT `fk_product_id` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Now what I want to do is list all the products and for each product calculate the cost of all the components that product needs. So if a product needs 4 doodads that cost $1 and 7 whatzits that cost $2 the cost of the product would be $18 (41 + 72). I know I'd need some JOINs but I have no idea what I'd need.

I'm going on a trip tomorrow and want to be able to access jellyfin remotely but port forwarding JF isn't an option. I already have Wireguard set up on my pfsense router and my phone can VPN in just fine. I used to have a tablet so I reused its config for my steam deck. I SSH'd the config file over, imported in Network Manager. But when I activate the Wireguard VPN nearly the entire UI stops responding. The power button works and I can bring up the on-screen keyboard but that's it. My only option is to hold down the power button to force the deck to shut down.

Anyone have any ideas what's going on?

I'm looking for communities to subscribe to so I went to the Communities page then selected All but I can't sort the listed communities. My cursor changes to a finger when I hover over the Subscribers column but nothing happens when I click on it or any of the other columns..