Subversion-Projekte lars-tiefland.medien

Revision

Revision 98 | Revision 100 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

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