[Plus Emulator] Fixed Group Forums

It loads now, but I just cannot buy the forum terminal for the group,

Aurotha said:

It loads now, but I just cannot buy the forum terminal for the group,

You must be registered for see links

Click to expand...

Check if the forum terminal exists in your catalogue

Paypal said:

Check if the forum terminal exists in your catalogue

Click to expand...

It does exist in the furniture and catalog items table, still getting error.

Paypal said:

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

Click to expand...

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.

Yes, there are some problems with the DB structure. I fixed it already too.

Furnidata.xml:

Catalogue page (Which you should have already, but for anyone who doesn't):

Furniture:
@andrexy0 this should help your other problem in the catalogue

Paypal said:

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

Click to expand...

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.

andrexy0 said:

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.

Click to expand...

I know i said about the reason you couldnt buy it from catalogue this could have been a fix

Stuck on buying the group terminal

Aurotha said:

Stuck on buying the group terminal

Click to expand...

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.

andrexy0 said:

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.

Click to expand...

So what did you change?

a fix? damn straight

Try this. If it isnt working I will provide you full SQLs of whole groups.

andrexy0 said:

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.

Click to expand...

Works, Thanks

When I try purchase the group forum furniture, appear the message "Oooeps, Error!". How to resolve it?
 
RESOLVED

link don't work..

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

Thanks for release. It works for me fine

Nice Release ! mobis terminal please ?

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