Onderwerp

[Trajan Myksos]

Test.

[Marcus Myksos]

het werkt!!!

[Trajan Myksos]

Seems like it, yes.

[Trajan Myksos]

Weird... everything within this topic is shown on the eagle?

[Marcus Myksos]

what does it mean O_o ???

[Trajan Myksos]

Ari is going to take a look. I'm curious if he will find a way to solve the problem.

[ari]

Had a spot of trouble with the query to do the announcements. Not entirely sure how it worked before, I suppose I was lucky. Here, have a sample of what the line building the query used to be:

Code: Select all

$sql = "SELECT t.forum_id AS forum_id, post_text, post_time, post_subject, bbcode_uid, bbcode_bitfield FROM phpbb_posts AS p JOIN phpbb_topics AS t ON p.topic_id = t.topic_id WHERE t.forum_id in (" . implode (', ', $announcements_keys) . ") AND t.topic_id = (SELECT MAX(it.topic_id) FROM phpbb_topics AS it WHERE it.forum_id = t.forum_id) GROUP BY p.forum_id ORDER BY t.topic_id DESC, p.post_id";

... and what it was changed to:

Code: Select all

$sql = "SELECT forum_id, post_text, post_time, post_subject, bbcode_uid, bbcode_bitfield FROM phpbb_posts p JOIN (SELECT MIN(pi.post_id) AS post_id FROM phpbb_posts pi JOIN (SELECT MAX(ti.topic_id) AS topic_id FROM phpbb_topics ti WHERE ti.forum_id IN (" . implode (', ', $announcements_keys) . ") GROUP BY forum_id) tn USING(topic_id) GROUP BY forum_id) pn USING(post_id);";

I'm not sure whether these would make more sense with some whitespace. I find that SQL lacks structure anyway.

[Trajan Myksos]

It's Latin to me anyway.