0000808: function COM_emailUserTopics and the stories in submission queue

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0000808

glFusion CMS

General

public

2011-09-02 08:18

2012-05-15 10:14

Reporter

cchiapusio

Assigned To

Priority

normal

Severity

minor

Reproducibility

always

Status

acknowledged

Resolution

open

Platform

Unix

Linux

OS Version

Fedora 9

Product Version

1.2.0

Target Version

Fixed in Version

Summary

0000808: function COM_emailUserTopics and the stories in submission queue

Description

COM_emailUserTopics will email out stories that are not in draft or submission queue and at the end of the daily run, then set lastemailedstories. If a story is then released from the submission queue, on the next run that message pre-dates the 'lastemailedstories' and is not mailed out.

$lastrun = DB_getItem( $_TABLES['vars'], 'value', "name = 'lastemailedstories'" );
.....
$commonsql = " FROM {$_TABLES['stories']} WHERE draft_flag = 0 AND date <= NOW() AND date >= '{$lastrun}'";

Tags

No tags attached.

Attached Files

Relationships

Notes
(0001129) lgarner (developer) 2011-09-29 15:53	Maybe it would make sense to update the publish_date during the approval process, if it's earlier than now.

(0001161) cchiapusio (reporter) 2012-05-15 10:14	That would seem a reasonable way to massage the issue away.

Issue History
Date Modified	Username	Field	Change
2011-09-02 08:18	cchiapusio	New Issue
2011-09-12 08:12	mark	Status	new => acknowledged
2011-09-29 15:53	lgarner	Note Added: 0001129
2012-05-15 10:14	cchiapusio	Note Added: 0001161