Getting Spellname from ID

[Corthezz]

Hello OC,
right now I am working on making my bot for Vanilla (1.12.1) more user independent.
Currently the user has to register the spell name, the corresponding button to trigger it and the cooldown in the custom class.
Also the CC has to contain ID's for the buffs and debuffs the custom class is working with.

Since I want to get rid of it I started to work on a new solution. I know that I could handle the whole fight system easily with lua but I think my programming knowledge isnt good enough at this point (working on getting away from c# to c right now).

Right now I can read the spell ID of every spell listed in the spellbook aswell the spell ID of a spell which is placed on a specific actionbar button.
Since most spells have different ranks and I dont want the user to list thousand ID's just for one spell I have to find a way to get the name by the ID.

Right now I read all IDs in the spellbook and query http://www.aowow.org/?spell=XXXXX for every entry I get to retrieve the spellname and cost. After every run I save the retrieved data into a local file.
It works but its just not the best way. Since I couldnt find a better way until now I just would like to ask if anyone could push me in the right direction.

My next guess is to read the dbc files but I think there should be something more simple.

[Robske]

if API GetSpellInfo - WoWWiki - Your guide to the World of Warcraft exists, that's where you'll find it.

[Corthezz]

thought about using this before but like mentioned above I would need Lua DoString to get the return values.

[JuJuBoSc]

Or you can read it from Spell.dbc

[Corthezz]

Or you can read it from Spell.dbc

I took a look at the spell.dbc file before but couldnt find any name. just a bunch of numbers but I think this will be the best way so I will dig deeper.

[Frosttall]

I took a look at the spell.dbc file before but couldnt find any name. just a bunch of numbers but I think this will be the best way so I will dig deeper.

http://www.pxr.dk/wowdev/wiki/index....=Spell.dbc#Old

"124-132 sRefName String + Loc Names different then your clients localization will appear as null terminated strings "

[JuJuBoSc]

public struct SpellDBEntry
    {
        public int SpellId;
        public uint pName;
        public uint pSubName;
        public uint pDescription;
        public uint pAuraDescription;
        public int SpellRuneCostId;
        public int SpellMissileId;
        public int SpellDescriptionVariableId;
        private int Unk20;
        public int SpellScalingId;
        public int SpellAuraOptionsId;
        public int SpellAuraRestrictionsId;
        public int SpellCastingRequirementsId;
        public int SpellCategoriesId;
        public int SpellClassOptionsId;
        public int SpellCooldownsId;
        public int SpellEquippedItemsId;
        public int SpellinterruptsId;
        public int SpellLevelId;
        public int SpellReagentsId;
        public int SpellShapeshiftId;
        public int SpellTargetRestrictionsId;
        public int SpellTotemsId;
        public int ResearchProjectId;
        public int SpellMiscId;
}

current Spell.dbc

[Frosttall]

public struct SpellDBEntry
    {
        public int SpellId;
        public uint pName;
        public uint pSubName;
        public uint pDescription;
        public uint pAuraDescription;
        public int SpellRuneCostId;
        public int SpellMissileId;
        public int SpellDescriptionVariableId;
        private int Unk20;
        public int SpellScalingId;
        public int SpellAuraOptionsId;
        public int SpellAuraRestrictionsId;
        public int SpellCastingRequirementsId;
        public int SpellCategoriesId;
        public int SpellClassOptionsId;
        public int SpellCooldownsId;
        public int SpellEquippedItemsId;
        public int SpellinterruptsId;
        public int SpellLevelId;
        public int SpellReagentsId;
        public int SpellShapeshiftId;
        public int SpellTargetRestrictionsId;
        public int SpellTotemsId;
        public int ResearchProjectId;
        public int SpellMiscId;
}

current Spell.dbc

He is on 1.12.1...

[Robske]

Look at the function I posted earlier in your favorite disassembler to figure out how WoW does it, then do it yourself..

[Corthezz]

Look at the function I posted earlier in your favorite disassembler to figure out how WoW does it, then do it yourself..

I will. Oh forgot ... I got like zero knowledge about disassembling but I will take a look.
Juju: No name in spell.dbc:

https://i.imgur.com/6ILaYQ9.jpg

[JuJuBoSc]

He is on 1.12.1...

I should have read the post entirely ..

[TOM_RUS]

I will. Oh forgot ... I got like zero knowledge about disassembling but I will take a look.
Juju: No name in spell.dbc:

https://i.imgur.com/6ILaYQ9.jpg

You doing it wrong. Spell name is in Spell.dbc for sure.

[Natrist]

You doing it wrong. Spell name is in Spell.dbc for sure.

The problem is in the software you're using. Download MyDBCEditer --and yes, it is spelled right.

[Master674]

The problem is in the software you're using. Download MyDBCEditer --and yes, it is spelled right.

Nope he is just not defining the types properly.

[Sacred]

Dump spells from the game, then store it in plain text format (for example 122;Frost Nova), at runtime read it to dictionary where id is key and name is value. You'll never need to update this data, because you'll never have a new patch for the game.

Btw, for 1.12.1 Spellname field is 120 in Spell.dbc.