Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Solved [How To?] Delete posts from the same IP
#7
Not Solved
Hi faviouz,

The spam bot was a guest and hence did not have an uid (I confirmed this by querying all tables with the ip).

Therefore, I used the following (solution):
DELETE FROM mybb_posts WHERE ipaddress IN (1,2,3);
(replacing 1,2,3 with the list(s) of ipaddress')

Then I re-built all cache's and rebuilt thread counts and such, and now they (posts/threads) have all been with erased with no trace that the guest ever existed.

Many thanks for your assistance!


Messages In This Thread
Delete posts from the same IP - by NullZero - 2011-08-06, 07:28 PM
RE: Delete posts from the same IP - by faviouz - 2011-08-06, 07:35 PM
RE: Delete posts from the same IP - by NullZero - 2011-08-06, 07:42 PM
RE: Delete posts from the same IP - by ranjani - 2011-08-06, 07:52 PM
RE: Delete posts from the same IP - by NullZero - 2011-08-06, 08:13 PM
RE: Delete posts from the same IP - by faviouz - 2011-08-06, 08:22 PM
RE: Delete posts from the same IP - by NullZero - 2011-08-06, 08:33 PM
RE: Delete posts from the same IP - by faviouz - 2011-08-06, 08:44 PM
RE: Delete posts from the same IP - by bojris - 2011-09-02, 07:16 AM
RE: Delete posts from the same IP - by StefanT - 2011-09-02, 07:29 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)