Profile Enhancements - Ban Info on User Profile

3.7 version can be found here: https://vborg.vbsupport.ru/showthread.php?t=188670

What does this hack do?
If a user has been banned it will display information about the ban (ban date, reason and the person who has banned the user) on the user's profile.

Demo: http://piforums.info/member.php?u=44

This is my first hack and I hope everything will work correctly

Don't redistribute it without my permission.

Updates:
[30/9/2006] Version 1.0.2: Added improvements posted by flash7 here
[30/9/2006] Version 1.0.1: Fixed the HTML bugs found by flash7 here
You need to reupload the baninfo.php if you want to apply the changes.
[29/9/2006] Version 1.0.0: First public release

[flash7]

Hello zappsan,
I've set a improvement of baninfo.php because $db->query is deprecated on vb 3.6.1

PHP Code:

// Ban Info on User Profile Hack ? 2006 by zappsan (http://piforums.paulhq.com)
 
$baninfo = $db->query_first_slave("SELECT * FROM " . TABLE_PREFIX . "userban WHERE userid=" .$userinfo['userid']);
if ($baninfo['userid'])
{
echo '<table class="tborder" cellspacing="1" cellpadding="3" width="100%">
<tr>
<td class="tcat" colspan="3">Ban Information</td>
</tr>
<tr>
<td class="alt1"><b>Time banned: </b>';
if ($baninfo['liftdate'] == '0')
{
echo 'Forever</td>';
}
else
{
$bandate = vbdate($vbulletin->options['dateformat'], $baninfo['bandate'], false);
$liftdate = vbdate($vbulletin->options['dateformat'], $baninfo['liftdate'], false);
echo 'From '.$bandate.' to '.$liftdate.'</td>';
}
if (empty($baninfo['reason']))
{
echo '<td class="alt1"><b>Reason:</b> None</td>';
}
else
{
echo '<td class="alt1"><b>Reason:</b> '.$baninfo['reason'].'</td>';
}
echo '<td class="alt1"><b>Banned by: </b>';
$bannedby = $db->query_first("SELECT username FROM " . TABLE_PREFIX . "user WHERE userid=" .$baninfo['adminid']);
echo $bannedby['username'].'</td></tr></table><br />';
} 


let me know if all right

[zappsan]

Originally Posted by bada_bing

Will this work for the vb 3.5.x versions

I didn't test it with 3.5.x yet.
I might try it later.

Originally Posted by Keyser S?ze

might want to update the mod info in the release, and i would think putting the ver. number in the zip title would be nice i always like that, so ppl know the zip has been updated

I updated the info and added the version number to the zip file now

Originally Posted by Yorixz

Edit;
flash7, you're my hero That code indeed seems to fix my trouble (and the trouble of others, as this should be happening to everyone with 3.6.1 if I read your post), thanks a lot.

It worked fine for me with 3.6.1, strange.
But good to see you haven't got problems anymore

Originally Posted by flash7

Hello zappsan,
I've set a improvement of baninfo.php because $db->query is deprecated on vb 3.6.1

....let me know if all right

I added it, thanks

[Keyser S?ze]

can this be made into a product?

[SportsZone]

Nice hack, thanks

[Medina]

How to change the English text to your own language? I'v tried the Language manager by searching for "Time Banned:" But with no results.

Can you help me please.

[zappsan]

Originally Posted by Keyser S?ze

can this be made into a product?

Why would you want it to be a product?
Well, I'm probably going to do some changes/updates and I'll look into it.
I can't promise anything though.

Originally Posted by Medina

How to change the English text to your own language? I'v tried the Language manager by searching for "Time Banned:" But with no results.

Can you help me please.

I didn't add any phrases to this hack, so you won't find them.
If you want different words to be displayed, edit the "baninfo.php" and replace the bold words with your own ones.
I'm planing to add phrases though.

if ($baninfo['userid'])
{
echo '<table class="tborder" cellspacing="1" cellpadding="3" width="100%">
<tr>
<td class="tcat" colspan="3">Ban Information</td>
</tr>
<tr>
<td class="alt1"><b>Time banned: </b>';
if ($baninfo['liftdate'] == '0')
{
echo 'Forever</td>';
}
else
{
$bandate = vbdate($vbulletin->options['dateformat'], $baninfo['bandate'], false);
$liftdate = vbdate($vbulletin->options['dateformat'], $baninfo['liftdate'], false);
echo 'From '.$bandate.' to '.$liftdate.'</td>';
}
if (empty($baninfo['reason']))
{
echo '<td class="alt1"><b>Reason:</b> None</td>';
}
else
{
echo '<td class="alt1"><b>Reason:</b> '.$baninfo['reason'].'</td>';
}
echo '<td class="alt1"><b>Banned by: </b>';
$bannedby = $db->query_first("SELECT username FROM " . TABLE_PREFIX . "user WHERE userid=" .$baninfo['adminid']);
echo $bannedby['username'].'</td></tr></table><br />';
}

[bonjurkes]

when i try to visit baninfo.php

domainname.com/forum/baninfo.php i am getting an error like

Fatal error: Call to a member function on a non-object in /home/bonjurke/public_html/forum/baninfo.php on line 4

[zappsan]

Originally Posted by bonjurkes

when i try to visit baninfo.php

domainname.com/forum/baninfo.php i am getting an error like

Well, the ban info will only work when you view the profile of a banned user, trying to visit the file alone wont work.
That's how it's meant to be.

[Wild-Wing]

this is a cool idea.

[Bounce]

how do you take the info off ....for instance if you reinstate someone..

it still shows them as banned :tired: