Changeset 801 for trunk/install.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/install.php (modified) (2 diffs)

trunk/install.php

@@ -306 +306 @@
     $query.= ",'admin','".$language."'";
     $query.= ",'".$admin_mail."');";
+    mysql_query($query);
+
+    $query = '
+UPDATE '.USERS_TABLE.'
+  SET feed_id = \''.find_available_feed_id().'\'
+  WHERE id = 1
+;';
     mysql_query($query);
     
@@ -349 +356 @@
     'L_END_MESSAGE'=>$lang['install_end_message'],
     
-    'F_ACTION'=>add_session_id( 'install.php' ),
+    'F_ACTION'=>'install.php',
     'F_DB_HOST'=>$dbhost,
     'F_DB_USER'=>$dbuser,