Changeset 548

Timestamp:

Oct 3, 2004, 1:12:56 PM (20 years ago)

Author:

z0rglub

Message:

when registering a new user, we must take into account that user_category.date_last can be NULL

File:

• branches/release-1_3/include/functions_user.inc.php (modified) (1 diff)

branches/release-1_3/include/functions_user.inc.php

@@ -159 +159 @@
       $query.= ' (user_id,category_id,date_last,nb_sub_categories) VALUES';
       $query.= ' ('.$user_id.','.$row['category_id'];
-      $query.= ",'".$row['date_last']."',".$row['nb_sub_categories'].')';
+      $query.= ",";
+      if (!isset($row['date_last']) or $row['date_last'] == '')
+      {
+        $query.= 'NULL';
+      }
+      else
+      {
+        $query.= "'".$row['date_last']."'";
+      }
+      $query.= ",".$row['nb_sub_categories'].')';
       $query.= ';';
       mysql_query ( $query );