Plex Quark95 • 1y ago • 100%

[Guide] Adding/editing Plex edition tags using simple SQL commands. No PlexPass Required.

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 🖖🏻

Plex Quark95 • 1y ago • 100%

[Guide] Adding/editing Plex edition tags using simple SQL commands. No PlexPass Required.

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 🖖🏻

Memmy - An iOS client for Lemmy Quark95 • 1y ago • 100%

[Feature request] Allow me to upload images from the files app instead of only the photos app

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.*

Audiobook Covers Quark95 • 1y ago • 100%

[Original, Series] Harry Potter (1997 - 2007) - J.K. Rowling - Book Covers

[Download](https://dropovercl.s3.amazonaws.com/cd4e7e4a-0247-4760-b561-0564fca9717d/33d473cc-824f-4fb2-9902-c751e17623df/56c12c9c-7809-497c-b0ae-be8aa0ec0493.zip)

Audiobook Covers Quark95 • 1y ago • 100%

[Cleaned, Series] Harry Potter (1997 - 2007) - J.K. Rowling, Stephen Fry, Jim Dale - Hogwarts Covers

[Download](https://dropovercl.s3.amazonaws.com/e776bf56-a5dd-4695-a31d-36a35b13a8b7/d5058215-5f5e-4d0f-a753-8e96c7991be9/19c397e6-418b-4463-b111-db1e2cf26dc7.zip)

Audiobook Covers Quark95 • 1y ago • 100%

[Cleaned, Series] Harry Potter (1997 - 2007) - J.K. Rowling, Stephen Fry, Jim Dale - Character Covers

[Download](https://dropovercl.s3.amazonaws.com/9c0325d8-1a90-4c8d-8316-eea5bbb95e74/abc0271d-cc3f-468b-b71b-83f15be182ca/cc6cca54-c6bb-43cf-abb1-88befc676418.zip)

Audiobook Covers Quark95 • 1y ago • 100%

[Original, Series] The Lord of the Rings (1954 - 1955) - J.R.R. Tolkien, Rob Inglis

  

Audiobook Covers Quark95 • 1y ago • 100%

Welcome to c/audiobookcovers!

**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!**