diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-09-28 17:15:34 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-09-28 17:15:34 -0700 |
| commit | 3b53cd56ef151586024cb99742a91d4a75afdb5b (patch) | |
| tree | f0d02417d5cac33bb1d7999bbeefd11848b18d7f /include/queue.php | |
| parent | 6368b093375d50f929b0a419834299e6b62e274e (diff) | |
| parent | 30e88a4f6b38e1d51ebcd97ac4b81c29f9ce4823 (diff) | |
| download | volse-hubzilla-3b53cd56ef151586024cb99742a91d4a75afdb5b.tar.gz volse-hubzilla-3b53cd56ef151586024cb99742a91d4a75afdb5b.tar.bz2 volse-hubzilla-3b53cd56ef151586024cb99742a91d4a75afdb5b.zip | |
Merge branch 'deadsite'
Diffstat (limited to 'include/queue.php')
| -rw-r--r-- | include/queue.php | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/include/queue.php b/include/queue.php index 7d2ad3b2d..18c8c5fa2 100644 --- a/include/queue.php +++ b/include/queue.php @@ -22,6 +22,22 @@ function queue_run($argv, $argc){ logger('queue: start'); + + $r = q("select outq_posturl from outq where outq_created < %s - INTERVAL %s", + db_utcnow(), db_quoteinterval('3 DAY') + ); + if($r) { + foreach($r as $rr) { + $site_url = ''; + $h = parse_url($rr['outq_posturl']); + $desturl = $h['scheme'] . '://' . $h['host'] . (($h['port']) ? ':' . $h['port'] : ''); + q("update site set site_dead = 1 where site_dead = 0 and site_url = '%s' and site_update < %s - INTERVAL %s", + dbesc($desturl), + db_utcnow(), db_quoteinterval('1 MONTH') + ); + } + } + $r = q("DELETE FROM outq WHERE outq_created < %s - INTERVAL %s", db_utcnow(), db_quoteinterval('3 DAY') ); |