[OEUO] Economy helper

[adaleg]

Hi All,

I've created a simple (but very useful) script to help me on economy stuff.
All it does is, as you select a player's vendor, it will catalogue all items on its inventory and save it to a local file.
After that, I import this file to a local db (on my case, I use SQL Express, but you can use anything), and run some selects to find best price or to decide how to price the items I want to sell.
You can also query objects by property (i.e select items that has DI > 30 ordered by lowest price).
The import to db and selects are manually atm because I'm the only one using but if more ppl interested, I'm happy to automate and create a UI.

If you are interested, send me a pvt message and I can send you the script and help to use..

Cheers

[Crome969]

Show us how it works, i guess many people would be interested in...

[adaleg]

This is the script, but it requires two libraries!

/* edit: script package below */

and this is a sample of what it logs:
-----------------------
item name: A Legendary Scroll Of Peacemaking (120 Skill)
vendor coords: 1068,509,-66
properties:
Cursed

Weight: 1 Stone

Price: 500,000
-----------------------
item name: A Legendary Scroll Of Necromancy (120 Skill)
vendor coords: 1068,509,-66
properties:
Cursed

Weight: 1 Stone

Price: 500,000
-----------------------
item name: A Legendary Scroll Of Peacemaking (120 Skill)
vendor coords: 1068,509,-66
properties:
Cursed

Weight: 1 Stone

Price: 500,000
-----------------------
item name: A Legendary Scroll Of Animal Lore (120 Skill)
vendor coords: 1068,509,-66
properties:
Cursed

Weight: 1 Stone

Price: 750,000

Load on OEU, click loop, click start and go check some vendors...
As I mentioned, the import to DB is not automated yet, I use SQL Express, Management Studio and some SQL Scripts to import it!

Cheers

[Endless Night]

nice I once wrote a similar such tool.    But these days out of pure laziness i just use searchuo or similar with no shard selected and choose a middle price point from the results..

One thing I always meant to do was make it auto buy certain items if the price point was xx% below median price and then place the stuff on my vendor.  I am pretty certain theses a few robots like that wandering around.

[adaleg]

Yeah...good one!
That shouldn't be hard to implement...
maybe set a configuration list with item/max price.
I'll take a look on that...
thx

[Crome969]

Maybe use Code Tags for future :

Code: [Select]

Code here :-)

Or add it as Attachment, so only granted users (non restricted) could take a copy :-)

[adaleg]

Code: [Select]

-------------------------------------------
-- Load script and press the play btn.
-- Walk around opening vendor containers
-- All priced items will be logged to OEU with its properties and vendor location x,y,z
-- Use UOCartographer to find the vendor later.
-------------------------------------------

Yeah, you're right mate, thanks!
I've enclosed the script with it's libraries and added a small header with instructions.

Thx!