Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 92 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

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