I've updated to the latest revision... and thanks for all your work, this is a really slick little program. I have a question though. It may have more to do with my current MaNGOS revision than my databases, or your program though.
If I create a new item, I can't go back and edit it. Now I honestly can't say anything about current in game items because I didn't want to fool with them, but once my item was created, it stayed that way. I can change the database numbers all I want, but the item is forced in game to be the same as the first one I created.
Example: I went through the creation of the item but forgot to add a model number. therefore all I got was this lousy ? Should be simple enough to fix, but when I chose a model number for it, it never updated. To test this out further, I changed the items description, deleted the item from my character and then recreated it. still the same original item I created improperly. Then I created a second item, this time I plugged in all the same numbers but a different item number, and now added the proper model number. The item didn't work in game.
I have at least figured that I need to restart the server when I add new items. (I'm not sure if this needs to be done)
but my question is, can items be updated? Or once an item is loaded by the server, is its data is locked in? This by the way is the same problem I ran into with WoWemu. It seemed that it took data from your items and hard saved them to your World.save. I just assumed that since MaNGOS had the SQL database... items could be updated without removing them from the server.
I'm running the 3184 server