MySQL support for Torque Engine

by AIDan · in Torque Game Engine · 11/25/2001 (11:18 am) · 62 replies · appears

- create database Accounts;
- GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,REFERENCES ON Accounts.* TO mikkel@localhost IDENTIFIED BY 'hempel';
- flush privileges;
- quit;
// NEVER USE THE OBJECT AS GLOBAL ONE
// SOMEONE COULD RETRIEVE THE PASSWORD, THEN!!!

function MySQLtest()
{
    // ----------------------------------------------------
    %mysqltest = new MySQL();

   // ----------------------------------------------------
   // set host info

//   %mysqltest.host = "192.168.1.100";    // default: "localhost"
//   %mysqltest.port = 6660;               // default: 3306

   // user information
   %mysqltest.user = "mikkel";           // NO default!
   %mysqltest.pwd  = "hempel";           // default: ""

   // connection flags
   %mysqltest.flag_compress = false;     // default: false
   %mysqltest.flag_ssl      = true;      // default: false

   // database to use
   %mysqltest.db = "Accounts";           // NO default!

   // ----------------------------------------------------
   %mysqltest.ValidateSettings();        // optional

   %mysqltest.Connect();

   %mysqltest.Close();
}

MySQLtest();
exec("fps/database/mysqltest.cs");
E:\Images\torque\engine\game\mysql\mysql.h(15) : fatal error C1083: Cannot open include file: 'mysql_1.7.1/include/mysql.h': No such file or directory
mysql_cs.cc
E:\Images\torque\engine\game\mysql\mysql.h(15) : fatal error C1083: Cannot open include file: 'mysql_1.7.1/include/mysql.h': No such file or directory
Error executing cl.exe.
[b]#include "mysql.h"[/b]
[b]C/C++->Preprocessor:[/b] In the [b]Additional include directories[/b] entry field, add [b],../lib/mysql/include[/b] to the end of the line
[b]Link->Input:[/b]: In the [b]Object/library modules[/b] entry field, add [b]libmySQL.lib[/b] to the end of the line
[b]Link->Input:[/b]: In the [b]Additional library path[/b] entry field, add [b],../lib/mysql/lib/opt[/b] to the end of the line
E:\Images\torque\engine\game\mysql\mysql.h(16) : fatal error C1083: Cannot open include file: 'mysql_1.7.1/include/mysql.h': No such file or directory
mysql_cs.cc
E:\Images\torque\engine\game\mysql\mysql.h(16) : fatal error C1083: Cannot open include file: 'mysql_1.7.1/include/mysql.h': No such file or directory
StringTableEntry MySQL::GetRowCell (S32 _iResult, StringTableEntry _sFieldName)
{
    MYSQL_RES   *pRes;
    MYSQL_FIELD *pField;

    MySQLGetResultEx (pRes, 0);

    // Go through all of the fields
    for (U32 i = 0; i < pRes->field_count; i++)
        {
        // Get a field
        pField = mysql_fetch_field_direct(pRes, i);
        // Do we have a match
        if (dStrcmp(pField->name, _sFieldName) == 0)
           {
           // Yes we do
           return(GetRowCell(_iResult, i));
           }
        }

    // Let the user know
    Con::errorf ("MySQL: unknown field name: %s", _sFieldName);

    return(0);
}

Game Development Community

MySQL support for Torque Engine

About the author

Recent Threads