Ban List Mod

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in the Customisations Database.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
Locked
Extensions Robot
Extensions Robot
Extensions Robot
Posts: 29216
Joined: Sat Aug 16, 2003 7:36 am

Ban List Mod

Post by Extensions Robot »

Modification name: Ban List Mod
Author: RMcGirr83
Modification description: Allows users to see who is banned on the board. Sortable by username, start date, and end date.

Only displays a link if you have a user(s) banned and the settings set correctly under the "Board settings" in the ACP (ACP->General->Board Configuration->Board Features).

Custom support is given at this forum
Modification version: 1.0.11
Tested on phpBB version: 3.0.12

Download file: ban_list.zip
File size: 48.59 KiB

Modification overview page: View

The phpBB Team is not responsible nor required to provide support for this modification. By installing this MOD, you acknowledge that the phpBB Support Team or phpBB Extension Customisations Team may not be able to provide support.

-->Modification support<--
Last edited by Extensions Robot on Mon Sep 19, 2022 7:33 pm, edited 21 times in total.
(this is a non-active account manager for the phpBB Extension Customisations Team)
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 28616
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Ban List Mod

Post by Paul »

Modification validated/released

Notes:
User avatar
RMcGirr83
Former Team Member
Posts: 22011
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Ban List Mod

Post by RMcGirr83 »

This post has been reserved for the MOD author.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
User avatar
RMcGirr83
Former Team Member
Posts: 22011
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Ban List Mod

Post by RMcGirr83 »

Thank you MOD Validation Team!! :D

Screenies

Index Page down by the statistics block
index_page.jpg
index_page.jpg (6.69 KiB) Viewed 29973 times
The list when link above is clicked on.
ban_list.jpg
ban_list.jpg (23.37 KiB) Viewed 19455 times
There is also a setting in ACP -> Board Features to allow everyone to see the list, only mods and admins or just admins.

Thanks to Prime Halo for some tips on code improvement.

Enjoy!!
Last edited by RMcGirr83 on Mon Nov 23, 2009 7:29 pm, edited 1 time in total.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL »

Can you explain me this step please?

SQL

Code: Select all

INSERT INTO phpbb_config (`config_name`, `config_value`, `is_dynamic`) VALUES ('allow_ban_list', '2', '0');
User avatar
RMcGirr83
Former Team Member
Posts: 22011
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Ban List Mod

Post by RMcGirr83 »

Sure, first change that sql to this (because as it stands now, that will only work on mysql databases)

Code: Select all

INSERT INTO phpbb_config (config_name, config_value, is_dynamic) VALUES ('allow_ban_list', '2', '0');
then read this

Knowledge Base - Executing SQL Queries in phpMyAdmin
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL »

Thank you. I succesfully installed it. One thing though. It displays a "1" even though I don't have any banned users.
User avatar
RMcGirr83
Former Team Member
Posts: 22011
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Ban List Mod

Post by RMcGirr83 »

Please go into your ACP -> User and Groups and clicking on "Ban Usernames".

Does a user show up towards the bottom of the screen?
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL »

No, no user shows up there. Same goes for when I click the "Banned Users" on the bottom of the index but it does display it like this "Banned Users 1". Shouldn't it display a "0"?
User avatar
RMcGirr83
Former Team Member
Posts: 22011
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Ban List Mod

Post by RMcGirr83 »

It shouldn't show at all and what's worse, I can't replicate this. Can you try this please?

Go into your database via phpmyadmin, choose the ban table, click on the search tab. Towards the middle of the screen will be displayed "ban_userid", change the operator to the right of that to > and put in -1 for the value, then hit "Go".

Do you get any results?

The link should only show if you actually have banned users, you state you don't so the link shouldn't show at all.
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL »

I'm not exactly sure where to do the changes because I'm not into this SQL stuff.

Am I right here > http://i107.photobucket.com/albums/m287 ... 282317.gif
User avatar
RMcGirr83
Former Team Member
Posts: 22011
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Ban List Mod

Post by RMcGirr83 »

Let's try this instead, hit the sql tab after clicking on phpbb_banlist and run this query

Code: Select all

SELECT ban_userid from phpbb_banlist WHERE ban_userid > -1;
Do you get any results?
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL »

No, it's still the same as before.
User avatar
RMcGirr83
Former Team Member
Posts: 22011
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr

Re: Ban List Mod

Post by RMcGirr83 »

Well then, to be honest, I have no idea why the link is showing.

According to the sql that is run from the includes/ban_list.php file

Code: Select all

		$sql = 'SELECT COUNT(ban_userid) AS total_banned
					FROM ' . BANLIST_TABLE . '
				WHERE ban_userid <> 0
					AND (ban_end >= ' . time() . ' OR ban_end = 0)';
You should only be picking up bans that have an entry in ban_userid. If you have no ban_userid then nothing should be chosen.

Would you mind sending to me, via PM, a link to your board please as well as cpanel and admin log in so I can see what is going on, or at least see why this is happening?

If you don't want to, I completely understand, but I will not be able to help you further.

Sorry. :(
Former Modifications/Extensions Team Member | My extensions | github | All requests for support via PM will be ignored
Appreciate the extensions/mods/support then buy me a beer Image
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: Ban List Mod

Post by 3Di »

Just a thought, since the user_id = 1 it is the anonymous user, then the SQL should say something like WHERE ban_userid >1 because there are not negatives there (phpbb2 had), or you are assuming to ban also it?

I don't know if it is related to the issue the Poster have, though.. just a thought. :)
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
Locked

Return to “[3.0.x] MOD Database Releases”