Kreny's Blog

这里只作一个备份，不建议大家使用。

首先删除不存在的Group

DELETE FROM `phpbb_groups` WHERE group_id NOT IN (
SELECT group_id
FROM `phpbb_user_group`
)

接着删除不存在用户的Group

SELECT *
FROM `phpbb_user_group`
WHERE user_id NOT
IN (

SELECT user_id
FROM `phpbb_users`
)
AND user_id >0

找出注册却未登陆过的用户

SELECT user_id
FROM `phpbb_users`
where `user_lastvisit`= '0' and `user_id` > 0
ORDER BY `user_regdate` ASC;

SELECT * / DELETE
FROM `phpbb_user_group` WHERE user_id IN (
SELECT user_id
FROM `phpbb_users`
WHERE `user_lastvisit` = '0' AND `user_id` >0
)

SELECT * / DELETE
FROM `phpbb_users`
WHERE `user_lastvisit` = '0' AND `user_id` >0