Wise Chat deletes all media!

Hi,

I have a customer who used wise chat. He ran into some problems. Occasionally all mediafiles vanished, you cant find them in the filesystem nor in the database!

It is triggered by:
POST /wp-admin/admin-ajax.php?action=wise_chat_delete_message_endpoint

I checked it now several times, deleteing any kind of message from wise chats, deletes also ALL media images!

Please fix this!

Thank you!

https://wordpress.org/plugins/wise-chat/

EDIT:
I checked your code and I think you have some serious problems generating a good query to get those connected attachement.

I deleted a message written by me, it was just a “test”, with debugging enabled, I got this:

View post on imgur.com

getAttachmentsByMessageIds() needs to be rewritten – thats what my first thought was! Take a look at “OR mt1.post_id IS NULL”. So basically we have:
(SELECT something based on the metavalue OR post_id=NULL) AND (file is of any kind)

If you have any questions: https://www.damianschwyrz.de, just hit me!