[Spam Attack] How to filter all Applicants in GDN_User.

Chanux

How to filter all Applicants in GDN_User.

whu606

@Chanux

If you made it clearer what you are hoping to achieve, there is a higher chance of someone being able to advise you correctly.

peregrine

@Chanux.

Since your question is a riddle I thought i would play the game.

• to filter and delete Applicants use this plugin

http://vanillaforums.org/addon/cleanser-plugin or the BulkEditor plugin

• to filter and restrict login attempts, use the

http://vanillaforums.org/addon/registrationrestrictlogger-plugin

• to filter capabilities of an applicant

remove permission in that role for viewing activity and profile.

• to filter via a program use

http://vanillaforums.org/addon/memberslistenh-plugin

there are a number of other ways as well.

I am not sure if you will respond, since you have asked numerous questions in the past and never provided a folowup, but just in case you haven't read this - I'll provide you a few links

http://vanillaforums.org/discussion/23130/forum-post-ettikett-etiquette

http://vanillaforums.org/discussion/17954/food-for-thought-forum-etiquette

http://vanillaforums.org/discussion/25115/how-to-how-can-a-new-user-better-help-the-community-when-asking-a-question

Chanux

my forum under huge Spam attack. they create over 1000 user accounts per day. after that i changed registration system as admin approval.

But They Didn't stop. I have about 5000 spam accounts now. i jst want to remove this all accout from application aproval panel.

I don't need any plugins. please give me some advice. How can i filter applicant using Table column.

peregrine

@Chanux said:

I> don't need any plugins.

au contraire. you do indeed need two plugins to aid you in you mission.

No problem, your choice, you don't want a plugin that works to do what you are seeking to do bizarre.

I suggest you read up on my sql joins.

the cleanser plugin will and produce a list of applicants that you can view.
the cleanser will also remove all the spam applicants if you choose to remove them.

http://vanillaforums.org/addon/cleanser-plugin

my forum under huge Spam attack. they create over 1000 user accounts per day. after that i changed registration system as admin approval.

I still suggest this: http://vanillaforums.org/addon/registrationrestrictlogger-plugin

You can lead a horse to water, but you can't make them drink.

R_J

@Chanux: You'll need to know the role ID (GDN_Role), and then you can look up the role of each user in GDN_UserRole. That will give you the IDs of the users in GDN_User.

No offense, but if you do not know or see that in your database, you shouldn't use database tools to "clean" up. As you can see from the simple explanation on where to look up the roles, you could guess that there are numerous other tables involved when a user registers. If you just clean up, GDN_User, your database becomes a mess.

Do yourself a favor and follow @peregrines advice to use a clever plugin for that job.

peregrine

@R_J said:
Chanux: You'll need to know the role ID (GDN_Role), and then you can look up the role of each user in GDN_UserRole. That will give you the IDs of the users in GDN_User.

No offense, but if you do not know or see that in your database, you shouldn't use database tools to "clean" up. As you can see from the simple explanation on where to look up the roles, you could guess that there are numerous other tables involved when a user registers. If you just clean up, GDN_User, your database becomes a mess.

Do yourself a favor and follow peregrines advice to use a clever plugin for that job.

Thanks @R_J, I was fearful someone would post sql code that would get him into bigger trouble.

R_J

I love giving answers for the original questions, even if I think there are better ways to solve a problem, because people should be able to decide which way to go.
But if they want to jump off a cliff, I don't feel the urge to push them... I never have advised anyone to "format c:" either

peregrine

I just tried "format c:" and I was off-line for a while. had to recover the system .

whu606

@peregrine

Good job you kept a backup!

I always tell people to keep a copy in C:\Backup, in case anything goes wrong...

UnderDog

@peregrine said:
I just tried "format c:" and I was off-line for a while.

I Did deltree in c:\windows once ... I thought I was in c:\windows\temp\

peregrine

@UnderDog said:
I Did deltree in c:\windows once ... I thought I was in c:\windows\temp\

some unix users would mistakenly create file names like *

then they would type rm * thinking it would remove the file "*" . it did, but alot more.

x00

if you alias /bin/rm -i as rm then you will always get interactive output, who actually writes /bin/rm most of the time? So it will tell you what is about to be deleted [y/n]

Chanux

We can't Stop them.. This is the end of my day.. every day i deleted all of this.

Chanux

Unfortunately my All Decline or All Approve Option is not working

hgtonight

There is a limit to how much data can be passed in a get request which is how this screen works, IIRC.

You are getting that many spam applicants every day?

peregrine

We can't Stop them.. This is the end of my day.. every day i deleted all of this.

yes, you can

Unfortunately my All Decline or All Approve Option is not working

we already told you that- that is why the plugins were created. that's limitation of vanilla, they never expected to have 5000 applicants, and they way the vanilla software in the dashboard is written, it can't deal with it - timeouts etc.

http://vanillaforums.org/discussion/comment/196127/#Comment_196127

@Chanux - you don't seem to follow instructions. that have already been given. If you can't follow advice - why ask for it. numerous people have been successful using this method

http://vanillaforums.org/discussion/24785/poll-which-registration-method-and-plugins-do-you-use-to-deter-spammers-and-their-efficacy

Chanux

unfortunately All this solutions are not working for me.

now i just want to know "How can i filter Applicant user from database". i mean witch table witch value represent applicant users.

R_J

Look at that interesting discussion for your answer: http://vanillaforums.org/discussion/comment/196133/#Comment_196133

whu606

@Chanux

I got those same applicants, while using BotStop with Registration Approval modification.

@peregrine wrote a brilliant plugin, http://vanillaforums.org/addon/1139/registration-restrict-logger which stopped them in their tracks.

If you are using this solution, and it isn't working for you, then I can only think you are not implementing it correctly.

If you add the {I want to see text to the plugin, you'll never see those applicants again.

peregrine

@Chanux

unfortunately All this solutions are not working for me.

the details you provided are exasperating.