https://www.icyphoenix.com/viewtopic.php?f=35&t=5530&p=37096#p37096
-----------------------------------
Bicet
Mon 02 Mar, 2009 14:09

[BUG] Recent Topics- Today&Yesterday
-----------------------------------
Here's yesterday

[quote]error getting total topics.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (p.post_time + 86400 + 3600) > 1235952000 AND (p.post_time + 3600) < 1235952' at line 3

SELECT count(DISTINCT(t.topic_id)) AS total_topics FROM phpbb_topics t, phpbb_posts p WHERE t.forum_id NOT IN (11,12,19,20,23,31,38) AND AND (p.post_time + 86400 + 3600) > 1235952000 AND (p.post_time + 3600) < 1235952000 AND p.post_id = t.topic_last_post_id

Line : 438
File : recent.php[/quote]

And Today

[quote]
error getting total topics.

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (p.post_time + 3600) > 1235952000 AND p.post_id = t.topic_last_post_id' at line 3

SELECT count(DISTINCT(t.topic_id)) AS total_topics FROM phpbb_topics t, phpbb_posts p WHERE t.forum_id NOT IN (11,12,19,20,23,31,38) AND AND (p.post_time + 3600) > 1235952000 AND p.post_id = t.topic_last_post_id

Line : 438
File : recent.php[/quote]


