Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 49 | Revision 54 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	class Team
3 
	{
4 
		var $t_id;
5 
		var $t_name;
4 lars 6 
		var $t_group;
3 lars 7 
 
8 
		function __construct($t_id)
9 
		{
10 
			global $db, $db_meld, $error, $meld;
11 
			$t_id=intval($t_id);
12 
			$sql="SELECT * FROM teams WHERE t_id=$t_id";
13 
			$res=$db->query($sql);
14 
			if (true == DB::isError($res))
15 
			{
16 
				$error="true";
17 
				$meld="Ein Fehler ist aufgetreten!";
18 
				$db_meld=$res->getUserInfo();
19 
				return $error;
20 
			}
21 
			else
22 
			{
52 lars 23 
				$row=$res->fetchRow();
3 lars 24 
				$this->t_id=$t_id;
25 
				$this->t_name=$row["t_name"];
4 lars 26 
				$this->t_group=$row["t_group"];
3 lars 27 
				return $this;
28 
			}
31 lars 29 
		}
30 
 
5 lars 31 
		function Team($t_id)
32 
		{
33 
			$this->__construct($t_id);
34 
		}
31 lars 35 
 
36 
		function update ($t_name, $t_group)
4 lars 37 
		{
31 lars 38 
			$this->t_name=$t_name;
39 
			$this->t_group=$t_group;
40 
		}
41 
 
42 
		function save($op)
43 
		{
44 
			global $db;
45 
			switch($op)
46 
			{
47 
				case "save":
48 
					$sql="INSERT INTO teams (t_name, t_group)
49 
						VALUES ('$this->t_name', $this->t_group)";
50 
					break;
51 
				case "update":
52 
					$sql="UPDATE teams SET t_name='$this->t_name', t_group=$this->t_group WHERE t_id=$this->t_id";
53 
					break;
49 lars 54 
				case "delete":
31 lars 55 
					$sql="DELETE FROM teams WHERE t_id=$this->t_id";
56 
					break;
57 
			}
58 
			return $db->query($sql);
59 
		}
60 
 
61 
		function listeTeam($limit, $start=0)
62 
		{
4 lars 63 
			global $db, $db_meld, $error, $meld, $user;
64 
			$sql="SELECT * FROM teams";
65 
			if ($db->provides('limit') && $limit > 0)
66 
			{
67 
				$res=$db->limitquery($sql, $start, $limit);
68 
			}
69 
			else
70 
			{
71 
				$res=$db->query($sql);
72 
			}
73 
			if (true == DB::isError($res))
74 
			{
75 
				$error=true;
76 
				$meld="Ein Fehler ist aufgetreten!";
77 
				$db_meld=$res->getUserInfo();
78 
			}
79 
			return $res;
80 
		}
31 lars 81 
	}
3 lars 82 
?>