Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 15 | Zur aktuellen Revision | Details | 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"];
37
					$this->u_type=$row["u_type"];
38
					$this->u_max_anz=$row["u_max_anz"];
39
					return $this;
40
				}
41
			}
42
		}
43
 
44
		function UserListe($limit, $start=0)
45
		{
46
			$sql="SELECT * FROM auth_user";
47
			global $db, $meld, $db_meld, $error;
48
			if ($db->provides('limit') && $limit > 0)
49
			{
50
				$res=$db->limitquery($sql, $start, $limit);
51
			}
52
			else
53
			{
54
				$res=$db->query($sql);
55
			}
56
			if (true == DB::isError($res))
57
			{
58
				$error=true;
59
				$meld="Ein Fehler ist aufgetreten!";
60
				$db_meld=$res->getUserInfo();
61
			}
62
			return $res;
63
		}
64
 
65
		function updateUser($op, $u_id, $u_name, $u_max_anz, $u_type, $u_password)
66
		{
67
			global $db;
68
            $u_password=($u_password!="")?md5('$u_password'):"";
69
			$pw_sql=", u_password='$u_password'";
70
			$op=strtoupper($op);
71
			switch($op)
72
			{
73
				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')";
74
					break;
75
				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";
76
					break;
77
				case "D": $sql="DELETE FROM auth_user WHERE u_id=$u_id";
78
					break;
79
			}
80
			return $db->query($sql);
81
		}
82
	}
83
 
84
	function updateUserPassword($password)
85
	{
86
		$this->u_password=md5($password);
87
	}
88
?>