1
hipoonios
Can't delete spammers messages (newbb)
  • 2010/11/4 20:21

  • hipoonios

  • Friend of XOOPS

  • Posts: 298

  • Since: 2005/9/24


Hi,

A spammer have spammed my forum. Somehow he has managed to post html in the forum even if it is turned off in administration!

Now I can't delete his messages because there is no delete button.

My forum is here:http://www.classicgametunes.net/modules/newbb/viewforum.php?forum=1

Click on any topic and see what I mean.

My questions is.

1. How did he manage to do this? I have protector installed.
2. What is the easiest way to delete his messages?
I love Xoops!

2
dbman
Re: Can't delete spammers messages (newbb)
  • 2010/11/4 21:14

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


In phpmyadmin or another client use this SQL statement:
DELETE FROM <prefix>_bb_posts,<prefix>_bb_posts_text USING <prefix>_bb_posts, <prefix>_bb_posts_text WHERE (<prefix>_bb_posts.uid 308 AND <prefix>_bb_posts.post_id = <prefix>_bb_posts_text.post_id);



Replace <prefix> with your Xoops DB prefix. I see the spammers uid is 308 from the link you posted. Of course you should backup your database prior to executing this statement.



3
ghia
Re: Can't delete spammers messages (newbb)
  • 2010/11/5 1:49

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


You can also delete them with the normal forum routines one by one, by replacing viewtopic in the URL of your navigator when the post is in view by delete and then press go.
/modules/newbb/viewtopic.php?topic_id=110&forum=1&post_id=336#forumpost336
=>
/modules/newbb/delete.php?topic_id=110&forum=1&post_id=336#forumpost336



4
hipoonios
Re: Can't delete spammers messages (newbb)
  • 2010/11/5 3:54

  • hipoonios

  • Friend of XOOPS

  • Posts: 298

  • Since: 2005/9/24


Thanks! Both these ways worked. I used the phpmyadmin way here as it was faster (he made about 40 posts).

Any idea how he could post html?
I love Xoops!

5
dbman
Re: Can't delete spammers messages (newbb)
  • 2010/11/5 4:30

  • dbman

  • Friend of XOOPS

  • Posts: 172

  • Since: 2005/4/28


What version of xoops is the site running?

6
ghia
Re: Can't delete spammers messages (newbb)
  • 2010/11/5 9:28

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Forum version?
The posting is done by automated scripts and is not dependent on the editors provided on your site.
Check in the fora properties that you have Allow html = no.

Login

Who's Online

264 user(s) are online (154 user(s) are browsing Support Forums)


Members: 0


Guests: 264


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits