MySQL for TGE

Download Code File

I found a forum thread by Felix Kollmann which lead me to a dead end on his site, after reading more of the thread I noticed that Stefan Beffy Moises snagged a copy of the code and tossed it on his www site (Thanxs Beffy!!!).

Looking at the code revealed that it needed a bit of an updated to be TGE 1.2 compliant as well as to get the ball rolling for cross platform compliancy.

I spent an hour or so last night updating the ConsoleMethods and adding a new one, as well as #if def'ing the winsock.h.

Decided to toss this back into the resource section so it does not get lost again. The .zip contains everything you need to get up and running


-Ron

You will need to download the original zip file from Beffy's site in order to use my updates

Updates:
03/04/04 Yacketta updated zip file

Updated 3/15/05
Got am e-mail regarding this resource and the inability to get it working as stated in the documentation. After some minor digging I found that the ConsoleMethod's needed to be updated as follows

ConsoleMethod (MySQL, GetRowCellDirect, const char*, 4, 4, "MySQL.GetRowCellDirect (ResultID, FieldNr)")
{
	MySQL* pThis= dynamic_cast<MySQL*> (object);

	return pThis->GetRowCell (atoi (argv[2]), atoi (argv[3]));
}

ConsoleMethod (MySQL, GetRowCell, const char*, 4, 4, "MySQL.GetRowCell (ResultID, FieldName)")
{
	MySQL* pThis= dynamic_cast<MySQL*> (object);

	return pThis->GetRowCell (atoi (argv[2]), argv[3]);
}

ConsoleMethod (MySQL, NumFields, S32, 2, 2, "MySQL.NumFields()")
{
	MySQL* pThis= dynamic_cast<MySQL*> (object);

	return pThis->NumFields();
}

ConsoleMethod (MySQL, GetFieldName, const char*, 4, 4, "MySQL.GetFieldName (ResultID, FieldIndex)")
{
	MySQL* pThis= dynamic_cast<MySQL*> (object);

	return pThis->GetFieldName (atoi (argv[2]), atoi (argv[3]));
}

the above changes enables one to get this resource compiled using visual studio 2003. I did not perform any unit or end to end tests with a mysql db

-Ron