如何刷新从数据库中获取的表格(FiveM Lua)

我正在尝试创建一个脚本,任何人都可以用/createmafia命令在指定位置创建黑手党。

问题是,我将数据插入到数据库中,但当我将新的mafiajob设置到玩家时,它会忽略它,因为es_extended脚本无法在ESX.MafiaJobs表中找到该工作,该表在每次服务器重新启动时获取。

我可以在执行setjob命令之前强制重新从数据库获取数据吗?

这是我正在使用的函数:

function createmafia(mafia, identifier, grade)

    MySQL.Async.execute('INSERT INTO mafiajobs (name, identifier, label) VALUES (@name, @identifier, @label)',{
        ['@name'] = mafia,
        ['@identifier'] = identifier,
        ['@label'] = mafia
    }, function() end)

    MySQL.Async.execute('INSERT INTO mafiajob_grades (mafiajob_name, mafiagrade, name, label, identifier) VALUES (@mafiajob_name, @mafiagrade, @mafiagradename, @mafiagradelabel, @identifier)',{
        ['@mafiajob_name'] = mafia,
        ['@mafiagrade'] = grade,
        ['@mafiagradename'] = 'boss',
        ['@mafiagradelabel'] = 'Αφεντικό',
        ['@identifier'] = identifier
    }, function() end)

    MySQL.Async.execute('UPDATE users SET mafiajob = @mafiajob, mafiajob_grade = @mafiajob_grade WHERE identifier =  @identifier ',{
        ['@identifier'] = identifier,
        ['@mafiajob_grade'] = grade,
        ['@mafiajob'] = mafia
    }, function() end)

    local xPlayer = GetPlayerFromIdentifier(identifier)
    xPlayer.setMafiaJob(mafia, grade)

end
点赞