Subversion-Projekte lars-tiefland.medien

<?

    class Album

    {

        var $id;

        var $name;

        var $sampler;

        var $genre;

        var $pic;

        var $year;

        var $p_del;

        function __construct( $id = 0 )

        {

            global $db, $prefix;

            if ( $id )

            {

                $sql = "SELECT * FROM $prefix" . "boxes WHERE a_id=$id";

                $res = $db->query( $sql );

                $row = $res->fetchRow();

                $this->id = $id;

                $this->name = stripslashes( $row["a_name"] );

                $this->genre = $row["a_genre"];

                $this->year = $row["a_year"];

                $this->pic = stripslashes( ( $row["a_pic"] ) ? $row["a_pic"] :

                    "nopic.jpg" );

            }

            else

            {

                $this->id = 0;

                $this->name = "";

                $this->genre = -1;

                $this->pic = "";

                $this->year = 0;

            }

            return $this;

        }

        function Album( $id = 0 )

        {

            $this->__construct( $id );

        }

        function update( $a_name, $a_pic, $a_year, $a_genre = 0, $p_del = 0 )

        {

            $this->name = $a_name;

            $this->year = $a_year;

            $this->pic = $a_pic;

            $this->genre = $a_genre;

            $this->p_del = $p_del;

        }

        function save( $mode = "save" )

        {

            global $db, $prefix;

            switch ( $mode )

            {

                case "save":

                    $sql = "INSERT INTO $prefix" .

                        "boxes (a_name, a_pic, a_year, a_genre) VALUES ('$this->name', $this->sampler, '$this->pic', $this->year, $this->genre)";

                    break;

                case "update":

                    $pic_sql = "";

                    if ( $this->pic || $this->p_del )

                    {

                        $pic_sql = "a_pic='$this->pic',";

                    }

                    $sql = "UPDATE $prefix" . "boxes SET a_name='$this->name', " .

                        $pic_sql . " a_year=$this->year, a_genre=$this->genre WHERE a_id=$this->id";

                    break;

                case "del":

                    break;

            }

            return $db->query( $sql );

        }

        function Liste( $start = 0, $anz = 0 )

        {

            global $db, $prefix, $common;

            $sql = "SELECT * FROM $prefix" . "boxes";

            if ( $anz > 0 )

            {

                $res = $db->limitquery( $sql, $start, $anz );

                $id = 0;

                $ret = array( array() );

                while ( $row = $res->fetchRow() )

                {

                    $ret[$id]["link_id"] = $row["a_id"];

                    $ret[$id]["a_name"] = stripslashes( $row["a_name"] );

                    $ret[$id]["a_year"] = ( $row["a_year"] ) ? $row["a_year"] :

                        $common["unknown"];

                    $ret[$id]["a_pic"] = stripslashes( ( $row["a_pic"] ) ? $row["a_pic"] :

                        "nopic.jpg" );

                    $g = new Genre( $row["a_genre"] );

                    $ret[$id]["a_genre"] = $g->name;

                    $id++;

                }

                return $ret;

            }

            else

            {

                $res = $db->query( $sql );

                return $res->numRows();

            }

        }

        function getAlbums()

        {

            global $db, $prefix, $common;

            $sql = "SELECT * FROM $prefix" . "boxes ORDER BY a_name";

            $res = $db->query( $sql );

            $ret["-1"] = $common["please_select"];

            while ( $row = $res->fetchRow() )

            {

                $id = $row["a_id"];

                $ret[$id] = stripslashes( $row["a_name"] );

            }

            return $ret;

        }

    }

?>