天堂1游戏之查询指令(清除指定等级以下角色) |
|
文章作者:admin |
文章来源:天堂游戏,天堂1游戏,天堂1游戏发布网 |
更新时间:2010/6/20 19:24:07 |
|
|
|
--刪除低於50的腳色 DELETE characters.* FROM `characters` WHERE `level` < '150'; --把空帳號刪掉 DELETE accounts.* from accounts left join characters on accounts.login=characters.account_name where characters.account_name is null; --刪掉空角色的好友 DELETE character_buddys.* from character_buddys left join characters on character_buddys.char_id=characters.objid where characters.objid is null; DELETE character_buddys.* from character_buddys left join characters on character_buddys.buddy_id=characters.objid where characters.objid is null; --刪掉空角色的狀態 DELETE character_buff.* from character_buff left join characters on character_buff.char_obj_id=characters.objid where characters.objid is null; --刪掉空角色的東西 DELETE character_items.* from character_items left join characters on character_items.char_id=characters.objid where characters.objid is null; --刪掉空角色的任務 DELETE character_quests.* from character_quests left join characters on character_quests.char_id=characters.objid where characters.objid is null; --刪掉空角色的技能 DELETE character_skills.* from character_skills left join characters on character_skills.char_obj_id=characters.objid where characters.objid is null; --刪掉空角色的座標 DELETE character_teleport.* from character_teleport left join characters on character_teleport.char_id=characters.objid where characters.objid is null; --把空帳號的倉庫刪掉 DELETE character_warehouse.* from character_warehouse left join accounts on character_warehouse.account_name=accounts.login where accounts.login is null; --刪除不存在的寵物 DELETE pets.* from pets left join character_items on pets.item_obj_id=character_items.id where character_items.id is null; --刪除空血盟 DELETE clan_data.* from clan_data left join characters on clan_data.leader_id=characters.objid where characters.objid is null; --刪除空血盟倉庫 DELETE clan_warehouse.* from clan_warehouse left join clan_data on clan_warehouse.clan_name=clan_data.clan_name where clan_data.clan_name is null; --刪除最後登入日期的跟等級 delete `characters`.* FROM `accounts` Inner Join `characters` ON `characters`.`account_name` = `accounts`.`login` where `accounts`.`lastactive` < "2009-01-01 00:00:00" and `characters`.`level` < 150
|
浏览次数:59 |
|
|
|