[dicb]

I should note, I backedup the entire new forum directory, so my numbers may be off here, especially since I see them replacing things in the install dir. I just thought better safe than sorry since their may be more things that needed changes made in them than 3.0.8 did.

First replace... 597 replaced in 315 documents.

Second replace... 8 replaced in 315.

Third replace... 77 replaced in 315.

#8 - changed [ . TABLE_PREFIX . $idname] to [. "$idname] on line 1242 of /includes/functions.php

print_chooser_row (with two o's) starts on line 1497 of /includes/adminfunctions.php. started replacement at 1506, but I'm not sure I did it right. I replaced

if (!is_array($GLOBALS["$cachename"]))
	{
		$GLOBALS["$cachename"] = array();
		$result = $vbulletin->db->query_read("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title");
		while ($currow = $vbulletin->db->fetch_array($result))
		{
			$GLOBALS["$cachename"]["$currow[$tableid]"] = $currow['title'];
		}
		unset($currow);
		$vbulletin->db->free_result($result);
	}

with

if ($tableid == "user" OR $tableid == "usergroup") { 
                $result = $DB_site->query("SELECT title, $tableid FROM "."$tablename $wherecondition ORDER BY title"); 
        } else { 
                $result = $DB_site->query("SELECT title, $tableid FROM " . TABLE_PREFIX . "$tablename $wherecondition ORDER BY title"); // existing code 
        }

Once again, I have no idea if that's right.

construct_style_choose starts on line 166. Replaced on line 175,

	$tableid = $tablename . "id";

with...

$tableid = $tablename . "id"; 

    if ($tablename == "user" OR $tablename == "usergroupid") { 
        $result = $DB_site->query(" 
            SELECT title, $tableid 
            FROM "."$tablename 
            WHERE userselect = 1 
            ORDER BY title 
        "); 

    } else { 
                // existing code 
                        $result = $DB_site->query(" 
            SELECT title, $tableid 
            FROM " . TABLE_PREFIX . "$tablename 
            WHERE userselect = 1 
            ORDER BY title 
        "); 
    }

I'm not sure I did everything right, or if there is more that needs to be done, however that is what I did. I am uploading them now, but don't have time to test it. Timestamp should give an idea of how long it took, but subtract one cig break for sanity.