FUDforum: Bug Reports » Error : Invalid group id when Mass Emailing

Home » FUDforum Development » Bug Reports » Error : Invalid group id when Mass Emailing

Show: Today's Messages :: Polls :: Message Navigator

Re : Re: Re : Re: Error : Invalid group id when Mass Emailing [message #29716 is a reply to message #29714]

Tue, 10 January 2006 22:00

blemish

Messages: 13
Registered: October 2005
Location: France

Karma:

Junior Member

Great ! Thank you very much ! Smile

But ...

I checked PM & "Send to all forum moderators" and every modo received 1 PM per forum (4 modos, 24 forums = 96 PM !).

What do you think about adding some DISTINCT to this :

	} else if ($gid == $all_mods) {
		$c = uq('SELECT '.$fld.' FROM '.$DBHOST_TBL_PREFIX.'mod m INNER JOIN '.$DBHOST_TBL_PREFIX.'users u ON u.id=m.user_id '.(isset($_POST['ignore_override']) ? '' : ' WHERE (users_opt & 8)=0'));

like :

	} else if ($gid == $all_mods) {
		$c = uq('SELECT DISTINCT '.$fld.' FROM '.$DBHOST_TBL_PREFIX.'mod m INNER JOIN '.$DBHOST_TBL_PREFIX.'users u ON u.id=m.user_id '.(isset($_POST['ignore_override']) ? '' : ' WHERE (users_opt & 8)=0'));

And probably the same trick for group leaders ... ?
Thank you again & again for your valuable help !

Report message to a moderator

[Message index]

		Error : Invalid group id when Mass Emailing By: blemish on Mon, 09 January 2006 20:17
		Re: Error : Invalid group id when Mass Emailing By: Ilia on Tue, 10 January 2006 03:27
		Re : Re: Error : Invalid group id when Mass Emailing By: blemish on Tue, 10 January 2006 15:01
		Re: Re : Re: Error : Invalid group id when Mass Emailing By: Ilia on Tue, 10 January 2006 15:41
		Re : Re: Re : Re: Error : Invalid group id when Mass Emailing By: blemish on Tue, 10 January 2006 22:00
		Re: Re : Re: Re : Re: Error : Invalid group id when Mass Emailing By: Ilia on Wed, 11 January 2006 14:40
		Re : Error : Invalid group id when Mass Emailing By: blemish on Sun, 15 January 2006 19:24

Previous Topic:	Topics show above Announcements and Stickies + Consistency Check
Next Topic:	Division by Zero in Compact Message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 09:30:52 GMT 2024

Total time taken to generate the page: 0.03905 seconds