Quaternion rotation

[amaru]

Some time ago (~year) SilverIce introduced a revision where gameobject rotation became handled as quaternions, as a result many objects were found rotated around some axis prior to their previous position.

What can be done and is there any general solution to this?

[amaru]

As for transports there is gameobject_addon table that fixes everything, but there are a lot of other custom objects that became rotated

[Schmoozerd]

well, the problem is, that many GOs had bad dataz in the rotation fields before (however they were unused)

a good solution was an UPDATE statement, that took the old angle and converted this to (proper) quaternion rotation. this statement can be found on github, in the comments related to one of the quaternion commit. (by zergtmn)

However the big databases udb and ytdb have updated their values in large since quite some time, so in an updated database there shouldn't be problems remaining.