[Mapbender-commits] r9185 - trunk/mapbender/http/php

[svn_mapbender at osgeo.org]

Author: syed
Date: 2015-04-27 02:53:49 -0700 (Mon, 27 Apr 2015)
New Revision: 9185

Modified:
   trunk/mapbender/http/php/mb_delete_local_data.php
Log:
fix delete_local_data php-script

Modified: trunk/mapbender/http/php/mb_delete_local_data.php
===================================================================
--- trunk/mapbender/http/php/mb_delete_local_data.php	2015-04-17 11:37:47 UTC (rev 9184)
+++ trunk/mapbender/http/php/mb_delete_local_data.php	2015-04-27 09:53:49 UTC (rev 9185)
@@ -19,53 +19,41 @@
 require_once(dirname(__FILE__)."/../php/mb_validateSession.php");
 require_once(dirname(__FILE__) . "/../classes/class_wmc.php");
 
+// user id in session
 $user_id = Mapbender::session()->get("mb_user_id");
-
+// create wmc object
 $wmc = new wmc();
-
+// get post parameter
+$serial_id;
 $wmc_id = $_POST["id"];
-
-$form_target = $self;
-
-$sql = 'Select wmc from mb_user_wmc where wmc_id = $1 and wmc_has_local_data = 1 and fkey_user_id = $2;';
-
+// sql statement to get the wmc object and the serial_id
+$sql = 'Select wmc,wmc_serial_id from mb_user_wmc where wmc_id = $1 and wmc_has_local_data = 1 and fkey_user_id = $2;';
 $v = array($wmc_id, $user_id);
-$t = array("i", "i");
+$t = array("c", "i");
 $res = db_prep_query($sql, $v, $t);
-
-// if($row = db_fetch_array($res)){
-//     $wmc->createFromXml($row['wmc']);
-//     $wmc->generalExtensionArray['KMLS'] = null;
-//     $wmc->wmc_id = $wmc_id;
-//     $wmc->has_local_data = 0;
-//     $wmc->local_data_public = 0;
-//     $wmc->local_data_size = '0';
-//     $res = $wmc->insert(true);
-//     echo(json_encode($res));
-// } else {
-//     echo('{"success":false}');
-// }
-
-
-
-if($row = db_fetch_array($res)){
-    //FIXME: Diesnt work!!
+// fetch result
+if ($row = db_fetch_array($res)) {
     $wmc->createFromXml($row['wmc']);
     $wmc->generalExtensionArray['KMLS'] = null;
+    $wmc->generalExtensionArray['KMLORDER'] = null;
     $wmc->wmc_id = $wmc_id;
     $wmc->has_local_data = 0;
     $wmc->local_data_public = 0;
     $wmc->local_data_size = '0';
     $newWmcXml = $wmc->toXml();
-    // var_dump($wmc->wmc_id);die;
+    // set the serial_id
+    $serial_id =  $row['wmc_serial_id'];
 
     if (is_int(intval($wmc->wmc_id))) {
-        $wmc->update_existing($newWmcXml, $wmc->wmc_id);
+        $wmc->update_existing($newWmcXml, $serial_id);
+        // send sql to update the local-data flag
+        $sql =  'UPDATE mb_user_wmc mb  SET wmc_has_local_data = 0 WHERE wmc_id = $1';
+        $v = array($wmc_id);
+        $t = array("s");
+
+        $res = db_prep_query($sql, $v, $t);
         echo('{"success":true}');
     }
+} else {
+    echo('{"success":false}');
 }
-else {
-echo('{"success":false}');
-}
-
-?>