/** * 获取指定群信息 * @UserFunction(method = GET) * @CheckLogin */ function get_group(Integer $id) { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $user_id = getCurrentUserId(); $group = $db->fetch('SELETE * FROM `group` WHERE `id` = ?', $id); $group['users'] = $db->fetchAll('SELECT a.`id`, a.`username`, a.`portrait` FROM `user` AS a INNER JOIN `group_user` AS b ON b.user_id=a.id WHERE b.group_id = ?', $id); return $group; }
/** * 删除好友数据 * @UserFunction(method = GET|POST) * @CheckLogin */ function delete_friend(Integer $id) { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $my_friend_status = $db->fetch('SELECT `status` FROM `friend` WHERE `user_id` = ? AND `friend_id` = ?', getCurrentUserId(), $id); $other_friend_status = $db->fetch('SELECT `status` FROM `friend` WHERE `user_id` = ? AND `friend_id` = ?', $id, getCurrentUserId()); if ($my_friend_status && $other_friend_status) { if ($my_friend_status['status'] == 1) { //我们是好友 $db->exec('DELETE FROM `friend` WHERE `user_id`=? AND `friend_id`=?;', getCurrentUserId(), $id); $db->exec('UPDATE `friend` SET `status` = 5 WHERE `user_id`=? AND `friend_id`=?;', $id, getCurrentUserId()); } else { if ($my_friend_status['status'] == 2) { // 删除请求 $db->exec('DELETE FROM `friend` WHERE `user_id`=? AND `friend_id`=?;', getCurrentUserId(), $id); $db->exec('DELETE FROM `friend` WHERE `user_id`=? AND `friend_id`=?;', $id, getCurrentUserId()); } else { if ($my_friend_status['status'] == 3) { // 删除请求 $db->exec('DELETE FROM `friend` WHERE `user_id`=? AND `friend_id`=?;', getCurrentUserId(), $id); $db->exec('UPDATE `friend` SET `status` = 4 WHERE `user_id`=? AND `friend_id`=?;', $id, getCurrentUserId()); } else { throw new ProException('unknow error', 305); } } } } else { if ($my_friend_status) { $db->exec('DELETE FROM `friend` WHERE `user_id`=? AND `friend_id`=?;', getCurrentUserId(), $id); } else { throw new ProException('unknow error', 306); } } }
/** * 获取某人用户资料 * @UserFunction(method = GET) * @CheckLogin */ function profile(Integer $id) { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $user = $db->fetch('SELECT `id`, `username`, `portrait` FROM `user` WHERE `id` = ?', $id); if ($user) { return $user; } else { throw new ProException('user not found', 109); } }