vb.org Archive - Public Ban List

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Requests/Questions (Unpaid) (https://vborg.vbsupport.ru/forumdisplay.php?f=112)

- - Public Ban List (https://vborg.vbsupport.ru/showthread.php?t=95580)

I am requesting a Public Ban list to be created.

Basically it would list all user banned, their ban reason, ban length, and the person who banned them.

Or if this exists already, then please let me know :)

Thanks!

With a few minor changes to make the code 3.5 friendly I was able to get this to function on my forum:

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

Don't know if it was the best way to do it but it worked for me.

Quote:

Originally Posted by .Tim

Could you please post the changed code version in this thread (not as a new release thread) or contact the original author to ask for permission to release it as your own (the 3.5 version) or ask him to release it?

Okay, don't know if it was done in the best way, I just played with the code until it worked. Anyways, here it is:

Step One:

Upload the files contained within the zip to your forums directory. (use the files in my zip, not the ones from the original thread)

Step Two:

Run file admincp/install_showbans.php.

Step Three:

Open modcp/banning.php and make the following file edits:

Find:

Code:

'period' => TYPE_STR,

After it add:

Code:

'bannedpost' => TYP_STR,

Then Find:

Code:

// insert a record into the userban table

                /*insert query*/

                $db->query_write("

                        INSERT INTO " . TABLE_PREFIX . "userban

                        (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)

                        VALUES

                        ($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . $db->escape_string($user['usertitle']) . "', " . $vbulletin->userinfo['userid'] . ", " . TIMENOW . ", $liftdate, '" . $db->escape_string($vbulletin->GPC['reason']) . "')

                ");

        }

Replace it with:

Code:

// insert a record into the userban table

                /*insert query*/

                $db->query_write("

                        INSERT INTO " . TABLE_PREFIX . "banlist

                        (userid, username, dateline, bannedpost, sentbywhom, howlong, reason)

                        VALUES

                        ($user[userid], '" . $db->escape_string($user[username]) . "', " . TIMENOW . ", '" . $db->escape_string($vbulletin->GPC['bannedpost']) . "', '" . $db->escape_string($vbulletin->userinfo[username]) . "', $liftdate, '" . $db->escape_string($vbulletin->GPC['reason']) . "')

                ");



        }

Then find:

Code:

print_input_row($vbphrase['user_ban_reason'], 'reason', '', true, 50, 250);

Replace it with:

Code:

print_input_row($vbphrase['user_ban_reason'], 'reason', '', true, 50, 250, 8, 45, 1, 0);

Step 4:

Add the following new templates

banlist_main

Code:

$stylevar[htmldoctype]

<html id="form" dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">

<head>

<title>Banned Users</title>

$headinclude

</head>

<body>

$header

$navbar

<table align="center" border="0" class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" width="100%">

                <tr>

        

                        <td class="tcat" colspan="6"><div align="center"><STRONG>$vbphrase[banlist_banlist]</STRONG></div></td>

</tr>

<td class="alt1" colspan="6"><div align="center">$vbphrase[banlist_description] </div></td>

</tr><tr>

<td class="thead">&nbsp;</td>

<td nowrap class="thead">$vbphrase[username] / $vbphrase[banlist_bannedby]</td>

<td nowrap class="thead" align="center">$vbphrase[banlist_datebanned]</td>

<td nowrap class="thead" align="center">$vbphrase[banlist_bannedpost]</td>

<td nowrap class="thead">Reason</td>

<td nowrap class="thead" align="center">$vbphrase[banlist_releasedate]</td>

</tr>

$bannedbit

</table>



$footer

</body>

</html>

banlist_banbit

Code:

<tr>

<td nowrap class="alt2"><div align="center"><img src="images/icons/icon4.gif"></</div></td>

<td nowrap class="alt1"><a href="member.php?u=$banned[userid]" target="_blank"><strong>$banned[username]</strong></a><br>

<div class="smallfont">$vbphrase[banlist_bannedby]: $banned[sentbywhom]</div></td>

<td nowrap class="alt2" align="center">$banned[date]</td>

<if condition="$banned['bannedpost']">

<td nowrap class="alt1"><div align="center"><a href="$banned[bannedpost]" target="_blank">$vbphrase[banlist_link]</a></div></td>

<else />

<td nowrap class="alt1"><div align="center">$vbphrase[banlist_nolink]</div></td>

</if>

<td class="alt2">$banned[reason]</td>

<td nowrap class="alt1" align="center">$banned[releasedate] at $banned[releasetime] </td>

</tr>

Thanks, I installed. It only logs new bans and not current existing ones, right?

Yeah, I don't know how to get old ones to show up. I just unbanned and re-banned my banned users. :ermm:

The temp banned users in the admin cp show up as perm banned users now. Does this happen to you? And is it a problem? Or are the temp banned users still only temp banned?

In the showbans.php list they show up properly. On the admin/mod side it says permanent but that's not the case I don't think. I have a fake user temp banned for a day. So I guess tomorrow I can let you know if it functions properly. :D

Hmm, it doesn't appear to work on temp bans. A user I temp banned until 2pm today is still banned. I'll try and figure out a fix for that.

I believe I have fixed the bug. I will need to wait 1 day to find for sure though

Quote:

Originally Posted by .Tim

Step Three:

Open modcp/banning.php and make the following file edits:

Code:

// insert a record into the userban table

                /*insert query*/

                $db->query_write("

                        INSERT INTO " . TABLE_PREFIX . "userban

                        (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)

                        VALUES

                        ($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . $db->escape_string($user['usertitle']) . "', " . $vbulletin->userinfo['userid'] . ", " . TIMENOW . ", $liftdate, '" . $db->escape_string($vbulletin->GPC['reason']) . "')

                ");

        }

Replace it with:

Code:

// insert a record into the userban table

                /*insert query*/

                $db->query_write("

                        INSERT INTO " . TABLE_PREFIX . "banlist

                        (userid, username, dateline, bannedpost, sentbywhom, howlong, reason)

                        VALUES

                        ($user[userid], '" . $db->escape_string($user[username]) . "', " . TIMENOW . ", '" . $db->escape_string($vbulletin->GPC['bannedpost']) . "', '" . $db->escape_string($vbulletin->userinfo[username]) . "', $liftdate, '" . $db->escape_string($vbulletin->GPC['reason']) . "')

                ");



        }

I fixed it by readding

Code:

// insert a record into the userban table

                /*insert query*/

                $db->query_write("

                        INSERT INTO " . TABLE_PREFIX . "userban

                        (userid, usergroupid, displaygroupid, customtitle, usertitle, adminid, bandate, liftdate, reason)

                        VALUES

                        ($user[userid], $user[usergroupid], $user[displaygroupid], $user[customtitle], '" . $db->escape_string($user['usertitle']) . "', " . $vbulletin->userinfo['userid'] . ", " . TIMENOW . ", $liftdate, '" . $db->escape_string($vbulletin->GPC['reason']) . "')

                ");

above

Code:

// insert a record into the userban table

                /*insert query*/

                $db->query_write("

                        INSERT INTO " . TABLE_PREFIX . "banlist

                        (userid, username, dateline, bannedpost, sentbywhom, howlong, reason)

                        VALUES

                        ($user[userid], '" . $db->escape_string($user[username]) . "', " . TIMENOW . ", '" . $db->escape_string($vbulletin->GPC['bannedpost']) . "', '" . $db->escape_string($vbulletin->userinfo[username]) . "', $liftdate, '" . $db->escape_string($vbulletin->GPC['reason']) . "')

                ");



        }

Not sure if this is the best way to do it though.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (12)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02898 seconds Memory Usage 1,757KB 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 (12)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: