Jump to content
Jambands.ca
Sign in to follow this  
fluffhead77

spam

Recommended Posts

temporary damage control. lowroller suggested that to minimize cleanup. I can't think of everything. I've deleted about 1000 accounts that were all spammers. One by frikkin one. I found that Firefox was great for doing it though because I could minimize the amount of clicks, submit the delete form with the enter key (safari forced an extra click) and then I learned that I could close the 20 or so tabs (I did about 20 tabs worth at a time) by right clicking on my search page and "close all other tabs".

Now I have to close the forum down, take a backup while it's much cleaner and then test my delete anonymous posts sql.

likely in the next 15 minutes.

Share this post


Link to post
Share on other sites

getting there. no new spam should show up. I still need to clean up the 300 or so spam posts but my test query didn't work. Who's good at mysql here? I have a select that pulls them out, but my syntax is f'd for the delete of the same dataset.

also, NO NEW registrations have been logged since the big cleanup and lockdown today. we're getting back our land!

Share this post


Link to post
Share on other sites

Awesome. Still haven't heard back from the guy about the user group deal, I think he may be on holidays from the sounds of it. But one of the other mods I emailed thinks they did what you were thinking you may have to do about making a new group for existing members then creating a group for new users, but he couldn't confirm. And it was a vBulletin board too.

Share this post


Link to post
Share on other sites
apparently spam is really popular in okinawa.

true story.

It's massively popular in Korea. People think I'm crazy when I tell them that it is considered the lowest form of food available. On Monday I was at my sister-in-law's place for a big holiday meal. One of the gift bags someone brought her was a giant package of Spam and canned tuna.

Share this post


Link to post
Share on other sites
Awesome. Still haven't heard back from the guy about the user group deal, I think he may be on holidays from the sounds of it. But one of the other mods I emailed thinks they did what you were thinking you may have to do about making a new group for existing members then creating a group for new users, but he couldn't confirm. And it was a vBulletin board too.

if found some php code that automatically places new registrants into a specific group. I can change that without much effort other than making sure I document it for the day I update the forums...the code will have to change again. I'd rather not do it that way so I may just assign y'all to a new group....yet unnamed but I have one in mind. Rhymes with thanks.

Share this post


Link to post
Share on other sites

didn't update the site yet. I did a backup last night and it took hours. I'll close down again tonight and rebackup the database. That part just takes a few minutes...and then I should be able to update the site and turn it back on.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...