FUDforum: How To » How to include ALL of text in email notifications to those subscribed to a topic?

Home » FUDforum » How To » How to include ALL of text in email notifications to those subscribed to a topic?

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

Re: How to include ALL of text in email notifications to those subscribed to a topic? [message #33328 is a reply to message #31787]

Sat, 26 August 2006 22:47

ky@smi

Messages: 27
Registered: June 2006

Karma:

Junior Member

Hi Again,
Please disregard the question about how to view queries. I got mysql query browser to work.

I've been going through the sql queries from the /* send new thread notifications to forum subscribers */

$c = uq('SELECT u.email, u.icq, u.users_opt
FROM phpgw_fud_forum_notify fn
INNER JOIN phpgw_fud_users u ON fn.user_id=u.id
LEFT JOIN phpgw_fud_forum_read r ON r.forum_id=fn.forum_id AND r.user_id=fn.user_id
INNER JOIN phpgw_fud_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id='.$mtf->forum_id.'
LEFT JOIN phpgw_fud_group_cache g2 ON g2.user_id=fn.user_id AND g2.resource_id='.$mtf->forum_id.'
WHERE
fn.forum_id='.$mtf->forum_id.' AND fn.user_id!='.(int)$mtf->poster_id.'
AND (CASE WHEN (r.last_view IS NULL AND (u.last_read=0 OR u.last_read >= '.$mtf->frm_last_post_date.')) OR r.last_view > '.$mtf->frm_last_post_date.' THEN 1 ELSE 0 END)=1
AND ((CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) & 2) > 0');

and found that excluding
AND (CASE WHEN (r.last_view IS NULL AND (u.last_read=0 OR u.last_read >= '.$mtf->frm_last_post_date.')) OR r.last_view > '.$mtf->frm_last_post_date.' THEN 1 ELSE 0 END)=1 AND ((CASE WHEN g2.id IS NOT NULL THEN g2.group_cache_opt ELSE g1.group_cache_opt END) & 2) > 0

gives me the correct list. The list goes wrong when

AND (CASE WHEN... ELSE 0 END)=1 is included.

The full version of Fudforum doesn't run this if smart notifications is disabled.

I don't understand the above. When someone posts a new topic, the r.last_view is never null because it immediately comes up in the next window that the poster sees.

Also, I don't understand
r.last_view > '.$mtf->frm_last_post_date.'
Can I interpret this as
if the last view of the thread is after the last post date in the forum, then TRUE?

Am I making an error in interpretation here?

RE:the 2nd half of the filter, what is the g2.group_cache supposed to do?

Report message to a moderator

[Message index]

		How to include ALL of text in email notifications to those subscribed to a topic? By: prodos on Thu, 18 May 2006 03:44
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Fri, 19 May 2006 03:00
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: prodos on Fri, 19 May 2006 06:11
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Fri, 19 May 2006 14:00
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: prodos on Sat, 20 May 2006 00:08
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Sat, 20 May 2006 19:44
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: prodos on Sat, 20 May 2006 23:00
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: prodos on Sun, 21 May 2006 00:30
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Sun, 21 May 2006 03:23
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: prodos on Sun, 21 May 2006 05:57
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Fri, 11 August 2006 19:33
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Fri, 11 August 2006 20:37
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Fri, 11 August 2006 21:13
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Sat, 12 August 2006 16:17
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Sat, 12 August 2006 19:18
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Sat, 12 August 2006 19:20
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Mon, 14 August 2006 08:07
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Mon, 14 August 2006 14:54
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Wed, 16 August 2006 16:24
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Thu, 17 August 2006 13:32
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Thu, 17 August 2006 16:48
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Thu, 17 August 2006 22:49
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Sun, 20 August 2006 19:43
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Mon, 21 August 2006 11:47
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Mon, 21 August 2006 13:43
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Mon, 21 August 2006 15:41
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Tue, 22 August 2006 13:33
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Wed, 23 August 2006 13:00
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Wed, 23 August 2006 13:13
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Wed, 23 August 2006 17:09
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Thu, 24 August 2006 15:22
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Fri, 25 August 2006 12:47
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Fri, 25 August 2006 14:51
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Sat, 26 August 2006 07:27
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Sat, 26 August 2006 22:47
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Sun, 27 August 2006 01:00
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Sun, 27 August 2006 16:15
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Tue, 29 August 2006 14:49
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Tue, 29 August 2006 15:10
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Tue, 29 August 2006 17:50
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: Ilia on Wed, 30 August 2006 13:25
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Wed, 30 August 2006 14:40
		Re: How to include ALL of text in email notifications to those subscribed to a topic? By: ky@smi on Thu, 31 August 2006 10:32

Previous Topic:	Signature doesn't show up when i post through mail
Next Topic:	Posting and reading by email

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 21:26:21 GMT 2024

Total time taken to generate the page: 0.06265 seconds