[Question] Mysql Query

[Rodrigo152 6]

Good afternoon everyone, can anyone help me with this problem, I would like to know why this quest is not working, I open it ingame and nothing happens.

 

quest point_exchange begin
    state start begin
        when 20082.chat."Consult Kill Points" begin
            syschat("Checking your kill points...")

            -- Querying the number of points in the ranking_de_kills column
            localresult_kills = mysql_query("SELECT ranking_de_kills FROM player WHERE id = "..pc.get_player_id())
            ifresult_kills then
                local Pontos_kills = tonumber(resultado_kills[1]) or 0
                syschat("You have " .. kill_points .. " kill points.")
            else
                syschat("Error querying kill points.")
            end
        end
    end
end

 

[KolenMG 1138]

Try this: 

 

quest point_exchange begin
    state start begin
        when 20082.chat."Consult Kill Points" begin
            syschat("Checking your kill points...")

            -- Querying the number of points in the ranking_de_kills column
            local result_kills = mysql_query("SELECT ranking_de_kills FROM player WHERE id = "..pc.get_player_id())
            
            if result_kills then
                local Pontos_kills = tonumber(result_kills[1]) or 0
                syschat("You have " .. Pontos_kills .. " kill points.")
            else
                syschat("Error querying kill points.")
            end
        end
    end
end

is untested tho. 

 

however, you have a lot of typos in it. 

resultado_kills[1] should be localresult_kills[1] to match the variable used earlier (localresult_kills). 

kill_points is not defined in your script. You likely intended to use Pontos_kills here instead.

ifresult_kills then: was wrong. 

 

Edited September 6, 2024 by KolenMG