User IDs to User Names

[SFishy]

Doesn't seem anyone is interested in this... I'm hoping to spark an interest in someone who might find this useful information to have.

I have this little script that I downloaded here at vbulletin.org (see attached). It tells you what members are being ignored, and who they are being ignored by.

I don't even need to know the "ignored by" part, but it's an added bonus.

Two problems I have...

I'd like to get this info into a template and I don't even know how to start...

I'd like the userIDs (from the ignore lists) to actually be translated into the usernames.

Anyone want to help?

Thanks...

[SFishy]

This is what the output looks like currently...

[SFishy]

Hi all, just bumping this up...

Here's me trying to convince someone with the know-how: it would be really useful information to have to see who your users consider to be "trouble makers" ... to know who they are ignoring.

I tried to figure out how to get it into a template myself, or how to get the user IDs to convert over to usernames, and I couldn't do either -- I'm really a programming dummy!

*begging* anyone?

[Boofo]

In that file, change this:

PHP Code:

SELECT ignorelist, username 


to this:

PHP Code:

SELECT ignorelist, username, userid 


[SFishy]

Thanks Boofo... but that didn't work

[Boofo]

What are you trying to do exactly?

[SFishy]

Boofo,

Ignore.php spits out a list of users who have people on their ignore list. Their ignore list is shown as a series of userID numbers. If there's more than 1, they are separated by a space.

Look at the attached .gif above in my first reply...

Part 1. I was the userIDs translated into usernames.
Part 2. I was the whole thing in some kind of template.

[filburt1]

PHP Code:

// assuming the list is in $user['ignorelist']...
$ignorelist = explode(" ", $user['ignorelist']);
$usernames = array();
if (!empty($user['ignorelist']))
{
    $result = $DB_site->query("SELECT userid, username FROM user WHERE userid IN (" . implode(", ", $ignorelist) . ")");
    while ($bits = $DB_site->fetch_array($result)
    {
        $usernames[$bits[userid]] = $bits['username'];
    }
} 


Then $usernames[userid will equal that userid's username.

[SFishy]

Filburt,

Thank you so much for the help...

Please pardon my php stupidity, but where exactly does your code go in the ignore.php script? I did try to figure it out, but couldn't get it to work.

[noppid]

So I played with your idea, doctored the php and made a template.

Anyone can view this page. If the point is to humiliate those being ignored, we've succeeded. LOL

If this is supposed to be for admins, we need to change the template and relocate the php file.

Hope it helps.