强烈要求补丁出XS个人空间的批量删除功能

现在群发广告很疯狂，一个个的删除每个几十个个人空间真是要累死

删除ss6中某一用户空间的所有数据：

1. 
   
2. delete from supe_userspaces where uid=3;
   
3. delete from supe_userspacefields where uid=3;
   
4. delete from supe_spacecache where uid=3;
   
5. delete from supe_spacecomments where uid=3;
   
6. delete from supe_spaceitems where uid=3;
   
7. delete from supe_spaceblogs  where itemid NOT IN(SELECT itemid FROM supe_spaceitems);
   
8. delete from supe_spacefiles where itemid NOT IN (SELECT itemid FROM supe_spaceitems);
   
9. delete from supe_spacegoods where itemid NOT IN (SELECT itemid FROM supe_spaceitems);
   
10. delete from supe_spaceimages where itemid NOT IN (SELECT itemid FROM supe_spaceitems);
    
11. delete from supe_spacenews where itemid NOT IN (SELECT itemid FROM supe_spaceitems);
    
12. delete from supe_spacevideos where itemid NOT IN (SELECT itemid FROM supe_spaceitems);
    
13. delete from supe_spacetags where itemid NOT IN (SELECT itemid FROM supe_spaceitems);
    

复制代码

这些SQL语句要指定uid的。

删除ss6中某一用户空间的所有数据：这些SQL语句要指定uid的。
lidq.jingwu 发表于 2010-01-08 10:31

    你这个方法根本就不算是办法，还不如直接在后台删除了，我需要的是批量删除