fhiiqm/inc/func_lib.inc.php
changeset 22 aae5b0ecc47b
parent 21 97dba0fe820c
child 23 a382de56a8e4
--- a/fhiiqm/inc/func_lib.inc.php	Fri Dec 23 15:03:37 2011 +0100
+++ b/fhiiqm/inc/func_lib.inc.php	Thu Jan 12 11:41:22 2012 +0100
@@ -206,13 +206,14 @@
         }    
     }
     
-    function duplicate_record ($table, $key_name, $key_value) 
+    function duplicate_record ($table, $key_name, $key_value, $auto=1) 
     {
        /** dupliziert Datensatz in table
         *   Parameter
         *   $table      Tabellenname
         *   $key_name   Name ID-Spalte
         *   $key_value  Wert ID des DSes, der dupliziert werden soll
+        *   $auto       ID ist Auto-Wert
         */
          
     	include_once($_SERVER['DOCUMENT_ROOT'] ."/fhiiqm/inc/dbconnect.inc.php");
@@ -228,23 +229,28 @@
         
         foreach ($result as $row) 
         {
-            if ($row->Field == $key_name) {
+            if ($row->Field == $key_name && $auto) {
             $query .= 'NULL, ';
-            } else {
+            }
+            elseif ($row->Field == $key_name && !$auto) 
+                {$query .= '"'. $key_value . '_COPY", ';}
+            else {
             $query .= $row->Field . ', ';
             } // END IF
         } 
         
         $query = substr($query, 0, strlen($query) - 2);
         $query .= ' FROM ' . $table . ' WHERE ' . $key_name . ' = "' . $key_value . '")';
-
+//        echo "$query<br />";
         $ret = $dbc -> execute($query);
-        if ($ret)
+        if ($ret && $auto)
         { 
             // Return new id
             $new_id = $dbc -> insertId();
             return $new_id;
         }
+        elseif ($ret && !$auto)
+            return $key_value . "_COPY";
         else
             return false;
 /*