· 9 years ago · Apr 10, 2017, 08:44 PM
1-- ----------------------------
2-- Table structure for `moderation_topic_actions`
3-- ----------------------------
4DROP TABLE IF EXISTS `moderation_topic_actions`;
5CREATE TABLE `moderation_topic_actions` (
6 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
7 `parent_id` int(11) NOT NULL,
8 `type` varchar(255) NOT NULL,
9 `caption` varchar(225) NOT NULL DEFAULT '',
10 `message_text` varchar(255) NOT NULL,
11 `default_sanction` varchar(255) NOT NULL,
12 `mute_time` int(11) NOT NULL,
13 `ban_time` int(11) NOT NULL,
14 `ip_time` int(11) NOT NULL,
15 `trade_lock_time` int(11) NOT NULL,
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
18
19-- ----------------------------
20-- Records of moderation_topic_actions
21-- ----------------------------
22INSERT INTO `moderation_topic_actions` VALUES ('1', '1', 'mods', 'explicit_sexual_talk', 'Users are to not participate in any sexual, inappropriate, or generally objective acts towards other users without their prior consent.', 'alert', '0', '0', '0', '0');
23INSERT INTO `moderation_topic_actions` VALUES ('2', '1', 'mods', 'cybersex', 'Users are to not participate in any sexual, inappropriate, or generally objective acts towards other users without their prior consent.', 'alert', '0', '0', '0', '0');
24INSERT INTO `moderation_topic_actions` VALUES ('3', '1', 'mods', 'sexual_webcam_images', 'Users are to not participate in any sexual, inappropriate, or generally objective acts towards other users without their prior consent.', 'alert', '0', '0', '0', '0');
25INSERT INTO `moderation_topic_actions` VALUES ('6', '2', 'mods', 'meet_irl', 'Do not disclose any personal information of another user (e.g., address, IP Address, phone number, school) without their consent.', 'alert', '0', '0', '0', '0');
26INSERT INTO `moderation_topic_actions` VALUES ('8', '2', 'mods', 'asking_pii', 'Do not disclose any personal information of another user (e.g., address, IP Address, phone number, school) without their consent.', 'alert', '0', '0', '0', '0');
27INSERT INTO `moderation_topic_actions` VALUES ('9', '3', 'mods', 'scamsites_promoting', '', 'ban', '0', '2678400', '2678400', '0');
28INSERT INTO `moderation_topic_actions` VALUES ('10', '3', 'mods', 'selling_buying_accounts_or_furni', '', 'ban', '0', '2678400', '0', '0');
29INSERT INTO `moderation_topic_actions` VALUES ('11', '3', 'mods', 'stealing_accounts_or_furni', '', 'ban', '0', '2678400', '0', '0');
30INSERT INTO `moderation_topic_actions` VALUES ('12', '4', 'mods_till_logout', 'bullying', 'Do not bully, harass, or abuse other users; avoid violent or aggressive behaviour.', 'alert', '0', '0', '0', '0');
31INSERT INTO `moderation_topic_actions` VALUES ('13', '4', 'mods', 'habbo_name', 'Do not create a username with an offensive name that is insulting, racist, harassing, or generally objectionable.', 'ban', '0', '2678400', '0', '0');
32INSERT INTO `moderation_topic_actions` VALUES ('14', '4', 'auto_reply', 'swearing', 'This CFH has been deemed a non-emergency. Please use the ignore feature, swearing is not moderated on Habboon.', 'alert', '0', '0', '0', '0');
33INSERT INTO `moderation_topic_actions` VALUES ('15', '4', 'mods_till_logout', 'drugs_promotion', '', 'alert', '0', '0', '0', '0');
34INSERT INTO `moderation_topic_actions` VALUES ('16', '4', 'auto_reply', 'gambling', 'This CFH has been deemed a non-emergency. Gambling is allowed on Habboon.com', '', '0', '0', '0', '0');
35INSERT INTO `moderation_topic_actions` VALUES ('17', '4', 'mods', 'staff_impersonation', 'Do not pretend to be a representative of Habboon Hotel or claim to have their powers.', 'alert', '0', '0', '0', '0');
36INSERT INTO `moderation_topic_actions` VALUES ('18', '4', 'auto_reply', 'minors_access', 'This CFH has been deemed a non-emergency. Minors are allowed on Habboon as long as they follow the rules.', '', '0', '0', '0', '0');
37INSERT INTO `moderation_topic_actions` VALUES ('19', '5', 'mods_till_logout', 'hate_speech', '', 'alert', '0', '0', '0', '0');
38INSERT INTO `moderation_topic_actions` VALUES ('20', '5', 'mods_till_logout', 'violent_roleplay', '', 'alert', '0', '0', '0', '0');
39INSERT INTO `moderation_topic_actions` VALUES ('21', '5', 'mods', 'self_threatening', '', 'alert', '0', '0', '0', '0');
40INSERT INTO `moderation_topic_actions` VALUES ('22', '6', 'mods_till_logout', 'flooding', 'Do not excessively repeat identical or similar statements (flooding).', 'mute', '1', '0', '0', '0');
41INSERT INTO `moderation_topic_actions` VALUES ('23', '6', 'auto_reply', 'door_blocking', 'This CFH has been deemed a non-emergency. Please ask the room owner to kick the person from the room.', 'kick', '0', '0', '0', '0');
42INSERT INTO `moderation_topic_actions` VALUES ('29', '6', 'mods', 'raids', 'Users are to not participate in any raids, including mass flooding across Habboon services.', 'kick', '0', '0', '0', '0');
43INSERT INTO `moderation_topic_actions` VALUES ('31', '1', 'mods', 'sexually_inappropiate_behaviour', 'Users are to not participate in any sexual, inappropriate, or generally objective acts towards other users without their prior consent.', 'alert', '0', '0', '0', '0');
44INSERT INTO `moderation_topic_actions` VALUES ('32', '3', 'auto_reply', 'hacking_scamming_tricks', 'This CFH has been deemed a non-emergency. Please report this activity with video evidence via BoonForums.com.', '', '0', '0', '0', '0');
45INSERT INTO `moderation_topic_actions` VALUES ('33', '3', 'auto_reply', 'fraud', 'This CFH has been deemed a non-emergency. Please report this activity with video evidence via BoonForums.com.', '', '0', '0', '0', '0');
46INSERT INTO `moderation_topic_actions` VALUES ('34', '4', 'mods', 'inappropiate_room_group_event', 'Do not create a group with an offensive name that is insulting, racist, harassing, or generally objectionable.', 'alert', '0', '0', '0', '0');
47INSERT INTO `moderation_topic_actions` VALUES ('35', '6', 'mods', 'scripting', 'Users are to not participate in any scripting, hacking or malicious acts against users or Habboon services.', 'ban', '0', '2678400', '0', '0');
48INSERT INTO `moderation_topic_actions` VALUES ('36', '1', 'mods', 'sex_links', 'Users are to not participate in any sexual, inappropriate, or generally objective acts towards other users without their prior consent.', 'alert', '0', '0', '0', '0');
49
50-- ----------------------------
51-- Table structure for `moderation_topics`
52-- ----------------------------
53DROP TABLE IF EXISTS `moderation_topics`;
54CREATE TABLE `moderation_topics` (
55 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
56 `caption` varchar(225) NOT NULL DEFAULT '',
57 PRIMARY KEY (`id`)
58) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
59
60-- ----------------------------
61-- Records of moderation_topics
62-- ----------------------------
63INSERT INTO `moderation_topics` VALUES ('1', 'sexual_content');
64INSERT INTO `moderation_topics` VALUES ('2', 'pii_meeting_irl');
65INSERT INTO `moderation_topics` VALUES ('3', 'scamming');
66INSERT INTO `moderation_topics` VALUES ('4', 'trolling_bad_behavior');
67INSERT INTO `moderation_topics` VALUES ('5', 'violent_behavior');
68INSERT INTO `moderation_topics` VALUES ('6', 'game_interruption');
69
70-- ----------------------------
71-- Table structure for `server_locale`
72-- ----------------------------
73DROP TABLE IF EXISTS `server_locale`;
74CREATE TABLE `server_locale` (
75 `key` varchar(255) NOT NULL,
76 `value` text,
77 PRIMARY KEY (`key`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80-- ----------------------------
81-- Records of server_locale
82-- ----------------------------
83INSERT INTO `server_locale` VALUES ('moderation.kick.disallowed', 'You cannot kick this user!');
84INSERT INTO `server_locale` VALUES ('room.creation.model.not_found', 'Oops, that room model was not found.');
85INSERT INTO `server_locale` VALUES ('room.creation.name.too_short', 'Sorry, that room name is too short!');
86INSERT INTO `server_locale` VALUES ('room.item.already_placed', 'That item has already been placed, reload the room!');
87INSERT INTO `server_locale` VALUES ('room.rights.user.has_rights', 'Oops, that user already has room rights!');
88INSERT INTO `server_locale` VALUES ('server.console.alert', 'Message from server administrator:');
89INSERT INTO `server_locale` VALUES ('server.shutdown.message', 'The server is shutting down.');
90INSERT INTO `server_locale` VALUES ('user.login.message', 'Welcome to the hotel.');
91INSERT INTO `server_locale` VALUES ('user.not_found', 'Oops, this user could not be found!');
92
93-- ----------------------------
94-- Table structure for `server_settings`
95-- ----------------------------
96DROP TABLE IF EXISTS `server_settings`;
97CREATE TABLE `server_settings` (
98 `key` varchar(255) NOT NULL DEFAULT 'server.variable',
99 `value` text NOT NULL,
100 `description` text NOT NULL,
101 PRIMARY KEY (`key`)
102) ENGINE=InnoDB DEFAULT CHARSET=latin1;
103
104-- ----------------------------
105-- Records of server_settings
106-- ----------------------------
107INSERT INTO `server_settings` VALUES ('catalog.enabled', '1', 'If set to 0 the catalog will be disabled.');
108INSERT INTO `server_settings` VALUES ('catalog.group.purchase.cost', '150', 'How much a group costs to purchase.');
109INSERT INTO `server_settings` VALUES ('group.delete.member.limit', '500', 'If the group has more members than this value allows, it cannot be deleted.');
110INSERT INTO `server_settings` VALUES ('messenger.buddy_limit', '5000', 'The amount of friends a user can have.');
111INSERT INTO `server_settings` VALUES ('room.chat.filter.banned_phrases.chances', '6', 'The amount of banned/filtered words a user can say before being banned.');
112INSERT INTO `server_settings` VALUES ('room.item.exchangeables.enabled', '1', 'If this is set to 1, a user can exchange exchangeable items into credits.');
113INSERT INTO `server_settings` VALUES ('room.item.gifts.enabled', '1', 'Disables the ability to give gifts or open them, if set to 0.');
114INSERT INTO `server_settings` VALUES ('room.item.placement_limit', '7500', 'How many items a room can hold.');
115INSERT INTO `server_settings` VALUES ('room.pets.placement_limit', '25', 'How many pets a room can hold.');
116INSERT INTO `server_settings` VALUES ('room.promotion.lifespan', '120', 'The lifespan of a room promotion.');
117INSERT INTO `server_settings` VALUES ('trading.auto_exchange_redeemables', '0', 'When enabled credits that are traded will automatically be redeemed.');
118INSERT INTO `server_settings` VALUES ('user.currency_scheduler.credit_reward', '100', 'The amount of credits a user will recieve every x minutes');
119INSERT INTO `server_settings` VALUES ('user.currency_scheduler.ducket_reward', '100', 'The amount of pixels a user will recieve every x minutes');
120INSERT INTO `server_settings` VALUES ('user.currency_scheduler.tick', '15', 'The time a user will have to wait for Credits/Pixels update in minutes');
121INSERT INTO `server_settings` VALUES ('user.login.message.enabled', '0', 'If this is enabled, a message from the server_locale table will be given to the user.');