ALTER TABLE `config` ADD `vids_in_cat` SET( '0', '1' ) NOT NULL DEFAULT '0' AFTER `maj_htaccess` ; INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Charmix.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Mamarqueblanche.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Archivesexy.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Porn.fr', '', '0');
ALTER TABLE `config` ADD `index` SET( '0', '1' ) NOT NULL DEFAULT '0' AFTER `maj_htaccess` ; ALTER TABLE `config` ADD `search_cat` SET( '0', '1' ) NOT NULL DEFAULT '0' AFTER `index` ; ALTER TABLE `config` ADD `search_desc` SET( '0', '1' ) NOT NULL DEFAULT '0' AFTER `search_cat` ; ALTER TABLE `rss` CHANGE `categories` `categories` TEXT NOT NULL; DELETE FROM `liste` WHERE `nom` = 'Passix.com' AND `id` = 6; INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Guestvideos.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Hardeluxe.com', '', '0');
ALTER TABLE `config` ADD `analytics` VARCHAR( 20 ) NOT NULL AFTER `titre_page`; ALTER TABLE `config` ADD `to_www` SET( '0', '1' ) NOT NULL DEFAULT '1' AFTER `url_erreur` ; ALTER TABLE `rss` ADD INDEX ( `sponsor` ); UPDATE `liste` SET `nom` = 'Dvdx.tv', `url` = '' WHERE `id` = 14; DELETE FROM `liste` WHERE `nom` = 'Videocochon.com' AND `id` = 13; INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Video-hentai.tv', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Gaycash.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Cinehard.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Gay.biz', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Masculin.tv', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Venusbiz.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Evolucash.com', '', '0');
ALTER TABLE `config` ADD `url_site` VARCHAR( 100 ) NOT NULL AFTER `path_html`; ALTER TABLE `config` ADD `template` VARCHAR( 25 ) NOT NULL AFTER `email`; ALTER TABLE `top` CHANGE `video` `video` INT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `top` CHANGE `clicks` `clicks` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `search_top` CHANGE `n` `n` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `search_top` CHANGE `res` `res` SMALLINT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `click` CHANGE `idvideo` `idvideo` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `click` CHANGE `sp` `sp` TINYINT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `click` CHANGE `click` `click` SMALLINT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `aff` CHANGE `in` `in` MEDIUMINT UNSIGNED NOT NULL DEFAULT '0'; ALTER TABLE `rss` CHANGE `id` `id` INT UNSIGNED NOT NULL AUTO_INCREMENT; UPDATE `config` SET `template` = 'page_defaut.tpl'; INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Dvd-explorer.com', '', '0');
ALTER TABLE `liste` DROP `break`; INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Videos-colmax.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Videos-play.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Hentai-francais.com', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `url` , `actif` ) VALUES ('', 'Totale-defonce.com', '', '0');
DROP TABLE `search_top`; CREATE TABLE `search_top` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` VARCHAR( 40 ) NOT NULL DEFAULT '', `n` MEDIUMINT NOT NULL, `res` smallint(6) NOT NULL, PRIMARY KEY (`id`) ) TYPE = MYISAM ;
ALTER TABLE `search_top` ADD `res` SMALLINT NOT NULL AFTER `n` ;
ALTER TABLE `cat` ADD `meta` VARCHAR( 250 ) NOT NULL AFTER `valeur` ; INSERT INTO `liste` ( `id` , `nom` , `break` , `url` , `actif` ) VALUES ('', 'Wendise.com', ',', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `break` , `url` , `actif` ) VALUES ('', 'Films-amateurs.tv', ',', '', '0'); CREATE TABLE `search_top` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` VARCHAR( 40 ) NOT NULL DEFAULT '', `n` MEDIUMINT NOT NULL, PRIMARY KEY (`id`) ) TYPE = MYISAM ;
ALTER TABLE `rss` CHANGE `thumb2` `thumb2` VARCHAR( 100 ) NOT NULL; INSERT INTO `liste` ( `id` , `nom` , `break` , `url` , `actif` ) VALUES ('', 'Video-mature.tv', ',', '', '0'); INSERT INTO `liste` ( `id` , `nom` , `break` , `url` , `actif` ) VALUES ('', 'Carpediem.fr', ',', '', '0');
CREATE TABLE `liste` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `nom` varchar(40) NOT NULL DEFAULT '', `break` varchar(5) NOT NULL DEFAULT '', `url` varchar(140) NOT NULL DEFAULT '', `actif` SET('0','1') NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- Contenu de la table `liste` -- INSERT INTO `liste` VALUES (1, 'Webfric.com', ',', '', '1'); INSERT INTO `liste` VALUES (3, 'Sexedenfer.com', '|', '', '1'); INSERT INTO `liste` VALUES (4, 'Films-x.tv', ',', '', '1'); INSERT INTO `liste` VALUES (5, 'Vidsatomix.com', ',', '', '1'); INSERT INTO `liste` VALUES (6, 'Passix.com', ',', '', '0'); INSERT INTO `liste` VALUES (7, 'Tvsexe.tv', ',', '', '0'); INSERT INTO `liste` VALUES (8, 'Archivegay.com', '|', '', '1'); INSERT INTO `liste` VALUES (9, 'Smartmovies.net', ',', '', '1'); INSERT INTO `liste` VALUES (10, 'Bandez.com', ',', '', '1'); INSERT INTO `liste` VALUES (11, 'Ca-dechire.com', ',', '', '0'); INSERT INTO `liste` VALUES (12, 'Creasexe.com', ',', '', '1'); INSERT INTO `liste` VALUES (13, 'Videocochon.com', ',', '', '0'); INSERT INTO `liste` VALUES (14, 'Xponsor.com', ',', '', '0'); INSERT INTO `liste` VALUES (15, 'Xtapas.com', ',', '', '0');
-- -- Structure de la table `aff` -- CREATE TABLE `aff` ( `id` int(11) NOT NULL AUTO_INCREMENT, `in` int(11) NOT NULL DEFAULT '0', `date` date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Structure de la table `click` -- CREATE TABLE `click` ( `id` int(11) NOT NULL AUTO_INCREMENT, `idvideo` mediumint(9) NOT NULL DEFAULT '0', `sp` mediumint(9) NOT NULL DEFAULT '0', `click` mediumint(9) NOT NULL DEFAULT '0', `date` date NOT NULL DEFAULT '0000-00-00', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -------------------------------------------------------- -- -- Structure de la table `top` -- CREATE TABLE `top` ( `id` int(11) NOT NULL AUTO_INCREMENT, `video` mediumint(9) NOT NULL DEFAULT '0', `clicks` mediumint(9) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) TYPE=MyISAM ;
Voila, la mise à jour est finie !
CREATE TABLE `liste` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `nom` varchar(40) NOT NULL DEFAULT '', `logo` varchar(80) NOT NULL DEFAULT '', `break` varchar(5) NOT NULL DEFAULT '', `actif` SET('0','1') NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=15 ; -- -- Contenu de la table `liste` -- INSERT INTO `liste` VALUES (1, 'Webfric.com', '', ',', '1'); INSERT INTO `liste` VALUES (3, 'Sexedenfer.com', '', '|', '1'); INSERT INTO `liste` VALUES (4, 'Films-x.tv', '', ',', '1'); INSERT INTO `liste` VALUES (5, 'Vidsatomix.com', '', ',', '1'); INSERT INTO `liste` VALUES (6, 'Passix.com', '', ',', '1'); INSERT INTO `liste` VALUES (7, 'Tvsexe.tv', '', ',', '0'); INSERT INTO `liste` VALUES (8, 'Gaystage.com', '', ',', '0'); INSERT INTO `liste` VALUES (9, 'Smartmovies.net', '', ',', '0'); INSERT INTO `liste` VALUES (10, 'Bandez.com', '', ',', '1'); INSERT INTO `liste` VALUES (11, 'Ca-dechire.com', '', ',', '0'); INSERT INTO `liste` VALUES (12, 'Creasexe.com', '', ',', '1'); INSERT INTO `liste` VALUES (13, 'Videocochon.com', '', ',', '0'); INSERT INTO `liste` VALUES (14, 'Xponsor.com', '', ',', '0');
Voila, la mise à jour est finie !
CREATE TABLE `liste` ( `id` mediumint(9) NOT NULL AUTO_INCREMENT, `nom` varchar(40) NOT NULL DEFAULT '', `logo` varchar(80) NOT NULL DEFAULT '', `break` varchar(5) NOT NULL DEFAULT '', `actif` SET('0','1') NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=13 ; -- -- Contenu de la table `liste` -- INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (1, 'Webfric.com', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (3, 'Sexedenfer.com', '', '|', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (4, 'Films-x.tv', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (5, 'Vidsatomix.com', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (6, 'Passix.com', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (7, 'Tvsexe.tv', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (8, 'Gaystage.com', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (9, 'Smartmovies.net', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (10, 'Bandez.com', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (11, 'Ca-dechire.com', '', ',', '1'); INSERT INTO `liste` (`id`, `nom`, `logo`, `break`, `actif`) VALUES (12, 'Creasexe.com', '', ',', '1');
CREATE TABLE `search_ban` ( `id` int(11) NOT NULL AUTO_INCREMENT, `key` varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=16 ; -- -- Contenu de la table `search_ban` -- INSERT INTO `search_ban` (`id`, `key`) VALUES (9, 'illégal'); INSERT INTO `search_ban` (`id`, `key`) VALUES (4, 'enfant'); INSERT INTO `search_ban` (`id`, `key`) VALUES (5, 'mineur'); INSERT INTO `search_ban` (`id`, `key`) VALUES (6, 'garcon'); INSERT INTO `search_ban` (`id`, `key`) VALUES (7, 'fille'); INSERT INTO `search_ban` (`id`, `key`) VALUES (8, 'mineur'); INSERT INTO `search_ban` (`id`, `key`) VALUES (10, 'viol'); INSERT INTO `search_ban` (`id`, `key`) VALUES (11, '13'); INSERT INTO `search_ban` (`id`, `key`) VALUES (12, '14'); INSERT INTO `search_ban` (`id`, `key`) VALUES (13, '15'); INSERT INTO `search_ban` (`id`, `key`) VALUES (14, '17'); INSERT INTO `search_ban` (`id`, `key`) VALUES (15, '16');