Subversion-Projekte lars-tiefland.em_wm

Revision

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

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