| Author |
 Topic Search  Topic Options
|
123Simples 
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 08 November 2010 at 5:53pm |
 rgelb wrote:
@MrTws - We are talking about 6 months of spam (probably several thousand entries). |
So are you busy for the next few weeks then?  If it is several thousands of spam messages, then out of curiosity, how many are left that you actually want to keep? I'm sure Bruce (or someone more up on this) will give you an answer to your problem, but if I were you, I'd start making manual deletions now just to cut down on the workload
|
|
|
 |
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 November 2010 at 5:58pm |
|
Also, by any chance is your posts (spam) mainly made by guests, rather than members?
|
|
|
|
rgelb
Newbie
Joined: 04 August 2005
Status: Offline
Points: 15
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 November 2010 at 5:03pm |
|
The posts are by members and guests. So after deleting all the spam posts there should be about a 1000 legit posts left.
|
|
Scotty32
Moderator Group
Joined: 30 November 2002
Location: Manchester, UK
Status: Offline
Points: 1682
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 November 2010 at 6:33pm |
you could probably go into the database and do:
DELETE FROM tblThreads WHERE Author_ID = *spam id* |
Which would delete all posts for that user. Though, I dont know if it would affect other parts of the forum, You would need to do a Posts Resync in the Admin Area. You may also end up with Topics that dont have any posts in them, another SQL statement may be able to clear them out too.
|
|
|
|
StarDust
Senior Member
Joined: 14 May 2007
Location: Bangladesh
Status: Offline
Points: 310
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2010 at 8:38am |
JohnnyW wrote:
I'm a developer myself so relitivly easily wrote my own mod called the 'spamming p**k' button for admins which sits under the post options menu. If there's a spammer hit the forum by hitting the page it'll delete all their posts, ban their account and their IP address. It has certainly cut down on a lot of wasted time and I'm sure it'd be a welcome addition to future versions as the problem is only going to get worse unfortunatly.
|
I absolutely support this idea. I think the developers should look into this idea for the future versions. Its not something that will require some major re-shifting in the coding, so it could be done. Hi Bruce, MrTWS and Scotty! Its good to meet you again!
|
|
|
|
pbanks
Groupie
Joined: 22 August 2008
Location: Ireland
Status: Offline
Points: 70
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2010 at 9:08am |
| I'm a developer myself so relitivly easily wrote my own mod called the
'spamming p**k' button for admins which sits under the post options
menu. If there's a spammer hit the forum by hitting the page it'll
delete all their posts, ban their account and their IP address. It has
certainly cut down on a lot of wasted time and I'm sure it'd be a
welcome addition to future versions as the problem is only going to get
worse unfortunatly. |
It would be great if you could "share" this in the Mod Section ... I think we'd all benefit from such an addition?
|
|
123Simples
Senior Member
Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192
|
Post Options
Thanks(0)
Quote Reply
Posted: 10 November 2010 at 6:23pm |
|
Hi StarDust
Where have you been?
|
|
|
|
StarDust
Senior Member
Joined: 14 May 2007
Location: Bangladesh
Status: Offline
Points: 310
|
Post Options
Thanks(0)
Quote Reply
Posted: 11 November 2010 at 5:03am |
|
MrTWS, I have been around. just was silent. :D
|
|
|
|
Tips, mods and skins for WWF v9.x