For this to work delete your user table and or add this code in
PHP Code:
-- ----------------------------
-- 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(50) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT 'defaultuser@meth0d.org',
`auth_ticket` text NOT NULL,
`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 'hr-115-42.hd-190-1.ch-215-62.lg-285-91.sh-290-62',
`gender` enum('M','F') NOT NULL DEFAULT 'M',
`motto` varchar(50) 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 '0',
`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') NOT NULL DEFAULT '0',
`hide_inroom` enum('0','1') NOT NULL DEFAULT '0',
`mail_verified` varchar(6) NOT NULL DEFAULT '0',
`vip` enum('0','1') NOT NULL DEFAULT '0',
`points` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of users
-- ----------------------------
Also almost forgot
PHP Code:
--
-- Table structure for table `site_news`
--
CREATE TABLE IF NOT EXISTS `site_news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`seo_link` varchar(120) NOT NULL DEFAULT 'news-article',
`title` text NOT NULL,
`category_id` int(10) unsigned NOT NULL DEFAULT '1',
`topstory_image` text NOT NULL,
`body` text NOT NULL,
`snippet` text NOT NULL,
`datestr` varchar(50) NOT NULL,
`timestamp` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `site_news`
--
INSERT INTO `site_news` (`id`, `seo_link`, `title`, `category_id`, `topstory_image`, `body`, `snippet`, `datestr`, `timestamp`) VALUES
(1, 'welcome-to-bobbzo-hotel', 'Welcome to Bobbzo Hotel!', 1, 'http://127.0.0.1/images/ts/Bat_hulk_habbo.png', '<p>Hello and welcome to the brand new Bobbzo Hotel!</p>\r\n<p>Bobbzo Hotel opened a few years back but back then it was old and out dated. Now, we are back with UberCMS and PhoenixEMU so that we provide you with all the lastest Pets, Wired Furniture, Games, and many other in-game Items.</p>\r\n<p> </p>\r\n<p><strong>What will be happening in the near future?</strong></p>\r\n<p>Later this year I will planning quite a big Update within the Bobbzo System to provide you with an entirely secure site to ensure your safety and to keep you updated with Habbo Hotel''s latest features.</p>\r\n<p> </p>\r\n<p>Thanks,</p>\r\n<p>Unkn0wn, Sam & James</p>', 'What''s on the way?', '16-Jun-2011', 1308246943);
-- --------------------------------------------------------
Originally Posted by NeonCrayonz
