Top 100 most ignored members?

[BirdOPrey5]

Originally Posted by exel

Here you go: http://elite-source.com/web-design-d....html#post2104

Requested here: https://vborg.vbsupport.ru/showthrea...48#post2433448

PHP Code:

$ignorelistquery = $vbulletin->db->query_read("
SELECT ulist.userid, ulist.type, COUNT(ulist.relationid) AS exel, u.userid, u.username
FROM " . TABLE_PREFIX . " userlist as ulist
LEFT JOIN " . TABLE_PREFIX . " user as u ON(u.userid = ulist.relationid)
WHERE ulist.type ='ignore'
GROUP BY ulist.relationid
ORDER BY ulist.type DESC LIMIT 100
    "); 

    while($ignore = $db->fetch_array($ignorelistquery)) { 

    $exelusername = $ignore['username']; //Username by Exel @ Elite-Source
    $exeluserid = $ignore['userid']; //Ignore UserID by Exel @ Elite-Source
    $exelcount = $ignore['exel']; //Ignore Count by Exel @ Elite-Source

        $topignorelist .= "   
        <div style='background-color: alt1; padding: 4px; border-bottom: 1px solid rgb(163,163,163);'>   
        <div style='padding-top: 1px; padding-bottom: 1px;'><span><a href='member.php?u=$exeluserid'>$exelusername</a></span><span style='color: #1b5c75;margin-right: 5px;float:right;'>(Ignored $exelcount times)</span></div> 
        </div>";   
    }   
    $db->free_result($ignorelistquery); 


There are spaces after each " . TABLE_PREFIX . " that must be removed to prevent db errors if a table prefix is present.