Game Development Community

Dynamic map/objects using SQL to build/modify?

by JackT · in Torque Game Engine · 08/28/2008 (4:46 am) · 5 replies

Hi all,

I am looking for a games engine that will enable me to dynamically build a basic map with objects that can be manipulated. I want to build and then manipulate/change the objects from a SQL database.

Can I get Torque to do this? If not, anyone know of a games engine that will?

Regards,

Jack

About the author

Recent Threads


#1
08/28/2008 (5:14 am)
Torque can do this, if you link in one of the many database resources available, and then store the objects in the database, writing some server side scripts to run through the table and create the objects. You'd still have a mission file but it would only contain the bare minimums. With a little more work you could replace the mission file too.

So, yes... it can do it quite well.
#2
08/28/2008 (9:35 am)
Dave,

Thanks for that. Do you have any links handy you could paste in so I can have a look at how this might be done?

Many thanks.
#3
08/28/2008 (9:48 am)
No need to wait for others to post links. Use the search box on the top right of your screen.

Search for "database" or "mysql".
#4
08/28/2008 (11:28 am)
I recently starting working with sqlite in TGB using this resource. Seem pretty useful, I have made some improvements to it, if you are interested in that just send me an email.
#5
08/28/2008 (11:43 am)
Peter - I started off doing that, searching for SQL. To be honest, I was struggling to see what I could actually do. As you must have surmised I am not a programmer :)
I want to do a PoC and am currently having a look around at what is possible and how much it will cost. I will be paying someone else to do the coding (thank God!). I might try to hack up something just to get a feel though.


James - thanks, I will have a look. We will need to connect into an external database, probably PostgreSQL but the code is helpful to see.

Many thanks for the feedback, it is great to see that this software has responsive and helpful people using it!


Jack.