function like_action($user_id, $action_id)
{
if (!$user_id || !$action_id) {
return false;
}
$query = he_database::placeholder("SELECT COUNT(*) FROM `se_he_wall_like`\r\n WHERE `user_id`=? AND `action_id`=?", $user_id, $action_id);
$like = he_database::fetch_field($query);
if ($like == 1) {
$query = he_database::placeholder("DELETE FROM `se_he_wall_like`\r\n WHERE `user_id`=? AND `action_id`=?", $user_id, $action_id);
} else {
$query = he_database::placeholder("INSERT INTO `se_he_wall_like`\r\n (`user_id`, `action_id`, `like_stamp`) VALUES(?, ?, ?)", $user_id, $action_id, time());
}
he_database::query($query);
//GET ACTION LIKES
$query = he_database::placeholder("SELECT `a`.`user_id`, `u`.`user_username`, `u`.`user_fname`, `u`.`user_lname` \r\n FROM `se_he_wall_like` AS `a`\r\n INNER JOIN `se_users` AS `u` ON (`a`.`user_id`=`u`.`user_id`)\r\n WHERE `a`.`action_id`=? ORDER BY `a`.`like_stamp`", $action_id);
$res = he_database::query($query);
$user_ids = array();
$user_arr = array();
while ($row = he_database::fetch_row_from_resource($res)) {
$action_user = new se_user();
$action_user->user_exists = 1;
$action_user->user_info['user_id'] = $row['user_id'];
$action_user->user_info['user_username'] = $row['user_username'];
$action_user->user_info['user_fname'] = $row['user_fname'];
$action_user->user_info['user_lname'] = $row['user_lname'];
$action_user->user_displayname();
$user_ids[] = $row['user_id'];
$user_arr[$row['user_id']] = $action_user;
}
$action_info = he_wall::format_like($user_ids, $user_arr);
$action_info = $action_info ? $action_info : array('like' => 0, 'value' => '');
return $action_info;
}
