vb.org Archive - Banned members automatically stop receiving email notification on subscribed threads

Page 2 of 2

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 members automatically stop receiving email notification on subscribed threads (https://vborg.vbsupport.ru/showthread.php?t=43442)

8ball

09-24-2002 10:48 AM

thanks for this Erwin ;) !!

i keep it and will try it as soon as possible :D

Erwin

09-25-2002 05:31 AM

There's no need to install this hack anymore. vB has included this hack as standard in 2.2.8 which is now out. :) Thanks to PPN who listened to me when I posted about this on vB.com.

Talisman

10-16-2002 01:37 PM

Thanks for the fix, Erwin. We're still using 2.2.6.

Erwin

10-16-2002 08:32 PM

You're welcome. :) Glad people still find this useful.

lalo landa

01-09-2003 05:15 AM

work in 2.2.4 too

Kathy

02-01-2003 03:15 AM

Sorry for bringing this back up...but I'd like clarification. My current functions.php has this section but I don't think it is stopping the "banned" and "email awaiting confiramtion" from getting email notifications.. Of course I have a very hacked up file so perhaps I've missed getting the right upgraded bit in my 2.2.8:

Code:

$useremails=$DB_site->query("SELECT user.*

                               FROM subscribethread,user,usergroup

                               WHERE subscribethread.threadid='$threadid'

                                 AND subscribethread.userid=user.userid

                                 AND usergroup.usergroupid=user.usergroupid

                                 AND user.userid<>'$userid'

                                 AND user.usergroupid<>'3'

                                 AND usergroup.canview = 1

                                 AND user.lastactivity>'$lastposttime[dateline]'");

Is there someplace I can make it so that banned, email awaiting, and another usergroup (bad email) can be unsubscribed?

Banned =usergroupid=23
users awaiting confirmation=usergroupid=3
Bad email =usergroupid=52

thanks!

Erwin

02-01-2003 04:11 AM

Just add this line as part of that query:

AND user.usergroupid NOT IN (23,3,52)

:)

Kathy

02-01-2003 04:17 AM

thanks Erwin.

What is this line? I don't want to mess up the query by listing a usergroupid twice:
AND user.usergroupid<>'3'

Erwin

02-01-2003 04:32 AM

You can take that line out. :)

oldengine

05-01-2005 02:14 AM

Can we get this for use in 3.0.7 ?

All times are GMT. The time now is 02:00 AM.

Page 2 of 2

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01205 seconds Memory Usage 1,727KB 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_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)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: