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 1193711936 at 1193711936 ---------------

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) :

$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 1193712265 at 1193712265 ---------------

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 1193713244 at 1193713244 ---------------

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!