Subversion-Projekte lars-tiefland.em_wm

Revision

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

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