SECURITY: fix stupid XSS vulnerability on initial post submit; add in support for the new search API
SELECT f.forum_id,f.forum_type,f.forum_name,f.forum_desc,
COUNT(t.topic_id) AS num_topics, COUNT(p.post_id) AS num_posts,
p.post_id,t.topic_id,t.topic_title,u.username,u.user_level,p.timestamp FROM decir_forums AS f
LEFT JOIN decir_topics AS t
ON (t.forum_id=f.forum_id)
LEFT JOIN decir_posts AS p
ON (p.topic_id=t.topic_id)
LEFT JOIN users AS u
ON (u.user_id=f.last_post_user)
WHERE ( t.topic_id=f.last_post_topic AND p.post_id=f.last_post_id ) OR ( f.last_post_topic IS NULL AND f.last_post_id IS NULL )
GROUP BY f.parent,f.forum_id
ORDER BY f.forum_order;
SELECT COUNT(t.topic_id) AS num_topics, COUNT(p.post_id) AS num_posts FROM decir_forums AS f
LEFT JOIN decir_topics AS t
ON (t.forum_id=f.forum_id)
LEFT JOIN decir_posts AS p
ON (p.topic_id=t.topic_id)
GROUP BY f.forum_id
ORDER BY f.forum_order;
INSERT INTO decir_forums(forum_id,forum_type,forum_name,forum_order) VALUES(1,2,'Test category',1);
INSERT INTO decir_forums(forum_id,forum_type,forum_name,forum_desc,parent,forum_order,last_post_id,last_post_topic,last_post_user) VALUES(3,1,'Test forum 1','This is just a test forum.',1,2,3,3,2);
INSERT INTO decir_topics(topic_id,forum_id,topic_title,topic_icon,topic_starter,timestamp) VALUES(1,3,'Test topic 1',1,2,UNIX_TIMESTAMP());
INSERT INTO decir_posts(post_id,topic_id,poster_id,poster_name,timestamp) VALUES(1,1,2,'Dan',UNIX_TIMESTAMP());
INSERT INTO decir_posts_text(post_id,post_text,bbcode_uid) VALUES(1,'This post was created manually using SQL queries.
It is nothing more than a [b:0123456789]proof of concept[/b:0123456789]!
-Dan','0123456789');
INSERT INTO decir_forums(forum_id,forum_type,forum_name,forum_desc,parent,forum_order,last_post_id,last_post_topic,last_post_user) VALUES(4,1,'Test forum 2','This is just a test forum.',1,3,2,2,2);
INSERT INTO decir_topics(topic_id,forum_id,topic_title,topic_icon,topic_starter,timestamp) VALUES(2,4,'Test topic 2',1,2,UNIX_TIMESTAMP());
INSERT INTO decir_posts(post_id,topic_id,poster_id,poster_name,timestamp) VALUES(2,2,2,'Dan',UNIX_TIMESTAMP());
INSERT INTO decir_posts_text(post_id,post_text,bbcode_uid) VALUES(2,'This post was created manually using SQL queries.
It is nothing more than a [b:0123456789]proof of concept[/b:0123456789]!
-Dan','0123456789');
INSERT INTO decir_topics(topic_id,forum_id,topic_title,topic_icon,topic_starter,timestamp) VALUES(3,3,'Test topic 3',1,2,UNIX_TIMESTAMP());
INSERT INTO decir_posts(post_id,topic_id,poster_id,poster_name,timestamp) VALUES(3,3,2,'Dan',UNIX_TIMESTAMP());
INSERT INTO decir_posts_text(post_id,post_text,bbcode_uid) VALUES(3,'This post was created manually using SQL queries.
It is nothing more than a [b:0123456789]proof of concept[/b:0123456789]!
-Dan','0123456789');