MySQL query for making a FORUM Active/Open ?

[jwocky]

Does anyone know what the SQL query would be to make a certain forumid into an "Active" forum and an "Open" forum.. and vice versa?

Would be much appreciated!!

Update:

Ok I *think* I found the location where this info is kept and changed

Its in the forum.options area..

Now it seems my defauly forums have options of "87751" while one that has the Forum Active/Open settings set to NO are listed as "87748"

So I made a Db query command to change the 87748 to an 87751 to open a restricted forum..

PHP Code:

    if ($subfid>0)
    {
    echo "ACTIVE!!";
    $vbulletin->db->query_write(" 
        UPDATE " . TABLE_PREFIX . "forum 
        SET options = " . $activeperm ." 
        WHERE forumid = $subfid 
    "); 
    } 


Now the change goes through on the database.. and if I open the subforum options in AdminCP is lists the change as having taken effect (just from looking at the radio button things)..

But the problem is in the forum display to the user, the change doesnt take effect.. ie. the users still cant see the forum. The change doesnt go through until I resubmit the forum options form in AdminCP then it works..

Any ideas on why this is acting like that ?

Thanks!!!

Ps. Ive been doing more reading thru old threads and Im wondering if my problem has to do with updating the 'datastore' anyone know if i'm barking up the right or wrong tree here ?