Playercreateinfo spells

From ArcEmu-Wiki
Revision as of 23:01, 15 July 2010 by Eatos (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

This table is used to generate starting spells for characters.

Index

The record's index number. There is so many , because of race/class combinations. Each seperate race and class has it's own Index number.

Contents



INDEX ID CLASS/RACE COMBOS


HUMANS-----

Warrior- 1 Paladin- 9 Rogue- 18 Priest- 25 Mage- 34 Warlock- 38 Deathknight- 56


DWARF-----

Warrior- 3 Paladin- 10 Hunter- 12 Rogue- 20 Priest- 26 Deathknight- 58


NIGHT ELF-----

Warrior- 4 Hunter- 15 Rogue- 21 Priest- 27 Druid- 42 Deathknight- 59


GNOME-----

Warrior- 7 Rogue- 23 Mage- 36 Warlock- 41 Deathknight- 62


DRAENEI-----

Warrior- 44 Paladin- 45 Hunter- 46 Priest- 47 Shaman- 48 Mage- 49 Deathknight- 64


ORC-----

Warrior- 2 Hunter- 11 Rogue- 19 Shaman- 30 Warlock- 39 Deathknight- 57


UNDEAD-----

Warrior- 5 Rogue- 22 Priest- 28 Mage- 35 Warlock- 40 Deathknight- 60


TAUREN-----

Warrior- 6 Hunter- 16 Shaman- 31 Druid- 43 Deathknight- 61


TROLL-----

Warrior- 8 Hunter- 17 Rogue- 24 Priest- 29 Shaman- 32 Mage- 37 Deathknight- 63


BLOOD ELF-----

Paladin- 50 Hunter- 51 Rogue- 52 Priest- 53 Mage- 54 Warlock- 55 Deathknight- 65

SQL Structure

CREATE TABLE `playercreateinfo_spells` (
  `indexid` tinyint(3) unsigned NOT NULL default '0',
  `spellid` smallint(5) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Player System'

UPDATE

By Eatos

Personal tools