Automatic activation of a forum

[Flimflamsam]

(Copied from my post at vbulletin.com)
Hi all,

I'm wanting to use a cronjob'd PHP script to activate a forum, but I do not know which/where to change it in the database to make the forum "active".

I noticed on forums of the same type (we have several of the same basic forum, but each for different weeks) the 'options' field in the database was 89799 and the ones on the "inactive" forums were 89798 so I tried it by changing the number to 89799 on the new one, but this didn't work and that was the only notable difference in the forum data, barring the forumIDs, etc.

Can someone tell me what needs to change in the database for the forum to become active?

-- a month passes --

So I've had a bit more time to look at this, and will probably just post it on vb.org - but anyway, here's what I've found so far.

The SQL that vbulletin uses is about the same as what I was using, that is something like this:

update forum set options='89799' where forumid=123

Now this code does work, and changes the data as expected, but the forum still does not become active. So I looked at the admincp code and noticed it ran a few functions after a forum update. These are:

build_forum_parentlists($forumid);
build_forum_child_lists($parentid);
build_forum_child_lists($oldforuminfo['parentid']);
build_forum_permissions();

So I've added those into my script as well (I've used the standard vbulletin libraries and functions, by including them).

This still doesn't seem to have changed the 'active' flag of the forum. I also get that 89799 number from the correct convert_array_to_bits() function.

Anyone have any ideas as to what I need to get this working OR an alternative to achieve the same result?

PS. Mods, apologies - I think this probably belongs more in the "Coding Questions" forum.