summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorcweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2010-01-16 10:20:45 +0000
committercweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f>2010-01-16 10:20:45 +0000
commit991ef5c1bfb73d17f67eb9024871cefbce969dca (patch)
tree7f0706ac565804aa342a62041c9701a45900d01e
parentb009bdb07ca03099fb66305187fa2d557abd7814 (diff)
downloadsemanticscuttle-991ef5c1bfb73d17f67eb9024871cefbce969dca.tar.gz
semanticscuttle-991ef5c1bfb73d17f67eb9024871cefbce969dca.tar.bz2
Part of request #2928950: Add config option to allow sorting by bookmark creation date instead of modification date
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@594 b3834d28-1941-0410-a4f8-b48e95affb8f
-rw-r--r--data/config.default.php10
-rw-r--r--doc/ChangeLog2
-rw-r--r--src/SemanticScuttle/Service/Bookmark.php4
3 files changed, 14 insertions, 2 deletions
diff --git a/data/config.default.php b/data/config.default.php
index 8dd61a5..c3c3b58 100644
--- a/data/config.default.php
+++ b/data/config.default.php
@@ -379,6 +379,16 @@ $defaultRecentDays = 14;
$defaultOrderBy = 'date_desc';
/**
+ * Database field to use when sorting by date.
+ * Options here are 'bModified' to sort after
+ * modification date, and 'bDatetime' to sort
+ * after creation date
+ *
+ * @var string
+ */
+$dateOrderField = 'bModified';
+
+/**
* Number of entries that are shown in
* the RSS feed by default.
*
diff --git a/doc/ChangeLog b/doc/ChangeLog
index 7b58030..4b1c30b 100644
--- a/doc/ChangeLog
+++ b/doc/ChangeLog
@@ -7,6 +7,8 @@ ChangeLog for SemantiScuttle
- Implement part of request #2928950:
- User adjustable entry count: rss.php?count=20
- Fix HTTP content type header for RSS
+ - Add config option to allow sorting by bookmark creation date
+ instead of modification date
0.95.1 - 2009-11-16
-------------------
diff --git a/src/SemanticScuttle/Service/Bookmark.php b/src/SemanticScuttle/Service/Bookmark.php
index d0aba0b..cb53cb1 100644
--- a/src/SemanticScuttle/Service/Bookmark.php
+++ b/src/SemanticScuttle/Service/Bookmark.php
@@ -693,7 +693,7 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService
switch($sortOrder) {
case 'date_asc':
- $query_5 .= ' ORDER BY B.bModified ASC ';
+ $query_5 .= ' ORDER BY B.' . $GLOBALS['dateOrderField'] . ' ASC ';
break;
case 'title_desc':
$query_5 .= ' ORDER BY B.bTitle DESC ';
@@ -714,7 +714,7 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService
$query_5 .= ' ORDER BY B.bAddress ASC ';
break;
default:
- $query_5 .= ' ORDER BY B.bModified DESC ';
+ $query_5 .= ' ORDER BY B.' . $GLOBALS['dateOrderField'] . ' DESC ';
}
// Handle the parts of the query that depend on any tags that are present.