Habbo Project [Minimail Fix]

[x5Abrahamx5]

Add this code to your Database SQL
Goto:

You must be registered for see links

>login>GOTO your retro database>Click on where it says SQL then put in this code:
like this:

You must be registered for see links

CREATE TABLE IF NOT EXISTS `user_messages` (
`Id` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
`user` varchar(255) COLLATE latin1_general_ci NOT NULL,
`text` varchar(900) COLLATE latin1_general_ci DEFAULT NULL,
`username` text CHARACTER SET utf8,
`resolved` varchar(300) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

And if it's still not working then try adding the users code:

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) unsigned NOT NULL,
`username` varchar(50) NOT NULL,
`real_name` varchar(100) NOT NULL DEFAULT '',
`password` varchar(50) NOT NULL,
`mail` varchar(50) NOT NULL DEFAULT '[email protected]',
`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',
`volume` int(3) NOT NULL DEFAULT '100',
`accept_trading` enum('0','1') NOT NULL DEFAULT '1',
`seckey` varchar(999) NOT NULL,
`country` varchar(150) NOT NULL DEFAULT 'default.png',
`topdonator` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

And if THAT doesn't work then i don't know go ask the creators of the Project.


Extra code: (Alittle housekeeping fix)

CREATE TABLE IF NOT EXISTS `hk_issues` (
`id` int(5) unsigned NOT NULL,
`type` varchar(255) COLLATE latin1_general_ci NOT NULL,
`text` varchar(900) COLLATE latin1_general_ci DEFAULT NULL,
`username` text COLLATE latin1_general_ci,
`resolved` varchar(300) COLLATE latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=11 ;