Changeset 801 for trunk/comments.php

Timestamp:

Jul 16, 2005, 4:29:35 PM (19 years ago)

Author:

plg

Message:

• new feature : RSS notification feed. Feed generator is an external tool (FeedCreator class v1.7.2). New file feed.php

• new database field : comments.validation_date (datetime). This field is required for notification feed.

• new database field : users.feed_id (varchar(50)). users.feed_id is an alias of users.id but is much more complicated to find (50 characters, figures or letters, case sensitive) : the purpose is to keep it secret (as far as possible).

• new database field : users.last_feed_check (datetime)

• new database field : users.registration_date (datetime)

• bug fixed : no need to add the (unavailable) session id to install.php in the installation form.

• modified database field : images.date_available become more precise (date to datetime). This precision is needed for notification feed.

• new index : comments_i1 (validation_date). Might be useful for feed queries.

• new index : comments_i2 (image_id). Useful each time you want to have informations about an element and its associated comments.

• version 9.11 of mysqldump outputs database field names and table names with backquote "`" (didn't find how to take them off)

File:

• trunk/comments.php (modified) (1 diff)

trunk/comments.php

@@ -158 +158 @@
 UPDATE '.COMMENTS_TABLE.'
   SET validated = \'true\'
+    , validation_date = NOW()
   WHERE id IN ('.implode(',', $_POST['comment_id']).')
 ;';