Subversion-Projekte lars-tiefland.php_share

<?
        function shopLog($verwendung, $eintrag1, $eintrag2, $eintrag3, $eintrag4, $update = false)
        {
                // Datenbank wählen / Markus
                if (empty($_SESSION['INI']['shopLog']['useDB'])) {
                        $_SESSION['INI']['shopLog']['useDB']=$_SESSION['INI']['dbConnect']['database'];
                }
                
                if (isset($_SESSION['shopLog']['logID'][$verwendung]) and $update == true)
                {
                        $buffer=array();
                        foreach(array("eintrag1","eintrag2","eintrag3","eintrag4") as $vName)
                        {
                                if (!empty($$vName))
                                {
                                        $buffer[] = "$vName = '".$$vName."'";
                                }
                        }
                        $query=
                        "
                                        update 
                                                ".$_SESSION['INI']['shopLog']['useDB'].".shop_log 
                                        set 
                                                ".implode(", ", $buffer)." 
                                        where 
                                                ID = '".$_SESSION['shopLog']['logID'][$verwendung]."'
                        ";
                }
                else
                {
                        $query="
                                insert into ".$_SESSION['INI']['shopLog']['useDB'].".shop_log
                                        (shops_ID, eintrag1, eintrag2, eintrag3, eintrag4, erstellt_am, erstellt_von)
                                values
                                        (
                                                '".$_SESSION['INI']['shops_ID']."',
                                                '".$eintrag1."',
                                                '".$eintrag2."',
                                                '".$eintrag3."',
                                                '".$eintrag4."',
                                                NOW(),
                                                '(".$verwendung.")'
                                        )
                        ";
                }
                
                $result = mysql_query ($query) or mail
                (
                        $_SESSION['INI']['shopLog']['errorMailTo'],
                        $_SESSION['INI']['shopLog']['errorMailSubject'],
                        mysql_errno().": ".mysql_error().print_r($query, true),
                        "from: ".$_SESSION['INI']['shopLog']['errorMailFrom']
                );
                $buffer = mysql_insert_id();
                if ($buffer > 0)
                {
                        $_SESSION['shopLog']['logID'][$verwendung] = $buffer;
                }
        }
?>