UBB.Developers Forums UBB.threads 6 V6 Modifications Archived Mods [6.2] Advanced Banning 1.0.1

NAME: Advanced Banning
VERSION: 1.0.1
DESCRIPTION: Allows to set different ban levels for users.
WORKING UNDER: UBB.threads 6.2.2
PREREQUISITES: none
AUTHORS: Astaran
CREDITS: DAVE-L, this hack is based on his user privilieges hack
DEMO: none
FILES ALTERED: addpost.php, doratethread.php, dorateuser.php, editpost.php,
mess_handler.php, newpost.php, newreply.php, sendprivate.php,
ubbt.inc.php, admin/menu.php, admin/banuser.php, admin/dobanuser.php
DATABASE ALTERED: yes
NEW FILES: admin/editbanusers.php, admin/doeditbanusers.php
OBSOLETE FILES: admin/unbanuser.php, admin/dounbanuser.php

HISTORY:
2003-02-07 Dave_L - 1.0.0 Original release of User privileges
2003-02-15 Astaran - 1.0.0 Original release of Advanced banning
2003-03-02 Astaran - 1.0.1 Updated "Upgrading Instructions" - added missing field in altertable command

NOTES: This hack advances/replaces the normal ban masks. I tested it on my board and it worked well. Make sure to backup all files so that you can undo everything.

UPGRADING: If already installed Dave_L's user restrictions hack, only follow the upgrading instructions at the end of the file.

I uploaded the file to my server, cause i wasn't able to attach it.

EDIT: Now it works, get it from the first post.

I like the idea behind this so I installed and put the database changes in place.

I get this error when I run the edit/delete bans

SQL ERROR: Unable to do_query: SELECT t1.B_Uid,t1.B_Hostname,t1.B_Reason,t1.B_X_NoEditPost,t1.B_X_NoEditProfile,t1.B_X_NoMessage,t1.B_X_NoPost,t1.B_X_NoRate,t1.B_X_NoLogin,t1.B_Comment,t2.U_Username FROM w3t_Banned as t1 LEFT OUTER JOIN w3t_Users as t2 ON t1.B_Uid = t2.U_Number
Unknown column 't1.B_X_NoLogin' in 'field list' Edit or delete bans

Also when I ban a user/ip Iget this message

SQL ERROR: Unable to do_query: INSERT INTO w3t_Banned (B_Uid,B_Hostname,B_Reason,B_X_NoEditPost,B_X_NoEditProfile,B_X_NoMessage,B_X_NoPost,B_X_NoRate,B_X_NoLogin,B_Comment) VALUES ('1807','NULL','test','0','1','1','0','1','0','test')
Unknown column 'B_X_NoLogin' in 'field list'

The Uid 'testing' has been banned. You will now be returned to the main administration page


Is this what I want using that link?

The B_X_NoLogin column was not included in my original User Privileges hack (since I couldn't figure out how to make that work). The addition of that column is missing from the instructions. To add that column:

ALTER TABLE w3t_Banned
ADD B_X_NoLogin CHAR(1) NOT NULL DEFAULT '1';

Dave thanks that fixed it. Nice mod

Thx, Dave_L.
This field was missing from the altertable command in the upgrading instructions.

I updated the instructions and attached the mod to the first post.

Are you sure that you updated the instructions cause I can't see it.
Also does the login ban works?

Thanks

I got it working on 6.2.3 with the above code addition.

Me too . Fantastic !!!