SMF Support > SMF 1.1.x Support

How to delete all the messages of one member

<< < (4/4)

JimM:

--- Quote from: Illori on April 04, 2011, 12:07:21 PM ---in the future please do not bump old topics you are best to create a new one for your issue

--- End quote ---

Illori, in this case Spyd was adding a solution and not opening an additional issue.  It's quite ok for members to add solutions to older topics because the more solutions we have the better we all are.

estecb:
You people are forgetting to remove the topics as well. Otherwise, weird things will happend within your forums...



--- Code: ---DELETE FROM smf_messages WHERE ID_MEMBER = <id>;
--- End code ---


--- Code: ---DELETE FROM smf_topics WHERE ID_MEMBER_STARTED = <id>;
--- End code ---


So if you want to remove all topics and msg from the user id 100, you should do:


--- Code: ---DELETE FROM smf_messages WHERE ID_MEMBER = 100;
DELETE FROM smf_topics WHERE ID_MEMBER_STARTED = 100;
--- End code ---

Navigation

[0] Message Index

[*] Previous page