Post: #1

Hello everyone, first of all this is my first topic and i want to start with some cool stuff..

So, lets go.

Im scripting a integration between shard and website... its a socket connection trough PHP and sphere, with an account and start execute any sphere command by PHP.

Ok it's ready and it's working!

But now, i decided to make a web-papperdoll to my shard and there is where my problem begins...

I used a php code that i send 2 fields on $_GET (ids,hues) to the file and the papperdoll is printed on the website using the .mul's files of UO.
(It's a very old code, but still working)

Usage exemple: (12 is the male gump id of papperdol, and 33770 is the HUE color)
<img src="papperdoll.php?index=12&hue=33770" />

Ok, i 've made a script to sphere that in all world save, a mySQL table will be updated with the online player papperdolls itens, so i created a table to store de "player uid", "item id", "hue", "description".

[FUNCTION update_papperdoll]
db.connect
db.query "delete from <def.db_players> where uid = '<uid>'"

for x 1 24
if (<findlayer.<local.x>.id> != 0)
db.query "insert into players (uid, id, hue, description) values ('<uid>', '<findlayer.<local.x>.id>', '<findlayer.<local.x>.color>', '<findlayer.<local.x>.name>')"
endif
endfor

It's wrong, i need to get the relative gump id of the item to store on the DB cuz if i get the <findlayer.<local.x>.id> of a plate mail i'll get "01415" but i need the gump id "5141"...

Someone understand the problem? sorry about my poor english!

Many Thanks!

Post: #2

I've found some good information on this link!


http://uo.stratics.com/heptazane/fileformats.shtml#1.0


I still trying!

thx

Post: #3

use '<eval <findlayer.<local.x>.id>>' instead of '<findlayer.<local.x>.id>'

Post: #4

Thanks for help!!!!


It works!!!

here is the first picture taken from my system

Written in PHP, using .mul files from my shard.


As u can see, it works with HUES custom colors and custom gumps


Thanks!

---

ANother one.... now with other gump

---

Now added transparency to the background! (the red background is the HTML background)

Post: #5

very nice

Post: #6

Thanks Darksun84!!!!