04-02-2015 12:34 PM - edited 03-19-2019 09:25 AM
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?
11-07-2016 06:42 AM
Did you find how to delete rooms?
11-07-2016 06:48 AM
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!
11-09-2016 05:08 AM
thanks. i will try.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: