vb.org Archive - Users Awaiting Moderation

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Users Awaiting Moderation (https://vborg.vbsupport.ru/showthread.php?t=196723)

macara

11-19-2008 07:46 PM

Users Awaiting Moderation

Hello,

Is there any way to avoid that names of Users Awaiting Moderation appears on "What's Going On?", "Statistics" or "Welcome to our newest member" before I accept their registration?

Thankyou in advance

macara

11-21-2008 10:31 PM

Please I am very needy solve this problem.

steve3402000

11-22-2008 07:09 AM

I dont think there is, when they reg, it automatically shows who they are, sometimes they try to put websites, and spam BS as user names, I have to delete scumbags:eek: 3 times a day

MARCO1

11-22-2008 07:25 AM

please check your inbox

Kahuna900

11-26-2008 02:30 PM

I can't believe vbulletin will not official fix this problem. It seems pretty simple to me, why would you show any new members until they are officially a registered user?

hantousha

03-08-2009 08:42 PM

Edit your Index.php file,

Replace:

Code:

$newusername = $vbulletin->userstats['newusername'];

$newuserid = $vbulletin->userstats['newuserid'];

Replace with:

Code:

$newuser = $db->query_first("SELECT userid, username

                                  FROM " . TABLE_PREFIX . "user

                                  WHERE usergroupid NOT IN (3,4,8)

                                  ORDER BY userid DESC

                                  LIMIT 1");

     $newuserid = $newuser['userid'];        // set template variables

     $newusername = $newuser['username'];

In the line "WHERE usergroupid NOT IN (3,4,8)" add the groups you don't want to show...

Hope this helps...

macara

06-15-2009 04:42 PM

Quote:

Originally Posted by hantousha (Post 1763462)

Edit your Index.php file,

Replace:

Code:

$newusername = $vbulletin->userstats['newusername'];

$newuserid = $vbulletin->userstats['newuserid'];

Replace with:

Code:

$newuser = $db->query_first("SELECT userid, username

                                  FROM " . TABLE_PREFIX . "user

                                  WHERE usergroupid NOT IN (3,4,8)

                                  ORDER BY userid DESC

                                  LIMIT 1");

     $newuserid = $newuser['userid'];        // set template variables

     $newusername = $newuser['username'];

In the line "WHERE usergroupid NOT IN (3,4,8)" add the groups you don't want to show...

Hope this helps...

Thanks a lot.

I tried your solution and it seems that it works but the "WHERE usergroupid NOT IN (3)" still appears ((COPPA) Users Awaiting Moderation).

Best Regards

edward hamilton

04-10-2010 07:37 PM

I can't believe I finally found this simple fix to a problem that many forum admins have been struggling with for years. I wish the search in vBulletin was better. I found this through a google search. Thanks hantousha!

random_name

08-16-2013 12:26 PM

Thank you for the help. This is very useful. Despite enabling human factors in registration, a lot of spammers still get through. Our board is setup forcing 1) email authentication 2) users awaiting moderation to prevent spam; however, they still pollute "Welcome to our newest member" and other areas.

It would be great if this support was native to the forum.

All times are GMT. The time now is 01:01 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01286 seconds Memory Usage 1,733KB 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 (4)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (9)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: