Subversion-Projekte lars-tiefland.content-management

<?
    function artikelDatabase( $shopsID = -1 )
    {
        global $webs;

        $db = shopDatabase( $shopsID ) . "artikel";
        return $db;
    }

    function shopDatabase( $shopsID = -1 )
    {
        if ( isset( $_SESSION["filter"]["shops_ID"] ) && $_SESSION["filter"]["shops_ID"] &&
            $shopsID == -1 )
        {
            $shopsID = $_SESSION["filter"]["shops_ID"];
        }

        if ( isset( $_SESSION["shops"] ) && $_SESSION["shops"][$shopsID]['database'] )
        {
            $db = $_SESSION["shops"][$shopsID]["database"] . ".";
        } elseif ( is_numeric( $shopsID ) )
        {
            $sql = "
                SELECT
                    `database`
                FROM
                    " . $webs["datenbank"] . ".shops
                WHERE
                    ID = " . $shopsID . " 
            ";
            $result = mysql_query( $sql ) or die( mysql_errno() . ': ' .
                mysql_error() . '<hr />' . $sql );
            $row = mysql_fetch_assoc( $result );

            if ( $row['database'] )
            {
                $db = $row['database'] . ".";
            }
            else
            {
                $db = "";
            }

        }
        else
        {
            $db = "";
        }
        return $db;
    }
?>