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: 27739
Joined: Sat Aug 16, 2003 7:36 am

Ban List Mod

Post by Extensions Robot » Sun Sep 28, 2008 6:01 pm

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 Extensions Team may not be able to provide support.

-->Modification support<--
Last edited by Extensions Robot on Mon Mar 27, 2017 3:10 pm, edited 18 times in total.
(this is a non-active account manager for the phpBB Extension Customisations Team)

User avatar
Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 24745
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Ban List Mod

Post by Paul » Sun Sep 28, 2008 6:01 pm

Modification validated/released

Notes:
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Ban List Mod

Post by RMcGirr83 » Sun Sep 28, 2008 6:01 pm

This post has been reserved for the MOD author.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Ban List Mod

Post by RMcGirr83 » Sun Sep 28, 2008 7:09 pm

Thank you MOD Validation Team!! :D

Screenies

Index Page down by the statistics block
index_page.jpg
index_page.jpg (6.69 KiB) Viewed 23344 times
The list when link above is clicked on.
ban_list.jpg
ban_list.jpg (23.37 KiB) Viewed 12826 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.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL » Sun Sep 28, 2008 7:54 pm

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
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Ban List Mod

Post by RMcGirr83 » Sun Sep 28, 2008 8:11 pm

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
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL » Sun Sep 28, 2008 8:23 pm

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
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Ban List Mod

Post by RMcGirr83 » Sun Sep 28, 2008 8:36 pm

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

Does a user show up towards the bottom of the screen?
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL » Sun Sep 28, 2008 8:41 pm

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
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Ban List Mod

Post by RMcGirr83 » Sun Sep 28, 2008 8:54 pm

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.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL » Sun Sep 28, 2008 9:19 pm

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
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Ban List Mod

Post by RMcGirr83 » Sun Sep 28, 2008 9:31 pm

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?
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

JeRicHoOL
Registered User
Posts: 449
Joined: Sun Jun 01, 2008 4:02 pm

Re: Ban List Mod

Post by JeRicHoOL » Sun Sep 28, 2008 9:37 pm

No, it's still the same as before.

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 20955
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Ban List Mod

Post by RMcGirr83 » Sun Sep 28, 2008 11:25 pm

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. :(
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

User avatar
3Di
Registered User
Posts: 12994
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Ban List Mod

Post by 3Di » Sun Sep 28, 2008 11:37 pm

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. :)
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate

:game_die: VIP º The best Dice Roller extension around for phpBB 3.2 is out, test it! :game_die:

Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

Locked

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

Who is online

Users browsing this forum: No registered users and 29 guests