Author Topic: [OEUO] Economy helper  (Read 17094 times)

0 Members and 1 Guest are viewing this topic.

Offline adalegTopic starter

  • Jr. Member
  • **
  • Posts: 10
  • Activity:
    0%
  • Reputation Power: 1
  • adaleg has no influence.
  • Respect: 0
  • Referrals: 0
    • View Profile
[OEUO] Economy helper
« on: October 30, 2014, 05:24:21 PM »
0
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

Offline Crome969

  • Elite
  • *
  • *
  • Posts: 2098
  • Activity:
    0%
  • Reputation Power: 25
  • Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.
  • Gender: Male
  • UO Enthusiast
  • Respect: +211
  • Referrals: 10
    • View Profile
    • ScriptSDK
Re: [OEUO] Economy helper
« Reply #1 on: October 31, 2014, 02:24:22 AM »
0
Show us how it works, i guess many people would be interested in...

Offline adalegTopic starter

  • Jr. Member
  • **
  • Posts: 10
  • Activity:
    0%
  • Reputation Power: 1
  • adaleg has no influence.
  • Respect: 0
  • Referrals: 0
    • View Profile
Re: [OEUO] Economy helper
« Reply #2 on: October 31, 2014, 03:51:49 AM »
0
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
« Last Edit: November 05, 2014, 01:53:17 PM by adaleg »

Offline Endless Night

  • Global Moderator
  • *
  • *
  • Posts: 5467
  • Activity:
    0%
  • Reputation Power: 62
  • Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!Endless Night is awe-inspiring!
  • Respect: +393
  • Referrals: 1
    • View Profile
Re: [OEUO] Economy helper
« Reply #3 on: November 03, 2014, 09:06:33 AM »
0
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.
« Last Edit: November 03, 2014, 09:08:43 AM by Endless Night »
Outlaw Josey Wales - "Manwink, A Long Gone Scripty, and Endless are always teasing us with their private sections lol. What there realy saying is scripters rule and users drool."
Briza - "Your a living breathing vortex of usefulness."

Offline adalegTopic starter

  • Jr. Member
  • **
  • Posts: 10
  • Activity:
    0%
  • Reputation Power: 1
  • adaleg has no influence.
  • Respect: 0
  • Referrals: 0
    • View Profile
Re: [OEUO] Economy helper
« Reply #4 on: November 04, 2014, 07:37:50 PM »
0
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

Offline Crome969

  • Elite
  • *
  • *
  • Posts: 2098
  • Activity:
    0%
  • Reputation Power: 25
  • Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.Crome969 is on the verge of being accepted.
  • Gender: Male
  • UO Enthusiast
  • Respect: +211
  • Referrals: 10
    • View Profile
    • ScriptSDK
Re: [OEUO] Economy helper
« Reply #5 on: November 05, 2014, 12:08:12 AM »
0
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 :-)

Offline adalegTopic starter

  • Jr. Member
  • **
  • Posts: 10
  • Activity:
    0%
  • Reputation Power: 1
  • adaleg has no influence.
  • Respect: 0
  • Referrals: 0
    • View Profile
Re: [OEUO] Economy helper
« Reply #6 on: November 05, 2014, 01:47:58 PM »
0
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!

There are 1 attachment(s) in this post. You must register and post an acceptable introduction to download
vendor_scan.zip
« Last Edit: November 05, 2014, 01:53:32 PM by adaleg »

Tags: