Game Development Community

Connecting to sql table

by Joshua Turner · in Game Design and Creative Issues · 03/11/2005 (8:05 pm) · 8 replies

How do i connect and querty.
Where can i go to learn this stuff.
I kno all the commands but how do i do it with torque engine.
like login and get info in game.
NextNext Thread
PrevPrevious Thread
More from Game Design and Creative Issues


Torque 3D Owner Stephen Zepp
#1
03/11/2005 (8:23 pm)
There is a MySQL resource that you can drop in to TGE. Of course, you must configure the computer where your database will reside to use MySQL.

Torque Owner Joshua Turner
#2
03/11/2005 (9:14 pm)
Well what is it.
can u give me a exzampel or somthing.

Torque Owner Eric Lavigne
#3
03/11/2005 (9:35 pm)
I believe this requires access to SDK source code, so it can't be posted here. If you're considering buying Torque though, I can assure you that this is an easy task once you have access to the source.

Torque Owner Dreamer
Default Studio Name
#4
03/11/2005 (9:56 pm)
I wouldn't say easy, but it's doable.
Also you can't link to mysql directly in a commercial app w/o releasing the source or purchasing a mysql licsense.

There are 2 better options.

Connect via the web and a PHP script.

Use a different DB engine, like sqlite.

All depends on what you want to do.

Regardless, there is no direct Torque support for databases, you would need to mod the engine.

Torque Owner Joshua Turner
#5
03/11/2005 (10:27 pm)
Uhhhh.

Torque Owner Dreamer
Default Studio Name
#6
03/11/2005 (10:28 pm)
Sure use my resource...
http://www.garagegames.com/index.php?sec=mg&mod=resource&page=view&qid=7281

Torque Owner Joshua Turner
#7
03/11/2005 (10:29 pm)
Cant i do plugin dll or somthing.

Torque Owner Dreamer
Default Studio Name
#8
03/11/2005 (10:34 pm)
Not sure, I don't develop for windows.
You could simply write a script to use HTTPOBJECT to connect to a php script on a server, and have the php script do the talkin for ya.

Thats the simplest solution in most cases, as I said depends on what you want to do.