andig/videodb — pull request #14 by devloic (2013-07-06 05:28:33+00:00)
Title: new JSON based engines (filmstarts.de, sensacine.com, allocine.fr), solves lookup problem with nexgen, genres become multilingual, solves spanish html entities problem on search form

requires to update database .

INSERT INTO `videodbfork`.`videodb_config` (`opt`, `value`) VALUES ('enginesensacine', '');
INSERT INTO `videodbfork`.`videodb_config` (`opt`, `value`) VALUES ('enginefilmstarts', '');

truncate videodb_genres and run:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

CREATE TABLE IF NOT EXISTS `videodb_genres` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`name_de` varchar(255) NOT NULL,
`name_fr` varchar(255) NOT NULL,
`name_es` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=114 ;

INSERT INTO `videodb_genres` (`id`, `name`, `name_de`, `name_fr`, `name_es`) VALUES
(1, 'Action', 'Action', 'Action', 'Acción'),
(2, 'Adventure', 'Abenteuer', 'Aventure', 'Aventura'),
(3, 'Animation', 'Animation', 'Animation', 'Animación'),
(4, 'Comedy', 'Komödie', 'Comédie', 'Comedia'),
(5, 'Crime', 'Krimi', 'Policier', 'Crimen'),
(6, 'Documentary', 'Dokumentarfilm', 'Documentaire', 'Documental'),
(7, 'Drama', 'Drama', 'Drame', 'Drama'),
(8, 'Family', 'Familienfilm', 'Famille', 'Familia'),
(9, 'Fantasy', 'Fantasy', 'Fantastique', 'Fantasía'),
(10, 'Film-Noir', 'Film noir', 'Film noir', 'Cine negro'),
(11, 'Horror', 'Horror', 'Epouvante-horreur', 'Terror'),
(12, 'Musical', 'Musical', 'Comédie musicale', 'Comedia musical'),
(13, 'Mystery', 'Mysteryfilm', 'Mistère', 'Misterio'),
(14, 'Romance', 'Romanze', 'Romance', 'Romántico'),
(15, 'Sci-Fi', 'Science fiction', 'Science fiction', 'Ciencia ficción'),
(16, 'Short', 'Kurzfilm', 'Court métrage', 'Cortometraje '),
(17, 'Thriller', 'Thriller', 'Thriller', 'Suspense'),
(18, 'War', 'Kriegfilm', 'Guerre', 'Guerra'),
(19, 'Western', 'Western', 'Western', 'Western'),
(20, 'Adult', 'Erwachsen', 'Adulte', 'Adulto'),
(21, 'Music', 'Musik', 'Musical', 'Musical'),
(22, 'Biography', 'Biografie', 'Biopic', 'Biografía'),
(23, 'History', 'Geschichte', 'Historique', 'Histórico'),
(24, 'Sport', 'Sport', 'Sport', 'Deporte'),
(101, 'Martial Arts', 'Martial Arts', 'Arts Martiaux', 'Artes Marciales'),
(102, 'Bollywood', 'Bollywood', 'Bollywood', 'Bollywood'),
(103, 'Classics', 'Klassiker', 'Classique', 'Clásico'),
(104, 'Tragicomedy', 'Tragikomödie', 'Comédie dramatique', 'Comedia dramática'),
(105, 'Concert', 'Konzert', 'Concert', 'Concierto'),
(106, 'Divers', 'Unbekannt', 'Unknown', 'Desconocido'),
(107, 'Erotic', 'Erotik', 'Erotique', 'Erótico'),
(108, 'Espionage', 'Spionage', 'Espionnage', 'Espionaje'),
(109, 'Experimental', 'Experimentalfilm', 'Expérimental', 'Experimental'),
(110, 'Judiciary', 'Gericht', 'Judiciaire', 'Judicial'),
(111, 'Opera', 'Opera', 'Opera', 'Opera'),
(112, 'Epic', 'Monumentalfilm', 'Péplum', 'Épico'),
(113, 'Show', 'Show', 'Show', 'Show');