•   
  • 1
  • 20
  • 21
  • 22
  • 23
  • 24(current)
[MYSQL] HOW-TO: 5 User XBMC
(2021-05-15, 03:03)Supay Wrote: I'm not sure if it is due to having this setup, but is anyone able to please advise me?

I am running this multi-user setup with 6 users.  Myself as the master so I can manage it all, with all sources scraped to the database.  Other users are 2 children and 3 adults.  I have setup everyone with their own profile and have everything configured for each person.  For the children, they only have three sources added, for child friendly content, however of course because they run off the same database master the content for that still shows up.  I therefore set a custom library node with a rule specifically for those source paths and replaced the main menu TV Shows with this custom library node.  However, all of the adult source content still shows up.  Is this still due to the database info showing up for them and thereby just outright bypassing the sources?  Is there any way to tweak this so that we can all run off the same setup but exclude specific content from the child profiles please?
Yes this is because of the DB, I do remember someone else doing some changes to the views that are used for the kids to remove content. I
 can have a look at editing some of the SQL for you.

What are the 3 sources you want for the kids?
Reply
(2021-05-16, 16:53)BigMong Wrote:
(2021-05-15, 03:03)Supay Wrote: I'm not sure if it is due to having this setup, but is anyone able to please advise me?

I am running this multi-user setup with 6 users.  Myself as the master so I can manage it all, with all sources scraped to the database.  Other users are 2 children and 3 adults.  I have setup everyone with their own profile and have everything configured for each person.  For the children, they only have three sources added, for child friendly content, however of course because they run off the same database master the content for that still shows up.  I therefore set a custom library node with a rule specifically for those source paths and replaced the main menu TV Shows with this custom library node.  However, all of the adult source content still shows up.  Is this still due to the database info showing up for them and thereby just outright bypassing the sources?  Is there any way to tweak this so that we can all run off the same setup but exclude specific content from the child profiles please?
Yes this is because of the DB, I do remember someone else doing some changes to the views that are used for the kids to remove content. I
 can have a look at editing some of the SQL for you.

What are the 3 sources you want for the kids?

Thank you for this!  Though I imagine if you get a nice way to work this out you will also make a lot of others happy.  The sources I want specifically for the children are below.  I have them in folders based on UK age ratings for films and just a kids TV folder.

        <default pathversion="1"></default>
        <source>
            <name>movies-12</name>
            <path pathversion="1">nfs://10.17.42.50/srv/nfs/movies-12/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>movies-pg</name>
            <path pathversion="1">nfs://10.17.42.50/srv/nfs/movies-pg/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>tv-kids</name>
            <path pathversion="1">nfs://10.17.42.50/srv/nfs/tv-kids/</path>
            <allowsharing>true</allowsharing>
Reply
(2021-05-17, 11:22)Supay Wrote:
(2021-05-16, 16:53)BigMong Wrote:
(2021-05-15, 03:03)Supay Wrote: I'm not sure if it is due to having this setup, but is anyone able to please advise me?

I am running this multi-user setup with 6 users.  Myself as the master so I can manage it all, with all sources scraped to the database.  Other users are 2 children and 3 adults.  I have setup everyone with their own profile and have everything configured for each person.  For the children, they only have three sources added, for child friendly content, however of course because they run off the same database master the content for that still shows up.  I therefore set a custom library node with a rule specifically for those source paths and replaced the main menu TV Shows with this custom library node.  However, all of the adult source content still shows up.  Is this still due to the database info showing up for them and thereby just outright bypassing the sources?  Is there any way to tweak this so that we can all run off the same setup but exclude specific content from the child profiles please?
Yes this is because of the DB, I do remember someone else doing some changes to the views that are used for the kids to remove content. I
 can have a look at editing some of the SQL for you.

What are the 3 sources you want for the kids?

Thank you for this!  Though I imagine if you get a nice way to work this out you will also make a lot of others happy.  The sources I want specifically for the children are below.  I have them in folders based on UK age ratings for films and just a kids TV folder.

        <default pathversion="1"></default>
        <source>
            <name>movies-12</name>
            <path pathversion="1">nfs://10.17.42.50/srv/nfs/movies-12/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>movies-pg</name>
            <path pathversion="1">nfs://10.17.42.50/srv/nfs/movies-pg/</path>
            <allowsharing>true</allowsharing>
        </source>
        <source>
            <name>tv-kids</name>
            <path pathversion="1">nfs://10.17.42.50/srv/nfs/tv-kids/</path>
            <allowsharing>true</allowsharing>
@Supay Sorry for the delay been away with work.
Give this a try

Kodi V119 - 05 Custom Views.sql

This is set to create the views for U02, you can change easy on line 12
at the bottom of each view I have added 3 where strings
  WHERE
    `path`.`strPath` LIKE '%movies-12%' OR
    `path`.`strPath` LIKE '%movies-pg%' OR
    `path`.`strPath` LIKE '%tv-kids%';
more can be added and even removed as long as there is a OR at the end of each line except the last line that needs a ;
the % is wildcards.

Let me know if you get the desired results.

If the string are found anywhere in the path it will show
Reply
Thank you for continually updating this thread for each new Kodi version. For the longest time I've been running 16.1 with the multi-user MySQL setup (needed to keep a SPMC installation synchronized). But now thanks to new hardware, I'll be moving to 19.1. I've already run your scripts to create and modify the 119 schema databases.

For the next step, do I simply run an instance of Kodi 19.1 and let it migrate my existing library on its own? Or do I have to export the library in Kodi 16.1, and then import it using 19.1? Or do I have to run each major version migration one at a time, 16 -> 17 -> 18 -> 19?
Reply
(2021-05-26, 02:48)runningnaked Wrote: Thank you for continually updating this thread for each new Kodi version. For the longest time I've been running 16.1 with the multi-user MySQL setup (needed to keep a SPMC installation synchronized). But now thanks to new hardware, I'll be moving to 19.1. I've already run your scripts to create and modify the 119 schema databases.

For the next step, do I simply run an instance of Kodi 19.1 and let it migrate my existing library on its own? Or do I have to export the library in Kodi 16.1, and then import it using 19.1? Or do I have to run each major version migration one at a time, 16 -> 17 -> 18 -> 19?

If you setup the 119 like you said then rebuild your library.
from your old setup for each user use Step 5 "texturecache.py" to export then import once the new library is ready.
there are lots of little changes from each db version and its easier to do it this way then to write a script todo it sorry.

on a plus side your library information is all updated Smile

hope this helps
Reply
@BigMong Thank you so much! That definitely helps a lot -- it's very clear and I'll take a stab at it this week. Smile
Reply
  •   
  • 1
  • 20
  • 21
  • 22
  • 23
  • 24(current)



Logout Mark Read Team Forum Stats Members Help
[MYSQL] HOW-TO: 5 User XBMC5
This forum uses Lukasz Tkacz MyBB addons.