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

Page 2 of 9

Show 40 post(s) from this thread on one page

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)

dawl	03-12-2002 10:58 PM

I get an empty page even though I have 2 members in the "Banned" group...any ideas ?

69-FLy-gUy

03-13-2002 05:09 AM

same here...

Bald Bouncer

03-13-2002 07:56 AM

Quote:

Originally posted by dawl
I get an empty page even though I have 2 members in the "Banned" group...any ideas ?

open up showbanned.php and find

PHP Code:


		
			
        $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 AND usergroup.usergroupid = 15

change 15 to your banned usergroup ;)

Robert9

03-13-2002 12:53 PM

Quote:

basically.. add two fields to user profile for the reason of banning, and the length of the ban.

create a new user group called "Banned" (exact name/case required) and set permissions as you wish
(most likely you would set them all to 'No')

edit your config.php and add

-----------V
wherever i want??

//set fieldid's of banreason field and banuser field
$banreasonfieldid=10;
$banuntilfieldid=11;

-----------^

to the bottom of it, replacing '10' and '11' with the fieldid's of the reason and until field respectively.

Red= i don't understand, can somebody post an example code, because i don't know, how to make 2 new fields!
Green= Question by me
thx in adnace

DoDgE

69-FLy-gUy

03-13-2002 09:45 PM

in your admin CP... go to add under User Profile Fields..

then once the two profiles are created... look at the ID's of each one.. then edit it as requested for the config.php file.....

69-FLy-gUy

03-13-2002 09:54 PM

i tried editing the showbanned. but it still isn't working. very weird.

dawl	03-13-2002 10:21 PM

same here

69-FLy-gUy

03-13-2002 10:42 PM

dawl.. if you get it workin, let me know=)

dawl	03-14-2002 11:23 AM

sure will - i'm chalking it up to being sick, i'm obviously missing something simple...the fever has the brain garbled LOL I'll keep tinkering and let you know.

fonzerelli_79

03-14-2002 11:44 AM

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'

All times are GMT. The time now is 06:18 AM.

Page 2 of 9

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01092 seconds Memory Usage 1,739KB 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 (1)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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: