Where does the "forum list" SELECT statement reside?

[footose]

Yes! I was just running that as you typed that! And it wouldn't be fun if it wasn't easy Thanks so far, I'm kind of new at the VBulletin end of things, but seem to be picking it up quick.

Seems it a combination of the fields of the "forum" table in the vbulletin database and something else I have yet to figure out. EDIT: Looks like the last part of it is the permissions for the forum.

Here is a list from what I got for anyone that is interested.

PHP Code:


array(53) 
{ 
    [3]=> array(31) 
    { 
        ["forumid"]=> int(3) 
        ["styleid"]=> int(0) 
        ["title"]=> string(4) "Main" 
        ["title_clean"]=> string(4) "Main" 
        ["description"]=> string(0) "" 
        ["description_clean"]=> string(0) "" 
        ["options"]=> int(89795) 
        ["displayorder"]=> int(10) 
        ["daysprune"]=> int(-1) 
        ["newpostemail"]=> string(0) "" 
        ["newthreademail"]=> string(0) "" 
        ["parentid"]=> int(-1) 
        ["parentlist"]=> string(4) "3,-1" 
        ["password"]=> string(0) "" 
        ["link"]=> string(0) "" 
        ["childlist"]=> string(28) "3,27,11,32,36,35,33,34,47,-1" 
        ["importforumid"]=> int(0) 
        ["importcategoryid"]=> int(1) 
        ["lastpostid"]=> int(0) 
        ["showprivate"]=> int(0) 
        ["defaultsortfield"]=> string(8) "lastpost" 
        ["defaultsortorder"]=> string(4) "desc" 
        ["hasstatusicons"]=> int(1) 
        ["statusiconon"]=> string(29) "/images/misc/general_disc.png" 
        ["statusiconoff"]=> string(29) "/images/misc/general_disc.png" 
        ["statusiconlockon"]=> string(29) "/images/misc/general_disc.png" 
        ["statusiconlockoff"]=> string(29) "/images/misc/general_disc.png" 
        ["statusiconlink"]=> string(29) "/images/misc/general_disc.png" 
        ["podcast"]=> int(0) ["depth"]=> int(0) 
        ["permissions"]=> array(10) 
        { 
            [4]=> int(655375) 
            [6]=> int(1048575) 
            [21]=> int(0) 
            [7]=> int(782847) 
            [2]=> int(782591) 
            [5]=> int(1048575) 
            [24]=> int(782591) 
            [20]=> int(783607) 
            [1]=> int(659471) 
            [3]=> int(655375) 
        } 
    } 
    
} 


This looks like "array 1" holds 53 of these other elements, (i have 53 forums, therefore I assume this holds all the data for each forum). and inside of each, it holds what is parsed by the cache...

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

Just to note, I just checked the database, and I can confirm that the first part of the array will be the forum number, and the second part of the array will be whatever is listed in your "forum" database, and the final part of the array will be yet another array of the permissions

Example:
Forum # = 3, Title = "Main", Description = "Whatever"

echo $vbulletin->forumcache[3]["Title"]

...

will print "Main"

echo $vbulletin->forumcache[3]["Description"]

...

will print "Whatever"

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

I have to also note that this doesn't help my original goal, because this does not contain the "last post", "views" and "posts" columns like I original thought it would.

Back to the drawing board. Hopefully this helps someone else.