vb.org Archive - Banned Users List (with reason/date)

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Banned Users List (with reason/date) (https://vborg.vbsupport.ru/showthread.php?t=35979)

ok, if you still want the banned list without having the users show in thw show groups remove usergroup.showgroup = 1 so it looks like this. remember to change 9 to your banned usergroup

PHP Code:


		
			
// get banned users**********************************************************

$users = $DB_site->query("

    SELECT

        $banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,

        user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect

        FROM usergroup

        LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)

        LEFT JOIN userfield ON (userfield.userid = user.userid)

        WHERE usergroup.usergroupid = 9

    ");

Quote:

Originally posted by fonzerelli_79
i get this dtatbase error

Database error in vBulletin 2.2.0:

Invalid SQL:
SELECT
userfield.field10, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,
user.usergroupid, user.lastactivity, user.lastvisit, userfield.field11
FROM usergroup
LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE usergroup.showgroup = 1 AND usergroup.usergroupid = 10

mysql error: Unknown column 'userfield.field10' in 'field list'

Anyone have an answer to this? I get the same thing.

have a question on this i have installed it but the thing is, the page shows up but it doesnt list any person i have added too the banned group on the showbanned page any ideas what i might be?

Quote:

Originally posted by Webdude?

Anyone have an answer to this? I get the same thing.

When you made the new profile fields did you put them in numerical order from the last profile field, so if the original ones were 1 2 3 4 and you added a new one and names it 10 youll get the error so give it the value after the last one so if the original ones were 1 2 3 4 names the new ones 5 6 and change it in the config file, i had the same problem and this fixed it

Quote:

Originally posted by streamzone
have a question on this i have installed it but the thing is, the page shows up but it doesnt list any person i have added too the banned group on the showbanned page any ideas what i might be?

ok try this, find where you added this

PHP Code:


		
			
// get banned users**********************************************************

$users = $DB_site->query("

    SELECT

        $banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,

        user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect

        FROM usergroup

        LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)

        LEFT JOIN userfield ON (userfield.userid = user.userid)

        WHERE usergroup.showgroup = 1 usergroup.usergroupid = [EDIT ME]



    ");

remove usergroup.showgroup = 1 so it looks like this

PHP Code:


		
			
// get banned users**********************************************************

$users = $DB_site->query("

    SELECT

        $banreasonfieldselect, usergroup.title, user.username, user.userid, user.invisible, user.receivepm,

        user.usergroupid, user.lastactivity, user.lastvisit, $banuntilfieldselect

        FROM usergroup

        LEFT JOIN user ON (usergroup.usergroupid = user.usergroupid)

        LEFT JOIN userfield ON (userfield.userid = user.userid)

        WHERE usergroup.usergroupid = [EDIT ME]

    ");

now the banned usergrop can be hidden from the forum leader section and still show up in the banned usergroup, see where it says [EDIT ME] change that to the banned usergroup number

If you wanna show who banned them, in the showbanned.php first install the hack then after you installed it follow the text in the next post, the screen shot is below

Heres the instructions

What for it is necessary to create new group Banned if is Banned by Moderators?

When Administrator or Super Moderator ban users, in showbanned.php don't show By Who.
Help me please!
And: add unban to mod CP - good suggestion. Please make this :)

Quote:

Originally posted by inetd
When Administrator or Super Moderator ban users, in showbanned.php don't show By Who.
Help me please!
And: add unban to mod CP - good suggestion. Please make this :)

ill make unban too, but if you use the admin cp, yoiu muest put in your name and when manualy in the account, if you use the mod cp, it adds your account to why you ban them manually, and i have it so if a mod banns some one it sets there user title to banned by moderator, it doesnt matter what the usergroup has

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 (3)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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.01542 seconds Memory Usage 1,749KB 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 (3)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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: