-- ESX mysql-async\nMySQL.Async.fetchAll('SELECT * FROM users WHERE identifier = @id', {['@id'] = identifier}, function(rows)\n -- ...\nend)\n<\/pre>\n\n\n\n-- QBCore oxmysql\nlocal rows = MySQL.query.await('SELECT * FROM players WHERE citizenid = ?', { citizenid })\n-- rows is a Lua table; handle nil and length checks directly\n<\/pre>\n\n\n\n-- ESX scalar example\nMySQL.Async.fetchScalar('SELECT COUNT(1) FROM owned_vehicles', {}, function(count)\n -- ...\nend)\n<\/pre>\n\n\n\n-- oxmysql scalar\nlocal count = MySQL.scalar.await('SELECT COUNT(1) FROM player_vehicles')\n<\/pre>\n\n\n\n-- ESX insert\nMySQL.Async.execute('INSERT INTO addon_account VALUES (@owner, @name, @money)', {\n ['@owner'] = identifier, ['@name'] = name, ['@money'] = money\n})\n<\/pre>\n\n\n\n-- oxmysql insert\nMySQL.prepare.await('INSERT INTO player_accounts (citizenid, name, amount) VALUES (?, ?, ?)', { citizenid, name, amount })\n<\/pre>\n\n\n\nNotes<\/p>\n\n\n\n
\nPrefer query.await<\/code>, scalar.await<\/code>, and prepare.await<\/code> for clean flow.<\/li>\n\n\n\nUse prepared statements for write operations.<\/li>\n<\/ol>\n\n\n\nStep 4. Map ESX Data Structures to QBCore<\/h2>\n\n\n\n You will move player identities and owned entities. Use this reference to map tables.<\/p>\n\n\n\nESX table<\/th> Key column<\/th> QBCore table<\/th> Key column<\/th> Notes<\/th><\/tr><\/thead> users<\/code><\/td>identifier<\/code><\/td>players<\/code><\/td>citizenid<\/code><\/td>Convert identifiers and create citizenid<\/code> for each row<\/td><\/tr>owned_vehicles<\/code><\/td>owner<\/code><\/td>player_vehicles<\/code><\/td>citizenid<\/code><\/td>Convert plate casing and JSON payloads<\/td><\/tr> datastore_data<\/code><\/td>owner<\/code><\/td>player_metadata<\/code><\/td>citizenid<\/code><\/td>If you store JSON, merge carefully<\/td><\/tr> addon_account_data<\/code><\/td>owner<\/code><\/td>player_accounts<\/code><\/td>citizenid<\/code><\/td>Map account names to QBCore banking or cash<\/td><\/tr> addon_inventory_items<\/code><\/td>owner<\/code><\/td>player_inventories<\/code><\/td>citizenid<\/code><\/td>If you move to ox_inventory<\/code>, migrate separately<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\nYou can keep custom tables. Adjust only foreign keys that reference ESX identifiers.<\/p>\n\n\n\n
Step 5. Stabilize Identifiers<\/h2>\n\n\n\n ESX often stores a CFX identifier like license:xxxx<\/code> or historical steam:xxxx<\/code>. QBCore uses citizenid<\/code> as the stable player key and keeps the runtime identifiers for authentication only.<\/p>\n\n\n\nYou will<\/p>\n\n\n\n
\nCreate a citizenid<\/code> for every player.<\/li>\n\n\n\nLink legacy identifiers to the new record.<\/li>\n\n\n\n Keep a lookup table for support and audits.<\/li>\n<\/ol>\n\n\n\nSQL bootstrap<\/h3>\n\n\n\n Run this on a copy of your ESX database to prepare QBCore tables.<\/p>\n\n\n\n
-- 1) Create players table if missing. Adjust to your QBCore schema.\nCREATE TABLE IF NOT EXISTS players (\n citizenid VARCHAR(11) PRIMARY KEY,\n license VARCHAR(64) UNIQUE,\n identifiers JSON NOT NULL,\n name VARCHAR(64),\n charinfo JSON NOT NULL,\n metadata JSON NOT NULL,\n money JSON NOT NULL,\n job JSON NOT NULL,\n position VARCHAR(128) DEFAULT NULL,\n created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;\n\n-- 2) Helper function equivalent in SQL using a deterministic generator would be complex.\n-- Instead, stage the mapping in a separate table and generate citizenid in Lua.\nCREATE TABLE IF NOT EXISTS legacy_identifier_map (\n license VARCHAR(64) PRIMARY KEY,\n steam VARCHAR(64) NULL,\n fivem VARCHAR(64) NULL,\n discord VARCHAR(64) NULL,\n xbl VARCHAR(64) NULL,\n liveid VARCHAR(64) NULL,\n citizenid VARCHAR(11) UNIQUE\n);\n\n-- 3) Seed the mapping from ESX users\nINSERT INTO legacy_identifier_map (license)\nSELECT DISTINCT REPLACE(identifier, 'identifier:', '')\nFROM users\nWHERE identifier LIKE 'license:%' OR identifier LIKE 'steam:%';\n<\/pre>\n\n\n\nGenerate citizenid and insert players in Lua<\/h3>\n\n\n\n Run once on staging. Back up first.<\/p>\n\n\n\n
-- server\/migrate_identifiers.lua\nlocal QBCore = exports['qb-core']:GetCoreObject()\n\nlocal function generateCitizenId()\n local charset = {}\n for c = 65, 90 do table.insert(charset, string.char(c)) end\n for n = 48, 57 do table.insert(charset, string.char(n)) end\n math.randomseed(GetGameTimer())\n local id = {}\n for i = 1, 11 do id[i] = charset[math.random(1, #charset)] end\n return table.concat(id)\nend\n\nlocal rows = MySQL.query.await('SELECT license FROM legacy_identifier_map WHERE citizenid IS NULL')\nfor _, r in ipairs(rows) do\n local citizenid = generateCitizenId()\n MySQL.prepare.await('UPDATE legacy_identifier_map SET citizenid = ? WHERE license = ?', { citizenid, r.license })\nend\n\n-- Build players from ESX users\nlocal users = MySQL.query.await([[SELECT u.identifier, u.firstname, u.lastname, u.dateofbirth, u.sex, u.height\n FROM users u]])\nfor _, u in ipairs(users) do\n local license = u.identifier\n local map = MySQL.single.await('SELECT citizenid FROM legacy_identifier_map WHERE license = ?', { license })\n if map and map.citizenid then\n local name = string.format('%s %s', u.firstname or 'John', u.lastname or 'Doe')\n local charinfo = json.encode({ firstname = u.firstname, lastname = u.lastname, birthdate = u.dateofbirth, gender = u.sex, height = u.height })\n local metadata = json.encode({ hunger = 100, thirst = 100 })\n local money = json.encode({ cash = 0, bank = 0, crypto = 0 })\n local job = json.encode({ name = 'unemployed', label = 'Unemployed', grade = { name = '0', level = 0 }})\n\n MySQL.prepare.await('INSERT IGNORE INTO players (citizenid, license, identifiers, name, charinfo, metadata, money, job) VALUES (?, ?, ?, ?, ?, ?, ?, ?)', {\n map.citizenid,\n license,\n json.encode({ license = license }),\n name,\n charinfo,\n metadata,\n money,\n job\n })\n end\nend\nprint('Identifier migration finished')\n<\/pre>\n\n\n\n