Adding to ForumInfo

[kwblue]

Hello,

I see $ForumInfo in my templates for information about the forum that is being displayed. I want to add to the query and display that information, but I have having a very difficult time for some reason.. Here is what I am doing in the functions.php file (fetch_foruminfo function):

$ForumInfoQuery = "
			SELECT forum.*,`AP`.`FirstInformation`, `AP`.`SecondInformation`, `AP`.`ThirdInformation`, NOT ISNULL(podcast.forumid) AS podcast
			FROM " . TABLE_PREFIX . "forum AS forum
			LEFT JOIN " . TABLE_PREFIX . "podcast AS podcast ON (forum.forumid = podcast.forumid AND podcast.enabled = 1)
			LEFT JOIN AP_ForumDetails as AP ON (AP.forumid = forum.forumid)
			WHERE forum.forumid = $forumid
		";

		$vbulletin->forumcache["$forumid"] = $vbulletin->db->query_first_slave($forumInfoQuery);

Basically I just added the 3 fields in the query and joined on the second 'Left Join'. Now - in my template (ForumDisplay), I would put:

$foruminfo[FirstInformation]

However - nothing ever shows up If I use any other field, though, besides my custom fields they show up properly.

I am sure it is something stupid, but I just can't figure it out.

What I am trying to accomplish: Give some extra information from a custom datatable about each forum. That information will be displayed in the ForumDisplay template when the user clicks on that forum. All the info will be either at the top of the forum or in a sidebar (haven't decided yet).

Thanks in advance!!!

[kwblue]

bump?

[Lynne]

Try:

PHP Code:

AP.FirstInformation as FirstInformation 


and similar for the others.