Changeset 11771 for trunk/www/db_po/insert_po.php

Timestamp:

08/04/11 11:20:53 (13 years ago)

Author:

Daniela Dorner

Message:

key2 can be empty now

File:

• trunk/www/db_po/insert_po.php (modified) (4 diffs)

trunk/www/db_po/insert_po.php

@@ -4 +4 @@
     ini_set("mysql.trace_mode", "On");
 
+    // init
+    //
+    // values which cannot be empty
     if (empty($_GET["fUpdCase"]))
     {
@@ -24 +27 @@
         return;
     }
+    if (empty($_GET["fValue"]))
+    {
+        echo "Please insert a value.<br>";
+        return;
+    }
+    if (empty($_GET["fDescription"]))
+    {
+        echo "Please insert a description.<br>";
+        return;
+    }
+    if (empty($_GET["fType"]))
+    {
+        echo "Please select a type.<br>";
+        return;
+    }
+    // values which may be empty
     if (empty($_GET["fKey2"]))
-    {
-        echo "Please select a key2.<br>";
-        return;
-    }
-    if (empty($_GET["fValue"]))
-    {
-        echo "Please insert a value.<br>";
-        return;
-    }
-    if (empty($_GET["fDescription"]))
-    {
-        echo "Please insert a description.<br>";
-        return;
-    }
-    if (empty($_GET["fType"]))
-    {
-        echo "Please select a type.<br>";
-        return;
-    }
+        $_GET["fKey2"]="";
     if (empty($_GET["fOriginalIndex"]))
         $_GET["fOriginalIndex"]="";
@@ -97 +98 @@
 
     //check if key alread exists
-    $query2="SELECT Count(*) from ProgramOption WHERE fKey1='".$_GET["fKey1"]."' AND fKey2='.".$_GET["fKey2"]."'";
+    if (empty($_GET["fKey2"]))
+        $query2="SELECT Count(*) from ProgramOption WHERE fKey1='".$_GET["fKey1"]."' AND ISNULL(fKey2)";
+    else
+        $query2="SELECT Count(*) from ProgramOption WHERE fKey1='".$_GET["fKey1"]."' AND fKey2='.".$_GET["fKey2"]."'";
     $query2.=" AND fCounter=(Select Max(fCounter) from History)";
     if (!$result2=mysqli_query($db_id, $query2))
@@ -158 +162 @@
         $query0.=", fUser='".$_SERVER['PHP_AUTH_USER']."'";
         $query0.=", fKey1='".$_GET["fKey1"]."'";
-        $query0.=", fKey2='.".$_GET["fKey2"]."'";
+        if (!empty($_GET["fKey2"]))
+            $query0.=", fKey2='.".$_GET["fKey2"]."'";
         $query0.=", fDescription='".$_GET["fDescription"]."'";
         $query0.=", fType='".$_GET["fType"]."'";