Inventory management

hi everybody,

first of all, let me say thank you for this amazing website!
i yust wanted to ask if someone of you had ever planed, started (or finished

) to create some kind of inventory management system (web based) for guild-houses etc.
currently we are maintainig our guild-house inventory in one big excel file - but this is more than complex (because not every member is able to take a quick look/search at/through the list, it's quite complicated to generate the same ordering as in the IG inventory to quickly find differences or add/remove items from the list etc.)
how do you guys manage your guild-house inventory? is anybody else interested in developing (maybe someone with more knowledge in developing web applications then me

) or using such a software?

thanks for listening
Dyma

dyma wrote:i yust wanted to ask if someone of you had ever planed, started (or finished ) to create some kind of inventory management system (web based) for guild-houses etc.

gimme a few days...

sure

i would love to help but i'm very into renovating my new (and old :/) home, so have very less time. what is your exact plan (if you already have one and want to talk about it yet). are there any points where/we i could help you?

This message was edited 4 times. Last update was at 13/08/2008 22:35:18

here it is. because it is kind of 'secret' how much bling users have, i have included the sources and everything else whats needed, (hopefully hehe)
so that guilds/alliances can host their own.

(for now) 'online' version is at http://ballisticmystix.net/inventory/

it's butt-ugly, but functional.

edit: added more up to date item id/names databases (also removed not needed lines) and french/german names.
even tho french/german names are drop in replacement to database, php source only supports english names (land/grade stuff)

wow, i'm impressed!
thanks for your work and time!
i will set this up asap to let my guildmates test. thank you so much!

feedback is going to come as soon as i/we got time to test.

This message was edited 3 times. Last update was at 15/08/2008 10:19:52

Okay, first tests done and the feedback from the guild mates is quite good! they'r realy happy about that nifty dump-import thing.

I implementet some new filters (as a drop-down) and fixed the "mat only" (hide) filter because some items (in my case it was an autolauncher, an amp and one staff) do have rm_class_type=4 and rm_faber_stat_type=2. If you whish i could create a patch (its a little work to remove the german translations so i have not done this yet).
Here my new/fixed filters (direct c&p). Im not 100% shure about the sheet id ranges but it works for me atm (no, i dont realy think my guild has all available mats and items in inventory

):

dyma wrote:If you whish i could create a patch (its a little work to remove the german translations so i have not done this yet).

no need. i came up a better solution yesterday

now i have one big filter based english names from item_words table.
filter creates new table that maps sheet_id (number) to correct item data (bitfield) and bulk (which is missing from dump)
it's 'run once' filter, so showing results is lot easyer (and supports any language)

trying to finish and clean up the inv code in the weekends.

man, you'r quite fast and your plan sounds good.
but, where do you get those bulk values from?

a guild mate searched some ryzom files but could'nt find them (i don't searched them myself because i was not at home and don't have any ryzom data here...).

dyma wrote:man, you'r quite fast and your plan sounds good.
but, where do you get those bulk values from? a guild mate searched some ryzom files but could'nt find them (i don't searched them myself because i was not at home and don't have any ryzom data here...).

i'm guessing from item name

something like 'if name=flower bulk=1 else if name=expcrystal bulk=0.01'.

Ah, okay. This was also my approach.

Great work Karu!!!

This message was edited 1 time. Last update was at 20/08/2008 02:01:06

well.. it's not name based filter. it started as one, but ended up being item_id based

there is probably lot that it misses, but it should get most of it right.

also added bag/room/packer inventory importer. needs it's own 'guild' that is marked 'personal'. read access can be given to other ppl.

upgrade from v0.1 is by importing upgrade.sql and then everyting else except bmsite_inv.sql (that one wipes users/inventories)

ohh yeah, make sure you sit down when check the total bulk

Great, thanks. I'm going to sit down upgrade right now

This message was edited 1 time. Last update was at 21/08/2008 18:04:47

There is a small bug in the regexp that removes unneccessary stuff from names. currently it dosn't match on fine and basic mats.

is:

should be (imho):

dyma wrote:There is a small bug in the regexp that removes unneccessary stuff from names. currently it dosn't match on fine and basic mats.

should be (imho):
"/^". "(?:(bundle|fragment|handful|phial|portion|tuft) of\s+){0,1}". "(?:(basic|fine|choice|excellent|supreme)\s+)". "(?:(forest|desert|jungle|lake|prime root)\s+){0,1}". "(.*)/i"

i believe you right

, i have so little basic/fine mats, so i didnt notice it