我的代码无法将数据插入数据库

function registerAccount(login, password, email, reference)
    local checkUsername = exports.TR_mysql:query("SELECT UID FROM `dhiran` WHERE `login` = ? LIMIT 1", login)
    if checkUsername and checkUsername[1] then
        triggerClientEvent(client, "loginResponseServer", resourceRoot, "Já existe um usuário com esse tipo de login.", "error")
        return
    end

    local serial = getPlayerSerial(client)
    local checkSerial = exports.TR_mysql:query("SELECT UID FROM `dhiran` WHERE `serial` = ? LIMIT 1", serial)
    if checkSerial and #checkSerial == 2 then
        triggerClientEvent(client, "loginResponseServer", resourceRoot, "Você já esgotou o limite de criação de contas em uma série(2).", "error")
        return
    end

    local checkEmail = exports.TR_mysql:query("SELECT UID FROM `dhiran` WHERE `email` = ? LIMIT 1", email)
    if checkEmail and checkEmail[1] then
        triggerClientEvent(client, "loginResponseServer", resourceRoot, "Este e-mail já está atribuído a uma conta.", "error")
        return
    end

    local referenceUID = false
    if reference then
        referenceUID = teaDecodeBinary(reference, "XayDpN36bGKGvfbD")
        if tonumber(referenceUID) == nil or string.len(referenceUID) < 1 then
            triggerClientEvent(client, "loginResponseServer", resourceRoot, "O código de referência é inválido.", "error", "reference")
            return
        end
    end

    exports.TR_mysql:query("INSERT INTO dhiran (login, password, email, serial, createIP, position, referencedPlayer, money, phoneBlocked) VALUES (?, ?, ?, ?, ?, ?, ?, ?, '[[]]')", login, passwordHash(password, "bcrypt", {}), email, getPlayerSerial(client), getPlayerIP(client), settings.spawnPositions[math.random(1, #settings.spawnPositions)], referenceUID and referenceUID or false, referenceUID and 500 or 0)
    triggerClientEvent(client, "loginResponseServer", resourceRoot, false, "success", "accountCreate")
end
addEvent("registerAccount", true)
addEventHandler("registerAccount", resourceRoot, registerAccount)

我的代码无法将数据插入数据库,它说该登录名已经存在,但实际上并没有。我已经尝试了几个小时来解决这个问题,但是无济于事。

请帮帮我 <3

原文链接 https://stackoverflow.com/questions/69804341

点赞