FAQ, Handitem command (PLUSEMU)

[JerryCool]

I'll be releasing a few more commands if it's useful or not.

• FAQ
• HandItem

Handitem:

                #region handitem (:handitem <id>)
                case "handitem":
                    {
                        if (Session.GetHabbo().HasCmd("handitem"))
                        {
                            Room currentRoom = Session.GetHabbo().CurrentRoom;
                            RoomUser roomUserByHabbo = null;
                            currentRoom = SilverwaveEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
                            if (currentRoom != null)
                            {
                                roomUserByHabbo = currentRoom.GetRoomUserManager().GetRoomUserByHabbo(Session.GetHabbo().Id);
                                if (roomUserByHabbo != null)
                                {
                                    try
                                    {
                                        roomUserByHabbo.CarryItem(int.Parse(Params[1]));
                                    }
                                    catch
                                    {
                                    }
                                }
                            }
                        }
        return true;
        }                 #endregion

FAQ:

                #region FAQ (:faq)
                case "faq":
                    {
                        if (Session.GetHabbo().HasCmd("faq"))
                        {
                            DataTable table;
                            Room currentRoom = Session.GetHabbo().CurrentRoom;
                            using (IQueryAdapter adapter = SilverwaveEnvironment.GetDatabaseManager().getQueryreactor())
                            {
                                adapter.setQuery("SELECT question, answer FROM faq");
                                table = adapter.getTable();
                            }
                            StringBuilder builder = new StringBuilder();
                            builder.Append(" - FAQ - \r\r");
                            foreach (DataRow row in table.Rows)
                            {
                                builder.Append("Q: " + ((string)row["question"]) + "\r");
                                builder.Append("A: " + ((string)row["answer"]) + "\r\r");
                            }
                            Session.SendNotif(builder.ToString());
                        }
                        return true;
                    }
                   
                   #endregion

SQL FOR FAQ:

-- ----------------------------
-- Table structure for `faq`
-- ----------------------------
DROP TABLE IF EXISTS `faq`;
CREATE TABLE `faq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of faq
-- ----------------------------
INSERT INTO `faq` VALUES ('1', 'How can I be staff?', 'Be active, help users, advertise and more');
INSERT INTO `faq` VALUES ('2', 'Can I have more credits?', 'No, you get 500c every 15 minutes');
INSERT INTO `faq` VALUES ('3', 'Can I have a rare?', 'Hell no');
INSERT INTO `faq` VALUES ('4', 'Can I have more duckets?', 'No, you get 100 duckets every 15 minutes');
INSERT INTO `faq` VALUES ('5', 'When will pets get released?', 'They are allready in the catalog.');
INSERT INTO `faq` VALUES ('6', 'Can staff come and advertise my room?', 'Sometimes..');
INSERT INTO `faq` VALUES ('7', 'Can I be friend with staff?', 'Sure, as long you do not beg :D'); INSERT INTO `faq` VALUES ('8', 'Can I have a badge?', 'No, there is a badgeshop feature on your website, check it out :D');

SQL for fuse_cmds:

INSERT INTO `fuse_cmds` VALUES ('86', 'handitem', '1', '%id%', 'Gives you the chosen item');
INSERT INTO `fuse_cmds` VALUES ('87', 'faq', '1', null, 'It gives you the answers you might need');

Screenshots;


Credits:
JerryCool - Fixed coding for PlusEMU.
SwiftEMU - Taking their code from the source.

[MentaL]

[duckietm]

Thanks !

[The General]

Yay lets spam the database with :faq

[Bloodraven]

It'd be difficult to spam the database. Spam filter...

[The General]

It'd be difficult to spam the database. Spam filter...

Don''t think commands are blocked by spam filter.

But it is more friendly to cache it a single time.

[Receiver]

Thank's for the handitem command but, i wouldn't be using the faq command as the one above me said you can spam it and cause yourself into more problems.

[The General]

Thank's for the handitem command but, i wouldn't be using the faq command as the one above me said you can spam it and cause yourself into more problems.

Change it to a static list and load it when the emulator is started :)

[Bloodraven]

Don''t think commands are blocked by spam filter.

But it is more friendly to cache it a single time.

Ahh, I suppose it would be pretty easy to have commands be filtered with the spam filter.

I wouldn't even use an FAQ command, having it on the web-side would be better.

[Twan]

Well, thanks for these commands!

[JerryCool]

Thanks for all your feedback's and I see a few hotels using the FAQ..