Subversion-Projekte lars-tiefland.medien

<?
        Class CD
        {
                var $id;
                var $name;
                var $tracks;
                var $album;

                function __construct($id=0)
                {
                        global $db, $prefix;
                        if ($id)
                        {
                                $sql="SELECT * FROM $prefix"."cds WHERE cd_id=$id";
                                $res=$db->query($sql);
                                $row=$res->fetchRow();
                                $this->id=$id;
                                $this->name=stripslashes($row["cd_name"]);
                                $this->tracks=$row["cd_tracks"];
                                $this->album=$row["album_id"];
                        }
                        else
                        {
                                $this->id=0;
                                $this->name="";
                                $this->tracks=1;
                                $this->album=0;
                        }
                        return $this;
                }
                function CD($id=0)
                {
                        $this->__construct($id);
                }

                function update($cd_name, $album_id, $cd_tracks)
                {
                        $this->name=$cd_name;
                        $this->tracks=$cd_tracks;
                        $this->album=$album_id;
                }

                function save($mode="save")
                {
                        global $db, $prefix;
                        switch ($mode)
                        {
                                case "save":
                                        $sql="INSERT INTO $prefix"."cds (cd_name, album_id, cd_tracks) VALUES ('$this->name', $this->album, $this->tracks)";
                                        break;
                                case "update":
                                        $sql="UPDATE $prefix"."cds SET cd_name='$this->name', album_id=$this->album, cd_tracks=$this->tracks WHERE cd_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"."cds";
                        if ($anz > 0)
                        {
                                $res=$db->limitquery($sql,$start,$anz);
                                $id=0;
                                $ret=array(array());
                                while ($row=$res->fetchRow())
                                {
                                        $ret[$id]["link_id"]=$row["cd_id"];
                                        $ret[$id]["cd_name"]=stripslashes($row["cd_name"]);
                                        $album_id=$row["album_id"];
                                        $a=new Album($album_id);
                                        $ret[$id]["a_name"]=$a->name;
                                        $ret[$id]["cd_tracks"]=$row["cd_tracks"];
                                        $id++;
                                }
                                return $ret;
                        }
                        else
                        {
                                $res=$db->query($sql);
                                return $res->numRows();
                        }
                }


                function getCDs()
                {
                        global $db, $prefix, $common;
                        $sql="SELECT * FROM $prefix"."cds ORDER by cd_name";
                        $res=$db->query($sql);
                        $id=0;
                        $ret[-1]=$common["please_select"];
                        while($row=$res->fetchRow())
                        {
                                $ret[$row["cd_id"]]=stripslashes($row["cd_name"]);
                                $id++;
                        }
                        return $ret;
                }
                function getTracks()
                {
                        global $db, $prefix;
                        $sql="SELECT * FROM $prefix"."cd_tracks WHERE cd_id=$this->id";
                        $res=$db->query($sql);
                        if($res->numRows())
                        {
                                $id=0;
                                $ret=array(array());
                                while($row=$res->fetchRow())
                                {
                                        $ret[$id]["t_id"]=sprintf("%02d", $row["t_id"]);
                                        $t=new Track($row["t_id"]);
                                        $g=new Genre($t->genre);
                                        $artist=new Artist($t->artist);
                                        $ret[$id]["track_no"]=sprintf("%02d", $row["track_no"]);
                                        $ret[$id]["t_artist"]="$artist->fname $artist->name";
                                        $ret[$id]["t_artist_id"]=$artist->id;
                                        $ret[$id]["a_pic"]=$artist->pic;
                                        $ret[$id]["t_name"]=stripslashes($t->name);
                                        $ret[$id]["t_dur"]=$t->dur;
                                        $ret[$id]["t_genre"]=$g->name;
                                        $id++;
                                }
                                return $ret;
                        }
                }
        }
?>