/** * 退出群 * @UserFunction(method = GET|POST) * @CheckLogin */ function quit_group(Integer $id) { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $user_id = getCurrentUserId(); if ($db->exec('DELETE FROM `group_user` WHERE `group_id` = ? AND `user_id` = ?', $id, $user_id) > 0) { $db->exec('UPDATE `group` SET `number` = `number`-1 WHERE `id` = ?;', $id); } }
/** * 删除好友数据 * @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); } } }
if ($res) { $_RETURN['status'] = 1; $_RETURN['data'] = $res[0]; } else { $_RETURN['status'] = -1; $_RETURN['errorMsg'] = 'Ошибка получения данных пользователя'; } echo json_encode($_RETURN); } /** * @method: Удаляет пользователя с данным ID * @params: ID user * */ if ($_a == 'deleteUser') { $id = $_GET['id']; $res = $Db->exec('DELETE FROM user WHERE id = ' . $Db->quote($id)); $_RETURN['status'] = $res ? 1 : -1; echo json_encode($_RETURN); } /** * @method: Сохраняет новые данные пользователя * @params: ID user, DATA from form * */ if ($_a == 'saveUser') { $id = $_GET['userId']; $data = json_decode($_GET['data']); $data->password = md5($data->password); $rows = array('login', 'email', 'password', 'type', 'f', 'i', 'o'); $res = $Db->update('UPDATE user SET login = '******', email = ' . $Db->quote($data->mail) . ',
/** * 获取某人用户资料 * @UserFunction(method = POST) * @CheckLogin */ function update_profile(string $username) { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $db->exec('UPDATE `user` SET `username`= ? WHERE `id` = ?', $username, getCurrentUserId()); }