diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-05-08 12:49:16 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2003-05-08 12:49:16 +0000 |
| commit | 13da69d62545f1ff10a597cbf0777d5f7300b7ed (patch) | |
| tree | f739f00893193ac10f515cb1b0282f042b17d86a /phpBB/includes/functions_admin.php | |
| parent | 6a29503a135b8464571bfe858e22e78841744c5c (diff) | |
| download | forums-13da69d62545f1ff10a597cbf0777d5f7300b7ed.tar forums-13da69d62545f1ff10a597cbf0777d5f7300b7ed.tar.gz forums-13da69d62545f1ff10a597cbf0777d5f7300b7ed.tar.bz2 forums-13da69d62545f1ff10a597cbf0777d5f7300b7ed.tar.xz forums-13da69d62545f1ff10a597cbf0777d5f7300b7ed.zip | |
Prune related
git-svn-id: file:///svn/phpbb/trunk@3992 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/functions_admin.php')
| -rw-r--r-- | phpBB/includes/functions_admin.php | 33 |
1 files changed, 23 insertions, 10 deletions
diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php index 4760e88905..727154f0cb 100644 --- a/phpBB/includes/functions_admin.php +++ b/phpBB/includes/functions_admin.php @@ -344,7 +344,7 @@ function delete_posts($where_type, $where_ids, $auto_sync = TRUE) $db->sql_transaction('commit'); - delete_attachment($post_ids); +// delete_attachment($post_ids); if ($auto_sync) { @@ -1063,6 +1063,8 @@ function prune($forum_id, $prune_date, $prune_flags = 0, $auto_sync = true) { global $db; + $sql_forum = (is_array($forum_id)) ? ' IN (' . implode(',', $forum_id) . ')' : " = $forum_id"; + $sql_and = ''; if (!($prune_flags & 4)) { @@ -1075,7 +1077,7 @@ function prune($forum_id, $prune_date, $prune_flags = 0, $auto_sync = true) $sql = 'SELECT topic_id FROM ' . TOPICS_TABLE . " - WHERE forum_id = $forum_id + WHERE forum_id $sql_forum AND topic_last_post_time < $prune_date AND poll_start = 0 $sql_and"; @@ -1092,7 +1094,7 @@ function prune($forum_id, $prune_date, $prune_flags = 0, $auto_sync = true) { $sql = 'SELECT topic_id FROM ' . TOPICS_TABLE . " - WHERE forum_id = $forum_id + WHERE forum_id $sql_forum AND poll_start > 0 AND poll_last_vote < $prune_date AND topic_last_post_time < $prune_date @@ -1116,15 +1118,26 @@ function auto_prune($forum_id, $prune_flags, $prune_days, $prune_freq) { global $db; - $prune_date = time() - ($prune_days * 86400); - $next_prune = time() + ($prune_freq * 86400); + $sql = 'SELECT forum_name + FROM ' . FORUMS_TABLE . " + WHERE forum_id = $forum_id"; + $result = $db->sql_query($sql); - prune($forum_id, $prune_date, $prune_flags, true); + if ($row = $db->sql_fetchrow($result)) + { + $prune_date = time() - ($prune_days * 86400); + $next_prune = time() + ($prune_freq * 86400); - $sql = 'UPDATE ' . FORUMS_TABLE . " - SET prune_next = $next_prune - WHERE forum_id = $forum_id"; - $db->sql_query($sql); + prune($forum_id, $prune_date, $prune_flags, true); + + $sql = 'UPDATE ' . FORUMS_TABLE . " + SET prune_next = $next_prune + WHERE forum_id = $forum_id"; + $db->sql_query($sql); + + add_log('admin', 'LOG_AUTO_PRUNE', $row['forum_name']); + } + $db->sql_freeresult($result); return; } |