diff options
Diffstat (limited to 'plugin.video.mediathekview/resources')
14 files changed, 1489 insertions, 0 deletions
diff --git a/plugin.video.mediathekview/resources/fanart.jpg b/plugin.video.mediathekview/resources/fanart.jpg Binary files differnew file mode 100644 index 0000000..4d9bd9d --- /dev/null +++ b/plugin.video.mediathekview/resources/fanart.jpg diff --git a/plugin.video.mediathekview/resources/icon.jpg b/plugin.video.mediathekview/resources/icon.jpg Binary files differnew file mode 100644 index 0000000..79073be --- /dev/null +++ b/plugin.video.mediathekview/resources/icon.jpg diff --git a/plugin.video.mediathekview/resources/language/English/strings.po b/plugin.video.mediathekview/resources/language/English/strings.po new file mode 100644 index 0000000..e4c3cf5 --- /dev/null +++ b/plugin.video.mediathekview/resources/language/English/strings.po @@ -0,0 +1,300 @@ +# Kodi Media Center language file +# Addon Name: MediathekView +# Addon id: plugin.video.mediathekview +# Addon Provider: leo.moll@yeasoft.com +msgid "" +msgstr "" +"Project-Id-Version: Kodi Addons\n" +"Report-Msgid-Bugs-To: leo.moll@yeasoft.com\n" +"POT-Creation-Date: YEAR-MO-DA HO:MI+ZONE\n" +"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n" +"Last-Translator: Alex\n" +"Language-Team: English (http://www.transifex.com/projects/p/xbmc-addons/language/en/)\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Language: en\n" +"Plural-Forms: nplurals=2; plural=(n != 1);\n" + +# Settings categories +msgctxt "#30001" +msgid "General" +msgstr "General" + +msgctxt "#30002" +msgid "Database Settings" +msgstr "Database Settings" + +# Settings Page 1 +msgctxt "#30110" +msgid "Prefer HD streams" +msgstr "Prefer HD streams" + +msgctxt "#30111" +msgid "No future videos (usually trailers)" +msgstr "No future videos (usually trailers)" + +msgctxt "#30112" +msgid "Minimum duration in minutes" +msgstr "Minimum duration in minutes" + +msgctxt "#30113" +msgid "Group shows of different channel" +msgstr "Group shows of different channel" + +msgctxt "#30114" +msgid "Download directory" +msgstr "Download directory" + +# Settings Page 2 +msgctxt "#30210" +msgid "Database type" +msgstr "Database type" + +msgctxt "#30211" +msgid "Database hostname" +msgstr "Database hostname" + +msgctxt "#30212" +msgid "Database username" +msgstr "Database username" + +msgctxt "#30213" +msgid "Database password" +msgstr "Database password" + +msgctxt "#30214" +msgid "Database name" +msgstr "Database name" + +msgctxt "#30221" +msgid "Internal (sqlite)" +msgstr "Internal (sqlite)" + +msgctxt "#30222" +msgid "External (mysql)" +msgstr "External (mysql)" + +msgctxt "#30231" +msgid "Database Updates" +msgstr "Database Updates" + +msgctxt "#30232" +msgid "Update interval in hours" +msgstr "Update interval in hours" + +msgctxt "#30233" +msgid "XZ Program Location" +msgstr "XZ Program Location" + +msgctxt "#30238" +msgid "Reset Database" +msgstr "Reset Database" + +# Main Menu +msgctxt "#30901" +msgid "Search in Title" +msgstr "Search in Title" + +msgctxt "#30902" +msgid "Search in Title and Description" +msgstr "Search in Title and Description" + +msgctxt "#30903" +msgid "Livestreams" +msgstr "Livestreams" + +msgctxt "#30904" +msgid "Recently Added" +msgstr "Recently Added" + +msgctxt "#30905" +msgid "Recently Added by Channel" +msgstr "Recently Added by Channel" + +msgctxt "#30906" +msgid "Browse by Show in all Channels" +msgstr "Browse by Show in all Channels" + +msgctxt "#30907" +msgid "Browse Shows by Channel" +msgstr "Browse Shows by Channel" + +msgctxt "#30908" +msgid "Database Information" +msgstr "Database Information" + +# Context Menu +msgctxt "#30921" +msgid "Download Video" +msgstr "Download Video" + +msgctxt "#30922" +msgid "Download LoRes Video" +msgstr "Download LoRes Video" + +msgctxt "#30923" +msgid "Download HD Video" +msgstr "Download HD Video" + +msgctxt "#30924" +msgid "Add to queue" +msgstr "Add to queue" + +# Database status +msgctxt "#30941" +msgid "Not Initialized" +msgstr "Not Initialized" + +msgctxt "#30942" +msgid "No Status Available" +msgstr "No Status Available" + +msgctxt "#30943" +msgid "Idle" +msgstr "Idle" + +msgctxt "#30944" +msgid "Updating..." +msgstr "Updating..." + +msgctxt "#30945" +msgid "Last Update Aborted" +msgstr "Last Update Aborted" + +# Other Strings +msgctxt "#30951" +msgid "Mediathek Database Error" +msgstr "Mediathek Database Error" + +msgctxt "#30952" +msgid "Download Error" +msgstr "Download Error" + +msgctxt "#30953" +msgid "Error while downloading {}: {}" +msgstr "Error while downloading {}: {}" + +msgctxt "#30954" +msgid "Required decompression program 'xz' not found on your system" +msgstr "Required decompression program 'xz' not found on your system" + +msgctxt "#30955" +msgid "Download Database Update" +msgstr "Download Database Update" + +msgctxt "#30956" +msgid "Mediathek Database Update" +msgstr "Mediathek Database Update" + +msgctxt "#30957" +msgid "Mediathek (%d): channels:%d, shows:%d, movies:%d ..." +msgstr "Mediathek (%d): channels:%d, shows:%d, movies:%d ..." + +msgctxt "#30958" +msgid "Please set a download folder in the settings" +msgstr "Please set a download folder in the settings" + +msgctxt "#30959" +msgid "Download directory could not be created: {}" +msgstr "Download directory could not be created: {}" + +msgctxt "#30960" +msgid "Download Successful" +msgstr "Download Successful" + +msgctxt "#30961" +msgid "Welcome to MediathekView" +msgstr "Welcome to MediathekView" + +msgctxt "#30962" +msgid "This Kodi addon allows access to most video-platforms from German public service " +"broadcasters using the database provided by the popular project of MediathekView.\n\n" +"Without the endless effort of the MediathekView contributors, addons like this would not " +"exist.\n\n" +"Please consider donating to this awesome project! Visit MediathekView at https://mediathekview.de/" +msgstr "This Kodi addon allows access to most video-platforms from German public service " +"broadcasters using the database provided by the great project of MediathekView.\n\n" +"Without the endless effort of the MediathekView contributors, addons like this would not " +"exist.\n\n" +"Please consider donating to this great project! Visit MediathekView at https://mediathekview.de/" + +msgctxt "#30963" +msgid "XZ Decompressor is Missing" +msgstr "XZ Decompressor is Missing" + +msgctxt "#30964" +msgid "The database updater needs the program 'xz' in order to process the database update files. " +"This programm was not found on your Kodi system.\n\nIf you want to use the database updater on this " +"system, you have to install 'xz' in one of the standard locations (/bin, /usr/bin, /usr/local/bin).\n\n" +"Alternatively you can specify the location of the 'xz' program in the addon settings.\n\n" +"Another possibilty would be the use of an external database updated either by another Kodi system " +"or by the provided update script running on a server (see README file).\n\n" +"The datebase updater has been disabled so you have to enable it again from the addon settings page." +msgstr "The database updater needs the program 'xz' in order to process the database update files. " +"This programm was not found on your Kodi system.\n\nIf you want to use the database updater on this " +"system, you have to install 'xz' in one of the standard locations (/bin, /usr/bin, /usr/local/bin).\n\n" +"Alternatively you can specify the location of the 'xz' program in the addon settings.\n\n" +"Another possibilty would be the use of an external database updated either by another Kodi system " +"or by the provided update script running on a server (see README file).\n\n" +"The datebase updater has been disabled so you have to enable it again from the addon settings page." + +msgctxt "#30965" +msgid "Database Status: %s" +msgstr "Database Status: %s" + +msgctxt "#30966" +msgid "This database was never updated" +msgstr "This database was never updated" + +msgctxt "#30967" +msgid "%s in progress...\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies" +msgstr "%s in progress...\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies" + +msgctxt "#30968" +msgid "%s in progress...\nAdditions: %d channels, %d shows, %d movies" +msgstr "%s in progress...\nAdditions: %d channels, %d shows, %d movies" + +msgctxt "#30969" +msgid "Last %s: %s\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" +msgstr "Last %s: %s\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" + +msgctxt "#30970" +msgid "Last %s: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" +msgstr "Last %s: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" + +msgctxt "#30971" +msgid "Total: %d channels, %d shows, %d movies" +msgstr "Total: %d channels, %d shows, %d movies" + +msgctxt "#30972" +msgid "Full Update" +msgstr "Full Update" + +msgctxt "#30973" +msgid "Differential Update" +msgstr "Differential Update" + +msgctxt "#30974" +msgid "Downloading Video" +msgstr "Downloading Video" + +msgctxt "#30975" +msgid "Error while downloading {}: {}" +msgstr "Error while downloading {}: {}" + +msgctxt "#30976" +msgid "Video {} has been downloaded" +msgstr "Video {} has been downloaded" + +msgctxt "#30977" +msgid "Video Already Exists" +msgstr "Video Already Exists" + +msgctxt "#30978" +msgid "Downloading Subtitles" +msgstr "Downloading Subtitles" + +msgctxt "#30979" +msgid "Download path does not exist" +msgstr "Download path does not exist" diff --git a/plugin.video.mediathekview/resources/language/German/strings.po b/plugin.video.mediathekview/resources/language/German/strings.po new file mode 100644 index 0000000..c6da721 --- /dev/null +++ b/plugin.video.mediathekview/resources/language/German/strings.po @@ -0,0 +1,302 @@ +# Kodi Media Center language file +# Addon Name: MediathekView +# Addon id: plugin.video.mediathekview +# Addon Provider: leo.moll@yeasoft.com +msgid "" +msgstr "" +"Project-Id-Version: Kodi Addons\n" +"Report-Msgid-Bugs-To: leo.moll@yeasoft.com\n" +"POT-Creation-Date: YEAR-MO-DA HO:MI+ZONE\n" +"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n" +"Last-Translator: Alex\n" +"Language-Team: German (http://www.transifex.com/projects/p/xbmc-addons/language/de/)\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Language: en\n" +"Plural-Forms: nplurals=2; plural=(n != 1);\n" + +# Settings categories +msgctxt "#30001" +msgid "General" +msgstr "Allgemein" + +msgctxt "#30002" +msgid "Database Settings" +msgstr "Datenbank Einstellungen" + +# Settings Page 1 +msgctxt "#30110" +msgid "Prefer HD streams" +msgstr "HD Streams bevorzugen" + +msgctxt "#30111" +msgid "No future videos (usually trailers)" +msgstr "Keine Videos aus der Zukunft (üblicherweise Trailer)" + +msgctxt "#30112" +msgid "Minimum duration in minutes" +msgstr "Minimlae Länge in Minuten" + +msgctxt "#30113" +msgid "Group shows of different channel" +msgstr "Sendungen verschiedener Sender zusammenfassen" + +msgctxt "#30114" +msgid "Download directory" +msgstr "Download-Verzeichnis" + +# Settings Page 2 +msgctxt "#30210" +msgid "Database type" +msgstr "Datenbank Typ" + +msgctxt "#30211" +msgid "Database hostname" +msgstr "Datenbank Hostname" + +msgctxt "#30212" +msgid "Database username" +msgstr "Datenbank Benutzername" + +msgctxt "#30213" +msgid "Database password" +msgstr "Datenbank Passwort" + +msgctxt "#30214" +msgid "Database name" +msgstr "Datenbank Name" + +msgctxt "#30221" +msgid "Internal (sqlite)" +msgstr "Intern (sqlite)" + +msgctxt "#30222" +msgid "External (mysql)" +msgstr "Extern (mysql)" + +msgctxt "#30231" +msgid "Database Updates" +msgstr "Datenbankupdates" + +msgctxt "#30232" +msgid "Update interval in hours" +msgstr "Aktualisierungsintervall in Stunden" + +msgctxt "#30233" +msgid "XZ Program Location" +msgstr "XZ Programm" + +msgctxt "#30238" +msgid "Reset Database" +msgstr "Datenbank zurücksetzen" + +# Main Menu +msgctxt "#30901" +msgid "Search in Title" +msgstr "Suchen in Titel" + +msgctxt "#30902" +msgid "Search in Title and Description" +msgstr "Suchen in Titel und Beschreibung" + +msgctxt "#30903" +msgid "Livestreams" +msgstr "Livestreams" + +msgctxt "#30904" +msgid "Recently Added" +msgstr "Vor Kurzem hinzugefügt" + +msgctxt "#30905" +msgid "Recently Added by Channel" +msgstr "Vor Kurzem hinzugefügt nach Sender" + +msgctxt "#30906" +msgid "Browse by Show in all Channels" +msgstr "Alle Sendungen" + +msgctxt "#30907" +msgid "Browse Shows by Channel" +msgstr "Alle Sendungen nach Sender" + +msgctxt "#30908" +msgid "Database Information" +msgstr "Datenbank Informationen" + +# Context Menu +msgctxt "#30921" +msgid "Download Video" +msgstr "Video herunterladen" + +msgctxt "#30922" +msgid "Download LoRes Video" +msgstr "Niedrig auflösendes Video herunterladen" + +msgctxt "#30923" +msgid "Download HD Video" +msgstr "Hoch auflösendes Video herunterladen" + +msgctxt "#30924" +msgid "Add to queue" +msgstr "Zur Warteschlange hinzufügen" + +# Database status +msgctxt "#30941" +msgid "Not Initialized" +msgstr "Nicht initialisiert" + +msgctxt "#30942" +msgid "No Status Available" +msgstr "Kein Status verfügbar" + +msgctxt "#30943" +msgid "Idle" +msgstr "Bereit" + +msgctxt "#30944" +msgid "Updating..." +msgstr "Aktualisierung läuft..." + +msgctxt "#30945" +msgid "Last Update Aborted" +msgstr "Letzte Aktualisierung abgebrochen" + +# Other Strings +msgctxt "#30951" +msgid "Mediathek Database Error" +msgstr "Mediathek Datenbank Fehler" + +msgctxt "#30952" +msgid "Download Error" +msgstr "Dowload Fehler" + +msgctxt "#30953" +msgid "Error while downloading {}: {}" +msgstr "Fehler beim herunterladen von {}: {}" + +msgctxt "#30954" +msgid "Required decompression program 'xz' not found on your system" +msgstr "Der benötigte Entpacker 'xz' konnte nicht gefunden werden" + +msgctxt "#30955" +msgid "Download Database Update" +msgstr "Datenbank Update wird heruntergeladen" + +msgctxt "#30956" +msgid "Mediathek Database Update" +msgstr "Mediathek wird aktualisiert" + +msgctxt "#30957" +msgid "Mediathek (%d): channels:%d, shows:%d, movies:%d ..." +msgstr "Mediathek (%d): Sender:%d, Sendungen:%d, Filme:%d ..." + +msgctxt "#30958" +msgid "Please set a download folder in the settings" +msgstr "Bitte waehlen Sie ein Download-Verzeichnis in den Einstellungen" + +msgctxt "#30959" +msgid "Download directory could not be created: {}" +msgstr "Fehler beim Ertzeugen des Download-Verzeichnisses: {}" + +msgctxt "#30960" +msgid "Download Successful" +msgstr "Download Erfolgreich" + +msgctxt "#30961" +msgid "Welcome to MediathekView" +msgstr "Willkommen" + +msgctxt "#30962" +msgid "This Kodi addon allows access to most video-platforms from German public service " +"broadcasters using the database provided by the popular project of MediathekView.\n\n" +"Without the endless effort of the MediathekView contributors, addons like this would not " +"exist.\n\n" +"Please consider donating to this awesome project! Visit MediathekView at https://mediathekview.de/" +msgstr "Dieses Kodi Addon Ermöglicht den Zugriff auf fast alle deutschen Mediatheken der " +"öffentlich Rechtlichen basierend auf der Datenbank des beliebten MediathekView Projektes.\n\n" +"Ohne den unermüdlichen Einsatz des MediathekView-Teams wäre ein solches Addon nicht möglich.\n\n" +"Um das Projekt zu unterstützen, besteht die Möglichkeit auf https://mediathekview.de/ eine " +"Spende zu hinterlassen." + +msgctxt "#30963" +msgid "XZ Decompressor is Missing" +msgstr "Entpacker XZ nicht gefunden" + +msgctxt "#30964" +msgid "The database updater needs the program 'xz' in order to process the database update files. " +"This programm was not found on your Kodi system.\n\nIf you want to use the database er on this " +"system, you have to install 'xz' in one of the standard locations (/bin, /usr/bin, /usr/local/bin).\n\n" +"Alternatively you can specify the location of the 'xz' program in the addon settings.\n\n" +"Another possibilty would be the use of an external database updated either by another Kodi system " +"or by the provided update script running on a server (see README file).\n\n" +"The datebase er has been disabled so you have to enable it again from the addon settings page." +msgstr "Der Datenbank-Aktualisierer benötigt den Entpacker 'xz' der auf diesem Kodi-System leider " +"nicht gefunden wurde.\n\nUm den Datenbank-Aktualisierer zu benutzen, muss dieses Programm auf dem " +"System in einem der Standard-Verzeichnisse (/bin, /usr/bin, /usr/local/bin) installiert werden.\n\n" +"Unter Windows bzw. falls das Programm in einem anderen Verzeichnis installiert ist, muss der Pfad " +"zum Programm in den Addon-Einstellungen angegeben werden.\n\n" +"Eine andere Möglichkeit ist die Benutzung einer externen Datenbank die entweder über eine anderes " +"Kodi-System oder über das mitgelieferte Update-Skript (siehe README) regelmäßig aktualisiert wird.\n\n" +"Der Datenbank-Aktualisierer wurde deaktiviert. Er kann über die Addon-Einstellungen wieder aktiviert " +"werden." + +msgctxt "#30965" +msgid "Database Status: %s" +msgstr "Datenbank-Status: %s" + +msgctxt "#30966" +msgid "This database was never updated" +msgstr "Diese Datenbank wurde noch nicht aktualisiert" + +msgctxt "#30967" +msgid "%s in progress...\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies" +msgstr "%s läuft...\nFilmdatenbank vom %s\nNeuzugänge: %d Sender, %d Sendungen, %d Filme" + +msgctxt "#30968" +msgid "%s in progress...\nAdditions: %d channels, %d shows, %d movies" +msgstr "%s läuft...\nNeuzugänge: %d Sender, %d Sendungen, %d Filme" + +msgctxt "#30969" +msgid "Last %s: %s\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" +msgstr "Letzte %s: %s\nFilmdatenbank vom %s\nNeuzugänge: %d Sender, %d Sendungen, %d Filme\nLöschungen: %d Sender, %d Sendungen, %d Filme" + +msgctxt "#30970" +msgid "Last %s: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" +msgstr "Letzte %s: %s\nNeuzugänge: %d Sender, %d Sendungen, %d Filme\nLöschungen: %d Sender, %d Sendungen, %d Filme" + +msgctxt "#30971" +msgid "Total: %d channels, %d shows, %d movies" +msgstr "Summen: %d Sender, %d Sendungen, %d Filme" + +msgctxt "#30972" +msgid "Full Update" +msgstr "Vollständige Aktualisierung" + +msgctxt "#30973" +msgid "Differential Update" +msgstr "Differentielle Aktualisierung" + +msgctxt "#30974" +msgid "Downloading Video" +msgstr "Video wird herunterladen" + +msgctxt "#30975" +msgid "Error while downloading {}: {}" +msgstr "Fehler beim Herunterladen von {}: {}" + +msgctxt "#30976" +msgid "Video {} has been downloaded" +msgstr "Video {} wurde heruntergeladen" + +msgctxt "#30977" +msgid "Video Already Exists" +msgstr "Das Video existiert bereits" + +msgctxt "#30978" +msgid "Downloading Subtitles" +msgstr "Untertitel werden heruntergeladen" + +msgctxt "#30979" +msgid "Download path does not exist" +msgstr "Download-Verzeichnis existiert nicht" diff --git a/plugin.video.mediathekview/resources/language/Italian/strings.po b/plugin.video.mediathekview/resources/language/Italian/strings.po new file mode 100644 index 0000000..aadc963 --- /dev/null +++ b/plugin.video.mediathekview/resources/language/Italian/strings.po @@ -0,0 +1,303 @@ +# Kodi Media Center language file +# Addon Name: MediathekView +# Addon id: plugin.video.mediathekview +# Addon Provider: leo.moll@yeasoft.com +msgid "" +msgstr "" +"Project-Id-Version: Kodi Addons\n" +"Report-Msgid-Bugs-To: leo.moll@yeasoft.com\n" +"POT-Creation-Date: YEAR-MO-DA HO:MI+ZONE\n" +"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n" +"Last-Translator: Alex\n" +"Language-Team: Italian (http://www.transifex.com/projects/p/xbmc-addons/language/it/)\n" +"MIME-Version: 1.0\n" +"Content-Type: text/plain; charset=UTF-8\n" +"Content-Transfer-Encoding: 8bit\n" +"Language: en\n" +"Plural-Forms: nplurals=2; plural=(n != 1);\n" + +# Settings categories +msgctxt "#30001" +msgid "General" +msgstr "Visualizzazione" + +msgctxt "#30002" +msgid "Database Settings" +msgstr "Impostazioni Banca Dati" + +# Settings Page 1 +msgctxt "#30110" +msgid "Prefer HD streams" +msgstr "Preferisci alta definizione" + +msgctxt "#30111" +msgid "No future videos (usually trailers)" +msgstr "Non mostrare video futuri (usualmente trailer)" + +msgctxt "#30112" +msgid "Minimum duration in minutes" +msgstr "Durata minima in minuti" + +msgctxt "#30113" +msgid "Group shows of different channel" +msgstr "Raggruppa trasmissioni su canali diversi" + +msgctxt "#30114" +msgid "Download directory" +msgstr "Directory di download" + +# Settings Page 2 +msgctxt "#30210" +msgid "Database type" +msgstr "Tipo banca dati" + +msgctxt "#30211" +msgid "Database hostname" +msgstr "Hostname banca dati" + +msgctxt "#30212" +msgid "Database username" +msgstr "Nome utente" + +msgctxt "#30213" +msgid "Database password" +msgstr "Password" + +msgctxt "#30214" +msgid "Database name" +msgstr "Nome Database" + +msgctxt "#30221" +msgid "Internal (sqlite)" +msgstr "Interna (sqlite)" + +msgctxt "#30222" +msgid "External (mysql)" +msgstr "Esterna (mysql)" + +msgctxt "#30231" +msgid "Database Updates" +msgstr "Attualizzazione Database" + +msgctxt "#30232" +msgid "Update interval in hours" +msgstr "Intervallo di attualizzazione in ore" + +msgctxt "#30233" +msgid "XZ Program Location" +msgstr "Programma XZ" + +msgctxt "#30238" +msgid "Reset Database" +msgstr "Ripristina Database" + +# Main Menu +msgctxt "#30901" +msgid "Search in Title" +msgstr "Ricerca nel Titolo" + +msgctxt "#30902" +msgid "Search in Title and Description" +msgstr "Ricerca nel Titolo e nella Descrizione" + +msgctxt "#30903" +msgid "Livestreams" +msgstr "Livestreams" + +msgctxt "#30904" +msgid "Recently Added" +msgstr "Recenti" + +msgctxt "#30905" +msgid "Recently Added by Channel" +msgstr "Recenti secondo emittenti" + +msgctxt "#30906" +msgid "Browse by Show in all Channels" +msgstr "Tutte le trasmissioni" + +msgctxt "#30907" +msgid "Browse Shows by Channel" +msgstr "Trasmissioni secondo emittenti" + +msgctxt "#30908" +msgid "Database Information" +msgstr "Informazioni Database" + +# Context Menu +msgctxt "#30921" +msgid "Download Video" +msgstr "Scarica video" + +msgctxt "#30922" +msgid "Download LoRes Video" +msgstr "Scarica video bassa risoluzione" + +msgctxt "#30923" +msgid "Download HD Video" +msgstr "Scarica video alta risoluzione" + +msgctxt "#30924" +msgid "Add to queue" +msgstr "Metti in coda" + +# Database status +msgctxt "#30941" +msgid "Not Initialized" +msgstr "Non inizializzato" + +msgctxt "#30942" +msgid "No Status Available" +msgstr "Stato non disponibile" + +msgctxt "#30943" +msgid "Idle" +msgstr "Disponibile" + +msgctxt "#30944" +msgid "Updating..." +msgstr "Attualizzazione in corso..." + +msgctxt "#30945" +msgid "Last Update Aborted" +msgstr "Ultima attualizzazione interrotta" + +# Other Strings +msgctxt "#30951" +msgid "Mediathek Database Error" +msgstr "Errore Database Mediathek" + +msgctxt "#30952" +msgid "Download Error" +msgstr "Errore di Scaricamento" + +msgctxt "#30953" +msgid "Error while downloading {}: {}" +msgstr "Errore scaricando {0}: {1}" + +msgctxt "#30954" +msgid "Required decompression program 'xz' not found on your system" +msgstr "Il decompressore 'xz' manca sul sistema" + +msgctxt "#30955" +msgid "Download Database Update" +msgstr "Attualizzazione viene scaricata" + +msgctxt "#30956" +msgid "Mediathek Database Update" +msgstr "Mediathek in attualizzazione" + +msgctxt "#30957" +msgid "Mediathek (%d): channels:%d, shows:%d, movies:%d ..." +msgstr "Mediathek (%d): canali:%d, programmi:%d, film:%d ..." + +msgctxt "#30958" +msgid "Please set a download folder in the settings" +msgstr "Selezionare una directory di download nelle impostazioni" + +msgctxt "#30959" +msgid "Download directory could not be created: {}" +msgstr "Non è stato possibile creare la directory di download: {}" + +msgctxt "#30960" +msgid "Download Successful" +msgstr "Download Completato" + +msgctxt "#30961" +msgid "Welcome to MediathekView" +msgstr "Benvenuti" + +msgctxt "#30962" +msgid "This Kodi addon allows access to most video-platforms from German public service " +"broadcasters using the database provided by the popular project of MediathekView.\n\n" +"Without the endless effort of the MediathekView contributors, addons like this would not " +"exist.\n\n" +"Please consider donating to this awesome project! Visit MediathekView at https://mediathekview.de/" +msgstr "Questo addon di Kodi permette l'accesso a gran parte delle piattaforme video operate dalle " +"emittenti pubbliche tedesche usando la banca dati del grandioso progetto MediathekView.\n\n" +"Senza l'assiduo impegno del team di MediathekView un addon come questo non sarebba mai " +"stato fattibile.\n\n" +"Per aiutare i programmatori ad offrire continui aggiornamente al database, è possibile " +"donare un piccolo contributo sulla pagina del progetto https://mediathekview.de/" + +msgctxt "#30963" +msgid "XZ Decompressor is Missing" +msgstr "Decompressore XZ non trovato" + +msgctxt "#30964" +msgid "The database updater needs the program 'xz' in order to process the database update files. " +"This programm was not found on your Kodi system.\n\nIf you want to use the database er on this " +"system, you have to install 'xz' in one of the standard locations (/bin, /usr/bin, /usr/local/bin).\n\n" +"Alternatively you can specify the location of the 'xz' program in the addon settings.\n\n" +"Another possibilty would be the use of an external database updated either by another Kodi system " +"or by the provided update script running on a server (see README file).\n\n" +"The datebase er has been disabled so you have to enable it again from the addon settings page." +msgstr "L'attualizzatore del database necessita il programma di decompressione 'xz' che purtroppo " +"non è stato trovato su questo sistema Kodi.\n\nSe si vuole usare l'attualizzatore del database su " +"questo sistema, è necessario installare il programma di decompressione in una delle directory " +"standard (/bin, /usr/bin, /usr/local/bin).\n\nSu sistemi Windows o nel caso il programma di " +"decompressione sia installato in una directory alternativa, il percorso potrà essere specificato " +"nelle impostazioni dell'addon.\n\n" +"In alternativa è possibile utilizzare un database esterno attualizzato da un altro sistema Kodi " +"o dallo script in allegato operato su un server unix (vedi file di README).\n\n" +"L'attualizzatore è stato disabilitato e potrà essere riattivato nelle impostazione dell'addon." + +msgctxt "#30965" +msgid "Database Status: %s" +msgstr "Stato del Database: %s" + +msgctxt "#30966" +msgid "This database was never updated" +msgstr "Questo database non è stato mai attualizzato" + +msgctxt "#30967" +msgid "%s in progress...\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies" +msgstr "%s in corso...\nAggiornamento del %s\nAggiunzioni: %d canali, %d programmi, %d film" + +msgctxt "#30968" +msgid "%s in progress...\nAdditions: %d channels, %d shows, %d movies" +msgstr "%s in corso...\nAggiunzioni: %d canali, %d programmi, %d film" + +msgctxt "#30969" +msgid "Last %s: %s\nDatabase: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" +msgstr "Ultimo %s: %s\nAggiornamento del %s\nAggiunzioni: %d canali, %d programmi, %d film\nCancellazioni: %d canali, %d programmi, %d film" + +msgctxt "#30970" +msgid "Last %s: %s\nAdditions: %d channels, %d shows, %d movies\nDeletions: %d channels, %d shows, %d movies" +msgstr "Ultimo %s: %s\nAggiunzioni: %d canali, %d programmi, %d film\nCancellazioni: %d canali, %d programmi, %d film" + +msgctxt "#30971" +msgid "Total: %d channels, %d shows, %d movies" +msgstr "Somme: %d canali, %d programmi, %d film" + +msgctxt "#30972" +msgid "Full Update" +msgstr "Aggiornamento Completo" + +msgctxt "#30973" +msgid "Differential Update" +msgstr "Aggiornamento Differenziale" + +msgctxt "#30974" +msgid "Downloading Video" +msgstr "Scaricamento video" + +msgctxt "#30975" +msgid "Error while downloading {}: {}" +msgstr "Errore durante lo scaricamento di {}: {}" + +msgctxt "#30976" +msgid "Video {} has been downloaded" +msgstr "Il video {} è stato scaricato" + +msgctxt "#30977" +msgid "Video Already Exists" +msgstr "Il video è già esistente" + +msgctxt "#30978" +msgid "Downloading Subtitles" +msgstr "Scaricamento sottotitoli" + +msgctxt "#30979" +msgid "Download path does not exist" +msgstr "Directory di scaricamento non esiste" diff --git a/plugin.video.mediathekview/resources/screenshot1.png b/plugin.video.mediathekview/resources/screenshot1.png Binary files differnew file mode 100644 index 0000000..cfee38d --- /dev/null +++ b/plugin.video.mediathekview/resources/screenshot1.png diff --git a/plugin.video.mediathekview/resources/screenshot2.png b/plugin.video.mediathekview/resources/screenshot2.png Binary files differnew file mode 100644 index 0000000..58c7d23 --- /dev/null +++ b/plugin.video.mediathekview/resources/screenshot2.png diff --git a/plugin.video.mediathekview/resources/screenshot3.png b/plugin.video.mediathekview/resources/screenshot3.png Binary files differnew file mode 100644 index 0000000..edec0c6 --- /dev/null +++ b/plugin.video.mediathekview/resources/screenshot3.png diff --git a/plugin.video.mediathekview/resources/screenshot4.png b/plugin.video.mediathekview/resources/screenshot4.png Binary files differnew file mode 100644 index 0000000..7f41e8b --- /dev/null +++ b/plugin.video.mediathekview/resources/screenshot4.png diff --git a/plugin.video.mediathekview/resources/screenshot5.png b/plugin.video.mediathekview/resources/screenshot5.png Binary files differnew file mode 100644 index 0000000..9e82c02 --- /dev/null +++ b/plugin.video.mediathekview/resources/screenshot5.png diff --git a/plugin.video.mediathekview/resources/settings.xml b/plugin.video.mediathekview/resources/settings.xml new file mode 100644 index 0000000..b50510a --- /dev/null +++ b/plugin.video.mediathekview/resources/settings.xml @@ -0,0 +1,23 @@ +<?xml version="1.0" encoding="utf-8" standalone="yes"?> +<settings> + <category label="30001"> + <setting id="firstrun" type="bool" default="true" visible="false" /> + <setting id="quality" type="bool" label="30110" default="true" /> + <setting id="nofuture" type="bool" label="30111" default="true" /> + <setting id="minlength" type="slider" label="30112" default="0" range="0,30" /> + <setting id="groupshows" type="bool" label="30113" default="true" /> + <setting id="downloadpath" type="folder" label="30114" source="auto" option="writeable" /> + </category> + <category label="30002"> + <setting id="dbtype" type="enum" label="30210" default="0" lvalues="30221|30222" /> + <setting id="dbhost" type="text" label="30211" default="localhost" visible="eq(-1,1)" /> + <setting id="dbuser" type="text" label="30212" default="filmliste" visible="eq(-2,1)" /> + <setting id="dbpass" type="text" label="30213" default="" option="hidden" visible="eq(-3,1)" /> + <setting id="dbdata" type="text" label="30214" default="filmliste" visible="eq(-4,1)" /> + <setting id="updenabled" type="bool" label="30231" default="true" /> + <setting id="updinterval" type="slider" label="30232" default="2" range="1,24" visible="eq(-1,true)" /> + <setting id="updxzbin" type="file" label="30233" default="" visible="eq(-2,true)" /> + + <!-- setting type="action" label="30238" action="RunScript(plugin.video.mediathekview, downloadreport)"/ --> + </category> +</settings> diff --git a/plugin.video.mediathekview/resources/sql/exportstruct.sh b/plugin.video.mediathekview/resources/sql/exportstruct.sh new file mode 100755 index 0000000..04c18a6 --- /dev/null +++ b/plugin.video.mediathekview/resources/sql/exportstruct.sh @@ -0,0 +1,3 @@ +#!/bin/bash +mysqldump -u root -p --add-drop-database --add-drop-table --events --routines --no-data --databases filmliste > filmliste-init-0.sql +sed -i'' -e 's/ AUTO_INCREMENT=[0-9]*//g' filmliste-init-0.sql diff --git a/plugin.video.mediathekview/resources/sql/filmliste-mysql-v1.sql b/plugin.video.mediathekview/resources/sql/filmliste-mysql-v1.sql new file mode 100644 index 0000000..341fb74 --- /dev/null +++ b/plugin.video.mediathekview/resources/sql/filmliste-mysql-v1.sql @@ -0,0 +1,454 @@ +-- MySQL dump 10.13 Distrib 5.7.20, for osx10.13 (x86_64) +-- +-- Host: localhost Database: filmliste +-- ------------------------------------------------------ +-- Server version 5.7.20 + +/*!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 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Current Database: `filmliste` +-- + +/*!40000 DROP DATABASE IF EXISTS `filmliste`*/; + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `filmliste` /*!40100 DEFAULT CHARACTER SET utf8 */; + +USE `filmliste`; + +-- +-- Table structure for table `channel` +-- + +DROP TABLE IF EXISTS `channel`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `channel` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `dtCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `touched` smallint(1) NOT NULL DEFAULT '1', + `channel` varchar(255) NOT NULL, + PRIMARY KEY (`id`), + KEY `channel` (`channel`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `film` +-- + +DROP TABLE IF EXISTS `film`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `film` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `dtCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `touched` smallint(1) NOT NULL DEFAULT '1', + `channelid` int(11) NOT NULL, + `showid` int(11) NOT NULL, + `title` varchar(255) NOT NULL, + `search` varchar(255) NOT NULL, + `aired` timestamp NULL DEFAULT NULL, + `duration` time DEFAULT NULL, + `size` int(11) DEFAULT NULL, + `description` longtext, + `website` varchar(384) DEFAULT NULL, + `url_sub` varchar(384) DEFAULT NULL, + `url_video` varchar(384) DEFAULT NULL, + `url_video_sd` varchar(384) DEFAULT NULL, + `url_video_hd` varchar(384) DEFAULT NULL, + `airedepoch` int(11) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `index_1` (`showid`,`title`), + KEY `index_2` (`channelid`,`title`), + KEY `dupecheck` (`channelid`,`showid`,`url_video`), + CONSTRAINT `FK_FilmChannel` FOREIGN KEY (`channelid`) REFERENCES `channel` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, + CONSTRAINT `FK_FilmShow` FOREIGN KEY (`showid`) REFERENCES `show` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `show` +-- + +DROP TABLE IF EXISTS `show`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `show` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `dtCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, + `touched` smallint(1) NOT NULL DEFAULT '1', + `channelid` int(11) NOT NULL, + `show` varchar(255) NOT NULL, + `search` varchar(255) NOT NULL, + PRIMARY KEY (`id`), + KEY `show` (`show`), + KEY `search` (`search`), + KEY `combined_1` (`channelid`,`search`), + KEY `combined_2` (`channelid`,`show`), + CONSTRAINT `FK_ShowChannel` FOREIGN KEY (`channelid`) REFERENCES `channel` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `status` +-- + +DROP TABLE IF EXISTS `status`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `status` ( + `modified` int(11) NOT NULL, + `status` varchar(255) NOT NULL, + `lastupdate` int(11) NOT NULL, + `filmupdate` int(11) NOT NULL, + `fullupdate` int(1) NOT NULL, + `add_chn` int(11) NOT NULL, + `add_shw` int(11) NOT NULL, + `add_mov` int(11) NOT NULL, + `del_chm` int(11) NOT NULL, + `del_shw` int(11) NOT NULL, + `del_mov` int(11) NOT NULL, + `tot_chn` int(11) NOT NULL, + `tot_shw` int(11) NOT NULL, + `tot_mov` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `status` +-- + +LOCK TABLES `status` WRITE; +/*!40000 ALTER TABLE `status` DISABLE KEYS */; +INSERT INTO `status` VALUES (0,'IDLE',0,0,0,0,0,0,0,0,0,0,0,0); +/*!40000 ALTER TABLE `status` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Dumping routines for database 'filmliste' +-- +/*!50003 DROP PROCEDURE IF EXISTS `ftInsertChannel` */; +/*!50003 SET @saved_cs_client = @@character_set_client */ ; +/*!50003 SET @saved_cs_results = @@character_set_results */ ; +/*!50003 SET @saved_col_connection = @@collation_connection */ ; +/*!50003 SET character_set_client = utf8 */ ; +/*!50003 SET character_set_results = utf8 */ ; +/*!50003 SET collation_connection = utf8_general_ci */ ; +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; +/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; +DELIMITER ;; +CREATE DEFINER=`root`@`localhost` PROCEDURE `ftInsertChannel`( + _channel VARCHAR(255) +) +BEGIN + DECLARE channelid_ INT(11); + DECLARE touched_ INT(1); + DECLARE added_ INT(1) DEFAULT 0; + + SELECT `id`, + `touched` + INTO channelid_, + touched_ + FROM `channel` + WHERE ( `channel`.`channel` = _channel ); + + IF ( channelid_ IS NULL ) THEN + INSERT INTO `channel` ( + `channel` + ) + VALUES ( + _channel + ); + SET channelid_ = LAST_INSERT_ID(); + SET added_ = 1; + ELSE + UPDATE `channel` + SET `touched` = 1 + WHERE ( `id` = channelid_ ); + END IF; + + SELECT channelid_ AS `id`, + added_ AS `added`; +END ;; +DELIMITER ; +/*!50003 SET sql_mode = @saved_sql_mode */ ; +/*!50003 SET character_set_client = @saved_cs_client */ ; +/*!50003 SET character_set_results = @saved_cs_results */ ; +/*!50003 SET collation_connection = @saved_col_connection */ ; +/*!50003 DROP PROCEDURE IF EXISTS `ftInsertFilm` */; +/*!50003 SET @saved_cs_client = @@character_set_client */ ; +/*!50003 SET @saved_cs_results = @@character_set_results */ ; +/*!50003 SET @saved_col_connection = @@collation_connection */ ; +/*!50003 SET character_set_client = utf8 */ ; +/*!50003 SET character_set_results = utf8 */ ; +/*!50003 SET collation_connection = utf8_general_ci */ ; +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; +/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; +DELIMITER ;; +CREATE DEFINER=`root`@`localhost` PROCEDURE `ftInsertFilm`( + _channelid INT(11), + _showid INT(11), + _title VARCHAR(255), + _search VARCHAR(255), + _aired TIMESTAMP, + _duration TIME, + _size INT(11), + _description LONGTEXT, + _website VARCHAR(384), + _url_sub VARCHAR(384), + _url_video VARCHAR(384), + _url_video_sd VARCHAR(384), + _url_video_hd VARCHAR(384), + _airedepoch INT(11) +) +BEGIN + DECLARE id_ INT; + DECLARE added_ INT DEFAULT 0; + + SELECT `id` + INTO id_ + FROM `film` AS f + WHERE ( f.channelid = _channelid ) + AND + ( f.showid = _showid ) + AND + ( f.url_video = _url_video ); + + IF ( id_ IS NULL ) THEN + INSERT INTO `film` ( + `channelid`, + `showid`, + `title`, + `search`, + `aired`, + `duration`, + `size`, + `description`, + `website`, + `url_sub`, + `url_video`, + `url_video_sd`, + `url_video_hd`, + `airedepoch` + ) + VALUES ( + _channelid, + _showid, + _title, + _search, + IF(_aired = "1980-01-01 00:00:00", NULL, _aired), + IF(_duration = "00:00:00", NULL, _duration), + _size, + _description, + _website, + _url_sub, + _url_video, + _url_video_sd, + _url_video_hd, + _airedepoch + ); + SET id_ = LAST_INSERT_ID(); + SET added_ = 1; + ELSE + UPDATE `film` + SET `touched` = 1 + WHERE ( `id` = id_ ); + END IF; + SELECT id_ AS `id`, + added_ AS `added`; +END ;; +DELIMITER ; +/*!50003 SET sql_mode = @saved_sql_mode */ ; +/*!50003 SET character_set_client = @saved_cs_client */ ; +/*!50003 SET character_set_results = @saved_cs_results */ ; +/*!50003 SET collation_connection = @saved_col_connection */ ; +/*!50003 DROP PROCEDURE IF EXISTS `ftInsertShow` */; +/*!50003 SET @saved_cs_client = @@character_set_client */ ; +/*!50003 SET @saved_cs_results = @@character_set_results */ ; +/*!50003 SET @saved_col_connection = @@collation_connection */ ; +/*!50003 SET character_set_client = utf8 */ ; +/*!50003 SET character_set_results = utf8 */ ; +/*!50003 SET collation_connection = utf8_general_ci */ ; +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; +/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; +DELIMITER ;; +CREATE DEFINER=`root`@`localhost` PROCEDURE `ftInsertShow`( + _channelid INT(11), + _show VARCHAR(255), + _search VARCHAR(255) +) +BEGIN + DECLARE showid_ INT(11); + DECLARE touched_ INT(1); + DECLARE added_ INT(1) DEFAULT 0; + + SELECT `id`, + `touched` + INTO showid_, + touched_ + FROM `show` + WHERE ( `show`.`channelid` = _channelid ) + AND + ( `show`.`show` = _show ); + + IF ( showid_ IS NULL ) THEN + INSERT INTO `show` ( + `channelid`, + `show`, + `search` + ) + VALUES ( + _channelid, + _show, + _search + ); + SET showid_ = LAST_INSERT_ID(); + SET added_ = 1; + ELSE + UPDATE `show` + SET `touched` = 1 + WHERE ( `id` = showid_ ); + END IF; + + + SELECT showid_ AS `id`, + added_ AS `added`; +END ;; +DELIMITER ; +/*!50003 SET sql_mode = @saved_sql_mode */ ; +/*!50003 SET character_set_client = @saved_cs_client */ ; +/*!50003 SET character_set_results = @saved_cs_results */ ; +/*!50003 SET collation_connection = @saved_col_connection */ ; +/*!50003 DROP PROCEDURE IF EXISTS `ftUpdateEnd` */; +/*!50003 SET @saved_cs_client = @@character_set_client */ ; +/*!50003 SET @saved_cs_results = @@character_set_results */ ; +/*!50003 SET @saved_col_connection = @@collation_connection */ ; +/*!50003 SET character_set_client = utf8 */ ; +/*!50003 SET character_set_results = utf8 */ ; +/*!50003 SET collation_connection = utf8_general_ci */ ; +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; +/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; +DELIMITER ;; +CREATE DEFINER=`root`@`localhost` PROCEDURE `ftUpdateEnd`( + _full INT(1) +) +BEGIN + DECLARE del_chn_ INT DEFAULT 0; + DECLARE del_shw_ INT DEFAULT 0; + DECLARE del_mov_ INT DEFAULT 0; + DECLARE cnt_chn_ INT DEFAULT 0; + DECLARE cnt_shw_ INT DEFAULT 0; + DECLARE cnt_mov_ INT DEFAULT 0; + + IF ( _full = 1 ) THEN + SELECT COUNT(*) + INTO del_chn_ + FROM `channel` + WHERE ( `touched` = 0 ); + + SELECT COUNT(*) + INTO del_shw_ + FROM `show` + WHERE ( `touched` = 0 ); + + SELECT COUNT(*) + INTO del_mov_ + FROM `film` + WHERE ( `touched` = 0 ); + + DELETE FROM `show` + WHERE ( `show`.`touched` = 0 ) + AND + ( ( SELECT SUM( `film`.`touched` ) FROM `film` WHERE `film`.`showid` = `show`.`id` ) = 0 ); + + DELETE FROM `film` + WHERE ( `touched` = 0 ); + ELSE + SET del_chn_ = 0; + SET del_shw_ = 0; + SET del_mov_ = 0; + END IF; + + SELECT del_chn_ AS `del_chn`, + del_shw_ AS `del_shw`, + del_mov_ AS `del_mov`, + cnt_chn_ AS `cnt_chn`, + cnt_shw_ AS `cnt_shw`, + cnt_mov_ AS `cnt_mov`; +END ;; +DELIMITER ; +/*!50003 SET sql_mode = @saved_sql_mode */ ; +/*!50003 SET character_set_client = @saved_cs_client */ ; +/*!50003 SET character_set_results = @saved_cs_results */ ; +/*!50003 SET collation_connection = @saved_col_connection */ ; +/*!50003 DROP PROCEDURE IF EXISTS `ftUpdateStart` */; +/*!50003 SET @saved_cs_client = @@character_set_client */ ; +/*!50003 SET @saved_cs_results = @@character_set_results */ ; +/*!50003 SET @saved_col_connection = @@collation_connection */ ; +/*!50003 SET character_set_client = utf8 */ ; +/*!50003 SET character_set_results = utf8 */ ; +/*!50003 SET collation_connection = utf8_general_ci */ ; +/*!50003 SET @saved_sql_mode = @@sql_mode */ ; +/*!50003 SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */ ; +DELIMITER ;; +CREATE DEFINER=`root`@`localhost` PROCEDURE `ftUpdateStart`( + _full INT(1) +) +BEGIN + DECLARE cnt_chn_ INT DEFAULT 0; + DECLARE cnt_shw_ INT DEFAULT 0; + DECLARE cnt_mov_ INT DEFAULT 0; + + IF ( _full = 1 ) THEN + UPDATE `channel` + SET `touched` = 0; + + UPDATE `show` + SET `touched` = 0; + + UPDATE `film` + SET `touched` = 0; + END IF; + + SELECT COUNT(*) + INTO cnt_chn_ + FROM `channel`; + + SELECT COUNT(*) + INTO cnt_shw_ + FROM `show`; + + SELECT COUNT(*) + INTO cnt_mov_ + FROM `film`; + + SELECT cnt_chn_ AS `cnt_chn`, + cnt_shw_ AS `cnt_shw`, + cnt_mov_ AS `cnt_mov`; +END ;; +DELIMITER ; +/*!50003 SET sql_mode = @saved_sql_mode */ ; +/*!50003 SET character_set_client = @saved_cs_client */ ; +/*!50003 SET character_set_results = @saved_cs_results */ ; +/*!50003 SET collation_connection = @saved_col_connection */ ; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!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 */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2018-01-03 16:26:35 diff --git a/plugin.video.mediathekview/resources/sql/filmliste-sqlite-v1.sql b/plugin.video.mediathekview/resources/sql/filmliste-sqlite-v1.sql new file mode 100644 index 0000000..8e7ee09 --- /dev/null +++ b/plugin.video.mediathekview/resources/sql/filmliste-sqlite-v1.sql @@ -0,0 +1,104 @@ +/* + Navicat Premium Data Transfer + + Source Server : Kodi MediathekView + Source Server Type : SQLite + Source Server Version : 3012001 + Source Database : main + + Target Server Type : SQLite + Target Server Version : 3012001 + File Encoding : utf-8 + + Date: 12/27/2017 23:56:51 PM +*/ + +PRAGMA foreign_keys = false; + +-- ---------------------------- +-- Table structure for channel +-- ---------------------------- +DROP TABLE IF EXISTS "channel"; +CREATE TABLE "channel" ( + "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + "dtCreated" integer(11,0) NOT NULL DEFAULT 0, + "touched" integer(1,0) NOT NULL DEFAULT 1, + "channel" TEXT(255,0) NOT NULL +); + +-- ---------------------------- +-- Table structure for film +-- ---------------------------- +DROP TABLE IF EXISTS "film"; +CREATE TABLE "film" ( + "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + "dtCreated" integer(11,0) NOT NULL DEFAULT 0, + "touched" integer(1,0) NOT NULL DEFAULT 1, + "channelid" INTEGER(11,0) NOT NULL, + "showid" INTEGER(11,0) NOT NULL, + "title" TEXT(255,0) NOT NULL, + "search" TEXT(255,0) NOT NULL, + "aired" integer(11,0), + "duration" integer(11,0), + "size" integer(11,0), + "description" TEXT(2048,0), + "website" TEXT(384,0), + "url_sub" TEXT(384,0), + "url_video" TEXT(384,0), + "url_video_sd" TEXT(384,0), + "url_video_hd" TEXT(384,0), + CONSTRAINT "FK_FilmShow" FOREIGN KEY ("showid") REFERENCES "show" ("id") ON DELETE CASCADE, + CONSTRAINT "FK_FilmChannel" FOREIGN KEY ("channelid") REFERENCES "channel" ("id") ON DELETE CASCADE +); + +-- ---------------------------- +-- Table structure for show +-- ---------------------------- +DROP TABLE IF EXISTS "show"; +CREATE TABLE "show" ( + "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + "dtCreated" integer(11,0) NOT NULL DEFAULT 0, + "touched" integer(1,0) NOT NULL DEFAULT 1, + "channelid" INTEGER(11,0) NOT NULL DEFAULT 0, + "show" TEXT(255,0) NOT NULL, + "search" TEXT(255,0) NOT NULL, + CONSTRAINT "FK_ShowChannel" FOREIGN KEY ("channelid") REFERENCES "channel" ("id") ON DELETE CASCADE +); + +-- ---------------------------- +-- Table structure for status +-- ---------------------------- +DROP TABLE IF EXISTS "status"; +CREATE TABLE "status" ( + "modified" integer(11,0), + "status" TEXT(32,0), + "lastupdate" integer(11,0), + "filmupdate" integer(11,0), + "fullupdate" integer(1,0), + "add_chn" integer(11,0), + "add_shw" integer(11,0), + "add_mov" integer(11,0), + "del_chm" integer(11,0), + "del_shw" integer(11,0), + "del_mov" integer(11,0), + "tot_chn" integer(11,0), + "tot_shw" integer(11,0), + "tot_mov" integer(11,0) +); + +-- ---------------------------- +-- Indexes structure for table film +-- ---------------------------- +CREATE INDEX "dupecheck" ON film ("channelid", "showid", "url_video"); +CREATE INDEX "index_1" ON film ("channelid", "title" COLLATE NOCASE); +CREATE INDEX "index_2" ON film ("showid", "title" COLLATE NOCASE); + +-- ---------------------------- +-- Indexes structure for table show +-- ---------------------------- +CREATE INDEX "category" ON show ("category"); +CREATE INDEX "search" ON show ("search"); +CREATE INDEX "combined_1" ON show ("channelid", "search"); +CREATE INDEX "combined_2" ON show ("channelid", "show"); + +PRAGMA foreign_keys = true; |