Subversion-Projekte lars-tiefland.ci

<?php

/**
 *
 * @package WebanOS CI
 * @author Lars Tiefland <ltiefland@gmail.com> 
 * @copyright 2016
 * @version $Rev: 1044 $
 */

class User_model extends CI_Model
{
        public function __construct()
        {
                parent::__construct();
        }

        public function user_list()
        {
                $sql = "SELECT
                                *
                        FROM
                                Access
                        WHERE
                                user !='admin'
                        AND
                                user LIKE '%@".__SHOP__."'
                ";
                $res = $GLOBALS['db_red']->query($sql);
                $users = $res->result_array();
                return $users;
        }

        public function get_info($user_id)
        {
                $sql = "SELECT
                                *
                        FROM
                                Access
                        WHERE
                                id=".$user_id."
                ";
                $res = $GLOBALS["db_red"]->query($sql);
                $user = $res->row_array();
                list($user_local, $domain) = explode("@", $user["user"]);
                $user["domain"] = $domain;
                $user["local"] = $user_local;
                $user["datenquellen"] = unserialize($user["datenquellen"]);
                return $user;
        }
}

?>