Changeset 322

Timestamp:

Jan 27, 2004, 12:29:52 AM (20 years ago)

Author:

z0rglub

Message:

moving the synchronization between data and calculated after the real update
of the category status (still if changed)

File:

• branches/release-1_3/admin/cat_modify.php (modified) (2 diffs)

branches/release-1_3/admin/cat_modify.php

@@ -41 +41 @@
   $query.= ';';
   $row = mysql_fetch_array( mysql_query( $query ) );
+  
+  $query = 'UPDATE '.PREFIX_TABLE.'categories';
+
+  $query.= ' SET name = ';
+  if ( $_POST['name'] == '' )
+    $query.= 'NULL';
+  else
+    $query.= "'".htmlentities( $_POST['name'], ENT_QUOTES)."'";
+
+  $query.= ', comment = ';
+  if ( $_POST['comment'] == '' )
+    $query.= 'NULL';
+  else
+    $query.= "'".htmlentities( $_POST['comment'], ENT_QUOTES )."'";
+
+  $query.= ", status = '".$_POST['status']."'";
+  $query.= ", visible = '".$_POST['visible']."'";
+
+  if ( isset( $_POST['uploadable'] ) )
+    $query.= ", uploadable = '".$_POST['uploadable']."'";
+
+  if ( isset( $_POST['associate'] ) )
+  {
+    $query.= ', id_uppercat = ';
+    if ( $_POST['associate'] == -1 ) $query.= 'NULL';
+    else                             $query.= $_POST['associate'];
+  }
+  $query.= ' WHERE id = '.$_GET['cat'];
+  $query.= ';';
+  mysql_query( $query );
 
   if ( $_POST['status'] != $row['status'] )
@@ -57 +87 @@
     synchronize_all_users();
   }
-  
-  $query = 'UPDATE '.PREFIX_TABLE.'categories';
-
-  $query.= ' SET name = ';
-  if ( $_POST['name'] == '' )
-    $query.= 'NULL';
-  else
-    $query.= "'".htmlentities( $_POST['name'], ENT_QUOTES)."'";
-
-  $query.= ', comment = ';
-  if ( $_POST['comment'] == '' )
-    $query.= 'NULL';
-  else
-    $query.= "'".htmlentities( $_POST['comment'], ENT_QUOTES )."'";
-
-  $query.= ", status = '".$_POST['status']."'";
-  $query.= ", visible = '".$_POST['visible']."'";
-
-  if ( isset( $_POST['uploadable'] ) )
-    $query.= ", uploadable = '".$_POST['uploadable']."'";
-
-  if ( isset( $_POST['associate'] ) )
-  {
-    $query.= ', id_uppercat = ';
-    if ( $_POST['associate'] == -1 ) $query.= 'NULL';
-    else                             $query.= $_POST['associate'];
-  }
-  $query.= ' WHERE id = '.$_GET['cat'];
-  $query.= ';';
-  mysql_query( $query );
 
   // checking users favorites