Subversion-Projekte lars-tiefland.em_wm

<?
        class Ort
        {
                var $o_id;
                var $o_name;
                var $o_name2;
                
                function __construct($o_id)
                {
                        global $db, $db_meld, $error, $meld;
                        $o_id=intval($o_id);
                        $sql="SELECT * FROM locations WHERE l_id=$o_id";
                        $res=$db->query($sql);
                        if (true == DB::isError($res))
                        {
                                $error="true";
                                $meld="Ein Fehler ist aufgetreten!";
                                $db_meld=$res->getUserInfo();
                                return $error;
                        }
                        else
                        {
                                $row=$res->fetchRow();
                                $this->o_id=$o_id;
                                $this->o_name=$row["l_name"];
                                $this->o_name2=$row["l_name2"];
                                return $this;
                        }
                }
                
                function Ort($o_id)
                {
                        $this->__construct($o_id);
                }
                
                function update($l_name, $l_name2)
                {
                        $this->l_name=$l_name;
                        $this->l_name2=$l_name2;
                }
                
                function save($op)
                {
                        global $db;
                        switch($op)
                        {
                                case "save":
                                        $sql="INSERT INTO locations (l_name, l_name2)
                                                VALUES ('$this->o_name', '$this->o_name2)";
                                        break;
                                case "update":
                                        $sql="UPDATE locations SET l_name='$this->o_name', l_name2='$this->o_name2' WHERE l_id=$this->o_id";
                                        break;
                                case "del":
                                        $sql="DELETE FROM locations WHERE l_id=$this->l_id";
                                        break;
                        }
                        return $db->query($sql);
                }
                
                function listeOrt($limit, $start=0)
                {
                        global $db, $db_meld, $error, $meld, $user;
                        $sql="SELECT * FROM locations";
                        if ($db->provides('limit') && $limit > 0)
                        {
                                $res=$db->limitquery($sql, $start, $limit);
                        }
                        else
                        {
                                $res=$db->query($sql);
                        }
                        if (true == DB::isError($res))
                        {
                                $error=true;
                                $meld="Ein Fehler ist aufgetreten!";
                                $db_meld=$res->getUserInfo();
                        }
                        return $res;
                }
        }
?>