From 1f0e77025d9b758f6d5066f451e2e98e42b50751 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sun, 17 Aug 2008 09:31:11 +0000
Subject: [PATCH] MDL-16072 memory related improvements

---
 mod/forum/db/upgrade.php | 2 +-
 mod/forum/lib.php        | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/forum/db/upgrade.php b/mod/forum/db/upgrade.php
index 86140586b0..c4d26491b4 100644
--- a/mod/forum/db/upgrade.php
+++ b/mod/forum/db/upgrade.php
@@ -115,7 +115,7 @@ function xmldb_forum_upgrade($oldversion) {
 
         $count = $DB->count_records_sql("SELECT COUNT('x') $sqlfrom");
 
-        if ($rs = $DB->get_recordset_sql("SELECT p.*, d.forum, f.course, cm.id AS cmid $sqlfrom")) {
+        if ($rs = $DB->get_recordset_sql("SELECT p.id, p.attachment, d.forum, f.course, cm.id AS cmid $sqlfrom")) {
 
             $pbar = new progress_bar('migrateforumfiles', 500, true);
 
diff --git a/mod/forum/lib.php b/mod/forum/lib.php
index 6ec8fa7378..52d6710791 100644
--- a/mod/forum/lib.php
+++ b/mod/forum/lib.php
@@ -3787,7 +3787,7 @@ function forum_move_attachments($discussion, $forumfrom, $forumto) {
     $oldcontext = get_context_instance(CONTEXT_MODULE, $oldcm->id);
 
     // loop through all posts, better not use attachment flag ;-)
-    if ($posts = $DB->get_records('forum_posts', array('discussion'=>$discussion->id))) {
+    if ($posts = $DB->get_records('forum_posts', array('discussion'=>$discussion->id), '', 'id, attachment')) {
         foreach ($posts as $post) {
             if ($oldfiles = $fs->get_area_files($oldcontext->id, 'forum_attachment', $post->id, "id", false)) {
                 foreach ($oldfiles as $oldfile) {
-- 
2.39.5