Hope I didn't light any fires... I was in turbo mode and not paying attention. To apply this fix for those who upgraded, download the ZIP from the github repo and copy the mission file over.
If you have modified the mission file, you will need to merge the changes HERE
I have reports from my players (still at work here) that all of the new "custom" buildings added by overwatch are now gone. Anyone else experiencing this?
the change takes place only in the player_login.sqf file in the @hive directory. So long as you have the proper schema in your DB it should be fine. The trick is moving the code snippet to the proper place in that file.
I did this previously with mixed results. Had issues with the trigger and restoring.
Also had another trigger to backup all house inventory changes into another table to restore from there with an interface (admin clicks restore button on inventory after querying player's name). The queries...
FYI, here is the trigger I use to block "bad" house updates. Don't blame me if it breaks your custom Stored Procs or scripts. It should work without issue for the vanilla package.
Change the definer to a user with permissions on the table.
DELIMITER $$
DROP TRIGGER IF EXISTS...
this fix works... ok. I find I still need a trigger to block updates in the DB and even with both of these when the server crashes it can wipe inventories.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.