Tdawg

float Database_MySQL::GetShuttleLoc(string ShuttleName)
{
	string sqlquery;
	float position;
	sqlquery = "SELECT ShuttleX, ShuttleZ, ShuttleY, ShuttleMapID FROM 'shuttlelocations' WHERE ShuttleName='" + (string)ShuttleName + "'";
	if (!mysql_query (Handle, sqlquery.c_str())) 
	{
		Result = mysql_store_result (Handle);
		if (!Result)
			return NULL;
		Row = mysql_fetch_row (Result);
		if (!Row)
		{ 
		    Log( LOG_PRINT | LOG_NO_OUTPUT | LOG_NO_TIMESTAMP, NULL, "Failed to fetch shuttle location for user [%s]", ShuttleName);
			mysql_free_result(Result);
			return NULL;
		}
		if (Row[0] > 0)
		{
			position = (atof(Row[1]), atof(Row[2]), atof(Row[3]), atof(Row[4]));
			mysql_free_result(Result);
			return position;
		}
	        else
        {
            mysql_free_result(Result);
            return NULL;
        }
    }
    else
        return NULL;
}