[Uber] Infobus questions 100%

[=dj.matias=]

I've coded infobus questions for uberemu today.

Add to Chatcommandhandlers.cs:

 case "startquestion":

                        if (Session.GetHabbo().HasFuse("fuse_sysadmin"))
                        {
                            Room Room = UberEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
                            DataTable Data = null;
                            int QuestionId = int.Parse(Params[1]);
                            Room.CurrentPollId = QuestionId;
                            string Question;

                            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                            {
                                Question = dbClient.ReadString("SELECT question FROM infobus_questions WHERE id = '" + QuestionId + "' LIMIT 1");
                            }


                            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                            {
                                Data = dbClient.ReadDataTable("SELECT * FROM infobus_answers WHERE question_id = '" + QuestionId + "'");

                            }

                            ServerMessage InfobusQuestion = new ServerMessage(79);
                            InfobusQuestion.AppendStringWithBreak(Question);
                            InfobusQuestion.AppendInt32(Data.Rows.Count);
                            if (Data != null)
                            {
                                foreach (DataRow Row in Data.Rows)
                                {
                                    InfobusQuestion.AppendInt32((int)Row["id"]);
                                    InfobusQuestion.AppendStringWithBreak((string)Row["answer_text"]);
                                }
                            }
                            Room.SendMessage(InfobusQuestion);



                            Thread Infobus = new Thread(delegate() { Room.ShowResults(Room, QuestionId, Session); });
                            Infobus.Start();
                            Room.HasThread.Add((uint)QuestionId, Infobus);


                            return true;
                        }
                        return false;

Add to Rooms.cs:

 private void AnswerInfobusPoll()
        {
            Room Room = UberEnvironment.GetGame().GetRoomManager().GetRoom(Session.GetHabbo().CurrentRoomId);
            int AnswerId = Request.PopWiredInt32();
            int QuestionId = Room.CurrentPollId;
            DataTable Data = null;

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                dbClient.ExecuteQuery("INSERT INTO `infobus_results` (`question_id`, `answer_id`) VALUES ('" + QuestionId + "', '" + AnswerId + "')");
            }
           
        
        }

Find:

RequestHandlers[3004] = new RequestHandler(GetTrainerPanel);

Add after:

RequestHandlers[112] = new RequestHandler(AnswerInfobusPoll);

Add to Room.cs:

 public static void ShowResults(Room Room, int QuestionId, GameClient Session)
        {
            Thread.Sleep(30000);
            string Question;
            DataTable Data = null;
            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                Question = dbClient.ReadString("SELECT question FROM infobus_questions WHERE id = '" + QuestionId + "' LIMIT 1");
            }


            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                Data = dbClient.ReadDataTable("SELECT * FROM infobus_answers WHERE question_id = '" + QuestionId + "'");

            }

            ServerMessage InfobusQuestion = new ServerMessage(80);
            InfobusQuestion.AppendStringWithBreak(Question);
            InfobusQuestion.AppendInt32(Data.Rows.Count);
            if (Data != null)
            {
                foreach (DataRow Row in Data.Rows)
                {
                    int ResultCount;
                    InfobusQuestion.AppendInt32((int)Row["id"]);
                    InfobusQuestion.AppendStringWithBreak((string)Row["answer_text"]);
                    using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                    {
                        ResultCount = dbClient.ReadInt32("SELECT COUNT(*) FROM infobus_results WHERE answer_id = '" + (int)Row["id"] + "' AND question_id = '" + QuestionId + "'");
                    }
                    InfobusQuestion.AppendInt32(ResultCount);
                }
            }
            int AnswerUserCount;
            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                AnswerUserCount = dbClient.ReadInt32("SELECT COUNT(*) FROM infobus_results WHERE question_id = '" + QuestionId + "'");
            }
            InfobusQuestion.AppendInt32(AnswerUserCount);
            Room.SendMessage(InfobusQuestion);

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                dbClient.ExecuteQuery("DELETE FROM infobus_results WHERE question_id = '" + QuestionId + "'");
            }
        }

SQL:

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50516
Source Host           : localhost:3306
Source Database       : uberdb2

Target Server Type    : MYSQL
Target Server Version : 50516
File Encoding         : 65001

Date: 2012-03-11 10:15:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `infobus_answers`
-- ----------------------------
DROP TABLE IF EXISTS `infobus_answers`;
CREATE TABLE `infobus_answers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL DEFAULT '0',
  `answer_text` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of infobus_answers
-- ----------------------------
INSERT INTO `infobus_answers` VALUES ('1', '1', 'Awesome');
INSERT INTO `infobus_answers` VALUES ('2', '1', 'Nice');
INSERT INTO `infobus_answers` VALUES ('3', '1', 'Poor');

-- ----------------------------
-- Table structure for `infobus_questions`
-- ----------------------------
DROP TABLE IF EXISTS `infobus_questions`;
CREATE TABLE `infobus_questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of infobus_questions
-- ----------------------------
INSERT INTO `infobus_questions` VALUES ('1', 'What do you think about this?');

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50516
Source Host           : localhost:3306
Source Database       : uberdb2

Target Server Type    : MYSQL
Target Server Version : 50516
File Encoding         : 65001

Date: 2012-03-11 10:16:23
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `infobus_results`
-- ----------------------------
DROP TABLE IF EXISTS `infobus_results`;
CREATE TABLE `infobus_results` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `answer_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of infobus_results
-- ----------------------------

Find public List<Trade> ActiveTrades;

Add after:

public int CurrentPollId;

You can start infobus question command :startquestion [question id]

[MentaL]

[Joopie]

Woow, its a long time ago when i saw a good uber addon/edit. Good job!
Posted via Mobile Device

[Livar]

Slaxxer had something like this! Amazing though.

[wy479]

Nice. +rep +like

[DoctorCooper]

+Rep / +Like, finally back to the basics :D

[Jax]

I like it :) +Like

[TimGlipper]

Nice! Can I please have your UberEMU?

+Rep

[Retro!]

Never thought I'd see this again. Well done.

[Shoelace]

Omg i love this

[GertJanA]

Would be nice if this was in Phoenix.
Gianni? Maybe something for you? x)

Greetz,

[HabMoon]

Great job! (:

[zer0 141]

Great Work ;)

Keep it up!

[Davidaap]

use tasks instead of threads.

[Subway]

Cool release

[=dj.matias=]

I release today might be open/close bus commands and room polls :)

[DoctorCooper]

I release today might be open/close bus commands and room polls :)

Nice idea, keep up to good work sir.

[NeonCrayonz]

I remember in slaxxer's emu, there was something like this. Nice to see it improved on and released. +1 Rep for you!

[Huginho98]

I can't find RequestHandlers[3004] = new RequestHandler(GetTrainerPanel);

[TashiaLurvesYou]

Awesome(:
someone code for phoenix too? :D