Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
[Spam Attack] How to filter all Applicants in GDN_User.
Chanux
✭✭
How to filter all Applicants in GDN_User.
0
This discussion has been closed.
Answers
@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.
@Chanux.
Since your question is a riddle I thought i would play the game.
http://vanillaforums.org/addon/cleanser-plugin or the BulkEditor plugin
http://vanillaforums.org/addon/registrationrestrictlogger-plugin
remove permission in that role for viewing activity and profile.
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
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
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.
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
I still suggest this: http://vanillaforums.org/addon/registrationrestrictlogger-plugin
You can lead a horse to water, but you can't make them drink.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
@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.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
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
I just tried "format c:" and I was off-line for a while. had to recover the system .
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
@peregrine
Good job you kept a backup!
I always tell people to keep a copy in C:\Backup, in case anything goes wrong...
I Did deltree in c:\windows once ... I thought I was in c:\windows\temp\
There was an error rendering this rich post.
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.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
if you alias
/bin/rm -i
asrm
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]grep is your friend.
We can't Stop them.. This is the end of my day.. every day i deleted all of this.
Unfortunately my All Decline or All Approve Option is not working
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?
Search first
Check out the Documentation! We are always looking for new content and pull requests.
Click on insightful, awesome, and funny reactions to thank community volunteers for their valuable posts.
yes, you can
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
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
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.
Look at that interesting discussion for your answer: http://vanillaforums.org/discussion/comment/196133/#Comment_196133
@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.
@Chanux
the details you provided are exasperating.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.