Mysql
by Katy Atik · in General Discussion · 02/17/2005 (8:46 am) · 5 replies
Hello:
I am a new Torque Engine user.
I need to design a game where one of the requirements is to retrieve entries from a MySQL database and give each player a trophy depending on the values retrieved from the DB.
Can this be done in Torque? If so, can anyone guide me to a sample source code. I've looked in GG sites but was not able to find any information.
Thanks,
Katia
I am a new Torque Engine user.
I need to design a game where one of the requirements is to retrieve entries from a MySQL database and give each player a trophy depending on the values retrieved from the DB.
Can this be done in Torque? If so, can anyone guide me to a sample source code. I've looked in GG sites but was not able to find any information.
Thanks,
Katia
#2
David Blake posted the resources that you'll need. However, you're not really even supposed to be looking at them because they contain source code that should only be available to SDK owners. Garage Games has recently added a security feature which marks such pages as private and keeps unlicensed users from viewing them, but it will take time for them to go through all of the old pages like that one and mark them as private.
02/17/2005 (8:52 am)
I think you will need a Torque SDK to do this. Your profile says that you don't have a Torque SDK yet. In order to add MySQL support, you will need access to the C++ source. It is not hard to add.David Blake posted the resources that you'll need. However, you're not really even supposed to be looking at them because they contain source code that should only be available to SDK owners. Garage Games has recently added a security feature which marks such pages as private and keeps unlicensed users from viewing them, but it will take time for them to go through all of the old pages like that one and mark them as private.
#3
I wanted to find out about Torque capabilities before getting the license.
02/17/2005 (10:10 am)
Thank you both for your quick reply.I wanted to find out about Torque capabilities before getting the license.
#4
02/17/2005 (11:08 am)
It's actually not hard to add database connectivity to any engine as long as you have the source. Unless you don't know the interfaces or programming language necessary to integrate it into the source code.
#5
There is a resource somewhere that uses this technique for a login server, and while there is an engine mod required for that to work, it is possible to do the whole thing in script. It would just be a little complicated is all.
That said... BUY a license to use TGE it'll be the best money you ever spent I guarantee it!
03/02/2005 (9:53 am)
Umm hey this could be done simply by connecting to the DB via PHP and HttpObjects and would not nessecarily require moding the engine code.There is a resource somewhere that uses this technique for a login server, and while there is an engine mod required for that to work, it is possible to do the whole thing in script. It would just be a little complicated is all.
That said... BUY a license to use TGE it'll be the best money you ever spent I guarantee it!
Associate David Montgomery-Blake
David MontgomeryBlake
ODBC / Database support in Torque
MySQL in TGE
EDIT:
Added another resource.
And, yes, you'd need to change the C++ source so you'd have to purchase a license.