[lunitius]

This is my first stab at creating the modification I was asking for in my previous post. Basically I want the "select" box that is visible on the "write" page for wordpress to offer some more usability:

1. I wanted it to be larger (easy enough)
2. I wanted it to show the relationships between my top-level forums (Categories), my second level forums (Forums) and my third level forums (Sub-Forums) so that I could make intelligent decisions about which "forum" i wanted my post to be in.

Here is the modification. It is pretty raw right now but functional. I am working to factor it out to something a little more friendly to anyone by using the various api calls and variables presented from VB. Once I get the next cut done which should include these "upgrades" I will post it as well.

I attached a picture of what this looks like as well so you can get an idea of what I am talking about in case I am not explaining it clearly. See the attachments.

If you have any thoughts on how to do this better or more efficiently please let me know. I am decent coder but struggle with arrays:

This is a context diff of vbbridge.php

[root@abbadon plugins]# diff -b -B -c vbbridge.php.orig vbbridge.php
*** vbbridge.php.orig   Sun May 20 23:15:23 2007
--- vbbridge.php        Mon May 21 22:47:32 2007
***************
*** 421,440 ****
  function VB_Post_Form () {
  if (get_option('vbb_VBPOST')) {
  ?>
! <CENTER> Select Forum To Post To: <BR><select id="forumid" name="forumid" class="inputbox" size="5" >
! 
  <?php
  $wpdb =& $GLOBALS['wpdb'];
- $sql = "SELECT forumid, title FROM " . get_option('vbb_VBPRX') . "forum order by displayorder";
- $results = $wpdb->get_results($sql);
  
  
! foreach ($results as $forum) {
! if ($forum->forumid == get_option('vbb_VBFID')) { $selector = ' selected'; } else { $selector = ''; }
! echo "<option value=$forum->forumid$selector>$forum->title</option>\n";
  }
- 
  ?>
  </select>
  <BR>
  Or
--- 421,491 ----
  function VB_Post_Form () {
  if (get_option('vbb_VBPOST')) {
  ?>
! <!-- BEGIN EDIT BY ISI -->
! <CENTER> Select Forum To Post To: <BR><select id="forumid" name="forumid" class="inputbox" size="20" >
  <?php
  $wpdb =& $GLOBALS['wpdb'];
  
+ // connect to db (i couldn't figure out how to get this to work with the vbulletin api)
+ $conn = mysql_connect("localhost","dden","Oicu812");
+ mysql_select_db("dden_blog", $conn);
+ 
+ // create an array to keep track of what has been printed so we don't do it more than once
+ $printed = array();
+ 
+ // Get all top level (no parent) forums
+ $results = mysql_query("SELECT forumid, title, childlist FROM " . get_option('vbb_VBPRX') . "forum where parentid = '-1'");
+ while ($row = mysql_fetch_array($results, MYSQL_ASSOC))
+ {
+     // Check to see if the forumid has already been printed.
+     // If not print it and add it to the array of printed forumid to prevent duplicates
+     if (!array_search($row['forumid'], $printed))
+     {
+         echo "<option value=$row[forumid]>$row[title]</option>\n";
+         array_push($printed, $row['forumid']);
+     }
+ 
+     // Get the forumid and title of the children of the top level
+     $childlist = explode(",", $row['childlist']);
+     foreach ($childlist as $child1)
+     {
+         if ($child1 != $row['forumid'])
+         {
+             $child1_results = mysql_query("SELECT forumid, title, childlist FROM " . get_option('vbb_VBPRX') . "forum where forumid = '$child1'", $conn);
+             while ($child1_row = mysql_fetch_assoc($child1_results))
+             {
+                  // Check to see if the forumid has already been printed.
+                  // If not print it and add it to the array of printed forumid to prevent duplicates
+                 if (!array_search($child1_row['forumid'], $printed))
+                 {
+                     print "<option value=$child1_row[forumid]>--> $child1_row[title]</option>\n";
+                     array_push($printed, $child1_row['forumid']);
+                 }
+ 
+                // Get the forumid and title of the children of the first level for forum
+                $childlist2 = explode(",", $child1_row['childlist']);
+                foreach ($childlist2 as $child2)
+                {
+                    if ($child2 != $child1_row['forumid'])
+                    {
+                        $child2_results = mysql_query("SELECT forumid, title, childlist FROM " . get_option('vbb_VBPRX') . "forum where forumid = '$child2'", $conn);
+                        while ($child2_row = mysql_fetch_assoc($child2_results))
+                        {
+                            if (!array_search($child2_row['forumid'], $printed))
+                            {
+                                print "<option value=$child2_row[forumid]>&nbsp; &nbsp;----> $child2_row[title]</option>\n";
+                                array_push($printed, $child2_row['forumid']);
+                            }
+                        }
+                    }
+                }
+             }
+         }
  
!     }
  }
  ?>
+ <!-- END EDIT BY ISI -->
  </select>
  <BR>
  Or

Suggestions and comments welcome.

-- Isi