[R63] Part of (valentine) quests.

Uhm TopErwin i've coded the Count function inside the ShowQuests void, here it is :

PHP Code:

---

        public void ShowQuests()
        {
            //L`val11{{2}}JPASjJFIND_STUFF{{2}}bling_chair_c{{2}}QA1296543600000{{2}}EXTRA01{{2}}{{2}}PkHFIND_STUFF{{2}}val_table1{{2}}QA1296630000000{{2}}EXTRA02{{2}}{{2}}P]HFIND_STUFF{{2}}bling_bed{{2}}QA1296802800000{{2}}DAY02{{2}}{{2}}S\HFIND_STUFF{{2}}bath{{2}}QA1296716400000{{2}}DAY01{{2}}{{2}}

            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);
        } 


---

Quote:

---

Originally Posted by PEjump2

Uhm TopErwin i've coded the Count function inside the ShowQuests void, here it is :

---

lolz, forgote it >,<
tnx for remembering me to do it ;)

its amazing release.Thanks :)

Damn this gets coded pretty fast o.o

Nice to see some of you 'working together' in a way, :D

Quote:

---

Originally Posted by habmoon

Damn this gets coded pretty fast o.o

Nice to see some of you 'working together' in a way, :D

---

No, just have this 2 days short school days,
if you work 2 days about 1/2 hours on it you can get verry big part done ;)
(if you know how to code with packets etz >,<)

Quote:

---

Originally Posted by toperwin

lolz, forgote it >,<
tnx for remembering me to do it ;)

---

I'm not remembering you to do it, i've already done it, re-check my post >_>

--- Edit ---

Why aren't you using something like this? :

PHP Code:

---

int QuestID = Request.PopWiredInt32(); 


---

Quote:

---

Originally Posted by PEjump2

I'm not remembering you to do it, i've already done it, re-check my post >_>

---

i'm not saying that you are wrong/bad?
i just say thanks to remember me that that wasn't just done,

Quote:

---

Originally Posted by toperwin

i'm not saying that you are wrong/bad?
i just say thanks to remember me that that wasn't just done,

---

You should rly do something about you'r english, you can't even understand a normal sentence..
And wouldn't it be better to create a own class for the Quests and Cache all quest-page data in a Array on Emulator startup? ^_^

Doen't work for me when I click on the heart button I get a error, i have do anything, somebody can help me?

Quote:

---

Originally Posted by YabMeernl

Doen't work for me when I click on the heart button I get a error, i have do anything, somebody can help me?

---

Update your swf, i have on bottom of my toppic a cracked swf from anthony93260.

//Nevermind works\\
///////////\\\\\\\\\

Thanks for this :D
Hope that 'knowing if quest is done' part is done fast =D

now only need to buy in our catalog not?

#1054 - Unknown column 'hearts' in 'field list'

what can I do?

this work whit no error:

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 ;

but.. make no hearts.... :?:

Quote:

---

Originally Posted by baddragon

#1054 - Unknown column 'hearts' in 'field list'

what can I do?

---

Run this sql:

PHP Code:

---

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


---

Quote:

---

Originally Posted by toperwin

Run this sql:

PHP Code:

---

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


---

---

yes... i have this in users...

hearts int(11) 0