[Quarterbore]

OK, I got help from paul41598 on this but by changing the Latest Paid Subscribers pluggin to as follows this works 100% on my site (tested in 3.6.0. and 3.6.1.)

PHP Code:

// plugin by Paul41598

if ($vbulletin->options['latest_paid_subscribers_reminder_on'])
{    
if ($vbulletin->userinfo['userid'] AND !$_COOKIE['lpscookie']) {
$alertdays = $vbulletin->options['latest_paid_subscribers_warndays'];
$day1 = (TIMENOW + ($alertdays * 86400));
$getexpirers = $vbulletin->db->query_read("
SELECT subscriptionlog.userid, subscriptionlog.subscriptionid, subscription.subscriptionid, subscriptionlog.expirydate,
user.userid, user.username
FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog, " . TABLE_PREFIX . "subscription AS subscription
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (subscriptionlog.userid = user.userid)
WHERE subscriptionlog.status != '0' AND subscriptionlog.subscriptionid = subscription.subscriptionid AND user.userid = ".$vbulletin->userinfo['userid']." AND subscriptionlog.expirydate < $day1
ORDER BY subscriptionlog.expirydate ASC LIMIT 5");


    while($getexpirer = $vbulletin->db->fetch_array($getexpirers))
    {
      $expiryremaining = round((($getexpirer['expirydate'] - TIMENOW)/86400),2);
    $expirytitle = $getexpirer['title'];
    $expirydate = vbdate('F jS, Y', $getexpirer['expirydate']);
    eval('$expiryalert .= "' . fetch_template('expirydatebits') . '";');
    }
}
}

if ($vbulletin->options['latest_paid_subscribers_on'])
{        
$show['subscribers'] = true;
$max = $vbulletin->options['latest_paid_subscribers'];

$getsubscribers = $vbulletin->db->query_read("
SELECT subscriptionlog.userid, subscriptionlog.status, subscriptionlog.regdate, subscriptionlog.expirydate,
user.userid, user.username, user.usergroupid, displaygroupid,
usergroup.usergroupid, usergroup.title,
groupa.opentag as opentaga, groupa.closetag as closetaga, 
groupb.opentag as opentagb, groupb.closetag as closetagb
FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
LEFT JOIN " . TABLE_PREFIX . "user as user ON (subscriptionlog.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE subscriptionlog.status != '0' ORDER BY subscriptionlog.regdate DESC LIMIT 0, $max");


if ($vbulletin->db->num_rows($getsubscribers) > 0)
{
    $count = 0;
    while($getsubscriber = $vbulletin->db->fetch_array($getsubscribers))
    {
       
        $getsubscriber['opentag'] = $getsubscriber['opentagb'] ? $getsubscriber['opentagb'] : $getsubscriber['opentaga'];
        $getsubscriber['closetag'] = $getsubscriber['closetagb'] ? $getsubscriber['closetagb'] : $getsubscriber['closetaga'];

if ($vbulletin->options['latest_paid_subscribers_dateselect'])
        {
        $expireson = vbdate($vbulletin->options['latest_paid_subscribers_dateselect'], $getsubscriber['expirydate']);
        }
else {
        $expireson = vbdate($vbulletin->options['dateformat'], $getsubscriber['expirydate']);
     }

if ($vbulletin->options['latest_paid_subscribers_hoverover']) {
        $subscribers[$count] .= "<a href=\"member.php?" . $vbulletin->options[sessionurl] . "u=$getsubscriber[userid]\" title='$getsubscriber[username] Subscription Expires On: $expireson'>";
        $subscribers[$count] .= $getsubscriber['opentag'].$getsubscriber['username'].$getsubscriber['closetag']."</a>";
        $count++;
        }
    else {
        $subscribers[$count] .= "<a href=\"member.php?" . $vbulletin->options[sessionurl] . "u=$getsubscriber[userid]\" title='$getsubscriber[title]'>";
        $subscribers[$count] .= $getsubscriber['opentag'].$getsubscriber['username'].$getsubscriber['closetag']."</a>";
        $count++;
    }    

    }
    
    $showsubscribers = implode(", ", $subscribers);
    unset($count, $getsubscriber, $max);
    @mysql_free_result($getsubscribers);
}
} 


The difference is in these TWO lines of code!

PHP Code:

LEFT JOIN " . TABLE_PREFIX . "user as user ON (subscriptionlog.userid = user.userid) 
LEFT JOIN " . TABLE_PREFIX . "usergroup as usergroup ON(user.usergroupid = usergroup.usergroupid) 


My site uses PHP 4.4.1. and MySQL 4.1.21 in case that helps debug this... but it works 100% with those two "As" terms included!

Oh yea, did you mean to have you help link in your hack go to Google (as opposed to here?)?