KayotRO MySQL EQEmu Database Editor

[Kayot]

Finally a first post! I was thinking no one was interested. Anyway, I plan to post Updated V.0.0.0R001 soon. I figured out a neat way to save resources so I'm quickly cleaning the code.

P.S. Maybe I should release the EXE separately as it's the only file that changes?

[mwmdragon]

I would love to see this tool completed.

Request...

Make it so you can tell what NPCs are using a certain merchant list. I hate going in to find out which merchant list is being used by whom before i can edit it safely. I'm trying to get merchants cleaned up to live, instead of every merchant selling a ton of crap all the time like they just grabbed a bunch of log files and ripped what they were currently selling on live after all the noobs unloaded on em :P

So...

Merchant ID - NPC using it - Items being sold

With the ability to add and remove items being sold.

[John Adams]

I believe eq4me is also cleaning up the merchantlist tables. Might want to see what he's up to, maybe y'all can team up.

[eq4me]

Yea, right now I am cleaning up the items in the merchantlist. Means getting out any itens that dont belong there and checking if the merchant actually exists. A good example is the Swirlspine Belt. It exists in the merchant table but there is no npc for that merchant id.
I continue after I come home from work but I can't guarantee that it is done today.

I've collected enough data to create the merchant table from scratch but I need time to build the scripts to match allakhazam to peq id's.

[Kayot]

So, a feature that will find orphan entries in merchant lists? Sounds like fun.

eq4me - What are you writing your scripts in? I'm using vb.net 2003 and a MySQL connector library. I'm interested in help, but a bit scared as my codes are a little childish (Smart ass comments), not to mention messy and I don't really document as much as I should. The sides effects of being self taught ^-^. Not to mention if someone who

[eq4me]

I am doing this under Linux with bash and awk. What I am doing right now is laying a groundwork. That means tables which matches eg. peq item and npc id's with allakhazam id's, finding out which vendor listed on allakhazam has which item for sale and much more. Short term I just want to get rid of all exzess items in the merchant table and check if any items need to be on more vendors.
Once I am done with this I will see if i can accumulate all my scripts to someting more automated. But since eqemu is staying with Titanium I dont see the need to do weeky or even monthly updates.

[Kayot]

My questions is this. Are the container ID's needed in tradeskills in the recipes? I'm still able to make the combind with any forge so long as it uses the tradeskill button. I'm wondering because if it's unnessisary I'l like to prune that when making new recipes.