PDA

View Full Version : query to change forum post counting?


Staxed
06-24-2006, 08:19 AM
Anyone have a query that will set all forums to count towards post count?

Hellcat
06-24-2006, 10:36 AM
IIRC that setting is part of the "options" bitfield / column of the "forum" table.

You can't do that with a single SQL query without affecting the other settings, I think....

How many forums are you talking of?

Staxed
06-24-2006, 02:18 PM
it's only about 20...i can do it manually...i was just trying to be lazy...:)

Paul M
06-24-2006, 02:37 PM
You could do it if you new which bit by doing a logical AND on the field, but it's not worth it for so few.