Subversion-Projekte lars-tiefland.medien

Revision

Revision 82 | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
68 lars 1 
<?
39 lars 2 
	class Track
3 
	{
4 
		var $id;
5 
		var $artist;
43 lars 6 
		var $genre;
39 lars 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"];
52 lars 20 
				$this->name=stripslashes($row["t_name"]);
39 lars 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 
 
53 lars 40 
		function update($id, $a_id, $g_id, $t_name, $t_dur)
43 lars 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":
53 lars 55 
					$sql="INSERT INTO $prefix"."tracks (artist_id, t_genre, t_name, t_dur) VALUE($this->artist, $this->genre, '$this->name', '$this->dur')";
51 lars 56 
					break;
43 lars 57 
				case "update":
53 lars 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";
43 lars 59 
					break;
60 
				case "delete":
50 lars 61 
					$sql="DELETE FROM $prefix"."tracks WHERE t_id=$this->id";
43 lars 62 
					break;
63 
			}
64 
			return $db->query($sql);
65 
		}
57 lars 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;
67 lars 75 
				$ret=array(array());
57 lars 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;
63 lars 99 
			$sql="SELECT * FROM $prefix"."tracks order by t_name";
57 lars 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 
		}
39 lars 109 
	}
110 
?>