RPG Resource 1 AKA SQLite3 for T3D
by Kevin Mitchell · 10/05/2009 (5:36 am) · 9 comments
File Front:
Download Source
1: Download the .zip file and extract it.
2. Copy the Engine Folder into: "C:TorqueTorque 3D 2009 SDK 1.0"
3. Open your project code.
4. Right click the 'project name' DLL project, go to properties.
5. Expand Linker, select general, Under Add lib. Dir. add the sqlite directory:
C:TorqueTorque 3D 2009 SDK 1.0Enginelibsqlite3
6. Next select Input, and under Additional Dependencies add
sqlite3.lib
7. Right click the 'project name' DLL project, go to add folder and name it 'sqlite'.
8. Right click the sqlite folder. Add -> Existing File -> select the files in:
C:TorqueTorque 3D 2009 SDK 1.0Enginesourcesqlite3
9. Compile.
10. Add sqlite3.dll and sqlite3.exe to your game directory.
11. Create your database by running cmd and in you game directory type:
sqlite3 Database.db
12. use .help for a list of options and enjoy using sqlite in your game.
Note: the database.db file is created after you exit sqlite.
Much credit to the guy that first created the SQLite 3 source. Without that i wouldn't know how to create the lib files from the sqlite website or the changes needed to make things note crash.
Enjoy.
Back To Blog:
RPG_Blog AKA New Resources
Download Source
1: Download the .zip file and extract it.
2. Copy the Engine Folder into: "C:TorqueTorque 3D 2009 SDK 1.0"
3. Open your project code.
4. Right click the 'project name' DLL project, go to properties.
5. Expand Linker, select general, Under Add lib. Dir. add the sqlite directory:
C:TorqueTorque 3D 2009 SDK 1.0Enginelibsqlite3
6. Next select Input, and under Additional Dependencies add
sqlite3.lib
7. Right click the 'project name' DLL project, go to add folder and name it 'sqlite'.
8. Right click the sqlite folder. Add -> Existing File -> select the files in:
C:TorqueTorque 3D 2009 SDK 1.0Enginesourcesqlite3
9. Compile.
10. Add sqlite3.dll and sqlite3.exe to your game directory.
11. Create your database by running cmd and in you game directory type:
sqlite3 Database.db
12. use .help for a list of options and enjoy using sqlite in your game.
Note: the database.db file is created after you exit sqlite.
Much credit to the guy that first created the SQLite 3 source. Without that i wouldn't know how to create the lib files from the sqlite website or the changes needed to make things note crash.
Enjoy.
Back To Blog:
RPG_Blog AKA New Resources
About the author
Jack of all trades master of none. 3DS Max, Blender, Poser5, CS4, FL Studios, TORQUE 3D.
#2
There is no add folder ... did you mean add filter?
Also did you just add that that directly to the root dll filter like so
Project DLL
.. sqlite
.. Source Files
Or Do I add it under the source section like so
Project DLL
.. Source Files
.... Engine
...... sqlite
.... Source
.... Torque.rc
10/05/2009 (11:45 pm)
Excellent resource thank you. One comment/question but in step 7.Right click the 'project name' DLL project, go to add folder and name it 'sqlite'.
There is no add folder ... did you mean add filter?
Also did you just add that that directly to the root dll filter like so
Project DLL
.. sqlite
.. Source Files
Or Do I add it under the source section like so
Project DLL
.. Source Files
.... Engine
...... sqlite
.... Source
.... Torque.rc
#3
10/06/2009 (4:19 am)
Yes the second one, the files should be situated like the file system. If you droppeds the engine folder in the torque directory the it should work ok. 
#4
10/06/2009 (5:34 am)
thanks a lot, we need this asap! ;D
#5
10/07/2009 (2:24 pm)
Please let me know if anyone is having problems. I'll see if I can help. 
#7
Cooooooool!!!!!
10/08/2009 (10:03 pm)
Yes, thank you very much. It looks as if you are sharing a complete RPG 'lite' kit for T3D this way. Cooooooool!!!!!
#8
10/08/2009 (10:25 pm)
There is a lot more that's needed to consist as a kit. If anything it's a helpful stepping stone.
#9
Hey, Kevin
Thanks for the awesome resource! I'm attempting to incorporate your resource into a project that I'm working at the moment. I know the resource is using Windows, as the method to build sqlite ability into the project. However, I'm working on a project using Mac OS X which might not be in your knowledge area, but I'm been able to add sqlite.o file into the project build with no issues. The issue is, that in statements like
sqlite.closeResult(%t);
sqlite.closeDatabase();
sqlite.delete(); statements do not appear to be exposed. Did you create sqlite.dot function? Even the sqlite3 Framework on Mac OS X appears not to see these functions as well.
Any suggestions, would be awesome.
10/28/2009 (5:57 pm)
Hey, Kevin
Thanks for the awesome resource! I'm attempting to incorporate your resource into a project that I'm working at the moment. I know the resource is using Windows, as the method to build sqlite ability into the project. However, I'm working on a project using Mac OS X which might not be in your knowledge area, but I'm been able to add sqlite.o file into the project build with no issues. The issue is, that in statements like
sqlite.closeResult(%t);
sqlite.closeDatabase();
sqlite.delete(); statements do not appear to be exposed. Did you create sqlite.dot function? Even the sqlite3 Framework on Mac OS X appears not to see these functions as well.
Any suggestions, would be awesome.
Torque 3D Owner Chris Sargent
Thanks for this information in both of the resources!