Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Topic paging issue

@_ck_

Participant

Thinking out loud here, don’t do anything yet on your own.

This is Sam’s new routine in 1.0.2 based on my alternate recount for bbpress 0.9

$sql = “INSERT INTO $bbdb->topics (topic_id, topic_posts)

(SELECT topic_id, COUNT(post_status) as topic_posts

FROM $bbdb->posts

WHERE post_status = ‘0’ GROUP BY topic_id)

ON DUPLICATE KEY UPDATE topic_posts = VALUES(topic_posts);

“;

I will investigate further…

Skip to toolbar