[wellwell-devel] [SCM] Interchange wellwell catalog branch, master, updated. 7be4fea92be103cd4f7c500a6a8227656d8ec6a1

[Stefan Hornburg]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "Interchange wellwell catalog".

The branch, master has been updated
       via  7be4fea92be103cd4f7c500a6a8227656d8ec6a1 (commit)
       via  fdd1800b3ec8cc617bcbfcb5fcdb078553688c5c (commit)
       via  e712fd0ed94c967084db1d0838c38332c53b0b95 (commit)
       via  2d7f26e9b2f2973464166763dfbffa26afb98b8a (commit)
      from  4ee68f65ac4e251b351376170a70c7614994de9b (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 7be4fea92be103cd4f7c500a6a8227656d8ec6a1
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri Feb 6 09:45:54 2009 +0100

    display human readable time

commit fdd1800b3ec8cc617bcbfcb5fcdb078553688c5c
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri Feb 6 09:45:15 2009 +0100

    store timestamp for new content

commit e712fd0ed94c967084db1d0838c38332c53b0b95
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri Feb 6 09:42:10 2009 +0100

    use numeric value to store timestamp

commit 2d7f26e9b2f2973464166763dfbffa26afb98b8a
Author: Stefan Hornburg (Racke) <racke at linuxia.de>
Date:   Fri Feb 6 09:20:58 2009 +0100

    avoid leakage of code value

-----------------------------------------------------------------------

Summary of changes and diff:
 plugins/content/code/content.sub                |    4 +++-
 plugins/content/code/form_content_edit_save.sub |    6 +++++-
 plugins/content/components/content_list         |    2 +-
 plugins/content/database/mysql/content.sql      |    2 +-
 plugins/content/database/pgsql/content.sql      |    2 +-
 5 files changed, 11 insertions(+), 5 deletions(-)

diff --git a/plugins/content/code/content.sub b/plugins/content/code/content.sub
index 2869e53..9a64c74 100644
--- a/plugins/content/code/content.sub
+++ b/plugins/content/code/content.sub
@@ -18,6 +18,8 @@ sub {
 		$CGI->{mv_nextpage} = 'content/recent';
 	}
 
+	$Values->{code} = $CGI->{code};
+
 	return 1;
 }
-EOS
\ No newline at end of file
+EOS
diff --git a/plugins/content/code/form_content_edit_save.sub b/plugins/content/code/form_content_edit_save.sub
index 9aa6969..6e16f1d 100644
--- a/plugins/content/code/form_content_edit_save.sub
+++ b/plugins/content/code/form_content_edit_save.sub
@@ -8,7 +8,11 @@ sub {
 	}
 	$content{uid} = $Session->{username} || 0;
 	$content{type} = 'page';
-	$content{created} = 0;
+
+	# store timestamp
+	unless ($CGI->{code}) {
+		$content{created} = $Tag->time({format => '%s'});
+	}
 
 	$Tag->perl({tables => 'content'});
 	
diff --git a/plugins/content/components/content_list b/plugins/content/components/content_list
index 343eb8d..4817425 100644
--- a/plugins/content/components/content_list
+++ b/plugins/content/components/content_list
@@ -8,7 +8,7 @@
 <tr>
 <td><a href="[area content/[sql-code]]">[sql-param title]</a></td>
 <td>[user name [sql-param uid]]</td>
-<td>[sql-param created]</td>
+<td>[time time="[sql-param created]"]%A, %e.%B %Y[/time] </td>
 </tr>
 [/list]
 [on-match]
diff --git a/plugins/content/database/mysql/content.sql b/plugins/content/database/mysql/content.sql
index a1d215f..ff4d1fd 100644
--- a/plugins/content/database/mysql/content.sql
+++ b/plugins/content/database/mysql/content.sql
@@ -6,7 +6,7 @@ CREATE TABLE content (
   body longtext NOT NULL,
   uri varchar(255) NOT NULL,
   locale varchar(255) NOT NULL default 'en_US',
-  created datetime NOT NULL,
+  created integer NOT NULL DEFAULT 0,
   PRIMARY KEY (code),
   KEY (type)
 );
diff --git a/plugins/content/database/pgsql/content.sql b/plugins/content/database/pgsql/content.sql
index 0232aba..71d7324 100644
--- a/plugins/content/database/pgsql/content.sql
+++ b/plugins/content/database/pgsql/content.sql
@@ -6,6 +6,6 @@ CREATE TABLE content (
   body text NOT NULL,
   uri varchar(255) NOT NULL,
   locale varchar(255) NOT NULL DEFAULT 'en_US',
-  created timestamp NOT NULL,
+  created integer NOT NULL DEFAULT 0,
   PRIMARY KEY (code)
 );


hooks/post-receive
-- 
Interchange wellwell catalog