[R63] Part of (valentine) quests.

Why don't use something like:

PHP Code:

---

SELECT count(*) FROM user_quests WHERE user = '" + Session.GetHabbo().Id + "' AND process = '1'; 


---

??

COUNT(*) must be used as Uppercase in order to work

WHERE I FIND
Code:
Messenger.OnStatusChanged(false);
?

With the search tool

WHERE I FIND
Code:
Messenger.OnStatusChanged(false);
?
in that file? There are so many ..

Nice one, works like a treat :)

Quote:

---

Originally Posted by PEjump2

COUNT(*) must be used as Uppercase in order to work

---

wrong, sql statements are not case sensitive.

Quote:

---

Originally Posted by Sojobo

wrong, sql statements are not case sensitive.

---

Hmm weird, i learned @ school that they must be uppercase o_O.
Weird teacher i guess.

Quote:

---

Originally Posted by PEjump2

Hmm weird, i learned @ school that they must be uppercase o_O.
Weird teacher i guess.

---

Just tidier I guess, I do all my SQL in uppercase too, the SQL commands anyway like SELECT, UPDATE, WHERE, etc.

Somebody has the sql for the new quests the new days?

i Have made a small fix .
Search:

PHP Code:

---

OpenQuest.AppendStringWithBreak("FIND_STUFF"); 


---

And delete it.
ADD:

PHP Code:

---

OpenQuest.AppendStringWithBreak((string)Row["type"]) 


---

Search:

PHP Code:

---

AcceptQuest.AppendStringWithBreak("FIND_STUFF"); 


---

And delete it.
ADD:

PHP Code:

---

AcceptQuest.AppendStringWithBreak((string)Row["type"]) 


---

Search:
DoneQuest.AppendStringWithBreak("FIND_STUFF");
And delete it.
ADD:

PHP Code:

---

DoneQuest.AppendStringWithBreak((string)Row["type"]) 


---

Now .
Run this into your SQL Database:

PHP Code:

---

ALTER TABLE  `quest` ADD  `type` enum('FIND_HIDDEN_STUFF','FIND_STUFF') NOT NULL DEFAULT 'FIND_STUFF'; 


---

This serves to change the type of mission.

Screen:
http://img203.imageshack.us/img203/5900/43829305.png

Please update the first post with all new fixs =) Thanks :P

I see you had a firework going on there
if so, could you release them aswell? :)

Quote:

---

Originally Posted by Danny95

I see you had a firework going on there
if so, could you release them aswell? :)

---

i made them, but still aren't fully ;p
when i take time for it and i done it i will maybe release ;)

I will improve this code with a catalogue edit + a holograph (R63) code