vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Adding to ForumInfo (https://vborg.vbsupport.ru/showthread.php?t=203536)

kwblue 01-29-2009 09:02 PM
Adding to ForumInfo
 
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):

Code:
$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:

Code:
$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 02-02-2009 05:05 PM
bump?

Lynne 02-02-2009 08:03 PM
Try:
PHP Code:
AP.FirstInformation as FirstInformation 
and similar for the others.


All times are GMT. The time now is 05:51 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01086 seconds
  • Memory Usage 1,715KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete