This is a Mysql Addon for uMMORPG 1.98
This is pretty much a drop in replacement for the sqlite Database.cs that comes with uMMORPG.
There are a few enhancement I made in this addon not present in the sqlite version:
- Primary keys and indexes. This can greatly improve performance when you have lots of users
- Native mysql types such as boolean and Datetime, no awkard conversions
- Foreign keys, make it really easy to do maintenance on your database and ensure data integrity
- utf8, character names in any language
To install follow these instructions:
- Backup, you have been warned
- Install mysql
- Create a database and ensure you can connect to it from your server
- export these environment variables before running unity or your server:
MYSQL_HOST=<your database server>
MYSQL_DATABASE=<your database name>
MYSQL_USER=<user name to connect to your database>
MYSQL_PASSWORD=<password to connect to your database>
MYSQL_PORT=<port to your database, typically 3306>`
- Run Unity and open your project
- Delete Database.cs that comes with uMMORPG
- add these files to your project
- Hit play and enjoy
- When you build a server, make sure to export those environment variables too
Note, many addons add their own tables and columns.
They will need to be modified to work with mysql.
That is out of my control, it is entirely up to you to update the addons.
If you don’t want to use environment variables, change where these fields are coming from in the method ConnectionString near the top. I use environment variables because I deploy my server in docker containers.
This is provided as is, no guaranty, I am not responsible if it offers your first born child in sacrifice to the devil.
I am simply offering it for free for anyone who might want it.