Subversion-Projekte lars-tiefland.shop_ns

Revision

Revision 2 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
2 lars 1 
<?php
2 
    /**
3 
     * @author Lars Tiefland
4 
     * @copyright 2012
5 
     */
6 
    namespace Weban;
7 
    class randelement
8 
    {
9 
        public function __construct( $id )
10 
        {
11 
            $sql = "SELECT
12 
                    id,
13 
                    ueberschrift AS titel,
14 
                    text AS inhalt,
15 
                    typ,
16 
                    untertyp,
17 
                    bild_url,
18 
                    bild_link,
19 
                    position
20 
                FROM
21 
                    sonderkasten
22 
                WHERE
23 
                    id = $id
24 
            ";
25 
            $res = $GLOBALS["db"]->query( $sql );
26 
            $row = $res->fetchRow();
27 
            foreach ( $row as $feld => $wert )
28 
            {
29 
                $this->$feld = $wert;
30 
            }
31 
        }
32 
 
33 
        public static function Liste( $position )
34 
        {
35 
            $sql = "SELECT
36 
                    id
37 
                FROM
38 
                    sonderkasten
39 
                WHERE
40 
                    position LIKE '%$position%'
41 
                AND
42 
                    language = '" . $GLOBALS["INI"]["language"] . "'
43 
                AND
44 
                    shops_ID = '" . $GLOBALS["INI"]["shops_ID"] . "'
45 
            ";
46 
            $res = $GLOBALS["db"]->query( $sql );
47 
            while ( $row = $res->fetchRow() )
48 
            {
24 lars 49 
                $kasten = new randelement( $row["id"] );
50 
                $pos_arr = explode( ",", $kasten->position );
51 
                $pos = getPageType( "sonderkasten" );
52 
                if ( in_array( $pos, $pos_arr ) || count( $pos_arr ) == 1 )
53 
                {
54 
                    $ret[] = $kasten;
55 
                }
2 lars 56 
            }
57 
            return $ret;
58 
        }
59 
    }
60 
?>