[MYSQL] HOW-TO: 5 User XBMC
#11
(2014-06-06, 08:12)schumi2004 Wrote: Looks good but for Linux/OpenELEC users it will fail I guess, Windows only script?

Its a .bat file that sets up various folders and files.

I do plan to eventually support linux and mac.

Also, i have your music database ready for testing.

Code:
RENAME TABLE `a46`.`song` to `a46`.`globalsong`;

ALTER TABLE `a46`.`globalsong` CHANGE iTimesPlayed iTimesPlayed1 INT;
ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed2 INT(11) AFTER iTimesPlayed1;
ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed3 INT(11) AFTER iTimesPlayed2;
ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed4 INT(11) AFTER iTimesPlayed3;
ALTER TABLE `a46`.`globalsong` ADD iTimesPlayed5 INT(11) AFTER iTimesPlayed4;
ALTER TABLE `a46`.`globalsong` CHANGE lastPlayed lastPlayed1 VARCHAR(20);
ALTER TABLE `a46`.`globalsong` ADD lastPlayed2 VARCHAR(20) AFTER lastPlayed1;
ALTER TABLE `a46`.`globalsong` ADD lastPlayed3 VARCHAR(20) AFTER lastPlayed2;
ALTER TABLE `a46`.`globalsong` ADD lastPlayed4 VARCHAR(20) AFTER lastPlayed3;
ALTER TABLE `a46`.`globalsong` ADD lastPlayed5 VARCHAR(20) AFTER lastPlayed4;

CREATE VIEW `a46`.`song`
AS SELECT
   `a46`.`globalsong`.`idSong` AS `idSong`,
   `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
   `a46`.`globalsong`.`idPath` AS `idPath`,
   `a46`.`globalsong`.`strArtists` AS `strArtists`,
   `a46`.`globalsong`.`strGenres` AS `strGenres`,
   `a46`.`globalsong`.`strTitle` AS `strTitle`,
   `a46`.`globalsong`.`iTrack` AS `iTrack`,
   `a46`.`globalsong`.`iDuration` AS `iDuration`,
   `a46`.`globalsong`.`iYear` AS `iYear`,
   `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `a46`.`globalsong`.`strFileName` AS `strFileName`,
   `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `a46`.`globalsong`.`iTimesPlayed1` AS `iTimesPlayed`,
   `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
   `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
   `a46`.`globalsong`.`idThumb` AS `idThumb`,
   `a46`.`globalsong`.`lastplayed1` AS `lastplayed`,
   `a46`.`globalsong`.`comment` AS `comment`,
   `a46`.`globalsong`.`rating` AS `rating`
FROM `a46`.`globalsong`;

CREATE DATABASE b46;
CREATE VIEW `b46`.`album` AS SELECT * FROM `a46`.`album`;
CREATE VIEW `b46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
CREATE VIEW `b46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
CREATE VIEW `b46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
CREATE VIEW `b46`.`art` AS SELECT * FROM `a46`.`art`;
CREATE VIEW `b46`.`artist` AS SELECT * FROM `a46`.`artist`;
CREATE VIEW `b46`.`content` AS SELECT * FROM `a46`.`content`;
CREATE VIEW `b46`.`discography` AS SELECT * FROM `a46`.`discography`;
CREATE VIEW `b46`.`genre` AS SELECT * FROM `a46`.`genre`;
CREATE VIEW `b46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
CREATE VIEW `b46`.`path` AS SELECT * FROM `a46`.`path`;
CREATE VIEW `b46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
CREATE VIEW `b46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
CREATE VIEW `b46`.`version` AS SELECT * FROM `a46`.`version`;

CREATE VIEW `b46`.`song`
AS SELECT
   `a46`.`globalsong`.`idSong` AS `idSong`,
   `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
   `a46`.`globalsong`.`idPath` AS `idPath`,
   `a46`.`globalsong`.`strArtists` AS `strArtists`,
   `a46`.`globalsong`.`strGenres` AS `strGenres`,
   `a46`.`globalsong`.`strTitle` AS `strTitle`,
   `a46`.`globalsong`.`iTrack` AS `iTrack`,
   `a46`.`globalsong`.`iDuration` AS `iDuration`,
   `a46`.`globalsong`.`iYear` AS `iYear`,
   `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `a46`.`globalsong`.`strFileName` AS `strFileName`,
   `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `a46`.`globalsong`.`iTimesPlayed2` AS `iTimesPlayed`,
   `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
   `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
   `a46`.`globalsong`.`idThumb` AS `idThumb`,
   `a46`.`globalsong`.`lastplayed2` AS `lastplayed`,
   `a46`.`globalsong`.`comment` AS `comment`,
   `a46`.`globalsong`.`rating` AS `rating`
FROM `a46`.`globalsong`;

CREATE VIEW `b46`.`albumartistview`
AS SELECT
   `album_artist`.`idAlbum` AS `idAlbum`,
   `album_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `album_artist`.`boolFeatured` AS `boolFeatured`,
   `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `album_artist`.`iOrder` AS `iOrder`
FROM (`b46`.`album_artist` join `b46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `b46`.`albumview`
AS SELECT
   `album`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
   `album`.`strArtists` AS `strArtists`,
   `album`.`strGenres` AS `strGenres`,
   `album`.`iYear` AS `iYear`,
   `album`.`strMoods` AS `strMoods`,
   `album`.`strStyles` AS `strStyles`,
   `album`.`strThemes` AS `strThemes`,
   `album`.`strReview` AS `strReview`,
   `album`.`strLabel` AS `strLabel`,
   `album`.`strType` AS `strType`,
   `album`.`strImage` AS `strImage`,
   `album`.`iRating` AS `iRating`,
   `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
FROM (`b46`.`album` left join `b46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;

CREATE VIEW `b46`.`artistview`
AS SELECT
   `artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `artist`.`strBorn` AS `strBorn`,
   `artist`.`strFormed` AS `strFormed`,
   `artist`.`strGenres` AS `strGenres`,
   `artist`.`strMoods` AS `strMoods`,
   `artist`.`strStyles` AS `strStyles`,
   `artist`.`strInstruments` AS `strInstruments`,
   `artist`.`strBiography` AS `strBiography`,
   `artist`.`strDied` AS `strDied`,
   `artist`.`strDisbanded` AS `strDisbanded`,
   `artist`.`strYearsActive` AS `strYearsActive`,
   `artist`.`strImage` AS `strImage`,
   `artist`.`strFanart` AS `strFanart`
FROM `b46`.`artist`;

CREATE VIEW `b46`.`songartistview`
AS SELECT
   `song_artist`.`idSong` AS `idSong`,
   `song_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `song_artist`.`boolFeatured` AS `boolFeatured`,
   `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `song_artist`.`iOrder` AS `iOrder`
FROM (`b46`.`song_artist` join `b46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `b46`.`songview`
AS SELECT
   `song`.`idSong` AS `idSong`,
   `song`.`strArtists` AS `strArtists`,
   `song`.`strGenres` AS `strGenres`,
   `song`.`strTitle` AS `strTitle`,
   `song`.`iTrack` AS `iTrack`,
   `song`.`iDuration` AS `iDuration`,
   `song`.`iYear` AS `iYear`,
   `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `song`.`strFileName` AS `strFileName`,
   `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `song`.`iTimesPlayed` AS `iTimesPlayed`,
   `song`.`iStartOffset` AS `iStartOffset`,
   `song`.`iEndOffset` AS `iEndOffset`,
   `song`.`lastplayed` AS `lastplayed`,
   `song`.`rating` AS `rating`,
   `song`.`comment` AS `comment`,
   `song`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `path`.`strPath` AS `strPath`,
   `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
   `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
   `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
   `album`.`bCompilation` AS `bCompilation`,
   `album`.`strArtists` AS `strAlbumArtists`
FROM (((`b46`.`song` join `b46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `b46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `b46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));

CREATE DATABASE c46;
CREATE VIEW `c46`.`album` AS SELECT * FROM `a46`.`album`;
CREATE VIEW `c46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
CREATE VIEW `c46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
CREATE VIEW `c46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
CREATE VIEW `c46`.`art` AS SELECT * FROM `a46`.`art`;
CREATE VIEW `c46`.`artist` AS SELECT * FROM `a46`.`artist`;
CREATE VIEW `c46`.`content` AS SELECT * FROM `a46`.`content`;
CREATE VIEW `c46`.`discography` AS SELECT * FROM `a46`.`discography`;
CREATE VIEW `c46`.`genre` AS SELECT * FROM `a46`.`genre`;
CREATE VIEW `c46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
CREATE VIEW `c46`.`path` AS SELECT * FROM `a46`.`path`;
CREATE VIEW `c46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
CREATE VIEW `c46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
CREATE VIEW `c46`.`version` AS SELECT * FROM `a46`.`version`;

CREATE VIEW `c46`.`song`
AS SELECT
   `a46`.`globalsong`.`idSong` AS `idSong`,
   `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
   `a46`.`globalsong`.`idPath` AS `idPath`,
   `a46`.`globalsong`.`strArtists` AS `strArtists`,
   `a46`.`globalsong`.`strGenres` AS `strGenres`,
   `a46`.`globalsong`.`strTitle` AS `strTitle`,
   `a46`.`globalsong`.`iTrack` AS `iTrack`,
   `a46`.`globalsong`.`iDuration` AS `iDuration`,
   `a46`.`globalsong`.`iYear` AS `iYear`,
   `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `a46`.`globalsong`.`strFileName` AS `strFileName`,
   `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `a46`.`globalsong`.`iTimesPlayed3` AS `iTimesPlayed`,
   `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
   `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
   `a46`.`globalsong`.`idThumb` AS `idThumb`,
   `a46`.`globalsong`.`lastplayed3` AS `lastplayed`,
   `a46`.`globalsong`.`comment` AS `comment`,
   `a46`.`globalsong`.`rating` AS `rating`
FROM `a46`.`globalsong`;

CREATE VIEW `c46`.`albumartistview`
AS SELECT
   `album_artist`.`idAlbum` AS `idAlbum`,
   `album_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `album_artist`.`boolFeatured` AS `boolFeatured`,
   `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `album_artist`.`iOrder` AS `iOrder`
FROM (`c46`.`album_artist` join `c46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `c46`.`albumview`
AS SELECT
   `album`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
   `album`.`strArtists` AS `strArtists`,
   `album`.`strGenres` AS `strGenres`,
   `album`.`iYear` AS `iYear`,
   `album`.`strMoods` AS `strMoods`,
   `album`.`strStyles` AS `strStyles`,
   `album`.`strThemes` AS `strThemes`,
   `album`.`strReview` AS `strReview`,
   `album`.`strLabel` AS `strLabel`,
   `album`.`strType` AS `strType`,
   `album`.`strImage` AS `strImage`,
   `album`.`iRating` AS `iRating`,
   `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
FROM (`c46`.`album` left join `c46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;

CREATE VIEW `c46`.`artistview`
AS SELECT
   `artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `artist`.`strBorn` AS `strBorn`,
   `artist`.`strFormed` AS `strFormed`,
   `artist`.`strGenres` AS `strGenres`,
   `artist`.`strMoods` AS `strMoods`,
   `artist`.`strStyles` AS `strStyles`,
   `artist`.`strInstruments` AS `strInstruments`,
   `artist`.`strBiography` AS `strBiography`,
   `artist`.`strDied` AS `strDied`,
   `artist`.`strDisbanded` AS `strDisbanded`,
   `artist`.`strYearsActive` AS `strYearsActive`,
   `artist`.`strImage` AS `strImage`,
   `artist`.`strFanart` AS `strFanart`
FROM `c46`.`artist`;

CREATE VIEW `c46`.`songartistview`
AS SELECT
   `song_artist`.`idSong` AS `idSong`,
   `song_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `song_artist`.`boolFeatured` AS `boolFeatured`,
   `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `song_artist`.`iOrder` AS `iOrder`
FROM (`c46`.`song_artist` join `c46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `c46`.`songview`
AS SELECT
   `song`.`idSong` AS `idSong`,
   `song`.`strArtists` AS `strArtists`,
   `song`.`strGenres` AS `strGenres`,
   `song`.`strTitle` AS `strTitle`,
   `song`.`iTrack` AS `iTrack`,
   `song`.`iDuration` AS `iDuration`,
   `song`.`iYear` AS `iYear`,
   `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `song`.`strFileName` AS `strFileName`,
   `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `song`.`iTimesPlayed` AS `iTimesPlayed`,
   `song`.`iStartOffset` AS `iStartOffset`,
   `song`.`iEndOffset` AS `iEndOffset`,
   `song`.`lastplayed` AS `lastplayed`,
   `song`.`rating` AS `rating`,
   `song`.`comment` AS `comment`,
   `song`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `path`.`strPath` AS `strPath`,
   `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
   `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
   `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
   `album`.`bCompilation` AS `bCompilation`,
   `album`.`strArtists` AS `strAlbumArtists`
FROM (((`c46`.`song` join `c46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `c46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `c46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));

CREATE DATABASE d46;
CREATE VIEW `d46`.`album` AS SELECT * FROM `a46`.`album`;
CREATE VIEW `d46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
CREATE VIEW `d46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
CREATE VIEW `d46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
CREATE VIEW `d46`.`art` AS SELECT * FROM `a46`.`art`;
CREATE VIEW `d46`.`artist` AS SELECT * FROM `a46`.`artist`;
CREATE VIEW `d46`.`content` AS SELECT * FROM `a46`.`content`;
CREATE VIEW `d46`.`discography` AS SELECT * FROM `a46`.`discography`;
CREATE VIEW `d46`.`genre` AS SELECT * FROM `a46`.`genre`;
CREATE VIEW `d46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
CREATE VIEW `d46`.`path` AS SELECT * FROM `a46`.`path`;
CREATE VIEW `d46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
CREATE VIEW `d46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
CREATE VIEW `d46`.`version` AS SELECT * FROM `a46`.`version`;

CREATE VIEW `d46`.`song`
AS SELECT
   `a46`.`globalsong`.`idSong` AS `idSong`,
   `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
   `a46`.`globalsong`.`idPath` AS `idPath`,
   `a46`.`globalsong`.`strArtists` AS `strArtists`,
   `a46`.`globalsong`.`strGenres` AS `strGenres`,
   `a46`.`globalsong`.`strTitle` AS `strTitle`,
   `a46`.`globalsong`.`iTrack` AS `iTrack`,
   `a46`.`globalsong`.`iDuration` AS `iDuration`,
   `a46`.`globalsong`.`iYear` AS `iYear`,
   `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `a46`.`globalsong`.`strFileName` AS `strFileName`,
   `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `a46`.`globalsong`.`iTimesPlayed4` AS `iTimesPlayed`,
   `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
   `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
   `a46`.`globalsong`.`idThumb` AS `idThumb`,
   `a46`.`globalsong`.`lastplayed4` AS `lastplayed`,
   `a46`.`globalsong`.`comment` AS `comment`,
   `a46`.`globalsong`.`rating` AS `rating`
FROM `a46`.`globalsong`;

CREATE VIEW `d46`.`albumartistview`
AS SELECT
   `album_artist`.`idAlbum` AS `idAlbum`,
   `album_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `album_artist`.`boolFeatured` AS `boolFeatured`,
   `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `album_artist`.`iOrder` AS `iOrder`
FROM (`d46`.`album_artist` join `d46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `d46`.`albumview`
AS SELECT
   `album`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
   `album`.`strArtists` AS `strArtists`,
   `album`.`strGenres` AS `strGenres`,
   `album`.`iYear` AS `iYear`,
   `album`.`strMoods` AS `strMoods`,
   `album`.`strStyles` AS `strStyles`,
   `album`.`strThemes` AS `strThemes`,
   `album`.`strReview` AS `strReview`,
   `album`.`strLabel` AS `strLabel`,
   `album`.`strType` AS `strType`,
   `album`.`strImage` AS `strImage`,
   `album`.`iRating` AS `iRating`,
   `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
FROM (`d46`.`album` left join `d46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;

CREATE VIEW `d46`.`artistview`
AS SELECT
   `artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `artist`.`strBorn` AS `strBorn`,
   `artist`.`strFormed` AS `strFormed`,
   `artist`.`strGenres` AS `strGenres`,
   `artist`.`strMoods` AS `strMoods`,
   `artist`.`strStyles` AS `strStyles`,
   `artist`.`strInstruments` AS `strInstruments`,
   `artist`.`strBiography` AS `strBiography`,
   `artist`.`strDied` AS `strDied`,
   `artist`.`strDisbanded` AS `strDisbanded`,
   `artist`.`strYearsActive` AS `strYearsActive`,
   `artist`.`strImage` AS `strImage`,
   `artist`.`strFanart` AS `strFanart`
FROM `d46`.`artist`;

CREATE VIEW `d46`.`songartistview`
AS SELECT
   `song_artist`.`idSong` AS `idSong`,
   `song_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `song_artist`.`boolFeatured` AS `boolFeatured`,
   `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `song_artist`.`iOrder` AS `iOrder`
FROM (`d46`.`song_artist` join `d46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `d46`.`songview`
AS SELECT
   `song`.`idSong` AS `idSong`,
   `song`.`strArtists` AS `strArtists`,
   `song`.`strGenres` AS `strGenres`,
   `song`.`strTitle` AS `strTitle`,
   `song`.`iTrack` AS `iTrack`,
   `song`.`iDuration` AS `iDuration`,
   `song`.`iYear` AS `iYear`,
   `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `song`.`strFileName` AS `strFileName`,
   `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `song`.`iTimesPlayed` AS `iTimesPlayed`,
   `song`.`iStartOffset` AS `iStartOffset`,
   `song`.`iEndOffset` AS `iEndOffset`,
   `song`.`lastplayed` AS `lastplayed`,
   `song`.`rating` AS `rating`,
   `song`.`comment` AS `comment`,
   `song`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `path`.`strPath` AS `strPath`,
   `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
   `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
   `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
   `album`.`bCompilation` AS `bCompilation`,
   `album`.`strArtists` AS `strAlbumArtists`
FROM (((`d46`.`song` join `d46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `d46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `d46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));

CREATE DATABASE e46;
CREATE VIEW `e46`.`album` AS SELECT * FROM `a46`.`album`;
CREATE VIEW `e46`.`album_artist` AS SELECT * FROM `a46`.`album_artist`;
CREATE VIEW `e46`.`album_genre` AS SELECT * FROM `a46`.`album_genre`;
CREATE VIEW `e46`.`albuminfosong` AS SELECT * FROM `a46`.`albuminfosong`;
CREATE VIEW `e46`.`art` AS SELECT * FROM `a46`.`art`;
CREATE VIEW `e46`.`artist` AS SELECT * FROM `a46`.`artist`;
CREATE VIEW `e46`.`content` AS SELECT * FROM `a46`.`content`;
CREATE VIEW `e46`.`discography` AS SELECT * FROM `a46`.`discography`;
CREATE VIEW `e46`.`genre` AS SELECT * FROM `a46`.`genre`;
CREATE VIEW `e46`.`karaokedata` AS SELECT * FROM `a46`.`karaokedata`;
CREATE VIEW `e46`.`path` AS SELECT * FROM `a46`.`path`;
CREATE VIEW `e46`.`song_artist` AS SELECT * FROM `a46`.`song_artist`;
CREATE VIEW `e46`.`song_genre` AS SELECT * FROM `a46`.`song_genre`;
CREATE VIEW `e46`.`version` AS SELECT * FROM `a46`.`version`;

CREATE VIEW `e46`.`song`
AS SELECT
   `a46`.`globalsong`.`idSong` AS `idSong`,
   `a46`.`globalsong`.`idAlbum` AS `idAlbum`,
   `a46`.`globalsong`.`idPath` AS `idPath`,
   `a46`.`globalsong`.`strArtists` AS `strArtists`,
   `a46`.`globalsong`.`strGenres` AS `strGenres`,
   `a46`.`globalsong`.`strTitle` AS `strTitle`,
   `a46`.`globalsong`.`iTrack` AS `iTrack`,
   `a46`.`globalsong`.`iDuration` AS `iDuration`,
   `a46`.`globalsong`.`iYear` AS `iYear`,
   `a46`.`globalsong`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `a46`.`globalsong`.`strFileName` AS `strFileName`,
   `a46`.`globalsong`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `a46`.`globalsong`.`iTimesPlayed5` AS `iTimesPlayed`,
   `a46`.`globalsong`.`iStartOffset` AS `iStartOffset`,
   `a46`.`globalsong`.`iEndOffset` AS `iEndOffset`,
   `a46`.`globalsong`.`idThumb` AS `idThumb`,
   `a46`.`globalsong`.`lastplayed5` AS `lastplayed`,
   `a46`.`globalsong`.`comment` AS `comment`,
   `a46`.`globalsong`.`rating` AS `rating`
FROM `a46`.`globalsong`;

CREATE VIEW `e46`.`albumartistview`
AS SELECT
   `album_artist`.`idAlbum` AS `idAlbum`,
   `album_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `album_artist`.`boolFeatured` AS `boolFeatured`,
   `album_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `album_artist`.`iOrder` AS `iOrder`
FROM (`e46`.`album_artist` join `e46`.`artist` on((`album_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `e46`.`albumview`
AS SELECT
   `album`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `album`.`strMusicBrainzAlbumID` AS `strMusicBrainzAlbumID`,
   `album`.`strArtists` AS `strArtists`,
   `album`.`strGenres` AS `strGenres`,
   `album`.`iYear` AS `iYear`,
   `album`.`strMoods` AS `strMoods`,
   `album`.`strStyles` AS `strStyles`,
   `album`.`strThemes` AS `strThemes`,
   `album`.`strReview` AS `strReview`,
   `album`.`strLabel` AS `strLabel`,
   `album`.`strType` AS `strType`,
   `album`.`strImage` AS `strImage`,
   `album`.`iRating` AS `iRating`,
   `album`.`bCompilation` AS `bCompilation`,min(`song`.`iTimesPlayed`) AS `iTimesPlayed`
FROM (`e46`.`album` left join `e46`.`song` on((`album`.`idAlbum` = `song`.`idAlbum`))) group by `album`.`idAlbum`;

CREATE VIEW `e46`.`artistview`
AS SELECT
   `artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `artist`.`strBorn` AS `strBorn`,
   `artist`.`strFormed` AS `strFormed`,
   `artist`.`strGenres` AS `strGenres`,
   `artist`.`strMoods` AS `strMoods`,
   `artist`.`strStyles` AS `strStyles`,
   `artist`.`strInstruments` AS `strInstruments`,
   `artist`.`strBiography` AS `strBiography`,
   `artist`.`strDied` AS `strDied`,
   `artist`.`strDisbanded` AS `strDisbanded`,
   `artist`.`strYearsActive` AS `strYearsActive`,
   `artist`.`strImage` AS `strImage`,
   `artist`.`strFanart` AS `strFanart`
FROM `e46`.`artist`;

CREATE VIEW `e46`.`songartistview`
AS SELECT
   `song_artist`.`idSong` AS `idSong`,
   `song_artist`.`idArtist` AS `idArtist`,
   `artist`.`strArtist` AS `strArtist`,
   `artist`.`strMusicBrainzArtistID` AS `strMusicBrainzArtistID`,
   `song_artist`.`boolFeatured` AS `boolFeatured`,
   `song_artist`.`strJoinPhrase` AS `strJoinPhrase`,
   `song_artist`.`iOrder` AS `iOrder`
FROM (`e46`.`song_artist` join `e46`.`artist` on((`song_artist`.`idArtist` = `artist`.`idArtist`)));

CREATE VIEW `e46`.`songview`
AS SELECT
   `song`.`idSong` AS `idSong`,
   `song`.`strArtists` AS `strArtists`,
   `song`.`strGenres` AS `strGenres`,
   `song`.`strTitle` AS `strTitle`,
   `song`.`iTrack` AS `iTrack`,
   `song`.`iDuration` AS `iDuration`,
   `song`.`iYear` AS `iYear`,
   `song`.`dwFileNameCRC` AS `dwFileNameCRC`,
   `song`.`strFileName` AS `strFileName`,
   `song`.`strMusicBrainzTrackID` AS `strMusicBrainzTrackID`,
   `song`.`iTimesPlayed` AS `iTimesPlayed`,
   `song`.`iStartOffset` AS `iStartOffset`,
   `song`.`iEndOffset` AS `iEndOffset`,
   `song`.`lastplayed` AS `lastplayed`,
   `song`.`rating` AS `rating`,
   `song`.`comment` AS `comment`,
   `song`.`idAlbum` AS `idAlbum`,
   `album`.`strAlbum` AS `strAlbum`,
   `path`.`strPath` AS `strPath`,
   `karaokedata`.`iKaraNumber` AS `iKaraNumber`,
   `karaokedata`.`iKaraDelay` AS `iKaraDelay`,
   `karaokedata`.`strKaraEncoding` AS `strKaraEncoding`,
   `album`.`bCompilation` AS `bCompilation`,
   `album`.`strArtists` AS `strAlbumArtists`
FROM (((`e46`.`song` join `e46`.`album` on((`song`.`idAlbum` = `album`.`idAlbum`))) join `e46`.`path` on((`song`.`idPath` = `path`.`idPath`))) left join `e46`.`karaokedata` on((`song`.`idSong` = `karaokedata`.`idSong`)));

Its the same instructions as video. Get XBMC to create a database called 'a46' with advancedsettings.xml

Code:
<advancedsettings>

<videodatabase>
<type>mysql</type>
<host>10.0.0.8</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>a</name>
</videodatabase>

<musicdatabase>
<type>mysql</type>
<host>10.0.0.8</host>
<port>3306</port>
<user>xbmc</user>
<pass>xbmc</pass>
<name>a</name>
</musicdatabase>

</advancedsettings>

Then run the query.

It renames the 'song' table to 'globalsong' and adds a place for b, c, d and e to store iTimesPlayed and lastplayed columns. Then links everything up.
Check Out My 5 User XBMC Tutorial
If i have helped you please REP+
Reply


Messages In This Thread
[MYSQL] HOW-TO: 5 User XBMC - by N4TH4N - 2014-06-02, 19:31
RE: [MYSQL] HOW-TO: Create and Link Multiple Databases - by N4TH4N - 2014-06-06, 08:23
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 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


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