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
?>