Quark95 1y ago • 100%
The classic, The Fellowship of the Ring
Quark95 1y ago • 100%
That’s fucking gorgeous Joe!
Quark95 1y ago • 100%
Guess I’m in the minority, but I feel like this new icon doesn’t fit in with the iOS design language. The old icon was better IMO. I’d prefer the old one with some nicer colors
Quark95 1y ago • 100%
I agree this suggested layout is a lot better than the current TestFlight build
Quark95 1y ago • 100%
Fallout 4 ☢️
cross-posted from: https://lemmy.fmhy.ml/post/778602 > In this guide I will explain how to add edition tags to movies or alter already existing ones. This guide assumes you have access to the plex database. > > ### Limitations > While this solution enables anyone to add/remove edition tags that will show up in any app/website that supports them. Some features are still be restricted to PlexPass subscribers such as displaying other editions on the movie details page. > > > ## Method > > ### 1. Identify your plex database location. > Generally your database should be located here: > `[Plex data directory]/Plug-in Support/Databases`. > But depending on your system `[Plex data directory]` will be different. > [Here is a list of common directories.](https://support.plex.tv/articles/202915258-where-is-the-plex-media-server-data-directory-located/) > > ### 2. Identify your plex binary location. > This might be a little more difficult as there is no nice pre-made list as there is with the data-directory. Try googling a little. > In my case the path is `/volume3/@appstore/Plex Media Server/Plex Media Server`, since I installed plex in Volume 3 on my Synology. > > If you are unable to locate your plex binary you may still be able to continue if you have sqlite3 installed on your system. Though I have not tested this solution. > > ### 3. Connecting to the database > Open your terminal and make sure you can access the plex binary. If your plex binary is on a server or in a docker container you may have to access it using ssh. In my case I have to use ssh: `ssh Quark95@123.69.10.420`. > > > You may have to enable ssh access on your system. > > Now we can connect to the database using SQLite. The command will look like this: `"[Plex binary path]" --sqlite "[Plex Data directory]/Plug-in Support/Databases/com.plexapp.plugins.library.db"`. > > Alternatively you could try `sqlite3 "[Plex Data directory]/Plug-in Support/Databases/com.plexapp.plugins.library.db"` > > And for reference my command looks like this: `"/volume3/@appstore/Plex Media Server/Plex Media Server" --sqlite "/volume3/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"` > > Now a prompt should appear that looks like this: > > `sqlite>` > > ### 4. Finding IDs > Now you'll need to find the ID of the movie(s) you want to edit. To do this, find the movie in your plex library on desktop, in the ... menu select `Get Info` and press `View XML`. In the XML file that opens you'll find the id as a string here: `<Video ratingKey="108014"`. Where in this case `108014` is the id. > > ### 5. Editing the database > > Before you continue I must warn you that editing the database in this way is not supported and if done incorrectly, can in a worst case scenario corrupt the plex database. However, as we are doing only minor changes, I feel it is relatively safe. > > Here are some examples of common commands I've found useful: > Remember to change `<your movie id>`, `<old tag>` and `<new tag>` or you may get an error. > - Add/edit edition tag for a single item: > `UPDATE metadata_items SET edition_title = "<new tag>" WHERE id = <your movie id>;` > - Add/edit tag for a list of items: > `UPDATE metadata_items SET edition_title = "<new tag>" WHERE id in (<your movie id>, <your movie id>, <your movie id>);` > - Edit all instances of a tag from `<old tag>` to `<new tag>`: > `UPDATE metadata_items SET edition_title = "<New tag>" WHERE edition_title = "<old tag>";` > > # That's it! > -- Quark95 🖖🏻
In this guide I will explain how to add edition tags to movies or alter already existing ones. This guide assumes you have access to the plex database. ### Limitations While this solution enables anyone to add/remove edition tags that will show up in any app/website that supports them. Some features are still be restricted to PlexPass subscribers such as displaying other editions on the movie details page. ## Method ### 1. Identify your plex database location. Generally your database should be located here: `[Plex data directory]/Plug-in Support/Databases`. But depending on your system `[Plex data directory]` will be different. [Here is a list of common directories.](https://support.plex.tv/articles/202915258-where-is-the-plex-media-server-data-directory-located/) ### 2. Identify your plex binary location. This might be a little more difficult as there is no nice pre-made list as there is with the data-directory. Try googling a little. In my case the path is `/volume3/@appstore/Plex Media Server/Plex Media Server`, since I installed plex in Volume 3 on my Synology. If you are unable to locate your plex binary you may still be able to continue if you have sqlite3 installed on your system. Though I have not tested this solution. ### 3. Connecting to the database Open your terminal and make sure you can access the plex binary. If your plex binary is on a server or in a docker container you may have to access it using ssh. In my case I have to use ssh: `ssh Quark95@123.69.10.420`. > You may have to enable ssh access on your system. Now we can connect to the database using SQLite. The command will look like this: `"[Plex binary path]" --sqlite "[Plex Data directory]/Plug-in Support/Databases/com.plexapp.plugins.library.db"`. Alternatively you could try `sqlite3 "[Plex Data directory]/Plug-in Support/Databases/com.plexapp.plugins.library.db"` And for reference my command looks like this: `"/volume3/@appstore/Plex Media Server/Plex Media Server" --sqlite "/volume3/Plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases/com.plexapp.plugins.library.db"` Now a prompt should appear that looks like this: `sqlite>` ### 4. Finding IDs Now you'll need to find the ID of the movie(s) you want to edit. To do this, find the movie in your plex library on desktop, in the ... menu select `Get Info` and press `View XML`. In the XML file that opens you'll find the id as a string here: `<Video ratingKey="108014"`. Where in this case `108014` is the id. ### 5. Editing the database > Before you continue I must warn you that editing the database in this way is not supported and if done incorrectly, can in a worst case scenario corrupt the plex database. However, as we are doing only minor changes, I feel it is relatively safe. Here are some examples of common commands I've found useful: Remember to change `<your movie id>`, `<old tag>` and `<new tag>` or you may get an error. - Add/edit edition tag for a single item: `UPDATE metadata_items SET edition_title = "<new tag>" WHERE id = <your movie id>;` - Add/edit tag for a list of items: `UPDATE metadata_items SET edition_title = "<new tag>" WHERE id in (<your movie id>, <your movie id>, <your movie id>);` - Edit all instances of a tag from `<old tag>` to `<new tag>`: `UPDATE metadata_items SET edition_title = "<New tag>" WHERE edition_title = "<old tag>";` # That's it! -- Quark95 🖖🏻
Quark95 1y ago • 100%
I used to do this too, loved it. And planning on doing it again. Gonna miss it when macOS drops support for Intel.
Unless I’m mistaken, currently it’s only possible to upload images from the photos app, but most of the time I want to upload files from the files app so that feature would be *nice.*
Quark95 1y ago • 100%
Breathtaking!
[Download](https://dropovercl.s3.amazonaws.com/cd4e7e4a-0247-4760-b561-0564fca9717d/33d473cc-824f-4fb2-9902-c751e17623df/56c12c9c-7809-497c-b0ae-be8aa0ec0493.zip)
Quark95 1y ago • 100%
This is the biggest issue for me so far using Memmy
[Download](https://dropovercl.s3.amazonaws.com/e776bf56-a5dd-4695-a31d-36a35b13a8b7/d5058215-5f5e-4d0f-a753-8e96c7991be9/19c397e6-418b-4463-b111-db1e2cf26dc7.zip)
[Download](https://dropovercl.s3.amazonaws.com/9c0325d8-1a90-4c8d-8316-eea5bbb95e74/abc0271d-cc3f-468b-b71b-83f15be182ca/cc6cca54-c6bb-43cf-abb1-88befc676418.zip)
Quark95 1y ago • 100%
I’ve tried using it before and while it’s usable on mobile I’ve always found the ui to be too unintuitive on desktop.
Quark95 1y ago • 100%
Science/medical division 🖖🏻
![](https://lemmy.fmhy.ml/pictrs/image/bdaaedf8-22d3-4887-9a7e-078dc4bc3de3.jpeg) ![](https://lemmy.fmhy.ml/pictrs/image/16647b08-43a5-4522-ab1e-6e696d69afa8.jpeg) ![](https://lemmy.fmhy.ml/pictrs/image/8885685c-14e0-451f-97cc-7e7fb681e8f1.jpeg)
Quark95 1y ago • 100%
Use MKVToolNix for losslessly editing MKV files
Quark95 1y ago • 100%
Have you considered using Plex as your music server? I’ve had a great experience with it.
Quark95 1y ago • 100%
I appreciate your optimistic view on the situation. I really hope Lemmy will one day reach the same level of popularity as Reddit.
Quark95 1y ago • 100%
Thanks to Elon I can’t read this tweet :(
Quark95 1y ago • 100%
Hah, could hear his voice while reading
Quark95 1y ago • 97%
Man, this really isn’t a good year for the internet
**Welcome weary traveler!** I, as I imagine many of you reading this can relate to, have been looking to distance myself from the reddit empire, but still have that reddit itch I need to scratch. To mitigate this I wanted to start this community as an alternative to the subreddit of the same name. I have no moderation experience so it may be a bumpy ride, but I suppose it wouldn't be much fun otherwise. I still haven't figured out all the rules or how to run one of these communities, but how hard can it be haha. :) As the name on the can suggests, this community is intended to be a place to share high quality covers for audiobooks. **Suggestions welcome, enjoy your stay!**
Quark95 1y ago • 80%
Myanonamouse is quite good, the registration is easy and there is allot of content. Unfortunately a lot of it is 64Kb/s and/or 22.1KHz or lower which imo is distractingly bad while listening, but there is still a good selection of higher quality books. 8/10 would mouse again.