telex
15-03-09, 10:19 AM
:big_smile:Cái này mình sưuu tầm được nếu các bạn thấy có ích nhơ thank nhá :
delete account with nomore connect from 2007-06-01:
delete from memb_info
where memb___id in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
delete from accountcharacter
where id in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
where accountid in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
delete from warehouse
where accountid in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
delete account that no connect ( blank account ) or longtime no connect:
delete from memb_info
where memb___id not in (
select memb___id from memb_stat)
delete from accountcharacter
where id not in (
select memb___id from memb_stat)
delete from character
where accountid not in (
select memb___id from memb_stat)
delete from warehouse
where accountid not in (
select memb___id from memb_stat)
Character not in account :
select accountid,character.name from character where accountid in (
select accountid from character
where name not in (select gameid1 from accountcharacter where id=accountid )
and name not in (select gameid2 from accountcharacter where id=accountid )
and name not in (select gameid3 from accountcharacter where id=accountid )
and name not in (select gameid4 from accountcharacter where id=accountid )
and name not in (select gameid5 from accountcharacter where id=accountid )
)
delete guild , guildmember that wrong :
alter table guild nocheck constraint all
alter table guildmember nocheck constraint all
delete from guild
where g_master not in ( select name from character )
delete from guildmember
where name not in ( select name from character )
delete from guildmember
where G_Name not in ( select G_name from guild )
Sr mình quên ghi nguồn : Nguồn từ webmu.org :D
delete account with nomore connect from 2007-06-01:
delete from memb_info
where memb___id in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
delete from accountcharacter
where id in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
where accountid in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
delete from warehouse
where accountid in (
select memb___id from memb_stat where disconnecttm<'2007-06-01')
delete account that no connect ( blank account ) or longtime no connect:
delete from memb_info
where memb___id not in (
select memb___id from memb_stat)
delete from accountcharacter
where id not in (
select memb___id from memb_stat)
delete from character
where accountid not in (
select memb___id from memb_stat)
delete from warehouse
where accountid not in (
select memb___id from memb_stat)
Character not in account :
select accountid,character.name from character where accountid in (
select accountid from character
where name not in (select gameid1 from accountcharacter where id=accountid )
and name not in (select gameid2 from accountcharacter where id=accountid )
and name not in (select gameid3 from accountcharacter where id=accountid )
and name not in (select gameid4 from accountcharacter where id=accountid )
and name not in (select gameid5 from accountcharacter where id=accountid )
)
delete guild , guildmember that wrong :
alter table guild nocheck constraint all
alter table guildmember nocheck constraint all
delete from guild
where g_master not in ( select name from character )
delete from guildmember
where name not in ( select name from character )
delete from guildmember
where G_Name not in ( select G_name from guild )
Sr mình quên ghi nguồn : Nguồn từ webmu.org :D