[wottech]

So my first LEFT JOIN using the showthread_query hook needs to be to include 'garage_user_vehicle' then? Let me go try that...

Yeah, that didn't work either...

PHP Code:

if(THIS_SCRIPT == 'showpost' OR THIS_SCRIPT == 'showthread')
{
$hook_query_fields .= ",garage_user_vehicle.*"; 
$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "garage_user_vehicle AS uservehicle ON(garage_user_vehicle.user_id = post.userid)";
} 


It is still not seeing garage_user_vehicle as a valid table. If someone could explain how I can associate the garage "user_id" to the post "userid" using the showthread_query, I would greatly appreciate it. If I can get that far, then I can probably figure out the rest of it (maybe). Thanks for the help so far...

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

Ok finally figured it out! Now to continue on with the rest of the queries...

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

Ok, I am finally back to the original issue - the IF-ELSE IF-ELSE conditional not working inside the plugin. I think I have another issue with the ORDER statement, as in 1 instance I am trying to retrieve up to 10 entries, but that causes the post to repeat itself. I may just have to do away with that as an option... Anyway, here are the 2 plugins I currently have working using the showthread_query:

PHP Code:

if(THIS_SCRIPT == 'showpost' OR THIS_SCRIPT == 'showthread')
{
   switch ($vbulletin->options['postbittype'])
    {
      case 1: $pbq = ",uservehicle.main_vehicle DESC LIMIT 1"; break;
      case 2: $pbq = ",uservehicle.main_vehicle DESC LIMIT 1"; break;
      case 3: $pbq = ",uservehicle.vehicle_id DESC LIMIT 10"; break;
    }  
$postorder .= $pbq;
$hook_query_fields .= ",uservehicle.user_id AS garageuser"; 
$hook_query_fields .= ",makes.make AS garagemake";
$hook_query_fields .= ",uservehicle.made_year AS garageyear";
$hook_query_fields .= ",models.model AS garagemodel";
$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "garage_user_vehicle AS uservehicle ON(uservehicle.user_id = post.userid)";
$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "garage_makes AS makes ON (uservehicle.make_id = makes.id)";
$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "garage_models AS models ON (uservehicle.model_id = models.id)";
} 


PHP Code:

$newyr = substr($post[garageyear], -2);
$gi = 0;

    if($vbulletin->options['postbittype'] == 3)
    {
        while ($gi<10) {     
                $template_hook['postbit_userinfo_right_after_posts'] .= "<div>Test</div>";
                $gi = $gi+1;
                }     
    } else if($vbulletin->options['postbittype'] == 2) {
        $template_hook['postbit_userinfo_right_after_posts'] .= "<div><img src='images/garage/car.png'><a href=garage.php?do=user_garage_view&id=$post[garageuser]> $post[username]'s Garage</a></div>";
    } else {
        $template_hook['postbit_userinfo_right_after_posts'] .= "<div><a href=garage.php?do=user_garage_view&id=$post[garageuser]>'$newyr $post[garagemake] $post[garagemodel]</a></div>";
       } 


I know the postbittype is being set, as it is in the db correctly, and as stated earlier, when it tries to return multiple entries (and that option is set), then the same post is displayed X number of times. So what are the possible issues with the conditional which is causing it not to work? Thanks!