Subversion-Projekte lars-tiefland.medien

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
98 lars 1 
<?
2 
	class CD_Track
3 
	{
4 
		var $id;
5 
		var $cd_id;
6 
		var $t_id;
7 
		var $track_no;
8 
 
9 
		function __construct($id)
10 
		{
11 
			global $db, $prefix;
12 
			if ($id)
13 
			{
14 
				$sql="SELECT * FROM $prefix"."cd_tracks WHERE t_id=$id";
15 
				$res=$db->query($sql);
16 
				$row=$res->fetchRow();
17 
				$this->id=$id;
18 
				$this->cd_id=$row["cd_id"];
19 
				$this->track_no=sprintf("%02d", $row["track_no"]);
20 
				$this->t_id=$row["t_id"];
21 
			}
22 
			else
23 
			{
24 
				$this->id=0;
25 
				$this->cd_id=0;
26 
				$this->t_id=0;
27 
				$this->track_no=0;
28 
			}
29 
			return $this;
30 
		}
31 
 
32 
		function CD_Track($id)
33 
		{
34 
			$this->__construct($id);
35 
		}
36 
 
37 
		function update($id, $cd_id, $t_id, $track_no)
38 
		{
39 
				$this->id=$id;
40 
				$this->cd_id=$cd_id;
41 
				$this->t_id=$t_id;
42 
				$this->track_no=$track_no;
43 
		}
44 
 
45 
		function save($mode)
46 
		{
47 
			global $db, $prefix;
48 
			switch($mode)
49 
			{
50 
				case "save":
51 
					$sql="INSERT INTO $prefix"."cd_tracks (cd_id, t_id, track_no) VALUE($this->cd_id, $this->t_id, $this->track_no)";
52 
					break;
53 
				case "update":
54 
					$sql="UPDATE $prefix"."cd_tracks SET cd_id=$this->cd_id, t_id=$this->t_id, track_no=$this->track_no WHERE id=$this->id";
55 
					break;
56 
				case "delete":
57 
					$sql="DELETE FROM $prefix"."cd_tracks WHERE id=$this->id";
58 
					break;
59 
			}
60 
			return $db->query($sql);
61 
		}
62 
 
63 
		function Liste($start=0,$anz=0)
64 
		{
65 
			global $db, $prefix;
66 
			$sql="SELECT * FROM $prefix"."cd_tracks";
67 
			if ($anz > 0)
68 
			{
69 
				$res=$db->limitquery($sql,$start,$anz);
70 
				$id=0;
71 
				$ret=array(array());
72 
				while ($row=$res->fetchRow())
73 
				{
74 
					$ret[$id]["link_id"]=$row["t_id"];
75 
					$t=new Track($t_id);
76 
					$ret[$id]["t_name"]=stripslashes($t->name);
77 
					$ret[$id]["t_dur"]=stripslashes($t->dur);
78 
					$g=new Genre($t->genre);
79 
					$a=new Artist($t->artist);
80 
					$ret[$id]["t_genre"] =$g->name;
81 
					$ret[$id]["t_artist"]="$a->fname $a->name";
82 
					$id++;
83 
				}
84 
				return $ret;
85 
			}
86 
			else
87 
			{
88 
				$res=$db->query($sql);
89 
				return $res->numRows();
90 
			}
91 
		}
92 
	}
93 
?>