http://forum.ballisticmystix.net/jforum/posts/list/6.page JForum - http://www.jforum.net
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]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2443.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2443.page GMT ) to create some kind of inventory management system (web based) for guild-houses etc.[/quote]gimme a few days...

]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2445.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2445.page GMT

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?]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2446.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2446.page GMT 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)]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2447.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2447.page GMT 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.]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2448.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2448.page GMT 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 :)):

[code]
// ** mats filter
if ($invfilter=='mats') {
// added weight=0 here because some items do have rm_class_type=4 and rm_faber_stat_type=2, but all mats have weight set to 0
$itemFilter=' AND g.sheet NOT IN (0, 8546094) AND rm_class_type=4 AND rm_faber_stat_type=2 AND weight=0';
// ** OP-Mat filter
} elseif ($invfilter=='opmats') {
$itemFilter=' AND g.sheet BETWEEN 8601000 AND 8605000';
// ** cat filter
} elseif ($invfilter=='cats') {
$itemFilter=' AND g.sheet = 8546094';
// ** tool filter
} elseif ($invfilter=='tools') {
$itemFilter=' AND g.sheet BETWEEN 8608046 AND 8612000';
// ** flower filter
} elseif ($invfilter=='flowers') {
$itemFilter=' AND w.name LIKE "%flower%"';
// ** item filter
} elseif ($invfilter=='items') {
$itemFilter=' AND rm_class_type!=4 OR (weight!=0 AND rm_class_type=4)';
}
[/code]]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2451.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2451.page GMT 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.
]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2452.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2452.page GMT 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...).]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2453.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2453.page GMT 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...).[/quote]i'm guessing from item name
something like 'if name=flower bulk=1 else if name=expcrystal bulk=0.01'.

]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2454.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2454.page GMT ]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2455.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2455.page GMT http://forum.ballisticmystix.net/jforum/posts/preList/522/2456.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2456.page GMT
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 ]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2458.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2458.page GMT ]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2459.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2459.page GMT
is:
[code]
"/^".
"(?:(bundle|fragment|handful|phial|portion|tuft) of\s+){0,1}".
"(?:(basic|fine|choice|excellent|supreme)\s+)".
"(?:(forest|desert|jungle|lake|prime root)\s+)".
"(.*)/i"
[/code]

should be (imho):
[code]
"/^".
"(?:(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"
[/code]]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2460.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2460.page GMT
should be (imho):
[code]
"/^".
"(?:(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"
[/code][/quote]i believe you right ;-), i have so little basic/fine mats, so i didnt notice it]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2461.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2461.page GMT
maybe i'm wrong (i'm not really into what you are doint there (:)) and how the identification of items/mats work), but there is no TYPE_ITEM_JEWEL_BRACELET. lib/admin_sheetid_filter.php (from line 88 ) shows:
[code]
$jewelTypes=array(
'a' => TYPE_ITEM_JEWEL_ANKLET,
'b' => TYPE_ITEM_JEWEL_ANKLET,
'd' => TYPE_ITEM_JEWEL_DIADEM,
'e' => TYPE_ITEM_JEWEL_EARRING,
'p' => TYPE_ITEM_JEWEL_PENDANT,
'r' => TYPE_ITEM_JEWEL_RING,
);
[/code]

i think line 3 should be:
[code]
'b' => TYPE_ITEM_JEWEL_BRACELET,
[/code]

before i'm doing something silly: is there a easy way you see to to seperate (and filter) the mats by groups (barrel, blade, clothes ...)?]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2570.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2570.page GMT i think line 3 should be:
[code]
'b' => TYPE_ITEM_JEWEL_BRACELET,
[/code]
yep you probably right.. damn typos ;-)

[quote]
before i'm doing something silly: is there a easy way you see to to seperate (and filter) the mats by groups (barrel, blade, clothes ...)?[/quote]
nope.. you need to check them from mat number ('Anete fiber' is 0006 etc)

i'll attach the filtered number-name list, ~345 lines (some missing and some extra probably).
you only need to write parser that generates dummy 'select case' php file that you can edit later ;-).
you also probably need to extend database table with one new field to keep the mat group info (bitfield, number does not matter).


]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2571.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2571.page GMT http://forum.ballisticmystix.net/jforum/posts/preList/522/2572.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2572.page GMT i have not testet those files (removed some guild-specific stuff) but i think it "should work" (c) ]]> http://forum.ballisticmystix.net/jforum/posts/preList/522/2576.page http://forum.ballisticmystix.net/jforum/posts/preList/522/2576.page GMT