Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (JAISP, isaac), 67 guests, and 320 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 518
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 14
FREAK 11
M4TT 9
mmkk 5
Ruben 4
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Delete Users Post x Amount #247981
01/16/12 10:38 AM
01/16/12 10:38 AM
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
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


Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Delete Users Post x Amount [Re: Mark S] #248046
01/18/12 03:11 PM
01/18/12 03:11 PM
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Bump


Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting
Re: Delete Users Post x Amount [Re: Mark S] #248051
01/18/12 03:55 PM
01/18/12 03:55 PM
Joined: Dec 2003
Posts: 5,823
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,823
Lutz,FL
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/12 01:48 PM
01/19/12 01:48 PM
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
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.


Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting
Re: Delete Users Post x Amount [Re: Mark S] #248079
01/20/12 09:37 AM
01/20/12 09:37 AM
Joined: Aug 2006
Posts: 1,530
Breda, NL
Yarp™ Offline
veteran
Yarp™  Offline
veteran
Joined: Aug 2006
Posts: 1,530
Breda, NL
Use ubb to delete them, don't do delete queries. 10 is not a lot to do manually.


[Linked Image]
Re: Delete Users Post x Amount [Re: Mark S] #248082
01/20/12 03:13 PM
01/20/12 03:13 PM
Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
Mark S Offline OP
Mark S  Offline OP

Joined: Jul 2006
Posts: 4,704
Liverpool : England : UK
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


Version v7.5.8
People who inspire me Gizmo ID242 SD
Its been a long road. . . .to be waiting

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,530
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)