From 894ea6758f3f99c49807df99ef4bbd95f74273dc Mon Sep 17 00:00:00 2001
From: Brett Profitt <brett.profitt@gmail.com>
Date: Mon, 13 Feb 2012 15:39:45 -0800
Subject: Fixes #11. Added notifications back.

---
 upgrades/2012020901.php | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 upgrades/2012020901.php

(limited to 'upgrades/2012020901.php')

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;
+	}
+}
-- 
cgit v1.2.3