Search options

OK, so it looks as if the PunBB database schema is not normalised.  For example, the topics relatation contains a count of the number of posts to that topic; this needs to be updated each time the topics relation is modified.  This is not something that they encourage in the database design textbooks!  Anyway, I have used the following to "fix" this de-normal data:

update forums set num_topics = (select count(*) from topics where forum_id=forums.id);
update forums set num_posts = (select count(*) from posts p join topics t on (p.topic_id=t.id) where forum_id=forums.id);
create temporary table last_posts as
   select p.topic_id, p.posted as last_post, last_post_id, p.poster as last_poster from
    (select topic_id, max(id) as last_post_id from posts group by topic_id) lp join posts p on(lp.last_post_id=p.id);
update topics set last_post=(select last_post from last_posts where topic_id=topics.id);
update topics set last_post_id=(select last_post_id from last_posts where topic_id=topics.id);
update topics set last_poster=(select last_poster from last_posts where topic_id=topics.id);
update topics set num_replies = (select count(*) from posts where topic_id=topics.id);

Notes:
- I updated forums.last_[post|poster|post_id] manually.
- This may not work properly when a topic has only one post in it.

I tried that, and I just saw the contents of the file.
Guessing, I added a line at the start saying <?php and a line at the end saying ?>
Now I don't see any output when I load the page, but the forum still seems to have incorrect page numbers, "Replies" counts and other things.
Where is this cached data kept?  Is it all in the database, or is it in the filesystem?

Thanks for your help.

Phil.

I've had a go at this and have quite quickly removed the spam from the database.

But it looks as if the "page 1,2,3....7,8,9" stuff has been cached somewhere, as has the "last post" information.

Can anyone suggest what I need to do to update this?

Thanks,

Phil.

Thanks Ludo.  Search didn't find that post - maybe we also need speeling-correction for search!

--Phil.