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