Inventory Database App - db admins please read

[Yumstain 0]

http://www.pathofexile.com/forum/view-thread/499892

^^ this works well, and pulls the inventory data to a sqlite3 database.

Simple query outputs this

:

Armourer's Scrap 29/40

Armourer's Scrap 22/40

Blacksmith's Whetstone 11/20

Blacksmith's Whetstone 9/20

Chaos Orb 2/10

Chaos Orb 2/10

Chromatic Orb 6/20

Chromatic Orb 4/20

Gemcutter's Prism 1/20

Glassblower's Bauble 4/20

Glassblower's Bauble 2/20

Being the front-end developer I am, I could use a bit of help with the php/sql part. E.g. I'd like to remove the "/20" from the stacks, so they can be calculated for totals. Also, the source at the link above could use a little work. It could be streamlined to only view character inventory items. User account sessions vs the current hard coded poe credentials, etc. Basically stripping it down / cleanup for our cause.

If someone will work with me on this back-end stuff, here is what I plan to do.

Build out the user interface using jqueryui

Integrate notifications for big item drops

charting / graphs

Theme all item/orb items with images

Android / iOS unofficial release (apk/app)

PM me if you'd like to get involved.

-cheers

[okostibi 0]

I believe this only queries items that are on the character:

http://www.pathofexile.com/character-wi ... r=charname

[alkpone 1000000]

Very nice job!! Are you thinking about some implementation with the bot ?

[Yumstain 0]

Hey Boss,

I'm not sure how exactly this could integrate, but if I can get this thing working well we will certainly talk. The issue with integrating this with the bot is that, when the bot is running, you can't really interrupt it. Also, this tool will support multiple bots, making it difficult to integrate into the GUI, which supports 1 bot.

Not sure yet, but I'm guessing this will be a web-hosted application. My approach will use the link above (thanks okostibi), and attempt to parse the feed appropriately to a database, then render it out nicely. I'm open to the idea of handing this off when complete, to be hosted at exiled-bot.

The link above (okostibi) returns JSON - GREAT!

[okostibi 0]

You could still monitor several accounts, and in the gui filter it by account name, that way you could just send an sms or email, when a particular item dropped(you know, to save it before it gets banned or whatever). Everything that poe site returns is json I believe.

You need to make your own parser, to only pull the data that you care about, and store it in a real database(sqlite is not my favorite).

If you need help with that, give me a pm

[alkpone 1000000]

Hey Boss,

I'm not sure how exactly this could integrate, but if I can get this thing working well we will certainly talk. The issue with integrating this with the bot is that, when the bot is running, you can't really interrupt it. Also, this tool will support multiple bots, making it difficult to integrate into the GUI, which supports 1 bot.

Not sure yet, but I'm guessing this will be a web-hosted application. My approach will use the link above (thanks okostibi), and attempt to parse the feed appropriately to a database, then render it out nicely. I'm open to the idea of handing this off when complete, to be hosted at exiled-bot.

The link above (okostibi) returns JSON - GREAT!

Okay, no problem for hosting it on exiled-bot once it's ready.

BTW I'm sure we'll find plenty of way to interface your work and the bot in the future!!