[Para tu Holo] Retos de san valentin

[;D] hola amigos aqui les dejos los fix para los retros de san valentin

busca en MessagesRequestsUsers.cs: public void RegisterUsers()

arriba de eso pon

codigo:   private void OpenQuests()
        {
                        //L`val11JPASjJFIND_STUFFbling_chair_cQA1296543600000EXTRA01PkHFIND_STUFFval_table1QA1296630000000EXTRA02P]HFIND_STUFFbling_bedQA1296802800000DAY02SHFIND_STUFFbathQA1296716400000DAY01

            DataTable Data = null;
            DataRow QuestCount = null;

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                Data = dbClient.ReadDataTable("SELECT * FROM quests");
                QuestCount = dbClient.ReadDataRow("SELECT COUNT(*) AS total FROM quests");
            }

            if (Data == null)
            {
                return;
            }

            string Count = QuestCount["total"].ToString();
            int TotalQuestCount = int.Parse(Count);

            ServerMessage OpenQuest = new ServerMessage(800);
            OpenQuest.AppendStringWithBreak("val11"); // val11 / xmas10
            OpenQuest.AppendInt32(2);
            OpenQuest.AppendInt32(TotalQuestCount);

            foreach (DataRow Row in Data.Rows)
            {
                OpenQuest.AppendInt32((int)Row["id"]);
                OpenQuest.AppendInt32(0);
                OpenQuest.AppendStringWithBreak("FIND_STUFF");
                OpenQuest.AppendStringWithBreak((string)Row["item"]);
                OpenQuest.AppendInt32(5);
                OpenQuest.AppendStringWithBreak((string)Row["time"]);
                OpenQuest.AppendStringWithBreak((string)Row["data"]);
                OpenQuest.AppendStringWithBreak("");
            }

            Session.SendMessage(OpenQuest);
        }

        private void AcceptQuest()
        {
            //Laval11SKFIND_STUFFbathQA1296716400000DAY01

            DataTable Data = null;

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                Data = dbClient.ReadDataTable("SELECT * FROM quests WHERE id = '" + Request.PopWiredInt32() + "' LIMIT 1");
            }

            if (Data == null)
            {
                return;
            }

            foreach (DataRow Row in Data.Rows)
            {
                ServerMessage AcceptQuest = new ServerMessage(801);
                AcceptQuest.AppendStringWithBreak("val11");
                AcceptQuest.AppendInt32((int)Row["id"]);
                AcceptQuest.AppendInt32(3);
                AcceptQuest.AppendStringWithBreak("FIND_STUFF");
                AcceptQuest.AppendStringWithBreak((string)Row["item"]);
                AcceptQuest.AppendInt32((int)Row["hearts"]);
                AcceptQuest.AppendStringWithBreak((string)Row["time"]);
                AcceptQuest.AppendStringWithBreak((string)Row["data"]);
                AcceptQuest.AppendStringWithBreak("");
                Session.SendMessage(AcceptQuest);

                using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                {
                    dbClient.ExecuteQuery("INSERT INTO user_quests (`id`, `user`, `quest`, `process`) VALUES (NULL, '" + Session.GetHabbo().Id + "', '" + (int)Row["id"] + "', '3')");
                }
            }
        }  

Busca RequestHandlers[3000] = new RequestHandler(GetPetsInventory); y abajo de eso pon

codigo:             RequestHandlers[3102] = new RequestHandler(OpenQuests);
            RequestHandlers[3101] = new RequestHandler(AcceptQuest);  

Busca en MessagesRequestsRooms.cs: Item.Interactor.OnTrigger(Session, Item, Request.PopWiredInt32(), hasRights);

Encima de el pon

Codigo: //Lbval11P]IFIND_STUFFbling_bedQA1296802800000DAY02

            DataTable Data = null;

            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
            {
                Data = dbClient.ReadDataTable("SELECT * FROM user_quests WHERE user = '" + Session.GetHabbo().Id + "'");
            }

            if (Data == null)
            {
                return;
            }

            foreach (DataRow Row in Data.Rows)
            {
                if ((int)Row["process"] == 3)
                {
                    DataTable Data2 = null;

                    using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                    {
                        Data2 = dbClient.ReadDataTable("SELECT * FROM quests WHERE id = '" + (int)Row["quest"] + "'");
                    }

                    if (Data2 == null)
                    {
                        return;
                    }

                    foreach (DataRow Row2 in Data2.Rows)
                    {
                        if ((string)Row2["item"] == Item.GetBaseItem().Name)
                        {
                            ServerMessage DoneQuest = new ServerMessage(802);
                            DoneQuest.AppendStringWithBreak("val11");
                            DoneQuest.AppendInt32((int)Row2["id"]);
                            DoneQuest.AppendInt32(1);
                            DoneQuest.AppendStringWithBreak("FIND_STUFF");
                            DoneQuest.AppendStringWithBreak((string)Row2["item"]);
                            DoneQuest.AppendInt32((int)Row2["hearts"]);
                            DoneQuest.AppendStringWithBreak((string)Row2["time"]);
                            DoneQuest.AppendStringWithBreak((string)Row2["data"]);
                            DoneQuest.AppendStringWithBreak("");
                            Session.SendMessage(DoneQuest);

                            using (DatabaseClient dbClient = UberEnvironment.GetDatabase().GetClient())
                            {
                                dbClient.ExecuteQuery("UPDATE user_quests SET process = '1' WHERE quest = '" + (int)Row2["id"] + "' AND user = '" + Session.GetHabbo().Id + "'");
                                dbClient.ExecuteQuery("UPDATE users SET hearts = hearts + " + (int)Row2["hearts"] + " WHERE id = '" + Session.GetHabbo().Id + "'");
                            }

                            return;
                        }
                    }
                }
            }  

Pon esto en tu database

Codigo:  CREATE TABLE IF NOT EXISTS `quests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item` varchar(255) NOT NULL,
  `time` varchar(255) NOT NULL,
  `data` varchar(255) NOT NULL,
  `hearts` int(11) NOT NULL DEFAULT '5',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=173 ;

INSERT INTO `quests` (`id`, `item`, `time`, `data`, `hearts`) VALUES
(115, 'bath', '1296716400000', 'DAY01', 5),
(116, 'bling_bed', '1296802800000', 'DAY02', 5),
(172, 'val_table1', '1296630000000', 'EXTRA02', 5),
(171, 'bling_chair_c', '1296543600000', 'EXTRA01', 5),
(117, 'bling_toilet', '1296889200000', 'DAY03', 5);  

Y esto tambien :

Codigo:  CREATE TABLE IF NOT EXISTS `user_quests` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) NOT NULL,
  `quest` int(11) NOT NULL,
  `process` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ; 

y por ultimo

Codigo: ALTER TABLE  `users` ADD  `hearts` INT( 11 ) NOT NULL DEFAULT  '0'; 

ragezone

PD: cualquier duda mandarme un mp

Edit por EliteRoyal: Por un corchete [ en la tabla de user_quets xD