Subversion-Projekte lars-tiefland.medien

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

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