Subversion-Projekte lars-tiefland.medien

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

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