There's still someone that using this resource?
I need help with paperdoll view, they're completely naked.
Except for that, everything is working.

I'm running the latest client
 
I need to use the latest client (7.0.9016)
Using the uopaperdoll code from Voxpire, I got this error, as non wearable

Initializing Database...
Done!
Initializing Character...
Query Database: SELECT * FROM myrunuo_characters WHERE char_id='208392'
Done!
Initializing Mul files...
Done!
Removing Guild Strings...
Done!
Setting Body Index...
Index: 12 * Female: 0
Done!
Setting BodyHue...
BodyHue: * Gump: 1
Done!
Set Dimesions: W:266 H:285
Initializing Items...
Query Database: SELECT * FROM myrunuo_characters_layers WHERE char_id='208392' ORDER BY layer_id
Found Item - Parsing...
Item ID: 5399 * Layer: 0 * Hue: 857
Found Item - Parsing...
Item ID: 5905 * Layer: 1 * Hue: 0
Found Item - Parsing...
Item ID: 5431 * Layer: 2 * Hue: 263
Found Item - Parsing...
Item ID: 5435 * Layer: 3 * Hue: 1726
Found Item - Parsing...
Item ID: 7939 * Layer: 4 * Hue: 1254
Found Item - Parsing...
Item ID: 5907 * Layer: 5 * Hue: 1714
Insert Items into Variables...
Index-> 12,5399,5905,5431,5435,7939,5907
Female-> 0,0,0,0,0,0,0
Gump-> 1,0,0,0,0,0,0
Hue-> ,857,0,263,1726,1254,1714
Done!
Building The Gump...
Verifying Mul Files:
TileData: Resource id #4
Hues: Resource id #3
Gump: Resource id #5
Gump Index: Resource id #6
Done!
Parsing Values...
Done!
Parsing Each Item...
Index: 12 * Female: 0 * Hue: 0 * Gump: 1
Load The Raw Gump...
Get Value From GumpIndex: returned ...
Get Value From GumpIndex: returned ...
Get Value From GumpIndex: returned ...
Index: 5399 * Female: 0 * Hue: 857 * Gump: 0
Get Value From TileData: returned ...
Flags Say NOT WEARABLE, move to next Item...
Index: 5905 * Female: 0 * Hue: 0 * Gump: 0
Get Value From TileData: returned ...
Flags Say NOT WEARABLE, move to next Item...
Index: 5431 * Female: 0 * Hue: 263 * Gump: 0
Get Value From TileData: returned ...
Flags Say NOT WEARABLE, move to next Item...
Index: 5435 * Female: 0 * Hue: 1726 * Gump: 0
Get Value From TileData: returned ...
Flags Say NOT WEARABLE, move to next Item...
Index: 7939 * Female: 0 * Hue: 1254 * Gump: 0
Get Value From TileData: returned ...
Flags Say NOT WEARABLE, move to next Item...
Index: 5907 * Female: 0 * Hue: 1714 * Gump: 0
Get Value From TileData: returned ...
Flags Say NOT WEARABLE, move to next Item...
 
Heya guys,

I see a few people went as far as myself. I'm trying to fix the Paperdoll issue and then I'll gather information and documentate so I can find a way to publish an updated version of MyRunUO. A good start to look at is this GitHub: GitHub - tbsampson/MyRunUO: Website and server scripts to display character, guild, and shard information for ServUO Ultima Online server
The link may have been shared before, or even be from the same person that posted this ServUO Resource.
In any case, thanks a lot for your work ! Years pass and code often get deprecated. No worries :)

Watch out though, a lot of the code is depreciated PHP wise. I see some people encouranted hosting issues, e.g. not being able to remote host their MySQL Databases. Some requirements here : either you host both ServUO and your MySQL Database (with a PHP webserver) on the same machine, and do it all local. Either you have to find a host that will let you create a MySQL Database and give you remote access to it. PHPMyAdmin helps too checking things are done correctly.

Personnally, I use Windows Server 2019 and IIS and added MySQL Workbench (and PHP in ISS). All in one toolkit may have given me less trouble to get it working.


1640343224795.png


EDIT: updates on what to modify.

So far, here are a few things I have found.

How to fix MyRunUO Paperdoll.php

1. Rewrite font paths in every file using it (make_logo.php, razor_setup.php and paperdoll.php) :
$font_path = 'fonts/Calibri.ttf';

to
$font_path = dirname(__FILE__) . "/fonts/Calibri.ttf";

2. On Windows Servers, PHP enabled through IIS, using PHP8
in php.ini, changed
extension=php_gd2.dll
to
extension=php_gd.dll

3. Using PHP versions 7.4 and above, change this in config.php
Find fuction "check_get" and remove reference to magic_quotes_gpc. It has been deprecated from PHP 7.4.
Change $magic = get_magic_quotes_gpc();
to
$magic = 0;


I'm looking now in the SQL files and results in my database (MySQL as recommended). There should be a problem there, because everything seems to work on the web server. No more errors in the logs. Just the "Gump" not being displayed.

I also have some converted UOP files that I could test to replace those old MULs. I was working on updating Pandora. It may work also. I'll let you know guys ! Just, even without the Paperdoll, it's a very cool system :)


EDIT2: another catch here. Paperdoll generation seems to be blocked about old hues.mul files provided. And especially, they don't match our current surver colors in game, at least, no on my shard.

1640557377033.png

Still, I could display this by using the hues.mul file that were provided. They are from 2009. Mines are from 2018. Still, there are many other things that could make things go wrong. But I could display the gump eventually.

Here's the last PHP fix I did :
in paperdoll.php
Code:
function add_gump($read, &$img)
{
  if (strpos($read, "ERROR"))
    return;

  $data = explode("DATASTART:\n", $read);
  $data = $data[1];
  $newdata = explode("***", $data);
  foreach($newdata as $key => $val) {
    if ($val == "DATAEND!")
      break;
    $val = explode(":", $val);
    $x = intval($val[0]) + 65;
    $y = intval($val[1]) + 65;
    $r = intval($val[2]);
    $g = intval($val[3]);
    $b = intval($val[4]);
    $length = intval($val[5]); // pixel color repeat length
  
    //fix for an error where red component was out of range
    if($r > 255) { $r = 255; }
    if($g > 255) { $g = 255; }
    if($b > 255) { $b = 255; }
    if($r < 0) { $r = 0; }
    if($g < 0) { $g = 0; }
    if($b < 0) { $b = 0; }
  
    if ($r || $g || $b) {
      $col = imagecolorallocate($img, $r, $g, $b);
      for ($i = 0; $i < $length; $i++)
        imagesetpixel($img, $x+$i, $y, $col);
    }
  }
}

The values for red colors, variable $r, were above 255. Capping them to 255 makes the paperdoll being drawned, but this is probably why everything is red. I'll look later for a better fix. Hope this helps a little :)

EDIT3: Last part of the paperdoll adventure lol

2 things I changed again and now it works fine for me.
First one: Remove "each" in the code and replace it with "foreach". each is deprecated, it still works, but it throws warnings. It will probably be removed from future PHP versions. Btw, the edits here work with PHP 7.4 and PHP 8.0. I'm runnin mine with PHP 7.4 as I don't really need PHP in an IIS environment.

in paperdoll.php,
change this :
Code:
  while (list($key, $val) = @each($newdata)) {
    if ($val == "DATAEND!")
      break;
    $val = explode(":", $val);

to this:
Code:
  foreach($newdata as $key => $val) {
    if ($val == "DATAEND!")
      break;
    $val = explode(":", $val);

And the 2nd thing is about colors and hues. This is a pure trial and error solution. I didn't get a thing of what I was doing, but paperdoll displays fine on my website, so I'm ok with that.

in paperdoll.php
chnage this :
Code:
// Check if we're applying a special hue (skin hues), if so, apply only to grays
        if (($orighue > 0x8000) && ($r == $g && $r == $b)) {
          $newr = (($color32[$r] >> 10))*8;
          $newg = (($color32[$r] >> 5) & 0x1F)*8;
          $newb = ($color32[$r] & 0x1F)*8;
        }
        else if ($orighue > 0x8000) {
          $newr = $r * 8;
          $newg = $g * 8;
          $newb = $b * 8;
        }
        else {
          $newr = (($color32[$r] >> 10))*8;
          $newg = (($color32[$r] >> 5) & 0x1F)*8;
          $newb = ($color32[$r] & 0x1F)*8;
        }

to this:
Code:
// Check if we're applying a special hue (skin hues), if so, apply only to grays
        if (($orighue > 0x8000) && ($r == $g && $r == $b)) {
          $newr = $r * 8;
          $newg = $g * 8;
          $newb = $b * 8;          
        }
        else if ($orighue > 0x8000) {
          $newr = $r * 8;
          $newg = $g * 8;
          $newb = $b * 8;
        }
        else {
          $newr = $r * 8;
          $newg = $g * 8;
          $newb = $b * 8;          
        }

I left the three parts and the IF conditions for the flag and check if it's a body hue. I'm not sure why it used to be decoded twice to RGB. I remember it worked that way, but now I noticed the body color was ok on my former version of paperdoll, but not the wearable items. So I removed the part about decoding RGB (it's actually already done earlier in the code), and just left the *8.

Sidenote, and it's probably the last step before being able to release an updated version of this resource : it only works with the provided MUL files. They are from 2009 and probably don't work with newer items and tiledata and hues. I tried a converted UOP set of MUL files from 2016, but the characters stayed naked. So there's still plenty of work on this to get it working with newer clients.
I'm giving up on this though. This is way beyon my skill level and I'm already happy my players can check who's online, click on their name and see (some of) their items displayed on a website :)

Once again, thanks A LOT to the original poster. I know what it is to pulblish a resource and not being able to update it years later ;)
We're a community and the job done by Ixtabay, Voxpire and many others who contributed in updating how to display a paperdoll (and all the other useful pieces of information from in game of course), is priceles. Thanks everyone !
 
Last edited:
Strangely, I tried it on a Debian 11 Linux server with LAMP and it didn’t work. :/
It’s probably linked to a missing PHP extension.
I have no issues with my IIS PHP 8.0 config though. I will try to compare with the Linux config and see what is different
 
Hey Guys, I'm back after a loooong absence. I've updated MyRunUO to work with the most recent ServUO, PHP 7.4+, MySQL 8.0 odbc. It still uses the old MUL files, so hue values are out of whack, etc. I'll paste an updated version soon, along with some notes on how to get it working. Also, I want to update it further to use the new UOP (or converted MULS) for newer character wearables and hues. If you have any insight on how to display gumps from the newer files, I would appreciate any help. This was a fun project that I would love to bring back.
Repo has been updated with a working version of MyRunUO: GitHub - tbsampson/MyRunUO: Website and server scripts to display character, guild, and shard information for ServUO Ultima Online server
 
Last edited:
Now that the old version is working again, I want to focus on a new version that will read the new files. Since I have no idea how to read the UOP file directly from PHP, I guess the best place to start is my converting the UOP file.

This is the latest conversion I found:
Releases · cbnolok/LegacyMULConverter-N

Can anyone confirm that this this tool works properly?

Looks pretty straight forward...
Code:
C:\LegacyMULConverter>LegacyMULCL-N.exe

LegacyMULConverter version N-2.2.
Syntax:
  -x <path>  Extracts known UOP files in <path> into MUL format.
  <path>     Packs known MUL files in <path> into UOP format.

I copied artLegacyMUL.uop from an updated EA Ultima Online client to a directory containing conversion tool and converted artLegacyMUL.uop into two files:
Code:
C:\LegacyMULConverter>LegacyMULCL-N.exe -x .
LegacyMULConverter version N-2.2.
Mode: Extract from UOP.

Extracting '.\artLegacyMUL.uop'... done.

All actions completed successfully.

The output was two files: art.mul and artidx.mul
The names of these two files differ slightly from the old versions: gumpart.mul and gumpidx.mul, but seem to be the right files

Along with these two converted files, I copied also from the recently patched EA Ultima Online directory: hues.mul and tiledata.mul

I've searched all over the web for clues on how to read these new files. This is what I've found:

The new UOP file format

MyRunUO ... displaying Paperdolls correctly

Updated paperdoll.php

GitHub - Vita-Nex/UOPaperdoll: Web-based generation of the in-game Paperdoll in Ultima Online.

GitHub - ppardalj/ultima-paperdoll-drawer-php: Library to generate paperdoll images for Ultima Online characters


Getting the paperdoll.php working with the new files (converted or native uop) is key to making a great new MyRunUO.

If you have the skill to fix paperdoll.php so that it will read the new files, I would love you hear from you! Otherwise, I would like to hear about anyone else experiences with recent artLegacyMUL.uop, hues.mul, and tiledata.mul.

Thanks!
 
Last edited:
Thanks a lot for all your work ! You did an amazing job already ! Congratz

I haven't been able to use UOP or converted UOP with paperdoll.php. I fear this is beyond my skills. The results are okay for my small playerbase, so I went back to managing my shard.
But take a look, if you want, a lot of items are working already : https://webstatus.uowhitewolf.com
However, new items, even when the most recent UOP files are converted to MUL, don't display well, or don't display at all. There may be a sort of 'gap' in the number, or how the items are converted. Not sure !
 
Hey i saw this and want to use it
i followed the steps
but im stuck on this error
im on Windows 10 pro , Xampp
site works fine only that it wont let me connect to the DB
i got password , SQL added to heidisql
0ef1a105f6ebc1121feff4dcd102679f.png
 
Have you installed MySQL ODBC connectors ?
I have installed both x86 and x64 on my server, but I'm not sure both are needed. Neither which version to use. I use 5.1.13.
Try this link ? MySQL :: Download MySQL Connector/ODBC (Archived Versions)
You may also need to enter the same name and description for the ODBC connector, both in the config script (C#) and inside the ODBC application. I think that's how the magic happens and the link is done.
 
the MySQL Connector/ODBC 8 installer says * a new version of this product is already installed* i checked both same thing


forgot to add - ODBC application
i need to open the ODBC program and add from there?
i done it once in File DSN for a other server
but i didnt see any on the guide for this one here.



update -
well error from console is gone after i changed this
$mulpath = "MUL_FILES/"; // Edit path of .mul files: gumpart.mul gumpidx.mul hues.mul tiledata.mul

to

$mulpath = "MUL_FILES"; // Edit path of .mul files: gumpart.mul gumpidx.mul hues.mul tiledata.mul

removed the / behind the S

update2 - issue i have now is the Icon on front page of online players
and image of the player when u select them is gone i checked old posts and added / changed what i could find and no luck :(
 
Last edited:
hi guys i need your help
I've been suffering for a couple of days and broke my brain ..
via http protocol opens the site, everything works except paperdoll, but when I try to open the site via https, nothing works there
I use ngnix ,php,mysql crt from cloudflare
please help me solve this problem
what configs to provide?


the problem is solved, I will leave a link to the manual that helped me, maybe it will come in handy for someone


hi guys again)
i have one more problems on my mysql 8+
syntacs error
im understent what , myrunuo.sql writen on mysql 5.6.17
but i cant find new format syntacs... maybe who know solution

this line SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; on myrunuo.sql
sql-mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION" on my.ini

System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.28]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.2022)' at line 1
? System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
? System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
? System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
? System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
? Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start()
 
Last edited:
Now that the old version is working again, I want to focus on a new version that will read the new files. Since I have no idea how to read the UOP file directly from PHP, I guess the best place to start is my converting the UOP file.

This is the latest conversion I found:
Releases · cbnolok/LegacyMULConverter-N

Can anyone confirm that this this tool works properly?

Looks pretty straight forward...
Code:
C:\LegacyMULConverter>LegacyMULCL-N.exe

LegacyMULConverter version N-2.2.
Syntax:
  -x <path>  Extracts known UOP files in <path> into MUL format.
  <path>     Packs known MUL files in <path> into UOP format.

I copied artLegacyMUL.uop from an updated EA Ultima Online client to a directory containing conversion tool and converted artLegacyMUL.uop into two files:
Code:
C:\LegacyMULConverter>LegacyMULCL-N.exe -x .
LegacyMULConverter version N-2.2.
Mode: Extract from UOP.

Extracting '.\artLegacyMUL.uop'... done.

All actions completed successfully.

The output was two files: art.mul and artidx.mul
The names of these two files differ slightly from the old versions: gumpart.mul and gumpidx.mul, but seem to be the right files

Along with these two converted files, I copied also from the recently patched EA Ultima Online directory: hues.mul and tiledata.mul

I've searched all over the web for clues on how to read these new files. This is what I've found:

The new UOP file format

MyRunUO ... displaying Paperdolls correctly

Updated paperdoll.php

GitHub - Vita-Nex/UOPaperdoll: Web-based generation of the in-game Paperdoll in Ultima Online.

GitHub - ppardalj/ultima-paperdoll-drawer-php: Library to generate paperdoll images for Ultima Online characters


Getting the paperdoll.php working with the new files (converted or native uop) is key to making a great new MyRunUO.

If you have the skill to fix paperdoll.php so that it will read the new files, I would love you hear from you! Otherwise, I would like to hear about anyone else experiences with recent artLegacyMUL.uop, hues.mul, and tiledata.mul.

Thanks!

I've sent you a PM with one of my old projects that should be enough for you to understand how to read art.mul and artidx.mul. It is how I generated in-game images on-the-fly on a website by item ID and hue.
 
I've sent you a PM with one of my old projects that should be enough for you to understand how to read art.mul and artidx.mul. It is how I generated in-game images on-the-fly on a website by item ID and hue.

I'd love to see this too! Can you post it here or send me a copy?

Thanks,

HR
 
I'd love to see this too! Can you post it here or send me a copy?

Thanks,

HR

Sure, I'll post it temporarily publicly.

NOTICE: Please DO NOT use the code as-is for any public site. It almost certainly lacks input sanitation which could lead to your whole server getting hacked. This was used by a separate web app that was isolated so I was not at all concerned with the security of the script.

 
Last edited:
Thanks so much! I'm always interested in source code to learn from!

HR

Please do not use the code as-is for any public site. It almost certainly lacks input sanitation which could lead to your whole server getting hacked. This is also the reason I do not want it public for long but I will leave it up a bit longer for any other interested parties.
 
Please do not use the code as-is for any public site. It almost certainly lacks input sanitation which could lead to your whole server getting hacked. This is also the reason I do not want it public for long but I will leave it up a bit longer for any other interested parties.

Good to know, thanks! I've worked with MySql and PHP (although it has been a while) so I know there are some safeguards needed to prevent things like MySql injection hacks, etc. But I am mainly interested in the MUL reading part of the code. It's been so long since I last worked with PHP and sample code like this really helps bring some of it back for me. Thanks for sharing it!
 
Thanks for sharing !
A few years ago, there were some many cool websites that could show gear and items a player was carrying in game, a bit like you can see on LOTRO official realms/websites.

But indeed, the original version from Ixtabay works like a charm now. Thanks for fixing this. I can't wait to hear more about future web projects :)
 
Thanks for sharing !
A few years ago, there were some many cool websites that could show gear and items a player was carrying in game, a bit like you can see on LOTRO official realms/websites.

But indeed, the original version from Ixtabay works like a charm now. Thanks for fixing this. I can't wait to hear more about future web projects :)

Was the package actually updated to fix whatever issues it had? I haven't even tried it yet because I've been far too busy to play around with my dev server. TBH, I had forgotten I even had a server live until you just replied lol
 
Well, if you check one of the latest answers here from the original poster, around January 28th this year, you will find a link to a GitHub. This is where you can find a working version of MyRunUO with Paperdoll/web app, I think.
The version I use is working very nicely thanks to all the fixes from Ixtabay. There may be a few more recent items that don't display on the paperdoll, or one or two skill images that need a new JPG file, but it works well. I use Windows Server 2019 with IIS and PHP 8.1. I guess results can be different with a Linux and/or different PHP versions.
 
hello everybody, need help with configure
i have windows server 2016 & webhosting (all in different places server and website)
& can't understand need write ip adress website or domain name? (www.uopvp.pp.ua)
install to windows server mysql odbc driver 8.0 and config all scripts, but nothing is work :(


web config:
// Path
$base_ref="185.70.111.99"; // This is the root URL where your MyRunUO resides, minus the http://

// Shard Info - This will appear on your logo and also in the Razor setup image.
$shard_name="Asgard World";
$shard_addr="82.144.223.15"; // Your server name (ie. servuo.myhost.com)
$shard_port="2593"; // your server port

// Edit your database settings:
$SQLhost = "185.70.111.99";
$SQLport = "3306";
$SQLuser = "user";
$SQLpass = "password";
$SQLdb = "database";
$mulpath = "MUL_FILES/"; // Edit path of .mul files: gumpart.mul gumpidx.mul hues.mul tiledata.mul
$validhosts = ""; // Leave blank to allow any host to use your paperdoll generator.

runuo config:
using System;
using System.Text;
using System.Threading;

namespace Server.Engines.MyRunUO
{
public class Config
{
// Is MyRunUO enabled?
public static bool Enabled = true;

// Details required for database connection string
public static string DatabaseDriver = "{MySQL ODBC 8.0 Unicode Driver}";
public static string DatabaseServer = "185.70.111.99";
public static string DatabaseName = "database";
public static string DatabaseUserID = "user";
public static string DatabasePassword = "password";

// Should the database use transactions? This is recommended
public static bool UseTransactions = true;

// Use optimized table loading techniques? (LOAD DATA INFILE)
public static bool LoadDataInFile = true;

// This must be enabled if the database server is on a remote machine.
public static bool DatabaseNonLocal = ( DatabaseServer != "localhost" );

// Text encoding used
public static Encoding EncodingIO = Encoding.ASCII;

// Database communication is done in a seperate thread. This value is the 'priority' of that thread, or, how much CPU it will try to use
public static ThreadPriority DatabaseThreadPriority = ThreadPriority.BelowNormal;

// Any character with an AccessLevel equal to or higher than this will not be displayed
public static AccessLevel HiddenAccessLevel = AccessLevel.Counselor;

// Export character database every 30 minutes
public static TimeSpan CharacterUpdateInterval = TimeSpan.FromMinutes( 1.0 );

// Export online list database every 5 minutes
public static TimeSpan StatusUpdateInterval = TimeSpan.FromMinutes( 1.0 );

public static string CompileConnectionString()
{
string connectionString = String.Format( "DRIVER={0};SERVER={1};DATABASE={2};UID={3};PASSWORD={4};",
DatabaseDriver, DatabaseServer, DatabaseName, DatabaseUserID, DatabasePassword );

return connectionString;
}
}
}

here is runuo errors:

RunUO - [www.runuo.com] Version 2.0, Build 2710.12842
Core: Running on .NET Framework Version 2.0.50727
Core: Optimizing for 2 64-bit processors
Scripts: Compiling C# scripts...done (0 errors, 0 warnings)
Scripts: Compiling VB.NET scripts...no files found.
Scripts: Verifying...done (3420 items, 643 mobiles)
Regions: Loading...done
World: Loading...Warning: Duplicate region name 'Jail' for map 'Felucca'
done (529153 items, 41137 mobiles) (13.36 seconds)
Time System: Calculated managed lights list and found 1063 lights.
Time System: Loading complete.
Time System: The time is 10.51AM on Offle 8th in the year 101. The moon is waning two thirds.
Onsite: Loading Points [ ]100%
Onsite: Load Complete.
Xanthos.Utilities.ConfigParser attempting to load Data/ShrinkConfig.xml...
Xanthos.Utilities.ConfigParser failed.
Semolo Fully Automated Tournament System...Initialized
Address: 127.0.0.1:2593
Address: fe80::88e8:aac8:d324:a0e0%4:2593
Address: fe80::10ce:e8d:ad6f:20f0%5:2593
Address: 82.144.223.15:2593
Address: 2001:0:2851:782c:10ce:e8d:ad6f:20f0:2593
Jail System: Starting
Jail System: 0 jailed players loaded.
Client: 188.130.177.172: Connected. [1 Online]
Login: 188.130.177.172: Invalid password for 'Chill'
Client: 188.130.177.172: Disconnected. [0 Online]
Client: 188.130.177.172: Connected. [1 Online]
Warning: 25 bad spawns detected, logged: 'badspawn.log'
Client: 188.130.177.172: Connected. [2 Online]
Login: 188.130.177.172: Invalid password for 'Just'
Client: 188.130.177.172: Disconnected. [1 Online]
Cleanup: Detected 895 inaccessible items, including 3 bank boxes, removing..
Login: 188.130.177.172: Invalid password for 'Kill'
Client: 188.130.177.172: Disconnected. [0 Online]
MyRunUO: Updating character database
MyRunUO: Database statements compiled in 0.55 seconds
MyRunUO: Exception caught in database thread
System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.33-0ubuntu0.16.04.1]The used command is not allowed with this MySQL version
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at Server.Engines.MyRunUO.DatabaseCommandQueue.Thread_Start()
MyRunUO: Characeter database updated in 1.6 seconds
 
@andrewspxod666 I just set this up to play with it, let me know if you still need help.

Overall it's not bad, I would love to see support for the newer UOP files or at least their extracted MUL counterparts.
 
I did everything clearly according to the instructions, step by step, but still I get this:

21:37:43 MyRunUO: Exception caught in database thread
21:37:43 System.Data.Odbc.OdbcException (0x80131937): ERROR [HY000] [MySQL][ODBC 5.1 Driver][mysqld-8.0.34]The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
 
Last edited:
Back