Access custom forum db column

[amnesia623]

I have added a column to the forum table. Can I access it via forum[mytable] somehow or do I have to create a new query?

[Paul M]

Again, the array name depends on where you are in vb, but generally, it's $foruminfo['column-name']

[amnesia623]

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

I can't seem to figure out how to get it to work and I'll try to explain the best I can what I want to do...

The table vb_forum has the column 'menuid'. This column will hold a number that will correspond with a menu id in another table and load the appropriate content.

Right now I am just trying to get the contents of the 'menuid' cell to output.

All menuid cells have been populated with the number 5

here is the php code in the plugin assigned to the 'global_start' hook (product:vbulletin, execution order:5) :

PHP Code:

$mytest = $foruminfo['menuid']; 


I have the variable $mytest outputting in a custom template that is called in the FORUMDISPLAY and FORUMHOME templates. I know the variable is displayed correctly because if I assign it a straight value (ie...'$mytest = "hello world" it displays correctly.

What am I doing wrong in the above code that is preventing me from either reading or displaying the 'menuid' column?

I am really looking forward to figuring this out so I can write some other mods.

Thanks

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

I can also display all the other columns in the row via foruminfo[column], just not the one I added.

do I need to run a maintenance function to maybe pull that info into a cache of some sort?

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

gotta love automerge....

It seems that I need to build the forum information in order to get this to work.

Thanks, Paul, for all your help!