Bug Fixes

• patch/mysql2: rebind undeefined parameters to null (Linden)

Updating the mysql2 package resolves a number of security issues, most notably resolving an sql injection exploit due to another dependency (sqlstring). Other changes may improve performance and resolve memory leaks.

Continuous Integration

• release: update add-and-commit action (Linden)
• release: remove fxmanifest from commit (Linden)
• release: set package version to tag (Linden)
• release: set working directory (Linden)

Chores

• bump package dependencies (Linden)
• bump version to v2.14.0 (github-actions)

Features

• enable node22 (ANTOND.)

Code Refactoring

• use bun instead of pnpm (ANTOND.)

Continuous Integration

• create-release: restructure and update versions (ANTOND.)
• create-pre-release: add pre-release workflow (ANTOND.)
• create-release: use github app token (ANTOND.)
• create-release: use npm trusted publisher (ANTOND.)

Chores

• update organization name (ANTOND.)
• lib: bump package version (ANTOND.)
• bump version to v2.12.3 (github-actions)
• bump version to v2.13.1 (github-actions)
• bump version to v2.13.2 (github-actions)

Commits

• e2d1fec: v2.13.0 (GitHub Actions)
• 38b4fe7: Merge remote-tracking branch 'upstream/main' (Linden)
• f230a4e: update name and refs (Linden)
• 94a132e: Update release.yml (Linden)
• 3767da5: Update release.yml (Linden)
• 991fb06: Update release.yml (Linden)
• 521c865: Update release.yml (Linden)
• 4141339: Update release.yml (Linden)
• b2e6384: Update release.yml (Linden)
• 4dfad43: Update release.yml (Linden)

This update only enables support for NodeJS v22. Requires FXServer 12913 or higher.

Almost all users will experience server crashes on artifacts 12913 or higher.
The developers of FiveM are too incompetent to fix any of the problems they have caused, so do not use this release.

We suggest using https://artifacts.jgscripts.com/ to find stable releases of FXServer. We suggest closing down your FiveM server.

Features

• enable node22 (Linden)

Bug Fixes

• lib/ts: build issues and export name (Linden)

Commits

• 586340d: v2.12.0 (GitHub Actions)

• External logger services can now be loaded with set mysql_logger_service '@resource/path.js'.
• Added support for mysql_option(s) in resource metadata (fxmanifest).
• Added mysql_option 'return_callback_errors', allowing error handling in your callbacks.

MySQL.scalar('SELECT datefOfBirth FROM characters LIMIT 1', function(res, err)
    if err then error(err) end

    print('scalar', res)
end)

• Added MySQL.startTransaction to library.

local success = MySQL.startTransaction(function(query)
    local a = query('INSERT INTO users (identifier) VALUES (?)', { 'someid' })

    -- if a is undefined, return false and rollback
    if not a then
        return false
    end

    -- errors in a query (e.g. syntax) will result in a rollback
    local b = query('SELEC * FROM users WHERE id = ? LIMIT 1', { a.insertId })

    -- transactions timeout after 30s to prevent connections being locked
    Wait(30000)

    -- throwing an error during a transaction will rollback
    if not b then
        error('sad')
    end

    -- no return, or any truthy value, will commit the transaction and release the connection
end)

print(success)

Features

• lib/lua: add options and 'return_callback_errors' (Linden)
• add startTransaction to library (Linden)
• logger: support loading external loggers (Linden)

Bug Fixes

• logger: catch errors when triggering error callback (Linden)
• lib: assert query value when using query store (Linden)
• revert citizenfx/server dependency update (Linden)
• update types/node (Linden)
• web: update and resolve conflicting dependencies (Linden)
• utils/parseArguments: resolve null parameters in sparse arrays (Linden)
• db/pool: set pool after confirming a connection (Linden)
• db/pool: don't manually fetch connection (Linden)

Code Refactoring

• database/pool: link to issues when connection fails (Linden)

Chores

• update package dependencies (Linden)
• deps-dev: bump vite from 4.2.0 to 4.5.5 in /web #244 (dependabot[bot])
• deps: bump braces from 3.0.2 to 3.0.3 in /web #241 (dependabot[bot])
• deps: bump micromatch from 4.0.5 to 4.0.8 in /web #242 (dependabot[bot])
• deps: bump postcss from 8.4.21 to 8.4.31 in /web #240 (dependabot[bot])

Commits

• bfe660b: v2.11.2 (GitHub Actions)

Bug Fixes

• utils/parseResponse: use nullish coalescing operator (Linden)

Commits

• 22be4b1: v2.11.1 (GitHub Actions)

Bug Fixes

• build: typo in fxmanifest creation (Linden)

Commits

• f8f3906: v2.11.0 (GitHub Actions)

Features

• logger: add fivemanage logging service #232 (Linden)
• utils/typeCast: support date typecasting for binary protocol #232 (Linden)

Bug Fixes

• update: catch error on failed fetch (Linden)
• database/connection: return promise from commit method #232 (Linden)
• database/connection: disable typecasting for execute method #232 (Linden)
• utils/typeCast: correctly parse null date fields #232 (Linden)
• patches/mysql: missing charset patch #232 (Linden)
• config: allow database to be undefined in uri #232 (Linden)

Code Refactoring

• database: add new connection class and misc tweaks #232 (Linden)
• profiler: move from logger module #232 (Linden)
• database/pool: warn if using multipleStatements #232 (Linden)
• logger: dynamically load logger service (Linden)

Chores

• update dependencies #232 (Linden)
• utils/typeCast: use patched type #232 (Linden)
• update dependencies #232 (Linden)
• update build target to nodejs 20 #232 (Linden)
• update package dependencies #232 (Linden)

Commits

• 5440e03: v2.10.1 (GitHub Actions)
• 318b4c1: Revert "chore: update build target to nodejs 20" (Linden) #232

Bug Fixes

• update: incorrect regex patterns (Linden)
• ci/release: update pnpm (Linden)
• ci/release: update node (Linden)

Code Refactoring

• db/connection: additional info for auth_gssapi_client error (Linden)

Chores

• dependencies: set target versions (Linden)

Commits

• 40faa5e: v2.10.0 (GitHub Actions)

Features

• query search for debug ui (Luke)
• utils/validateResultSet: add warning for oversized result sets (Linden)

Bug Fixes

• web: resolve dead font cdn link (Luke)

Commits

• 9b2b34f: v2.9.1 (GitHub Actions)