diff options
| author | Max Kostikov <max@kostikov.co> | 2021-02-06 11:36:22 +0100 |
|---|---|---|
| committer | Max Kostikov <max@kostikov.co> | 2021-02-06 11:36:22 +0100 |
| commit | e1d622c49f95aec51e5c1bd521dcd6fe2a9a5372 (patch) | |
| tree | a5ff3755263e7e0a08d8697192e8e290fd7e533b | |
| parent | 8bb77bcfd638b3921df0092ad0e1d39113b14e57 (diff) | |
| download | volse-hubzilla-e1d622c49f95aec51e5c1bd521dcd6fe2a9a5372.tar.gz volse-hubzilla-e1d622c49f95aec51e5c1bd521dcd6fe2a9a5372.tar.bz2 volse-hubzilla-e1d622c49f95aec51e5c1bd521dcd6fe2a9a5372.zip | |
Use datetime interval in public tag cloud query to support queueworker deduplication
| -rw-r--r-- | include/taxonomy.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/include/taxonomy.php b/include/taxonomy.php index 7745b6a5b..5fa4fde3f 100644 --- a/include/taxonomy.php +++ b/include/taxonomy.php @@ -345,7 +345,7 @@ function pub_tagadelic($net,$site,$limit,$recent,$safemode,$type) { } if($recent) - $sql_extra .= " and item.created > '" . datetime_convert('UTC','UTC', 'now - ' . intval($recent) . ' days ') . "' "; + $sql_extra .= " and item.created > NOW() - INTERVAL " . db_quoteinterval(intval($recent) . ' DAY') . " "; if($safemode) { |