how to configure this cms? have you test it? lol ive never used pixeltimecms
Don't run that query if you want to keep your users, since that will drop the entire users table.Hi,
For the 'Dingo vdWeek' script, we have a SQL structure. Here is the Sql structure:
-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(50) NOT NULL,
`real_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(5000) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT '[email protected]',
`auth_ticket` text,
`rank` int(11) unsigned NOT NULL DEFAULT '1',
`credits` int(11) NOT NULL DEFAULT '50000',
`vip_points` int(11) NOT NULL DEFAULT '0',
`activity_points` int(11) NOT NULL DEFAULT '0',
`activity_points_lastupdate` double NOT NULL DEFAULT '0',
`look` varchar(255) NOT NULL DEFAULT 'sh-290-77.ch-210-66.hd-180-1.lg-270-78.hr-100-31',
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`account_created` varchar(50) NOT NULL,
`last_online` varchar(50) NOT NULL,
`online` enum('0','1') NOT NULL DEFAULT '0',
`ip_last` varchar(120) NOT NULL,
`ip_reg` varchar(120) NOT NULL,
`home_room` int(10) unsigned NOT NULL DEFAULT '536',
`respect` int(11) NOT NULL DEFAULT '0',
`daily_respect_points` int(11) NOT NULL DEFAULT '3',
`daily_pet_respect_points` int(11) NOT NULL DEFAULT '3',
`newbie_status` int(11) NOT NULL DEFAULT '0',
`is_muted` enum('0','1') NOT NULL DEFAULT '0',
`mutant_penalty` enum('0','1','2') NOT NULL DEFAULT '0',
`mutant_penalty_expire` int(11) NOT NULL DEFAULT '0',
`block_newfriends` enum('0','1') NOT NULL DEFAULT '0',
`hide_online` enum('0','1') DEFAULT '0',
`hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
`mail_verified` varchar(devil) NOT NULL DEFAULT '0',
`vip` enum('0','1') NOT NULL DEFAULT '0',
`volume` int(3) NOT NULL DEFAULT '100',
`account_twitter` varchar(225) DEFAULT NULL,
`account_msn` varchar(225) DEFAULT NULL,
`accept_trading` enum('0','1') NOT NULL DEFAULT '1',
`geheim_pass` varchar(50) NOT NULL DEFAULT '',
`home_bg` varchar(255) NOT NULL DEFAULT 'You must be registered for see links',
`home_text` varchar(999) NOT NULL,
`dj` enum('0','1') NOT NULL DEFAULT '0',
`dvdw` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=229 DEFAULT CHARSET=latin1;
With this SQL structure you can automatically fix that Script and the DeeJay Script!
100% Credits to: dingohotel.be
Greetz, DingoHotel
No, the catalogue is a self-made catalogue, we won't release it.