1
schwob
how to delete all postings of a specific user ?
  • 2004/1/16 8:14

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


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.

2
lykoszine
Re: how to delete all postings of a specific user ?
  • 2004/1/16 9:30

  • lykoszine

  • Module Developer

  • Posts: 244

  • Since: 2002/1/2 2


Does deleteing the user not work?


3
schwob
Re: how to delete all postings of a specific user ?
  • 2004/1/16 9:38

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


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

4
schwob
Re: how to delete all postings of a specific user ?
  • 2004/1/16 9:45

  • schwob

  • Just popping in

  • Posts: 20

  • Since: 2003/2/11


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

5
lykoszine
Re: how to delete all postings of a specific user ?
  • 2004/1/16 10:22

  • lykoszine

  • Module Developer

  • Posts: 244

  • Since: 2002/1/2 2


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

Login

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Sep 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!