http://www.icyphoenix.com/viewtopic.php?f=35&t=7807&p=52542#p52542
-----------------------------------
mort
Wed 20 Apr, 2011 15:43

Re: Delete Pots From User Deleted
-----------------------------------
[quote user="Informpro" post="52531"]Imagine you delete the first post of a thread (because the author of the thread has been deleted). Could you guess what will happen ?[/quote]

You're right - It does remove the thread. :(

But! if anakin isn't worried about that, here's the string he will need to do it with.

[code linenumbers=false]DELETE FROM ip_posts WHERE post_username= "informpro" AND poster_id= -1;[/code]

Just change [b]informpro[/b] to whatever the user handle is.  :mryellow:

It's also important that the name be inside quotes. [b]"[/b]user name[b]"[/b] and NOT [b]`[/b]user name[b]`[/b]