Subversion-Projekte lars-tiefland.medien

Revision

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