Previous Thread
Next Thread
Print Thread
Hop To
Delete Users Post x Amount #247981 01/16/2012 10:38 AM
Joined: Jul 2006
Posts: 4,062
Mark S Offline OP
OP Offline
Joined: Jul 2006
Posts: 4,062
hi Guys,

I do not have the option to remove say the last 10 posts from a member who has had too much wine that evening with a keyboard on there lap wanting to put the world to rights.

So my question is thus.

Can i just delete Posts from Ubbt_POSTS in the database ?
If i run a SQL to list there posts i can clean up in no time, and not having to remove the whole topic.

I don't want to close a topic / i want to keep the flow. As i deal with the member in question in a private forum.

Thank you


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: Delete Users Post x Amount [Re: Mark S] #248046 01/18/2012 3:11 PM
Joined: Jul 2006
Posts: 4,062
Mark S Offline OP
OP Offline
Joined: Jul 2006
Posts: 4,062
Bump


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: Delete Users Post x Amount [Re: Mark S] #248051 01/18/2012 3:55 PM
Joined: Dec 2003
Posts: 5,998
Ruben Offline
Offline
Joined: Dec 2003
Posts: 5,998
Hey happy birfday!

It thought this could be done with prune or move in the control panel. But no.
So I guess the logical process would be to look at user posts via the profile method and edit them one at a time.
I would be leery of just editing the database since it impacts several tables when a user posts a topic or reply.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Re: Delete Users Post x Amount [Re: Mark S] #248071 01/19/2012 1:48 PM
Joined: Jul 2006
Posts: 4,062
Mark S Offline OP
OP Offline
Joined: Jul 2006
Posts: 4,062
Yeh that's the frustration, its clunky to delete say 10 posts and time consuming. Where its could be at the expense of a really interesting topic/thread.

I'm only now just realising the power of the SQL Querys to get the answers from my Boards.

List of all there IP's
Reading there last 20 posts via the database is also alot easier than having to open each thread / topic.

Would be handy to know for sure if there are any as you say impacts any other tables.


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo
Re: Delete Users Post x Amount [Re: Mark S] #248079 01/20/2012 9:37 AM
Joined: Aug 2006
Posts: 1,356
Yarp™ Offline
veteran
Offline
veteran
Joined: Aug 2006
Posts: 1,356
Use ubb to delete them, don't do delete queries. 10 is not a lot to do manually.


[Linked Image from siemons.org]
Re: Delete Users Post x Amount [Re: Mark S] #248082 01/20/2012 3:13 PM
Joined: Jul 2006
Posts: 4,062
Mark S Offline OP
OP Offline
Joined: Jul 2006
Posts: 4,062
cheers i got the answer "Dont do it that way."

I used 10 but in reality it can be more and its always more than one user, i will just have to weigh it up.

Wouldn't it be great to have in-line delete posts when viewing users posts.

Thanks for the reply Yarp


BOOM !! Version v7.6.1.1
People who inspire me Isaac ME Gizmo

Forum Search
ShoutChat Box
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Mobile app?
by Baldeagle - 12/06/2019 9:32 PM
How do you change Text Line spacing?
by jorb - 11/23/2019 12:14 AM
What happened to FAQ or Forum Help
by Ruben - 11/20/2019 11:58 AM
Search feature encountering an Error message
by jorb - 11/20/2019 12:06 AM
Followed List v7.7.2 Question
by Ruben - 11/12/2019 12:22 PM
Who's Online Now
1 registered members (may), 68 guests, and 432 spiders.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Amusing Terain Scenics
Amusing Terain Scenics
by isaac, August 19
Sky places
Sky places
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191023)