Resource icon
- Thread starter Ixtabay
- Start date
larhalt82
Member
Yes, all the MUL files
Tharmine
Member
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.
EDIT: updates on what to modify.
So far, here are a few things I have found.
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.
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
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 :
to this:
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 :
to this:
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 !
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.
EDIT: updates on what to modify.
So far, here are a few things I have found.
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.
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:
Thank you so much,now trying to install this system!!!up (for those who didn't read my edits and who would want to give it a shot. good luck
OP
Ixtabay
Member
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
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:
OP
Ixtabay
Member
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...
I copied artLegacyMUL.uop from an updated EA Ultima Online client to a directory containing conversion tool and converted artLegacyMUL.uop into two files:
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!
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:
Tharmine
Member
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 !
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
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
Tharmine
Member
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.
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
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:
loveslips
Member
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
www.setup.pp.ua
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
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
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
Установка и настройка nginx + php под Windows
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
Last edited:
detox
Member
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.
detox
Member
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.
Dropbox
www.dropbox.com
Last edited:
Thanks so much! I'm always interested in source code to learn from!
HR
detox
Member
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!
Tharmine
Member
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
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
detox
Member
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
Tharmine
Member
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.
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.
andrewspxod666
Initiate
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:
runuo config:
here is runuo errors:
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:
runuo config:
here is runuo errors:
@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.
Overall it's not bad, I would love to see support for the newer UOP files or at least their extracted MUL counterparts.
