vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)
-   -   Top 100 most ignored members? (https://vborg.vbsupport.ru/showthread.php?t=296173)

dutchbb 03-16-2013 12:08 AM
Top 100 most ignored members?
 
Someone on our forums asked for this. Top 100 of members who are ignored by the most other members (on the ignore list).

I believe it does not exist yet?

dutchbb 07-04-2013 05:43 PM
Anyone interested?

exel 07-13-2013 05:01 AM
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); 
You can add that to a global_complete hook / plugin then use $topignorelist wherever you want it.

From the looks of it, though.. you want it on an external page, so you can just add this to the PHP page you're going to use it on. ;)

And remember, you still need to add a table around it.

So it'd be something like..

HTML Code:
<table width="100%">
<tr>
<td>
Top 100 Ignored Members
</td>
</tr>
<tr>
<td>
$topignorelist
</td>
</tr>
</table>

dutchbb 07-13-2013 02:01 PM
1 Attachment(s)
Thanks but I just tried it and it returned a blank page on all the forum.

So not working for vBulletin 3.8.7 Patch Level 3

exel 07-13-2013 05:40 PM
Here you go, I turned it into a product. :)

https://vborg.vbsupport.ru/showthread.php?t=300073

BirdOPrey5 07-18-2013 11:06 AM
Quote:
Originally Posted by exel (Post 2433448)
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.

exel 07-19-2013 02:15 AM
Sorted product.


All times are GMT. The time now is 12:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01063 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_html_printable
  • (2)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete