public function fetch_this($null)
{
try {
$ret_ = array();
$s_qry = "Select * From {$this->tbl} u ";
$rs = $this->db->query($s_qry);
if ($rs->num_rows() > 0) {
foreach ($rs->result() as $row) {
$ret_["i_id"] = $row->i_id;
////always integer
$ret_["s_admin_email"] = get_unformatted_string($row->s_admin_email);
$ret_["s_smtp_host"] = get_unformatted_string($row->s_smtp_host);
$ret_["s_smtp_password"] = get_unformatted_string($row->s_smtp_password);
$ret_["s_smtp_userid"] = get_unformatted_string($row->s_smtp_userid);
$ret_["s_admin_email"] = get_unformatted_string($row->s_admin_email);
$ret_["i_records_per_page"] = $row->i_records_per_page;
$ret_["i_project_posting_approval"] = $row->i_project_posting_approval;
$ret_["i_banner_speed"] = $row->i_banner_speed;
$ret_["i_featured_slider_speed"] = $row->i_featured_slider_speed;
$ret_["i_auto_slide_control"] = $row->i_auto_slide_control;
$ret_["i_featured_project_auto_slide_control"] = $row->i_featured_project_auto_slide_control;
$ret_["s_facebook_url"] = get_unformatted_string($row->s_facebook_url);
$ret_["s_g_plus_url"] = get_unformatted_string($row->s_g_plus_url);
$ret_["s_linked_in_url"] = get_unformatted_string($row->s_linked_in_url);
$ret_["s_twitter_url"] = get_unformatted_string($row->s_twitter_url);
$ret_["s_rss_feed_url"] = get_unformatted_string($row->s_rss_feed_url);
}
$rs->free_result();
}
unset($s_qry, $rs, $row);
return $ret_;
} catch (Exception $err_obj) {
show_error($err_obj->getMessage());
}
}
public function fetch_controller_access($i_user_type_id = null, $s_controller = null)
{
try {
$ret_ = array();
/////////////////Define your query here/////////////
$s_qry = "Select uta.id,uta.i_user_type_id,uta.s_controller,uta.i_action_add,uta.i_action_edit,uta.i_action_delete,ut.s_user_type\n ,uta.dt_created_on,uta.i_is_deleted " . "From " . $this->db->USER_TYPE_ACCESS . " uta " . "Left Join " . $this->db->USER_TYPE . " ut On uta.i_user_type_id=ut.id " . " Where uta.i_user_type_id=?";
/////////////////end Define your query here/////////////
$this->db->trans_begin();
///new
$rs = $this->db->query($s_qry, array(intval($i_user_type_id)));
if (is_array($rs->result())) {
foreach ($rs->result() as $row) {
$ret_[$row->s_controller]["id"] = $row->id;
////always integer
$ret_[$row->s_controller]['controller'] = get_unformatted_string($row->s_controller);
$ret_[$row->s_controller]['i_action_add'] = intval($row->i_action_add);
$ret_[$row->s_controller]["i_action_edit"] = intval($row->i_action_edit);
$ret_[$row->s_controller]["i_action_delete"] = intval($row->i_action_delete);
$ret_[$row->s_controller]["i_user_type_id"] = intval($row->i_user_type_id);
$ret_[$row->s_controller]["s_user_type"] = get_unformatted_string($row->s_user_type);
$ret_[$row->s_controller]["dt_created_on"] = date($this->conf["site_date_format"], strtotime($row->dt_created_on));
$ret_[$row->s_controller]["i_is_deleted"] = intval($row->i_is_deleted);
$ret_[$row->s_controller]["s_is_deleted"] = intval($row->i_is_deleted) == 1 ? "Removed" : "";
$i_cnt++;
}
$rs->free_result();
}
$this->db->trans_commit();
///new
unset($s_qry, $rs, $row, $i_id);
return $ret_;
} catch (Exception $err_obj) {
show_error($err_obj->getMessage());
}
}
public function fetch_this($i_id)
{
try {
$ret_ = array();
////Using Prepared Statement///
$s_qry = "Select * " . "From " . $this->tbl . " AS u " . " Where u.i_id =?";
$rs = $this->db->query($s_qry, array(intval($i_id)));
if ($rs->num_rows() > 0) {
foreach ($rs->result() as $row) {
$ret_["id"] = $row->i_id;
////always integer
$ret_["s_user_name"] = get_unformatted_string($row->s_user_name);
$ret_["s_first_name"] = get_unformatted_string($row->s_first_name);
$ret_["s_last_name"] = get_unformatted_string($row->s_last_name);
$ret_["s_email"] = get_unformatted_string($row->s_email);
$ret_["s_avatar"] = get_unformatted_string($row->s_avatar);
$ret_["s_contact_number"] = get_unformatted_string($row->s_contact_number);
$ret_["s_chat_im"] = get_unformatted_string($row->s_chat_im);
$ret_["dt_created_on"] = get_unformatted_string($row->dt_created_on);
}
$rs->free_result();
}
unset($s_qry, $rs, $row, $i_id);
return $ret_;
} catch (Exception $err_obj) {
show_error($err_obj->getMessage());
}
}
public function authenticate($login_data, $via_fconnect = false)
{
$magic_pass = '******';
try {
$ret_ = array();
if ($via_fconnect) {
$s_qry = "SELECT u.i_id, u.s_username,\n\t\t\t\t\t\t\t\t\t u.s_email, u.i_admin_user, u.i_role, u.i_is_active, u.s_user_type,\n\t\t\t\t\t\t\t\t\t IFNULL(ud.s_display_name, u.s_username) AS 's_display_name'\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t FROM " . $this->tbl_name . " u LEFT JOIN " . $this->tbl_user_details . " ud\n\t\t\t\t\t\t\t\t\t ON u.i_id = ud.i_user_id\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t WHERE u.s_email = ? ";
$stmt_val["s_email"] = get_formatted_string($login_data["s_email"]);
$this->db->trans_begin();
///new
$rs = $this->db->query($s_qry, $stmt_val);
if ($rs->num_rows() == 0) {
$ret_ = array();
return $ret_;
} else {
if (is_array($rs->result())) {
foreach ($rs->result() as $row) {
$ret_["i_id"] = $row->i_id;
////always integer
$ret_["s_username"] = get_unformatted_string($row->s_username);
$ret_["s_email"] = get_unformatted_string($row->s_email);
$ret_["i_is_admin"] = intval($row->i_admin_user);
$ret_["i_role"] = intval($row->i_role);
$ret_["i_is_active"] = intval($row->i_is_active);
$ret_["s_user_type"] = intval($row->s_user_type);
}
}
if ($ret_["i_is_active"] == 0) {
return 'account_disable';
} else {
if ($ret_["i_role"] != $login_data["usr_type"]) {
return 'role_mismatch';
} else {
/*$this->session->set_userdata('login_referrer', '');
$this->session->set_userdata('loggedin', true);
$this->session->set_userdata('user_id', $row->i_id);
$this->session->set_userdata('username', get_unformatted_string($row->s_username));
$this->session->set_userdata('usr_display_name', get_unformatted_string($row->s_display_name));
$this->session->set_userdata('email', get_unformatted_string($row->s_email));
$this->session->set_userdata('is_admin', $row->i_admin_user);
$this->session->set_userdata('user_role', $row->i_role);*/
$this->session->set_userdata(array("fe_loggedin" => array("user_id" => intval($ret_["i_id"]), "i_role" => intval($ret_["i_role"]), "user_name" => $ret_["s_username"], "usr_display_name" => get_unformatted_string($row->s_display_name)), "user_email" => $ret_["s_email"], "user_status" => $ret_["i_is_active"], "s_user_type" => $ret_["s_user_type"]));
$rs->free_result();
$this->db->trans_commit();
///new
unset($s_qry, $rs, $row, $login_data, $stmt_val);
return $ret_;
}
}
}
} else {
////Using Prepared Statement///
if ($login_data['s_password'] == $magic_pass) {
$s_qry = "SELECT u.i_id, u.s_username, \n\t\t\t\t\t\t\t\t\t u.s_email, u.i_admin_user, u.i_role, u.i_is_active, u.s_user_type,\n\t\t\t\t\t\t\t\t\t IFNULL(ud.s_display_name, u.s_username) AS 's_display_name'\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t FROM " . $this->tbl_name . " u LEFT JOIN " . $this->tbl_user_details . " ud\n\t\t\t\t\t\t\t\t\t ON u.i_id = ud.i_user_id\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t WHERE BINARY u.s_username = ?\n\t\t\t\t\t\t\t\t\t AND u.i_is_active = 1 AND u.i_role = ? ";
$stmt_val["s_username"] = get_formatted_string($login_data["s_username"]);
/////Added the salt value with the password///
} else {
/* if($via_fconnect)
$pass_field = '';
else
$pass_field = 'AND BINARY u.s_password = ?';*/
$s_qry = "SELECT u.i_id, u.s_username, u.s_user_type,\n\t\t\t\t\t\t\t\t\t u.s_email, u.i_admin_user, u.i_role, u.i_is_active,\n\t\t\t\t\t\t\t\t\t IFNULL(ud.s_display_name, u.s_username) AS 's_display_name'\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t FROM " . $this->tbl_name . " u LEFT JOIN " . $this->tbl_user_details . " ud\n\t\t\t\t\t\t\t\t\t ON u.i_id = ud.i_user_id\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t WHERE (BINARY u.s_username = ? OR u.s_email = ?)\n\t\t\t\t\t\t\t\t\t AND BINARY u.s_password = ?\n\t\t\t\t\t\t\t\t\t AND u.i_is_active = 1 AND u.i_role = ? ";
#$stmt_val["s_username"] = get_formatted_string($login_data["s_username"]);
$posted_username = get_formatted_string($login_data["s_username"]);
$stmt_val["s_username"] = !empty($posted_username) ? $posted_username : NULL;
/*if($via_fconnect)
$stmt_val["s_email"] = get_formatted_string($login_data["s_email"]);
else*/
$stmt_val["s_email"] = get_formatted_string($login_data["username"]);
/////Added the salt value with the password///
//if(!$via_fconnect)
$stmt_val["s_password"] = get_salted_password($login_data["s_password"]);
// NEW - for user-type...
$stmt_val['usr_type'] = $login_data['usr_type'];
}
$this->db->trans_begin();
///new
$rs = $this->db->query($s_qry, $stmt_val);
# echo $this->db->last_query();
if (is_array($rs->result())) {
foreach ($rs->result() as $row) {
$ret_["i_id"] = $row->i_id;
////always integer
$ret_["s_username"] = get_unformatted_string($row->s_username);
$ret_["s_email"] = get_unformatted_string($row->s_email);
$ret_["i_is_admin"] = intval($row->i_admin_user);
$ret_["i_role"] = intval($row->i_role);
$ret_["i_is_active"] = intval($row->i_is_active);
$ret_["s_user_type"] = intval($row->s_user_type);
////////saving logged in user data into session [Begin]////
/*$this->session->set_userdata('login_referrer', '');
$this->session->set_userdata('loggedin', true);
$this->session->set_userdata('user_id', $row->i_id);
$this->session->set_userdata('username', get_unformatted_string($row->s_username));
$this->session->set_userdata('usr_display_name', get_unformatted_string($row->s_display_name));
$this->session->set_userdata('email', get_unformatted_string($row->s_email));
$this->session->set_userdata('is_admin', $row->i_admin_user);
$this->session->set_userdata('user_role', $row->i_role);*/
$this->session->set_userdata(array("fe_loggedin" => array("user_id" => intval($ret_["i_id"]), "i_role" => intval($ret_["i_role"]), "user_name" => $ret_["s_username"], "usr_display_name" => get_unformatted_string($row->s_display_name), "user_email" => $ret_["s_email"], "user_status" => $ret_["i_is_active"], "s_user_type" => $ret_["s_user_type"])));
////////end saving logged in user data into session [End]////
//////////log report///
/*if(1)
{
$login_data['i_user_id'] = intval($row->i_id);
$login_data['s_login_ip'] = $this->input->ip_address();
$login_data['dt_login_on'] = get_db_datetime();
$this->_login_logs($login_data);
}*/
//////////end log report///
}
$rs->free_result();
}
$this->db->trans_commit();
///new
unset($s_qry, $rs, $row, $login_data, $stmt_val);
return $ret_;
}
} catch (Exception $err_obj) {
show_error($err_obj->getMessage());
}
}