Subversion-Projekte lars-tiefland.php_share

<?
        function loadDirTemplates()
        {
                if ($_SESSION['navigation']['position'])
                {
                        $query="
                                SELECT
                                        templates.*
                                FROM
                                        templates,
                                        templates_to_directory,
                                        directory
                                WHERE
                                        templates.shops_ID=".$_SESSION['INI']['shops_ID']."
                                AND
                                        templates_to_directory.templates_ID = templates.ID
                                AND
                                        templates_to_directory.directory_ID = ".$_SESSION['navigation']['position']."
                                AND
                                        directory.ID = ".$_SESSION['navigation']['position']."
                                AND
                                        directory.Language = '".$_SESSION['INI']['language']."'
                        ";
                        
                        $buffer2=array();
                        $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
                        if ($zeile=mysql_fetch_assoc($result))
                        {
                                $buffer=array();
                                foreach(explode(";",$zeile['templateValue']) as $elem)
                                {
                                        $elem=explode("=",$elem);
                                        $buffer[$elem['0']]=$elem['1'];
                                }
                                $zeile['templateValue']=$buffer;
                                $buffer2[$zeile['templateKey']]=$zeile['templateValue'];
                                $_SESSION['INI']['TEMPLATE']['subDir']=$buffer2['subDir'];
                        }
                }
        }
?>