Search the Community

Hello everyone. I have a small question about how can I access the spell ID`s used by creatures? In world database in creature_template table there is spell1, spell2, ... spell8 values wich correspond to spells wich I will be able to use when this creature is under Mind Control (as stated in wiki), but these values are set for creatuers up to level ~60 and for creatures from 70-80 none creatures have their spell1 .. spell8 set to any value. So my question is essentialy is where can I obtain the spell ID`s used by cretures? Obviously the creatures in 70-80 range have spell and they use them, but I dont see any values in world database and may be these spell lists come from dbc or something? I would realy appreciate any help

Hey, first of all, sorry if this is the wrong place for my question, i didn't know where should i try to get help.. I've made a new NPC on my server (I'm using Jeutie's Repack), i've made a new equipment in creature_equip_template, and when i'm trying to write my equipment id under the column "equipment_id" it always says: SQL Error (1264): Out of range value for column 'equipment_id' at row 1 I tried to figure out what's the max range value, and it looks like it's 127. If i write 128 or more the error appears. Any idea how can i fix it, or how can i change the max value? I had already used Jeutie's Repack - Trinitycore before a few years ago, and as I remember there was no problem like this at all..