public function get_vote_users($voc_id, $vot_val = false) { $result = array("status" => false, "message" => "", "data" => array()); if ($this->is_valid_voice($voc_id)) { if ($this->is_valid_vote_value($vot_val)) { $sql = "SELECT vote.id AS vote_id, vote.voice_id, vote.vote_value, vote.voted_on, users. *\n FROM voices_votes AS vote\n INNER JOIN users ON users.id = vote.user_id\n WHERE vote.voice_id=?\n AND vote.vote_value=?\n ORDER BY vote.id DESC"; $query = $this->db->query($sql, array($voc_id, $vot_val)); } else { $sql = "SELECT vote.id AS vote_id, vote.voice_id, vote.vote_value, vote.voted_on, users. *\n FROM voices_votes AS vote\n INNER JOIN users ON users.id = vote.user_id\n WHERE vote.voice_id =?\n ORDER BY vote.id DESC"; $query = $this->db->query($sql, array($voc_id)); } if ($query->num_rows() > 0) { $result['status'] = true; $result['message'] = 'Data found.'; //$result['data'] = $query->result_array(); foreach ($query->result_array() as $user) { $data = $user; $data['name'] = manage_name($user); array_push($result['data'], $data); } } } else { $result['message'] = "Voice id not valid."; } return $result; }
public function get_user($id = 0) { // set return result $result = array("status" => false, "message" => "", "data" => array()); if (is_logged_in()) { $sql = "SELECT * FROM users WHERE id=?"; $query = $this->db->query($sql, array($id)); if ($query->num_rows() > 0) { $result['status'] = true; $result['message'] = 'User found.'; $result['data'] = $query->row_array(); $result['data']['name'] = manage_name($result['data']); } else { $result['message'] = "Invalid user id"; } } else { $result['message'] = "Invalid user login."; } return $result; }
/** * Mod_Eco_System::is_valid_user() * * @param integer $uid * @return */ public function is_valid_user($uid = 0) { $sql = "SELECT * FROM users WHERE id=? AND is_blocked=0"; $query = $this->db->query($sql, array($uid)); if ($query->num_rows() > 0) { $user = $query->row_array(); $user['name'] = manage_name($user); return $user; } else { return false; } }