How to get data from mysql

Sezo38 · 2019-04-21T18:04:14.556Z

Hey guys i have a question.
I have mysql-async, async and esplugin_mysql.

My problem is, I don’t know how to get data from mysql. It has to be the same identifier like the player has you know.

Already put data in mysql with that code:

MySQL.Async.fetchAll("INSERT INTO team (identifier, team) VALUES(@identifier, @team)", {["@identifier"] = user.getIdentifier(), ["@team"] = 'normal'},
        function (result) end)

Would be great if someone could tell me that.
Thanks

TheIndra · 2019-04-21T18:25:14.988Z

SELECT team FROM team WHERE identifier = @identifier`

or team can also be * if you don’t care what columns you receive

Sezo38 · 2019-04-21T18:31:58.245Z

thank you.
And how can I for example print out the result which team he is?

MySQL.Async.fetchAll("SELECT team FROM team WHERE identifier = @identifier", {["@identifier"] = identifier},
        function (result) 
            print(result[1])
        end)

the print gives me: table: 0000021… (a hexvalue)

TheIndra · 2019-04-21T18:35:13.501Z

either

print(result[1].team)

Or use fetchScalar and then just print result

Sezo38 · 2019-04-21T19:01:07.713Z

can you tell me why the result is showing me nil if I call the function?

TriggerEvent('es:getPlayerFromId', source, function(user)
        local team = getPlayerTeam(user.getIdentifier())
        if team == 'normal' then
            print("Your Team: normal")
        elseif team == nil then
            print("Your Team: nil")
        else
            print("Your Team: error")
        end
   end)

It tells me, your team: nil

code from the function…

Summary

function getPlayerTeam(identifier)
    if identifier ~= nil and type(identifier) == "string" then
        local team
        MySQL.Async.fetchAll("SELECT team FROM team WHERE identifier = @identifier", {["@identifier"] = identifier},
        function (result)
            print(result[1].team)
            team = result[1].team
        end)
        return team
    else
        print("Error occurred while checking existance user, missing parameter or incorrect parameter: identifier")
    end
end

TheIndra · 2019-04-21T19:03:49.340Z

Async.fetchAll returns an callback so if you return after the function it will run before the query is finished running either use sync or call another callback from your mysql callback

Sezo38 · 2019-04-21T19:12:09.289Z

how do you mean call another callback from my mysql callback
sorry

TheIndra · 2019-04-21T19:31:36.699Z

Sezo38:

MySQL.Async.fetchAll("SELECT team FROM team WHERE identifier = @identifier", {["@identifier"] = identifier}, 
function (result) print(result[1].team) 
    team = result[1].team 
end) 
return team

The return team is done directly, it doesn’t wait until the code in the function(result) is done executing

so either use MySQL.Sync or let your getPlayerTeam() function have an callback which you then call and put the team code inside

Sezo38 · 2019-04-21T21:29:27.301Z

Thank you, it worked.
I paste the code here in, for others that have the same problem.

function getPlayerTeam(identifier, callback)
    if identifier ~= nil and type(identifier) == "string" then
        MySQL.Async.fetchAll("SELECT team FROM team WHERE identifier = @identifier", {["@identifier"] = identifier}, 
        function (result)
            if result[1] then callback(result[1].team) 
            else callback(nil) end
        end)
    else
        print("Error occurred while checking existance user, missing parameter or incorrect parameter: identifier")
    end
end

TriggerEvent('es:getPlayerFromId', source, function(user)
        local team
        getPlayerTeam(user.getIdentifier(), function(team)
            if team == nil then
                print("Error occurred while checking the team of the player. Value is nil.")
                return
            else
                print("Your team is: "..team)
            end
        end)
   end)