|
Usuario Activo
Fecha de ingreso: 02/oct/2010
|
- POSTEADO POR WAO -
Cita:
|
Iniciado por Coke
imposible sin el codigo y la estructura de la base de datos...
|
Que codigo se refiere?, no falta ningun codigo, incluyen todos los archivos y bases de datos, no son modificaciones ni script ripeados, son script originales.
Cita:
--
-- Table structure for table `comments`
--
CREATE TABLE `comments` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(128) collate utf8_unicode_ci NOT NULL default '',
`email` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`website` varchar(255) collate utf8_unicode_ci NOT NULL default '',
`body` text collate utf8_unicode_ci NOT NULL,
`parentid` int(11) NOT NULL DEFAULT '0',
`dt` timestamp NOT NULL default CURRENT_TIMESTAMP,
`approval` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`hash` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Table structure for table `comment_config`
--
CREATE TABLE `comment_config` (
`user` varchar(128) NOT NULL DEFAULT 'admin',
`pass` varchar(255) NOT NULL DEFAULT 'password',
`admin_email` varchar(255) NOT NULL DEFAULT 'your@email.com',
`approval` tinyint(1) NOT NULL DEFAULT '0',
`approval_email` tinyint(1) NOT NULL DEFAULT '0',
`replies` tinyint(1) NOT NULL DEFAULT '1',
`sort` varchar(4) NOT NULL DEFAULT 'ASC',
`rate` tinyint(1) NOT NULL DEFAULT '0',
`rate_reveal` tinyint(1) NOT NULL DEFAULT '1',
`word_filter` tinytext,
`name` tinyint(1) NOT NULL DEFAULT '1',
`email` tinyint(1) NOT NULL DEFAULT '1',
`website` tinyint(1) NOT NULL DEFAULT '0',
`body` tinyint(1) NOT NULL DEFAULT '1',
`spam_protect` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Table structure for table `comment_ratings`
--
CREATE TABLE `comment_ratings` (
`comment_id` int(10) unsigned NOT NULL,
`rate_value` tinyint(1) NOT NULL,
`user_ip` int(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
INSERT INTO `comment_config` (`user`,`pass`,`admin_email`,`approval`,
`approval_email`,`replies`,`sort`,`rate`,`rate_reveal`,`word_filter`,`name`,`email`,
`website`,`body`,`spam_protect`)
VALUES
('admin', 'password', 'your@email.com', 0, 0, 1, 'ASC', 0, 1, 'shit fuck', 1, 1, 0, 1, 0);
|
Cita:
CREATE TABLE IF NOT EXISTS `wcddl_blacklist` (
`url` varchar(255) NOT NULL,
PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_config` (
`config_name` varchar(200) NOT NULL,
`config_val` text NOT NULL,
`config_group` varchar(30) NOT NULL default 'misc',
PRIMARY KEY (`config_name`),
KEY `config_group` (`config_group`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_downloads` (
`id` int(11) NOT NULL auto_increment,
`sid` int(5) NOT NULL,
`title` varchar(200) NOT NULL,
`type` varchar(20) NOT NULL,
`url` text NOT NULL,
`dat` varchar(15) NOT NULL,
`views` int(5) NOT NULL,
`rating` int(5) NOT NULL,
PRIMARY KEY (`id`),
KEY `sid` (`sid`,`title`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ;
CREATE TABLE IF NOT EXISTS `wcddl_queue` (
`id` int(11) NOT NULL auto_increment,
`sid` int(5) NOT NULL,
`title` varchar(200) NOT NULL,
`type` varchar(20) NOT NULL,
`url` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
CREATE TABLE IF NOT EXISTS `wcddl_recents` (
`query` varchar(200) NOT NULL,
`searches` int(5) NOT NULL,
PRIMARY KEY (`query`),
KEY `searches` (`searches`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `wcddl_sites` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(200) NOT NULL,
`url` text NOT NULL,
`email` varchar(200) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
CREATE TABLE IF NOT EXISTS `wcddl_whitelist` (
`url` varchar(255) NOT NULL,
PRIMARY KEY (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|
El autor del script de comentarios posteo esto...
* Added support for multiple pages (MySQL Table update required) Run this following query in your MySQL database manager: ALTER TABLE comments ADD pageid int(10) NOT NULL DEFAULT 0
Read the documentation for more on page defining |