Characters

From ArcEmu-Wiki
(Difference between revisions)
Jump to: navigation, search
(watched_faction_index)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
 +
{{LanguageLinks|Characters|EN}}
 +
 
== Description ==
 
== Description ==
  
Line 93: Line 95:
 
== selected_pvp_title ==
 
== selected_pvp_title ==
  
Selected player title (Seems to be in hash form?)
+
Selected player title (as binary flag)
  
  
 
== available_pvp_titles ==
 
== available_pvp_titles ==
  
Available titles (Seems to be in hash form?)
+
Available titles (as binary flags)
  
  
Line 138: Line 140:
  
  
== player_bytes ==
+
== player_bytes ==
 
+
Seems to hold some flags about the players client UI settings. For ex. some flags represent the status of the player action bars.
  
 
== positionX ==
 
== positionX ==
Line 339: Line 341:
  
 
== actions ==
 
== actions ==
 +
The entries in the client action bars
  
  

Latest revision as of 13:51, 6 July 2012

+/-
Main Page                   Other languages:   English  •   German   •   FrenchArcEmu Website     ArcEmu Forum     Bug Tracker


Description

This table contains all data pertaining to a base of a character.


Contents



guid

Unique character ID. Each new character gets an auto implemented sacrification id.


acct

This is the account that the character belongs to.


name

This is the characters name.


race

The Race ID of the character.

  • 1 = Human
  • 2 = Orc
  • 3 = Dwarf
  • 4 = Night Elf
  • 5 = Undead
  • 6 = Tauren
  • 7 = Gnome
  • 8 = Troll
  • 9 = Goblin
  • 10 = Blood Elf
  • 11 = Draenei


class

The Class ID of the character.

  • 1 = Warrior
  • 2 = Paladin
  • 3 = Hunter
  • 4 = Rogue
  • 5 = Priest
  • 6 = Death Knight
  • 7 = Shaman
  • 8 = Mage
  • 9 = Warlock
  • 10 = Unused
  • 11 = Druid


gender

The sex/gender of the character.

  • 0 = Male
  • 1 = Female


custom_faction

Faction player is set upon log in.


level

The current level of the designated player


xp

The total amount of xp that the signified player has.


exploration_data

skills

Skill id's you know


watched_faction_index

ToDo: Info needed

selected_pvp_title

Selected player title (as binary flag)


available_pvp_titles

Available titles (as binary flags)


gold

This is the amount of copper the character possesses.


ammo_id

available_prof_points

Number of professions points left. Can be set for more than the blizzlike default of 2 professions. Use the optional.conf to set a new max. profession default.


current_hp

How much hp you got at the moment the table is checked


current_power

How much power you got at the moment the table is checked.

You can not see if it is mana rage runic power energy


pvprank

bytes

bytes2

player_flags

player_bytes

Seems to hold some flags about the players client UI settings. For ex. some flags represent the status of the player action bars.

positionX

Position of the character relative to the map he/she is on and the map's x-axis.


positionY

Position of the character relative to the map he/she is on and the map's y-axis.


positionZ

Position of the character relative to the map he/she is on and the map's z-axis.


orientation

The direction the character is facing.


mapId

The mapId the player is in


zoneId

The zoneId the player is in


taximask

banned

Shows a character's ban status. 0 is not banned 1 is permanently banned

Can also contain a ban expiration timestamp in unixtime format. (see http://www.unixtimestamp.com/index.php for a converter)

banReason

The reason the GM has given why he/she has banned you.


timestamp

Shows the last date and time that the character was played. This data is formatted in a Unix timestamp (As example PHP - time() [1] (see http://www.unixtimestamp.com/index.php for a converter))

online

Flag system : 1 = Player is online 0 = Player is offline


bindpositionX

Where the player's hearthstone is set to on the x-axis.


bindpositionY

Where the player's hearthstone is set to on the y-axis.


bindpositionZ

Where the player's hearthstone is set to on the z-axis or the height of the position that the hearthstone is set to.


bindmapId

bindzoneId

isResting

Shows if you are resting.


restState

The resting state


restTime

How long you have rested


playedtime

Time you played on the specific character, time in the database is displayed in seconds.


deathstate

0 = alive 1 = dead


TalentResetTimes

Times you reseted your talents


first_login

Shows if it is your first login.

if it is 1 you will get the movie shown when you create a character.

if it is 0 nothing will happen


forced_rename_pending

Shows if you are forced to change your name


arenaPoints

How much arenapoints you have


totalstableslots

Shows how much stable slots you have


instance_id

Shows in which instanceid you are.


entrypointmap

entrypointx

entrypointy

entrypointz

entrypointo

entrypointinstance

taxi_path

taxi_lastnode

taxi_mountid

transporter

transporter_xdiff

transporter_ydiff

transporter_zdiff

spells

Spells you have learned


deleted_spells

A colon use to delete spells from players, because of the "spells" field's difficulty to manipulate.

Spells like older ranks of stealth should be in here.


reputation

factionId,Flags,standing,BaseStanding

row format


actions

The entries in the client action bars


actions2

auras

Used to save auras to people.List of IDs of all the auras on a player, comma separated.


finished_quests

Shows which quests you have finished


finisheddailies

Shows which dailies you have finished

honorRolloverTime

killsToday

Kills you made today


killsYesterday

Kills you made yesterday


killsLifeTime

Kills you made in your whole character history


honorToday

Honor you earned today


honorYesterday

Honor you earned yesterday


honorPoints

The amount of points displayed in a player's "honor tab".


Difficulty

The difficulty of the instance the player is located in.


DrunkValue

The value of how drunk you are.


Glyphs1

Shows which major glyphs you got.


Talents1

Shows which talents you got active


Glyphs2

Shows which minor glyphs you got.


Talents2

Shows your non-active talents.


NumSpecs

The number of specs you got.


Currentspec

Your current spec number.

0 is the standard spec.

1 is dual spec.


Talentspoint_override

phase

CanGainXP

Shows if you can gain xp.

1(default) allows you to get xp.

This is made because you can stop xp gain so you will always be the same level.


Data

SQL Structure

CREATE TABLE `characters` (
  `guid` int(6) unsigned NOT NULL DEFAULT '0',
  `acct` int(20) unsigned NOT NULL DEFAULT '0',
  `name` varchar(21) NOT NULL DEFAULT '',
  `race` smallint(3) NOT NULL,
  `class` smallint(3) NOT NULL,
  `gender` tinyint(1) NOT NULL,
  `custom_faction` int(30) NOT NULL DEFAULT '0',
  `level` int(3) NOT NULL,
  `xp` int(30) NOT NULL,
  `active_cheats` int(10) unsigned NOT NULL DEFAULT '0',
  `exploration_data` longtext NOT NULL,
  `skills` longtext NOT NULL,
  `watched_faction_index` bigint(40) NOT NULL,
  `selected_pvp_title` int(30) NOT NULL,
  `available_pvp_titles` bigint(10) unsigned NOT NULL DEFAULT '0',
  `available_pvp_titles1` bigint(10) NOT NULL,
  `gold` int(30) NOT NULL,
  `ammo_id` int(30) NOT NULL,
  `available_prof_points` int(30) NOT NULL,
  `current_hp` int(30) NOT NULL,
  `current_power` int(30) NOT NULL,
  `pvprank` int(30) NOT NULL,
  `bytes` int(30) NOT NULL,
  `bytes2` int(30) NOT NULL,
  `player_flags` int(30) NOT NULL,
  `player_bytes` int(30) NOT NULL,
  `positionX` float NOT NULL DEFAULT '0',
  `positionY` float NOT NULL DEFAULT '0',
  `positionZ` float NOT NULL DEFAULT '0',
  `orientation` float NOT NULL DEFAULT '0',
  `mapId` int(8) unsigned NOT NULL DEFAULT '0',
  `zoneId` int(8) unsigned NOT NULL DEFAULT '0',
  `taximask` longtext NOT NULL,
  `banned` int(40) unsigned NOT NULL DEFAULT '0',
  `banReason` varchar(255) NOT NULL,
  `timestamp` int(30) DEFAULT NULL,
  `online` int(11) DEFAULT NULL,
  `bindpositionX` float NOT NULL DEFAULT '0',
  `bindpositionY` float NOT NULL DEFAULT '0',
  `bindpositionZ` float NOT NULL DEFAULT '0',
  `bindmapId` int(8) unsigned NOT NULL DEFAULT '0',
  `bindzoneId` int(8) unsigned NOT NULL DEFAULT '0',
  `isResting` int(3) NOT NULL DEFAULT '0',
  `restState` int(5) NOT NULL DEFAULT '0',
  `restTime` int(5) NOT NULL DEFAULT '0',
  `playedtime` text NOT NULL,
  `deathstate` int(5) NOT NULL DEFAULT '0',
  `TalentResetTimes` int(5) NOT NULL DEFAULT '0',
  `first_login` tinyint(1) NOT NULL DEFAULT '0',
  `forced_rename_pending` tinyint(1) NOT NULL DEFAULT '0',
  `arenaPoints` int(10) NOT NULL,
  `totalstableslots` int(10) unsigned NOT NULL DEFAULT '0',
  `instance_id` int(10) NOT NULL,
  `entrypointmap` int(10) NOT NULL,
  `entrypointx` float NOT NULL,
  `entrypointy` float NOT NULL,
  `entrypointz` float NOT NULL,
  `entrypointo` float NOT NULL,
  `entrypointinstance` int(10) NOT NULL,
  `taxi_path` int(10) NOT NULL,
  `taxi_lastnode` int(10) NOT NULL,
  `taxi_mountid` int(10) NOT NULL,
  `transporter` int(10) NOT NULL,
  `transporter_xdiff` float NOT NULL,
  `transporter_ydiff` float NOT NULL,
  `transporter_zdiff` float NOT NULL,
  `spells` longtext NOT NULL,
  `deleted_spells` longtext NOT NULL,
  `reputation` longtext NOT NULL,
  `actions1` longtext NOT NULL,
  `actions2` longtext NOT NULL,
  `auras` longtext NOT NULL,
  `finished_quests` longtext NOT NULL,
  `finisheddailies` longtext NOT NULL,
  `honorRolloverTime` int(30) NOT NULL DEFAULT '0',
  `killsToday` int(10) NOT NULL DEFAULT '0',
  `killsYesterday` int(10) NOT NULL DEFAULT '0',
  `killsLifeTime` int(10) NOT NULL DEFAULT '0',
  `honorToday` int(10) NOT NULL DEFAULT '0',
  `honorYesterday` int(10) NOT NULL DEFAULT '0',
  `honorPoints` int(10) NOT NULL DEFAULT '0',
  `difficulty` int(4) NOT NULL DEFAULT '0',
  `drunkValue` int(30) NOT NULL DEFAULT '0',
  `glyphs1` longtext NOT NULL,
  `talents1` longtext NOT NULL,
  `glyphs2` longtext NOT NULL,
  `talents2` longtext NOT NULL,
  `numspecs` int(10) NOT NULL DEFAULT '1',
  `currentspec` int(10) NOT NULL DEFAULT '0',
  `talentpoint_override` longtext NOT NULL,
  `phase` int(10) unsigned NOT NULL DEFAULT '1',
  `CanGainXp` int(10) unsigned NOT NULL DEFAULT '1',
  `data` longtext,
  PRIMARY KEY (`guid`),
  KEY `acct` (`acct`),
  KEY `name` (`name`),
  KEY `b` (`banned`),
  KEY `c` (`online`),
  KEY `d` (`forced_rename_pending`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools