Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall
Hello everyone, today, a lot of Dede users difficult to solve the problem. Is the background of a large number of garbage enterprise membership problem. This is a very headache problem because Dede delete members are not all deleted alive Select multiple deletion features. So many sites have hundreds of spam members and send out some spam articles every day. Delete up again very difficult, everybody must be very headache, below I come to use plain and text method to teach everybody.
One: Member permission set
Login ded Background-Select the System column-then click on member settings (figure)
And then find members to use the right to open the status of this column, dede default option is 0 is registered members can publish articles. You can change it to 10 or 1. I propose to modify to 1. This will not be able to post spam members.
Second: Delete all garbage member: Although who can first audit members and then let the article but when you see a lot of garbage members in your website member system, it will also be very headache, and it is easy to miss some regular registered members. So here's a way to remove all the junk members directly
As shown in
This is a part, we should be able to see that is actually a person or a group of software is used mass. In fact, we carefully observe the garbage members, will find that he has a common point is that the enterprise users, and the name is the same, which gives us all the solution to remove members.
The method is as follows: Login dede-then click System Settings-then SQL command line tools as shown
Then enter the code with the inside:
SELECT * FROM Dede_member Query database membership table.
Delete from Dede_member where mtype= ' Enterprise ' deletes member table data according to the Enterprise field.
This is actually SQL. You can delete data whenever you find each property field in the table.
All right, I hope this helps you to solve the problem of backstage members also hope to be able to discuss technical issues with you this article by love article webmaster www.aiwenzhang.cn static water starting in A5 Welcome reprint declined to copy