Jump to content

MyMoviesImporter & MediaFileSyncTool

Rag3

By Rag3
in Fragen zu Plugins, AddOns & OSD-Skins

Recommended Posts

Kaloschke Apprentice

Kaloschke

Posted
Posted

So,

 

endlich zuhause. Vielen Dank für Deine Arbeit. Und los gehts:

 

- XMBC wird importiert

- bei Update Thumbnails kommt "No movies specified"

- bei Read Mediainfo.data das gleiche

- bei Updating MyMovies Database das gleiche

 

Was mach ich falsch?

 

Gruß Kaloschke

Link to comment
Rag3 Newbie

Rag3

Posted
  • Author
Posted

Welche XBMC-Version nutzt du?

werden im log die Filme angezeigt?

 

Wenn das der Fall ist, kann ich mir das nicht so recht erklären, würde dir dann mal ne Debug-Version zukommen lassen... Der halt die relevanten Schritte mal im Detail loggt... Schaffe ich aber wahrscheinlich erst am WE.

Link to comment
Kaloschke Apprentice

Kaloschke

Posted
Posted

Hi,

 

er findet was nicht:

 

Logfile created 2011-05-10 2011-05-10

2011-05-10 14:27:14 INFO Reading XBMC Database

2011-05-10 14:27:14 INFO # Opening database

2011-05-10 14:27:14 INFO # Loading movies

2011-05-10 14:27:14 INFO # # Crank: High Voltage

2011-05-10 14:27:14 INFO # # # Loading data

2011-05-10 14:27:14 WARN # # # Path not available

2011-05-10 14:27:14 WARN # # # Not adding movie to list

 

Welcher Pfad ist hier gemeint?

 

Meine Videos liegen auf einem Server, der in XMBC (V10) per SMB eingebunden wird. in der meiner MyMoviesImporter.XML steht:

 

<?xml version="1.0" encoding="utf-8" standalone="no"?>

<setting>

<xbmcPathMapping>

<xbmc>smb:</xbmc>

<target></target>

</xbmcPathMapping>

<misc>

<myMoviesDbPath>C:/ProgramData/CMUV/DVBViewer/Database/mymovies.db3</myMoviesDbPath>

<xbmcDbPath>C:/Users/Detlef/AppData/Roaming/XBMC/userdata/Database/MyVideos34.db</xbmcDbPath>

<XbmcImdbPrefix>tt</XbmcImdbPrefix>

<backdropFilePrefix>backdrop</backdropFilePrefix>

<folderpicFilePrefix>folder</folderpicFilePrefix>

<backdropFoldername>backdrops</backdropFoldername>

<trailerFileSuffix>[trailer]</trailerFileSuffix>

<maxPersonCount>15</maxPersonCount>

<addActorRole>true</addActorRole>

<maxBackdropCount>0</maxBackdropCount>

</misc>

</setting>

 

Muss das Programm in einem bestimmten Laufwerk bzw. Ordner geöffnet werden?

 

Gruß Kaloschke

Link to comment
Rag3 Newbie

Rag3

Posted
  • Author
Posted

Danke für die ausführlichen Infos... da ist mir beim Testen wohl eine Sache durch die Lappen gegangen... die xbmcPathMapping-Geschichte hat nen kleinen Fehler gehabt... Die Filme wurden bei dir nicht hinzugefügt, weil er den Pfad (aufgrund des fehlers) falsch umgesetzt hat und ihn daher nicht finden konnte...

 

Naja, hab ne neue Version hochgeladen, war ja nur was kleines :)

 

Viel Spaß.

Link to comment
Rag3 Newbie

Rag3

Posted
  • Author
Posted

XBMC nutzt meines wissens nach eine sqlite-db... Naja, wenn die Datenbankstruktur bei mysql gleich ist, wäre es eigentlich kein problem das umzusetzen... wie siehts diesbzgl. aus?

Link to comment
kicr Newbie

kicr

Posted
Posted

Standardmäßig ja, man kann aber auch einstellen, dass eine MySQL Datenbank benutzt werden soll. Ich poste dir mal den Tabellenoutput:

 

 

-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 12. Mai 2011 um 20:49
-- Server Version: 5.1.49
-- PHP-Version: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datenbank: `xbmc_video`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `actorlinkepisode`
--

CREATE TABLE IF NOT EXISTS `actorlinkepisode` (
 `idActor` int(11) DEFAULT NULL,
 `idEpisode` int(11) DEFAULT NULL,
 `strRole` text COLLATE latin1_general_ci,
 UNIQUE KEY `ix_actorlinkepisode_1` (`idActor`,`idEpisode`),
 UNIQUE KEY `ix_actorlinkepisode_2` (`idEpisode`,`idActor`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `actorlinkmovie`
--

CREATE TABLE IF NOT EXISTS `actorlinkmovie` (
 `idActor` int(11) DEFAULT NULL,
 `idMovie` int(11) DEFAULT NULL,
 `strRole` text COLLATE latin1_general_ci,
 UNIQUE KEY `ix_actorlinkmovie_1` (`idActor`,`idMovie`),
 UNIQUE KEY `ix_actorlinkmovie_2` (`idMovie`,`idActor`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `actorlinktvshow`
--

CREATE TABLE IF NOT EXISTS `actorlinktvshow` (
 `idActor` int(11) DEFAULT NULL,
 `idShow` int(11) DEFAULT NULL,
 `strRole` text COLLATE latin1_general_ci,
 UNIQUE KEY `ix_actorlinktvshow_1` (`idActor`,`idShow`),
 UNIQUE KEY `ix_actorlinktvshow_2` (`idShow`,`idActor`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `actors`
--

CREATE TABLE IF NOT EXISTS `actors` (
 `idActor` int(11) NOT NULL AUTO_INCREMENT,
 `strActor` text COLLATE latin1_general_ci,
 `strThumb` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idActor`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4735 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `artistlinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `artistlinkmusicvideo` (
 `idArtist` int(11) DEFAULT NULL,
 `idMVideo` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_artistlinkmusicvideo_1` (`idArtist`,`idMVideo`),
 UNIQUE KEY `ix_artistlinkmusicvideo_2` (`idMVideo`,`idArtist`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `bookmark`
--

CREATE TABLE IF NOT EXISTS `bookmark` (
 `idBookmark` int(11) NOT NULL AUTO_INCREMENT,
 `idFile` int(11) DEFAULT NULL,
 `timeInSeconds` double DEFAULT NULL,
 `totalTimeInSeconds` double DEFAULT NULL,
 `thumbNailImage` text COLLATE latin1_general_ci,
 `player` text COLLATE latin1_general_ci,
 `playerState` text COLLATE latin1_general_ci,
 `type` int(11) DEFAULT NULL,
 PRIMARY KEY (`idBookmark`),
 KEY `ix_bookmark` (`idFile`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `country`
--

CREATE TABLE IF NOT EXISTS `country` (
 `idCountry` int(11) NOT NULL AUTO_INCREMENT,
 `strCountry` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idCountry`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=7 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `countrylinkmovie`
--

CREATE TABLE IF NOT EXISTS `countrylinkmovie` (
 `idCountry` int(11) DEFAULT NULL,
 `idMovie` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_countrylinkmovie_1` (`idCountry`,`idMovie`),
 UNIQUE KEY `ix_countrylinkmovie_2` (`idMovie`,`idCountry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `directorlinkepisode`
--

CREATE TABLE IF NOT EXISTS `directorlinkepisode` (
 `idDirector` int(11) DEFAULT NULL,
 `idEpisode` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_directorlinkepisode_1` (`idDirector`,`idEpisode`),
 UNIQUE KEY `ix_directorlinkepisode_2` (`idEpisode`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `directorlinkmovie`
--

CREATE TABLE IF NOT EXISTS `directorlinkmovie` (
 `idDirector` int(11) DEFAULT NULL,
 `idMovie` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_directorlinkmovie_1` (`idDirector`,`idMovie`),
 UNIQUE KEY `ix_directorlinkmovie_2` (`idMovie`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `directorlinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `directorlinkmusicvideo` (
 `idDirector` int(11) DEFAULT NULL,
 `idMVideo` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_directorlinkmusicvideo_1` (`idDirector`,`idMVideo`),
 UNIQUE KEY `ix_directorlinkmusicvideo_2` (`idMVideo`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `directorlinktvshow`
--

CREATE TABLE IF NOT EXISTS `directorlinktvshow` (
 `idDirector` int(11) DEFAULT NULL,
 `idShow` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_directorlinktvshow_1` (`idDirector`,`idShow`),
 UNIQUE KEY `ix_directorlinktvshow_2` (`idShow`,`idDirector`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `episode`
--

CREATE TABLE IF NOT EXISTS `episode` (
 `idEpisode` int(11) NOT NULL AUTO_INCREMENT,
 `idFile` int(11) DEFAULT NULL,
 `c00` text COLLATE latin1_general_ci,
 `c01` text COLLATE latin1_general_ci,
 `c02` text COLLATE latin1_general_ci,
 `c03` text COLLATE latin1_general_ci,
 `c04` text COLLATE latin1_general_ci,
 `c05` text COLLATE latin1_general_ci,
 `c06` text COLLATE latin1_general_ci,
 `c07` text COLLATE latin1_general_ci,
 `c08` text COLLATE latin1_general_ci,
 `c09` text COLLATE latin1_general_ci,
 `c10` text COLLATE latin1_general_ci,
 `c11` text COLLATE latin1_general_ci,
 `c12` varchar(24) COLLATE latin1_general_ci DEFAULT NULL,
 `c13` varchar(24) COLLATE latin1_general_ci DEFAULT NULL,
 `c14` text COLLATE latin1_general_ci,
 `c15` text COLLATE latin1_general_ci,
 `c16` text COLLATE latin1_general_ci,
 `c17` varchar(24) COLLATE latin1_general_ci DEFAULT NULL,
 `c18` text COLLATE latin1_general_ci,
 `c19` text COLLATE latin1_general_ci,
 `c20` text COLLATE latin1_general_ci,
 `c21` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idEpisode`),
 UNIQUE KEY `ix_episode_file_1` (`idEpisode`,`idFile`),
 UNIQUE KEY `id_episode_file_2` (`idFile`,`idEpisode`),
 KEY `ix_episode_season_episode` (`c12`,`c13`),
 KEY `ix_episode_bookmark` (`c17`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1613 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `episodeview`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `xbmc_video`.`episodeview` AS select `xbmc_video`.`episode`.`idEpisode` AS `idEpisode`,`xbmc_video`.`episode`.`idFile` AS `idFile`,`xbmc_video`.`episode`.`c00` AS `c00`,`xbmc_video`.`episode`.`c01` AS `c01`,`xbmc_video`.`episode`.`c02` AS `c02`,`xbmc_video`.`episode`.`c03` AS `c03`,`xbmc_video`.`episode`.`c04` AS `c04`,`xbmc_video`.`episode`.`c05` AS `c05`,`xbmc_video`.`episode`.`c06` AS `c06`,`xbmc_video`.`episode`.`c07` AS `c07`,`xbmc_video`.`episode`.`c08` AS `c08`,`xbmc_video`.`episode`.`c09` AS `c09`,`xbmc_video`.`episode`.`c10` AS `c10`,`xbmc_video`.`episode`.`c11` AS `c11`,`xbmc_video`.`episode`.`c12` AS `c12`,`xbmc_video`.`episode`.`c13` AS `c13`,`xbmc_video`.`episode`.`c14` AS `c14`,`xbmc_video`.`episode`.`c15` AS `c15`,`xbmc_video`.`episode`.`c16` AS `c16`,`xbmc_video`.`episode`.`c17` AS `c17`,`xbmc_video`.`episode`.`c18` AS `c18`,`xbmc_video`.`episode`.`c19` AS `c19`,`xbmc_video`.`episode`.`c20` AS `c20`,`xbmc_video`.`episode`.`c21` AS `c21`,`xbmc_video`.`files`.`strFilename` AS `strFileName`,`xbmc_video`.`path`.`strPath` AS `strPath`,`xbmc_video`.`files`.`playCount` AS `playCount`,`xbmc_video`.`files`.`lastPlayed` AS `lastPlayed`,`xbmc_video`.`tvshow`.`c00` AS `strTitle`,`xbmc_video`.`tvshow`.`c14` AS `strStudio`,`xbmc_video`.`tvshow`.`idShow` AS `idShow`,`xbmc_video`.`tvshow`.`c05` AS `premiered`,`xbmc_video`.`tvshow`.`c13` AS `mpaa` from ((((`xbmc_video`.`episode` join `xbmc_video`.`files` on((`xbmc_video`.`files`.`idFile` = `xbmc_video`.`episode`.`idFile`))) join `xbmc_video`.`tvshowlinkepisode` on((`xbmc_video`.`episode`.`idEpisode` = `xbmc_video`.`tvshowlinkepisode`.`idEpisode`))) join `xbmc_video`.`tvshow` on((`xbmc_video`.`tvshow`.`idShow` = `xbmc_video`.`tvshowlinkepisode`.`idShow`))) join `xbmc_video`.`path` on((`xbmc_video`.`files`.`idPath` = `xbmc_video`.`path`.`idPath`)));

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `files`
--

CREATE TABLE IF NOT EXISTS `files` (
 `idFile` int(11) NOT NULL AUTO_INCREMENT,
 `idPath` int(11) DEFAULT NULL,
 `strFilename` varchar(512) COLLATE latin1_general_ci DEFAULT NULL,
 `playCount` int(11) DEFAULT NULL,
 `lastPlayed` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idFile`),
 UNIQUE KEY `ix_files` (`idPath`,`strFilename`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1808 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `genre`
--

CREATE TABLE IF NOT EXISTS `genre` (
 `idGenre` int(11) NOT NULL AUTO_INCREMENT,
 `strGenre` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idGenre`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=28 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `genrelinkmovie`
--

CREATE TABLE IF NOT EXISTS `genrelinkmovie` (
 `idGenre` int(11) DEFAULT NULL,
 `idMovie` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_genrelinkmovie_1` (`idGenre`,`idMovie`),
 UNIQUE KEY `ix_genrelinkmovie_2` (`idMovie`,`idGenre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `genrelinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `genrelinkmusicvideo` (
 `idGenre` int(11) DEFAULT NULL,
 `idMVideo` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_genrelinkmusicvideo_1` (`idGenre`,`idMVideo`),
 UNIQUE KEY `ix_genrelinkmusicvideo_2` (`idMVideo`,`idGenre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `genrelinktvshow`
--

CREATE TABLE IF NOT EXISTS `genrelinktvshow` (
 `idGenre` int(11) DEFAULT NULL,
 `idShow` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_genrelinktvshow_1` (`idGenre`,`idShow`),
 UNIQUE KEY `ix_genrelinktvshow_2` (`idShow`,`idGenre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `movie`
--

CREATE TABLE IF NOT EXISTS `movie` (
 `idMovie` int(11) NOT NULL AUTO_INCREMENT,
 `idFile` int(11) DEFAULT NULL,
 `c00` text COLLATE latin1_general_ci,
 `c01` text COLLATE latin1_general_ci,
 `c02` text COLLATE latin1_general_ci,
 `c03` text COLLATE latin1_general_ci,
 `c04` text COLLATE latin1_general_ci,
 `c05` text COLLATE latin1_general_ci,
 `c06` text COLLATE latin1_general_ci,
 `c07` text COLLATE latin1_general_ci,
 `c08` text COLLATE latin1_general_ci,
 `c09` text COLLATE latin1_general_ci,
 `c10` text COLLATE latin1_general_ci,
 `c11` text COLLATE latin1_general_ci,
 `c12` text COLLATE latin1_general_ci,
 `c13` text COLLATE latin1_general_ci,
 `c14` text COLLATE latin1_general_ci,
 `c15` text COLLATE latin1_general_ci,
 `c16` text COLLATE latin1_general_ci,
 `c17` text COLLATE latin1_general_ci,
 `c18` text COLLATE latin1_general_ci,
 `c19` text COLLATE latin1_general_ci,
 `c20` text COLLATE latin1_general_ci,
 `c21` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idMovie`),
 UNIQUE KEY `ix_movie_file_1` (`idFile`,`idMovie`),
 UNIQUE KEY `ix_movie_file_2` (`idMovie`,`idFile`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=197 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `movielinktvshow`
--

CREATE TABLE IF NOT EXISTS `movielinktvshow` (
 `idMovie` int(11) DEFAULT NULL,
 `IdShow` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_movielinktvshow_1` (`IdShow`,`idMovie`),
 UNIQUE KEY `ix_movielinktvshow_2` (`idMovie`,`IdShow`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `movieview`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `xbmc_video`.`movieview` AS select `xbmc_video`.`movie`.`idMovie` AS `idMovie`,`xbmc_video`.`movie`.`idFile` AS `idFile`,`xbmc_video`.`movie`.`c00` AS `c00`,`xbmc_video`.`movie`.`c01` AS `c01`,`xbmc_video`.`movie`.`c02` AS `c02`,`xbmc_video`.`movie`.`c03` AS `c03`,`xbmc_video`.`movie`.`c04` AS `c04`,`xbmc_video`.`movie`.`c05` AS `c05`,`xbmc_video`.`movie`.`c06` AS `c06`,`xbmc_video`.`movie`.`c07` AS `c07`,`xbmc_video`.`movie`.`c08` AS `c08`,`xbmc_video`.`movie`.`c09` AS `c09`,`xbmc_video`.`movie`.`c10` AS `c10`,`xbmc_video`.`movie`.`c11` AS `c11`,`xbmc_video`.`movie`.`c12` AS `c12`,`xbmc_video`.`movie`.`c13` AS `c13`,`xbmc_video`.`movie`.`c14` AS `c14`,`xbmc_video`.`movie`.`c15` AS `c15`,`xbmc_video`.`movie`.`c16` AS `c16`,`xbmc_video`.`movie`.`c17` AS `c17`,`xbmc_video`.`movie`.`c18` AS `c18`,`xbmc_video`.`movie`.`c19` AS `c19`,`xbmc_video`.`movie`.`c20` AS `c20`,`xbmc_video`.`movie`.`c21` AS `c21`,`xbmc_video`.`files`.`strFilename` AS `strFileName`,`xbmc_video`.`path`.`strPath` AS `strPath`,`xbmc_video`.`files`.`playCount` AS `playCount`,`xbmc_video`.`files`.`lastPlayed` AS `lastPlayed` from ((`xbmc_video`.`movie` join `xbmc_video`.`files` on((`xbmc_video`.`files`.`idFile` = `xbmc_video`.`movie`.`idFile`))) join `xbmc_video`.`path` on((`xbmc_video`.`path`.`idPath` = `xbmc_video`.`files`.`idPath`)));

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `musicvideo`
--

CREATE TABLE IF NOT EXISTS `musicvideo` (
 `idMVideo` int(11) NOT NULL AUTO_INCREMENT,
 `idFile` int(11) DEFAULT NULL,
 `c00` text COLLATE latin1_general_ci,
 `c01` text COLLATE latin1_general_ci,
 `c02` text COLLATE latin1_general_ci,
 `c03` text COLLATE latin1_general_ci,
 `c04` text COLLATE latin1_general_ci,
 `c05` text COLLATE latin1_general_ci,
 `c06` text COLLATE latin1_general_ci,
 `c07` text COLLATE latin1_general_ci,
 `c08` text COLLATE latin1_general_ci,
 `c09` text COLLATE latin1_general_ci,
 `c10` text COLLATE latin1_general_ci,
 `c11` text COLLATE latin1_general_ci,
 `c12` text COLLATE latin1_general_ci,
 `c13` text COLLATE latin1_general_ci,
 `c14` text COLLATE latin1_general_ci,
 `c15` text COLLATE latin1_general_ci,
 `c16` text COLLATE latin1_general_ci,
 `c17` text COLLATE latin1_general_ci,
 `c18` text COLLATE latin1_general_ci,
 `c19` text COLLATE latin1_general_ci,
 `c20` text COLLATE latin1_general_ci,
 `c21` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idMVideo`),
 UNIQUE KEY `ix_musicvideo_file_1` (`idMVideo`,`idFile`),
 UNIQUE KEY `ix_musicvideo_file_2` (`idFile`,`idMVideo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `musicvideoview`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`xbmc`@`%` SQL SECURITY DEFINER VIEW `xbmc_video`.`musicvideoview` AS select `xbmc_video`.`musicvideo`.`idMVideo` AS `idMVideo`,`xbmc_video`.`musicvideo`.`idFile` AS `idFile`,`xbmc_video`.`musicvideo`.`c00` AS `c00`,`xbmc_video`.`musicvideo`.`c01` AS `c01`,`xbmc_video`.`musicvideo`.`c02` AS `c02`,`xbmc_video`.`musicvideo`.`c03` AS `c03`,`xbmc_video`.`musicvideo`.`c04` AS `c04`,`xbmc_video`.`musicvideo`.`c05` AS `c05`,`xbmc_video`.`musicvideo`.`c06` AS `c06`,`xbmc_video`.`musicvideo`.`c07` AS `c07`,`xbmc_video`.`musicvideo`.`c08` AS `c08`,`xbmc_video`.`musicvideo`.`c09` AS `c09`,`xbmc_video`.`musicvideo`.`c10` AS `c10`,`xbmc_video`.`musicvideo`.`c11` AS `c11`,`xbmc_video`.`musicvideo`.`c12` AS `c12`,`xbmc_video`.`musicvideo`.`c13` AS `c13`,`xbmc_video`.`musicvideo`.`c14` AS `c14`,`xbmc_video`.`musicvideo`.`c15` AS `c15`,`xbmc_video`.`musicvideo`.`c16` AS `c16`,`xbmc_video`.`musicvideo`.`c17` AS `c17`,`xbmc_video`.`musicvideo`.`c18` AS `c18`,`xbmc_video`.`musicvideo`.`c19` AS `c19`,`xbmc_video`.`musicvideo`.`c20` AS `c20`,`xbmc_video`.`musicvideo`.`c21` AS `c21`,`xbmc_video`.`files`.`strFilename` AS `strFileName`,`xbmc_video`.`path`.`strPath` AS `strPath`,`xbmc_video`.`files`.`playCount` AS `playCount`,`xbmc_video`.`files`.`lastPlayed` AS `lastPlayed` from ((`xbmc_video`.`musicvideo` join `xbmc_video`.`files` on((`xbmc_video`.`files`.`idFile` = `xbmc_video`.`musicvideo`.`idFile`))) join `xbmc_video`.`path` on((`xbmc_video`.`path`.`idPath` = `xbmc_video`.`files`.`idPath`)));

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `path`
--

CREATE TABLE IF NOT EXISTS `path` (
 `idPath` int(11) NOT NULL AUTO_INCREMENT,
 `strPath` varchar(512) COLLATE latin1_general_ci DEFAULT NULL,
 `strContent` text COLLATE latin1_general_ci,
 `strScraper` text COLLATE latin1_general_ci,
 `strHash` text COLLATE latin1_general_ci,
 `scanRecursive` int(11) DEFAULT NULL,
 `useFolderNames` tinyint(1) DEFAULT NULL,
 `strSettings` text COLLATE latin1_general_ci,
 `noUpdate` tinyint(1) DEFAULT NULL,
 `exclude` tinyint(1) DEFAULT NULL,
 PRIMARY KEY (`idPath`),
 UNIQUE KEY `ix_path` (`strPath`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=371 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `setlinkmovie`
--

CREATE TABLE IF NOT EXISTS `setlinkmovie` (
 `idSet` int(11) DEFAULT NULL,
 `idMovie` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_setlinkmovie_1` (`idSet`,`idMovie`),
 UNIQUE KEY `ix_setlinkmovie_2` (`idMovie`,`idSet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `sets`
--

CREATE TABLE IF NOT EXISTS `sets` (
 `idSet` int(11) NOT NULL AUTO_INCREMENT,
 `strSet` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idSet`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
 `idFile` int(11) DEFAULT NULL,
 `Deinterlace` tinyint(1) DEFAULT NULL,
 `ViewMode` int(11) DEFAULT NULL,
 `ZoomAmount` float DEFAULT NULL,
 `PixelRatio` float DEFAULT NULL,
 `AudioStream` int(11) DEFAULT NULL,
 `SubtitleStream` int(11) DEFAULT NULL,
 `SubtitleDelay` float DEFAULT NULL,
 `SubtitlesOn` tinyint(1) DEFAULT NULL,
 `Brightness` float DEFAULT NULL,
 `Contrast` float DEFAULT NULL,
 `Gamma` float DEFAULT NULL,
 `VolumeAmplification` float DEFAULT NULL,
 `AudioDelay` float DEFAULT NULL,
 `OutputToAllSpeakers` tinyint(1) DEFAULT NULL,
 `ResumeTime` int(11) DEFAULT NULL,
 `Crop` tinyint(1) DEFAULT NULL,
 `CropLeft` int(11) DEFAULT NULL,
 `CropRight` int(11) DEFAULT NULL,
 `CropTop` int(11) DEFAULT NULL,
 `CropBottom` int(11) DEFAULT NULL,
 `Sharpness` float DEFAULT NULL,
 `NoiseReduction` float DEFAULT NULL,
 `NonLinStretch` tinyint(1) DEFAULT NULL,
 `PostProcess` tinyint(1) DEFAULT NULL,
 UNIQUE KEY `ix_settings` (`idFile`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `stacktimes`
--

CREATE TABLE IF NOT EXISTS `stacktimes` (
 `idFile` int(11) DEFAULT NULL,
 `times` text COLLATE latin1_general_ci,
 UNIQUE KEY `ix_stacktimes` (`idFile`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `streamdetails`
--

CREATE TABLE IF NOT EXISTS `streamdetails` (
 `idFile` int(11) DEFAULT NULL,
 `iStreamType` int(11) DEFAULT NULL,
 `strVideoCodec` text COLLATE latin1_general_ci,
 `fVideoAspect` float DEFAULT NULL,
 `iVideoWidth` int(11) DEFAULT NULL,
 `iVideoHeight` int(11) DEFAULT NULL,
 `strAudioCodec` text COLLATE latin1_general_ci,
 `iAudioChannels` int(11) DEFAULT NULL,
 `strAudioLanguage` text COLLATE latin1_general_ci,
 `strSubtitleLanguage` text COLLATE latin1_general_ci,
 `iVideoDuration` int(11) DEFAULT NULL,
 KEY `ix_streamdetails` (`idFile`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `studio`
--

CREATE TABLE IF NOT EXISTS `studio` (
 `idStudio` int(11) NOT NULL AUTO_INCREMENT,
 `strStudio` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idStudio`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=17 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `studiolinkmovie`
--

CREATE TABLE IF NOT EXISTS `studiolinkmovie` (
 `idStudio` int(11) DEFAULT NULL,
 `idMovie` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_studiolinkmovie_1` (`idStudio`,`idMovie`),
 UNIQUE KEY `ix_studiolinkmovie_2` (`idMovie`,`idStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `studiolinkmusicvideo`
--

CREATE TABLE IF NOT EXISTS `studiolinkmusicvideo` (
 `idStudio` int(11) DEFAULT NULL,
 `idMVideo` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_studiolinkmusicvideo_1` (`idStudio`,`idMVideo`),
 UNIQUE KEY `ix_studiolinkmusicvideo_2` (`idMVideo`,`idStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `studiolinktvshow`
--

CREATE TABLE IF NOT EXISTS `studiolinktvshow` (
 `idStudio` int(11) DEFAULT NULL,
 `idShow` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_studiolinktvshow_1` (`idStudio`,`idShow`),
 UNIQUE KEY `ix_studiolinktvshow_2` (`idShow`,`idStudio`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tvshow`
--

CREATE TABLE IF NOT EXISTS `tvshow` (
 `idShow` int(11) NOT NULL AUTO_INCREMENT,
 `c00` text COLLATE latin1_general_ci,
 `c01` text COLLATE latin1_general_ci,
 `c02` text COLLATE latin1_general_ci,
 `c03` text COLLATE latin1_general_ci,
 `c04` text COLLATE latin1_general_ci,
 `c05` text COLLATE latin1_general_ci,
 `c06` text COLLATE latin1_general_ci,
 `c07` text COLLATE latin1_general_ci,
 `c08` text COLLATE latin1_general_ci,
 `c09` text COLLATE latin1_general_ci,
 `c10` text COLLATE latin1_general_ci,
 `c11` text COLLATE latin1_general_ci,
 `c12` text COLLATE latin1_general_ci,
 `c13` text COLLATE latin1_general_ci,
 `c14` text COLLATE latin1_general_ci,
 `c15` text COLLATE latin1_general_ci,
 `c16` text COLLATE latin1_general_ci,
 `c17` text COLLATE latin1_general_ci,
 `c18` text COLLATE latin1_general_ci,
 `c19` text COLLATE latin1_general_ci,
 `c20` text COLLATE latin1_general_ci,
 `c21` text COLLATE latin1_general_ci,
 PRIMARY KEY (`idShow`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=17 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tvshowlinkepisode`
--

CREATE TABLE IF NOT EXISTS `tvshowlinkepisode` (
 `idShow` int(11) DEFAULT NULL,
 `idEpisode` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_tvshowlinkepisode_1` (`idShow`,`idEpisode`),
 UNIQUE KEY `ix_tvshowlinkepisode_2` (`idEpisode`,`idShow`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `tvshowlinkpath`
--

CREATE TABLE IF NOT EXISTS `tvshowlinkpath` (
 `idShow` int(11) DEFAULT NULL,
 `idPath` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_tvshowlinkpath_1` (`idShow`,`idPath`),
 UNIQUE KEY `ix_tvshowlinkpath_2` (`idPath`,`idShow`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `version`
--

CREATE TABLE IF NOT EXISTS `version` (
 `idVersion` int(11) DEFAULT NULL,
 `iCompressCount` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `writerlinkepisode`
--

CREATE TABLE IF NOT EXISTS `writerlinkepisode` (
 `idWriter` int(11) DEFAULT NULL,
 `idEpisode` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_writerlinkepisode_1` (`idWriter`,`idEpisode`),
 UNIQUE KEY `ix_writerlinkepisode_2` (`idEpisode`,`idWriter`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `writerlinkmovie`
--

CREATE TABLE IF NOT EXISTS `writerlinkmovie` (
 `idWriter` int(11) DEFAULT NULL,
 `idMovie` int(11) DEFAULT NULL,
 UNIQUE KEY `ix_writerlinkmovie_1` (`idWriter`,`idMovie`),
 UNIQUE KEY `ix_writerlinkmovie_2` (`idMovie`,`idWriter`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

 

Link to comment
Rag3 Newbie

Rag3

Posted
  • Author
Posted

Sieht für mich auf den ersten Blick nach dem gleichen schema aus... ich stelle mir nur noch die Frage, warum man MySQL nehmen soll, wenn sqlite seinen zweck erfüllt und keinen extra server benötigt...

Link to comment
kicr Newbie

kicr

Posted
Posted

Sieht für mich auf den ersten Blick nach dem gleichen schema aus... ich stelle mir nur noch die Frage, warum man MySQL nehmen soll, wenn sqlite seinen zweck erfüllt und keinen extra server benötigt...

 

Ich greife von insgesamt 3 XBMC Clients auf die MySQL Datenbank zu. Diese läuft auf meiner NAS wo auch die Daten liegen. Wenn ich z.B. im Wohnzimmer einen Film starte, pausiere und den PC herunterfahre kann ich im Schlafzimmer dort weiterschauen wo ich aufgehört habe. Da ich gerne und viel mit phpmyadmin arbeite, fallen manuelle Änderungen direkt in der DB leicht.

Link to comment
Rag3 Newbie

Rag3

Posted
  • Author
Posted

Ok, das leuchtet ein :)

Ich schau mir bei Gelegenheit mal den Aufwand an, sollte aber aufgrund des gleichen Schemas sehr gering sein...

 

Gruß

Rag3

Link to comment
  • 4 months later...
Kirak Newbie

Kirak

Posted
Posted

Ich habe mir den Thread durchgelesen und gesehen, dass man anscheinend eine Ember Datenbank importieren kann(bzw. die movie.nfo und sonstige Dateien die Ember in den Filmordnern erstellt.

Leider habe ich nicht herausgefunden wie das genau funktioniert. Würde nämlich ungern einen Umweg machen und deswegen extra XMBC installieren.

Könnte mir einer erklären wie das ganze funktioniert? Finde in der XML nur die Möglichkeit eine XBMC Datenbank auszuwählen.

Ich benutze Ember v1.2.2385 falls das relevant sein sollte.

Link to comment
  • 7 months later...
GBWebmaster Newbie

GBWebmaster

Posted
Posted

Ich weiß nicht, wie gepflegt dieses Tool bzw. dieser Threat noch ist ...

 

Ich benutze XBMC in der Version 11 und Ember Media Manager in der aktuellen Version 1.3.0.5.

Nach der Definition der Pfade findet das Programm die Datenbank und auch die Filme - wird alles schön aufgelistet.

 

Allerdings hab ich in den "backdrops"-Ordnern der neuen Filme keine Bilder, es wird eigentlich nichts heruntergeladen.

Das dvbv-interne MyMovies-PlugIn hatte auch das Problem, dass die iso-Filme als Filmdateien nicht erkannt wurden. Ist dies hier auch der Fall?

 

Und wenn ich im dvbv meine Spielfilme öffne, sind alle Bilder weg - auch die, die eigentlich in den Filmeordnern vorhanden sind. Nur leider scheinen diese in der mymovies-db gelöscht zu sein.

 

Kann mir hier jemand behilflich sein??

 

 

Gruß GBWebmaster

Link to comment
  • 1 year later...
Vroniefan Newbie

Vroniefan

Posted
Posted

Hi in der hoffnung das der author noch aktiv ist erst einmal danke nutze das tool schon seit jahren und bin sehr zufrieden damit nur habe ich jetzt auf die aktuelle version von xbmc geupdated und bekomm das tool nicht mehr zum laufen die xbmc datenbank kann nicht geöffnet werden gibt es dafür ne lösung ???

thx in advance Vroniefan

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing
×
×
  • Create New...