I know that MySQL and Rom integration has been discussed on this list for a while now and I have been trying to implement a few changes on my little project mud. I have been able to move helps over to a MySQL table and query the table as needed to look up helps. I have even, mostly anyway, gotten the Mud to maintain a open connection to the database while it is running so as not to continually open and close the request. However I was wondering how would I go to move over things that are not so static as the help files and that need to be loaded into memory? Does anyone have any small example , really looking for something short that tells how to run a query and keep the data in memory, of what they did for things like player files , areas, or items and mobs?
I would really appreciate any and all information that you can throw my way. Thanks for your time.
