[Plus Emulator] Fixed Group Forums

Joshhh

Member
Apr 13, 2016
325
177
It loads now, but I just cannot buy the forum terminal for the group,
 

Central

Imagination is more important than knowledge.
Feb 22, 2015
709
107
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
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.
 

Paypal

Freelance developer
Apr 1, 2017
310
131
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:
Code:
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');
@andrexy0 this should help your other problem in the catalogue
 

andrexy0

New Member
Jun 20, 2017
27
4
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:
Code:
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');
@andrexy0 this should help your other problem in the catalogue

No, that wasnt the problem. The problem was, that some DB Tables not have a default value. After I set default values everything was working.
 

Paypal

Freelance developer
Apr 1, 2017
310
131
No, that wasnt the problem. The problem was, that some DB Tables not have a default value. After I set default values everything was working.
I know i said about the reason you couldnt buy it from catalogue this could have been a fix
 

andrexy0

New Member
Jun 20, 2017
27
4
Code:
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.
 

Joshhh

Member
Apr 13, 2016
325
177
Code:
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.
Works, Thanks:up:
 

Marko97

M97 Project based Plus EMU
Aug 7, 2013
99
45
When I try purchase the group forum furniture, appear the message "Oooeps, Error!". How to resolve it?
 
RESOLVED
 

Mikee

Active Member
Jul 8, 2017
162
102
Can I ask why you copy and pasted all of the code for each class where the code is included. This makes no sense to do this except for the Groups namespace. For examples it replaces my own packets registered in packetmanager and serverpacketheader. You could of simply provided the proper code needed just for forums not everything in the class where group forums has some sort of existance.

Thanks anyway

Also to add on, a lot of these fields didnt have a default value, so for noobs getting errors open navicat, open the table hit ctrl + d, then add default values for each row where necessary
 
Last edited:

Twister

New Member
May 24, 2015
29
1
Sorry to up this old subject. But I have one problem when I rebot my Emulator I don't have theards when I have create after
 

Users who are viewing this thread

Top