cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
1668
Views
5
Helpful
3
Replies
j.house
Enthusiast

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

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?

3 REPLIES 3
salih.dogan
Beginner

Did you find how to delete rooms?

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!

thanks. i will try.

Create
Recognize Your Peers
Content for Community-Ad