It does exist in the furniture and catalog items table, still getting error.Check if the forum terminal exists in your catalogue
That wasn't the problem, I fixed it myself, it was some of the SQL inside that was bugging as it was picking up variables such as, type, desc etc which I fixed.RCON is a type of protocol used by the emu. The config is unrelated to your issue anyway -you need to check his SQL database. @Anglo fixed your problem by giving you that sql
change forum_enabled to has_forum
<furnitype id="5863" classname="guild_forum"><revision>51954</revision><defaultdir>0</defaultdir><xdim>2</xdim><ydim>1</ydim><partcolors/><name>Forum Furni</name><description>Double click to open Group Forum.</description><adurl></adurl><offerid>13767</offerid><buyout>1</buyout><rentofferid>-1</rentofferid><rentbuyout>0</rentbuyout><bc>0</bc><excludeddynamic>1</excludeddynamic><customparams></customparams><specialtype>17</specialtype><canstandon>0</canstandon><cansiton>0</cansiton><canlayon>0</canlayon><furniline>guilds</furniline></furnitype>
INSERT INTO `catalog_pages` VALUES (9223, 9036, 'Group Forums', 1, '1', '1', 1, 0, 2, '', 'guild_forum', '', 'Group Forums are here!|<<i><b><font color=\"#0e3f52\" size=\"16\">What are Group Forums?</font></b></i>\r\n\r\nForums allow you to effortlessly post, comment and discuss topics freely, without even leaving the Hotel!\r\n\r\n<i><b><font color=\"#0e3f52\" size=\"16\">Who can start a forum? </font></b></i>\r\n\r\nOnly a group owner can start a forum for their group.\r\n\r\n<i><b><font color=\"#0e3f52\" size=\"16\">Do I need a Forum Terminal?</font></b></i>\r\n\r\nYes - In order to start a Group Forum the group owner must first purchase a forum terminal for the group.\r\n\r\n\r\nFind out more about Group Forums <a href=\"event:habbopages/forums\">here</a>.\r\n\r\nPlease note, we will continue to add more functionalities to this feature in the near future.');
INSERT INTO `furniture` VALUES (5863, 'guild_forum', 'Forum Furni', 's', 2, 1, 0, '1', '0', '0', 5863, '1', '1', '1', '1', '1', 'guild_forum', 0, 1, '0', '0', 0, 0, '0', 0, '0');
Furnidata.xml:
Code:<furnitype id="5863" classname="guild_forum"><revision>51954</revision><defaultdir>0</defaultdir><xdim>2</xdim><ydim>1</ydim><partcolors/><name>Forum Furni</name><description>Double click to open Group Forum.</description><adurl></adurl><offerid>13767</offerid><buyout>1</buyout><rentofferid>-1</rentofferid><rentbuyout>0</rentbuyout><bc>0</bc><excludeddynamic>1</excludeddynamic><customparams></customparams><specialtype>17</specialtype><canstandon>0</canstandon><cansiton>0</cansiton><canlayon>0</canlayon><furniline>guilds</furniline></furnitype>
Catalogue page (Which you should have already, but for anyone who doesn't):
Code:INSERT INTO `catalog_pages` VALUES (9223, 9036, 'Group Forums', 1, '1', '1', 1, 0, 2, '', 'guild_forum', '', 'Group Forums are here!|<<i><b><font color=\"#0e3f52\" size=\"16\">What are Group Forums?</font></b></i>\r\n\r\nForums allow you to effortlessly post, comment and discuss topics freely, without even leaving the Hotel!\r\n\r\n<i><b><font color=\"#0e3f52\" size=\"16\">Who can start a forum? </font></b></i>\r\n\r\nOnly a group owner can start a forum for their group.\r\n\r\n<i><b><font color=\"#0e3f52\" size=\"16\">Do I need a Forum Terminal?</font></b></i>\r\n\r\nYes - In order to start a Group Forum the group owner must first purchase a forum terminal for the group.\r\n\r\n\r\nFind out more about Group Forums <a href=\"event:habbopages/forums\">here</a>.\r\n\r\nPlease note, we will continue to add more functionalities to this feature in the near future.');
Furniture:
@andrexy0 this should help your other problem in the catalogueCode:INSERT INTO `furniture` VALUES (5863, 'guild_forum', 'Forum Furni', 's', 2, 1, 0, '1', '0', '0', 5863, '1', '1', '1', '1', '1', 'guild_forum', 0, 1, '0', '0', 0, 0, '0', 0, '0');
Stuck on buying the group terminal
So what did you change?The db structure is wrong. You have to set default values, look the errors in your emulator.
You HAVENT insert a new Group Forum furni and you havent to do it, the Error is in the database.
DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`desc` varchar(255) NOT NULL,
`badge` varchar(50) NOT NULL,
`owner_id` int(11) unsigned NOT NULL,
`created` int(50) NOT NULL,
`room_id` int(10) unsigned NOT NULL DEFAULT '0',
`state` enum('0','1','2') NOT NULL DEFAULT '0',
`colour1` int(11) NOT NULL DEFAULT '242424',
`colour2` int(11) NOT NULL DEFAULT '242424',
`admindeco` enum('0','1') NOT NULL DEFAULT '1',
`has_forum` enum('1','0') NOT NULL DEFAULT '0',
`forum_enabled` enum('0','1') NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`) USING BTREE,
KEY `room_id` (`room_id`),
KEY `owner` (`owner_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `group_forums_settings`;
CREATE TABLE `group_forums_settings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`who_can_read` int(11) NOT NULL DEFAULT '0',
`who_can_post` int(11) NOT NULL DEFAULT '0',
`who_can_init_discussions` int(11) NOT NULL DEFAULT '0',
`who_can_mod` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `group_forums_threads`;
CREATE TABLE `group_forums_threads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp` int(11) DEFAULT NULL,
`caption` varchar(255) NOT NULL,
`pinned` enum('0','1') NOT NULL DEFAULT '0',
`locked` enum('0','1') NOT NULL DEFAULT '0',
`deleted_level` int(11) NOT NULL DEFAULT '0',
`deleter_user_id` int(11) NOT NULL DEFAULT '0',
`forum_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `group_forums_thread_posts`;
CREATE TABLE `group_forums_thread_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`timestamp` int(11) DEFAULT NULL,
`message` varchar(255) NOT NULL,
`deleted_level` int(11) NOT NULL DEFAULT '0',
`deleter_user_id` int(11) NOT NULL DEFAULT '0',
`thread_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
Works, ThanksCode:DROP TABLE IF EXISTS `groups`; CREATE TABLE `groups` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `desc` varchar(255) NOT NULL, `badge` varchar(50) NOT NULL, `owner_id` int(11) unsigned NOT NULL, `created` int(50) NOT NULL, `room_id` int(10) unsigned NOT NULL DEFAULT '0', `state` enum('0','1','2') NOT NULL DEFAULT '0', `colour1` int(11) NOT NULL DEFAULT '242424', `colour2` int(11) NOT NULL DEFAULT '242424', `admindeco` enum('0','1') NOT NULL DEFAULT '1', `has_forum` enum('1','0') NOT NULL DEFAULT '0', `forum_enabled` enum('0','1') NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) USING BTREE, KEY `room_id` (`room_id`), KEY `owner` (`owner_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `group_forums_settings`; CREATE TABLE `group_forums_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `who_can_read` int(11) NOT NULL DEFAULT '0', `who_can_post` int(11) NOT NULL DEFAULT '0', `who_can_init_discussions` int(11) NOT NULL DEFAULT '0', `who_can_mod` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `group_forums_threads`; CREATE TABLE `group_forums_threads` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `timestamp` int(11) DEFAULT NULL, `caption` varchar(255) NOT NULL, `pinned` enum('0','1') NOT NULL DEFAULT '0', `locked` enum('0','1') NOT NULL DEFAULT '0', `deleted_level` int(11) NOT NULL DEFAULT '0', `deleter_user_id` int(11) NOT NULL DEFAULT '0', `forum_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS `group_forums_thread_posts`; CREATE TABLE `group_forums_thread_posts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `timestamp` int(11) DEFAULT NULL, `message` varchar(255) NOT NULL, `deleted_level` int(11) NOT NULL DEFAULT '0', `deleter_user_id` int(11) NOT NULL DEFAULT '0', `thread_id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
Try this. If it isnt working I will provide you full SQLs of whole groups.