search

paulpach / ummorpg_mysql

Mysql driver for uMMORPG
MIT License
40 stars 18 forks source link

Nice Work #7

Open Subere23 opened 6 years ago

Subere23 commented 6 years ago

I just wanted to say that I decided to give uMMORPG a try for some of the Mixed Reality experiences I am working on. I had a real big issue with using sqlite though. In just a few hours, I was able to get this in and working on a Windows VM and using Azure Database for MySQL.

Thanks for the great work.

Subere23 commented 6 years ago

Well let me add, it was great until I tried to compile to Universal Windows Platform. While I am working on a multiplatform application, my initial target is HoloLens and Windows Mixed Reality which all fall into the UWP realm. Any suggestions on getting this solution to work in the context?

Subere23 commented 6 years ago

If it helps this is a screenshot of the errors I get when I try to compile it. I have tried a number of different version of mysql.data.dll but nothing seems to work.

screenshot 33

Subere23 commented 6 years ago

It took over a week, but I found a solution. Part of it was a bug on Unity's end which was fixed in the 2017.2.2p2 build that just came out.

Due to the fact that I have made so many changes, to files and setting etc, it would have made recreation unpredictable, so I started a fresh project this weekend. Reimported uMMORPG and the Mysql_Addon then added the HoloLens/Windows Mixed Reality toolkit.

And while it took me a while of trying things to get it going it turns out that all the files that were supplied will work with UWP. With 2 added steps.

Copy the Mono.Data.TDS.DLL file from "C:\Program Files\Unity\Hub\Editor\2017.2.2p2\Editor\Data\Mono\lib\mono\2.0" and put it in the "Asset/Plugins" directory.

Build the Project using the compile configuration of Scripting Runtime Version = Stable (.Net 3.5 Equiv) Scripting Backend = IL2CPP API Compatibility level = .Net 4.6

screenshot 47

This setup should allow a UWP user to complete a build in Unity.

With UWP applications you take the build that Unity produces and then compile and deploy from Visual Studio. Before doing that, take the sqlite3.dll file from the "Asset/uMMORPG/Plugins/sqlite_x86/" directory and copy it to the "{Build Directory}/{Project Name sub folder}/"

Just so it's clear, as seen below, my build directory is "OpenUWP" so "OpenUWP/0PenDoorways/" is the folder to drop sqlite3.dll screenshot 49

paulpach commented 6 years ago

thank you for figuring this out.