Arcturus-Community/sqlupdates/1_16_0_TO_2_0_0.sql

#DATABASE UPDATE: 1.16.0 -> 2.0.0

INSERT INTO `catalog_pages`(`id`, `parent_id`, `caption_save`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `vip_only`, `includes`, `room_id`) VALUES (null, -1, 'guilds_forum', 'Group Forums', 1, 27181, '1', '1', 1, '0', 2, 'guild_forum', 'catalog_groups_en', 'catalog_groupsteaser_en', '', 'Group Forums are here! Buy a terminal and chat to your groups!', '', 'Group Forums are here!', '', '0', '', 0);
SET @page_id = LAST_INSERT_ID();
UPDATE catalog_items SET page_id = @page_id WHERE catalog_name LIKE '%guild_forum%';
UPDATE items_base SET `interaction_type` = 'guild_furni' WHERE item_name LIKE '%guild_forum%';
INSERT INTO `emulator_settings` (`key`, `value`) VALUES ('hotel.bot.butler.commanddistance', '5');

#END DATABASE UPDATE: 1.16.0 -> 2.0.0
Fixed dismounting. Added `hotel.room.wired.norules` which is disabled by default, which will allow you to use wired to place furniture under users. 2019-05-01 01:59:25 +02:00			`#DATABASE UPDATE: 1.16.0 -> 2.0.0`
Pushed Updated SQL. 2019-05-02 02:42:12 +02:00
Pushed Updated SQL. 2019-05-02 02:44:24 +02:00			INSERT INTO `catalog_pages`(`id`, `parent_id`, `caption_save`, `caption`, `icon_color`, `icon_image`, `visible`, `enabled`, `min_rank`, `club_only`, `order_num`, `page_layout`, `page_headline`, `page_teaser`, `page_special`, `page_text1`, `page_text2`, `page_text_details`, `page_text_teaser`, `vip_only`, `includes`, `room_id`) VALUES (null, -1, 'guilds_forum', 'Group Forums', 1, 27181, '1', '1', 1, '0', 2, 'guild_forum', 'catalog_groups_en', 'catalog_groupsteaser_en', '', 'Group Forums are here! Buy a terminal and chat to your groups!', '', 'Group Forums are here!', '', '0', '', 0);
Pushed Updated SQL. 2019-05-02 02:42:12 +02:00			`SET @page_id = LAST_INSERT_ID();`
			`UPDATE catalog_items SET page_id = @page_id WHERE catalog_name LIKE '%guild_forum%';`
			UPDATE items_base SET `interaction_type` = 'guild_furni' WHERE item_name LIKE '%guild_forum%';
Fixed ButlerBots, they now give drinks over a furniture if within a command difference. 2019-05-03 00:47:30 +02:00			INSERT INTO `emulator_settings` (`key`, `value`) VALUES ('hotel.bot.butler.commanddistance', '5');
Fixed dismounting. Added `hotel.room.wired.norules` which is disabled by default, which will allow you to use wired to place furniture under users. 2019-05-01 01:59:25 +02:00
			`#END DATABASE UPDATE: 1.16.0 -> 2.0.0`