Subversion-Projekte lars-tiefland.php_share

<?
        function createOrder($userId)
        {
                $Bemerkung = getBemerkung(true);
        
                // Datenbank wählen / Markus
                if (empty($_SESSION['INI']['buy']['useDB'])) {
                        $_SESSION['INI']['buy']['useDB']=$_SESSION['INI']['dbConnect']['database'];
                }
                        
                if ($_SESSION['SHOP']['Lieferadresse'] == "true")
                {
                $query="
                        insert
                                into
                        ".$_SESSION['INI']['buy']['useDB'].".Bestellung
                        (
                                liefer_Anrede,
                                liefer_Firma,
                                liefer_Vorname,
                                liefer_Name,
                                liefer_Strasse,
                                liefer_Str_Nr,
                                liefer_PLZ,
                                liefer_Ort,
                                liefer_Land,
                                Bemerkung,
                                shops_ID,
                                Login,
                                erstellt_am,
                                Language
                        )
                        values
                        (
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_Anrede']."',
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_Firma']."',
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_Vorname']."',
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_Nachname']."',
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_Strasse']."',
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_Str_Nr']."',
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_PLZ']."',
                                '".$_SESSION['SHOP']['buy']['Persdata']['liefer_Ort']."',
                                '".getCountryById($_SESSION['SHOP']['buy']['Persdata']['liefer_Land'])."',
                                '".$Bemerkung."',
                                '".$_SESSION['INI']['shops_ID']."',
                                '".$userId."',
                                NOW(),
                                '".$_SESSION['INI']['language']."'
                        )";
                        }
                        else
                        {
                        $query="
                        insert
                                into
                        ".$_SESSION['INI']['buy']['useDB'].".Bestellung
                        (
                                Bemerkung,
                                shops_ID,
                                Login,
                                erstellt_am,
                                Language
                        )
                        values
                        (
                                '".$Bemerkung."',
                                '".$_SESSION['INI']['shops_ID']."',
                                '".$userId."',
                                NOW(),
                                '".$_SESSION['INI']['language']."'
                        )";
                        }

                $result = mysql_query ($query) or mail
                (
                        $_SESSION['INI']['sysadmin'],
                        "Fehler in createOrder",
                        mysql_errno().": ".mysql_error()."<hr>$query<hr>",
                        "from: ".$_SESSION['INI']['errorFrom']
                );
                
                return mysql_insert_id();
        }
?>