Playercreateinfo

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table is what holds all the new character creation data. Class, Race, Faction, Starting Location is just some of things you will find in this table.

Contents



Fields

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.


Race

This is the race data for that indexID.

1 - HUMAN

2 - ORC

3 - DWARF

4 - NIGHTELF

5 - UNDEAD

6 - TAUREN

7 - GNOME

8 - TROLL

9 - GOBLIN

10 - BLOODELF

11 - DRAENEI


Factiontemplate

The default factions the Index will begin with.

1 - HUMAN

2 - ORC

3 - DWARF

4 - NIGHTELF

5 - UNDEAD

6 - TAUREN

115 - GNOME

116 - TROLL

?? - GOBLIN

1610 - BLOODELF

1629 - DRAENEI

class

The class ID of this Index (race/class template)


1 - Warrior

2 - Paladin

3 - Hunter

4 - Rogue

5 - Priest

6 - Death knight

7 - Shaman

8 - Mage

9 - Warlock

11 - Druid


MapID

The MAP ID of the starting location of the class/race template. (Index)

0 - Eastern Kingoms

1 - Kalimdor

530 - Outlands/Silvermoon/Exodar

571 - Northrend

609 - Ebon Hold


ZoneID

The ZONE ID of the starting location of the class/race Template. (Index)

You can find the x,y,z MapID, zoneID of place by using the .gps command.


PositionX

This is the first part of a WoW location. (North/South)


PositionY

This is the second part of a WoW location. (West/east)


PositionZ

This is the height portion of the WoW location. (up/down)


DisplayID

This is the blank Male/Female Model for that Race/Facial features you pick out.

49 = Human

51 = Orc

53 = Dwarf

55 = NIGHTELF

57 = UNDEAD

59 = TAUREN

1563 = Gnome

1478 = TROLL

????? = GOBLIN

15476 = BLOODELF

16125 = DRAENEI

BaseStrength

The base(starting) Strength of this Index (class/race template)


BaseAgility

Base Agility


BaseStamina

Base Stamina


BaseIntellect

Base Intellect


BaseSpirit

Base Spirit


BaseHealth

Base Health


BaseMana

Base Mana


BaseRange

Base Range


BaseFocus

Base Focus


BaseEnergy

Base Energy


Attackpower

Base Attack power


Mindmg

Minimum natural base damage before adding weapons and skills.


Maxdmg

Maximum natural base damage before adding weapons and skills.


introid

? ToDo


taximask

? ToDo


SQL Schema

CREATE TABLE `playercreateinfo` (
  `Index` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  `race` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `factiontemplate` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `class` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `mapID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `zoneID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `positionX` FLOAT NOT NULL DEFAULT '0',
  `positionY` FLOAT NOT NULL DEFAULT '0',
  `positionZ` FLOAT NOT NULL DEFAULT '0',
  `displayID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `BaseStrength` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `BaseAgility` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `BaseStamina` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `BaseIntellect` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `BaseSpirit` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `BaseHealth` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `BaseMana` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `BaseRage` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `BaseFocus` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `BaseEnergy` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `attackpower` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `mindmg` FLOAT NOT NULL DEFAULT '0',
  `maxdmg` FLOAT NOT NULL DEFAULT '0',
  `introid` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `taximask` tinytext,
  PRIMARY KEY  (`Index`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=latin1 COMMENT='Player System'
Personal tools