Since the SteamID update i had to resolve to Arma2Net and redo all server_publish, and server_swapObject functions with it...in order to save the playerUID in the CharacterID cell instead of the characterID one. Why ? cause the hiveext.dll doesnt support bigint(24) values for CharacterID.
Anyways...I've been rewriting the server_swapObject.sqf and i noticed something REALLY WEIRD.
although there is a proper mysql entry in arma2net log, it DOESNT get executed (or it does but epoch deletes the entry...i cant figure this out) and instead just the 1st object in the database gets deleted (as it should be since its deleting it and then creates and publishes the upgraded object).
No matter what i do, no matter how i tweak the SQL query, i cant get a 100% successful result.
Sometimes it upgrades the object and writes it in the db and sometimes it doesnt.
IF the object doesnt have a lock, then it will 90% work. If it does then i get about 50% chance the sql will get executed (like i said, not sure if it gets deleted by epoch after insertion....no logs no nadda).
That had the same problem....and he was also pointing to the same file....
Also i say that Plot for Life people experience the same difficulties ( i dont have that mod ).
Whats going on here ? Anyone knows ?
To test this i build a CinderWallDoor_DZ and change it to a CinderWallDoorLocked_DZ with a Lock....upgrading / downgrading it all the time and checking the db and logs to catch the error.
Is epoch (like server_monitor or something else) checking/deleting stuff and not post anything in the logs ?
Or simple for some FREAKING WEIRD reason arma2net is not getting executed ?
Question
Sandbird
Since the SteamID update i had to resolve to Arma2Net and redo all server_publish, and server_swapObject functions with it...in order to save the playerUID in the CharacterID cell instead of the characterID one. Why ? cause the hiveext.dll doesnt support bigint(24) values for CharacterID.
Anyways...I've been rewriting the server_swapObject.sqf and i noticed something REALLY WEIRD.
My hivewrite:
While the sql in the server_publishObject.sqf works fine:
The same SQL in server_swapObject.sqf,
although there is a proper mysql entry in arma2net log, it DOESNT get executed (or it does but epoch deletes the entry...i cant figure this out) and instead just the 1st object in the database gets deleted (as it should be since its deleting it and then creates and publishes the upgraded object).
No matter what i do, no matter how i tweak the SQL query, i cant get a 100% successful result.
Sometimes it upgrades the object and writes it in the db and sometimes it doesnt.
IF the object doesnt have a lock, then it will 90% work. If it does then i get about 50% chance the sql will get executed (like i said, not sure if it gets deleted by epoch after insertion....no logs no nadda).
I found a guy here: http://forums.dayzgame.com/index.php?/topic/163482-issue-with-door-locks-on-my-server/
That had the same problem....and he was also pointing to the same file....
Also i say that Plot for Life people experience the same difficulties ( i dont have that mod ).
Whats going on here ? Anyone knows ?
To test this i build a CinderWallDoor_DZ and change it to a CinderWallDoorLocked_DZ with a Lock....upgrading / downgrading it all the time and checking the db and logs to catch the error.
Is epoch (like server_monitor or something else) checking/deleting stuff and not post anything in the logs ?
Or simple for some FREAKING WEIRD reason arma2net is not getting executed ?
In the logs all looks fine :
but the object does not exist in the db....and if i manually execute this SQL it inserts fine.
ps: Same thing for downgrading objects.
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now