Simple Quest System

[Shando]

[TattieBoJangle]

This would cover a huge amount and would be great to have it in a game the only other thing i could think of that would make the even better would be an inventory system but that may be better in its own.

Keep up the great work m8 cant wait to see it in action.

[SolarPortal]

Very good idea Shando.

Q) What sort of database are you after? MySQL, simple in engine database, etc....

it looks like the basics are covered in what you wrote, if anything pops into mind, i will jot them down.

[Shando]

Hi SP,

I really don't care what sort of database it is (either in-engine or MySQL) But, having said that, I do know SQL pretty well, so something SQLesque would be perfect.

At the moment I'm just using Lua Tables to test out some of my code!! Though I have mapped out the required minimalist database which I'll post here shortly for feedback.

Shando

[Shando]

[Shando]

UPDATE

I've made a few changes to the Tables listed in my previous message, so rather than posting another long message, I've uploaded a pdf of my proposed Tables here:



Regards

Shando

PS: I'll probably be starting work on the actual code over the next week, so please let me know of any changes etc. as soon as possible.

[SolarPortal]

just been looking into mysql with lua and found this page from the lua website. All we might need to do is compile(dll or other file type) it into the system. Have a read and let us know

I am also trying to see if we can have a table bbcode system as it would make lists like yours tidier to read. Will let you know how this one turns out. However, the list and its contents are very interesting and i feel you have covered a lot of bases, it will be interesting to see how this plays out.
The PDF is a really good document outlining the data. Good job!

Another idea we had to do with storing your tables could be to use excel and use the script file interaction system you first built for the community to access and read the data into lua easier. That way its easier to type out and read in every time.

[Shando]

[SolarPortal]

i will look into this and see whats integratable the best. I will check the JSON interface first as well as MySQL

[Shando]