daily pastebin goal
27%
SHARE
TWEET

Untitled

a guest Mar 17th, 2018 84 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. ALTER TABLE `groups`
  2. ADD COLUMN `forum_enabled` enum('0','1') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0' AFTER `admindeco`;
  3.  
  4. ALTER TABLE `user_badges`
  5. ADD UNIQUE INDEX `user_id, badge_id` (`user_id`, `badge_id`);
  6.  
  7. ALTER TABLE `furniture`
  8. ADD COLUMN `behaviour_data` int(11) NOT NULL DEFAULT 0 AFTER `interaction_type`;
  9.  
  10. ALTER TABLE `users`
  11. MODIFY COLUMN `rank_vip` int(1) NULL DEFAULT 1 AFTER `rank`;
  12.  
  13. ALTER TABLE `server_settings`
  14. CHANGE COLUMN `variable` `key` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'server.variable' FIRST ;
  15.  
  16. ALTER TABLE `catalog_deals`
  17. DROP COLUMN `page_id`,
  18. DROP COLUMN `cost_credits`,
  19. DROP COLUMN `cost_pixels`,
  20. MODIFY COLUMN `items` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL AFTER `id`,
  21. ADD COLUMN `room_id` int(11) NOT NULL AFTER `name`;
  22.  
  23. SET FOREIGN_KEY_CHECKS=0;
  24.  
  25. -- ----------------------------
  26. -- Table structure for `moderation_topic_actions`
  27. -- ----------------------------
  28. DROP TABLE IF EXISTS `moderation_topic_actions`;
  29. CREATE TABLE `moderation_topic_actions` (
  30. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  31. `parent_id` int(11) NOT NULL,
  32. `type` varchar(255) NOT NULL,
  33. `caption` varchar(225) NOT NULL DEFAULT '',
  34. `message_text` varchar(255) NOT NULL,
  35. `default_sanction` varchar(255) NOT NULL,
  36. `mute_time` int(11) NOT NULL,
  37. `ban_time` int(11) NOT NULL,
  38. `ip_time` int(11) NOT NULL,
  39. `trade_lock_time` int(11) NOT NULL,
  40. PRIMARY KEY (`id`)
  41. ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
  42.  
  43. -- ----------------------------
  44. -- Records of moderation_topic_actions
  45. -- ----------------------------
  46. INSERT 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');
  47. INSERT 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');
  48. INSERT 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');
  49. INSERT 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');
  50. INSERT 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');
  51. INSERT INTO `moderation_topic_actions` VALUES ('9', '3', 'mods', 'scamsites_promoting', '', 'ban', '0', '2678400', '2678400', '0');
  52. INSERT INTO `moderation_topic_actions` VALUES ('10', '3', 'mods', 'selling_buying_accounts_or_furni', '', 'ban', '0', '2678400', '0', '0');
  53. INSERT INTO `moderation_topic_actions` VALUES ('11', '3', 'mods', 'stealing_accounts_or_furni', '', 'ban', '0', '2678400', '0', '0');
  54. INSERT 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');
  55. INSERT 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');
  56. INSERT 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');
  57. INSERT INTO `moderation_topic_actions` VALUES ('15', '4', 'mods_till_logout', 'drugs_promotion', '', 'alert', '0', '0', '0', '0');
  58. INSERT 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');
  59. INSERT 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');
  60. INSERT 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');
  61. INSERT INTO `moderation_topic_actions` VALUES ('19', '5', 'mods_till_logout', 'hate_speech', '', 'alert', '0', '0', '0', '0');
  62. INSERT INTO `moderation_topic_actions` VALUES ('20', '5', 'mods_till_logout', 'violent_roleplay', '', 'alert', '0', '0', '0', '0');
  63. INSERT INTO `moderation_topic_actions` VALUES ('21', '5', 'mods', 'self_threatening', '', 'alert', '0', '0', '0', '0');
  64. INSERT 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');
  65. INSERT 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');
  66. INSERT 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');
  67. INSERT 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');
  68. INSERT 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');
  69. INSERT 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');
  70. INSERT 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');
  71. INSERT 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');
  72. INSERT 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');
  73.  
  74. -- ----------------------------
  75. -- Table structure for `moderation_topics`
  76. -- ----------------------------
  77. DROP TABLE IF EXISTS `moderation_topics`;
  78. CREATE TABLE `moderation_topics` (
  79. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  80. `caption` varchar(225) NOT NULL DEFAULT '',
  81. PRIMARY KEY (`id`)
  82. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
  83.  
  84. -- ----------------------------
  85. -- Records of moderation_topics
  86. -- ----------------------------
  87. INSERT INTO `moderation_topics` VALUES ('1', 'sexual_content');
  88. INSERT INTO `moderation_topics` VALUES ('2', 'pii_meeting_irl');
  89. INSERT INTO `moderation_topics` VALUES ('3', 'scamming');
  90. INSERT INTO `moderation_topics` VALUES ('4', 'trolling_bad_behavior');
  91. INSERT INTO `moderation_topics` VALUES ('5', 'violent_behavior');
  92. INSERT INTO `moderation_topics` VALUES ('6', 'game_interruption');
  93.  
  94. -- ----------------------------
  95. -- Table structure for `server_locale`
  96. -- ----------------------------
  97. DROP TABLE IF EXISTS `server_locale`;
  98. CREATE TABLE `server_locale` (
  99. `key` varchar(255) NOT NULL,
  100. `value` text,
  101. PRIMARY KEY (`key`)
  102. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  103.  
  104. -- ----------------------------
  105. -- Records of server_locale
  106. -- ----------------------------
  107. INSERT INTO `server_locale` VALUES ('moderation.kick.disallowed', 'You cannot kick this user!');
  108. INSERT INTO `server_locale` VALUES ('room.creation.model.not_found', 'Oops, that room model was not found.');
  109. INSERT INTO `server_locale` VALUES ('room.creation.name.too_short', 'Sorry, that room name is too short!');
  110. INSERT INTO `server_locale` VALUES ('room.item.already_placed', 'That item has already been placed, reload the room!');
  111. INSERT INTO `server_locale` VALUES ('room.rights.user.has_rights', 'Oops, that user already has room rights!');
  112. INSERT INTO `server_locale` VALUES ('server.console.alert', 'Message from server administrator:');
  113. INSERT INTO `server_locale` VALUES ('server.shutdown.message', 'The server is shutting down.');
  114. INSERT INTO `server_locale` VALUES ('user.login.message', 'Welcome to the hotel.');
  115. INSERT INTO `server_locale` VALUES ('user.not_found', 'Oops, this user could not be found!');
  116.  
  117. -- ----------------------------
  118. -- Table structure for `server_settings`
  119. -- ----------------------------
  120. DROP TABLE IF EXISTS `server_settings`;
  121. CREATE TABLE `server_settings` (
  122. `key` varchar(255) NOT NULL DEFAULT 'server.variable',
  123. `value` text NOT NULL,
  124. `description` text NOT NULL,
  125. PRIMARY KEY (`key`)
  126. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  127.  
  128. -- ----------------------------
  129. -- Records of server_settings
  130. -- ----------------------------
  131. INSERT INTO `server_settings` VALUES ('catalog.enabled', '1', 'If set to 0 the catalog will be disabled.');
  132. INSERT INTO `server_settings` VALUES ('catalog.group.purchase.cost', '150', 'How much a group costs to purchase.');
  133. INSERT INTO `server_settings` VALUES ('group.delete.member.limit', '500', 'If the group has more members than this value allows, it cannot be deleted.');
  134. INSERT INTO `server_settings` VALUES ('messenger.buddy_limit', '5000', 'The amount of friends a user can have.');
  135. INSERT INTO `server_settings` VALUES ('room.chat.filter.banned_phrases.chances', '6', 'The amount of banned/filtered words a user can say before being banned.');
  136. INSERT INTO `server_settings` VALUES ('room.item.exchangeables.enabled', '1', 'If this is set to 1, a user can exchange exchangeable items into credits.');
  137. INSERT INTO `server_settings` VALUES ('room.item.gifts.enabled', '1', 'Disables the ability to give gifts or open them, if set to 0.');
  138. INSERT INTO `server_settings` VALUES ('room.item.placement_limit', '7500', 'How many items a room can hold.');
  139. INSERT INTO `server_settings` VALUES ('room.pets.placement_limit', '25', 'How many pets a room can hold.');
  140. INSERT INTO `server_settings` VALUES ('room.promotion.lifespan', '120', 'The lifespan of a room promotion.');
  141. INSERT INTO `server_settings` VALUES ('trading.auto_exchange_redeemables', '0', 'When enabled credits that are traded will automatically be redeemed.');
  142. INSERT INTO `server_settings` VALUES ('user.currency_scheduler.credit_reward', '100', 'The amount of credits a user will recieve every x minutes');
  143. INSERT INTO `server_settings` VALUES ('user.currency_scheduler.ducket_reward', '100', 'The amount of pixels a user will recieve every x minutes');
  144. INSERT INTO `server_settings` VALUES ('user.currency_scheduler.tick', '15', 'The time a user will have to wait for Credits/Pixels update in minutes');
  145. INSERT 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.');
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand