Search results

  1. Redoing the save/load system to use a real database.

    I'm bored again so I'm working on redoing this but with mysql or mariadb so it will work in linux using mono and the latest pull from the git to keep it up to date. So far the only thing I got working now is just connecting to the db and creating tables. I'm thinking of doing something where it...
  2. Configurable save locations

    Ramdisk could be faster. It would be better to just use code to buffer the save in memory instead using multithreading. I have tried this on my server and saves are 10x faster from what I can tell. You can check it out at 192.151.158.220.
  3. Configurable save locations

    You could probably do this pretty easily although I figure it would be easier to just stick the whole servuo folder on the fastest drive as it doesn't take up much space to begin with. Putting the index files on another disk won't help much because I believe the index just holds constructor...
  4. Redoing the save/load system to use a real database.

    Well what you are describing can pretty much be done now. Each item is saved to its own row in the items table along with the base attributes. If say one item is corrupt you can just delete the row, along with any references to that item and the game will load. I have actually tested this out...
  5. UltimaXNA: How Do We Install It...??

    No web client! Comon now thats just negative thinking! its the cool ideas that keep devs motivated but you are right we have to see if we can get just a normal client working first. The problem with ultimaXNA is Zane I think is a full time student so he's no were close to a professional c#...
  6. UltimaXNA: How Do We Install It...??

    Lots of ideas, can have the client read the current .mul and .uop files as well as possibly a better file format so the client could use shaders and stuff to enhance things like water or spells with effects. Here is one example . I think a web based html5 client would be badass too then I...
  7. could someone recommend a remote host

    Not bad, they typically respond within a minute although I have occasionally ran into stuff like the setup originally was wrong and it took them a couple tries to get it running but so far not bad.
  8. UltimaXNA: How Do We Install It...??

    I found someone had forked ultimaxna and made it compatible with .uop files. I compiled it and ran it and it did show lots of the newer content. The client though still needs more work to it because it doesnt have any code to handle functional stuff above ML. Also crashes easily. This stuff...
  9. could someone recommend a remote host

    I got a dedicated host at nocix.net its an i7 7700k 4.2 ghz which is intel's latest kaby lake CPU and 32gb of ddr4 ram and 2 ssd drives on a gigabit connection for $80 a mo. Its not real server hardware but the thing is ridiculous fast.
  10. Using a Mondain's Legacy Client.?

    Ah yes, those instructions refer to runuo. I think there is a way to do it for servuo as well. It might even be automatic at this point if you just point your server to the ML client. Give that a try and see what happens.
  11. Using a Mondain's Legacy Client.?

    Yup, according to this link you need to edit two files in the script folder: Getting RunUO to work with ML-era data files: You may use any installation of RunUO; however, you will need to make changes to the scripts files to ensure that you are running on a Pre-*.UOP file set. The following...
  12. Using a Mondain's Legacy Client.?

    You will run into things where the client does not have assets for things that were made for later clients. Unless you run it on a server that is running only up to the ML client. For instance you might be in a town according to the server version but in the ML client you will be in a forest...
  13. Redoing the save/load system to use a real database.

    Thought I would make a post since its been a year lol. I'm just getting back into this because I want to work on my c# skills some more. Anyway I wanted to test my code on a linux server and I can get it to compile and run in mono but getting it connect to a mssql db from there is tricky. Plus...
  14. Smooth Movement for Characters/Mounts

    It would be cool to have a sort of open source MMORP engine made in unity or whatever, with everything done from scratch to include custom shaders and stuff to make UO look like a more modern/better diablo3. Granted this would take a ton of skill time and effort, I'm still working on the...
  15. Redoing the save/load system to use a real database.

    Yeah, that is kind of the idea behind EAV tables its basically a table that will contain either mobile serial or item serial plus a column for an attribute (well I'll probably have 2 columns for it) and a column for the value of the attribute. So say for example, I have a gargish documents book...
  16. Redoing the save/load system to use a real database.

    I fixed the null reference item bug, well sort of, the code just removes the null items I don't know why they are being loaded up as null yet though but I have done some testing and there is very few that end up being removed and I believe its a normal part of the cleanup process. But the server...
  17. Redoing the save/load system to use a real database.

    Sorry for lack of updates, I've been lazy and debuging this code is hard and I gave up for a bit lol. Anyways, I've been researching how other MMO's do persistance and it seems that relational databases arent the best because games tend to have a lot of hierarchical data. Although a lot still...
  18. Redoing the save/load system to use a real database.

    I added dynamic database creation, so if a db doesn't exist it auto creates it with the appropriate tables and column mappings. It should be fairly easy to setup a new shard all you need to do is have a local sql database server and make sure servuo has permissions to it and off you go. I will...
  19. Redoing the save/load system to use a real database.

    OK, so I finished coding the custom savedata save/load. I have set up a test server at 52.3.247.37 if anyone wants to log in and test it out. If it crashes I can check the logs and try to fix bugs. Eventually I'll get around to making a SQL script to create the db and some console commands to...
  20. Redoing the save/load system to use a real database.

    When I initially started this project I was looking at NoSQL solutions like object oriented database and other databases like cassandra but ended up deciding against it for several reasons. Mainly because I was a SQL DBA and that is what I am familiar with but also it would make things like...
Back