Resource icon

MyRunUO for ServUO 1

No permission to download

Ixtabay

Well-Known Member
Mar 30, 2015
65
13
Spring, TX USA
Ixtabay submitted a new resource:

MyRunUO for ServUO - Website and server scripts to display character, guild, and shard information for ServUO Ultima Onli

This is a complete drop in website to replace the old MyRunUO.

Scripts are included and have been updated for ServUO. Please read the installation instructions included.

  • Status checker on home page that shows whether or not your shard is online, and how many players, etc.
  • Automatically creates help page and logo based on your shard information (edit config file)
  • No coding necessary
  • All source included, psd, sql, .cs, .php
  • All images included
Go easy, it's...
Read more about this resource...
 
  • Like
Reactions: Izex and cmileto

Tasanar

Moderator
ServUO Developer
Oct 16, 2014
4,490
114
32
trueuo.com
Shard Name
Heritage
Donate
Donate money to this user
This looks awesome!!!

could we possible get an "install guide"?

How should I go about adding this to my website?
 

Visam

Well-Known Member
Mar 19, 2015
197
15
46
I was about to say... This looks awsome lol...

There is a guide included
How to setup MyRunUO.docx
 

Ixtabay

Well-Known Member
Mar 30, 2015
65
13
Spring, TX USA
This looks awesome!!!

could we possible get an "install guide"?

How should I go about adding this to my website?
Install guide is on github with the rest of the files
[doublepost=1482975498][/doublepost]
This looks awesome!!!

could we possible get an "install guide"?

How should I go about adding this to my website?
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.
 

Milva

Admin
Moderator
Mar 3, 2013
4,200
479
Donate
Donate money to this user
)This is really great!! Thanks for sharing with the community :)
 

cmileto

Well-Known Member
Nov 18, 2013
191
15
Kingwood, West Virginia
neverybody.org
Shard Name
Neverybody (test shard pls ignore)
Donate
Donate money to this user
Im having trouble getting this to work under mono on debian 8
Server runs fine but database and website not working....

Mono limitation?
I get this in terminal everytime script tries to connect to database:

Code:
[email protected]:~/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.
 

Ixtabay

Well-Known Member
Mar 30, 2015
65
13
Spring, TX USA
You know, I have always had issues with mono and ODBC on linux. Here is a MySQL version of MyRunUO scripts for mono:

https://github.com/tbsampson/MyRunUO_MySQL

Installing .NET MySQL Connector
create a working directory (i.e. mysql)
Code:
mkdir mysql
cd mysql
Download the connector
Code:
wget https://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-6.9.9-noinstall.zip
unzip mysql-connector-net-6.9.9-noinstall.zip
Now add the 4.0 libs
Code:
cd v4.0
sudo gacutil /i /package 4.0 MySql.Data.dll
You should see:
Package exported to: /opt/local/lib/mono/4.0/MySql.Data.dll -> ../gac/MySql.Data/6.8.3.0__c5687fc88969c44d/MySql.Data.dll
Installed MySql.Data.dll into the gac (/opt/local/lib/mono/gac)

Now the 4.5 libs
Code:
cd ../v4.5
sudo gacutil /i /package 4.5 MySql.Data.dll
Package exported to: /opt/local/lib/mono/4.5/MySql.Data.dll -> ../gac/MySql.Data/6.8.3.0__c5687fc88969c44d/MySql.Data.dll
Installed MySql.Data.dll into the gac (/opt/local/lib/mono/gac)

verify
Code:
gacutil -l|grep MySql
MySql.Data, Version=6.9.9.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d

Copy the MySql.Data.dll file to your server root folder (change path accordingly)
Code:
cp /opt/local/lib/mono/4.5/MySql.Data.dll /home/servuo/ServUO/
To use these in any of your ServUO scripts, you need to update the Makefile
Code:
nano Makefile
Change this:
REFS=System.Drawing.dll

To this:
REFS=System.Drawing.dll,System.Data.dll,MySql.Data.dll

This save
Add this to your scripts to use:
Code:
using MySql.Data;
using MySql.Data.MySqlClient;
If you are getting errors about MySql assembly reference, you may need to update your machine.config files
Code:
/etc/mono/4.0/machine.config
/etc/mono/4.5/machine.config
Edit these files, search for <system.data> and add this inside <DbProviderFactories>
Code:
            <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" />
Update your /Data/Assemblies.cfg file and add Myql.Data.dll

Code:
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.dll
 

Ixtabay

Well-Known Member
Mar 30, 2015
65
13
Spring, TX USA
So everything is working great except paperdolls for characters show as a broken link. Not sure what I have done wrong. Am using your mono mysql version on debian 8
Check the path of the mul files and make sure it matches exactly (with proper case). Also chmod 755 the mulfiles directory.
 

cmileto

Well-Known Member
Nov 18, 2013
191
15
Kingwood, West Virginia
neverybody.org
Shard Name
Neverybody (test shard pls ignore)
Donate
Donate money to this user
For what its worth it now works. The problem was I didnt have a trailing slash on the MUL path.... ie
works
$mulpath = "/home/admin/web/neverybody.org/public_html/MUL_FILES/";

does not work
$mulpath = "/home/admin/web/neverybody.org/public_html/MUL_FILES";

Hope this can help someone else in same position. Love this package.
 
Last edited:

Aschnyder26

Well-Known Member
Jul 6, 2016
257
18
Atlanta, GA
www.kalvasflam.org
Shard Name
Kal Vas Flam
First off I love this work you have done thank you so much. I am having a sudden problem with the "online" status updating to the website/database. It was working fine for days and then I went to check and it says offline but the server is running. The database IS updating character info and stats to the website so I know it is talking with my server AND I am getting a ping from the website that seems to be checking the status. I reinstalled everything from scratch a few times now and still same result. Everything is talking but the online status. Any ideas?
online.png