Alright, well, I’m not too good with introductions, so I’ll be short.
This script is a tool that allows you to doublecheck what is currently in the spell_dbc table, looking at ONE entry. It also does provide a way for DB devs to doublecheck some spells that are being created, as we all know that numbers aren’t that much explanatory.
There are two possible usages:
-
Fetch an entry from the
spell_dbctable and analyze it. -
Paste a SQL INSERT INTO request that has to insert only ONE record in the table, and analyzes it.
Alright, now, onwards to the source. This little project needs three files. You don’t need to edit anything else that the four define lines in index.php
index.php
defines.inc.php
spell.class.php
An example ? Sure.
Mode: Check an existing spell Check a
spell_dbcINSERT queryDisplayingspell_dbcentry with Id 68308; « Vault of Archavon - Earth, Wind & Fire - Achievement Check »
Dispel: 0 (DISPEL_NONE)
Prevention Type: 0 (PREVENTION_TYPE_NONE)
SpellFamilyName: SPELLFAMILY_GENERIC SpellFamilyFlags :0x00000000 0x00000000 0x00000000
DamageClass: SPELL_DAMAGE_CLASS_NONE
SpellSchoolMask: SPELL_SCHOOL_MASK_NONE
Attributes: 0x09800100 (SPELL_ATTR0_HIDE_IN_COMBAT_LOG, SPELL_ATTR0_CASTABLE_WHILE_DEAD, SPELL_ATTR0_CASTABLE_WHILE_MOUNTED, SPELL_ATTR0_CASTABLE_WHILE_SITTING)
AttributesEx2: 0x00000000
AttributesEx3: 0x00000000
AttributesEx4: 0x00000000
AttributesEx5: 0x00000000
AttributesEx6: 0x00000000
AttributesEx7: 0x00000000
Effect #1: SPELL_EFFECT_DUMMY
Real BasePoints: 0
Multiple BasePoints: 0
Targets: 1;0 (TARGET_UNIT_CASTER, TARGET_NONE)
Mechanic: 0 (MECHANIC_NONE)
RadiusIndex: 0
Amplitude: 0
MiscValue: 0
MiscValueB: 0
SpellClassMask: 0x00000000 00000000 00000000
Effect #2: NONE
Effect #3: NONE
Planned features:
-
Some more info, depending on the type of effect / aura
-
spell_dbcentry generator.