Subversion-Projekte lars-tiefland.ci

Revision

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

Revision Autor Zeilennr. Zeile
951 lars 1 
<?php
2 
 
3 
/**
4 
 *
5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
8 
 * @version $Rev: 1077 $
9 
 */
10 
 
11 
class User_model extends CI_Model
12 
{
13 
	public function __construct()
14 
	{
15 
		parent::__construct();
16 
	}
17 
 
18 
	public function user_list()
19 
	{
20 
		$sql = "SELECT
21 
				*
22 
			FROM
23 
				Access
964 lars 24 
			WHERE
25 
				user !='admin'
1044 lars 26 
			AND
27 
				user LIKE '%@".__SHOP__."'
951 lars 28 
		";
29 
		$res = $GLOBALS['db_red']->query($sql);
30 
		$users = $res->result_array();
31 
		return $users;
32 
	}
962 lars 33 
 
34 
	public function get_info($user_id)
35 
	{
36 
		$sql = "SELECT
37 
				*
38 
			FROM
39 
				Access
40 
			WHERE
41 
				id=".$user_id."
42 
		";
43 
		$res = $GLOBALS["db_red"]->query($sql);
999 lars 44 
		$user = $res->row_array();
1002 lars 45 
		list($user_local, $domain) = explode("@", $user["user"]);
46 
		$user["domain"] = $domain;
47 
		$user["local"] = $user_local;
1006 lars 48 
		$user["datenquellen"] = unserialize($user["datenquellen"]);
962 lars 49 
		return $user;
50 
	}
1075 lars 51 
 
52 
	public function save($user)
53 
	{
1077 lars 54 
		if ($_SERVER['SERVER_NAME'] == "ci.starfleethq.de")
1075 lars 55 
		{
56 
			$GLOBALS['db_red_write'] = $GLOBALS['db_red'];
57 
		}
58 
		else
59 
		{
60 
			$GLOBALS['db_red_write'] = $this->load->database('db_red_write', TRUE);
61 
		}
62 
		$passwd = crypt($user['passwd']);
63 
		if ($user["ID"])
64 
		{
65 
			$sql = "
66 
				UPDATE
67 
					Access
68 
				SET
69 
					name='".$user['name']."',
70 
					user='".$user['user'].'@'.$GLOBALS["webs"]['domain']."',
71 
					passwd='".$passwd."',
72 
					ignoreRemoteHosts=".$user["ignoreRemoteHosts"].",
73 
					email='".$user['email']."',
74 
					telefon='".$user['telefon']."',
75 
					fax='".$user['fax']."',
76 
					dir='".$user['dir']."',
77 
					beschreibung='".$user['beschreibung']."',
78 
					mitarbeiter='".$user["Mitarbeiter"]."',
79 
					app_user='".$user['app_user']."',
80 
					letzte_aenderung_von='".$this->session->username."'
81 
				WEHRE
82 
					id=".$user["ID"]."
83 
			";
84 
		}
85 
		else
86 
		{
87 
			$sql = "
88 
				INSERT INTO
89 
					Access
90 
				SET
91 
					name='".$user['name']."',
92 
					user='".$user['user'].'@'.$GLOBALS["webs"]['domain']."',
93 
					passwd='".$passwd."',
94 
					ignoreRemoteHosts=".$user["ignoreRemoteHosts"].",
95 
					email='".$user['email']."',
96 
					telefon='".$user['telefon']."',
97 
					fax='".$user['fax']."',
98 
					dir='".$user['dir']."',
99 
					beschreibung='".$user['beschreibung']."',
100 
					mitarbeiter='".$user["Mitarbeiter"]."',
101 
					app_user='".$user['app_user']."',
102 
					erstellt_am=NOW(),
103 
					erstellt_von='".$this->session->username."'
104 
			";
105 
		}
106 
		$GLOBALS['db_red_write']->query($sql);
107 
	}
951 lars 108 
}
109 
 
110 
?>