How to modify the price of the dual spec?

I would like to change the price of the dual spec in AzerothCore, how can I do that?

How to build the SQL query to accomplish that?

Short answer

UPDATE gossip_menu_option SET BoxMoney = XXXXXX WHERE OptionType = 18

replace with XXXXXX the actual price (in bronze) that you wish to apply. For example, for 500g it's 500x100x100 = 5000000

Explaination

If you use Keira3 and open any Gossip Menu Option, you'll see that different Option Type can be applied:

and you'll notice that 18 is what we are looking for, thus we query for OptionType = 18

You can find more info about how the tables gossip_menu and gossip_menu_options work in the official documentation:

• http://www.azerothcore.org/wiki/gossip_menu
• http://www.azerothcore.org/wiki/gossip_menu_option