Subversion-Projekte lars-tiefland.php_share

<?
        function getItem($Id)
        {
                $buffer=false;
                if (ereg("_", $Id )) {
                        $options = explode("_", $Id);
                        $query="
                                SELECT
                                        *
                                FROM
                                        artikel
                                WHERE
                                        Language= '".$_SESSION['INI']['language']."'
                                AND
                                        ID = ".$options[0]."
                                AND
                                (
                                        (status = 0)
                                        OR
                                        (                               
                                                Father = -3
                                                AND
                                                status = ".$_SESSION['INI']['shops_ID']."
                                        )
                                )
                                ";
                } else {
                        $query="
                                SELECT
                                        *
                                FROM
                                        artikel
                                WHERE
                                        Language= '".$_SESSION['INI']['language']."'
                                AND
                                        ID = $Id
                                AND
                                (
                                        (status = 0)
                                        OR
                                        (                               
                                                Father = -3
                                                AND
                                                status = ".$_SESSION['INI']['shops_ID']."
                                        )
                                )
                                ";
                }
                
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>".$query);
                if ($zeile=mysql_fetch_assoc($result))
                {
                        $buffer=itemKorrektur($zeile);
                }
                return $buffer;
        }
?>