Best of joomla gives you news, joomla templates, tutorials and websites about Joomla , FireBoard and FireMessage official page.
| No account yet?   |
Welcome, Guest
Please Login or Register.    Lost Password?
FireBoard Manual Latest release discussions Download FireBoard Spread FireBoard!
How to delete certain posts of a user (1 viewing) (1) Guest
Go to bottom Favoured: 0
TOPIC: How to delete certain posts of a user
#57954
How to delete certain posts of a user 2 Months, 2 Weeks ago  
Hello,

I just want to know how can I delete certain spam posts done by a registered user. In this case, I don't want to ban him. I just want to select his spam posts (about 66% of his posts) and delete it with one single click.

Can I do this with Fireboard admin panel? If not, can u show me how to do it using MySQL?

Thanks in advance.
amiruddin86 (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#57984
Re:How to delete certain posts of a user 2 Months, 2 Weeks ago  
All you should have to do is log in to the forum from the frontend website (with moderator rights), click on the post and there should be a delete link.
evwhitaker (User)
Junior Boarder
Posts: 20
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#57988
Re:How to delete certain posts of a user 2 Months, 2 Weeks ago  
I know that. But that make me sick. Imagine you have 250 posts to delete, you still want to do it that way?

What I want is, a solution with one single click.
amiruddin86 (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#58011
Re:How to delete certain posts of a user 2 Months, 2 Weeks ago  
There is none. Administer your boards a little more frequently of assign a moderator.
grinchy (User)
Senior Boarder
Posts: 355
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
#58020
Re:How to delete certain posts of a user 2 Months, 2 Weeks ago  
If you have PHPmyAdmin, run this query:

SELECT *
FROM `jos_fb_messages`
WHERE userid =70

Assuming your prefix is 'jos' and '70' is the userid of the person you want to delete. It'll produce a table with all the correct rows. You could even change the 'SELECT' to 'DELETE' if you wanted. The only problem with doing it this way is that there would then be orphaned entries in the jos_fb_messages_text.
miss_kagura (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Logged Logged
 
The administrator has disabled public write access.  
Go to top