Subversion-Projekte lars-tiefland.medien

<?
        class Track
        {
                var $id;
                var $t_id;
                var $cd;
                var $artist;
                var $genre;
                var $name;
                var $dur;
                
                function __construct($id)
                {
                        global $db, $prefix;
                        if ($id)
                        {
                                $sql="SELECT * FROM $prefix"."tracks WHERE t_id=$id";
                                $res=$db->query($sql);
                                $row=$res->fetchRow();
                                $this->id=$id;
                                $this->t_id=$row["cd_t_id"];
                                $this->cd=$row["cd_id"];
                                $this->artist=$row["artist_id"];
                                $this->name=stripslashes($row["t_name"]);
                                $this->dur=$row["t_dur"];
                                $this->genre=$row["t_genre"];
                        }
                        else
                        {
                                $this->id=0;
                                $this->t_id=0;
                                $this->cd=0;
                                $this->artist=0;
                                $this->name="";
                                $this->dur="";
                                $this->genre="";
                        }
                        return $this;
                }
                
                function Track($id)
                {
                        $this->__construct($id);
                }
                
                function update($id, $cd_id, $t_cd_id, $a_id, $g_id, $t_name, $t_dur)
                {
                        $this->id=$id;
                        $this->t_id=$t_cd_id;
                        $this->cd=$cd_id;
                        $this->artist=$a_id;
                        $this->genre=$g_id;
                        $this->name=$t_name;
                        $this->dur=$t_dur;
                }
                
                function save($mode)
                {
                        global $db, $prefix;
                        switch($mode)
                        {
                                case "save":
                                        $sql="INSERT INTO $prefix"."tracks (cd_id, cd_t_id, artist_id, t_genre, t_name, t_dur) VALUE($this->cd, $this->t_id, $this->artist, $this->genre, '$this->name', '$this->dur')";
                                        break;
                                case "update":
                                        $sql="UPDATE $prefix"."tracks SET cd_id=$this->cd, cd_t_id=$this->t_id, artist_id=$this->artist, t_genre=$this->genre, t_name='$this->name', t_dur='$this->dur' WHERE t_id=$this->id";
                                        break;
                                case "delete":
                                        $sql="DELETE FROM $prefix"."tracks WHERE t_id=$this->id";
                                        break;
                        }
                        return $db->query($sql);
                }
                
                function getTracks($cd_id)
                {
                        global $db, $prefix;
                        $sql="SELECT * FROM $prefix"."tracks where cd_id=$cd_id";
                        $res=$db->query($sql);
                        $id=0;
                        while($row=$res->fetchRow())
                        {
                                $ret[$id]["t_id"]=sprintf("%02d", $row["cd_t_id"]);
                                $artist=new Artist($row["artist_id"]);
                                $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($row["t_name"]);
                                $ret[$id]["t_dur"]=$row["t_dur"];
                                $id++;
                        }
                        return $ret;
                }
        }
?>