appdb/ include/note.php tables/appdb_tables.sql

[WineHQ]

ChangeSet ID:	30846
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	wineowner(a)winehq.org	2007/01/01 22:44:27

Modified files:
	include        : note.php 
	tables         : appdb_tables.sql 

Log message:
	Alexander Nicolaysen Sørnes <alex(a)thehandofagony.com>
	Fix the note deletion mail so it displays the information it is supposed to.

Patch: http://cvs.winehq.org/patch.py?id=30846

Old revision  New revision  Changes     Path
 1.19          1.20          +11 -5      appdb/include/note.php
 1.26          1.27          +2 -0       appdb/tables/appdb_tables.sql

Index: appdb/include/note.php
diff -u -p appdb/include/note.php:1.19 appdb/include/note.php:1.20
--- appdb/include/note.php:1.19	2 Jan 2007  4:44:27 -0000
+++ appdb/include/note.php	2 Jan 2007  4:44:27 -0000
@@ -22,6 +22,8 @@ class Note {
     var $iVersionId;
     var $sTitle;
     var $sDescription;
+    var $iSubmitterId;
+    var $sSubmitTime;
 
     /**
      * Constructor.
@@ -44,6 +46,8 @@ class Note {
                 $this->iVersionId = $oRow->versionId;
                 $this->sTitle = $oRow->noteTitle;
                 $this->sDescription = $oRow->noteDesc;
+                $this->sSubmitTime = $oRow->submitTime;
+                $this->iSubmitterId = $oRow->submitterId;
             }
         }
     }
@@ -56,9 +60,9 @@ class Note {
      */
     function create()
     {
-        $hResult = query_parameters("INSERT INTO appNotes (versionId, noteTitle, noteDesc) ".
-                                    "VALUES('?', '?', '?')",
-                                    $this->iVersionId, $this->sTitle, $this->sDescription);
+        $hResult = query_parameters("INSERT INTO appNotes (versionId, noteTitle, noteDesc, submitterId) ".
+                                    "VALUES('?', '?', '?', '?')",
+                                    $this->iVersionId, $this->sTitle, $this->sDescription, $_SESSION['current']->iUserId);
 
         if($hResult)
         {
@@ -152,12 +156,14 @@ class Note {
                 addmsg("Note modified.", "green");
             break;
             case "delete":
+                $oSubmitter = new User($this->iSubmitterId);
                 $sSubject = "Note ".$this->sTitle." for ".$sAppName." has been deleted by ".$_SESSION['current']->sRealname;
-                $sMsg .= "This note was made on ".substr($this->sDateCreated,0,10)." by ".$this->oOwner->sRealname."\n";
+                $sMsg .= "This note was made on ".print_date(mysqltimestamp_to_unixtimestamp($this->sSubmitTime))." by ".$oSubmitter->sRealname."\n";
                 $sMsg .= "\n";
                 $sMsg .= "Subject: ".$this->sTitle."\n";
                 $sMsg .= "\n";
-                $sMsg .= $this->sBody."\n";
+                $sMsg .= "Note contents:\n";
+                $sMsg .= $this->sDescription."\n";
                 $sMsg .= "\n";
                 $sMsg .= "Because:\n";
                 if($aClean['sReplyText'])
Index: appdb/tables/appdb_tables.sql
diff -u -p appdb/tables/appdb_tables.sql:1.26 appdb/tables/appdb_tables.sql:1.27
--- appdb/tables/appdb_tables.sql:1.26	2 Jan 2007  4:44:27 -0000
+++ appdb/tables/appdb_tables.sql	2 Jan 2007  4:44:27 -0000
@@ -168,6 +168,8 @@ create table appNotes (
 	noteTitle       varchar(255),
 	noteDesc        text,
 	versionId       int not null,
+	submitterId	int not null,
+	submitTime	timestamp not null,
 	key(noteId)
 );