prune_hub_reinstalls() and add cron weekly as a side effect

1 files changed, 32 insertions, 0 deletions

diff --git a/include/hubloc.php b/include/hubloc.php
new file mode 100644
index 000000000..b6f0c8c57
--- /dev/null
+++ b/include/hubloc.php
@@ -0,0 +1,32 @@
+<?php /** @file */
+
+
+
+function prune_hub_reinstalls() {
+
+	$r = q("select site_url from site where true");
+	if($r) {
+		foreach($r as $rr) {
+			$x = q("select count(*) as t, hubloc_sitekey, max(hubloc_connected) as c from hubloc where hubloc_url = '%s' group by hubloc_sitekey order by c",
+				dbesc($rr['site_url'])
+			);
+
+			// see if this url has more than one sitekey, indicating it has been re-installed.
+
+			if(count($x) > 1) {
+				
+				$d1 = datetime_convert('UTC','UTC',$x[0]['c']);
+				$d2 = datetime_convert('UTC','UTC','now - 3 days');
+
+				// allow some slop period, say 3 days - just in case this is a glitch or transient occurrence
+
+				if($d1 < $d2) {
+					logger('prune_hub_reinstalls: removing dead hublocs at ' . $rr['site_url']);
+					$y = q("delete from hubloc where hubloc_sitekey = '%s'",
+						dbesc($x[0]['hubloc_sitekey'])
+					);
+				}
+			}
+		}
+	}
+}
\ No newline at end of file