Skip to content
widberg edited this page Jul 4, 2023 · 6 revisions

There are remnants of SQL being used in the binary. FUEL uses ODBC to connect to a SQL server in the ComDBodbc_Z class.

The following functions from ODBC are imported

SQLAllocHandle
SQLSetEnvAttr
SQLSetConnectAttr
SQLGetDiagRec
SQLFetch
SQLNumResultCols
SQLExecute
SQLFreeStmt
SQLGetData
SQLPrepare
SQLDisconnect
SQLFreeHandle
SQLDriverConnect

Notably, none of the imported functions are capable of spinning up a database, meaning that one must be running external to the game.

There is also a StartDataBase command that calls SQLDriverConnect. The format string "DRIVER=MySQL ODBC 3.51 Driver;DATABASE=%s;DSN=ATV Outlawed Data Base;OPTION=0;PWD=%s;PORT=%d;SERVER=%s;UID=%s" is used as the InConnectionString argument to the SQLDriverConnect function after the relevant data has taken the place of the format specifiers. This string references "ATV Outlawed," a potential candidate for the game's name.

Several query format strings are seen in the binary as well

"SELECT %s FROM %s WHERE %s='%s';"
"UPDATE %s SET %s=%s WHERE %s='%s' LIMIT 1;"
"UPDATE %s SET %s='%s' WHERE %s='%s' LIMIT 1;"
"INSERT INTO %s (%s , %s , %s) VALUES( '%s' , '%s' , '%s');"
"INSERT INTO %s (" [("%s , %s" | "%s%s")...] ") VALUES (" [("%s , %s" | "%s%s")...] ";"
"INSERT INTO %s (%s , lasttick, %s , %s , %s, %s, %s, %s, %s, %s, %s, %s) VALUES( '%s' , now(), '%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s' , '%s');"

Home
FAQ

For FMTK Users and Mod Developers

Read the Docs

For FMTK Developers

Asobo BigFile Format Specification
Asobo Classes
      Animation_Z
      Binary_Z
      Bitmap_Z
      Camera_Z
      CollisionVol_Z
      Fonts_Z
      GameObj_Z
      GenWorld_Z
      GwRoad_Z
      Keyframer*_Z
      Light_Z
      LightData_Z
      Lod_Z
      LodData_Z
      Material_Z
      MaterialAnim_Z
      MaterialObj_Z
      Mesh_Z
      MeshData_Z
      Node_Z
      Omni_Z
      Particles_Z
      ParticlesData_Z
      RotShape_Z
      RotShapeData_Z
      Rtc_Z
      Skel_Z
      Skin_Z
      Sound_Z
      Spline_Z
      SplineGraph_Z
      Surface_Z
      SurfaceDatas_Z
      UserDefine_Z
      Warp_Z
      World_Z
      WorldRef_Z
Asobo File Format Idioms
Asobo CRC32
Asobo LZ Compression
Asobo Arithmetic Coding Compression
Asobo Save Game File Format Specification
Asobo Audio Formats
TotemTech/ToonTech/Zouna/ACE/BSSTech/Opal Timeline
Zouna Modding Resources
Miscellaneous

Clone this wiki locally