diff options
Diffstat (limited to 'upgrades')
| -rw-r--r-- | upgrades/2010102801.php | 2 | ||||
| -rw-r--r-- | upgrades/2012020901.php | 26 |
2 files changed, 27 insertions, 1 deletions
diff --git a/upgrades/2010102801.php b/upgrades/2010102801.php index 9190912fe..5bd5f78b4 100644 --- a/upgrades/2010102801.php +++ b/upgrades/2010102801.php @@ -23,4 +23,4 @@ while ($item = mysql_fetch_object($river_items)) { } } } -} +}
\ No newline at end of file diff --git a/upgrades/2012020901.php b/upgrades/2012020901.php new file mode 100644 index 000000000..793279b38 --- /dev/null +++ b/upgrades/2012020901.php @@ -0,0 +1,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; + } +} |