Achievement points

[Rodrigo152 4]

Good afternoon guys, I have this quest for achievement points, where you exchange points for a certain item, but it's not working. Can someone help me

 

quest point_change begin
    state start begin
        when 20082.chat."Exchange Points" with pc.getqf("exchange_access") == 1 begin
            -- Simulating that there is a mysql_query function that queries the database.
            local result_achievement = mysql_query("SELECT ranking_of_boss FROM player WHERE id = "..pc.get_player_id())
            local points_achievement = result_achievement[1] -- Assuming that the result is a table where the first element is the desired value.
            local result_kills = mysql_query("SELECT ranking_kills FROM player WHERE id = "..pc.get_player_id())
            local points_kills = result_kills[1]

            say("Welcome to the points exchange system!")
            say("You can exchange your achievement points and kills for valuable items here.")
            local s = select("Exchange achievement points", "Exchange kill points", "Cancel")
            
            if s == 1 then
                say("You have " .. conquest_points .. " conquest points.")
                say("Every 10 points can be exchanged for 1 Big Red Potion.")
                if achievement_points >= 10 then
                    local choice = select("Exchange 10 points for 1 Potion", "Cancel")
                    if choice == 1 then
                        -- Assuming the item can be added directly to the player's inventory.
                        pc.give_item2("ITEM_ID_POT_GREEN", 1)
                        -- Updating the database directly
                        mysql_query("UPDATE player SET ranking_of_boss = ranking_of_boss - 10 WHERE id = "..pc.get_player_id())
                        say("Exchange successful!")
                    end else
                else
                    say("You don't have enough points.")
                end else
            elseif s == 2 then
                say("You have " .. points_kills .. " kill points.")
                say("Every 15 points can be exchanged for 1 War Armor.")
                if points_kills >= 15 then
                    local choice = select("Exchange 15 points for 1 Armor", "Cancel")
                    if choice == 1 then
                        pc.give_item2("ITEM_ID_ARMADURA_GUERRA", 1)
                        mysql_query("UPDATE player SET ranking_of_kills = ranking_of_kills - 15 WHERE id = "..pc.get_player_id())
                        say("Exchange successful!")
                    end else
                else
                    say("You don't have enough points.")
                end
            end
        end
    end
end