cvs: phpweb /bin user-notes.php
| From: | Jim Winstead | Date: | Tue, 28 Aug 2001 06:13:03 +0000 |
| Subject: | cvs: phpweb /bin user-notes.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-6155@lists.php.net to get a copy of this message | ||
jimw Tue Aug 28 02:13:03 2001 EDT
Modified files:
/phpweb/bin user-notes.php
Log:
always update sections with removed notes before removing them
Index: phpweb/bin/user-notes.php
diff -u phpweb/bin/user-notes.php:1.3 phpweb/bin/user-notes.php:1.4
--- phpweb/bin/user-notes.php:1.3 Tue Aug 28 02:10:28 2001
+++ phpweb/bin/user-notes.php Tue Aug 28 02:13:03 2001
@@ -12,7 +12,7 @@
mysql_select_db("php3") or die("unable to select database");
if ($since) {
- mysql_query("CREATE TEMPORARY TABLE updated TYPE = HEAP SELECT DISTINCT sect FROM note WHERE
ts > FROM_UNIXTIME($since) OR updated > 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 removed")
or die("failed to create temporary table");
# purge entries marked for removal
mysql_query("DELETE FROM note WHERE removed");