Subversion-Projekte lars-tiefland.em_wm

Revision

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