Damn,
This is great. I feel like I paid for support or something with all the feedback to my newb post! :lol:
Thanks for the info, makes sense to me, also good to hear you guys are getting help when needed! I'm glad to hear some of the ShowEQ folks are sharing their knowledge.
If anyone has some time, I was curious about the items below. I understand you guys don't have a lot of free time to answer dumbass questions... and you've already made my day with the prior two posts! Yes, I'm that easy to please (even my wife says so!).
This is semi-off topic, but I was curious if there are any plans to add the zone items come from? Obviously, this is a no-go for linked items, as the DB would show everything in the game dropping in the Bazaar
However, looted items would validate where items drop and I figure as some point most of the items would be looted by people running your PC. I ask, because of items like 'a lucid shard' which drop in 10 different zones. It is only via the lore, that I'm able to figure out the zone.
My plan is to have a VT key tracker up on my webpage, among other things, to help the guild keep track of players' progress. I guess I was looking for ideas perhaps? I guess I could keep a seperate table of id + zone info and cross-reference that. I realize this is most likely out of the scope of your goals (eq emu), but figured I'd throw it in, as, heck, I have no clue how eq emu can figure out which ones to place in what zone, hehe.
My last annoying question, I promise, but once I imported the DB into my MySQL server I notice a 'problem' with some of the items 'name' fields. When I do a query for 'fine steel rapier' it returns 1 match. However, if I search for 'fine steel rapier\0' I get another, different match. I mainly write in VB6, but have this problem from the MySQL CC v0.9.3beta as well. I had noticed this with the 'a lucid shard' items in the prior released DB, though it was 'fixed' this revision and those no longer terminate with '\0'. I'm far from a DB mastermind and have solely worked with MS SQL server (access and other wanna-be databases as well) and have never bumped into this.
Thanks again!