Group Forums

<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 `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');

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;

20:30:19 - [ERROR] Exception:
System.FormatException: Input string was not in a correct format.
   at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffe
r& number, NumberFormatInfo info, Boolean parseDecimal)
   at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo in
fo)
   at System.Convert.ToInt32(String value)
   at Plus.Communication.Packets.Incoming.Catalog.PurchaseFromCatalogEvent.Parse
(GameClient Session, ClientPacket Packet) in C:\inetpub\wwwroot\Zebb1\Release 2\
Release 2\Emulator Source2\Communication\Packets\Incoming\Catalog\PurchaseFromCa
talogEvent.cs:line 269
   at Plus.Communication.Packets.PacketManager.TryExecutePacket(GameClient Sessi
on, ClientPacket Packet) in C:\inetpub\wwwroot\Zebb1\Release 2\Release 2\Emulato
r Source2\Communication\Packets\PacketManager.cs:line 154
   at Plus.HabboHotel.GameClients.GameClient.parser_onNewPacket(ClientPacket Mes
sage) in C:\inetpub\wwwroot\Zebb1\Release 2\Release 2\Emulator Source2\HabboHote
l\GameClients\GameClient.cs:line 76

   at Plus.Communication.Packets.Incoming.Catalog.PurchaseFromCatalogEvent.Parse
(GameClient Session, ClientPacket Packet) in C:\inetpub\wwwroot\Zebb1\Release 2\
Release 2\Emulator Source2\Communication\Packets\Incoming\Catalog\PurchaseFromCa
talogEvent.cs:line 269

Severity    Code    Description    Project    File    Line    Suppression State
Error    CS0246    The type or namespace name 'DeleteGroupPostEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    854    Active
Error    CS1061    'GameClient' does not contain a definition for 'SendMessage' and no extension method 'SendMessage' accepting a first argument of type 'GameClient' could be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs    71    Active
Error    CS0246    The type or namespace name 'ForumsListDataComposer' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs    71    Active
Error    CS1061    'IQueryAdapter' does not contain a definition for 'getTable' and no extension method 'getTable' accepting a first argument of type 'IQueryAdapter' could be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs    97    Active
Error    CS1061    'IQueryAdapter' does not contain a definition for 'getTable' and no extension method 'getTable' accepting a first argument of type 'IQueryAdapter' could be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs    141    Active
Error    CS1061    'GameClient' does not contain a definition for 'SendMessage' and no extension method 'SendMessage' accepting a first argument of type 'GameClient' could be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs    169    Active
Error    CS0246    The type or namespace name 'ForumsListDataComposer' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\Incoming\Groups\GetForumsListDataEvent.cs    169    Active
Error    CS0246    The type or namespace name 'GetForumStatsEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    846    Active
Error    CS0246    The type or namespace name 'GetThreadsListDataEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    847    Active
Error    CS0246    The type or namespace name 'GetThreadDataEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    848    Active
Error    CS0246    The type or namespace name 'PostGroupContentEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    849    Active
Error    CS0246    The type or namespace name 'DeleteGroupThreadEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    850    Active
Error    CS0246    The type or namespace name 'UpdateForumReadMarkerEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    851    Active
Error    CS0246    The type or namespace name 'UpdateForumSettingsEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    852    Active
Error    CS0246    The type or namespace name 'UpdateForumThreadStatusEvent' could not be found (are you missing a using directive or an assembly reference?)    Plus Emulator    C:\inetpub\wwwroot\Zebb1\Zebbo Emu [Use This]\Communication\Packets\PacketManager.cs    853    Active