Accueil
Forum
Download
Livre d'or
Contact
Liens Web
|
Accueil
Forum
Download
Livre d'or
Contact
Liens Web
|
Forum :
Masquer l’entête
|
Accès rapide :
|
|
Effectuer une Recherche avancée OU |
Module Blog [11 réponses]
jeudi 18 novembre 2010 à 10:03
jeudi 18 novembre 2010 à 12:38 
Veuillez patientez, la recherche est en cours...
)
<?php #####!!!#####-- $Id: install.sql 999 2010-11-18 07:54:35Z nico@rdennes $DROP TABLE IF EXISTS `Blogs`;CREATE TABLE IF NOT EXISTS `blogs` `id` int(10) NOT NULL auto_increment, `cat` tinyint(3) NOT NULL default '1', `user_id` int(10) NOT NULL, `pseudo` char(50) NOT NULL, `id_submitter` int(10) NOT NULL, `submitter` char(50) NOT NULL, `id_modif` int(10) NOT NULL, `user_modif` char(50) NOT NULL, `email` char(100) NOT NULL, `website` char(100) NOT NULL, `titre` char(150) NOT NULL, `titre_seo` char(150) NOT NULL, `sstitre` char(150) NOT NULL, `chapo` text NOT NULL, `billet` longtext NOT NULL, `source` varchar(255) NOT NULL, `otherslinks` text NOT NULL, `notes` varchar(255) NOT NULL, `youtube` char(50) NOT NULL, `dailymotion` char(50) NOT NULL, `xdate` datetime NOT NULL default '0000-00-00 00:00:00', `xdate_modif` datetime NOT NULL, `ip` char(15) NOT NULL, `hits` int(100) NOT NULL default '0', `inhome` tinyint(1) NOT NULL default '1', `allowcomments` tinyint(1) NOT NULL default '1', `allowcomm_ano` tinyint(1) NOT NULL default '1', `allowtrackbacks` tinyint(1) NOT NULL default '1', `mailcomment` tinyint(1) NOT NULL default '1', `comments` int(11) NOT NULL, `trackbacks` int(11) NOT NULL, `pdf` tinyint(1) NOT NULL default '1', `friend` tinyint(1) NOT NULL default '1', `print` tinyint(1) NOT NULL default '1', `language` char(50) NOT NULL, `video` tinyint(1) NOT NULL default '1', `description` varchar(255) NOT NULL, `keywords` varchar(255) NOT NULL, `xchapo` tinyint(1) NOT NULL default '0', `tags` tinyint(1) NOT NULL default '0', `active` tinyint(1) NOT NULL default '1', `view` tinyint(1) NOT NULL, `groups` text NOT NULL, `draft` tinyint(1) NOT NULL default '0', `trash` tinyint(1) NOT NULL default '0', `waiting` tinyint(1) NOT NULL default '1', `old_billet` tinyint(1) NOT NULL, PRIMARY KEY (`id`), KEY `active` (`active`), KEY `inhome` (`inhome`), KEY `draft` (`draft`), KEY `trash` (`trash`), KEY `xdate` (`xdate`), KEY `user_id` (`user_id`), CREATE TABLE IF NOT EXISTS `blogs_categories` ( `catid` int(11) NOT NULL auto_increment, `title` char(50) NOT NULL, `description` text NOT NULL, `parentid` int(11) NOT NULL default '0', `inhome` tinyint(1) NOT NULL default '1', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`catid`), KEY `inhome` (`inhome`), KEY `active` (`active`) INSERT INTO `blogs_categories` (`catid`, `title`, `description`, `parentid`, `inhome`, `active`) VALUES(1, 'Blog', 'Mon premier blog', 0, 1, 1),(2, 'Site internet', 'Mon premier site internet', 0, 1, 1) ");INSERT INTO `blogs_categories` (`catid`, `title`, `description`, `parentid`, `inhome`, `active`) VALUES(1, 'Blog', 'Mon premier blog', 0, 1, 1),(2, 'Site internet', 'Mon premier site internet', 0, 1, 1) ");CREATE TABLE IF NOT EXISTS `blogs_comments` ( `cid` int(10) NOT NULL auto_increment, `bid` int(10) NOT NULL default '0', `cat` tinyint(3) NOT NULL default '1', `user_id` int(11) NOT NULL, `pseudo` char(50) NOT NULL, `email` char(50) NOT NULL, `website` char(50) NOT NULL, `comment` text NOT NULL, `xdate` datetime default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', `trash` tinyint(1) NOT NULL default '0', `ip` char(15) NOT NULL, PRIMARY KEY (`cid`), KEY `bid` (`bid`))");CREATE TABLE IF NOT EXISTS `blogs_config` `config_name` char(20) NOT NULL, `config_value` char(10) NOT NULL, UNIQUE KEY `config_name` (`config_name`)INSERT INTO `blogs_config` (`config_name`, `config_value`) VALUES('b_draft', '1'),('b_active', '0'),('b_home', '1'),('b_allowcomment', '1'),('b_allowcomment_ano', '1'),('b_validcomments', '1'),('b_allowtrackbacks', '0'),('b_mailcomment', '1'),('b_chapo', '1'),('b_tags', '1'),('b_pdf', '1'),('b_friend', '1'),('b_print', '1'),('b_video', '0'),('RSS', '1'),('ATOM', '1'),('RSSC', '1'),('ATOMC', '1'),('rss_number', '20'),('atom_number', '15'),('rssc_number', '9'),('atomc_number', '10'),('who_submit', '1'),('who_errorbillet', '2'),('who_errorcomm', '2'),('box_calendar', '1'),('box_search', '1'),('box_categories', '1'),('box_archives', '1'),('box_links', '1'),('box_rss', '1'),('billets_home', '5'),('billets_cat', '8'),('billets_search', '10'),('pag_home', 'right'),('pag_cat', 'right'),('pag_search', 'center'),('col_homepage', 'right'),('box_comm', '1'),('fckeditor', '1'),('box_tags', '1'),('cache', '0'),('page_calendar', '1'),('page_mybillets', '1'),('page_populaire', '1'),('page_allcategories', '1'),('page_annuaire', '1'),('mail_newbillet', '1'),('mail_editbillet', '1') ");CREATE TABLE IF NOT EXISTS `blogs_definitions` ( `did` int(11) NOT NULL auto_increment, `words` char(50) NOT NULL, `definition` char(200) NOT NULL, `letter` char(1) NOT NULL, `actif` tinyint(1) NOT NULL default '0', PRIMARY KEY (`did`), KEY `words` (`words`), KEY `letter` (`letter`), KEY `actif` (`actif`))");CREATE TABLE IF NOT EXISTS `blogs_errors` ( `eid` int(10) NOT NULL auto_increment, `bid` int(10) NOT NULL default '0', `cat` tinyint(3) NOT NULL default '1', `user_id` int(11) NOT NULL, `pseudo` char(50) NOT NULL, `email` char(50) NOT NULL, `website` char(50) NOT NULL, `comment` text NOT NULL, `xdate` datetime default '0000-00-00 00:00:00', `active` tinyint(1) NOT NULL default '1', `trash` tinyint(1) NOT NULL default '0', `ip` char(15) NOT NULL, PRIMARY KEY (`eid`))");CREATE TABLE IF NOT EXISTS `blogs_links` ( `lid` int(11) NOT NULL auto_increment, `links` char(60) NOT NULL, `site` char(40) NOT NULL, `description` text NOT NULL, `inhome` tinyint(1) NOT NULL default '1', `xdate` datetime NOT NULL, `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`lid`), KEY `inhome` (`inhome`), KEY `active` (`active`))");CREATE TABLE IF NOT EXISTS `blogs_logs` ( `lo` int(11) NOT NULL auto_increment, `user_id` int(10) NOT NULL, `pseudo` char(50) NOT NULL, `table` char(50) NOT NULL, `xkey` char(50) NOT NULL, `logs` char(50) NOT NULL, `ip` char(15) NOT NULL, `xdate` datetime NOT NULL, PRIMARY KEY (`lo`))");CREATE TABLE IF NOT EXISTS `blogs_pages` ( `pid` int(11) NOT NULL auto_increment, `pagename` char(50) NOT NULL, `titre` char(100) NOT NULL, `titre_seo` char(100) NOT NULL, `sstitre` char(100) NOT NULL, `texte` text NOT NULL, `description` varchar(255) NOT NULL, `keywords` varchar(255) NOT NULL, `who` char(50) NOT NULL, `xdate` datetime NOT NULL, `inmenu` tinyint(1) NOT NULL default '1', `active` tinyint(1) NOT NULL default '1', PRIMARY KEY (`pid`), KEY `inhome` (`inmenu`), KEY `active` (`active`))");CREATE TABLE IF NOT EXISTS `".$prefix_install."_blogs_prevention` ( `config_name` char(20) NOT NULL, `config_value` text NOT NULL, UNIQUE KEY `config_name` (`config_name`))");INSERT INTO `blogs_prevention` (`config_name`, `config_value`) VALUES('bad_words', 'http:'),('bad_urls', ''),('bad_users', ''),('bad_ips', ''),('bad_emails', '@mail.ru\r\
\r\
'),('bad_web', ''),('akismet', '')");CREATE TABLE IF NOT EXISTS `blogs_trackbacks` ( `ping_id` int(11) NOT NULL auto_increment, `post_id` int(11) NOT NULL default '0', `ping_url` varchar(255) NOT NULL default '0', `ping_date` datetime NOT NULL, PRIMARY KEY (`ping_id`), KEY `post_id` (`post_id`))");CREATE TABLE IF NOT EXISTS `blogs_users` ( `rid` int(10) NOT NULL auto_increment, `user_id` int(10) NOT NULL, `username` char(50) NOT NULL, `adjoint` tinyint(1) NOT NULL default '0', `redacteur` tinyint(1) NOT NULL default '0', `editeur` tinyint(1) NOT NULL default '0', PRIMARY KEY (`rid`), KEY `user_id` (`user_id`), KEY `username` (`username`))");INSERT INTO `blogs_users` (`rid`, `user_id`, `username`, `adjoint`, `redacteur`, `editeur`) VALUES(1, '".$cookie[0]."', '".$cookie[1]."', 1, 0, 0)");#####!!!#####?>
jeudi 18 novembre 2010 à 17:36
Module Blog [11 réponses]
2.0 ©2006-2026