Subversion-Projekte lars-tiefland.medien

Revision

Zur aktuellen Revision | Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
98 lars 1 
<?
2 
	Class CD
3 
	{
4 
		var $id;
5 
		var $name;
6 
		var $tracks;
7 
		var $album;
8 
 
9 
		function __construct($id=0)
10 
		{
11 
			global $db, $prefix;
12 
			if ($id)
13 
			{
14 
				$sql="SELECT * FROM $prefix"."cds WHERE cd_id=$id";
15 
				$res=$db->query($sql);
16 
				$row=$res->fetchRow();
17 
				$this->id=$id;
18 
				$this->name=stripslashes($row["cd_name"]);
19 
				$this->tracks=$row["cd_tracks"];
20 
				$this->album=$row["album_id"];
21 
			}
22 
			else
23 
			{
24 
				$this->id=0;
25 
				$this->name="";
26 
				$this->tracks=1;
27 
				$this->album=0;
28 
			}
29 
			return $this;
30 
		}
31 
		function CD($id=0)
32 
		{
33 
			$this->__construct($id);
34 
		}
35 
 
36 
		function update($cd_name, $album_id, $cd_tracks)
37 
		{
38 
			$this->name=$cd_name;
39 
			$this->tracks=$cd_tracks;
40 
			$this->album=$album_id;
41 
		}
42 
 
43 
		function save($mode="save")
44 
		{
45 
			global $db, $prefix;
46 
			switch ($mode)
47 
			{
48 
				case "save":
49 
					$sql="INSERT INTO $prefix"."cds (cd_name, album_id, cd_tracks) VALUES ('$this->name', $this->album, $this->tracks)";
50 
					break;
51 
				case "update":
52 
					$sql="UPDATE $prefix"."cds SET cd_name='$this->name', album_id=$this->album, cd_tracks=$this->tracks WHERE cd_id=$this->id";
53 
					break;
54 
				case "del":
55 
					break;
56 
			}
57 
			return $db->query($sql);
58 
		}
59 
 
60 
		function Liste($start=0,$anz=0)
61 
		{
62 
			global $db, $prefix, $common;
63 
			$sql="SELECT * FROM $prefix"."cds";
64 
			if ($anz > 0)
65 
			{
66 
				$res=$db->limitquery($sql,$start,$anz);
67 
				$id=0;
68 
				$ret=array(array());
69 
				while ($row=$res->fetchRow())
70 
				{
71 
					$ret[$id]["link_id"]=$row["cd_id"];
72 
					$ret[$id]["cd_name"]=stripslashes($row["cd_name"]);
73 
					$album_id=$row["album_id"];
74 
					$a=new Album($album_id);
75 
					$ret[$id]["a_name"]=$a->name;
76 
					$ret[$id]["cd_tracks"]=$row["cd_tracks"];
77 
					$id++;
78 
				}
79 
				return $ret;
80 
			}
81 
			else
82 
			{
83 
				$res=$db->query($sql);
84 
				return $res->numRows();
85 
			}
86 
		}
87 
 
88 
 
89 
		function getCDs()
90 
		{
91 
			global $db, $prefix, $common;
92 
			$sql="SELECT * FROM $prefix"."cds ORDER by cd_name";
93 
			$res=$db->query($sql);
94 
			$id=0;
95 
			$ret[-1]=$common["please_select"];
96 
			while($row=$res->fetchRow())
97 
			{
98 
				$ret[$row["cd_id"]]=stripslashes($row["cd_name"]);
99 
				$id++;
100 
			}
101 
			return $ret;
102 
		}
103 
		function getTracks()
104 
		{
105 
			global $db, $prefix;
106 
			$sql="SELECT * FROM $prefix"."cd_tracks WHERE cd_id=$this->id";
107 
			$res=$db->query($sql);
108 
			if($res->numRows())
109 
			{
110 
				$id=0;
111 
				$ret=array(array());
112 
				while($row=$res->fetchRow())
113 
				{
114 
					$ret[$id]["t_id"]=sprintf("%02d", $row["t_id"]);
115 
					$t=new Track($row["t_id"]);
116 
					$g=new Genre($t->genre);
117 
					$artist=new Artist($t->artist);
118 
					$ret[$id]["track_no"]=sprintf("%02d", $row["track_no"]);
119 
					$ret[$id]["t_artist"]="$artist->fname $artist->name";
120 
					$ret[$id]["t_artist_id"]=$artist->id;
121 
					$ret[$id]["a_pic"]=$artist->pic;
122 
					$ret[$id]["t_name"]=stripslashes($t->name);
123 
					$ret[$id]["t_dur"]=$t->dur;
124 
					$ret[$id]["t_genre"]=$g->name;
125 
					$id++;
126 
				}
127 
				return $ret;
128 
			}
129 
		}
130 
	}
131 
?>