Understanding custom Auras similar to Blessing of Kings

Custom Code and Mods Custom Code and Requests
1

I’m wanting to add a bunch of custom Auras that are server-side only and don’t need any visibility the the client. My original post has more details on my overall goal:

https://community.trinitycore.org/topic/12663-hook-to-execute-custom-code-on-player-entry-or-exit-of-any-instance/

The trouble I’m having is understanding what needs to happen in the database to create a custom Aura. So I started with an Aura that is close to one that I’m shooting for like Blessing of Kings:

http://www.wowhead.com/spell=20217/blessing-of-kings

In my test code I know I can use 20217 and it correctly applies the buff to players but I can’t figure out how it works because 20217 isn’t in the spell_dbc table. How is Blessing of Kings / 20217 represented in the database?

What would be the database change steps to create a custom, server-side only aura that would apply a multiplier to the players HP?

Is there a sister tool to TrinityCore that helps build the spell database inserts?

2

you might take a look at this tool: https://github.com/stoneharry/Spell-Editor-GUI-V2

Also take a look at the Keira tool from the forums as it helps you creating database inserts and has been very useful for me.