Install guide is on github with the rest of the files
If you want, I can help you. You have a busy shard with many players and guilds, so it would help me further test and improve MyRunUO.
servuo@brains:~/neverybody$ make
`pwd`/ServUO.sh
--------------------------------------------------------------------------------
ServUO - [http://www.servuo.com] Version 0.5, Build 6209.34204
Publish 54
Core: Optimizing for 4 64-bit processors
Core: Unix environment detected
RandomImpl: SimpleRandom (Software)
Core: Loading config...
Scripts: Compiling C# scripts...done (cached)
Scripts: Skipping VB.NET Scripts...done (use -vb to enable)
Scripts: Verifying...
Finished (5279 items, 1218 mobiles, 7 customs) (0.44 seconds)
Regions: Loading...done
World: Loading...
Loading Ultima Live map changes
...done (5537 items, 893 mobiles, 2 customs) (0.72 seconds)
Restricting client version to 7.0.55.4. Action to be taken: LenientKick
09:51:06 Joeku's Staff Runebook: Loading...
09:51:06 Listening: 127.0.0.1:2593
09:51:06 Listening: 127.0.0.2:2593
09:51:06 Listening: 192.210.231.7:2593
09:51:06 ----------------------------------------------------------------------
09:51:18 MyRunUO: Updating character database
09:51:19 MyRunUO: Exception caught in database thread
09:51:19 System.EntryPointNotFoundException: LocalAlloc
at (wrapper managed-to-native) System.Data.Common.SafeNativeMethods:LocalAlloc (int,intptr)
at System.Data.ProviderBase.DbBuffer..ctor (System.Int32 initialSize, System.Boolean zeroBuffer) [0x0003b] in <a566c189d19d4271ab58420d6f875b13>:0
at System.Data.ProviderBase.DbBuffer..ctor (System.Int32 initialSize) [0x00000] in <a566c189d19d4271ab58420d6f875b13>:0
at System.Data.Odbc.CNativeBuffer..ctor (System.Int32 initialSize) [0x00000] in <a566c189d19d4271ab58420d6f875b13>:0
at System.Data.Odbc.OdbcCommand.GetStatementHandle () [0x00039] in <a566c189d19d4271ab58420d6f875b13>:0
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject (System.Data.CommandBehavior behavior, System.String method, System.Boolean needReader, System.Object[] methodArguments, System.Data.Odbc.ODBC32+SQL_API odbcApiMethod) [0x0001c] in <a566c189d19d4271ab58420d6f875b13>:0
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject (System.Data.CommandBehavior behavior, System.String method, System.Boolean needReader) [0x00022] in <a566c189d19d4271ab58420d6f875b13>:0
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery () [0x0000a] in <a566c189d19d4271ab58420d6f875b13>:0
at Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start () [0x001f4] in <b1ef9578942a43d8a130af22335cfac8>:0
09:51:19 MyRunUO: Database statements compiled in 0.40 seconds
09:51:19 MyRunUO: Characeter database updated in 0.2 seconds
shutdown
09:51:25 Core: Using dual save strategy
09:51:25 World: Saving...
09:51:25 Closing Save Files.
09:51:25 Save finished in 0.11 seconds.mkdir mysql
cd mysqlwget https://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-6.9.9-noinstall.zip
unzip mysql-connector-net-6.9.9-noinstall.zipcd v4.0
sudo gacutil /i /package 4.0 MySql.Data.dllcd ../v4.5
sudo gacutil /i /package 4.5 MySql.Data.dllgacutil -l|grep MySqlcp /opt/local/lib/mono/4.5/MySql.Data.dll /home/servuo/ServUO/nano Makefileusing MySql.Data;
using MySql.Data.MySqlClient;/etc/mono/4.0/machine.config
/etc/mono/4.5/machine.config <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
description=".Net Framework Data Provider for MySQL"
type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />System.dll
System.Core.dll
System.Data.dll
System.Data.DataSetExtensions.dll
System.Drawing.dll
System.Web.dll
System.Windows.Forms.dll
System.Xml.dll
System.Xml.Linq.dll
MySql.Data.dll
Microsoft.CSharp.dll
Ultima.dllCheck the path of the mul files and make sure it matches exactly (with proper case). Also chmod 755 the mulfiles directory.
this.ExecuteNonQuery("LOAD DATA {0}INFILE '{1}' INTO TABLE myrunuo_characters FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'", Config.DatabaseNonLocal ? "LOCAL " : "", this.m_MobilesPath);
this.ExecuteNonQuery("LOAD DATA {0}INFILE '{1}' INTO TABLE myrunuo_characters_skills FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'", Config.DatabaseNonLocal ? "LOCAL " : "", this.m_SkillsPath);
this.ExecuteNonQuery("LOAD DATA {0}INFILE '{1}' INTO TABLE myrunuo_characters_layers FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'", Config.DatabaseNonLocal ? "LOCAL " : "", this.m_LayersPath);this.ExecuteNonQuery("LOAD DATA {0}INFILE '{1}' INTO TABLE myrunuo_characters FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'", Config.DatabaseNonLocal ? "" : "LOCAL ", this.m_MobilesPath);
this.ExecuteNonQuery("LOAD DATA {0}INFILE '{1}' INTO TABLE myrunuo_characters_skills FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'", Config.DatabaseNonLocal ? "" : "LOCAL ", this.m_SkillsPath);
this.ExecuteNonQuery("LOAD DATA {0}INFILE '{1}' INTO TABLE myrunuo_characters_layers FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'", Config.DatabaseNonLocal ? "" : "LOCAL ", this.m_LayersPath);
Can you help with mine lol I have it on a dedicate server machine with My Shard server...I got the database built and the tables loaded But i cant find the files in my server to replace thats in the myruno up scripts driector in the folder you download to do this with My server is also Servuo
The MyRunUO files you want to replace are in /Scripts/Services. Make sure you edit your database info in the PHP scripts. If you're on Linux, make sure you install the right ODBC connector. Once you're up and running watch the console for the message that it is updating the database and look for connection errors there. Sometimes Linux ODBC connections can be a pain. If you're on Windows it's a little easier. Also watch your permissions on config.php so no one can see your DB info (I'm sure you know this already). If you need any more help feel free to pm me or ask here. I'm running Debian 9 and it's a charm. The website he created is great, I'll be making changes to make it unique but will make sure credits are on the site. It's great to have paperdolls back, and the guild/player info is very nice. It also outputs some helpful text files in your root ServUO.
so is there a way to edit the install method of this service using this instead?
You bet
