Game Development Community

T3D with SQL

by Terry Barlow · in Torque 3D Professional · 07/04/2013 (3:32 pm) · 7 replies

Hi all

I am want to setup my T3D with SQL prob for now SQL 2008 since thats what I have installed on my server right now what I need to know is how do I go about it is there any docs or anything on it I want it to like save user names and PWD email address as well just for password resets but what I want it to do for now to start is have T3D ask for a user name and PWD so the user can login and then it will save all the users info and as time goes by the database will store more and more info but to start just the users log ininfo and then how do I tell T3D to use it thanks

Terry
Terry Barlow's profile picture
Torque Owner Terry Barlow
Default Studio Name

About the author

Send all correction E-Mails to: h0td0g4@yahoo.com Unskilled, having fun, playing around, and helping out!

Recent Threads

  • Windows Client Linux Server
  • Info On Torque3D
  • T3D and Win 8.1
  • RPG Engine Tool Kit
  • Master Server Take 2
    • NextNext Thread
    PrevPrevious Thread
    More from Torque 3D Professional


    Torque Owner Richard Ranft
    Roostertail Games
    #1
    07/04/2013 (5:14 pm)
    If you're looking to access MSSQL from unmanaged code I'd suggest reading up at msdn.microsoft.com. I'm pretty sure there's a way to access MSSQL via some networking protocol or other as well - could probably use Torque's built-in HTTPObject or TCPObject with tweaks.

    And, as a favor to me - please look into using punctuation. It really does make posts more readable.

    Torque 3D Owner Scottie Sirius
    #2
    07/05/2013 (9:41 am)
    There should be a plugin, add-on or module for this by now. I would strongly suggest it go on the to do list for future releases. I think there may be something like it in the RPG kit but haven't checked it out very closely.

    Torque Owner Stefan Lundmark
    #3
    07/05/2013 (10:01 am)
    Well, the reason there's no MSSQL resource/plugin is because, unlike MySQL, it isn't free. The latter is more straight-forward to bind and nowadays very stable and fast (Facebook and Google uses it).

    Unfortunatly they don't share the same syntax.

    Torque 3D Owner Scottie Sirius
    #4
    07/05/2013 (10:15 am)
    We just switched from MS SQL to MySQL to better accommodate the new website we're putting together, a PHPNuke derived CMS. The module I meant was more of a basic accounts, log-in, persistence module that had connection strings for most of the major databases. But...then that opens Pandora's box I suppose.

    Associate Ron Kapaun
    3tdstudios.com
    #5
    07/05/2013 (7:34 pm)
    Scot,

    Fix it, make it work. Make it public via resources(if you choose) or sell it as a product and use the income to finance additions to your version of the engine. I believe Kevin provided a public resource that added SQL lite to 1.2. Chances are you can build on that to make your system work. Just an idea.

    Ron

    Torque 3D Owner Scottie Sirius
    #6
    07/06/2013 (1:44 pm)
    Oh, no. We're well past all of that. I was just saying it seems like a registration/user accounts/persistence/database connectivity module should be a simple add-on for noobs by now. However, I do think that we'll be giving people some options soon!

    Torque Owner Demolishun
    DemolishunConsulting Rocks!
    #7
    07/12/2013 (8:50 am)
    All I have to do is:
    import sqlite3
or
import MySQLdb
or
import pymssql

    So the integration of professionally supported libraries is already available. Some assembly and learning curve is required: ScriptT3D