Jabber for Win Chat Rooms...how to delete unwanted rooms

[j.house]

When users create a chat room I get that they have the ability to delete the room.  What if an admin wants to clean up old rooms and/or innapropriate rooms?  how can rooms be deleted by someone other than the creator?

[salih.dogan]

Did you find how to delete rooms?

[j.house]

Yes, after much trial and error I found the correct syntax.  first you must run the following query to make sure you get the correct results for the rooms you want to remove:

SELECT *

FROM

tc_rooms

WHERE

Room_jid LIKE ('%roomname%')

Once you confirm the results you can perform the following to remove them.

DELETE

FROM

tc_rooms

WHERE

Room_jid LIKE ('%roomname%')

Hope this will save some people the grief that I went through!

[salih.dogan]

thanks. i will try.