Modified UOx3 [Mysql integration, some fixes}

Want to contribute to the Ultima Offline eXperiment? Submit your JS/DFN/Code fixes and/or other UOX3 improvements here!
Post Reply
User avatar
thedepthofman
UOX3 Newbie
Posts: 13
Joined: Sat Jun 21, 2014 5:39 am
Has thanked: 0
Been thanked: 0

Modified UOx3 [Mysql integration, some fixes}

Post by thedepthofman »

Image

I modified uox3 to use with mysql. Accounts, characters, items, guilds, houses, baseobjects, regions, jail, banned, spawn_items, time etc. are now being loaded from SQL instead of some folders, so world load time of uox3 decreased by %60, backup size decreased by %57 etc. Default UOX3 Worldfiles v0.16 (https://www.uox3.org/downloads.shtml) is also converted and inserted into mysql database.

Because of the original save system of uox3, it deletes all the data which is not supposed to, and it increases saving time. We must change it, so save time shortens so much that even players cannot be aware of it.

It's stable at the moment and can be used by anyone. You can download it from https://github.com/Kitiara/UOX3

I have also added CMAKE configurations, so you can create build files using CMAKE. I used VS2010 to build, but did not try the other versions of VStudio. If you want to develop it, send me a message from Github so I can add you as a contributor.
User avatar
Xuri
Site Admin
Posts: 3704
Joined: Mon Jun 02, 2003 9:11 am
Location: Norway
Has thanked: 48 times
Been thanked: 8 times
Contact:

Post by Xuri »

Good stuff :)
-= Ho Eyo He Hum =-
stranf
UOX3 Guru
Posts: 939
Joined: Wed Jan 04, 2006 3:59 pm
Has thanked: 0
Been thanked: 0

Post by stranf »

I might have to give this a shot. My world file is getting quite large..

Is it hard to convert to SQL?
Post Reply