[MYSQL] HOW-TO: 5 User XBMC
Exclamation 
Update: Database Version 119 [aka Matrix]

Database Version 107 [aka Krypton]
So I was finally ready to start the Kodi 17 roll out.
here is a WIP setup for multi users (Still testing everything out, but looks good)
Only looked at getting Movies and TV Shows working, this includes U01 does all the imports to the DB and keeps it tidy, rest of the users just use this data, ratings are split out if used.
Will look at fixing if needed for Musice Videos in the coming weeks as I will prob use that in my new setup.

I have space in the Database for 8 users (That's what I need), easy to remove some or add more.
A change I have made is using U01, U02, etc as I had a duplicate name, and adding a number didn't look right.

Table Names:
  • Kodi_U01_Video_107
  • Kodi_U02_Video_107
  • etc.
My Kodi Database Username is now KODI_17 Find and replace to change this.
I am moving to a new username each Kodi Version.

Getting the Database ready:
PHP Code:
--------------------
--- 
PREP GLOBALS ---
--------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

-- GLOBAL 
FILES --
RENAME TABLE `Kodi_U01_Video_107`.`filesTO `Kodi_U01_Video_107`.`global_files`;
-- 
USER 01 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesCHANGE playCount playCount_U01 INT(11);
ALTER TABLE `Kodi_U01_Video_107`.`global_filesCHANGE lastPlayed lastPlayed_U01 TEXT;
-- 
USER 02 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD playCount_U02 INT(11AFTER lastPlayed_U01;
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD lastPlayed_U02 TEXT AFTER playCount_U02;
-- 
USER 03 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD playCount_U03 INT(11AFTER lastPlayed_U02;
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD lastPlayed_U03 TEXT AFTER playCount_U03;
-- 
USER 04 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD playCount_U04 INT(11AFTER lastPlayed_U03;
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD lastPlayed_U04 TEXT AFTER playCount_U04;
-- 
USER 05 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD playCount_U05 INT(11AFTER lastPlayed_U04;
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD lastPlayed_U05 TEXT AFTER playCount_U05;
-- 
USER 06 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD playCount_U06 INT(11AFTER lastPlayed_U05;
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD lastPlayed_U06 TEXT AFTER playCount_U06;
-- 
USER 07 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD playCount_U07 INT(11AFTER lastPlayed_U06;
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD lastPlayed_U07 TEXT AFTER playCount_U07;
-- 
USER 08 --
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD playCount_U08 INT(11AFTER lastPlayed_U07;
ALTER TABLE `Kodi_U01_Video_107`.`global_filesADD lastPlayed_U08 TEXT AFTER playCount_U08;
-- 
FILES VIEW FOR U01 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U01_Video_107`.`files`
AS 
SELECT
`Kodi_U01_Video_107`.`global_files`.`idFile` AS `idFile`,
`
Kodi_U01_Video_107`.`global_files`.`idPath` AS `idPath`,
`
Kodi_U01_Video_107`.`global_files`.`strFilename` AS `strFilename`,
`
Kodi_U01_Video_107`.`global_files`.`playCount_U01` AS `playCount`,
`
Kodi_U01_Video_107`.`global_files`.`lastPlayed_U01` AS `lastPlayed`,
`
Kodi_U01_Video_107`.`global_files`.`dateAdded` AS `dateAdded`
FROM `Kodi_U01_Video_107`.`global_files`;

-- GLOBAL 
EPISODE --
RENAME TABLE `Kodi_U01_Video_107`.`episodeTO `Kodi_U01_Video_107`.`global_episode`;
-- 
USER 01 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeCHANGE userrating userrating_U01 INT(11);
-- 
USER 02 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeADD userrating_U02 INT(11AFTER userrating_U01;
-- 
USER 03 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeADD userrating_U03 INT(11AFTER userrating_U02;
-- 
USER 04 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeADD userrating_U04 INT(11AFTER userrating_U03;
-- 
USER 05 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeADD userrating_U05 INT(11AFTER userrating_U04;
-- 
USER 06 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeADD userrating_U06 INT(11AFTER userrating_U05;
-- 
USER 07 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeADD userrating_U07 INT(11AFTER userrating_U06;
-- 
USER 08 --
ALTER TABLE `Kodi_U01_Video_107`.`global_episodeADD userrating_U08 INT(11AFTER userrating_U07;
-- 
EPISODE VIEW FOR U01 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U01_Video_107`.`episode` AS SELECT
`Kodi_U01_Video_107`.`global_episode`.`idEpisode` AS `idEpisode`,
`
Kodi_U01_Video_107`.`global_episode`.`idFile` AS `idFile`,
`
Kodi_U01_Video_107`.`global_episode`.`c00` AS `c00`,
`
Kodi_U01_Video_107`.`global_episode`.`c01` AS `c01`,
`
Kodi_U01_Video_107`.`global_episode`.`c02` AS `c02`,
`
Kodi_U01_Video_107`.`global_episode`.`c03` AS `c03`,
`
Kodi_U01_Video_107`.`global_episode`.`c04` AS `c04`,
`
Kodi_U01_Video_107`.`global_episode`.`c05` AS `c05`,
`
Kodi_U01_Video_107`.`global_episode`.`c06` AS `c06`,
`
Kodi_U01_Video_107`.`global_episode`.`c07` AS `c07`,
`
Kodi_U01_Video_107`.`global_episode`.`c08` AS `c08`,
`
Kodi_U01_Video_107`.`global_episode`.`c09` AS `c09`,
`
Kodi_U01_Video_107`.`global_episode`.`c10` AS `c10`,
`
Kodi_U01_Video_107`.`global_episode`.`c11` AS `c11`,
`
Kodi_U01_Video_107`.`global_episode`.`c12` AS `c12`,
`
Kodi_U01_Video_107`.`global_episode`.`c13` AS `c13`,
`
Kodi_U01_Video_107`.`global_episode`.`c14` AS `c14`,
`
Kodi_U01_Video_107`.`global_episode`.`c15` AS `c15`,
`
Kodi_U01_Video_107`.`global_episode`.`c16` AS `c16`,
`
Kodi_U01_Video_107`.`global_episode`.`c17` AS `c17`,
`
Kodi_U01_Video_107`.`global_episode`.`c18` AS `c18`,
`
Kodi_U01_Video_107`.`global_episode`.`c19` AS `c19`,
`
Kodi_U01_Video_107`.`global_episode`.`c20` AS `c20`,
`
Kodi_U01_Video_107`.`global_episode`.`c21` AS `c21`,
`
Kodi_U01_Video_107`.`global_episode`.`c22` AS `c22`,
`
Kodi_U01_Video_107`.`global_episode`.`c23` AS `c23`,
`
Kodi_U01_Video_107`.`global_episode`.`idShow` AS `idShow`,
`
Kodi_U01_Video_107`.`global_episode`.`userrating_U01` AS `userrating`,
`
Kodi_U01_Video_107`.`global_episode`.`idSeason` AS `idSeason`
FROM `Kodi_U01_Video_107`.`global_episode`;

-- GLOBAL 
SEASONS --
RENAME TABLE `Kodi_U01_Video_107`.`seasonsTO `Kodi_U01_Video_107`.`global_seasons`;
-- 
USER 01 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsCHANGE userrating userrating_U01 INT(11);
-- 
USER 02 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsADD userrating_U02 INT(11AFTER userrating_U01;
-- 
USER 03 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsADD userrating_U03 INT(11AFTER userrating_U02;
-- 
USER 04 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsADD userrating_U04 INT(11AFTER userrating_U03;
-- 
USER 05 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsADD userrating_U05 INT(11AFTER userrating_U04;
-- 
USER 06 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsADD userrating_U06 INT(11AFTER userrating_U05;
-- 
USER 07 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsADD userrating_U07 INT(11AFTER userrating_U06;
-- 
USER 08 --
ALTER TABLE `Kodi_U01_Video_107`.`global_seasonsADD userrating_U08 INT(11AFTER userrating_U07;
-- 
SEASONS VIEW FOR U01 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U01_Video_107`.`seasons` AS SELECT
`Kodi_U01_Video_107`.`global_seasons`.`idSeason` AS `idSeason`,
`
Kodi_U01_Video_107`.`global_seasons`.`idShow` AS `idShow`,
`
Kodi_U01_Video_107`.`global_seasons`.`season` AS `season`,
`
Kodi_U01_Video_107`.`global_seasons`.`name` AS `name`,
`
Kodi_U01_Video_107`.`global_seasons`.`userrating_U01` AS `userrating`
FROM `Kodi_U01_Video_107`.`global_seasons`;

-- GLOBAL 
TVSHOWS --
RENAME TABLE `Kodi_U01_Video_107`.`tvshowTO `Kodi_U01_Video_107`.`global_tvshow`;
-- 
USER 01 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowCHANGE userrating userrating_U01 INT(11);
-- 
USER 02 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowADD userrating_U02 INT(11AFTER userrating_U01;
-- 
USER 03 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowADD userrating_U03 INT(11AFTER userrating_U02;
-- 
USER 04 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowADD userrating_U04 INT(11AFTER userrating_U03;
-- 
USER 05 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowADD userrating_U05 INT(11AFTER userrating_U04;
-- 
USER 06 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowADD userrating_U06 INT(11AFTER userrating_U05;
-- 
USER 07 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowADD userrating_U07 INT(11AFTER userrating_U06;
-- 
USER 08 --
ALTER TABLE `Kodi_U01_Video_107`.`global_tvshowADD userrating_U08 INT(11AFTER userrating_U07;
-- 
TVSHOW VIEW FOR U01 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U01_Video_107`.`tvshow` AS SELECT
`Kodi_U01_Video_107`.`global_tvshow`.`idShow` AS `idShow`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c00` AS `c00`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c01` AS `c01`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c02` AS `c02`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c03` AS `c03`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c04` AS `c04`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c05` AS `c05`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c06` AS `c06`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c07` AS `c07`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c08` AS `c08`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c09` AS `c09`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c10` AS `c10`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c11` AS `c11`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c12` AS `c12`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c13` AS `c13`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c14` AS `c14`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c15` AS `c15`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c16` AS `c16`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c17` AS `c17`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c18` AS `c18`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c19` AS `c19`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c20` AS `c20`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c21` AS `c21`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c22` AS `c22`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c23` AS `c23`,
`
Kodi_U01_Video_107`.`global_tvshow`.`userrating_U01` AS `userrating`,
`
Kodi_U01_Video_107`.`global_tvshow`.`duration` AS `duration`
FROM `Kodi_U01_Video_107`.`global_tvshow`;

-- GLOBAL 
MOVIE --
RENAME TABLE `Kodi_U01_Video_107`.`movieTO `Kodi_U01_Video_107`.`global_movie`;
-- 
USER 01 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieCHANGE userrating userrating_U01 INT(11);
-- 
USER 02 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieADD userrating_U02 INT(11AFTER userrating_U01;
-- 
USER 03 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieADD userrating_U03 INT(11AFTER userrating_U02;
-- 
USER 04 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieADD userrating_U04 INT(11AFTER userrating_U03;
-- 
USER 05 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieADD userrating_U05 INT(11AFTER userrating_U04;
-- 
USER 06 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieADD userrating_U06 INT(11AFTER userrating_U05;
-- 
USER 07 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieADD userrating_U07 INT(11AFTER userrating_U06;
-- 
USER 08 --
ALTER TABLE `Kodi_U01_Video_107`.`global_movieADD userrating_U08 INT(11AFTER userrating_U07;
-- 
MOVIE VIEW FOR U01 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U01_Video_107`.`movie` AS SELECT
`Kodi_U01_Video_107`.`global_movie`.`idMovie` AS `idMovie`,
`
Kodi_U01_Video_107`.`global_movie`.`idFile` AS `idFile`,
`
Kodi_U01_Video_107`.`global_movie`.`c00` AS `c00`,
`
Kodi_U01_Video_107`.`global_movie`.`c01` AS `c01`,
`
Kodi_U01_Video_107`.`global_movie`.`c02` AS `c02`,
`
Kodi_U01_Video_107`.`global_movie`.`c03` AS `c03`,
`
Kodi_U01_Video_107`.`global_movie`.`c04` AS `c04`,
`
Kodi_U01_Video_107`.`global_movie`.`c05` AS `c05`,
`
Kodi_U01_Video_107`.`global_movie`.`c06` AS `c06`,
`
Kodi_U01_Video_107`.`global_movie`.`c07` AS `c07`,
`
Kodi_U01_Video_107`.`global_movie`.`c08` AS `c08`,
`
Kodi_U01_Video_107`.`global_movie`.`c09` AS `c09`,
`
Kodi_U01_Video_107`.`global_movie`.`c10` AS `c10`,
`
Kodi_U01_Video_107`.`global_movie`.`c11` AS `c11`,
`
Kodi_U01_Video_107`.`global_movie`.`c12` AS `c12`,
`
Kodi_U01_Video_107`.`global_movie`.`c13` AS `c13`,
`
Kodi_U01_Video_107`.`global_movie`.`c14` AS `c14`,
`
Kodi_U01_Video_107`.`global_movie`.`c15` AS `c15`,
`
Kodi_U01_Video_107`.`global_movie`.`c16` AS `c16`,
`
Kodi_U01_Video_107`.`global_movie`.`c17` AS `c17`,
`
Kodi_U01_Video_107`.`global_movie`.`c18` AS `c18`,
`
Kodi_U01_Video_107`.`global_movie`.`c19` AS `c19`,
`
Kodi_U01_Video_107`.`global_movie`.`c20` AS `c20`,
`
Kodi_U01_Video_107`.`global_movie`.`c21` AS `c21`,
`
Kodi_U01_Video_107`.`global_movie`.`c22` AS `c22`,
`
Kodi_U01_Video_107`.`global_movie`.`c23` AS `c23`,
`
Kodi_U01_Video_107`.`global_movie`.`idSet` AS `idSet`,
`
Kodi_U01_Video_107`.`global_movie`.`userrating_U01` AS `userrating`,
`
Kodi_U01_Video_107`.`global_movie`.`premiered` AS `premiered`
FROM `Kodi_U01_Video_107`.`global_movie`;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */

User Template:
Find and Replace "_U02" with "_U03" etc for each user
PHP Code:
---------------
--- 
USER 02 ---
---------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

CREATE DATABASE IF NOT EXISTS Kodi_U02_Video_107 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

-- 
FILES VIEW FOR U02 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`files` AS SELECT
`Kodi_U01_Video_107`.`global_files`.`idFile` AS `idFile`,
`
Kodi_U01_Video_107`.`global_files`.`idPath` AS `idPath`,
`
Kodi_U01_Video_107`.`global_files`.`strFilename` AS `strFilename`,
`
Kodi_U01_Video_107`.`global_files`.`playCount_U02` AS `playCount`,
`
Kodi_U01_Video_107`.`global_files`.`lastPlayed_U02` AS `lastPlayed`,
`
Kodi_U01_Video_107`.`global_files`.`dateAdded` AS `dateAdded`
FROM `Kodi_U01_Video_107`.`global_files`;

-- 
BOOKMARKS FOR U02 --
CREATE TABLE `Kodi_U02_Video_107`.`bookmark` (
`
idBookmarkINT(11NOT NULL,
`
idFileINT(11) DEFAULT NULL,
`
timeInSecondsDOUBLE DEFAULT NULL,
`
totalTimeInSecondsDOUBLE DEFAULT NULL,
`
thumbNailImagetext,
`
playertext,
`
playerStatetext,
`
typeINT(11) DEFAULT NULL
ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `Kodi_U02_Video_107`.`bookmarkADD PRIMARY KEY (`idBookmark`), ADD KEY `ix_bookmark` (`idFile`,`type`);
ALTER TABLE `Kodi_U02_Video_107`.`bookmarkMODIFY `idBookmarkINT(11NOT NULL AUTO_INCREMENT;

-- 
EPISODE VIEW FOR U02 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`episode` AS SELECT
`Kodi_U01_Video_107`.`global_episode`.`idEpisode` AS `idEpisode`,
`
Kodi_U01_Video_107`.`global_episode`.`idFile` AS `idFile`,
`
Kodi_U01_Video_107`.`global_episode`.`c00` AS `c00`,
`
Kodi_U01_Video_107`.`global_episode`.`c01` AS `c01`,
`
Kodi_U01_Video_107`.`global_episode`.`c02` AS `c02`,
`
Kodi_U01_Video_107`.`global_episode`.`c03` AS `c03`,
`
Kodi_U01_Video_107`.`global_episode`.`c04` AS `c04`,
`
Kodi_U01_Video_107`.`global_episode`.`c05` AS `c05`,
`
Kodi_U01_Video_107`.`global_episode`.`c06` AS `c06`,
`
Kodi_U01_Video_107`.`global_episode`.`c07` AS `c07`,
`
Kodi_U01_Video_107`.`global_episode`.`c08` AS `c08`,
`
Kodi_U01_Video_107`.`global_episode`.`c09` AS `c09`,
`
Kodi_U01_Video_107`.`global_episode`.`c10` AS `c10`,
`
Kodi_U01_Video_107`.`global_episode`.`c11` AS `c11`,
`
Kodi_U01_Video_107`.`global_episode`.`c12` AS `c12`,
`
Kodi_U01_Video_107`.`global_episode`.`c13` AS `c13`,
`
Kodi_U01_Video_107`.`global_episode`.`c14` AS `c14`,
`
Kodi_U01_Video_107`.`global_episode`.`c15` AS `c15`,
`
Kodi_U01_Video_107`.`global_episode`.`c16` AS `c16`,
`
Kodi_U01_Video_107`.`global_episode`.`c17` AS `c17`,
`
Kodi_U01_Video_107`.`global_episode`.`c18` AS `c18`,
`
Kodi_U01_Video_107`.`global_episode`.`c19` AS `c19`,
`
Kodi_U01_Video_107`.`global_episode`.`c20` AS `c20`,
`
Kodi_U01_Video_107`.`global_episode`.`c21` AS `c21`,
`
Kodi_U01_Video_107`.`global_episode`.`c22` AS `c22`,
`
Kodi_U01_Video_107`.`global_episode`.`c23` AS `c23`,
`
Kodi_U01_Video_107`.`global_episode`.`idShow` AS `idShow`,
`
Kodi_U01_Video_107`.`global_episode`.`userrating_U02` AS `userrating`,
`
Kodi_U01_Video_107`.`global_episode`.`idSeason` AS `idSeason`
FROM `Kodi_U01_Video_107`.`global_episode`;

-- 
SEASONS VIEW FOR U02 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`seasons` AS SELECT
`Kodi_U01_Video_107`.`global_seasons`.`idSeason` AS `idSeason`,
`
Kodi_U01_Video_107`.`global_seasons`.`idShow` AS `idShow`,
`
Kodi_U01_Video_107`.`global_seasons`.`season` AS `season`,
`
Kodi_U01_Video_107`.`global_seasons`.`name` AS `name`,
`
Kodi_U01_Video_107`.`global_seasons`.`userrating_U02` AS `userrating`
FROM `Kodi_U01_Video_107`.`global_seasons`;

-- 
TVSHOW VIEW FOR U02 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`tvshow` AS SELECT
`Kodi_U01_Video_107`.`global_tvshow`.`idShow` AS `idShow`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c00` AS `c00`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c01` AS `c01`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c02` AS `c02`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c03` AS `c03`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c04` AS `c04`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c05` AS `c05`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c06` AS `c06`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c07` AS `c07`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c08` AS `c08`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c09` AS `c09`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c10` AS `c10`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c11` AS `c11`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c12` AS `c12`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c13` AS `c13`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c14` AS `c14`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c15` AS `c15`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c16` AS `c16`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c17` AS `c17`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c18` AS `c18`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c19` AS `c19`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c20` AS `c20`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c21` AS `c21`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c22` AS `c22`,
`
Kodi_U01_Video_107`.`global_tvshow`.`c23` AS `c23`,
`
Kodi_U01_Video_107`.`global_tvshow`.`userrating_U02` AS `userrating`,
`
Kodi_U01_Video_107`.`global_tvshow`.`duration` AS `duration`
FROM `Kodi_U01_Video_107`.`global_tvshow`;

-- 
MOVIE VIEWS FOR U02 --
CREATE ALGORITHM=MERGE DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`movie` AS SELECT
`Kodi_U01_Video_107`.`global_movie`.`idMovie` AS `idMovie`,
`
Kodi_U01_Video_107`.`global_movie`.`idFile` AS `idFile`,
`
Kodi_U01_Video_107`.`global_movie`.`c00` AS `c00`,
`
Kodi_U01_Video_107`.`global_movie`.`c01` AS `c01`,
`
Kodi_U01_Video_107`.`global_movie`.`c02` AS `c02`,
`
Kodi_U01_Video_107`.`global_movie`.`c03` AS `c03`,
`
Kodi_U01_Video_107`.`global_movie`.`c04` AS `c04`,
`
Kodi_U01_Video_107`.`global_movie`.`c05` AS `c05`,
`
Kodi_U01_Video_107`.`global_movie`.`c06` AS `c06`,
`
Kodi_U01_Video_107`.`global_movie`.`c07` AS `c07`,
`
Kodi_U01_Video_107`.`global_movie`.`c08` AS `c08`,
`
Kodi_U01_Video_107`.`global_movie`.`c09` AS `c09`,
`
Kodi_U01_Video_107`.`global_movie`.`c10` AS `c10`,
`
Kodi_U01_Video_107`.`global_movie`.`c11` AS `c11`,
`
Kodi_U01_Video_107`.`global_movie`.`c12` AS `c12`,
`
Kodi_U01_Video_107`.`global_movie`.`c13` AS `c13`,
`
Kodi_U01_Video_107`.`global_movie`.`c14` AS `c14`,
`
Kodi_U01_Video_107`.`global_movie`.`c15` AS `c15`,
`
Kodi_U01_Video_107`.`global_movie`.`c16` AS `c16`,
`
Kodi_U01_Video_107`.`global_movie`.`c17` AS `c17`,
`
Kodi_U01_Video_107`.`global_movie`.`c18` AS `c18`,
`
Kodi_U01_Video_107`.`global_movie`.`c19` AS `c19`,
`
Kodi_U01_Video_107`.`global_movie`.`c20` AS `c20`,
`
Kodi_U01_Video_107`.`global_movie`.`c21` AS `c21`,
`
Kodi_U01_Video_107`.`global_movie`.`c22` AS `c22`,
`
Kodi_U01_Video_107`.`global_movie`.`c23` AS `c23`,
`
Kodi_U01_Video_107`.`global_movie`.`idSet` AS `idSet`,
`
Kodi_U01_Video_107`.`global_movie`.`userrating_U02` AS `userrating`,
`
Kodi_U01_Video_107`.`global_movie`.`premiered` AS `premiered`
FROM `Kodi_U01_Video_107`.`global_movie`;

-- 
CREATE REST OF THE VIEWS --
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`actor` AS SELECT FROM `Kodi_U01_Video_107`.`actor`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`actor_link` AS SELECT FROM `Kodi_U01_Video_107`.`actor_link`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`art` AS SELECT FROM `Kodi_U01_Video_107`.`art`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`country` AS SELECT FROM `Kodi_U01_Video_107`.`country`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`country_link` AS SELECT FROM `Kodi_U01_Video_107`.`country_link`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`director_link` AS SELECT FROM `Kodi_U01_Video_107`.`director_link`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`genre` AS SELECT FROM `Kodi_U01_Video_107`.`genre`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`genre_link` AS SELECT FROM `Kodi_U01_Video_107`.`genre_link`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`movielinktvshow` AS SELECT FROM `Kodi_U01_Video_107`.`movielinktvshow`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`musicvideo` AS SELECT FROM `Kodi_U01_Video_107`.`musicvideo`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`path` AS SELECT FROM `Kodi_U01_Video_107`.`path`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`rating` AS SELECT FROM `Kodi_U01_Video_107`.`rating`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`sets` AS SELECT FROM `Kodi_U01_Video_107`.`sets`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`settings` AS SELECT FROM `Kodi_U01_Video_107`.`settings`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`stacktimes` AS SELECT FROM `Kodi_U01_Video_107`.`stacktimes`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`streamdetails` AS SELECT FROM `Kodi_U01_Video_107`.`streamdetails`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`studio` AS SELECT FROM `Kodi_U01_Video_107`.`studio`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`studio_link` AS SELECT FROM `Kodi_U01_Video_107`.`studio_link`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`tag` AS SELECT FROM `Kodi_U01_Video_107`.`tag`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`tag_link` AS SELECT FROM `Kodi_U01_Video_107`.`tag_link`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`tvshowlinkpath` AS SELECT FROM `Kodi_U01_Video_107`.`tvshowlinkpath`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`uniqueid` AS SELECT FROM `Kodi_U01_Video_107`.`uniqueid`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`version` AS SELECT FROM `Kodi_U01_Video_107`.`version`;
CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`writer_link` AS SELECT FROM `Kodi_U01_Video_107`.`writer_link`;

CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`episode_view` AS SELECT
`episode`.`idEpisode` AS `idEpisode`,
`
episode`.`idFile` AS `idFile`,
`
episode`.`c00` AS `c00`,
`
episode`.`c01` AS `c01`,
`
episode`.`c02` AS `c02`,
`
episode`.`c03` AS `c03`,
`
episode`.`c04` AS `c04`,
`
episode`.`c05` AS `c05`,
`
episode`.`c06` AS `c06`,
`
episode`.`c07` AS `c07`,
`
episode`.`c08` AS `c08`,
`
episode`.`c09` AS `c09`,
`
episode`.`c10` AS `c10`,
`
episode`.`c11` AS `c11`,
`
episode`.`c12` AS `c12`,
`
episode`.`c13` AS `c13`,
`
episode`.`c14` AS `c14`,
`
episode`.`c15` AS `c15`,
`
episode`.`c16` AS `c16`,
`
episode`.`c17` AS `c17`,
`
episode`.`c18` AS `c18`,
`
episode`.`c19` AS `c19`,
`
episode`.`c20` AS `c20`,
`
episode`.`c21` AS `c21`,
`
episode`.`c22` AS `c22`,
`
episode`.`c23` AS `c23`,
`
episode`.`idShow` AS `idShow`,
`
episode`.`userrating` AS `userrating`,
`
episode`.`idSeason` AS `idSeason`,
`
files`.`strFilename` AS `strFileName`,
`
path`.`strPath` AS `strPath`,
`
files`.`playCount` AS `playCount`,
`
files`.`lastPlayed` AS `lastPlayed`,
`
files`.`dateAdded` AS `dateAdded`,
`
tvshow`.`c00` AS `strTitle`,
`
tvshow`.`c08` AS `genre`,
`
tvshow`.`c14` AS `studio`,
`
tvshow`.`c05` AS `premiered`,
`
tvshow`.`c13` AS `mpaa`,
`
bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
`
bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
`
rating`.`rating` AS `rating`,
`
rating`.`votes` AS `votes`,
`
rating`.`rating_type` AS `rating_type`,
`
uniqueid`.`value` AS `uniqueid_value`,
`
uniqueid`.`type` AS `uniqueid_type`
FROM (((((((`Kodi_U02_Video_107`.`episodeJOIN `Kodi_U02_Video_107`.`filesON((`files`.`idFile` = `episode`.`idFile`)))
JOIN `Kodi_U02_Video_107`.`tvshowON((`tvshow`.`idShow` = `episode`.`idShow`)))
JOIN `Kodi_U02_Video_107`.`seasonsON((`seasons`.`idSeason` = `episode`.`idSeason`)))
JOIN `Kodi_U02_Video_107`.`pathON((`files`.`idPath` = `path`.`idPath`)))
LEFT JOIN `Kodi_U02_Video_107`.`bookmarkON(((`bookmark`.`idFile` = `episode`.`idFile`) AND (`bookmark`.`type` = 1))))
LEFT JOIN `Kodi_U02_Video_107`.`ratingON((`rating`.`rating_id` = `episode`.`c03`)))
LEFT JOIN `Kodi_U02_Video_107`.`uniqueidON((`uniqueid`.`uniqueid_id` = `episode`.`c20`)));

CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`tvshowcounts` AS SELECT
`tvshow`.`idShow` AS `idShow`,
MAX(`files`.`lastPlayed`) AS `lastPlayed`,
NULLIF(COUNT(`episode`.`c12`),0) AS `totalCount`,
COUNT(`files`.`playCount`) AS `watchedcount`,
NULLIF(COUNT(DISTINCT `episode`.`c12`),0) AS `totalSeasons`,
MAX(`files`.`dateAdded`) AS `dateAdded`
FROM ((`Kodi_U02_Video_107`.`tvshowLEFT JOIN `Kodi_U02_Video_107`.`episodeON((`episode`.`idShow` = `tvshow`.`idShow`)))
LEFT JOIN `Kodi_U02_Video_107`.`filesON((`files`.`idFile` = `episode`.`idFile`)))
GROUP BY `tvshow`.`idShow`;

CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`tvshow_view` AS SELECT
`tvshow`.`idShow` AS `idShow`,
`
tvshow`.`c00` AS `c00`,
`
tvshow`.`c01` AS `c01`,
`
tvshow`.`c02` AS `c02`,
`
tvshow`.`c03` AS `c03`,
`
tvshow`.`c04` AS `c04`,
`
tvshow`.`c05` AS `c05`,
`
tvshow`.`c06` AS `c06`,
`
tvshow`.`c07` AS `c07`,
`
tvshow`.`c08` AS `c08`,
`
tvshow`.`c09` AS `c09`,
`
tvshow`.`c10` AS `c10`,
`
tvshow`.`c11` AS `c11`,
`
tvshow`.`c12` AS `c12`,
`
tvshow`.`c13` AS `c13`,
`
tvshow`.`c14` AS `c14`,
`
tvshow`.`c15` AS `c15`,
`
tvshow`.`c16` AS `c16`,
`
tvshow`.`c17` AS `c17`,
`
tvshow`.`c18` AS `c18`,
`
tvshow`.`c19` AS `c19`,
`
tvshow`.`c20` AS `c20`,
`
tvshow`.`c21` AS `c21`,
`
tvshow`.`c22` AS `c22`,
`
tvshow`.`c23` AS `c23`,
`
tvshow`.`userrating` AS `userrating`,
`
tvshow`.`duration` AS `duration`,
`
path`.`idParentPath` AS `idParentPath`,
`
path`.`strPath` AS `strPath`,
`
tvshowcounts`.`dateAdded` AS `dateAdded`,
`
tvshowcounts`.`lastPlayed` AS `lastPlayed`,
`
tvshowcounts`.`totalCount` AS `totalCount`,
`
tvshowcounts`.`watchedcount` AS `watchedcount`,
`
tvshowcounts`.`totalSeasons` AS `totalSeasons`,
`
rating`.`rating` AS `rating`,
`
rating`.`votes` AS `votes`,
`
rating`.`rating_type` AS `rating_type`,
`
uniqueid`.`value` AS `uniqueid_value`,
`
uniqueid`.`type` AS `uniqueid_type`
FROM (((((`Kodi_U02_Video_107`.`tvshowLEFT JOIN `Kodi_U02_Video_107`.`tvshowlinkpathON((`tvshowlinkpath`.`idShow` = `tvshow`.`idShow`)))
LEFT JOIN `Kodi_U02_Video_107`.`pathON((`path`.`idPath` = `tvshowlinkpath`.`idPath`)))
JOIN `Kodi_U02_Video_107`.`tvshowcountsON((`tvshow`.`idShow` = `tvshowcounts`.`idShow`)))
LEFT JOIN `Kodi_U02_Video_107`.`ratingON((`rating`.`rating_id` = `tvshow`.`c04`)))
LEFT JOIN `Kodi_U02_Video_107`.`uniqueidON((`uniqueid`.`uniqueid_id` = `tvshow`.`c12`)))
GROUP BY `Kodi_U02_Video_107`.`tvshow`.`idShow`;

CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`season_view` AS SELECT
`seasons`.`idSeason` AS `idSeason`,
`
seasons`.`idShow` AS `idShow`,
`
seasons`.`season` AS `season`,
`
seasons`.`name` AS `name`,
`
seasons`.`userrating` AS `userrating`,
`
tvshow_view`.`strPath` AS `strPath`,
`
tvshow_view`.`c00` AS `showTitle`,
`
tvshow_view`.`c01` AS `plot`,
`
tvshow_view`.`c05` AS `premiered`,
`
tvshow_view`.`c08` AS `genre`,
`
tvshow_view`.`c14` AS `studio`,
`
tvshow_view`.`c13` AS `mpaa`,
COUNT(DISTINCT `episode`.`idEpisode`) AS `episodes`,
COUNT(`files`.`playCount`) AS `playCount`,
MIN(`episode`.`c05`) AS `aired`
FROM (((`Kodi_U02_Video_107`.`seasonsJOIN `Kodi_U02_Video_107`.`tvshow_viewON((`tvshow_view`.`idShow` = `seasons`.`idShow`)))
JOIN `Kodi_U02_Video_107`.`episodeON(((`episode`.`idShow` = `seasons`.`idShow`) AND (`episode`.`c12` = `seasons`.`season`))))
JOIN `Kodi_U02_Video_107`.`filesON((`files`.`idFile` = `episode`.`idFile`)))
GROUP BY `seasons`.`idSeason`;

CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`movie_view` AS SELECT
`movie`.`idMovie` AS `idMovie`,
`
movie`.`idFile` AS `idFile`,
`
movie`.`c00` AS `c00`,
`
movie`.`c01` AS `c01`,
`
movie`.`c02` AS `c02`,
`
movie`.`c03` AS `c03`,
`
movie`.`c04` AS `c04`,
`
movie`.`c05` AS `c05`,
`
movie`.`c06` AS `c06`,
`
movie`.`c07` AS `c07`,
`
movie`.`c08` AS `c08`,
`
movie`.`c09` AS `c09`,
`
movie`.`c10` AS `c10`,
`
movie`.`c11` AS `c11`,
`
movie`.`c12` AS `c12`,
`
movie`.`c13` AS `c13`,
`
movie`.`c14` AS `c14`,
`
movie`.`c15` AS `c15`,
`
movie`.`c16` AS `c16`,
`
movie`.`c17` AS `c17`,
`
movie`.`c18` AS `c18`,
`
movie`.`c19` AS `c19`,
`
movie`.`c20` AS `c20`,
`
movie`.`c21` AS `c21`,
`
movie`.`c22` AS `c22`,
`
movie`.`c23` AS `c23`,
`
movie`.`idSet` AS `idSet`,
`
movie`.`userrating` AS `userrating`,
`
movie`.`premiered` AS `premiered`,
`
sets`.`strSet` AS `strSet`,
`
sets`.`strOverview` AS `strSetOverview`,
`
files`.`strFilename` AS `strFileName`,
`
path`.`strPath` AS `strPath`,
`
files`.`playCount` AS `playCount`,
`
files`.`lastPlayed` AS `lastPlayed`,
`
files`.`dateAdded` AS `dateAdded`,
`
bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
`
bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`,
`
rating`.`rating` AS `rating`,
`
rating`.`votes` AS `votes`,
`
rating`.`rating_type` AS `rating_type`,
`
uniqueid`.`value` AS `uniqueid_value`,
`
uniqueid`.`type` AS `uniqueid_type`
FROM ((((((`Kodi_U02_Video_107`.`movieLEFT JOIN `Kodi_U02_Video_107`.`setsON((`sets`.`idSet` = `movie`.`idSet`)))
JOIN `Kodi_U02_Video_107`.`filesON((`files`.`idFile` = `movie`.`idFile`)))
JOIN `Kodi_U02_Video_107`.`pathON((`path`.`idPath` = `files`.`idPath`)))
LEFT JOIN `Kodi_U02_Video_107`.`bookmarkON(((`bookmark`.`idFile` = `movie`.`idFile`) AND (`bookmark`.`type` = 1))))
LEFT JOIN `Kodi_U02_Video_107`.`ratingON((`rating`.`rating_id` = `movie`.`c05`)))
LEFT JOIN `Kodi_U02_Video_107`.`uniqueidON((`uniqueid`.`uniqueid_id` = `movie`.`c09`)));

CREATE ALGORITHM=UNDEFINED DEFINER=`KODI_17`@`%SQL SECURITY DEFINER VIEW `Kodi_U02_Video_107`.`musicvideo_view` AS SELECT
`musicvideo`.`idMVideo` AS `idMVideo`,
`
musicvideo`.`idFile` AS `idFile`,
`
musicvideo`.`c00` AS `c00`,
`
musicvideo`.`c01` AS `c01`,
`
musicvideo`.`c02` AS `c02`,
`
musicvideo`.`c03` AS `c03`,
`
musicvideo`.`c04` AS `c04`,
`
musicvideo`.`c05` AS `c05`,
`
musicvideo`.`c06` AS `c06`,
`
musicvideo`.`c07` AS `c07`,
`
musicvideo`.`c08` AS `c08`,
`
musicvideo`.`c09` AS `c09`,
`
musicvideo`.`c10` AS `c10`,
`
musicvideo`.`c11` AS `c11`,
`
musicvideo`.`c12` AS `c12`,
`
musicvideo`.`c13` AS `c13`,
`
musicvideo`.`c14` AS `c14`,
`
musicvideo`.`c15` AS `c15`,
`
musicvideo`.`c16` AS `c16`,
`
musicvideo`.`c17` AS `c17`,
`
musicvideo`.`c18` AS `c18`,
`
musicvideo`.`c19` AS `c19`,
`
musicvideo`.`c20` AS `c20`,
`
musicvideo`.`c21` AS `c21`,
`
musicvideo`.`c22` AS `c22`,
`
musicvideo`.`c23` AS `c23`,
`
musicvideo`.`userrating` AS `userrating`,
`
musicvideo`.`premiered` AS `premiered`,
`
files`.`strFilename` AS `strFileName`,
`
path`.`strPath` AS `strPath`,
`
files`.`playCount` AS `playCount`,
`
files`.`lastPlayed` AS `lastPlayed`,
`
files`.`dateAdded` AS `dateAdded`,
`
bookmark`.`timeInSeconds` AS `resumeTimeInSeconds`,
`
bookmark`.`totalTimeInSeconds` AS `totalTimeInSeconds`
FROM (((`Kodi_U02_Video_107`.`musicvideoJOIN `Kodi_U02_Video_107`.`filesON((`files`.`idFile` = `musicvideo`.`idFile`)))
JOIN `Kodi_U02_Video_107`.`pathON((`path`.`idPath` = `files`.`idPath`)))
LEFT JOIN `Kodi_U02_Video_107`.`bookmarkON(((`bookmark`.`idFile` = `musicvideo`.`idFile`) AND (`bookmark`.`type` = 1))));

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */

Update the Delete File Trigger so when you remove items it will clean up the Bookmarks for each user.
Add more lines in like the "Kodi_U02_Video_107" for each Database you have.
PHP Code:
----------------
--- 
TRIGGERS ---
----------------
-- 
TRIGGER FIX FOR MULT USERS --
DROP TRIGGER IF EXISTS `Kodi_U01_Video_107`.`delete_file`;
DELIMITER $$
CREATE DEFINER=`KODI_17`@`%TRIGGER `Kodi_U01_Video_107`.`delete_fileAFTER DELETE
ON 
`Kodi_U01_Video_107`.`global_files`
FOR 
EACH ROW
BEGIN
DELETE FROM 
`Kodi_U01_Video_107`.bookmark WHERE idfile old.idfile;
DELETE FROM `Kodi_U02_Video_107`.bookmark WHERE idfile old.idfile;
DELETE FROM settings WHERE idfile old.idfile;
DELETE FROM stacktimes WHERE idfile old.idfile;
DELETE FROM streamdetails WHERE idfile old.idfile;
END$$
DELIMITER 

Update:
Fixed a small error in the user(s) it was point to the U01 Ratings not there own.
Reply


Messages In This Thread
[MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-02, 19:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by kikinjo - 2014-06-08, 11:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 14:41
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-07, 19:55
RE: [MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-06-07, 20:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-07, 21:02
RE: [MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-06-09, 17:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 15:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 22:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-08, 22:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-09, 00:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-10, 01:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-09, 02:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-09, 02:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by queonda - 2014-06-09, 21:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by queonda - 2014-06-10, 01:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-10, 02:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-11, 07:44
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-06-15, 02:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-15, 04:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-15, 09:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-15, 11:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-17, 05:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-19, 17:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Martijn - 2014-06-19, 17:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-19, 18:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by Martijn - 2014-06-19, 18:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-20, 15:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-07-04, 14:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by narvatu - 2014-07-04, 22:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-07-26, 17:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by rmilyard - 2014-07-26, 16:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-08-25, 04:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-09-14, 13:21
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2014-10-02, 02:17
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2014-10-04, 00:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-10-06, 15:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by Speed... - 2014-12-25, 17:56
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-10-09, 13:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by fnc1 - 2014-10-18, 04:55
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-12-02, 01:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2014-12-04, 02:03
[MYSQL] HOW-TO: 5 User XBMC - by Steini - 2014-12-05, 10:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by raphibb - 2014-12-06, 05:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by judocama - 2014-12-15, 14:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by Blend - 2015-01-07, 12:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by dual-o - 2015-01-07, 15:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by Blend - 2015-01-07, 18:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-11, 10:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by Blend - 2015-01-15, 22:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by Dersch - 2015-02-05, 12:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-15, 22:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Speed... - 2015-01-17, 02:13
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-17, 11:42
RE: [MYSQL] HOW-TO: 5 User XBMC - by Speed... - 2015-01-18, 18:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-01-24, 01:18
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-18, 19:02
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-01-20, 19:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-23, 18:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-23, 20:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-24, 12:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-05-23, 07:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by gardar - 2015-07-20, 02:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-24, 19:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-25, 08:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by Keithh - 2015-01-25, 10:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-25, 16:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-01-25, 22:48
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-01-26, 00:21
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-04-12, 18:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-04-12, 19:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by Nogler - 2015-05-23, 08:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-05-24, 05:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by nebulous - 2015-06-10, 15:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by papirri2 - 2015-06-14, 09:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by nickr - 2015-06-14, 09:55
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-06-17, 05:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by lody2mk - 2015-06-17, 19:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by freddy12 - 2015-06-23, 17:15
RE: [MYSQL] HOW-TO: 5 User XBMC - by Xiled78 - 2015-07-03, 04:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-07-27, 10:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-07-30, 09:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-07-30, 11:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-02, 07:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-02, 16:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-02, 03:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-09-02, 14:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-08-13, 01:50
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-13, 04:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-08-13, 10:36
Re: [MYSQL] HOW-TO: 5 User XBMC - by nickr - 2015-08-13, 11:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-08-13, 12:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-08-13, 13:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-08-13, 13:57
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-08-13, 14:01
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-08-18, 20:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-22, 08:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-08-22, 08:10
RE: [MYSQL] HOW-TO: 5 User XBMC - by quim_3000 - 2015-08-25, 08:41
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2015-08-25, 23:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-03, 00:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-09, 00:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-09-10, 05:01
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-09-10, 10:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2015-09-12, 05:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-09-12, 09:22
RE: [MYSQL] HOW-TO: 5 User XBMC - by mert0267 - 2015-09-18, 01:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-03, 16:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by Bohemi - 2015-10-04, 13:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-04, 17:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by bym007 - 2015-10-08, 13:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-10-08, 13:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-08, 15:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by pcgirl - 2015-10-08, 16:34
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-13, 22:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-22, 04:36
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 07:09
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-22, 11:26
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 13:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-22, 18:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by Connex - 2015-10-22, 16:24
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 18:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by jmh2002 - 2015-10-22, 19:07
[MYSQL] HOW-TO: 5 User XBMC - by Deihmos - 2015-10-22, 20:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-27, 17:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2015-10-28, 01:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-01-25, 20:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-01-23, 03:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-01-23, 05:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-01-25, 20:13
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-02-03, 14:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-02-07, 00:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-02-24, 10:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by birt - 2016-02-26, 10:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 06:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2016-04-27, 21:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2017-04-10, 03:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by D0bby - 2016-05-17, 18:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 07:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 13:49
RE: [MYSQL] HOW-TO: 5 User XBMC - by apeg - 2016-03-14, 21:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-03-14, 23:05
RE: [MYSQL] HOW-TO: 5 User XBMC - by gimalugi - 2016-03-15, 23:31
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2016-04-27, 22:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-04-28, 11:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by npbhdk - 2016-05-04, 18:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-05-05, 16:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by npbhdk - 2016-05-06, 01:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by RonM - 2016-05-05, 08:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by D0bby - 2016-05-17, 21:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by Sushi7 - 2016-06-27, 22:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-06-28, 10:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by Sushi7 - 2016-06-28, 13:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by mcfang - 2016-11-17, 15:16
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2016-06-28, 14:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by gaxander - 2016-07-28, 11:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by ascona - 2016-08-01, 15:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by matika - 2016-09-07, 23:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Sushi7 - 2016-08-15, 16:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by vibe666 - 2016-08-17, 03:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by bpanonpt - 2017-01-11, 01:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by bpanonpt - 2017-01-11, 18:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by Meddie31 - 2017-01-15, 16:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by TRaSH - 2017-01-15, 17:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by Meddie31 - 2017-01-15, 17:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-03, 09:48
RE: [MYSQL] HOW-TO: 5 User XBMC - by zosky - 2019-12-13, 04:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-04, 12:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by Ruben_82 - 2017-02-06, 05:51
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-11, 11:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by birt - 2017-02-25, 00:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-02-26, 13:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by nulled - 2017-03-21, 10:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-03-21, 12:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by nulled - 2017-03-21, 15:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-03-23, 04:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by nulled - 2017-03-23, 14:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-03-24, 10:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by Smasher - 2017-04-07, 00:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by bmac88 - 2017-04-07, 03:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-04-10, 12:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2017-04-10, 20:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by Smasher - 2017-04-10, 13:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-04-11, 12:51
RE: [MYSQL] HOW-TO: 5 User XBMC - by Smasher - 2017-04-11, 13:18
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-04-12, 11:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-06-22, 13:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by Karellen - 2017-06-22, 13:17
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-06-22, 13:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2017-06-25, 21:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2017-07-13, 13:54
RE: [MYSQL] HOW-TO: 5 User XBMC - by sloth85 - 2018-06-02, 15:34
RE: [MYSQL] HOW-TO: 5 User XBMC - by djibax - 2018-07-18, 00:38
RE: [MYSQL] HOW-TO: 5 User XBMC - by greyd - 2018-07-19, 19:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by calibos - 2018-08-09, 12:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by Klojum - 2018-08-31, 16:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by nickty - 2018-11-23, 13:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by Michal_K - 2019-02-06, 20:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-02-06, 23:05
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-02-07, 07:01
RE: [MYSQL] HOW-TO: 5 User XBMC - by birt - 2019-02-13, 12:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by sloth85 - 2020-08-25, 13:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by Michal_K - 2019-02-07, 10:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2019-07-03, 00:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-07-03, 12:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2019-07-04, 22:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-07-05, 00:14
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-19, 03:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-19, 09:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-19, 16:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-20, 01:44
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-20, 02:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-20, 10:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-20, 17:37
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 02:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-21, 03:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 14:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-21, 17:29
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 20:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-21, 22:45
RE: [MYSQL] HOW-TO: 5 User XBMC - by NicCo - 2019-08-20, 17:52
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-21, 02:13
RE: [MYSQL] HOW-TO: 5 User XBMC - by NicCo - 2019-08-22, 08:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-22, 13:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by NicCo - 2019-08-22, 16:00
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-25, 06:19
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-25, 21:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-25, 22:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-27, 21:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-08-28, 05:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-08-28, 14:24
RE: [MYSQL] HOW-TO: 5 User XBMC - by sloth85 - 2019-10-12, 13:08
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-11-01, 00:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2019-09-12, 19:39
RE: [MYSQL] HOW-TO: 5 User XBMC - by ponkotsu - 2019-09-26, 19:58
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2019-09-27, 01:50
RE: [MYSQL] HOW-TO: 5 User XBMC - by Moukrea - 2019-11-19, 13:27
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2020-01-26, 08:04
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2020-05-22, 19:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2021-01-28, 00:20
RE: [MYSQL] HOW-TO: 5 User XBMC - by OtheA - 2021-01-30, 02:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-08, 19:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-09, 14:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by Knallex - 2021-04-09, 13:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-09, 14:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-10, 09:26
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-10, 11:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by Knallex - 2021-04-10, 10:41
RE: [MYSQL] HOW-TO: 5 User XBMC - by Knallex - 2021-04-10, 10:47
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-10, 12:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-13, 21:15
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-14, 10:34
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-14, 13:56
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-14, 13:59
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-04-14, 19:02
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-04-14, 23:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-05-15, 03:03
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-05-16, 16:53
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-05-17, 11:22
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-05-22, 09:32
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2021-10-03, 13:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by ponkotsu - 2021-05-26, 02:48
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2021-05-29, 10:07
RE: [MYSQL] HOW-TO: 5 User XBMC - by ponkotsu - 2021-06-01, 18:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2021-12-24, 19:33
RE: [MYSQL] HOW-TO: 5 User XBMC - by Giangi - 2022-01-02, 17:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by palym - 2022-01-14, 09:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by palym - 2022-03-03, 08:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by yusufvml - 2022-03-19, 03:40
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2022-03-19, 15:11
RE: [MYSQL] HOW-TO: 5 User XBMC - by john_es - 2022-03-13, 18:22
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2022-03-15, 03:23
RE: [MYSQL] HOW-TO: 5 User XBMC - by TakedaT - 2022-08-10, 15:46
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-08-12, 11:57
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-08-13, 04:06
RE: [MYSQL] HOW-TO: 5 User XBMC - by bart330 - 2023-01-16, 13:55
RE: [MYSQL] HOW-TO: 5 User XBMC - by BigMong - 2023-01-16, 15:35
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-02-05, 15:43
RE: [MYSQL] HOW-TO: 5 User XBMC - by jro9909 - 2024-02-13, 18:28
RE: [MYSQL] HOW-TO: 5 User XBMC - by bart330 - 2023-01-17, 00:25
RE: [MYSQL] HOW-TO: 5 User XBMC - by *MarioP* - 2023-01-23, 10:12
RE: [MYSQL] HOW-TO: 5 User XBMC - by bart330 - 2023-01-24, 00:30
RE: [MYSQL] HOW-TO: 5 User XBMC - by *MarioP* - 2023-03-15, 17:51
RE: [MYSQL] HOW-TO: 5 User XBMC - by Supay - 2023-08-13, 04:36
RE: [MYSQL] HOW-TO: 5 User XBMC - by Mairiver - 2023-10-30, 17:36
Logout Mark Read Team Forum Stats Members Help
[MYSQL] HOW-TO: 5 User XBMC5