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; }