cvs: php-master-web /entry user-note.php
| From: | Andrew Lindeman | Date: | Sun, 18 May 2003 17:25:44 +0000 |
| Subject: | cvs: php-master-web /entry user-note.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-17793@lists.php.net to get a copy of this message | ||
alindeman Sun May 18 13:25:44 2003 EDT
Modified files:
/php-master-web/entry user-note.php
Log:
make this work again. Thanks SSnuS :)
Index: php-master-web/entry/user-note.php
diff -u php-master-web/entry/user-note.php:1.12 php-master-web/entry/user-note.php:1.13
--- php-master-web/entry/user-note.php:1.12 Sun May 18 12:55:07 2003
+++ php-master-web/entry/user-note.php Sun May 18 13:25:44 2003
@@ -26,11 +26,11 @@
flow of notes usually submitted. This prevents
a large flood of notes from coming in.
*/
-$result = @mysql_query ('SELECT COUNT(*) FROM note WHERE ts >= '.time() - 60);
+$result = @mysql_query ("SELECT COUNT(*) FROM note WHERE ts >= (NOW() - INTERVAL 1
MINUTE)");
if (!$result) {
mail ('alindeman@php.net', "failed manual note query", 'Note quota query
failed -- '.mysql_error());
- die("failed to insert record");
+ die("failed to query note db");
}
list ($count) = mysql_fetch_row ($result);