i want to get forums only That allowposting on it by Query

[omardealo]

hello ,

i use this query

$getforum = $db->query_read("SELECT forumid, title_clean FROM " . TABLE_PREFIX . " forum where ".$vbulletin->bf_misc_forumoptions['allowposting']." = '1'  ");

it not working , i want to get forums only That allowposting , and i don't know where i found forum permission on database .
thnx ...

--------------- Added [DATE]1394273222[/DATE] at [TIME]1394273222[/TIME] ---------------

forum permission for allowposting on options field , but how i use it ?

[Simon Lloyd]

You would need to look at the forumpermission table and the find which bit of the permissions shows allowed posting, you'd need to join the query with one looking at the forum table in order to get the forum name, it's a lot more complicated than you think.

[omardealo]

Originally Posted by Simon Lloyd

You would need to look at the forumpermission table and the find which bit of the permissions shows allowed posting, you'd need to join the query with one looking at the forum table in order to get the forum name, it's a lot more complicated than you think.

i look at forumpermission table already , and it's empty .. no data on it
sorry , but i think what you talk about is wrong
allowposting permission on options field -> Table: forum

thnx brother ,

[ozzy47]

What is it exactly you are trying to do, perhaps post the code and explain what it is you want.

[omardealo]

Originally Posted by ozzy47

What is it exactly you are trying to do, perhaps post the code and explain what it is you want.

i want make a dropdown list for only category that allowposting ...
i make it by another way , by product seeting i put all categorys and i can Chose the categorys that i want to exclude from appearing .

$forumbits_mod_forums = explode(",",  $vbulletin->options['forumbits_mod_forums']);   
$getforum = $db->query_read("SELECT forumid, title_clean FROM " . TABLE_PREFIX . " forum where forumid NOT IN ('" . implode("','",$forumbits_mod_forums) . "') order by displayorder ASC ");

but i want to know if there easy way to get only categorys (by query) that users can put on it new threads and exclude the others .

thnx ...

[Lynne]

Perhaps....

PHP Code:

$getforum = $db->query_read("SELECT forumid, title_clean FROM " . TABLE_PREFIX . "forum WHERE (options & 2) 


            <group name="forumoptions">
                <bitfield name="active">1</bitfield>
                <bitfield name="allowposting">2</bitfield>
                <bitfield name="cancontainthreads">4</bitfield>
                <bitfield name="moderatenewpost">8</bitfield>
                <bitfield name="moderatenewthread">16</bitfield>
                <bitfield name="moderateattach">32</bitfield>
.....