ReddcoinRocks I dont trust deleting with querys anymore… I deleted 90% of one of my databases recently because it decided it didnt care about my “WHERE” part
iisurge haha yeah, that’s one of the moments when you click the button and realize in the same second that… oh no!
but what I have learned from that: always use transactions if you are working on a live db! http://www.tutorialspoint.com/sql/sql-transactions.htm
Oliver you’re right and that’s why I limited the suggested query to usernames where the characters are (8 alphabetic lowercase chars + 2 numeric)*X and the post count is zero. I think that is the safest query to do an automated delete on a huge amount of autogenerated data. but if most of them have the same IP Address that might be another good way to limit the result. I’m also sure the admins won’t do anything that harms “real” user accounts.
// EDIT: I think there is also the need to add a captcha to the registration process to avoid this in the future. It is quite interesting that some people are investing the time to create downvote bots on reddit and bots that create user accounts on reddcointalk now. they must be very scared of the vision and pace of the reddcoin project.
ReddcoinRocks I believe the askimet thing is already enabled here so shouldnt be to hard for them. Lol It tried to mark my reddcoin.conf post as spam with the askimet thing
BrownSlaughter It was good to have some cooldown time to get some distance to all this reddit madness. I just read that you left reddit and removed your bot and I really can understand this decision. It’s just tiring to do objective discussions in such an aggressive atmosphere.
I’m a little confused, why would there be a bot doing this? Is it just to make the community seem like it is bigger than it is? And is this what happened on reddit? (I must admit I totally thought reddit subscribers were real -_-)
Because haters can’t use the reddit and bitcointalk forums anymore to shill. On the other side, retreating from there might have actually encouraged them. It’s important to maintain a cool head and don’t let them get under your skin.
A lot of these bots just crawl random pages looking for familiar looking form fields that they can submit - I sort of doubt the registrations are malicious. The registration form should probably have some kind of email verify (or at least captcha).