Here's what I had in mind.
As it stands right now, from what I know, there's a lot of caching involved. Changing data on the fly is simply not possible. For example, if one changes data related to NPC's or quests etc., the changes do not apply until a server restart. Of course, this is not desirable at all sometimes.
However, I can see something in the server code which states that through some server console commands some data might be reloaded.
15464 -- NPC commands ------------------------------------------------.
15464 exportdialogs Loads NPC dialogs from the DB and stores them in a XML file.
15464 exportnpc Loads NPC data from the DB and stores it in a XML file.
15464 importdialogs Loads NPC dialogs from a XML file or a directory and inserts them into the DB.
15464 importnpc Loads NPC data from a XML file or a directory and inserts it into the DB.
15464 loadnpc Loads/Reloads an NPC from the DB into the world.
15464 loadquest Loads/Reloads a quest from the DB into the world.
So, I am not sure whether these are broken or I haven't managed to use them yet, but is it possible to do some things like that via scripting?
Supposing I would survey some custom logs, for the sake of the example - how much an item has been sold/bought from NPC's, I'd then change in MySQL the base price (randomizing the economy a little bit). Of course, to be seamless to the users that data would have to become available in game without a restart, perhaps simulating what the servercommand loadquest does.
Technically speaking, again from what I understand although this may not be entirely true, the cache would have to be flushed and reupdated with the new data. Is it possible at this stage or is it possible to implement such a feature?
