Can't wait to try this, i have not messed around with Habbo servers in 2 years, Looks like an amazing release THANKS a lot
EDIT:
WELLLLLLLLL, no luck every time i try to execute the sql i get two problems
Problem 1. the items part of the sql says there is an error at the end of the script
-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
`id` int(10) unsigned NOT NULL,
`user_id` int(10) NOT NULL,
`room_id` int(10) unsigned NOT NULL DEFAULT '0',
`base_item` int(10) unsigned NOT NULL,
`extra_data` text NOT NULL,
`x` int(11) NOT NULL DEFAULT '0',
`y` int(11) NOT NULL DEFAULT '0',
`z` double NOT NULL DEFAULT '0',
`rot` int(11) NOT NULL DEFAULT '0',
`wall_pos` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`) USING BTREE,
KEY `userid` (`user_id`) USING BTREE,
KEY `roomid` (`room_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; ~~~~ Somewhere Here (ive tried almost everything)
Problem 2. the permissions users part of the sql gives me an error at the end of the script as well
-- ----------------------------
-- Table structure for `permissions_users`
-- ----------------------------
DROP TABLE IF EXISTS `permissions_users`;
CREATE TABLE `permissions_users` (
`userid` int(11) unsigned NOT NULL,
`cmd_update_permissions` enum('1','0') NOT NULL,
`cmd_update_settings` enum('1','0') NOT NULL,
`cmd_update_bots` enum('1','0') NOT NULL,
`cmd_update_catalogue` enum('1','0') NOT NULL,
`cmd_update_navigator` enum('1','0') NOT NULL,
`cmd_update_items` enum('1','0') NOT NULL,
`cmd_award` enum('1','0') NOT NULL,
`cmd_coords` enum('1','0') NOT NULL,
`cmd_override` enum('1','0') NOT NULL,
`cmd_coins` enum('1','0') NOT NULL,
`cmd_pixels` enum('1','0') NOT NULL,
`cmd_ha` enum('1','0') NOT NULL,
`cmd_hal` enum('1','0') NOT NULL,
`cmd_freeze` enum('1','0') NOT NULL,
`cmd_enable` enum('1','0') NOT NULL,
`cmd_roommute` enum('1','0') NOT NULL,
`cmd_setspeed` enum('1','0') NOT NULL,
`cmd_masscredits` enum('1','0') NOT NULL,
`cmd_globalcredits` enum('1','0') NOT NULL,
`cmd_roombadge` enum('1','0') NOT NULL,
`cmd_massbadge` enum('1','0') NOT NULL,
`cmd_userinfo` enum('1','0') NOT NULL,
`cmd_shutdown` enum('1','0') NOT NULL,
`cmd_givebadge` enum('1','0') NOT NULL,
`cmd_invisible` enum('1','0') NOT NULL,
`cmd_ban` enum('1','0') NOT NULL,
`cmd_superban` enum('1','0') NOT NULL,
`cmd_roomkick` enum('1','0') NOT NULL,
`cmd_roomalert` enum('1','0') NOT NULL,
`cmd_mute` enum('1','0') NOT NULL,
`cmd_unmute` enum('1','0') NOT NULL,
`cmd_alert` enum('1','0') NOT NULL,
`cmd_motd` enum('1','0') NOT NULL,
`cmd_kick` enum('1','0') NOT NULL,
`cmd_update_filter` enum('1','0') NOT NULL,
`acc_anyroomrights` enum('1','0') NOT NULL,
`acc_anyroomowner` enum('1','0') NOT NULL,
`acc_supporttool` enum('1','0') NOT NULL,
`acc_chatlogs` enum('1','0') NOT NULL,
`acc_enter_fullrooms` enum('1','0') NOT NULL,
`acc_enter_anyroom` enum('1','0') NOT NULL,
`acc_restrictedrooms` enum('1','0') NOT NULL,
`acc_unkickable` enum('1','0') NOT NULL,
`acc_unbannable` enum('1','0') NOT NULL,
`cmd_removebadge` enum('1','0') NOT NULL DEFAULT '0',
`cmd_summon` enum('1','0') NOT NULL DEFAULT '0',
`cmd_update_bans` enum('1','0') NOT NULL DEFAULT '0',
`cmd_masspixels` enum('1','0') NOT NULL DEFAULT '0',
`cmd_globalpixels` enum('1','0') NOT NULL DEFAULT '0',
`cmd_sa` enum('1','0') NOT NULL DEFAULT '0',
`receive_sa` enum('1','0') NOT NULL DEFAULT '0',
`cmd_ipban` enum('1','0') NOT NULL DEFAULT '0',
`floodtime` int(3) NOT NULL DEFAULT '30',
`cmd_spull` enum('1','0') NOT NULL DEFAULT '0',
`cmd_disconnect` enum('1','0') NOT NULL DEFAULT '0',
`cmd_update_achievements` enum('1','0') NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`),
UNIQUE KEY `userid` (`userid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8; ~~~~~~ Somewhere around here
Anybody have this problem?
EDIT 2!!!!: Ive finally figured it out after five hours it because it was trying to make one field a primary and unique id, and it made me do that manually