[Plus Emulator] Fixed Group Forums
- Thread starter Paypal
- Start date
Joshhh
Member
- Apr 13, 2016
- 325
- 177
It does exist in the furniture and catalog items table, still getting error.
Central
Imagination is more important than knowledge.
- Feb 22, 2015
- 709
- 107
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
- Thread starter
- #26
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
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');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.
Stuck on buying the group terminal
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.
Joshhh
Member
- Apr 13, 2016
- 325
- 177
So what did you change?
justbanterdev
New Member
- Jun 23, 2017
- 15
- 1
a fix? damn straight
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
Works, Thanks
brutalzinn123
New Member
- Dec 10, 2014
- 2
- 0
link don't work..
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
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:
LightStorm
New Member
- Dec 28, 2012
- 1
- 0
Nice Release ! 
mobis terminal please 
?
mobis terminal please ?
