MySQL integration for TGE/TGEA

This is based off an old resource that used a 2002 build of the lib which leaves it open to security holes, lack of features and having t owork around its "quirks". The file that is attatched has all the required files needed to install MySQL and i will guide you step by step on how to do it.

Eugh .. file size limit ... Here is the link to the files.
ryth.net/MySQL.rar


First download the file and open it up.
Extract the file into your main directory (F.E Z:Tourque_1_0_3)
You need to add the lib(Z:Tourquelibmysqllib)
and include (Z:Tourquelibmysqlinclude)
folder to your project (If your not sure how there is alot of info around)
Next, add the folder and all of its contents z:tourqueenginegamemysql to your project.
Compile!

Here is an example of how to use MySQL within your project.

//All information is stored in local variables (%) So that no one can gain information via the console.

function MySQL()
{
	%mysql= new MySQL();
	%mysql.host= "localhost";		// default: "localhost"
	%mysql.port= 0;			// default: 3306
	%mysql.user= "root";		// No default
	%mysql.pwd= "";			// default: ""
	%mysql.flag_compress= false;	// default: false
	%mysql.flag_ssl= false;		// default: false
	%mysql.db= "news";			// No default
	%mysql.ValidateSettings(); 		// optional
	%mysql.Connect();
	%mysql.Query ("SELECT * FROM news");
	%result= %mysql.StoreResult();

	for (%i= 0; %i< %mysql.NumRows (%result); %i++)
	{
		%mysql.FetchRow (%result);

		%id= %mysql.GetRowCell (%result, "Index");
		%date= %mysql.GetRowCell (%result, "Date");
		echo (%id, " --- ", %date);
	}

	%mysql.FreeResult (%result);
	%mysql.Close();
}

MySQL();

Short video explaining how to setup your visual studio in order to compile with MySQL.
ryth.net/T3D_MySQL_Vid.rar