aboutsummaryrefslogtreecommitdiff
path: root/mod/lightpics/upgrades/2012020901.php
blob: 793279b38976562e84ed76147aa83e535f5b5c9e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
<?php
/**
 * Adds last notified metadata and sets the notify interval
 */

elgg_set_plugin_setting('notify_interval', 60 * 60 * 24, 'tidypics');

$options = array(
	'type' => 'object',
	'subtype' => 'album',
	'limit' => 0
);

$prefix = elgg_get_config('dbprefix');
$batch = new ElggBatch('elgg_get_entities', $options);

foreach ($batch as $album) {
	// grab earliest picture and use that as the notification time
	// in old version of tidypics notifications went out only when a new album was populated.
	$q = "SELECT MIN(time_created) as ts FROM {$prefix}entities WHERE container_guid = $album->guid";
	$row = get_data_row($q);

	if ($row) {
		$album->last_notified = $row->ts;
	}
}