xoops forums

schwob

Just popping in
Posted on: 2004/1/16 8:14
schwob
schwob (Show more)
Just popping in
Posts: 20
Since: 2003/2/11
#1

how to delete all postings of a specific user ?

hi,
I would like to delete all postings of a specific user who is abusing my forum. I'm currently running XOOPS 2.0.5.
I hope it could be done by just running a smart SQL command like "delete ... from ... where user = ..." but I have no idea about the details. Is it enough to delete records from just one table or do I have to touch multiple tables ? Will the remaining thread structure "survive" such an operation ?
many thanks.

lykoszine

Module Developer
Posted on: 2004/1/16 9:30
lykoszine
lykoszine (Show more)
Module Developer
Posts: 244
Since: 2002/1/2 2
#2

Re: how to delete all postings of a specific user ?

Does deleteing the user not work?

schwob

Just popping in
Posted on: 2004/1/16 9:38
schwob
schwob (Show more)
Just popping in
Posts: 20
Since: 2003/2/11
#3

Re: how to delete all postings of a specific user ?

would this delete all his postings, too ?!
of course this would be perfect ... didn't even think of this ...

schwob

Just popping in
Posted on: 2004/1/16 9:45
schwob
schwob (Show more)
Just popping in
Posts: 20
Since: 2003/2/11
#4

Re: how to delete all postings of a specific user ?

before I try: would this delete only this user's postings ? or would all subsequent replies be deleted, too ?

lykoszine

Module Developer
Posted on: 2004/1/16 10:22
lykoszine
lykoszine (Show more)
Module Developer
Posts: 244
Since: 2002/1/2 2
#5

Re: how to delete all postings of a specific user ?

Sorry mate, I was out of line on this one. That will not work, it just makes the posts from "Annon"