ScriptUO
Scripting Resources & Utilities => OEUO => OpenEUO Scripts => Topic started by: adaleg on October 30, 2014, 05:24:21 PM
-
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
-
Show us how it works, i guess many people would be interested in...
-
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
-
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.
-
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
-
Maybe use Code Tags for future :
Code here :-)
Or add it as Attachment, so only granted users (non restricted) could take a copy :-)
-
-------------------------------------------
-- 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!