From 016cd6af4f5f8985fc36df35617ceb18071b7872 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Fri, 6 Feb 2004 13:15:15 +0000
Subject: [PATCH] Discussions now store the last user to change them, as well
 as the last time they were modified.   This isn't actually used yet but it
 will be.

---
 mod/forum/db/mysql.php     | 4 ++++
 mod/forum/db/mysql.sql     | 1 +
 mod/forum/db/postgres7.php | 4 ++++
 mod/forum/db/postgres7.sql | 3 ++-
 mod/forum/lib.php          | 6 +++++-
 mod/forum/version.php      | 2 +-
 6 files changed, 17 insertions(+), 3 deletions(-)

diff --git a/mod/forum/db/mysql.php b/mod/forum/db/mysql.php
index 9bdc25751a..c910bfb98d 100644
--- a/mod/forum/db/mysql.php
+++ b/mod/forum/db/mysql.php
@@ -104,6 +104,10 @@ function forum_upgrade($oldversion) {
   if ($oldversion < 2004013000) {
       table_column("forum_posts", "mailed", "mailed", "tinyint", "2");
   }
+
+  if ($oldversion < 2004020600) {
+      table_column("forum_discussions", "", "usermodified", "integer", "10", "unsigned", "0", "", "timemodified");
+  }
   
   return true;
 
diff --git a/mod/forum/db/mysql.sql b/mod/forum/db/mysql.sql
index 26e373fde5..c5c189ab11 100644
--- a/mod/forum/db/mysql.sql
+++ b/mod/forum/db/mysql.sql
@@ -36,6 +36,7 @@ CREATE TABLE prefix_forum_discussions (
   groupid int(10) unsigned NOT NULL default '0',
   assessed tinyint(1) NOT NULL default '1',
   timemodified int(10) unsigned NOT NULL default '0',
+  usermodified int(10) unsigned NOT NULL default '0',
   PRIMARY KEY  (id)
 ) COMMENT='Forums are composed of discussions';
 # --------------------------------------------------------
diff --git a/mod/forum/db/postgres7.php b/mod/forum/db/postgres7.php
index e01ac76a5b..5d9b69b5e6 100644
--- a/mod/forum/db/postgres7.php
+++ b/mod/forum/db/postgres7.php
@@ -43,6 +43,10 @@ function forum_upgrade($oldversion) {
       table_column("forum_discussions", "", "groupid", "integer", "10", "unsigned", "0", "", "userid");
   }
 
+  if ($oldversion < 2004020600) {
+      table_column("forum_discussions", "", "usermodified", "integer", "10", "unsigned", "0", "", "timemodified");
+  }
+
   return true;
 
 }
diff --git a/mod/forum/db/postgres7.sql b/mod/forum/db/postgres7.sql
index 12abc5cded..5cc0276fee 100644
--- a/mod/forum/db/postgres7.sql
+++ b/mod/forum/db/postgres7.sql
@@ -33,7 +33,8 @@ CREATE TABLE prefix_forum_discussions (
   userid integer NOT NULL default '0',
   groupid integer NOT NULL default '0',
   assessed integer NOT NULL default '1',
-  timemodified integer NOT NULL default '0'
+  timemodified integer NOT NULL default '0',
+  usermodified integer NOT NULL default '0'
 );
 # --------------------------------------------------------
 
diff --git a/mod/forum/lib.php b/mod/forum/lib.php
index 7dd30a5dba..8da15140fa 100644
--- a/mod/forum/lib.php
+++ b/mod/forum/lib.php
@@ -898,7 +898,8 @@ function forum_get_discussions($forum="0", $forumsort="d.timemodified DESC",
         $postdata = "p.*";
     }
 
-    return get_records_sql("SELECT $postdata, d.timemodified, u.firstname, u.lastname, u.email, u.picture
+    return get_records_sql("SELECT $postdata, d.timemodified, d.usermodified, 
+                                   u.firstname, u.lastname, u.email, u.picture
                               FROM {$CFG->prefix}forum_discussions d, 
                                    {$CFG->prefix}forum_posts p,
                                    {$CFG->prefix}user u 
@@ -1774,6 +1775,7 @@ function forum_add_new_post($post) {
 
     // Update discussion modified date
     set_field("forum_discussions", "timemodified", $post->modified, "id", $post->discussion);
+    set_field("forum_discussions", "usermodified", $post->userid, "id", $post->discussion);
     
     return $post->id;
 }
@@ -1794,6 +1796,7 @@ function forum_update_post($post) {
 
     // Update discussion modified date
     set_field("forum_discussions", "timemodified", $post->modified, "id", $post->discussion);
+    set_field("forum_discussions", "usermodified", $post->userid, "id", $post->discussion);
 
     return update_record("forum_posts", $post);
 }
@@ -1835,6 +1838,7 @@ function forum_add_discussion($discussion) {
 
     $discussion->firstpost    = $post->id;
     $discussion->timemodified = $timenow;
+    $discussion->usermodified = $post->userid;
 
     if (! $discussion->id = insert_record("forum_discussions", $discussion) ) {
         delete_records("forum_posts", "id", $post->id);
diff --git a/mod/forum/version.php b/mod/forum/version.php
index 660a96ab37..9b7b46edc1 100644
--- a/mod/forum/version.php
+++ b/mod/forum/version.php
@@ -5,7 +5,7 @@
 //  This fragment is called by /admin/index.php
 ////////////////////////////////////////////////////////////////////////////////
 
-$module->version  = 2004013101;
+$module->version  = 2004020600;
 $module->requires = 2004013101;  // Requires this Moodle version
 $module->cron     = 60;
 
-- 
2.39.5