Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
    function artikelDatabase( $shopsID = -1 )
3 
    {
4 
        global $webs;
5 
 
6 
        $db = shopDatabase( $shopsID ) . "artikel";
7 
        return $db;
8 
    }
9 
 
10 
    function shopDatabase( $shopsID = -1 )
11 
    {
12 
        if ( isset( $_SESSION["filter"]["shops_ID"] ) && $_SESSION["filter"]["shops_ID"] &&
13 
            $shopsID == -1 )
14 
        {
15 
            $shopsID = $_SESSION["filter"]["shops_ID"];
16 
        }
17 
 
18 
        if ( isset( $_SESSION["shops"] ) && $_SESSION["shops"][$shopsID]['database'] )
19 
        {
20 
            $db = $_SESSION["shops"][$shopsID]["database"] . ".";
21 
        } elseif ( is_numeric( $shopsID ) )
22 
        {
23 
            $sql = "
24 
                SELECT
25 
                    `database`
26 
                FROM
27 
                    " . $webs["datenbank"] . ".shops
28 
                WHERE
29 
                    ID = " . $shopsID . "
30 
            ";
31 
            $result = mysql_query( $sql ) or die( mysql_errno() . ': ' .
32 
                mysql_error() . '<hr />' . $sql );
33 
            $row = mysql_fetch_assoc( $result );
34 
 
35 
            if ( $row['database'] )
36 
            {
37 
                $db = $row['database'] . ".";
38 
            }
39 
            else
40 
            {
41 
                $db = "";
42 
            }
43 
 
44 
        }
45 
        else
46 
        {
47 
            $db = "";
48 
        }
49 
        return $db;
50 
    }
51 
?>