cvs: phpweb /bin user-notes.php
| From: | Jim Winstead | Date: | Tue, 28 Aug 2001 04:44:01 +0000 |
| Subject: | cvs: phpweb /bin user-notes.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-6152@lists.php.net to get a copy of this message | ||
jimw Tue Aug 28 00:44:01 2001 EDT
Modified files:
/phpweb/bin user-notes.php
Log:
sort entries correctly, plan ahead for handling votes on the notes
Index: phpweb/bin/user-notes.php
diff -u phpweb/bin/user-notes.php:1.1 phpweb/bin/user-notes.php:1.2
--- phpweb/bin/user-notes.php:1.1 Tue Aug 28 00:32:32 2001
+++ phpweb/bin/user-notes.php Tue Aug 28 00:44:01 2001
@@ -17,10 +17,10 @@
if ($since) {
$query .= ",updated WHERE note.sect=updated.sect";
}
-$query .= " ORDER BY sect";
+$query .= " ORDER BY sect,rate DESC,ts";
if ($since) {
- mysql_query("CREATE TEMPORARY TABLE updated TYPE = HEAP SELECT DISTINCT sect FROM note WHERE
ts > FROM_UNIXTIME($since)")
+ mysql_query("CREATE TEMPORARY TABLE updated TYPE = HEAP SELECT DISTINCT sect FROM note WHERE
ts > FROM_UNIXTIME($since) OR updated > FROM_UNIXTIME($since)")
or die("failed to create temporary table");
}