Subversion-Projekte lars-tiefland.medien

Revision

Revision 98 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 98 Revision 99
Zeile 103... Zeile 103...
103 
		function getTracks()
 103 
		function getTracks()
104 
		{
 104 
		{
105 
			global $db, $prefix;
 105 
			global $db, $prefix;
106 
			$sql="SELECT * FROM $prefix"."cd_tracks WHERE cd_id=$this->id";
 106 
			$sql="SELECT * FROM $prefix"."cd_tracks WHERE cd_id=$this->id";
107 
			$res=$db->query($sql);
 107 
			$res=$db->query($sql);
108 
			if($res->numRows())
 108 
			if($res->numRows())
109 
			{
 109 
			{
110 
				$id=0;
 110 
				$id=0;
111 
				$ret=array(array());
 111 
				$ret=array(array());
112 
				while($row=$res->fetchRow())
 112 
				while($row=$res->fetchRow())
113 
				{
 113 
				{
114 
					$ret[$id]["t_id"]=sprintf("%02d", $row["t_id"]);
 114 
					$ret[$id]["t_id"]=sprintf("%02d", $row["t_id"]);
115 
					$t=new Track($row["t_id"]);
 115 
					$t=new Track($row["t_id"]);
116 
					$g=new Genre($t->genre);
 116 
					$g=new Genre($t->genre);
117 
					$artist=new Artist($t->artist);
 117 
					$artist=new Artist($t->artist);
118 
					$ret[$id]["track_no"]=sprintf("%02d", $row["track_no"]);
 118 
					$ret[$id]["track_no"]=sprintf("%02d", $row["track_no"]);
119 
					$ret[$id]["t_artist"]="$artist->fname $artist->name";
 119 
					$ret[$id]["t_artist"]="$artist->fname $artist->name";
120 
					$ret[$id]["t_artist_id"]=$artist->id;
 120 
					$ret[$id]["t_artist_id"]=$artist->id;
121 
					$ret[$id]["a_pic"]=$artist->pic;
 121 
					$ret[$id]["a_pic"]=$artist->pic;
122 
					$ret[$id]["t_name"]=stripslashes($t->name);
 122 
					$ret[$id]["t_name"]=stripslashes($t->name);
123 
					$ret[$id]["t_dur"]=$t->dur;
 123 
					$ret[$id]["t_dur"]=$t->dur;
124 
					$ret[$id]["t_genre"]=$g->name;
 124 
					$ret[$id]["t_genre"]=$g->name;
125 
					$id++;
 125 
					$id++;
126 
				}
 126 
				}
127 
				return $ret;
 127 
				return $ret;
128 
			}
 128 
			}
129 
		}
 129 
		}
130 
	}
 130 
	}
131 
?>
 131 
?>