Subversion-Projekte lars-tiefland.medien

Revision

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

Revision Autor Zeilennr. Zeile
19 lars 1 
<?
2 
	Class Genre
3 
	{
4 
		var $id;
5 
		var $name;
6 
 
7 
		function __construct($id=0)
8 
		{
55 lars 9 
			global $db, $prefix, $common;
19 lars 10 
			if ($id)
11 
			{
12 
				$sql="SELECT * FROM $prefix"."genres WHERE g_id=$id";
13 
				$res=$db->query($sql);
14 
				$row=$res->fetchRow();
15 
				$this->id=$id;
55 lars 16 
				$this->name=stripslashes(($row["g_id"]!=1)?$row["g_name"]:$common["various"]);
19 lars 17 
			}
18 
			else
19 
			{
20 
				$this->id=0;
21 
				$this->name="";
22 
			}
23 
			return $this;
24 
		}
25 
		function Genre($id=0)
26 
		{
27 
			$this->__construct($id);
28 
		}
29 
 
30 
		function update($a_name)
31 
		{
32 
			$this->name=$a_name;
33 
		}
34 
 
35 
		function save($mode="save")
36 
		{
37 
			global $db, $prefix;
38 
			switch ($mode)
39 
			{
40 
				case "save":
41 
					$sql="INSERT INTO $prefix"."genres (g_name) VALUES ('$this->name')";
42 
					break;
43 
				case "update":
27 lars 44 
					$sql="UPDATE $prefix"."genres SET g_name='$this->name' WHERE g_id=$this->id";
19 lars 45 
					break;
46 
				case "del":
47 
					break;
48 
			}
49 
			return $db->query($sql);
50 
		}
51 
 
52 
		function Liste($start=0,$anz=0)
53 
		{
54 
			global $db, $prefix, $common;
55 
			$sql="SELECT * FROM $prefix"."genres";
56 
			if ($anz > 0)
57 
			{
58 
				$res=$db->limitquery($sql,$start,$anz);
59 
				$id=0;
67 lars 60 
				$ret=array(array());
19 lars 61 
				while ($row=$res->fetchRow())
62 
				{
63 
					$ret[$id]["link_id"]=$row["g_id"];
55 lars 64 
					$ret[$id]["g_name"]=stripslashes(($row["g_id"]!=1)?$row["g_name"]:$common["various"]);
19 lars 65 
					$id++;
66 
				}
67 
				return $ret;
68 
			}
69 
			else
70 
			{
71 
				$res=$db->query($sql);
72 
				return $res->numRows();
73 
			}
74 
		}
75 
 
76 
		function getGenres()
77 
		{
78 
			global $db, $prefix, $common;
63 lars 79 
			$sql="SELECT * FROM $prefix"."genres ORDER by g_name";
19 lars 80 
			$res=$db->query($sql);
81 
			$ret["-1"]=$common["please_select"];
82 
			while ($row=$res->fetchRow())
83 
			{
84 
				$g_id=$row["g_id"];
55 lars 85 
				$ret["$g_id"]=stripslashes(($g_id!=1)?$row["g_name"]:$common["various"]);
19 lars 86 
			}
22 lars 87 
			$ret["1"]=$common["various"];
19 lars 88 
			return $ret;
89 
		}
90 
	}
91 
?>