Advertisement
Guest User

Untitled

a guest
Jul 21st, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 4.48 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `help_subjects` (
  2.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  3.   `caption` varchar(100) NOT NULL,
  4.   PRIMARY KEY (`id`)
  5. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
  6.  
  7. INSERT INTO `help_subjects` (`id`, `caption`) VALUES
  8. (1, 'Uber - General'),
  9. (2, 'Credits, Pixels and Achievements'),
  10. (3, 'Catalogue and Furniture'),
  11. (4, 'Rooms'),
  12. (5, 'Infobus');
  13.  
  14. CREATE TABLE IF NOT EXISTS `help_topics` (
  15.   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  16.   `subject` int(11) unsigned NOT NULL DEFAULT '1',
  17.   `title` varchar(50) NOT NULL,
  18.   `body` text NOT NULL,
  19.   `known_issue` enum('0','1','2') NOT NULL DEFAULT '0',
  20.   PRIMARY KEY (`id`)
  21. ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
  22.  
  23. INSERT INTO `help_topics` (`id`, `subject`, `title`, `body`, `known_issue`) VALUES
  24. (1, 1, 'What is uberHotel?', 'uberHotel is a test platform for the new Habbo Hotel Emulator, UberEmulator. We are using this hotel to test and verify the stability, performance, and functionality of the server. This means the hotel will only be available temporarily, and certain features may be missing or broken.', '2'),
  25. (2, 1, 'Missing/broken features', 'This article will be updated to reflect an overview of features that are missing or broken.', '2'),
  26. (3, 2, 'How do I get Credits?', 'You can receive credits in a multitude of ways:\r\n\r\n* By signing up to Uber you receive some credits to get you started.\r\n* You will recieve credit updates at preset intervals.\r\n* You can play games and take part in events and competitions for prizes and credits.\r\n* You can trade other users for credits.', '1'),
  27. (4, 2, 'How do I get Pixels?', 'You automatically receive pixels every now and then. You can exchange these for effects, special pixel offers, and credits. You also receive pixels by completing achievements.', '1'),
  28. (5, 2, 'What are achievements and how do I get them?', 'Achievements are special tasks you can complete in the hotel which will give you a certain amount of pixels and a cool badge as reward.', '1'),
  29. (6, 2, 'Are all achievements available on Uber?', 'We have not yet added all achievements. The ones that are available can be seen under the ''Achievements'' tab in your inventory.', '0'),
  30. (7, 1, 'Staff on Uber', 'Uber is being maintained and moderated by a relatively small staff team. They are here to make sure everything works correctly and to help our players and keep them safe.\r\n\r\nIn general we do not have any staff openings; if we are looking for staff it will be announced on the homepage, or we will approach players we deem capable.', '2'),
  31. (8, 3, 'I have a suggestion for new furniture!', 'We do NOT accept any requests for custom furniture or anything along those lines, we only use furniture that is available on the official hotels. If you have suggestions for new furniture, try contacting Habbo. They might like your idea!', '0'),
  32. (9, 3, 'Why is this piece of furniture missing?', 'We may have not added all furniture yet or we may have purposely decided not to put it up for sale. Please do not contact us about this - we are constantly adding new furniture.', '1'),
  33. (10, 5, 'Where is the Infobus?', 'The infobus is currently available in the navigator, although bugged.', '1'),
  34. (11, 3, 'Stacking-related issues', 'The stacking system is a sensitive and complicated mechanism that still requires some work. There is generally no need to report any problems regarding stacking to us, as we are aware of problems relating to it.\r\n\r\nIf there are problems with stacking relating to a specific piece of furniture, then please submit a suggestion or bug report on our UserVoice forum.', '1'),
  35. (12, 1, 'Support Tickets & User Reports', 'We would just like to urge that the ticket system you will find in this help tool and when reporting users is only intended for SERIOUS requests. Yes, it works, and there is no need to test it. Any requests that are offensive, spam, or in anyway inappropriate may result in a ban.\r\n\r\nAlso, when submitting a help request, please keep in mind that it must be in English.', '2'),
  36. (13, 1, 'IMPORTANT: This is an English hotel!', 'Although allowed, we do discourage the use of foreign languages in this hotel so all users and staff can understand each other. Localised rooms and groups may be created but we ask ALL e-mails, support tickets and other communications to staff are in CLEAR, FLUENT ENGLISH. If we find this allowance abused by people swearing etc in their own langugage they will be banned IMMEDIATELY and this allowance discontinued.', '2');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement