I've got a quick question about the database. It doesn't seem like anybody outside the dev team is interested in merchants. I've been looking through the database and noticed that some merchants are way off from what they should be, for example:
npc # 646 "a_clockwork_jeweller" in Ak'Anon is associated with fishing supplies
npc # 1344 "Felen_Razdal" in Butcherblock is associated with a random assortment of stuff, when he should be selling stuff like rations, lanterns, etc.
The code I used to come up with this is this:
Code:
SELECT items.name, items.id, merchantlist.item, merchantlist.merchantid, npc_types.merchant_id, npc_types.name, npc_types.id
FROM `merchantlist`, `items`, `npc_types` where items.id = merchantlist.item and merchantlist.merchantid = npc_types.merchant_id and npc_types.name like "%razdal%" order by npc_types.name, items.name
So my quick question becomes three. First off, what can I do to help set the merchants straight?
Secondly, is the merchantlist.merchantid an arbitrary value, or is the exact value important somewhere?
Lastly, did I just totally botch the SQL statement above(which isn't exactly pretty), and am getting randomly wrong results?
I've already started writing a SQL file out to help fix the problems, but I didn't want to start working on it and have someone say that I wasted my time because the merchantid's were important and I couldn't just choose arbitrary ones. If anyone can help answer my questions I'd be greatly appreciative.
Also, if I posted this in the wrong place.. smack me with a clue-by-four, and let me know where it needs to go.