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;
}
}
