Back in the OC days I had written a small app that restored important files shared by some specific 'admin' on the users accounts. I was getting the info that a user unshared a file shared by that admin by querying the database and checking some status or permissions field.
Since, the database scheme has changed and that app doesn't work. Moreover I cannot find the fields that would provide the 'unshared' info in the new DB. Even worse, it seems like the 'post_unshare' event does not fire when a recipient unshares a file from his account. That I could verify from the admin audit as well.. Only if the owner unshares the file, then the event is recorder through the admin_audit.
Is there any way to know from within the database that a file has been unshared? Is there a way to catch that with a hook?