Project Skyfire - User contributions [en]

User talk:Akspa420

2011-09-25T10:01:14Z

Marqin: Created page with "{{Welcome|--~~~~}}"

{{Welcome|--[[User:Marqin|Marqin]] [[User_talk:Marqin|talk]] 05:01, 25 September 2011 (CDT)}}

Main Page

2011-09-20T17:20:10Z

Marqin: redesign

{| id="mp-topbanner" style="width:100%; margin:1.2em 0 6px 0; border:1px solid #ddd;"
| style="width:61%; color:#000;" |
{| style="width:100%; border:none; background:none;"
| style="width:280px; text-align:center; white-space:nowrap; color:#000;" |
<div style="top:+0.2em; font-size:95%;">Languages: English | [[Main Page/pl|Polski]] | [[Main Page/de|Deutsch]] | [[Main Page/es|Español]] | [[Main Page/it|Italiano]] | [[Main Page/ru|Pусский]]</div>
|}
|}

{| id="mp-topbanner" style="width:100%; background:#f9f9f9; margin:1.2em 0 6px 0; border:1px solid #ddd;"
| style="width:61%; color:#000;" |
{| style="width:100%; border:none; background:none;"
| style="width:280px; text-align:center; white-space:nowrap; color:#000;" |
<div style="font-size:162%; border:none; margin:0; padding:.1em; color:#000;">Welcome to [[Project Skyfire]] wiki!</div>
<div style="top:+0.2em; font-size:95%;">We have [[Special:Statistics|{{NUMBEROFARTICLES}}]] articles. [[Special:UserLogin|Join]] and feel free to improve us.</div>
|}
|}

{| align="right"
|-
| __TOC__
|}
=== NOTICE ===
Due to the spammers and vandals only trusted users may edit or create pages. Ask for Wiki edit access via IRC or a forum PM.

The wiki is under a heavy construction.

Some links may appear dead or some pages may be incomplete.

For now, as well as the structure is the same, refer to [http://www.trinitycore.info Trinity's Wiki]

== Getting started : Install the server ==
* [[Installation (Windows)]]
* [[Installation (Linux)]]
* [[Installation (Mac OS X)]]

== Getting started: Install SkyFireRedirect ==
* [[SkyFireRedirect Installation (Windows)]]
* [[SkyFireRedirect Installation (Mac OS X)]]

== Development ==
* [[Linux GDB Debugging]]
* [[Opcode list]]
* [[Todo-list]]
* [[DB Milestones|Database Milestones]]
* [[Reporting Bugs|Reporting Bugs]]
* [[DBC_Files|DBC Files]]
* [[IRC_Rules|IRC Rules]]

== SkyFire Database Structure ==
Database and Table Structures 
Supported client: 4.0.6a Build (13623)
* [[Description of the SkyFire `world` database structure]]
* [[Description of the SkyFire `characters` database structure]]
* [[Description of the SkyFire `auth` database structure]]

{{Pp-vandalism}}

Instalacja (Linux)

2011-09-18T21:02:10Z

Marqin: moved Instalacja (Linux) to Installation (Linux)/pl

#REDIRECT [[Installation (Linux)/pl]]

Русскоязычный раздел

2011-09-18T21:00:24Z

Marqin: moved Русскоязычный раздел to Main Page/ru

#REDIRECT [[Main Page/ru]]

Italiano

2011-09-18T20:59:25Z

Marqin: moved Italiano to Main Page/it

#REDIRECT [[Main Page/it]]

Español

2011-09-18T20:58:52Z

Marqin: moved Español to Main Page/es

#REDIRECT [[Main Page/es]]

Deutsch

2011-09-18T20:58:31Z

Marqin: moved Deutsch to Main Page/de

#REDIRECT [[Main Page/de]]

Polski

2011-09-18T20:57:57Z

Marqin: moved Polski to Main Page/pl

#REDIRECT [[Main Page/pl]]

Creature speech

2011-09-18T20:57:03Z

Marqin: decat

This is step-by-step guide to make your creature talking.

1. Get the text. You can use wowpedia for that ([http://www.wowpedia.org/Sinestra_%28tactics%29 example]).

2. Get speech entries. They can be found in dbc, which you could explore by using any utility that reads dbc - for example, [https://github.com/Sovak/DBC-Viewer dbc-viewer] or [http://depositfiles.com/ru/files/z94ney371 dbc-util] (simplier in use). Just read with chosen utility `SoundEntries.dbc` and find entries. For bosses, that could be done just by doing text search of boss-name. For example, for Sinestra, with dbc-util, you firstly convert dbc to csv, then open it in excel and `ctrl-f -> Sinestra -> enter`. From that entries you will need two fields: speech-sound-id and speech-sound-name, they are 1st and 3rd columns correspondingly.

3. Associate texts with sounds. Now you need to dive into the client mpq-files. You can use [http://www.zezula.net/en/mpq/download.html mpq-editor] for that. Just try different mpq's until you find your creature somewhere in Sounds/creatures/. In target-creature's folder you will see sound files named just as values of speech-sound-name field from step 2. Listen to this files and put in correspondence texts with speech-sound-id's.

Now if you want to make speech random appearing in game, or prepare it for manual invoking from C++ code, you should firstly add speech-data in `creature_text` table.
In `entry` you should put creature-entry, in `id` - relative index of speech phrase (for later use from C++ code), in `groupid`
- indexes that describe phrase's group (if are the same for two rows within same creature, then both phrases appear at one time),
in `sound` - speech-sound-id, in `text` - associated text, in `probability` - probability of appearing randomly in game (0 for manual-only usage).

Example:
<pre>
DELETE FROM `creature_text` WHERE `entry` = 45213;
INSERT INTO `creature_text`
(`entry`,`id`,`sound`,`text`)
VALUES
(45213, 0, 20199 -- aggro
, 'We were fools to entrust an imbecile like Cho''gall with such a sacred duty. I will deal with you intruders myself!'),
(45213, 1, 20200 -- death
, 'Deathwing... I have fallen... the brood... is lost...'),
...

UPDATE `creature_text` c
SET `probability` = 0,
`groupid` = c.`id`,
`type` = 1
WHERE `entry` = 45213;
</pre>

To invoke speech from C++ you could use CreatureAI::Talk method (pass `creature_text`.`id` into it).

[[Category:Guides]]

Creature ai scripts SF

2011-09-18T20:56:49Z

Marqin: decat

{| align="right"
|-
| __TOC__
|}

{{Back-to:World}}

 <big>'''The `creature_ai_scripts` table'''</big>

A full description is in the [[How-to:EventAI|How to EventAI]] guide.

 <big>'''Structure'''</big>

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#id|id]]
| int(11)
| unsigned
| PRI
| NO
| NULL
| Auto Increment
| Identifier
|-
| [[#creature_id|creature_id]]
| int(11)
| unsigned
|
| NO
| 0
|
| Creature Template
|-
| [[#event_type|event_type]]
| tinyint(5)
| unsigned
|
| NO
| 0
|
| Event Type
|-
| [[#event_inverse_phase_mask|event_inverse_phase_mask]]
| int(11)
| signed
|
| NO
| 0
|
| Mask which phases
|-
| [[#event_chance|event_chance]]
| int(3)
| unsigned
|
| NO
| 100
|
|
|-
| [[#event_flags|event_flags]]
| int(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#event_param1|event_param1]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#event_param2|event_param2]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#event_param3|event_param3]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#event_param4|event_param4]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_type|action1_type]]
| tinyint(5)
| unsigned
|
| NO
| 0
|
| Action Type
|-
| [[#action_param1|action1_param1]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_param2|action1_param2]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action1_param3|action1_param3]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_type|action2_type]]
| tinyint(5)
| unsigned
|
| NO
| 0
|
| Action Type
|-
| [[#action_param1|action2_param1]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_param2|action2_param2]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_param3|action2_param3]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_type|action3_type]]
| tinyint(5)
| unsigned
|
| NO
| 0
|
| Action Type
|-
| [[#action_param1|action3_param1]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_param2|action3_param2]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#action_param3|action3_param3]]
| int(11)
| signed
|
| NO
| 0
|
|
|-
| [[#comment|comment]]
| varchar(255)
| signed
|
| NO
| NULL
|
| Event Comment
|}

 <big>'''Description of the fields'''</big>

==== id ====

creature_id * 100
Example: creature_id = 28600 -> id = 2860000

==== creature_id ====

[[Creature template tc2#entry|entry]] of the creature.

==== event_type ====

A list of event types EventAI is able to handle. Each event type has its own specific interpretation of the params that accompany it. Params are always read in the ascending order (from Param1 to Param3). Events will not repeat until the creature exits combat or unless EFLAG_REPEATABLE is set. Some events such as EVENT_T_AGGRO, EVENT_T_DEATH, EVENT_T_SPAWNED, and EVENT_T_EVADE cannot repeat.
{| border="1"
|-
| '''Value'''
| '''Coment'''
|-
| 0
| EVENT_T_TIMER
|-
| 1
| EVENT_T_TIMER_OOC
|-
| 2
| EVENT_T_HP
|-
| 3
| EVENT_T_MANA
|-
| 4
| EVENT_T_AGGRO
|-
| 5
| EVENT_T_KILL
|-
| 6
| EVENT_T_DEATH
|-
| 7
| EVENT_T_EVADE
|-
| 8
| EVENT_T_SPELLHIT
|-
| 9
| EVENT_T_RANGE
|-
| 10
| EVENT_T_OOC_LOS
|-
| 11
| EVENT_T_SPAWNED
|-
| 12
| EVENT_T_TARGET_HP
|-
| 13
| EVENT_T_TARGET_CASTING
|-
| 14
| EVENT_T_FRIENDLY_HP
|-
| 15
| EVENT_T_FRIENDLY_IS_CC
|-
| 16
| EVENT_T_MISSING_BUFF
|-
| 17
| EVENT_T_SUMMONED_UNIT
|-
| 21
| EVENT_T_REACHED_HOME
|-
| 22
| EVENT_T_RECEIVE_EMOTE
|-
| 23
| EVENT_T_BUFFED
|-
| 24
| EVENT_T_TARGET_BUFFED
|}

==== event_inverse_phase_mask ====
Mask with phases this event should NOT trigger in*

== Working with Phases ==

Working with phases requires a certain amount of math. You will have to know a few things before we begin.

#You should have an idea of how many phases the NPC will have.
#You will have to know Binary Addition. Don't worry, I'll show you how to do it.

- '''Binary Addition''' -

<tt></tt>

*<tt>0110 = 6 (base 10)</tt>
*<tt>0111 = 7 (base 10)</tt>
*<tt>____ = __</tt>
*<tt>1101 = 13 (base 10)</tt>

<tt> </tt>

*<tt>07 06 05 04 03 02 01 00 <-- '''The place values.'''</tt>
*<tt>64 32 16 08 04 02 01 00 <-- '''Note how it doubles in size.''' '''''This''''' is what you add.</tt>

<tt>_</tt>

*<tt>_1 __ 1 __ 1</tt>
*<tt>04 + 02 + 01 = 07.</tt>

<tt>_</tt>

*<tt>_1 __ 0 __ 1 __ 1 __ 0 <-- Note how place 1, 2, and 4 are '''''1''''', but place 3 is not.</tt>
*<tt>08 + 04 + 02 + 01 + 00 = 11.</tt>

<tt>So you add 1, 2, and 8 together to get 11. You do not add the 4, because its bit was a 0. </tt>

__ __ __

''Now back to Phases''.

The overall concept (not method, just yet!) of a phase, is a "section" of activities that the NPC will act on. Hypothetically speaking, if a boss uses Attack "X" only when above 50% health, and only uses attack "Y" only when below 50% health, the boss will be using two different phases.

'''''The concept:''''' The "event_inverse_phase_mask" field is the field controlling phase information. Read the following sentence very carefully and memorize it. ''The number in this field represents the phases that this action'' '''''will not''''' ''be initiated in,'' including up to and less than the NPC's total number of phases. Keep this in the back of your head. The reason for this is because this number also casually tells the script how many phases the NPC has. It's surprisingly ingenious.

 This is where the Binary Addition comes into play. Suppose your NPC has three phases. It will start off in phase 1. ('''''*''''') It will remain in phase 1 unless specifically told to by Action Types 22, 23, 30, and 31, which control phases mid-game once the script is already running.

'''''*''''' (''I should mention right here that anything with an event_inverse_phase_mask of'' '''''0''''' ''will happen in'' '''all''' ''phases.'')

Suppose we wanted to have an attack that is only used in the NPC's first phase. You know that the NPC will have three phases. You would set up the attack as usual, but in the event_inverse_phase_mask field, you would put a '''6'''. Why the six? Let's take a look.

We have three phases. We will represent these like this: <tt></tt>

*<tt>_3__2__1__<-- ''Represents the Phase Number and the bit.''</tt>
*<tt>04 02 01</tt>

Phase 1's bit is 1. Phase 2's bit is 2. Phase 3's bit is 4. (If we had a phase 4, it would be 8, and phase 5 would be 16, etc.) To get ''6'', we have added the 2 and the 4 from the 2nd and 3rd phases. As was mentioned above, the number that goes into that field represents the bitmask of the phases that the action will ''not'' take place in.

== Quick Phase Reference ==

This list is for an easy reference of what phase equates to what number, if you're not very phase-savvy. The '''"Value"''' column is what goes into the "event_inverse_phase_mask" field. The '''"Phase"''' column indicates the phase number that the hypothetical mob or boss is in that the event '''''WILL''''' happen in. This field relies on the next field, the '''"Max Phases"''' field. That is the amount of total phases the mob has. (I.e. my boss has 2 phases, or my boss has 4 phases.) Then there is a '''description''' field for any numerical work involved. It is the least important field, and can safely be ignored.

Remember, anything with "0" as a phase will occur in all phases. It is 0 by default.

Again, this is based on the following number patterns:

00 + 01 + 02 + 03 + 04 + 05 + 06 + 07 + 008 - Represents Phases.

00 + 01 + 02 + 04 + 08 + 16 + 32 + 64 + 128 - The numerical representations of those phases.

And, once again, how this works, is:

#You look at the total number of phases. Suppose it's 3.
#You cover up all the numbers to the right of phase 3, which corresponds to the 04 right below it.
#Then you decide which phase you want the event to occur in.
#Then you look at ''all other phases,'' and add up the number beneath them.
#The number you come up with goes in the "Value" field below in that chart, and what will go into the event_inverse_phase_mask field.

==== event_chance ====

Chance to done this event, it's shuld be bettwen 1-100.

==== event_flags ====

{| border = 1 cellpadding=3 cellspacing=0
! Bit / Value !! Name !! Description
|-
| 0 / 1 || EFLAG_REPEATABLE || Event repeats (Does not repeat if this flag is not set)
|-
| 1/2 || EFLAG_NORMAL || Event only occurs in Normal instance difficulty
|-
| 2/4 || EFLAG_HEROIC || Event only occurs in Heroic instance difficulty
|-
| 7/128 || EFLAG_DEBUG_ONLY || Not yet impletmented!
|}

==== event_param1 ====

{{field-no-description|7}}

==== event_param2 ====

{{field-no-description|8}}

==== event_param3 ====

{{field-no-description|9}}

==== event_param4 ====

{{field-no-description|10}}

==== action_type ====

A list of action types that EventAI can handle.
Each event type has its own specific interpretation of it's params, like every event type.

{| border="1" cellspacing="0" cellpadding="5"
|-
| '''#'''
| '''Internal name'''
| '''action*_param1'''
| '''action*_param2'''
| '''action*_param3'''
| '''Description'''
|-
| 0
| ACTION_T_NONE
| No Action
|
|
| Does nothing.
|-
| 1
| ACTION_T_TEXT
| -TextId1
| -TextId2
| -TextId3
| Simply displays the specified -TextId. When -TextId2 and -TextId3 are specified, the selection will be randomized. Text types are defined, along with other options for the text, in a table below. All values needs to be negative.
|-
| 2
| ACTION_T_SET_FACTION
| FactionId
|
|
| Changes faction for a creature. When param1 is zero, creature will revert to it's default faction.
|-
| 3
| ACTION_T_MORPH_TO_ENTRY_OR_MODEL
| CreatureEntry
| ModelId
|
| Set either model from creature_template.entry (Param1) OR explicit modelId (Param2). If (Param1) AND (Param2) are both 0, demorph and revert to the default model.
|-
| 4
| ACTION_T_SOUND
| SoundId
|
|
| Plays a sound
|-
| 5
| ACTION_T_EMOTE
| moteId
|
|
| Does an emote
|-
| 6
| ACTION_T_RANDOM_SAY
| UNUSED
|-
| 7
| ACTION_T_RANDOM_YELL
| UNUSED
|-
| 8
| ACTION_T_RANDOM_TEXTEMOTE
| UNUSED
|-
| 9
| ACTION_T_RANDOM_SOUND
| SoundId1
| SoundId2
| SoundId3
| Plays a random sound *
|-
| 10
| ACTION_T_RANDOM_EMOTE
| EmoteId1
| EmoteId2
| EmoteId3
| Emotes a random emote
|-
| 11
| ACTION_T_CAST
| SpellId
| Target
| CastFlags
| Casts spell (Param1) on a target (Param2) using cast flags (specified below).
|-
| 12
| ACTION_T_SUMMON
| CreatureID
| Target
| Duration
| Summons a creature (Param1) for (Param3) duration and orders it to attach (Param2) target. Spawns on top of current creature.
|-
| 13
| ACTION_T_THREAT_SINGLE_PCT
| Threat%
| Target
|
| Modifies a threat by (Param1) percent on a target (Param2).
|-
| 14
| ACTION_T_THREAT_ALL_PCT
| Threat%
|
|
| Modifies a threat by (Param1) on all targets in the threat list (using -100% here will result in full aggro dump).
|-
| 15
| ACTION_T_QUEST_EVENT
| QuestID,
| Target
|
| Calls AreaExploredOrEventHappens with (Param1) for a target in (Param2).
|-
| 16
| ACTION_T_QUEST_CASTCREATUREGO
| CreatureID
| SpellId
| Target
| Sends CastCreatureOrGo for a creature specified by CreatureId (Param1) with provided spell id (Param2) for a target in (Param3).
|-
| 17
| ACTION_T_SET_UNIT_FIELD
| Field_Number
| Value
| Target
| Sets a unit field (Param1) to provided value (Param2) on a target in (Param3).
|-
| 18
| ACTION_T_SET_UNIT_FLAG
| Flags
| Target
|
| Sets flag (flags can be used together to modify multiple flags at once) on a target (Param2).
|-
| 19
| ACTION_T_REMOVE_UNIT_FLAG
| Flags
| Target
|
| Removes flag on a target (Param2).
|-
| 20
| ACTION_T_AUTO_ATTACK
| AllowAutoAttack
|
|
| Stop melee attack when (Param1) is zero, otherwise continue attacking / allow melee attack.
|-
| 21
| ACTION_T_COMBAT_MOVEMENT
| AllowCombatMovement
|
|
| Stop combat based movement when (Param1) is zero, otherwise continue/allow combat based movement (targeted movement generator).
|-
| 22
| ACTION_T_SET_PHASE
| Phase
|
|
| Sets the current phase to (Param1).
|-
| 23
| ACTION_T_INC_PHASE
| Value
|
|
| Increments the phase by (Param1). May be negative to decrement, but should not be zero.
|-
| 24
| ACTION_T_EVADE
| No Params
|
|
| Forces the creature to evade, wiping all threat and dropping combat.
|-
| 25
| ACTION_T_FLEE_FOR_ASSIST
| No Params
|
|
| Causes the creature to flee for assistence (often at low health).
|-
| 26
| ACTION_T_QUEST_EVENT_ALL
| QuestId
|
|
| Calls GroupEventHappens with (Param1). Only used if it's _expected_ event should call quest completion for all players in a current party.
|-
| 27
| ACTION_T_CASTCREATUREGO_ALL
| QuestId
| SpellId
|
| Calls CastedCreatureOrGo for all players on the threat list with quest id specified in (Param1) and spell id in (Param2).
|-
| 28
| ACTION_T_REMOVEAURASFROMSPELL
| Target
| Spellid
|
| Removes all auras on a target (Param1) caused by a spell (Param2).
|-
| 29
| ACTION_T_RANGED_MOVEMENT
| Distance
| Angle
|
| Changes the movement generator to a ranged type. (note: default melee type can still be set by using 0 as angle and 0 as distance).
|-
| 30
| ACTION_T_RANDOM_PHASE
| PhaseId1
| PhaseId2
| PhaseId3
| Sets a phase to a specified id(s)*
|-
| 31
| ACTION_T_RANDOM_PHASE_RANGE
| PhaseMin
| PhaseMax
|
| Sets a phase to a random id (Phase = PhaseMin + rnd % PhaseMin-PhaseMax). PhaseMax must be greater than PhaseMin.
|-
| 32
| ACTION_T_SUMMON
| CreatureID
| Target
| SummonID
| Summons a creature (Param1) to attack target (Param2) at location specified by EventAI_Summons (Param3).
|-
| 33
| ACTION_T_KILLED_MONSTER
| CreatureID
| Target
|
| Calls KilledMonster (Param1) for a target (Param2).
|-
| 34
| ACTION_T_SET_INST_DATA
| Field
| Data
|
| Calls ScriptedInstance::SetData with field (Param1) and data (Param2).
|-
| 35
| ACTION_T_SET_INST_DATA64
| Field
| Target
|
| Calls ScriptedInstance::SetData64 with field (Param1) and target's GUID (Param2).
|-
| 36
| ACTION_T_UPDATE_TEMPLATE
| TemplateId
| Team
|
| Changes a creature's template to (Param1) with team = Alliance or Horde when (Param2) is either false or true respectively.
|-
| 37
| ACTION_T_DIE
| No Params
|
|
| Kills the creature
|-
| 38
| ACTION_T_ZONE_COMBAT_PULSE
| No Params
|
|
| Puts all players within an instance into combat with the creature. Only works when a creature is already in combat. Doesn't work outside instances.
|-
| 39
| ACTION_T_CALL_FOR_HELP
| Radius
|
|
| Call any friendly out-of-combat creatures in a radius (Param1) to attack current creature's target.
|-
| 40
| ACTION_T_SET_SHEATH
| Sheath
|
|
| Sets sheath state for a creature (0 = no weapon, 1 = melee weapon, 2 = ranged weapon).
|-
| 41
| ACTION_T_FORCE_DESPAWN
| No Params
|
|
| Despawns the creature
|-
| 42
| ACTION_T_SET_INVINCIBILITY_HP_LEVEL
| hp_level
| is_percent
|
| Set min. health level for creature that can be set at damage as flat value or percent from max health
|-
|}

'''Cast Flags'''
{| border = 1 cellpadding=3 cellspacing=0
! Bit / Value !! Name !! Description
|-
| 0 / 1 || CAST_INTURRUPT_PREVIOUS || Interrupts any previous spell casting.
|-
| 1 / 2 || CAST_TRIGGERED || Forces the cast to be instant and ignores any mana/reagents requirements.
|-
| 2 / 4 || CAST_FORCE_CAST || Forces spell to cast even if the target is possibly out of range or the creature is possibly out of mana
|-
| 3 / 8 || CAST_NO_MELEE_IF_OOM || Prevents creature from entering melee if out of mana or out of range
|-
| 4 / 16 || CAST_FORCE_TARGET_SELF || Forces the target to cast this spell on itself
|-
|5 / 32 || CAST_AURA_NOT_PRESENT || Only casts the spell on the target if the target does not have the aura from that spell on itself already.
|}

* = Use -1 where the param is expected to do nothing. Random constant is generated for each event, so if you have a random yell and a random sound, they will be linked up with each other (ie. param2 with param2).

==== action_param1 ====
Depends on [[#action_type|action_type]]

==== action_param2 ====
Depends on [[#action_type|action_type]]

==== action_param3 ====
Depends on [[#action_type|action_type]]

==== comment ====
Comment as to what should this one script do.
* Style should be something like this: 'Creature (or Gameobject) name - Cast Spellname'
Read some real scripts for more info.

[[Category: SkyFire World database tables]]

Linux GDB Debugging

2011-09-18T20:56:36Z

Marqin: decat

GDB: The GNU Project Debugger.
Original Author is Derex from the MaNGOS project.
http://getmangos.com/community/topic/4579/howto-gdb-debugging/

Hi, this is a simple/dirty tutorial of what is GDB and how to use it.

This tutorial assumes that you can start your worldserver by typing:

worldserver

in the console.

1. Before you start debugging SkyFire you need to have ensured that it is compiled with debug information. To build SkyFire with debug info just add --with-debug-info to your options when running ../configure. Then compile and install SkyFire as usual.

2. Now you can start SkyFire with gdb by typing this.

gdb worldserver

Then you will most likely see something like this:

derex@*:~/workspace/SkyFire/build$ gdb worldserver
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu"...
(gdb)

(gdb) - is the GDB command prompt smile , here you can type some commands, almost like in normal shell.

Now after you have gdb running, you may instruct it to start SkyFire ( by having gdb start SkyFire you can debug it ), here is the command:

run

Just type it and if you are lucky you will have SkyFire loading.

Ok ... you made it, now SkyFire runs. Take a break until it crash ,then you can come back smile

3. When SkyFire crashes you will most likely see this message, or any similar.

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x42c5c950 (LWP 9283)]
Player (this=0x42c598e0, session=0x0) at ../../../src/game/Player.cpp:265
265 ../../../src/game/Player.cpp: No such file or directory.
in ../../../src/game/Player.cpp
(gdb)

Now you can type some commands to get information about the crash, and possibly give it to some dev to fix the problem.

Here are the commands that are best to be typed ( or at least I find the most useful for crash report )

shell echo -e "\nCRASH ON" `date`
info program
shell echo -e "\nBACKTRACE\n"
bt
shell echo -e "\nBACKTRACE FULL\n"
bt full
shell echo -e "\nTHREADS\n"
info threads
shell echo -e "\nTHREADS BACKTRACE\n"
thread apply all bt full

Just type them one after another and give the output in your bug report ...

OK. That is it, now we can think of some way to automate all this process. GDB has 2 very good switches:

--batch Exit after processing options.
--command=FILE, -x Execute GDB commands from FILE.

4. So you can put all the commands in one file and have GDB execute it, and when it finishes to exit. Lets say we put this in one file called gdb-commands.

run
shell echo -e "\nCRASH ON" `date`
info program
shell echo -e "\nBACKTRACE\n"
bt
shell echo -e "\nBACKTRACE FULL\n"
bt full
shell echo -e "\nTHREADS\n"
info threads
thread apply all bt full

Now you can start the whole monster with:

gdb worldserver --batch -x /path/to/gdb-commands

TIPS
1.You can also redirect stdout to some log file. I mean this:

gdb worldserver --batch -x /path/to/gdb-commands > /some/log/file

2.You can add a tail command to gdb-commands file to get the latest lines from your server.log file:

shell echo -e "\nSERVER.LOG\n"
shell tail -n 50 /path/to/your/server.log

50 means how much lanes to take from server.log

3. You can add -ggdb3 -g3 flags to your CXXFLAGS in order to get more debug output. If you add them there is no need to add --with-debug-info switch in order to get meaningful back-trace.

4. You can pass arguments to worldserver by passing them to the run gdb command ( run -c /path/to/worldserver.conf ).

To get correct version information about SkyFire ( so no need to specify it in the bug report ... its already there and its correct, and you can't forget it ).

[[Category:Guides]]

Smart scripts SF

2011-09-18T20:56:30Z

Marqin: decat

{| align="right"
| __TOC__
|}

{{Back-to:World}}

<big>'''The `smart_scripts` table'''</big>

==== Table Structure ====

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#entryorguid|entryorguid]]
| int(11)
| signed
| PRI
| NO
| ''None''
| 
| 
|-
| [[#Source_Type|source_type]]
| tinyint(3)
| unsigned
| PRI
| NO
| 0
|
| 
|-
| [[#id|id]]
| smallint(5)
| unsigned
| PRI
| NO
| 0
|
| 
|-
| [[#link|link]]
| smallint(5)
| unsigned
| PRI
| NO
| 0
|
| 
|-
| [[#Event_types|event_type]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#event_phase_mask|event_phase_mask]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#event_chance|event_chance]]
| tinyint(3)
| unsigned
|
| NO
| 100
|
|
|-
| [[#Event_flags|event_flags]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Event_types|event_param1]]
| int(10)
| unsigned
|
| NO
| 0
|
| 
|-
| [[#Event_types|event_param2]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Event_types|event_param3]]
| int(10)
| unsigned
|
| NO
| 0
|
| 
|-
| [[#Event_types|event_param4]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Action_types|action_type]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Action_types|action_param1]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Action_types|action_param2]]
| int(10)
| unsigned
|
| NO
| 0
|
| 
|-
| [[#Action_types|action_param3]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Action_types|action_param4]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Action_types|action_param5]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Action_types|action_param6]]
| int(10)
| unsigned
|
| NO
| 0
|
| 
|-
| [[#Targets|target_type]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Targets|target_param1]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Targets|target_param2]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Targets|target_param3]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#Targets|target_x]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#Targets|target_y]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#Targets|target_z]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#Targets|target_o]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#comment|comment]]
| text
| signed
|
| NO
| 
|
| Event Comment
|}

 

==== Table fields description ====

'''[[#EntryOrGuid|EntryOrGuid:]]'''

*Entryorguid > 0: entry of the creature / game object / etc.
*Entryorguid < 0: guid of the creature / game object / etc.
*Depends on source_type.

'''[[#Source_Type|source_type:]]'''

*Object type: creature, game object, spell.

'''[[#Id|id:]]'''

*Incremental id ''bound'' to each entryorguid&source_type (0, 1, 2, ...).

'''[[#Link|link:]]'''

*Simple event linking;
*Example: if id = 0 and link = 1; id 1 will only be able to occur if id = 0 was triggered.

'''[[#Event_types|event_type, event_param1, event_param2, event_param3, event_param4:]]'''

*Smart_event to be used.

'''event_phase_mask:'''

*Event will only be able to occur if creature/GO is in this phase;
*0 means all phases (?);
*(Inverse of EAI: event_inverse_phase_mask).

'''event_chance:'''

*Probability of the event to occur, in percentage;
*0-100%.

'''[[#Event_flags|event_flags:]]'''

*Sets if the event should not repeat or should only happen in a given instance/dungeon difficulty (if applicable);
*Values can be added together (bitwise math).

'''[[#Action_types|action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6:]]'''

*Action what will be used if event is triggered.

'''[[#Targets|target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o:]]'''

*Defines the target of the event and/or action.

'''comment:'''

*Description of the event-action combo;
*Use simple comments however they should not be ambiguous;
*(not used by core).
* Style should be something like this: 'Creature (or Gameobject) name - Cast Spellname'
Read some real scripts for more info.

'''Quick notes:'''

*Always update ''creature_template'' or ''gameobject_template'' with:
<pre>UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`=y;
UPDATE `gameobject_template` SET `AIName`='SmartGameObjectAI' WHERE `entry`=y;
</pre>
*If the creature or GO is inside a dungeon, set ''event_flags'' accordingly to the instance difficulty (heroic, 25 man, etc.).
*In case of doubt about an ''Event'', ''Action ''or ''Target, ''check source code (''src/server/game/AI/SmartScripts'' files; mainly '''SmartScript.cpp'''

 

==== Source_Type ====

{| width="50%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | Comment
|-
| SMART_SCRIPT_TYPE_CREATURE
| 0
| 
|-
| SMART_SCRIPT_TYPE_GAMEOBJECT
| 1
| Partially implemented
|-
| SMART_SCRIPT_TYPE_AREATRIGGER
| 2
| 
|-
| SMART_SCRIPT_TYPE_EVENT
| 3
| Not Yet Implemented 
|-
| SMART_SCRIPT_TYPE_GOSSIP
| 4
| Not Yet Implemented
|-
| SMART_SCRIPT_TYPE_QUEST
| 5
| Not Yet Implemented
|-
| SMART_SCRIPT_TYPE_SPELL
| 6
| Not Yet Implemented
|-
| SMART_SCRIPT_TYPE_TRANSPORT
| 7
| Not Yet Implemented
|-
| SMART_SCRIPT_TYPE_INSTANCE
| 8
| Not Yet Implemented
|-
| SMART_SCRIPT_TYPE_TIMED_ACTIONLIST
| 9
|
|}

 

==== Event types ====

{| width="100%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | Param1
! scope="col" | Param2
! scope="col" | Param3
! scope="col" | Param4
! scope="col" | Comment
|-
| SMART_EVENT_UPDATE_IC
| 0
| InitialMin
| InitialMax
| RepeatMin
| RepeatMax
| In combat.
|-
| SMART_EVENT_UPDATE_OOC
| 1
| InitialMin
| InitialMax
| RepeatMin
| RepeatMax
| Out of combat.
|-
| SMART_EVENT_HEALT_PCT
| 2
| HPMin%
| HPMax%
| RepeatMin
| RepeatMax
| Health Percentage
|-
| SMART_EVENT_MANA_PCT
| 3
| ManaMin%
| ManaMax%
| RepeatMin
| RepeatMax
| Mana Percentage
|-
| SMART_EVENT_AGGRO
| 4
|
|
|
|
| On Creature Aggro
|-
| SMART_EVENT_KILL
| 5
| CooldownMin0
| CooldownMax1
| playerOnly2
| else creature entry3
| On Creature Kill
|-
| SMART_EVENT_DEATH
| 6
|
|
|
|
| On Creature Death
|-
| SMART_EVENT_EVADE
| 7
|
|
|
|
| On Creature Evade Attack
|-
| SMART_EVENT_SPELLHIT
| 8
| SpellID
| School
| CooldownMin
| CooldownMax
| On Creature Spell Hit
|-
| SMART_EVENT_RANGE
| 9
| MinDist
| MaxDist
| RepeatMin
| RepeatMax
| On Target In Range
|-
| SMART_EVENT_OOC_LOS
| 10
| NoHostile
| MaxRange
| CooldownMin
| CooldownMax
| On Target In Distance Out of Combat
|-
| SMART_EVENT_RESPAWN
| 11
| type
| MapId
| ZoneId
|
| On Creature Respawn
|-
| SMART_EVENT_TARGET_HEALTH_PCT
| 12
| HPMin%
| HPMax%
| RepeatMin
| RepeatMax
| On Target Health Percentage
|-
| SMART_EVENT_TARGET_CASTING
| 13
| RepeatMin
| RepeatMax
|
|
| On Target Casting Spell
|-
| SMART_EVENT_FRIENDLY_HEALTH
| 14
| HPDeficit
| Radius
| RepeatMin
| RepeatMax
| On Friendly Health Deficit
|-
| SMART_EVENT_FRIENDLY_IS_CC
| 15
| Radius
| RepeatMin
| RepeatMax
|
|
|-
| SMART_EVENT_FRIENDLY_MISSING_BUFF
| 16
| SpellId
| Radius
| RepeatMin
| RepeatMax
| On Friendly Lost Buff
|-
| SMART_EVENT_SUMMONED_UNIT
| 17
| CretureId (0 all)
| CooldownMin
| CooldownMax
|
| On Creature Summoned Unit
|-
| SMART_EVENT_TARGET_MANA_PCT
| 18
| ManaMin%
| ManaMax%
| RepeatMin
| RepeatMax
| On Target Mana Percentage
|-
| SMART_EVENT_ACCEPTED_QUEST
| 19
| QuestID (0 any)
|
|
|
| On Target Accepted Quest
|-
| SMART_EVENT_REWARD_QUEST
| 20
| QuestID (0 any)
|
|
|
| On Target Rewarded Quest
|-
| SMART_EVENT_REACHED_HOME
| 21
|
|
|
|
| On Creature Reached Home
|-
| SMART_EVENT_RECEIVE_EMOTE
| 22
| EmoteId
| CooldownMin
| CooldownMax
| condition
| val1,val2,val3 (?)
|-
| SMART_EVENT_HAS_AURA
| 23
| SpellID
| Stacks
| RepeatMin
| RepeatMax
| On Creature Has Aura
|-
| SMART_EVENT_TARGET_BUFFED
| 24
| SpellID
| Stacks
| RepeatMin
| RepeatMax
| On Target Buffed With Spell
|-
| SMART_EVENT_RESET
| 25
|
|
|
|
| After Combat, On Respawn or Spawn
|-
| SMART_EVENT_IC_LOS
| 26
| NoHostile
| MaxRange
| CooldownMin
| CooldownMax
| On Target In Distance In Combat
|-
| SMART_EVENT_PASSENGER_BOARDED
| 27
| CooldownMin
| CooldownMax
|
|
|
|-
| SMART_EVENT_PASSENGER_REMOVED
| 28
| CooldownMin
| CooldownMax
|
|
|
|-
| SMART_EVENT_CHARMED
| 29
|
|
|
|
| On Creature Charmed
|-
| SMART_EVENT_CHARMED_TARGET
| 30
|
|
|
|
| On Target Charmed
|-
| SMART_EVENT_SPELLHIT_TARGET
| 31
| SpellId
| School
| RepeatMin
| RepeatMax
| On Target Spell Hit
|-
| SMART_EVENT_DAMAGED
| 32
| MinDmg
| MaxDmg
| RepeatMin
| RepeatMax
| On Creature Damaged
|-
| SMART_EVENT_DAMAGED_TARGET
| 33
| MinDmg
| MaxDmg
| RepeatMin
| RepeatMax
| On Target Damaged
|-
| SMART_EVENT_MOVEMENTINFORM
| 34
| MovementType (any)
| PointID
|
|
|
|-
| SMART_EVENT_SUMMON_DESPAWNED
| 35
| Entry
| CooldownMin
| CooldownMax
|
| On Summoned Unit Despawned
|-
| SMART_EVENT_CORPSE_REMOVED
| 36
|
|
|
|
| On Creature Corpse Removed
|-
| SMART_EVENT_AI_INIT
| 37
|
|
|
|
|
|-
| SMART_EVENT_DATA_SET
| 38
| Field
| Value
| CooldownMin
| CooldownMax
| On Creature Data Set, Can be used with SMART_ACTION_SET_DATA
|-
| SMART_EVENT_WAYPOINT_START
| 39
| PointId (0 any)
| pathId (0 any)
|
|
| On Creature Waypoint ID Started
|-
| SMART_EVENT_WAYPOINT_REACHED
| 40
| PointId (0 any)
| pathId (0 any)
|
|
| On Creature Waypoint ID Reached
|-
| SMART_EVENT_TRANSPORT_ADDPLAYER
| 41
|
|
|
|
|
|-
| SMART_EVENT_TRANSPORT_ADDCREATURE
| 42
| Entry (0 any)
|
|
|
|
|-
| SMART_EVENT_TRANSPORT_REMOVE_PLAYER
| 43
|
|
|
|
|
|-
| SMART_EVENT_TRANSPORT_RELOCATE
| 44
| PointId
|
|
|
|
|-
| SMART_EVENT_INSTANCE_PLAYER_ENTER
| 45
| Team (0 any)
| CooldownMin
| CooldownMax
|
|
|-
| SMART_EVENT_AREATRIGGER_ONTRIGGER
| 46
| TriggerId (0 any)
|
|
|
|
|-
| SMART_EVENT_QUEST_ACCEPTED
| 47
|
|
|
|
| On Target Quest Accepted
|-
| SMART_EVENT_QUEST_OBJ_COPLETETION
| 48
|
|
|
|
| On Target Quest Objective Completed
|-
| SMART_EVENT_QUEST_COMPLETION
| 49
|
|
|
|
| On Target Quest Completed
|-
| SMART_EVENT_QUEST_REWARDED
| 50
|
|
|
|
| On Target Quest Rewarded
|-
| SMART_EVENT_QUEST_FAIL
| 51
|
|
|
|
| On Target Quest Field
|-
| SMART_EVENT_TEXT_OVER
| 52
| GroupId (from creatue_text)
| CreatureId (0 any)
|
|
| On TEXT_OVER Event Triggered After SMART_ACTION_TALK
|-
| SMART_EVENT_RECEIVE_HEAL
| 53
| MinHeal
| MaxHeal
| CooldownMin
| CooldownMax
| On Creature Received Healing
|-
| SMART_EVENT_JUST_SUMMONED
| 54
|
|
|
|
| On Creature Just spawned
|-
| SMART_EVENT_WAYPOINT_PAUSED
| 55
| PointId (0 any)
| pathID (0 any)
|
|
| On Creature Paused at Waypoint ID
|-
| SMART_EVENT_WAYPOINT_RESUMED
| 56
| PointId (0 any)
| pathID (0 any)
|
|
| On Creature Resumed after Waypoint ID
|-
| SMART_EVENT_WAYPOINT_STOPPED
| 57
| PointId (0 any)
| pathID (0 any)
|
|
| On Creature Stopped On Waypoint ID
|-
| SMART_EVENT_WAYPOINT_ENDED
| 58
| PointId (0 any)
| pathID (0 any)
|
|
| On Creature Waypoint Path Ended
|-
| SMART_EVENT_TIMED_EVENT_TRIGGERED
| 59
| Id
|
|
|
|
|-
| SMART_EVENT_UPDATE
| 60
| InitialMin
| InitialMax
| RepeatMin
| RepeatMax
|
|-
| SMART_EVENT_LINK
| 61
|
|
|
|
| used to link together multiple events
|-
| SMART_EVENT_GOSSIP_SELECT
| 62
| menuID
| actionID
|
|
|
|-
| SMART_EVENT_JUST_CREATED
| 63
|
|
|
|
|
|-
| SMART_EVENT_GOSSIP_HELLO
| 64
|
|
|
|
|
|-
| SMART_EVENT_FOLLOW_COMPLETED
| 65
|
|
|
|
|
|-
| SMART_EVENT_DUMMY_EFFECT
| 66
| spellId
| effectIndex
|
|
|
|}

 

==== Action types ====

{| width="100%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | Param1
! scope="col" | Param2
! scope="col" | Param3
! scope="col" | Param4
! scope="col" | Param5
! scope="col" | Param6
! scope="col" | Comment
|-
| SMART_ACTION_NONE
| 0
|
|
|
|
|
|
| Do Nothing
|-
| SMART_ACTION_TALK
| 1
| [[Creature_text_tc2#group_id|Creature_text.groupid]]
| duration to wait before TEXT_OVER event is triggered
|
|
|
|
| Param2 in Milliseconds.
|-
| SMART_ACTION_SET_FACTION
| 2
| [[FactionTemplate.dbc_tc2|FactionID]] (or 0 for default)
|
|
|
|
|
|
|-
| SMART_ACTION_MORPH_TO_ENTRY_OR_MODEL
| 3
| [[Creature_template_tc2#entry|Creature_template.entry]](param1)
| [[Creature_template_tc2#modelid1-4|Creature_template.modelID]](param2)
|
|
|
|
| Take DisplayID of creature (param1) OR Turn to DisplayID (param2) OR Both = 0 for Demorph
|-
| SMART_ACTION_SOUND
| 4
| SoundId
| TextRange
|
|
|
|
| Play Sound
|-
| SMART_ACTION_PLAY_EMOTE
| 5
| EmoteId
|
|
|
|
|
| Play Emote
|-
| SMART_ACTION_FAIL_QUEST
| 6
| [[Quest_template_tc2#entry|QuestID]]
|
|
|
|
|
| Fail Quest of Target
|-
| SMART_ACTION_ADD_QUEST
| 7
| [[Quest_template_tc2#entry|QuestID]]
|
|
|
|
|
| Add Quest to Target
|-
| SMART_ACTION_SET_REACT_STATE
| 8
| State
|
|
|
|
|
| React State. Can be Aggressive, Passive or Defensive.
|-
| SMART_ACTION_ACTIVATE_GOBJECT
| 9
|
|
|
|
|
|
| Activate Object
|-
| SMART_ACTION_RANDOM_EMOTE
| 10
| EmoteId1
| EmoteId2
| EmoteId3...
|
|
|
| Play Random Emote
|-
| SMART_ACTION_CAST
| 11
| SpellId
| [[#Cast_flags|CastFlags]]
|
|
|
|
| Cast Spell ID at Target
|-
| SMART_ACTION_SUMMON_CREATURE
| 12
| CreatureID
| [[#Summon Types|Summon type]]
| duration in ms
| StorageID (always 0)
| attackInvoker
|
| Summon Unit
|-
| SMART_ACTION_THREAT_SINGLE_PCT
| 13
| Threat%
|
|
|
|
|
| Change Threat Percentage for Single Target
|-
| SMART_ACTION_THREAT_ALL_PCT
| 14
| Threat%
|
|
|
|
|
| Change Threat Percentage for All Enemies
|-
| SMART_ACTION_CALL_AREAEXPLOREDOREVENTHAPPENS
| 15
| [[Quest_template_tc2#entry|QuestID]]
|
|
|
|
|
|
|-
| SMART_ACTION_SEND_CASTCREATUREORGO
| 16
| [[Quest_template_tc2#entry|QuestID]]
| SpellId
|
|
|
|
|
|-
| SMART_ACTION_SET_EMOTE_STATE
| 17
| emoteID
|
|
|
|
|
| Play Emote Continuously
|-
| SMART_ACTION_SET_UNIT_FLAG
| 18
| [[Creature_template_tc2#unit_flags|Creature_template.unit_flags]] (may be more than one field OR'd together)
| Target
|
|
|
|
| Can set Multi-able flags at once
|-
| SMART_ACTION_REMOVE_UNIT_FLAG
| 19
| [[Creature_template_tc2#unit_flags|Creature_template.unit_flags]] (may be more than one field OR'd together)
| Target
|
|
|
|
| Can Remove Multi-able flags at once
|-
| SMART_ACTION_AUTO_ATTACK
| 20
| AllowAttackState (0 = Stop attack, anything else means continue attacking)
|
|
|
|
|
| Stop or Continue Automatic Attack.
|-
| SMART_ACTION_ALLOW_COMBAT_MOVEMENT
| 21
| AllowCombatMovement (0 = Stop combat based movement, anything else continue attacking)
|
|
|
|
|
| Allow or Disable Combat Movement
|-
| SMART_ACTION_SET_EVENT_PHASE
| 22
| smart_scripts.event_phase_mask
|
|
|
|
|
|
|-
| SMART_ACTION_INC_EVENT_PHASE
| 23
| Increment
| Decrement
|
|
|
|
| Set param1 OR param2 (not both). Value 0 has no effect.
|-
| SMART_ACTION_EVADE
| 24
|
|
|
|
|
|
| Evade Incoming Attack
|-
| SMART_ACTION_FLEE_FOR_ASSIST
| 25
|
|
|
|
|
|
|
|-
| SMART_ACTION_CALL_GROUPEVENTHAPPENS
| 26
| [[Quest_template_tc2#entry|QuestID]]
|
|
|
|
|
|
|-
| SMART_ACTION_CALL_CASTEDCREATUREORGO
| 27
| [[Creature_template_tc2#entry|Creature_template.entry]]
| SpellId
|
|
|
|
|
|-
| SMART_ACTION_REMOVEAURASFROMSPELL
| 28
| Spellid
|
|
|
|
|
|
|-
| SMART_ACTION_FOLLOW
| 29
| Distance
| Angle
| EndCreatureEntry
| credit
| creditType (0monsterkill, 1event)
|
| Follow Target
|-
| SMART_ACTION_RANDOM_PHASE
| 30
| [[Creature_tc2#phaseMask|Creature.phasemask]] 1
| [[Creature_tc2#phaseMask|Creature.phasemask]] 2
| [[Creature_tc2#phaseMask|Creature.phasemask]] 3...
|
|
|
|
|-
| SMART_ACTION_RANDOM_PHASE_RANGE
| 31
| [[Creature_tc2#phaseMask|Creature.phasemask]] minimum
| [[Creature_tc2#phaseMask|Creature.phasemask]] maximum
|
|
|
|
|
|-
| SMART_ACTION_RESET_GOBJECT
| 32
|
|
|
|
|
|
| Reset Gameobject
|-
| SMART_ACTION_CALL_KILLEDMONSTER
| 33
| CreatureId
|
|
|
|
|
|
|-
| SMART_ACTION_SET_INST_DATA
| 34
| Field
| Data
|
|
|
|
| Set Instance Data
|-
| SMART_ACTION_SET_INST_DATA64
| 35
| Field
|
|
|
|
|
| Set Instance Data uint64
|-
| SMART_ACTION_UPDATE_TEMPLATE
| 36
| Entry
| Team (updates creature_template to given entry)
|
|
|
|
|
|-
| SMART_ACTION_DIE
| 37
|
|
|
|
|
|
| Kill Target
|-
| SMART_ACTION_SET_IN_COMBAT_WITH_ZONE
| 38
|
|
|
|
|
|
|
|-
| SMART_ACTION_CALL_FOR_HELP
| 39
| Radius in yards that other creatures must be to acknowledge the cry for help
|
|
|
|
|
|
|-
| SMART_ACTION_SET_SHEATH
| 40
| Sheath (0-unarmed, 1-melee, 2-ranged)
|
|
|
|
|
|
|-
| SMART_ACTION_FORCE_DESPAWN
| 41
| timer
|
|
|
|
|
| Despawn Target after param1 Milliseconds
|-
| SMART_ACTION_SET_INVINCIBILITY_HP_LEVEL
| 42
| MinHpValue(+pct,-flat)
|
|
|
|
|
|
|-
| SMART_ACTION_MOUNT_TO_ENTRY_OR_MODEL
| 43
| [[Creature_template_tc2#entry|Creature_template.entry]]
| [[Creature_template_tc2#modelid1-4|Creature_template.modelID]]
|
|
|
|
| Mount to Creature Entry (param1) OR Mount to Creature Display (param2) Or both = 0 for Unmount
|-
| SMART_ACTION_SET_INGAME_PHASE_MASK
| 44
| [[Creature_tc2#phaseMask|Creature.phasemask]]
|
|
|
|
|
|
|-
| SMART_ACTION_SET_DATA
| 45
| Field
| Data
|
|
|
|
| Set Data For Target, can be used with SMART_EVENT_DATA_SET ( CREATURE ONLY - TODO )
|-
| SMART_ACTION_MOVE_FORWARD
| 46
| Distance in yards
|
|
|
|
|
|
|-
| SMART_ACTION_SET_VISIBILITY
| 47
| 0/1
|
|
|
|
|
|
|-
| SMART_ACTION_SET_ACTIVE
| 48
|
|
|
|
|
|
|
|-
| SMART_ACTION_ATTACK_START
| 49
|
|
|
|
|
|
|
|-
| SMART_ACTION_SUMMON_GO
| 50
| [[Gameobject_template_tc2#entry|Gameobject_template.entry]]
| DespawnTime in ms
|
|
|
|
|
|-
| SMART_ACTION_KILL_UNIT
| 51
|
|
|
|
|
|
|
|-
| SMART_ACTION_ACTIVATE_TAXI
| 52
| TaxiID
|
|
|
|
|
|
|-
| SMART_ACTION_WP_START
| 53
| run/walk
| [[Waypoints_tc2#entry|Waypoints.entry]]
| canRepeat
| [[Quest_template_tc2#entry|Quest_template.entry]]
| despawntime
| reactState
|
|-
| SMART_ACTION_WP_PAUSE
| 54
| time
|
|
|
|
|
|
|-
| SMART_ACTION_WP_STOP
| 55
| despawnTime
| [[Quest_template_tc2#entry|Quest_template.entry]]
| fail (0/1)
|
|
|
|
|-
| SMART_ACTION_ADD_ITEM
| 56
| [[Item_template_tc2#entry|Item_template.entry]]
| count
|
|
|
|
|
|-
| SMART_ACTION_REMOVE_ITEM
| 57
| [[Item_template_tc2#entry|Item_template.entry]]
| count
|
|
|
|
|
|-
| SMART_ACTION_INSTALL_AI_TEMPLATE
| 58
| AITemplateID
|
|
|
|
|
|
|-
| SMART_ACTION_SET_RUN
| 59
| 0/1
|
|
|
|
|
|
|-
| SMART_ACTION_SET_FLY
| 60,
| 0/1
|
|
|
|
|
|
|-
| SMART_ACTION_SET_SWIMM
| 61
| 0/1
|
|
|
|
|
|
|-
| SMART_ACTION_TELEPORT
| 62
| [[Maps.dbc_tc2|MapID]]
|
|
|
|
|
| Use Any SMART_TARGET, and Set target_x, target_y, target_z, target_o. (param4,param5,param6,param7)
|-
| SMART_ACTION_STORE_VARIABLE_DECIMAL
| 63
| varID
| number
|
|
|
|
|
|-
| SMART_ACTION_STORE_TARGET_LIST
| 64
| varID
|
|
|
|
|
|
|-
| SMART_ACTION_WP_RESUME
| 65
|
|
|
|
|
|
|
|-
| SMART_ACTION_SET_ORIENTATION
| 66
| 0 = North, West = 1.5, South = 3, East = 4.5
|
|
|
|
|
|
|-
| SMART_ACTION_CREATE_TIMED_EVENT
| 67
| id
| InitialMin
| InitialMax
| RepeatMin(only if it repeats)
| RepeatMax(only if it repeats)
| chance
|
|-
| SMART_ACTION_PLAYMOVIE
| 68
| entry
|
|
|
|
|
|
|-
| SMART_ACTION_MOVE_TO_POS
| 69
|
|
|
|
|
|
| Use Any SMART_TARGET, and Set target_x, target_y, target_z, target_o. (param4,param5,param6,param7)
|-
| SMART_ACTION_RESPAWN_TARGET
| 70
|
|
|
|
|
|
|
|-
| SMART_ACTION_EQUIP
| 71
| [[Creature_equip_template_tc2#entry|Creature_equip_template.entry]]
| Slotmask
| slot1 (item_template.entry)
| Slot2 (item_template.entry)
| Slot3 (item_template.entry)
|
| only slots with mask set will be sent to client, bits are 1, 2, 4, leaving mask 0 is defaulted to mask 7 (send all), Slots1-3 are only used if no Param1 is set
|-
| SMART_ACTION_CLOSE_GOSSIP
| 72
|
|
|
|
|
|
|
|-
| SMART_ACTION_TRIGGER_TIMED_EVENT
| 73
| id(>1)
|
|
|
|
|
|
|-
| SMART_ACTION_REMOVE_TIMED_EVENT
| 74
| id(>1)
|
|
|
|
|
|
|-
| SMART_ACTION_ADD_AURA
| 75
| Spellid
| targets
|
|
|
|
|
|-
| SMART_ACTION_OVERRIDE_SCRIPT_BASE_OBJECT
| 76
|
|
|
|
|
|
| WARNING: CAN CRASH CORE, do not use if you dont know what you are doing
|-
| SMART_ACTION_RESET_SCRIPT_BASE_OBJECT
| 77
|
|
|
|
|
|
|
|-
| SMART_ACTION_CALL_SCRIPT_RESET
| 78
|
|
|
|
|
|
|
|-
| SMART_ACTION_ENTER_VEHICLE
| 79
| SeatID
|
|
|
|
|
|
|-
| SMART_ACTION_CALL_TIMED_ACTIONLIST
| 80
| ID (overwrites already running actionlist)
| Stop after combat (0/1)
| timer update type(0-OOC,1-IC,2-ALWAYS)
|
|
|
|
|-
| SMART_ACTION_SET_NPC_FLAG
| 81
| [[Creature_template_tc2#npcflag|Creature_template.npcflag]]
|
|
|
|
|
|
|-
| SMART_ACTION_ADD_NPC_FLAG
| 82
| Add this number to the above flag
|
|
|
|
|
|
|-
| SMART_ACTION_REMOVE_NPC_FLAG
| 83
| Subtract this number from the above flag
|
|
|
|
|
|
|-
| SMART_ACTION_SIMPLE_TALK
| 84
| [[Creature_text_tc2#group_id|Creature_text.groupID]]
|
|
|
|
|
| can be used to make players say groupID, Text_over event is not triggered, whisper can not be used (Target units will say the text)
|-
| SMART_ACTION_INVOKER_CAST
| 85
| SpellID
| [[#Cast_flags|castFlags]]
|
|
|
|
| if avaliable, last used invoker will cast spellId with castFlags on targets
|-
| SMART_ACTION_CROSS_CAST
| 86
| SpellID
| [[#Cast_flags|castFlags]]
| CasterTargetType
| CasterTarget param1
| CasterTarget param2
| CasterTarget param3
| ( + the original target fields as Destination target), CasterTargets will cast spellID on all Targets (use with caution if targeting multiple * multiple units)
|-
| SMART_ACTION_CALL_RANDOM_TIMED_ACTIONLIST
| 87
| Script9 ids 1-9
|
|
|
|
|
|
|-
| SMART_ACTION_CALL_RANDOM_RANGE_TIMED_ACTIONLIST
| 88
| Script9 entry of script1
| entry of script2
|
|
|
|
|
|-
| SMART_ACTION_RANDOM_MOVE
| 89
| maxDist
|
|
|
|
|
|

|-
| SMART_ACTION_SET_UNIT_FIELD_BYTES_1
| 90
| [[Creature_addon_tc2#bytes1|Value]]
|
|
|
|
|
|

|-
| SMART_ACTION_REMOVE_UNIT_FIELD_BYTES_1
| 91
| [[Creature_addon_tc2#bytes1|Value]]
|
|
|
|
|
|
|-
| SMART_ACTION_INTERRUPT_SPELL
| 92
| withDelay (bool value)
| spellId (uint32 value)
| withInstant (bool value)
|
|
|
| This action allows you to interrupt the current spell being cast. If you do not set the spellId, the core will find the current spell depending on the withDelay and the withInstant values.

|-
| SMART_ACTION__GO_CUSTOM_ANIM
| 93
| animprogress (0-255)
|
|
|
|
|
|
|}

 
 

==== Predefined SAI templates ====

{| width="50%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Description Name
! scope="col" | Value (Param1)
! scope="col" | Param2
! scope="col" | Param3
! scope="col" | Param4
! scope="col" | Param5
! scope="col" | Param6
! scope="col" | Comment
|-
| SMARTAI_TEMPLATE_BASIC
| 0
| 
| 
| 
| 
| 
| 
|-
| SMARTAI_TEMPLATE_CASTER
| 1
| spellid
| repeatMin
| repeatMax
| range
| manaPCT
| +JOIN: target_param1 as castFlag
|-
| SMARTAI_TEMPLATE_TURRET
| 2
| spellid
| repeatMin
| repeatMax
| range
| manaPCT
| +JOIN: target_param1 as castflag
|-
| SMARTAI_TEMPLATE_PASSIVE
| 3
|
|
|
|
|
|
|-
| SMARTAI_TEMPLATE_CAGED_GO_PART
| 4
| creatureID
| give credit at point end (0/1)
|
|
|
|
|-
| SMARTAI_TEMPLATE_CAGED_NPC_PART
| 5
| gameObjectID
| despawntime
| run (0/1)
| dist
| TextGroupID
|
|}

 

==== Targets ====

{| width="100%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | target_param1
! scope="col" | target_param2
! scope="col" | target_param3
! scope="col" | target_x
! scope="col" | target_y
! scope="col" | target_z
! scope="col" | target_o
! scope="col" | Comment
|-
| SMART_TARGET_NONE
| 0
|
|
|
|
|
|
|
| None, default to invoker
|-
| SMART_TARGET_SELF
| 1
|
|
|
|
|
|
|
| Self cast
|-
| SMART_TARGET_VICTIM
| 2
|
|
|
|
|
|
|
| Our current target (ie: highest aggro)
|-
| SMART_TARGET_HOSTILE_SECOND_AGGRO
| 3
|
|
|
|
|
|
|
| Second highest aggro
|-
| SMART_TARGET_HOSTILE_LAST_AGGRO
| 4
|
|
|
|
|
|
|
| Dead last on aggro
|-
| SMART_TARGET_HOSTILE_RANDOM
| 5
|
|
|
|
|
|
|
| Just any random target on our threat list
|-
| SMART_TARGET_HOSTILE_RANDOM_NOT_TOP
| 6
|
|
|
|
|
|
|
| Any random target except top threat
|-
| SMART_TARGET_ACTION_INVOKER
| 7
|
|
|
|
|
|
|
| Unit who caused this Event to occur
|-
| SMART_TARGET_POSITION
| 8
|
|
|
| x
| y
| z
| o
| Use xyz from event params
|-
| SMART_TARGET_CREATURE_RANGE
| 9
| [[Creature_template_tc2#entry|creatureEntry]] (0 any)
| minDist
| maxDist
|
|
|
|
|
|-
| SMART_TARGET_CREATURE_GUID
| 10
| guid
| entry
|
|
|
|
|
|
|-
| SMART_TARGET_CREATURE_DISTANCE
| 11
| [[Creature_template_tc2#entry|creatureEntry]] (0 any)
| maxDist
|
|
|
|
|
|
|-
| SMART_TARGET_STORED
| 12
| id
|
|
|
|
|
|
| Uses pre-stored target(list)
|-
| SMART_TARGET_GAMEOBJECT_RANGE
| 13
| [[Gameobject_template_tc2#entry|goEntry]] (0 any)
| minDist
| maxDist
|
|
|
|
|
|-
| SMART_TARGET_GAMEOBJECT_GUID
| 14
| guid
| entry
|
|
|
|
|
|
|-
| SMART_TARGET_GAMEOBJECT_DISTANCE
| 15
| [[Gameobject_template_tc2#entry|goEntry]] (0 any)
| maxDist
|
|
|
|
|
|
|-
| SMART_TARGET_INVOKER_PARTY
| 16
|
|
|
|
|
|
|
| Invoker's party members
|-
| SMART_TARGET_PLAYER_RANGE
| 17
| minDist
| maxDist
|
|
|
|
|
|
|-
| SMART_TARGET_PLAYER_DISTANCE
| 18
| maxDist
|
|
|
|
|
|
|
|-
| SMART_TARGET_CLOSEST_CREATURE
| 19
| [[Creature_template_tc2#entry|creatureEntry]] (0 any)
|
|
|
|
|
|
|
|-
| SMART_TARGET_CLOSEST_GAMEOBJECT
| 20
| [[Gameobject_template_tc2#entry|goEntry]] (0 any)
|
|
|
|
|
|
|
|-
| SMART_TARGET_CLOSEST_PLAYER
| 21
|
|
|
|
|
|
|
|
|-
| SMART_TARGET_ACTION_INVOKER_VEHICLE
| 22
|
|
|
|
|
|
|
| Unit's vehicle who caused this Event to occur
|-
| SMART_TARGET_OWNER_OR_SUMMONER
| 23
|
|
|
|
|
|
|
| Unit's owner or summoner
|-
| SMART_TARGET_THREAT_LIST
| 24
|
|
|
|
|
|
|
| All units on creature's threat list
|}

 

==== Event flags ====

{| width="50%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | Comment
|-
| SMART_EVENT_FLAG_NOT_REPEATABLE
| 0x01
| Event can not repeat
|-
| SMART_EVENT_FLAG_DIFFICULTY_0
| 0x02
| Event only occurs in instance difficulty 0
|-
| SMART_EVENT_FLAG_DIFFICULTY_1
| 0x04
| Event only occurs in instance difficulty 1
|-
| SMART_EVENT_FLAG_DIFFICULTY_2
| 0x08
| Event only occurs in instance difficulty 2
|-
| SMART_EVENT_FLAG_DIFFICULTY_3
| 0x10
| Event only occurs in instance difficulty 3
|-
| SMART_EVENT_FLAG_DEBUG_ONLY
| 0x80
| Event only occurs in debug build
|}

 

==== Cast flags ====

{| width="50%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | Comment
|-
| SMARTCAST_INTERRUPT_PREVIOUS
| 0x01
| Interrupt any spell casting
|-
| SMARTCAST_TRIGGERED
| 0x02
| Triggered (this makes spell cost zero mana and have no cast time)
|-
| CAST_FORCE_CAST
| 0x04
| Not Yet Implemented: Forces cast even if creature is out of mana or out of range
|-
| CAST_NO_MELEE_IF_OOM
| 0x08
| Not Yet Implemented: Prevents creature from entering melee if out of mana or out of range
|-
| CAST_FORCE_TARGET_SELF
| 0x10
| Not Yet Implemented: Forces the target to cast this spell on itself
|-
| CAST_AURA_NOT_PRESENT
| 0x20
| Not Yet Implemented: Only casts the spell if the target does not have an aura from the spell
|}

 

==== React States ====

{| width="55%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | Comment
|-
| REACT_PASSIVE
| 0
| attacks nothing, does not defend (default setting)
|-
| REACT_DEFENSIVE
| 1
| only attacks when attacked
|-
| REACT_AGGRESSIVE
| 2
| will attack if on threat list and in threat radius
|-
|}

==== Summon Types ====

{| width="55%" border="1" cellpadding="1" cellspacing="1"
|-
! scope="col" | Name
! scope="col" | Value
! scope="col" | Comment
|-
| TEMPSUMMON_TIMED_OR_DEAD_DESPAWN
| 1
| despawns after a specified time OR when the creature disappears
|-
| TEMPSUMMON_TIMED_OR_CORPSE_DESPAWN
| 2
| despawns after a specified time OR when the creature dies
|-
| TEMPSUMMON_TIMED_DESPAWN
| 3
| despawns after a specified time
|-
| TEMPSUMMON_TIMED_DESPAWN_OUT_OF_COMBAT
| 4
| despawns after a specified time after the creature is out of combat
|-
| TEMPSUMMON_CORPSE_DESPAWN
| 5
| despawns instantly after death
|-
| TEMPSUMMON_CORPSE_TIMED_DESPAWN
| 6
| despawns after a specified time after death
|-
| TEMPSUMMON_DEAD_DESPAWN
| 7
| despawns when the creature disappears
|-
| TEMPSUMMON_MANUAL_DESPAWN
| 8
| despawns when UnSummon() (or Force Despawn action) is called
|-
|}

==== (Event) Phases explained ====

When dealing with phases, ''phase IDs'' have to be used.

There are 7 (6+1) different phases: 1, 2, 3, 4, 5, 6 and the default, 0.

''Example'': the script is in phase 0 by default: if we want it to go to phase 1, we got two choices:

SMART_ACTION_INC_PHASE by 1 or SMART_ACTION_SET_PHASE 1

If the script is in phase 0 and want to skip to phase 2:

SMART_ACTION_INC_PHASE by 2 or SMART_ACTION_SET_PHASE 2

If the script is in phase 1 and want to skip to phase 2:

SMART_ACTION_INC_PHASE by 1 or SMART_ACTION_SET_PHASE 2

'''smart_scripts.event_phase_mask''':

The values in this field are bitmasked values:

PHASE_ALWAYS_BIT = 0,

PHASE_1_BIT = 1,

PHASE_2_BIT = 2,

PHASE_3_BIT = 4,

PHASE_4_BIT = 8,

PHASE_5_BIT = 16,

PHASE_6_BIT = 32

''Example'': if we want an event to only be able to occur in phase 1 and phase 4:

event_phase_mask = 1+8 = 9

phase 1: 1

phase 4: 8

[[Category: SkyFire World database tables]]

Installation (Windows)

2011-09-18T20:56:08Z

Marqin: decat

{| align="right"

|-

| __TOC__

|}

== INTRODUCTION ==
Before you get scared by this long guide, we assure you the procedure is quite simple. Most of the following steps are to be performed only the first time you install SkyFireEMU and only the SkyFireEMU updating procedures will need to be run from time to time.
After the first few times everyone gets used to the procedure and never needs to look at this guide ever again.

=== Software Required ===
<ol>
<li>[http://git-scm.com/download Git]</li>

<li>C++/C# Compiler: [http://www.microsoft.com/downloads/details.aspx?familyid=F3FBB04E-92C2-4701-B4BA-92E26E408569&displaylang=en#filelist Visual Studio 2008 Express] / [http://www.microsoft.com/express/Downloads/#2010-Visual-CPP Visual Studio 2010 Express] (Both free)
*'''Beware''', Express editions do not support 64-bit compilation by default and making them do so is arduous at best.
*You will need C++ for the Core and C# for the wow.exe patcher. (The patcher is now pre-compiled if you do not want to install C#)</li> 

<li>[http://www.slproweb.com/products/Win32OpenSSL.html OpenSSL]
*'''Do NOT use the light version!'''
*Download the 32bit version if you have a 32bit compiler and the 64bit bit version if you have a 64bit compiler.
*You may have to download and install one of the Microsoft Visual C++ Redistributable Packages for OpenSSL to work.</li> 

<li>[http://www.cmake.org/cmake/resources/software.html CMake]</li>

<li>MySQL Server
*You can use [http://dev.mysql.com/downloads/mysql/ MySQL Community Server] or third party packages such as [http://www.wampserver.com WAMP] or [http://www.apachefriends.org/en/xampp.html XAMPP]
*It's recommended that your MySQL server and the MySQL header source versions match.
*Current SkyFire core MySQL header version: 5.5.9
*'''Do NOT download the Essentials package''' or compiling will NOT happen and you will have problems. ''As quoted on the MySQL page:''<pre>The Windows "msi-essential-*" installers do not include: Instance Manager tool, Documentation, Development headers etc.</pre>
*Download the 32bit version if you have a 32bit compiler and the 64bit version if you have a 64bit compiler.
*If you are just planning on updating the MySQL header source and plan on using another server or package like [http://www.wampserver.com WAMP] or [http://www.apachefriends.org/en/xampp.html XAMPP], all you need to install is '''Client C API library (shared)''' under '''Development Components''' when doing a '''Custom Setup'''.</li> 

<li>[http://www.microsoft.com/downloads/details.aspx?FamilyId=333325FD-AE52-4E35-B531-508D977D32A6&displaylang=en .NET Framework 3.5] (You should already have this via your Windows updates.)</li>

<li>SQL Client: [http://www.heidisql.com/download.php HeidiSQL] [http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools]
*'''DO NOT USE NAVICAT: Due to NaviCat not being able to handle // style comments (standard SQL), we advice all users to stay VERY clear of the product - you have been warned.'''</li>
</ol>
 

=== Software Recommended ===
git command help:<ul>
<li>[http://code.google.com/p/gitextensions/ gitextensions]
*most popular with the community</li>
<li>[http://code.google.com/p/tortoisegit/ tortoisegit]
*Makes pulling and cloning sources easier with right mouse clicks.
*Also adds symbols over your folder and file icons to indicate if your source is inaccurate.
*Note: You still need to install [http://git-scm.com/download Git] for this to work.
</li>
</ul>
 

=== Microsoft Visual C++ Redistributable Packages ===

*If you use different PCs for compile/run SkyFireEMU, install one of the following packages on your Server-PC to avoid missing dependencies (dependig on your Visual Studio Version and your Server-PC Operating System) Microsoft Visual C++ 2008 Redistributable Package SP1 MFC Security Update [[http://www.microsoft.com/downloads/en/details.aspx?familyid=05ce856d-8128-408b-96fa-5e1f57b097d8&displaylang=en x86 / x64 / ia64]] Microsoft Visual C++ 2010 Redistributable Package SP1 [[http://www.microsoft.com/downloads/details.aspx?familyid=C32F406A-F8FC-4164-B6EB-5328B8578F03&displaylang=en x86]] / [[http://www.microsoft.com/downloads/details.aspx?familyid=C68CCBB6-75EF-4C9D-A326-879EAB4FCDF8&displaylang=en x64]] / [[http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=647A8A36-A058-41A4-88B2-D4A05CC0B6B3 ia64]]
 

== PULLING AND COMPILING THE SOURCE ==

*'''Before you start this phase you need to have installed Git, OpenSSL, CMake, Visual Studio, .NET Framework 3.5 (if needed) and MySQL (If you are updating the MySQL Header Source.)'''


=== Pulling the Source ===
<ol>
<li>Create a directory in which Core files will be pulled (for example: '''C:\SkyFireEMU''').</li>
<li>Right-click on the directory and click on '''Git GUI Here''' or open Git GUI from the Start menu</li>
<li>Then click '''Clone Existing Repository''' when the Git GUI dialog comes up.</li>
<li>Fill in the data as follows:
<pre>Source Location: https://github.com/ProjectSkyFire/SkyFireEMU
Target Directory: C:\SkyFireEMU\Core
</pre></li>
<li>Click on '''clone'''. Wait a few minutes (or less) and all the source files will be pulled in the directory '''C:\SkyFireEMU\Core'''.</li>
</ol>

=== Configuring and Generating Visual C++ solutions with CMake ===
<ol>
<li>Create a new directory in you C:\SkyFireEMU\ called "Build"
<li>Open CMake (cmake-gui)</li>
<li>Fill in the data as follows:
<pre>Where the the source code: C:\SkyFireEMU\Core
Where to build the binaries: C:\SkyFireEMU\Build</pre></li>
<li>Click '''Configure'''.</li>
<li>It should ask you if you want to create the directory, '''click yes'''.</li>
<li>A dialog should pop up asking you what compiler you will be using. Select the appropriate compiler and select '''Use default native compilers''' then click '''Finish'''.</li>
<li>When done, it will show you a list of options which it wants you to confirm (the top red part with the check boxes.) 
Go through them and check/uncheck those you want enabled/disabled (you can hover the options to see what they are used for). 
For now we will keep it all default except '''Tools'''. Tools will provide us with the files to make our dbc, maps and vmaps. 
So we have the following selected:
<pre>
SCRIPTS
SERVERS
TOOLS (If you want to make extractor.exe, vmap3assembler.exe, vmap3extractor.exe)
USE_COREPCH
USE_MYSQL_SOURCES (If you are NOT updating the MySQL header sources.)
USE_SCRIPTPCH
</pre>
*'''Do not worry about setting CMAKE_INTALL_PREFIX it's not used. Just keep it at it's default value (C:/Program Files/SkyFire)'''
*'''(If you are updating MySQL header source):''' If you have installed MySQL version other than 5.5, be sure to UNCHECK the WITH_MYSQL_SOURCES option. This tells CMake to look for include files and libraries in your MySQL installation instead of using the MySQL source files provided with SkyFireEMU (which are 5.5.9). Remember, unchecking WITH_MYSQL_SOURCES requires that you have full MySQL package (not Essentials) and that your selected compiler is for the same architecture (32bit/64bit) as your MySQL. If you have 5.5.x, you need not worry - just leave WITH_MYSQL_SOURCES checked.</li>
<li>Click on '''Configure''' again to verify your selection. (Most of the red should now go away.)</li>
<li>Click on '''Generate''' and it will start chugging away and creating the solutionfiles/projectfiles/makefiles it requires to build for that specific compiler.</li>
<li>When done, it'll state "Generating done"</li>
<li>Close CMake and continue below with '''Compiling the Source'''.
</ol>

=== Compiling the Source ===
<ol>
<li>Open '''SkyFire.sln''' located in your build folder with your chosen compiler.</li>
<li>Go on the top menu and click '''Build''' then click on '''Configuration Manager'''. Make sure you set the build to '''Release''' and to '''Win32''' or '''x64''' depending on the Operating System SkyFire will be running on and what you have set during CMake configuration. 
*Warning: Visual Studio 2008/2010 Express editions do not support the 64 bit platform. You will need to install the full Visual Studio, as well as additional components to enable 64 bit support. Refer to Microsoft's website and documentation for more details.</li> 
<li>Now go back to the '''Build''' menu and click on '''Clean Solution'''. Unless you are just testing a compilation, it is always best to '''clean your build before compiling.''' Compilation length differs from machine to machine, you should expect it to take 15-30 minutes. </li>
*You will find the following message once the compilation has finished successfully:
<pre>========== Build: 19 completed, 0 failed, 0 up-to-date, 1 skipped ==========
</pre>
*'''Do not worry if you get something like 5823 warnings from vmap3extractor and extractor.'''
*You will find your freshly compiled binaries in your '''C:\SkyFireEMU\Build\bin\Release''' folder.
*You will need the following files in order for the core to function properly:
<pre>ace.dll
authserver.conf.dist
authserver.exe
libmysql.dll (If you did NOT update the header source.)
worldserver.conf.dist
worldserver.exe
</pre>

*The following files will only be needed to make the dbc, maps and vmaps:
<pre>extractor.exe
vmap3assembler.exe
vmap3extractor.exe
</pre>
*Delete any other file which is not in the above lists, you will not need them. 

<li>Move the files from both lists to where ever your server will be runned from. For demonstration\instruction purposes, we will move them to C:\SkyFireEMU\Server\ 
*You may delete C:\SkyFireEMU\Build after you've move the files if you'd like.</li>
 
<li>Rename authserver.conf.dist to authserver.conf and worldserver.conf.dist to worldserver.conf These are your config files. Go through and edit each one to match your prefered settings.</li>
<li>You will also need '''libeay32.dll''' & '''ssleay32.dll''' to run your server.
This file is found in your '''OpenSSL folder''' which is usually located '''C:\OpenSSL-Win*''' Just copy and paste '''libeay32.dll''' & '''ssleay32.dll''' along with your other files in your '''C:\SkyFireEMU\Server''' folder.</li>
<li>'''(If you are updating MySQL header source):''' You will also need '''libmysql.dll''' to run your server.
This file is found in your '''MySQL folder''' which is usually located '''C:\Program Files*\MySQL\MySQL Server *\lib''' Just copy and paste '''libmysql.dll''' along with your other files in your '''C:\SkyFireEMU\Server''' folder.</li>
</ol>

=== Keeping the code up to date ===
SkyFireEMU Developers are always at work fixing and adding new features to the core so it's best you keep up to date with the code.

<ol>
<li>Simply right-click on your '''C:\SkyFireEMU\Core''' folder and click on '''Git GUI Here'''.</li>
<li>Click on the '''Remote>Fetch from>origin''' when you see green line with text '''success''' hit '''Close'''.</li>
<li>Then Click on the '''Merge>Local Merge...''' when you see the green line with text '''success''' hit '''Close'''!</li>
</ol>

*Now you can repeat the compiling procedure above. 
*'''And remember to clean your build everytime!'''
 
 

== IMPORTING THE DATABASE ==

*'''Before you start this phase you need to have installed a SQL Client and you should also have installed and set up your MySQL server and made an user account for SkyFireEMU with proper permissions to access and write data.''' 

=== Creating Auth, Characters and World Databases ===
Using your chosen SQL Client, create the three Databases.
<ol>
<li>Auth</li>
<li>Characters</li>
<li>World</li>
</ol>
*Doing this may prevent importing problems later.


==== Importing Auth and Characters Databases ====
Using your chosen SQL Client,
import both the auth_database.sql and characters_database.sql files located in '''C:\SkyFireEMU\Core\sql\base''' to their respective places in your MySQL database.
*'''DO NOT IMPORT WORLD_DATABASE.SQL FROM THIS DIRECTORY UNLESS YOU WANT A COMPLETELY BLANK WORLD.'''

==== Importing World Database ====
<ol>
<li>Open '''Database_Installer_Updater.bat''' found in '''C:\SkyFireEMU\Core\database'''</li>
<li>Follow the dialog and enter in your info.</li>

Example:<pre>
MySQL Server Address (e.g. localhost):localhost

MySQL Username: root
MySQL Password: pass

World Database: world
</pre></li>
<li>Press '''1''' to install the World Database and all current updates when asked.</li>
<li>Wait for the installer to do it's magic. After it is done, press any key to go back to the main menu.</li>
<li>Install locals if you want.</li>
<li>Press '''X''' to exit.</li>
</ol>
Done!

==== Importing Important Database Structure Updates ====
<ol>
<li>Go into your '''C:\SkyFireEMU\core\sql\updates''' directory.</li>
<li>Apply updates to their appropriate corresponding databases using your chosen SQL client.</li>
</ol>


==== Importing World Database Updates ====
<ol>
<li>Open '''Database_Installer_Updater.bat''' found in '''C:\SkyFireEMU\Core\database'''</li>
<li>Follow the dialog and enter in your info like you did before.</li>
<li>Press '''U''' to import the World Database updates when asked.</li>
<li>Select the correct changesets needed.</li>
</ol>
*Or.. if you are a "pro" use your SQL client and import needed changes from '''C:\SkyFireEMU\Core\database\updates'''


=== Auth Database Accounts and Passwords ===
It is '''highly advised''' you change the passwords or delete these accounts
<pre>User: Administrator
Pass: Administrator

User: Moderator
Pass: Moderator

User: Developer
Pass: Developer

User: Gamemaster
Pass: Gamemaster

User: Player
Pass: Player</pre>

==== Changing passwords ====
You can change a password to an account simply by going to your Worldserver console and type<pre>account set password <accountname> <newpassword> <newpassword></pre>

==== Deleting accounts ====
You can delete an account simply by going to your Worldserver console and type<pre>account delete <accountname></pre>

==== Making new accounts ====
You can make a new account simply by going to your Worldserver console and type<pre>account create <accountname> <password></pre>

==== Raising an account's access/GM level ====
You can raise an account level simply by going to your Worldserver console and type<pre>account set gmlevel <accountname> <gmlevel> <realmid></pre>Or you can go into your Auth database via your SQL Client, select '''account_access''' and add a new line.
*id=your account id found under '''accounts'''
*GM/Access Levels: 0=Regular player, 1=Gamemaster, 2=Developer, 3=Moderator, 4=Administrator
**You can only add Administrator (gmlevel 4) with your SQL client
*RealmID is usually 1 or -1 for all realms
 
 

== DBC, MAPS AND VMAPS ==

*You can also download a copy of these tools which are already compiled from https://github.com/ProjectSkyfire/SkyFire-Community-Tools 
<ol>
<li>'''Before you begin to do anything,''' make sure you change '''SET accounttype "LK"''' to '''SET accounttype "CT"''' in your '''Config.wtf & launcher.wtf''' files located in your WTF folder. It's usually found '''C:\Program Files (x86)\World of Warcraft\WTF'''
*'''Then run launcher.exe and allow it to update your data files to the Cataclysm expansion, must download fully.'''
*If you still have problems delete your whole WTF folder and rerun launcher to generate both .wtf files again then redo the whole step above.
<li>Move extractor.exe, vmap3assembler.exe and vmap3extractor.exe to your wow directory (C:\Program Files (x86)\World of Warcraft)</li>
<li>Open a command prompt to your wow directory (cd C:\Program Files (x86)\World of Warcraft)</li>
</ol>

=== dbc and maps ===
<ol>
<li>In your command prompt type '''extractor.exe''' and hit enter.</li>
<li>Wait until finished.</li>
<li>It should have made two new directories, '''dbc''' and '''maps'''.</li>
<li>Move both of these folders to your Server folder/machine. (C:\SkyFireEMU\Server if you have been following from above.)</li>
</ol>

=== vmaps ===
<ol>
<li>In your command prompt type '''vmap3extractor.exe''' and hit enter.</li>
<li>Wait until finished.</li>
<li>It should have made a new directory named '''Buildings'''.</li>
<li>In your command prompt type '''mkdir vmaps''' or simply make a '''new folder''' and rename it to '''vmaps'''.</li>
<li>Then in your command prompt again, type '''vmap3assembler.exe Buildings vmaps''' and hit enter.</li>
<li>Wait until finished.</li>
<li>Move your '''vmaps''' folder to your Server folder/machine where your '''dbc''' and '''maps''' folder are. (Again, C:\SkyFireEMU\Server if you have been following from above.)</li>
</ol> 
*You may delete your '''Buildings''' folder if you want. It is not needed.
 
 

== SKYFIRE WOW.EXE PATCHER ==
Your Wow.exe client will be needed to be patched before you can properly connect to your server.


=== Pulling ===
You should be an expert with pulling sources by now. So just do the same thing here.
https://github.com/SkyFire/SkyFire-Community-Tools
*The patcher is already pre-compiled in directory: ''''..\SkyFire Patcher\406a'''. So after you pull, you can skip the compiling steps below.


=== Compile ===

*'''Note: The patcher is made in C# and not C++. You need a C# compiler to compile it.'''
*You will not need CMake for this.
<ol>
<li>Open SkyFirePatcher.sln (located in '''..Sources\Patcher''') with C#.</li>
<li>Select "Release"</li>
<li>The platform should be "Any" (No separate 32/64 bit versions.)</li>
<li>Clean</li>
<li>Build. (This should take less than a minute.)</li>
</ol>

*Do not worry if you get an error like:<pre>..Sources\Patcher\SkyFirePatcher\Form1.cs(20,13): warning CS0414: The field 'SkyFirePatcher.Form1.exeLength' is assigned but its value is never used</pre>


=== Keeping the code up to date ===
Again, you should be an expert by now with this pulling the source stuff. It's basically the same thing.

=== Moving and Patching ===

*After you compiled it, you should have SkyFirePatcher.exe in your '''..Sources\Patcher\SkyFirePatcher\bin\Release''' folder. (You can delete the rest if you like.)

<ol>
<li>Move SkyFirePatcher.exe into your Wow directory. (Usually something like C:\Program Files (x86)\World of Warcraft)</li>

<li>Now run SkyFirePatcher.exe and a dialog should pop up with:
<pre>Loading Wow.exe into memory...
Success!
Ready to patch Wow.exe.</pre>
And "Status: Ready!" at the bottom.</li>

<li>Click "Patch" at the bottom to patch your Wow.exe 
It will make a backup of your original Wow.exe as well. (Something like wow-original.exe)</li>
</ol>

=== Play! ===
*Use your new patched Wow.exe file to play on your server and the backed up original Wow.exe to play to retail.
 
 
 

== References ==

http://www.trinitycore.org/w/How-to:Win

http://wiki.cactusemu.com/index.php?title=Installation_%28Windows%29

Video tutorial: [http://www.youtube.com/watch?v=sitxeaONV5A Pulling core repository with TortoiseGit]

Video tutorial: [http://www.youtube.com/watch?v=ec3zxCmaVq4 CMake x64]

Video tutorial: [http://www.youtube.com/watch?v=TdPwKUy9gkE Compiling x64]

Video tutorial: [http://www.youtube.com/watch?v=uqbbpgJSUF0 Importing the databases and structure updates]

Video tutorial: [http://www.youtube.com/watch?v=JoA5tSeTWn4 dbc, map and vmaps]

[[Category:Installation]]

Installation (Linux)

2011-09-18T20:56:00Z

Marqin: decat

== Introduction ==

This is a basic guide on how to install SkyFireEMU and SkyFireDB from scratch with small modifications though it can be applied to all Linux versions. **Please note this is a work in progress and only contains enough information to get most people a viable server in Linux.

== Prerequisites ==

The compilation of SkyFireEMU and the setup of SkyFireDB will require certain packages to be installed. In Ubuntu use the following command:

<pre>sudo apt-get install build-essential autoconf libtool gcc g++ make cmake subversion git patch wget links zip unzip unrar openssl libssl-dev mysql-server mysql-client libmysqlclient15-dev libmysql++-dev libreadline5-dev zlib1g-dev libbz2-dev git-core libace-dev</pre>

In RedHat/Fedora based distributions use this command:

<pre>yum groupinstall "development tools" "development libraries"
yum install gcc-c++ git wget links zip unzip unrar mysql-server mysql-client mysql-devel openssl cmake</pre>

You may also want to install phpmyadmin and/or Apache. Do not forget the user and password for the Mysql root user.

'''Installing ACE'''

Start by downloading and unzipping the source

<pre>wget http://download.dre.vanderbilt.edu/previous_versions/ACE-5.7.8.tar.gz
tar xvzf ACE-5.7.8.tar.gz
cd ~/ACE_wrappers/</pre>

Here is where we compile ACE

<pre>mkdir build
cd build
../configure --prefix=/home/`echo $USER`/.sys/
make -j(#cores+1)
make install</pre>

<pre>The reason I state (#cores+1) in the make statement, is because of multi-core processors.
In the event one has a 4-core processor, you would use "make -j5", minus quotations.
Note: There is NO SPACE inbetween j and 5. It's all a single stroke.</pre>

'''Installing OpenSSL''' - You should check if "0.9.8o" is the latest version

The entire procedure here is for people that do believe they need the latest revision - normally the version that comes with your distribution is sufficient enough.

32-bit Debian-based distributions (These no longer exist at the below locations but you can apt-get them if they dont come preinstalled with you openssl install from above)

<pre>wget ftp://ftp.debian.org/debian/pool/main/o/openssl/libssl-dev_0.9.8o-5_i386.deb
wget ftp://ftp.debian.org/debian/pool/main/o/openssl/libssl0.9.8_0.9.8o-5_i386.deb
wget ftp://ftp.debian.org/debian/pool/main/o/openssl/openssl_0.9.8o-5_i386.deb
sudo dpkg -i libssl0.9.8_0.9.8o-5_i386.deb
sudo dpkg -i openssl_0.9.8o-5_i386.deb
sudo dpkg -i libssl-dev_0.9.8o-5_i386.deb</pre>

Debian-based distributions (These no longer exist at the below locations but you can apt-get them if they dont come preinstalled with you openssl install from above)

<pre>wget ftp://ftp.debian.org/debian/pool/main/o/openssl/libssl-dev_0.9.8o-1_amd64.deb
wget ftp://ftp.debian.org/debian/pool/main/o/openssl/libssl0.9.8_0.9.8o-1_amd64.deb
wget ftp://ftp.debian.org/debian/pool/main/o/openssl/openssl_0.9.8o-1_amd64.deb
sudo dpkg -i libssl0.9.8_0.9.8o-1_amd64.deb
sudo dpkg -i openssl_0.9.8o-1_amd64.deb
sudo dpkg -i libssl-dev_0.9.8o-1_amd64.deb</pre>

Other distributions

For cases where you want to run an even newer release of OpenSSL than mentioned here, or your distribution not supplying a version that isn't of recent date, please check your distributions repositories or documentation. You can also retrieve it as sourcecode at http://openssl.org/source (feel free to use newer packages if you really feel like it). To build it from sourcecode, here's a primer :

<pre>wget http://openssl.org/source/openssl-0.9.8o.tar.gz
tar -xvf openssl-0.9.8o.tar.gz
cd openssl-0.9.8o
mkdir build
cd build</pre>

Alternative 1 : Local installation

<pre>../config --prefix=/home/`echo $USER`/.sys shared
make
make install</pre>

Alternative 2 : Systemwide installation

<pre>../config shared
make
sudo make install</pre>

Please note that any old revision of the OpenSSL package installed by the distribution may/will interfere with the new version. See your distribution documentation for information on how to remove it to be able to use the new one.

== Compiling and Installing the SkyFireEMU ==

Grab the latest version of SkyFireEMU using git:

<pre>git clone git://github.com/ProjectSkyfire/SkyFireEMU.git</pre>

or if you prefer 4.2.0 use
<pre>git clone git://github.com/ProjectSkyfire/SkyFireEMU_420.git</pre>

This should create a directory called SkyFireEMU that will contain all the files necessary to compile the server and it's tools. Change to the directory, configure, and build.

<pre>cd SkyFireEMU
mkdir build
cd build
cmake ../ -DPREFIX=/home/`echo $USER`/skyfire -DTOOLS=1
make -j(#cores+1)
make install</pre>

Parameter explanations

<pre>-DACE_LIBRARY=<path to ACE library> (full path to your libACE.so file INCLUDING the filename - do not use if you have ACE installed systemwide)
-DACE_INCLUDE_DIR=<path to ACE includes/headers> (path to the libACE include directory - do not use if you have ACE installed systemwide)
-DOPENSSL_LIBRARIES=<path to OpenSSL library> (path to your OpenSSL library - do not use if you have OpenSSL installed systemwide)
-DOPENSSL_INCLUDE_DIR=<path to OpenSSL includes> (path to your OpenSSL includes directory - do not use if you have OpenSSL installed systemwide)

-DSERVERS Build worldserver and authserver
-DSCRIPTS Build core with scripts included
-DTOOLS Build map/vmap extraction/assembler tools
-DUSE_SCRIPTPCH Use precompiled headers when compiling scripts
-DUSE_COREPCH Use precompiled headers when compiling servers
-DUSE_SFMT Use SFMT as random numbergenerator
-DWITH_WARNINGS Show all warnings during compile
-DWITH_COREDEBUG Include additional debug-code in core
-DWITH_SQL Copy SQL files during installation
-DPREFIX Set installation directory
-DCONF_DIR Set configuration directory
-DLIBSDIR Set library directory
-DCMAKE_C_FLAGS Set C_FLAGS for compile (advanced users only)
-DCMAKE_CXX_FLAGS Set CXX_FLAGS for compile (advanced users only)</pre>

== Installing SkyFireDB ==

Now, install the DB framework for which SkyFireDB will be installed to:

<pre>mysql -u <mysql_root> -p<password> < ~/SkyFireEMU/sql/create/create_mysql.sql
mysql -u <mysql_root> -p<password> auth < ~/SkyFireEMU/sql/base/auth/auth.sql
mysql -u <mysql_root> -p<password> characters < ~/SkyFireEMU/sql/base/character/character.sql</pre>

<pre>Replace the parts in <> to the correct administrative username, and associated password.
Usually administrative user is root, however if you set up mysql correctly, it will be a uname
associated with SkyFire.</pre>

Grab the latest version of SkyFireDB using the git command:

<pre>git clone git://github.com/ProjectSkyfire/SkyFireDB.git</pre>

This will create a directory called SkyFireDB that will contain the "World" database that the server will need. Edit the database installer and then install the World database:

Edit "mysql_user", "mysql_pass", and "new_world".
<pre> can be done with nano, gedit, scite, etc. Command is (most easily):
nano ~/SkyFireDB/linux_installer.sh</pre>

Now run the installer to install the world database:

<pre>sh ~/SkyFireDB/linux_installer.sh</pre>

Press "i" to install a new World database

(If this fails comment out line #104 by placeing a # at the begging. For some reason the script is jacked up but after commenting that out it works fine.)

(If you are doing this for more than local use you will also need to change a database entry using this mysql command.)
<pre>update auth.realmlist set adress = "YOUR IP HERE" where id = 1;</pre>

== Configuration ==

Now move and edit the configuration files to run the server.

<pre>mv ~/skyfire/etc/worldserver.conf.dist ~/skyfire/etc/worldserver.conf
mv ~/skyfire/etc/authserver.conf.dist ~/skyfire/etc/authserver.conf</pre>

Edit both of these files to the correct Mysql user name, password, and your DataDir.
<pre>nano ~/skyfire/etc/(correctserver).conf</pre>

== Extractor and VMAPs ==

If you need a Windows compiled copy of the DBC Extractor and the tools for the VMAP 
Extraction and assembly you can get a copy of them using your GIT client and download 
them from: https://github.com/ProjectSkyfire/SkyFire-Community-Tools 

Before doing any of these commands, follow the guide at
<pre>http://appdb.winehq.org/objectManager.php?sClass=version&iId=20549</pre>
to obtain a working installation of the latest WoW 4.0.X client, then proceed:

The last and final step of setting up SkyFireEMU is to obtain a proper set of maps for use in the server. Change to the WoW directory and run some commands:

<pre>cd "Wow Directory"
~/skyfire/bin/extractor
~/skyfire/bin/vmap3extractor
mv dbc ~/skyfire/bin/dbc
mv maps ~/skyfire/bin/maps
mkdir vmaps
~/skyfire/bin/vmap3assembler
mv vmaps ~/skyfire/bin/
</pre>

== SkyFire Patcher ==

The client will need to be patched before it can properly connect to the server. Acquire the patcher in the Community Tools repository.

<pre>git clone git://github.com/ProjectSkyfire/SkyFire-Community-Tools.git</pre>

Install Mono in Wine or Crossover Office and run the patcher to modify your WoW.exe file.

to install Mono simply, and correctly configured, please view:
<pre>http://wiki.winehq.org/winetricks</pre>
to obtain specific versions/running hackery in your Wine bottle.

== References ==

http://www.trinitycore.org/w/How-to:Linux

http://wiki.cactusemu.com/index.php?title=Installation_%28Linux%29

http://wiki.winehq.org/winetricks

http://appdb.winehq.org/objectManager.php?sClass=version&iId=20549

[[Category:Installation]]

Category:SkyFire Auth database tables

2011-09-17T12:37:21Z

Marqin: Created page with "Category: Categories"

[[Category: Categories]]

Areatrigger involvedrelation SF

2011-09-17T12:36:00Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `areatrigger_involvedrelations` table'''</big>

This table holds the information for when an areatrigger completes an objective for a quest, such as an exploration quest.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|The ID# of the areatrigger to use for the quest. Contained in AreaTrigger.dbc.
|-
|[[#quest|quest]]
|mediumint(8)
|unsigned
|
|The ID# of the quest that the areatrigger completes the objective. Contained in [[Quest_template_SF|quest_template]]
|}

Areatrigger tavern SF

2011-09-17T12:35:50Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `areatrigger_tavern` table'''</big>

This table holds the information of when to enter the player into a Resting state.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|ID# of the areatrigger. Contained in AreaTrigger.dbc.
|-
|[[#name|name]]
|text
|
|
|The name of the areatrigger or zone. Used for easy reference purposes.
|}

Areatrigger teleport SF

2011-09-17T12:35:45Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `areatrigger_teleport` table'''</big>

This table holds the information for "zone portals."

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|The ID# of the areatrigger. Contained in AreaTrigger.dbc.
|-
|[[#name|name]]
|text
|
|
|The name for the areatrigger. Used for easy reference purposes.
|-
|[[#target_map|target_map]]
|float
|signed
|
|The ID# of the map to teleport to. Contained in Maps.dbc.
|-
|[[#target_position_x|target_position_x]]
|float
|signed
|
|The X coordinate to spawn the player.
|-
|[[#target_position_y|target_position_y]]
|float
|signed
|
|The Y coordinate to spawn the player.
|-
|[[#target_position_z|target_position_z]]
|float
|signed
|
|The Z coordinate to spawn the player.
|-
|[[#target_orientation|target_orientation]]
|float
|signed
|
|The orientation to spawn the player (0 = North, moving clockwise. Circle is Pi*2).
|}

Creature questrelation SF

2011-09-17T12:35:38Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `creature_questrelations` table'''</big>

This table holds the information for what creatures start what quests.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|The ID# of the creature that starts the quest. Contained in [[Creature_template_SF|creature_template]].
|-
|[[#quest|quest]]
|mediumint(8)
|unsigned
|
|The ID# of the quest that the creature starts .Contained in [[Quest_template_SF|quest_template]].
|}

Creature involvedrelation SF

2011-09-17T12:35:35Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `creature_involvedrelations` table'''</big>

This table holds the information for what creatures end what quests.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|The ID# of the creature that ends the quest. Contained in [[Creature_template_SF|creature_template]].
|-
|[[#quest|quest]]
|mediumint(8)
|unsigned
|
|The ID# of the quest that the creature ends. Contained in [[Quest_template_SF|quest_template]].
|}

Battleground template SF

2011-09-17T12:35:32Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `battleground_template` table'''</big>

This table hold the basic information about battlegrounds.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|ID# of the battleground. Contained in BattlemasterList.dbc.
|-
|[[#MinPlayersPerTeam|MinPlayersPerTeam]]
|smallint(5)
|unsigned
|
|The required number of players in each level bracket to start the battleground.
|-
|[[#MaxPlayersPerTeam|MaxPlayersPerTeam]]
|smallint(5)
|unsigned
|
|The maximum number of players that can be in the battleground.
|-
|[[#MinLvl|MinLvl]]
|tinyint(3)
|unsigned
|
|The minimum level you must be to join the battleground.
|-
|[[#MaxLvl|MaxLvl]]
|tinyint(3)
|unsigned
|
|The maximum level you can be to join the battleground (Usually 85).
|-
|[[#AllianceStartLoc|AllianceStartLoc]]
|mediumint(8)
|unsigned
|
|The location within the battlegrounds all Alliance players will start. Contained in WorldSafeLocs.dbc.
|-
|[[#AllianceStartO|AllianceStartO]]
|float
|signed
|
|The orientation the Alliance players will be when the spawn (North = 0, moves clockwise).
|-
|[[#HordeStartLoc|HordeStartLoc]]
|mediumint(8)
|unsigned
|
|The location within the battlegrounds all Horde players will start. Contained in WorldSafeLocs.dbc.
|-
|[[#HordeStartO|HordeStartO]]
|float
|signed
|
|The orientation the Horde. players will be when the spawn (North = 0, moves clockwise).
|-
|[[#Weight|Weight]]
|tinyint(2)
|unsigned
|1
|
|-
|[[#ScriptName|ScriptName]]
|char(64)
|signed
|
|
|-
|[[#Comment|Comment]]
|char(32)
|signed
|
|A simple comment (Generally just the name of the battleground for easy reference).
|-
|}

Achievement reward SF

2011-09-17T12:35:29Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `achievement_reward` table'''</big>

This table holds the information for awarding items to players via in-game mail when the earn certain achievements.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#entry|entry]]
|mediumint(8)
|unsigned
|
|The ID of the achievement. Found in Achievements.dbc.
|-
|[[#title_A|title_A]]
|mediumint(8)
|unsigned
|
|The ID of the title to award to Alliance players who gain the achievement. Found in CharTitles.dbc.
|-
|[[#title_H|title_H]]
|mediumint(8)
|unsigned
|
|The ID of the title to award to Horde players who gain the achievement. Found in CharTitles.dbc
|-
|[[#item|item]]
|mediumint(8)
|unsigned
|
|The ID of the item to be mailed to the player. Found in [[Item_template_SF|item_template]].
|-
|[[#sender|sender]]
|mediumint(8)
|unsigned
|
|The ID of the creature who sends the mail. Found in [[Creature_template_SF|creature_template]]
|-
|[[#subject|subject]]
|varchar(225)
|signed
|
|The subject of the mail to be sent.
|-
|[[#text|text]]
|text
|signed
|
|The text contained in the mail to be sent.
|}

Creature onkill reputation SF

2011-09-17T12:35:26Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `creature_onkill_reputation` table'''</big>

This table holds the information for awarding reputation for killing a specified creature.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#creature_id|creature_id]]
|mediumint(8)
|unsigned
|
|The creature's ID that will award rep. Found in [[Creature_template_SF|creature_template]].
|-
|[[#RewOnKillRepFaction1|RewOnKillRepFaction1]]
|smallint(6)
|signed
|
|The ID# of the faction that you will gain/lose rep with. Found in Faction.dbc.
|-
|[[#RewOnKillRepFaction2|RewOnKillRepFaction2]]
|smallint(6)
|signed
|
|The ID# of the faction that you will gain/lose rep with. Found in Faction.dbc.
|-
|[[#MaxStanding1|MaxStanding1]]
|tinyint(4)
|signed
|
|The maximum standing (0-7 (Hated-Exalted)) that will award rep until for RewOnKillRepFaction1.
|-
|[[#IsTeamAward1|IsTeamAward1]]
|tinyint(4)
|signed
|
|Specifies if the kill should also award rep to the meta faction (0 = Off, 1 = On) for RewOnKillRepFaction1.
|-
|[[#RewOnKillRepValue1|RewOnKillRepValue1]]
|mediumint(9)
|signed
|
|Amount of rep the kill should award to RewOnKillRepFaction1.
|-
|[[#MaxStanding2|MaxStanding2]]
|tinyint(4)
|signed
|
|The maximum standing (0-7 (Hated-Exalted)) that will award rep until for RewOnKillRepFaction2.
|-
|[[#IsTeamAward2|IsTeamAward2]]
|tinyint(4)
|signed
|
|Specifies if the kill should also award rep to the meta faction (0 = Off, 1 = On) for RewOnKillRepFaction2.
|-
|[[#RewOnKillRepValue2|RewOnKillRepValue2]]
|mediumint(9)
|signed
|
|Amount of rep the kill should award to RewOnKillRepFaction2.
|-
|[[#TeamDependent|TeamDependent]]
|tinyint(3)
|unsigned
|
|Specifies if the kill should award rep from both factions to all players or Alliance for 1 and Horde for 2 (0 = Off, 1 = On).
|}

Creature formations SF

2011-09-17T12:35:16Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `creature_formations` table'''</big>

This table holds the information for the creation of "formed" creatures (Creatures with attached separate entities). This does '''not''' hold data for shared health pools. An example of this would be [http://www.wowhead.com/npc=32930/ Kologarn] with his main body being the leader and his right and left arms being members.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#leaderGUID|leaderGUID]]
|int(11)
|unsigned
|
|The main ("body") creature's GUID. Found in [[Creature_SF|Creature]].
|-
|[[#memberGUID|memberGUID]]
|int(11)
|unsigned
|
|The GUID of the "limb" creature. Found in [[Creature_SF|Creature]].
|-
|[[#dist|dist]]
|float
|unsigned
|
|The distance away from the "body" of the creature the member should be.
|-
|[[#angle|angle]]
|float
|unsigned
|
|The angle the member should be at.
|-
|[[#groupAI|groupAI]]
|int(11)
|unsigned
|
|
|}

Command SF

2011-09-17T12:35:07Z

Marqin:

{| align="right"
| __TOC__
|}
{{Back-to:World}}
[[Category: SkyFire World database tables]]

<big>'''The `command` table'''</big>

This table holds the security levels for the various commands.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attribute'''
|'''Default'''
|'''Comment'''
|-
|[[#name|name]]
|varchar(50)
|signed
|
|Name of the command.
|-
|[[#security|security]]
|tinyint(3)
|unsigned
|
|The minimum security level required to use the command.
|-
|[[#help|help]]
|longtext
|signed
|
|The in-game syntax for proper use of the command.
|}

User talk:Hiyoo

2011-09-17T10:44:11Z

Marqin: Created page with "{{Welcome|--~~~~}}"

User talk:Lotus-blade

2011-09-17T10:44:08Z

Marqin: Created page with "{{Welcome|--~~~~}}"

User talk:Ozhaaraz

2011-09-17T10:44:05Z

Marqin: Created page with "{{Welcome|--~~~~}}"

User talk:Willgtl

2011-09-16T17:01:56Z

Marqin: Created page with "{{welcome|--~~~~}}"

{{welcome|--[[User:Marqin|Marqin]] [[User_talk:Marqin|talk]] 12:01, 16 September 2011 (CDT)}}

User talk:Quux

2011-09-09T16:13:26Z

Marqin: Created page with "{{Welcome|--~~~~}}"

User talk:Subv

2011-09-06T15:18:21Z

Marqin: Created page with "{{Welcome|--~~~~}}"

User talk:CaptSilver

2011-09-05T16:36:55Z

Marqin: Created page with "{{Welcome|--~~~~}}"

Npc trainer SF

2011-09-04T21:00:50Z

Marqin:

{| align="right"

| __TOC__

|}

[[Category: SkyFire World database tables]]

{{Back-to:World}}

<big>'''The `npc_trainer` table'''</big>

This table holds all the spells that each trainer can teach.

<big>'''Structure'''</big>

{| border="1"

|'''Field'''

|'''Type'''

|'''Attributes'''

|'''Key'''

|'''Null'''

|'''Default'''

|'''Extra'''

|'''Comment'''

|-

|[[#entry|entry]]

|mediumint(8)

|unsigned

|PRI

|NO

|0

|

|

|-

|[[#spell|spell]]

|mediumint(8)

|signed

|PRI

|NO

|0

|

|

|-

|[[#spellcost|spellcost]]

|int(10)

|unsigned

|

|NO

|0

|

|

|-

|[[#reqskill|reqskill]]

|smallint(5)

|unsigned

|

|NO

|0

|

|

|-

|[[#reqskillvalue|reqskillvalue]]

|smallint(5)

|unsigned

|

|NO

|0

|

|

|-

|[[#reqlevel|reqlevel]]

|tinyint(3)

|unsigned

|

|NO

|0

|

|

|}

<big>'''Description of the fields'''</big>

====entry====

The template ID of the creature. See [[creature_template_tc2#entry|creature_template.entry]]

333a: Entry can also be used as a reference, Biohazard referenced all the trainers for more information see [[Trainer_reference_tdb|Reference_list]]

====spell====

The spell ID from Spell.dbc

====spellcost====

The cost that the player needs to pay in order to learn the spell in copper. If you get this information from a data site such as Wowhead, be sure to take into account that they usually post the discounted prices based on friendly to exalted with a given faction.

==== reqskill ====

The required skill the player needs to have in order to be able to learn the spell. See ID in [[SkillLine.dbc tc2|SkillLine.dbc]])

====reqskillvalue====

The proficiency in the skill from [[#reqskill|reqskill]] that the player needs to meet in order to learn the spell.

====reqlevel====

The level the player needs to be in order to learn the spell.

Creature template SF

2011-09-04T21:00:42Z

Marqin:

{| align="right"
|-
| __TOC__
|}

{{Back-to:World}}

 <big>'''The `creature_template` table'''</big>

This table contains the description of creatures. Each spawned creature is an instance of a template present in this table, this means every creature MUST be defined in this table.

 <big>'''Structure'''</big>

{| border="1"
|-
| '''Field'''
| '''Type'''
| '''Attributes'''
| '''Key'''
| '''Null'''
| '''Default'''
| '''Extra'''
| '''Comment'''
|-
| [[#entry|entry]]
| mediumint(8)
| unsigned
| PRI
| NO
| 0
|
|
|-
| [[#difficulty_entry_1-3|difficulty_entry_1]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#difficulty_entry_1-3|difficulty_entry_2]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#difficulty_entry_1-3|difficulty_entry_3]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#KillCredit1|KillCredit1]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#KillCredit2|KillCredit2]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#modelid1-4|modelid1]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#modelid1-4|modelid2]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#modelid1-4|modelid3]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#modelid1-4|modelid4]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#name|name]]
| char(100)
| signed
|
| NO
| 0
|
|
|-
| [[#subname|subname]]
| char(100)
| signed
|
| YES
| NULL
|
|
|-
| [[#IconName|IconName]]
| char(100)
| signed
|
| YES
| NULL
|
|
|-
| [[#gossip_menu_id|gossip_menu_id]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#minlevel|minlevel]]
| tinyint(3)
| unsigned
|
| NO
| 1
|
|
|-
| [[#maxlevel|maxlevel]]
| tinyint(3)
| unsigned
|
| NO
| 1
|
|
|-
| [[#exp|exp]]
| smallint(2)
| signed
|
| NO
| 0
|
|
|-
| [[#faction_A|faction_A]]
| smallint(5)
| unsigned
|
| NO
| 0
|
|
|-
| [[#faction_H|faction_H]]
| smallint(5)
| unsigned
|
| NO
| 0
|
|
|-
| [[#npcflag|npcflag]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#speed_walk|speed_walk]]
| float
| signed
|
| NO
| 1
|
| Result of 2.5/2.5, most common value
|-
| [[#speed_run|speed_run]]
| float
| signed
|
| NO
| 1.14286
|
| Result of 8.0/7.0, most common value
|-
| [[#scale|scale]]
| float
| signed
|
| NO
| 1
|
|
|-
| [[#rank|rank]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#mindmg|mindmg]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#maxdmg|maxdmg]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#dmgschool|dmgschool]]
| tinyint(4)
| signed
|
| NO
| 0
|
|
|-
| [[#attackpower|attackpower]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#dmg_multiplier|dmg_multiplier]]
| float
| signed
|
| NO
| 1
|
|
|-
| [[#baseattacktime|baseattacktime]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#rangeattacktime|rangeattacktime]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#unit_class|unit_class]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#unit_flags|unit_flags]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#dynamicflags|dynamicflags]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#family|family]]
| tinyint(4)
| signed
|
| NO
| 0
|
|
|-
| [[#trainer_type|trainer_type]]
| tinyint(4)
| signed
|
| NO
| 0
|
|
|-
| [[#trainer_spell|trainer_spell]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#trainer_class|trainer_class]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#trainer_race|trainer_race]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#minrangedmg|minrangedmg]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#maxrangedmg|maxrangedmg]]
| float
| signed
|
| NO
| 0
|
|
|-
| [[#rangedattackpower|rangedattackpower]]
| smallint(5)
| unsigned
|
| NO
| 0
|
|
|-
| [[#type|type]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#type_flags|type_flags]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#lootid|lootid]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#pickpocketloot|pickpocketloot]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#skinloot|skinloot]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#resistance1|resistance1]]
| smallint(5)
| signed
|
| NO
| 0
|
|
|-
| [[#resistance2|resistance2]]
| smallint(5)
| signed
|
| NO
| 0
|
|
|-
| [[#resistance3|resistance3]]
| smallint(5)
| signed
|
| NO
| 0
|
|
|-
| [[#resistance4|resistance4]]
| smallint(5)
| signed
|
| NO
| 0
|
|
|-
| [[#resistance5|resistance5]]
| smallint(5)
| signed
|
| NO
| 0
|
|
|-
| [[#resistance6|resistance6]]
| smallint(5)
| signed
|
| NO
| 0
|
|
|-
| [[#spell1|spell1]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#spell2|spell2]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#spell3|spell3]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#spell4|spell4]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#spell5|spell5]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#spell6|spell6]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#spell7|spell7]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#spell8|spell8]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#PetSpellDataId|PetSpellDataId]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#VehicleId|VehicleId]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#mingold|mingold]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#maxgold|maxgold]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#AIName|AIName]]
| char(64)
| signed
|
| NO
| "
|
|
|-
| [[#MovementType|MovementType]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#InhabitType|InhabitType]]
| tinyint(3)
| unsigned
|
| NO
| 3
|
|
|-
| [[#Health_mod|Health_mod]]
| float
| signed
|
| NO
| 1
|
|
|-
| [[#Mana_mod|Mana_mod]]
| float
| signed
|
| NO
| 1
|
|
|-
| [[#Armor_mod|Armor_mod]]
| float
| signed
|
| NO
| 1
|
|
|-
| [[#RacialLeader|RacialLeader]]
| tinyint(3)
| unsigned
|
| NO
| 0
|
|
|-
| [[#QuestItem1-6|QuestItem1]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#QuestItem1-6|QuestItem2]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#QuestItem1-6|QuestItem3]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#QuestItem1-6|QuestItem4]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#QuestItem1-6|QuestItem5]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#QuestItem1-6|QuestItem6]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#movementID|movementID]]
| int(11)
| unsigned
|
| NO
| 0
|
|
|-
| [[#RegenHealth|RegenHealth]]
| tinyint(3)
| unsigned
|
| NO
| 1
|
|
|-
| [[#equipment_id|equipment_id]]
| mediumint(8)
| unsigned
|
| NO
| 0
|
|
|-
| [[#mechanic_immune_mask|mechanic_immune_mask]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#flags_extra|flags_extra]]
| int(10)
| unsigned
|
| NO
| 0
|
|
|-
| [[#ScriptName|ScriptName]]
| char(64)
| signed
|
| NO
| "
|
|
|-
| [[#WDBVerified|WDBVerified]]
| smallint(5)
| signed
|
| YES
| 1
|
|
|}

 <big>'''Description of the fields'''</big>

==== entry ====

Creature's unique id.

==== difficulty_entry_1-3 ====

This field connects the stats from another [[#entry|entry]] to this template when in 25man normal, 10man heroic or 25man heroic mode instance.

==== KillCredit1 ====

If this is a kill credit template -- one that is a dummy template that is used when more than one creature can count as a kill in a quest, then this is a link the the fist [[#entry|entry]] of the creature that could be killed to give quest credit.

==== KillCredit2 ====

If this is a kill credit template -- one that is a dummy template that is used when more than one creature can count as a kill in a quest, then this is a link the the second [[#entry|entry]] of the creature that could be killed to give quest credit. If more than two creatures can be killed and count toward a single objective, an EAI or C++ script will be required.

==== modelid1-4 ====

A random graphical model that the client applies on this creature. This is a [[Creature model info tc2#entry|creature_model_info.entry]]

==== name ====

Base name of the creature.

==== subname ====

The subname of the creature that appears in <> below the creature's name.

==== IconName ====

Script icon used by guards with directions menu.

==== gossip_menu_id ====

The gossip ID of this creature. This field is obtained from sniff (update fields). If you can not sniff this value, and need to make one up, it must be > 50000. This field is the link to [[Gossip menu tc2#entry|gossip_menu.entry]].

==== minlevel ====

The minimum level of the creature if the creature has a level range.

==== maxlevel ====

The maximum level of the creature if the creature has a level range. When added to world, a level in chosen in the specified level range.

==== exp ====

The expansion table the creatures health value is taken from. Values are from 0 to 3.
----
Value 0 = PreTBC - BASEHP0
----
Value 1 = TBC - BASEHP1
----
Value 2 = WOTLK - BASEHP2
----
Value 3 = Cataclysm - BASEHP3
----

==== faction_A ====

The faction if the creature is on the alliance side. See [[FactionTemplate.dbc tc2|FactionTemplate.dbc]]. Just because more than one faction has the same name, the inter-faction relationships can be different.

Note: This field also controls the creature family assistance mechanic. Only creatures with the same faction will assist each other.

==== faction_H ====

The faction if the creature is on the horde side. See [[FactionTemplate.dbc tc2|FactionTemplate.dbc]]. Just because more than one faction has the same name, the inter-faction relationships can be different.

Note: This field also controls the creature family assistance mechanic. Only creatures with the same faction will assist each other.

==== npcflag ====

A bitmask that represents what NPC flags the creature has. Each bit controls a different flag and to combine flags, you can add each flag that you want, in effect activating the respective bits.

{| cellspacing="0" cellpadding="3" border="1"
|-
! colspan="2" | Flag
! Name
! Comment
|-
| 1
| 0x0000 0001
| Gossip
| If creature has more gossip options, add this flag to bring up a menu.
|-
| 2
| 0x0000 0002
| Quest Giver
| Any creature giving or taking quests needs to have this flag.
|-
| 16
| 0x0000 0010
| Trainer
| Allows the creature to have a trainer list to teach spells
|-
| 32
| 0x0000 0020
| Class Trainer
|
|-
| 64
| 0x0000 0040
| Profession Trainer
|
|-
| 128
| 0x0000 0080
| Vendor
| Any creature selling items needs to have this flag.
|-
| 256
| 0x0000 0100
| Vendor Ammo
|
|-
| 512
| 0x0000 0200
| Vendor Food
|
|-
| 1024
| 0x0000 0400
| Vendor Poison
|
|-
| 2048
| 0x0000 0800
| Vendor Reagent
|
|-
| 4096
| 0x0000 1000
| Repairer
| Creatures with this flag can repair items.
|-
| 8192
| 0x0000 2000
| Flight Master
| Any creature serving as fly master has this.
|-
| 16384
| 0x0000 4000
| Spirit Healer
| Makes the creature invisible to alive characters and has the resurrect function.
|-
| 32768
| 0x0000 8000
| Spirit Guide
|
|-
| 65536
| 0x0001 0000
| Innkeeper
| Creatures with this flag can set hearthstone locations.
|-
| 131072
| 0x0002 0000
| Banker
| Creatures with this flag can show the bank
|-
| 262144
| 0x0004 0000
| Petitioner
|
|-
| 524288
| 0x0008 0000
| Tabard Designer
| Allows the designing of guild tabards.
|-
| 1048576
| 0x0010 0000
| Battlemaster
| Creatures with this flag port players to battlegrounds.
|-
| 2097152
| 0x0020 0000
| Auctioneer
| Allows creature to display auction list.
|-
| 4194304
| 0x0040 0000
| Stable Master
| Has the option to stable pets for hunters.
|-
| 8388608
| 0x0080 0000
| Guild Banker
|
|-
| 16777216
| 0x0100 0000
| Spellclick
| Needs data on npc_spellclick_spells table
|}

So if you want an NPC that is a quest giver, a vendor, and can repair you just add the specific flags together: 1 + 2 + 128 + 4096 = 4227. The same with hexadecimal numbers: 0x1 + 0x2 + 0x80 + 0x1000 = 0x1083

==== speed_walk ====

Controls how fast the creature can walk. For vehicles: increases fly speed.

==== speed_run ====

Controls how fast the creature can run. For vehicles: increases ground movement speed.

==== scale ====

If non-zero, this field defines the size of how the model of the creature appears ingame. If zero, it will use default model size taken from the DBC.

==== rank ====

The rank of the creature:

{| cellspacing="0" cellpadding="3" border="1"
|-
! Rank
! Name
! Comments
|-
| 0
| Normal
|
|-
| 1
| Elite
| Higher damage, more health, better loot.
|-
| 2
| Rare Elite
| A rare mob but with elite damage and health.
|-
| 3
| World Boss
| Highest rank, best loot, longest respawn time.
|-
| 4
| Rare
| Somewhat better loot, longer respawn time.
|-
| 5
| Unknown
|
|}

==== mindmg ====

Minimum damage the creature deals in melee. This field is '''no longer''' combined with the [[#attackpower|attackpower]] field to calculate the damage.

==== maxdmg ====

Maximum damage the creature deals in melee. This field is '''no longer''' combined with the [[#attackpower|attackpower]] field to calculate the damage.

==== dmgschool ====

Creature's melee damage school.

{| cellspacing="0" cellpadding="3" border="1"
|-
! ID
! Name
|-
| 0
| SPELL_SCHOOL_NORMAL
|-
| 1
| SPELL_SCHOOL_HOLY
|-
| 2
| SPELL_SCHOOL_FIRE
|-
| 3
| SPELL_SCHOOL_NATURE
|-
| 4
| SPELL_SCHOOL_FROST
|-
| 5
| SPELL_SCHOOL_SHADOW
|-
| 6
| SPELL_SCHOOL_ARCANE
|}

==== attackpower ====

The attack power for the creature's melee attacks. This field along with [[#mindmg|mindmg]] and [[#maxdmg|maxdmg]] dictate how much the creature will hit for. The formula in applying correct damages is as follows:
<pre>UPDATE `creature_template` SET
`mindmg` = <#1>,
`maxdmg` = <#2>,
`attackpower` = ROUND((`mindmg` + `maxdmg`) / 4 * 7),
`mindmg` = ROUND(`mindmg` - `attackpower` / 7),
`maxdmg` = ROUND(`maxdmg` - `attackpower` / 7)
WHERE `entry` = ...
</pre>
In the query above, substitute '<#1>' with the minimum damage you want the creature to deal and '<#2>' with the maximum damage you want the creature to deal.

NOTE: You might also want to double check the values calculated after the query is run because if the difference between mindmg and maxdmg is too high, mindmg will end up being a negative value.

==== dmg_multiplier ====

Multiplier for mindmg and maxdmg

Example: mindmg=200 maxdmg = 500 dmg_multiplier = 10

Outcome: mob will hit for 2000-5000

==== baseattacktime ====

This is the base time that determines how long a creature must wait between melee attacks. This time is in milliseconds.

==== rangeattacktime ====

This is the base time that determines how long a creature must wait between ranged attacks. This time is in milliseconds.

==== unit_class ====

This is the creatures class:

{| cellspacing="0" cellpadding="3" border="1"
|-
| '''Class name'''
| '''Value'''
|-
| CLASS_WARRIOR
| 1
|-
| CLASS_PALADIN
| 2
|-
| CLASS_ROGUE
| 4
|-
| CLASS_MAGE
| 8
|}

==== unit_flags ====

Allows the manual application of unit flags to creatures. Again this is a bitmask field and to apply more than one flag, just add the different numbers. Some possible flags are:

{| border="1"
|-
! colspan="2" | Flag
! Name
! Comments
|-
| 1
| 0x0000 0001
| UNIT_FLAG_UNK_0
|
|-
| 2
| 0x0000 0002
| UNIT_FLAG_NON_ATTACKABLE
|
|-
| 4
| 0x0000 0004
| UNIT_FLAG_DISABLE_MOVE
|
|-
| 8
| 0x0000 0008
| UNIT_FLAG_PVP_ATTACKABLE
| Allows to apply pvp rules to attackable state in addition to faction dependent state
|-
| 16
| 0x0000 0010
| UNIT_FLAG_RENAME
|
|-
| 32
| 0x0000 0020
| UNIT_FLAG_PREPARATION
| Don't take reagents for spells with SPELL_ATTR_EX5_NO_REAGENT_WHILE_PREP
|-
| 64
| 0x0000 0040
| UNIT_FLAG_UNK_6
|
|-
| 128
| 0x0000 0080
| UNIT_FLAG_NOT_ATTACKABLE_1
| UNIT_FLAG_NOT_ATTACKABLE_1) is NON_PVP_ATTACKABLE
|-
| 256
| 0x0000 0100
| UNIT_FLAG_OOC_NOT_ATTACKABLE
| 2.0.8 - (OOC Out Of Combat) Cannot be attacked when not in combat. Removed if unit for some reason enter combat.
|-
| 512
| 0x0000 0200
| UNIT_FLAG_PASSIVE
| makes you unable to attack everything. Almost identical to our "civilian"-term.
Will ignore it's surroundings and not engage in combat unless "called upon" or engaged by another unit.
|-
| 1024
| 0x0000 0400
| UNIT_FLAG_LOOTING
| Loot animation
|-
| 2048
| 0x0000 0800
| UNIT_FLAG_PET_IN_COMBAT
| In combat? 2.0.8
|-
| 4096
| 0x0000 1000
| UNIT_FLAG_PVP
| Changed in 3.0.3
|-
| 8192
| 0x0000 2000
| UNIT_FLAG_SILENCED
| Can't cast spells
|-
| 16384
| 0x0000 4000
| UNIT_FLAG_UNK_14
| 2.0.8
|-
| 32768
| 0x0000 8000
| UNIT_FLAG_UNK_15
|
|-
| 65536
| 0x0001 0000
| UNIT_FLAG_UNK_16
|
|-
| 131072
| 0x0002 0000
| UNIT_FLAG_PACIFIED
| 3.0.3 ok
|-
| 262144
| 0x0004 0000
| UNIT_FLAG_STUNNED
| 3.0.3 ok
|-
| 524288
| 0x0008 0000
| UNIT_FLAG_IN_COMBAT
|
|-
| 1048576
| 0x0010 0000
| UNIT_FLAG_TAXI_FLIGHT
| Disable casting at client side spell not allowed by taxi flight (mounted?), probably used with 0x4 flag
|-
| 2097152
| 0x0020 0000
| UNIT_FLAG_DISARMED
| 3.0.3, disable melee spells casting..., "Required melee weapon" added to melee spells tooltip.
|-
| 4194304
| 0x0040 0000
| UNIT_FLAG_CONFUSED
|
|-
| 8388608
| 0x0080 0000
| UNIT_FLAG_FLEEING
|
|-
| 16777216
| 0x0100 0000
| UNIT_FLAG_PLAYER_CONTROLLED
| Used in spell Eyes of the Beast for pet... let attack by controlled creature
|-
| 33554432
| 0x0200 0000
| UNIT_FLAG_NOT_SELECTABLE
| Can't be selected by mouse
|-
| 67108864
| 0x0400 0000
| UNIT_FLAG_SKINNABLE
|
|-
| 134217728
| 0x0800 0000
| UNIT_FLAG_MOUNT
| The client seems to handle it perfectly
|-
| 268435456
| 0x1000 0000
| UNIT_FLAG_UNK_28
|
|-
| 536870912
| 0x2000 0000
| UNIT_FLAG_UNK_29
| Used in Feing Death spell
|-
| 1073741824
| 0x4000 0000
| UNIT_FLAG_SHEATHE
|
|-
| 2147483648
| 0x8000 0000
| UNIT_FLAG_UNK_31
|
|}

==== dynamicflags ====

Flags that control visual appearance of the creature.

A few known flags and their use are:

{| border="1"
|-
! colspan="2" | Flag
! Name
! Comments
|-
| 1
| 0x01
| UNIT_DYNFLAG_LOOTABLE
|
|-
| 2
| 0x02
| UNIT_DYNFLAG_TRACK_UNIT
|
|-
| 4
| 0x04
| UNIT_DYNFLAG_OTHER_TAGGER
| Makes creatures name appear grey (good for simulating dead creatures)
|-
| 8
| 0x08
| UNIT_DYNFLAG_ROOTED
|
|-
| 16
| 0x10
| UNIT_DYNFLAG_SPECIALINFO
|
|-
| 32
| 0x20
| UNIT_DYNFLAG_DEAD
| Makes the creature appear dead (this DOES NOT make the creatures name grey)
|}

==== family ====

The family this creature belongs to.

{| cellspacing="0" cellpadding="3" border="1"
|-
! ID
! Family
! ID
! Family
|-
| 1
| Wolf
| 26
| Owl
|-
| 2
| Cat
| 27
| Wind Serpent
|-
| 3
| Spider
| 28
| Remote Control
|-
| 4
| Bear
| 29
| Felguard
|-
| 5
| Boar
| 30
| Dragonhawk
|-
| 6
| Crocolisk
| 31
| Ravager
|-
| 7
| Carrion Bird
| 32
| Warp Stalker
|-
| 8
| Crab
| 33
| Sporebat
|-
| 9
| Gorilla
| 34
| Nether Ray
|-
| 11
| Raptor
| 35
| Serpent
|-
| 12
| Tallstrider
| 37
| Moth
|-
| 15
| Felhunter
| 38
| Chimaera
|-
| 16
| Voidwalker
| 39
| Devilsaur
|-
| 17
| Succubus
| 40
| Ghoul
|-
| 19
| Doomguard
| 41
| Silithid
|-
| 20
| Scorpid
| 42
| Worm
|-
| 21
| Turtle
| 43
| Rhino
|-
| 23
| Imp
| 44
| Wasp
|-
| 24
| Bat
| 45
| Core Hound
|-
| 25
| Hyena
| 46
| Spirit Beast
|}

==== trainer_type ====

If the NPC is a trainer (has the trainer flag), then this field controls what kind of trainer it is. Both this field and the related field must be filled in for a trainer to work correctly.

{| cellspacing="0" cellpadding="3" border="1"
|-
! ID
! Type
! Related Field
! Comments
|-
| 0
| TRAINER_TYPE_CLASS
| [[#trainer_class|trainer_class]]
| Trains class spells
|-
| 1
| TRAINER_TYPE_MOUNTS
| [[#trainer_race|trainer_race]]
| Trains riding skill
|-
| 2
| TRAINER_TYPE_TRADESKILLS
| [[#trainer_spell|trainer_spell]]
| Trains professions
|-
| 3
| TRAINER_TYPE_PETS
| [[#trainer_class|trainer_class]]
| Trains pet skills
|}

==== trainer_spell ====

If the NPC is a trainer that teaches professions ([[#trainer_type|trainer_type]] == 2), then the player must already know the spell ID specified here to be able to talk to this NPC.

==== trainer_class ====

If the NPC is a class trainer or a pet trainer ([[#trainer_type|trainer_type]] == 0 or 3), then the player's class must be the same as the value specified here to talk to this trainer. For pet trainers, this value must be 3 (hunter). See [[Characters tc2#class|characters.class]]

==== trainer_race ====

If the NPC is a mount trainer ([[#trainer_type|trainer_type]] == 1), then the player's race must be the same as the value specified here to talk to this trainer. See [[Characters tc2#race|characters.race]]

==== minrangedmg ====

Minimum ranged damage the creature inflicts.

==== maxrangedmg ====

Maximum range damage the creature inflicts.

==== rangedattackpower ====

{{field-no-description|40}}

==== type ====

The type of the creature.

{| cellspacing="0" cellpadding="3" border="1"
|-
! ID
! Type
|-
| 0
| None
|-
| 1
| Beast
|-
| 2
| Dragonkin
|-
| 3
| Demon
|-
| 4
| Elemental
|-
| 5
| Giant
|-
| 6
| Undead
|-
| 7
| Humanoid
|-
| 8
| Critter
|-
| 9
| Mechanical
|-
| 10
| Not specified
|-
| 11
| Totem
|-
| 12
| Non-Combat Pet
|-
| 13
| Gas Cloud
|}

==== type_flags ====

This field can control whether a mob is minable or herbable or lootable by enineer. If it is either of those three, then the loot given when it is skinned/mined will be stored in the [[Loot template tc2|skinning_loot_template]] table. It also controls, whether this mob can be tamed by a hunter. Other fields have no special meaning on the serverside. The entire field will be send to the client in SMSG_CREATURE_QUERY_RESPONSE

Some values provided from the community:

{| border="1"
|-
! colspan="2" | Flag
! Name
! Comments
|-
| 1
| 0x0000 0001
| CREATURE_TYPEFLAGS_TAMEABLE
| Makes the mob tameable (must also be a beast and have family set)
|-
| 2
| 0x0000 0002
| CREATURE_TYPEFLAGS_GHOST
| Creature are also visible for not alive player. Allow gossip interaction if npcflag allow?
|-
| 4
| 0x0000 0004
| CREATURE_TYPEFLAGS_UNK3
| Changes creature's visible level to "??"
|-
| 8
| 0x0000 0008
| CREATURE_TYPEFLAGS_UNK4
|
|-
| 16
| 0x0000 0010
| CREATURE_TYPEFLAGS_UNK5
|
|-
| 32
| 0x0000 0020
| CREATURE_TYPEFLAGS_UNK6
|
|-
| 64
| 0x0000 0040
| CREATURE_TYPEFLAGS_UNK7
|
|-
| 128
| 0x0000 0080
| CREATURE_TYPEFLAGS_DEAD_INTERACT
| Player can interact with the creature if its dead (not player dead)
|-
| 256
| 0x0000 0100
| CREATURE_TYPEFLAGS_HERBLOOT
| Makes mob herbable
|-
| 512
| 0x0000 0200
| CREATURE_TYPEFLAGS_MININGLOOT
| Makes mob minable
|-
| 1024
| 0x0000 0400
| CREATURE_TYPEFLAGS_UNK11
|
|-
| 2048
| 0x0000 0800
| CREATURE_TYPEFLAGS_MOUNTED_COMBAT
| Creature can remain mounted when entering combat
|-
| 4096
| 0x0000 1000
| CREATURE_TYPEFLAGS_AID_PLAYERS
| Can aid any player in combat if in range?
|-
| 8192
| 0x0000 2000
| CREATURE_TYPEFLAGS_UNK14
|
|-
| 16384
| 0x0000 4000
| CREATURE_TYPEFLAGS_UNK15
|
|-
| 32768
| 0x0000 8000
| CREATURE_TYPEFLAGS_ENGINEERLOOT
| Makes mob lootable by engineer
|-
| 65536
| 0x0001 0000
| CREATURE_TYPEFLAGS_EXOTIC
| Tamable as an exotic pet. Normal tamable flag must also be set.
|-
| 131072
| 0x0002 0000
| CREATURE_TYPEFLAGS_UNK18
| Related to vehicles/pvp?
|-
| 262144
| 0x0004 0000
| CREATURE_TYPEFLAGS_UNK19
| Related to vehicles/siege weapons?
|-
| 524288
| 0x0008 0000
| CREATURE_TYPEFLAGS_UNK20
|
|-
| 1048576
| 0x0010 0000
| CREATURE_TYPEFLAGS_UNK21
|
|-
| 2097152
| 0x0020 0000
| CREATURE_TYPEFLAGS_UNK22
|
|-
| 4194304
| 0x0040 0000
| CREATURE_TYPEFLAGS_UNK23
|
|-
| 8388608
| 0x0080 0000
| CREATURE_TYPEFLAGS_UNK24
| First seen in 3.2.2. Related to banner/backpack of creature/companion?
|}

==== lootid ====

The ID of the loot template ID that this creature should use to generate loots. See [[Loot template tc2#entry|creature_loot_template.entry]]

==== pickpocketloot ====

The ID of the pickpocketing loot template that this creature should use to generate pickpocketing loots. See [[Loot template tc2#entry|pickpocketing_loot_template.entry]]

==== skinloot ====

The ID of the skinning loot template that this creature should use to generate skinning loots. See [[Loot template tc2#entry|skinning_loot_template.entry]]

==== resistance1 ====

Holy resistance.

==== resistance2 ====

Fire resistance.

==== resistance3 ====

Nature resistance.

==== resistance4 ====

Frost resistance.

==== resistance5 ====

Shadow resistance.

==== resistance6 ====

Arcane resistance.

==== spell1 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 1st spell on action bar

==== spell2 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 2nd spell on action bar

==== spell3 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 3rd spell on action bar

==== spell4 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 4th spell on action bar

==== spell5 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 5th spell on action bar

==== spell6 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 6th spell on action bar

==== spell7 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 7th spell on action bar

==== spell8 ====

Spell ID that can be used for Mind Control of this creature. For vehicle creatures: 8th spell on action bar

==== PetSpellDataId ====

ID, found in CreatureSpellData.dbc, that displays what spells the pet has in the client.

==== VehicleId ====

Entryid of Vehicle if creature is/has a vehicle entry. This field determines how the player appears on the vehicle, how the vehicle moves, and whether or not the vehicle action bar is shown. For example, a VehicleID of 292 will make the player invisible, prevent the vehicle from strafing left/right (but will allow fowards/backwards), and will show the vehicle action bar spells (which are defined in [[Creature_template_tc2#spell1|spell1-8]]). An npc_spellclick_spells entry must be made for this creature entry in order for this to work.

==== mingold ====

Minimum money that the creature drops when killed, in copper.

==== maxgold ====

Maximum money that the creature drops when killed, in copper.

==== AIName ====

This field is overridden by ScriptName field if both are set.

{| cellspacing="0" cellpadding="3" border="1"
|-
! Name
! Description
|-
| NullAI
| Empty AI, creature does nothing.
|-
| AggressorAI
| Creature attacks as soon as something is in aggro range.
|-
| ReactorAI
| Creature attacks only if aggroed by attack, spell etc.
|-
| GuardAI
|
|-
| PetAI
| Creature is a pet.
|-
| TotemAI
| Creature casts spell from field spell1, otherwise like NullAI.
|-
| EventAI
| Creature uses event based AI.
|-
| SmartAI
| Creature uses new smart AI.
|}

==== MovementType ====

The creature's default movement type.

{| cellspacing="0" cellpadding="3" border="1"
|-
! ID
! Type
|-
| 0
| Idle; stay in one place
|-
| 1
| Random movement inside the spawndist radius
|-
| 2
| Waypoint movement
|}

==== InhabitType ====

Controls where the creature can move and attack.

{| cellspacing="0" cellpadding="3" border="1"
|-
! Bitmask
! Type
|-
| 1
| Ground
|-
| 2
| Water
|-
| 4
| Flying
|-
|}
(This is a bitmask'ed value. You can add values together: 1+4=5 would make the creature walk on ground and fly.)

==== Health_mod ====

Used to modify the base Level/Class health of a creature. This field comes from WDB.

==== Mana_mod ====

Used to modify the base Level/Class mana of a creature. This field comes from WDB.

==== Armor_mod ====

Used to modify the base Level/Class armor of a creature.

==== RacialLeader ====

A flag indicating wheather the creature is a racial leader. Killing racial leaders grants 100 honor.

==== QuestItem1-6 ====

Tells the client (mouse-hovering this creature -> tooltip) that this creature will drop the item specified in this field.

==== movementID ====

We have no idea what this field does. It is passed directly to the client.

==== RegenHealth ====

Boolean 1 or 0 controlling if the creature should regenerate its health or not.

==== equipment_id ====

The default ID of the equipment that this creature should display. See [[Creature equip template tc2#entry|creature_equip_template.entry]]

==== mechanic_immune_mask ====

This makes the creature immune to specific spell natures. See Spell.dbc at row effect_X_mechanic_id.

Uses references from SpellMechanic.dbc.

{| cellspacing="0" cellpadding="3" border="1"
|-
! colspan="2" | Flag
! Type
! Comment
|-
| 1
| 0x0000 0001
| MECHANIC_CHARM
|
|-
| 2
| 0x0000 0002
| MECHANIC_DISORIENTED
|
|-
| 4
| 0x0000 0004
| MECHANIC_DISARM
|
|-
| 8
| 0x0000 0008
| MECHANIC_DISTRACT
|
|-
| 16
| 0x0000 0010
| MECHANIC_FEAR
|
|-
| 32
| 0x0000 0020
| MECHANIC_GRIP
| Death Grip and similar effects
|-
| 64
| 0x0000 0040
| MECHANIC_ROOT
|
|-
| 128
| 0x0000 0080
| MECHANIC_PACIFY
| (0 spells use this mechanic)
|-
| 256
| 0x0000 0100
| MECHANIC_SILENCE
|
|-
| 512
| 0x0000 0200
| MECHANIC_SLEEP
|
|-
| 1024
| 0x0000 0400
| MECHANIC_SNARE
|
|-
| 2048
| 0x0000 0800
| MECHANIC_STUN
|
|-
| 4096
| 0x0000 1000
| MECHANIC_FREEZE
|
|-
| 8192
| 0x0000 2000
| MECHANIC_KNOCKOUT
| Knockout,
|-
| 16384
| 0x0000 4000
| MECHANIC_BLEED
|
|-
| 32768
| 0x0000 8000
| MECHANIC_BANDAGE
| Healing etc.
|-
| 65536
| 0x0001 0000
| MECHANIC_POLYMORPH
|
|-
| 131072
| 0x0002 0000
| MECHANIC_BANISH
|
|-
| 262144
| 0x0004 0000
| MECHANIC_SHIELD
|
|-
| 524288
| 0x0008 0000
| MECHANIC_SHACKLE
|
|-
| 1048576
| 0x0010 0000
| MECHANIC_MOUNT
|
|-
| 2097152
| 0x0020 0000
| MECHANIC_INFECTED
| Blood Plague from Unholy Blight etc.
|-
| 4194304
| 0x0040 0000
| MECHANIC_TURN
| e.g. Turn Evil
|-
| 8388608
| 0x0080 0000
| MECHANIC_HORROR
| e.g. Death Coil (Warlock)
|-
| 16777216
| 0x0100 0000
| MECHANIC_INVULNERABILITY
|
|-
| 33554432
| 0x0200 0000
| MECHANIC_INTERRUPT
|
|-
| 67108864
| 0x0400 0000
| MECHANIC_DAZE
|
|-
| 134217728
| 0x0800 0000
| MECHANIC_DISCOVERY
|
|-
| 268435456
| 0x1000 0000
| MECHANIC_IMMUNE_SHIELD
|
|-
| 536870912
| 0x2000 0000
| MECHANIC_SAPPED
|
|-
| 1073741824
| 0x4000 0000
| MECHANIC_ENRAGED
|
|}

To combine immunities just add values. Immune to everything corresponds to the value 2147483647 (0x3FFF FFFF).

==== flags_extra ====

These flags control certain creature specific attributes.

{| cellspacing="0" cellpadding="3" border="1"
|-
! colspan="3" | Flag
! Type
|-
| 1
| CREATURE_FLAG_EXTRA_INSTANCE_BIND
| 0x00000001
| creature kill binds instance to killer and killer's group
|-
| 2
| CREATURE_FLAG_EXTRA_CIVILIAN
| 0x00000002
| creature does not aggro (ignore faction/reputation hostility)
|-
| 4
| CREATURE_FLAG_EXTRA_NO_PARRY
| 0x00000004
| creature does not parry
|-
| 8
| CREATURE_FLAG_EXTRA_NO_PARRY_HASTEN
| 0x00000008
| creature does not counter-attack at parry
|-
| 16
| CREATURE_FLAG_EXTRA_NO_BLOCK
| 0x00000010
| creature does not block
|-
| 32
| CREATURE_FLAG_EXTRA_NO_CRUSH
| 0x00000020
| creature does not do crush-attacks
|-
| 64
| CREATURE_FLAG_EXTRA_NO_XP_AT_KILL
| 0x00000040
| creature kill does not give XP
|-
| 128
| CREATURE_FLAG_EXTRA_TRIGGER
| 0x00000080
| creature is trigger-NPC (invisible to players only)
|-
| 256
| CREATURE_FLAG_EXTRA_NO_TAUNT
| 0x00000100
| creature is immune to taunt-auras and "attack me"-effects
|-
| 16384
| CREATURE_FLAG_EXTRA_WORLDEVENT
| 0x00004000
| custom flag for world events (left room for merging)
|-
| 32768
| CREATURE_FLAG_EXTRA_GUARD
| 0x00008000
| creature is a guard (Will ignore feign death and vanish)
|-
| 131072
| CREATURE_FLAG_EXTRA_NO_CRIT
| 0x00020000
| creature does not do critical strikes
|-
| 262144
| CREATURE_FLAG_EXTRA_NO_SKILLGAIN
| 0x00040000
| creature won't increase weapon skills
|-
| 524288
| CREATURE_FLAG_EXTRA_TAUNT_DIMINISH
| 0x00080000
| creature taunt is subject to diminishing returns
|-
| 1048576
| CREATURE_FLAG_EXTRA_ALL_DIMINISH
| 0x00100000
| Creature is subject to all diminishing returns
|-
| 2097152
| CREATURE_FLAG_EXTRA_DUNGEON_BOSS
| 0x00200000
| Creature is a dungeon boss
|}

==== ScriptName ====

The name of the script that this creature uses, if any. This ties a script from a scripting engine to this creature.

{{WDBVerified}}

[[Category:SkyFire_World_database_tables]]

Creature SF

2011-09-04T21:00:24Z

Marqin: recategorized

{| align="right"
| __TOC__
|}
[[Category: SkyFire World database tables]]
{{Back-to:World}}

<big>'''The `creature` table'''</big>

Contains individual creature spawn data. Spawn of a creature is an instance of the creature object in the world.

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment'''
|-
|[[#guid|guid]]
|int(10)
|unsigned
|PRI
|NO
|NULL
|Auto Increment
|Global Unique Identifier
|-
|[[#id|id]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|Creature Identifier
|-
|[[#map|map]]
|smallint(5)
|unsigned
|
|NO
|0
|
|Map Identifier
|-
|[[#spawnMask|spawnMask]]
|tinyint(3)
|unsigned
|
|NO
|1
|
|
|-
|[[#phaseMask|phaseMask]]
|smallint(5)
|unsigned
|
|NO
|1
|
|
|-
|[[#modelid|modelid]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#equipment_id|equipment_id]]
|mediumint(9)
|signed
|
|NO
|0
|
|
|-
|[[#position_x|position_x]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#position_y|position_y]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#position_z|position_z]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#orientation|orientation]]
|float
|signed
|
|NO
|0
|
|
|-
|[[#spawntimesecs|spawntimesecs]]
|int(10)
|unsigned
|
|NO
|120
|
|
|-
|[[#spawndist|spawndist]]
|float
|signed
|
|NO
|5
|
|
|-
|[[#currentwaypoint|currentwaypoint]]
|mediumint(8)
|unsigned
|
|NO
|0
|
|
|-
|[[#curhealth|curhealth]]
|int(10)
|unsigned
|
|NO
|1
|
|
|-
|[[#curmana|curmana]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#DeathState|DeathState]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#MovementType|MovementType]]
|tinyint(3)
|unsigned
|
|NO
|0
|
|
|-
|[[#npcflag|npcflag]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#unit_flags|unit_flags]]
|int(10)
|unsigned
|
|NO
|0
|
|
|-
|[[#dynamicflags|dynamicflags]]
|int(10)
|unsigned
|
|NO
|0
|
|
|}

<big>'''Description of the fields'''</big>
==== guid ====
A unique identifier given to each creature to distinguish one creature from another. Two creatures can NOT have same GUID.

==== id ====
The id of the template that is used when instantiating this creature. See [[creature_template_tc2#entry|creature_template.entry]]

==== map ====
The Map ID of the position of the creature. See [[Map.dbc tc2|Map.dbc]]

==== spawnMask ====
Controls under which difficulties the creature is spawned.

Just like flags you can add them as you wish so 3 would be: Spawned in 10/25 man normal versions of maps (pre 3.2 all maps)

{| border=1 cellpadding=3 cellspacing=0
! Value !! Comment
|-
| 0 || Not spawned
|-
| 1 || Spawned only in 10-man-normal versions of maps (includes maps without a heroic mode)
|-
| 2 || Spawned only in 25-man-normal versions of maps (or heroics pre 3.2)
|-
| 4 || Spawned only in 10-man heroic versions of maps
|-
| 8 || Spawned only in 25-man-heroic versions of maps
|-
| 15 || Spawned in all versions of maps
|}

==== phaseMask ====
This is a bitmask field that describes all the phases that a creature will appear in. Aura 261 determines the phase you can see. For example, if you had this aura http://www.wowhead.com/?spell=55782, you would be able to see creatures in phase 2. If you wanted the creature to be visible in both phase 1 and phase 2, you would set the phaseMask to 3.

==== modelid ====
The model ID associated with this creature. Note that two creatures that use the same template can have different models. See [[creature_model_info_tc2|creature_model_info]] for more information on model-specific characteristics. NOTE: This can be left at 0
and a random model from its assigned models in creature_template will be assigned by the core.

==== equipment_id ====
The ID of the equipment that the creature is using. See [[creature_equip_template_tc2#entry|creature_equip_template.entry]]

NOTE: equipment should be assigned in creature_template. Only use this if a guid has different equipment than others of the same entry.

==== position_x ====
The X position of the creature.

==== position_y ====
The Y position of the creature.

==== position_z ====
The Z position of the creature.

==== orientation ====
The orientation of the creature. (North = 0.0; South = pi (3.14159))

==== spawntimesecs ====
The respawn time of the creature in seconds.

==== spawndist ====
The maximum distance that the creature should spawn from its spawn point. Also controls how far away the creature can walk from its spawn point if its [[creature tc2#MovementType|MovementType]] = 1.

==== currentwaypoint ====
The current waypoint number that the creature is on, if any. See [[waypoint_data_tc2#point|waypoint_data.point]]

==== curhealth ====
The current health that the creature has.

==== curmana ====
The current mana that the creature has.

==== DeathState ====
The creature's death state. -- Should not be used; correct aura and correct creature flags is a better way to do it.

==== MovementType ====
The movement type associated with this creature. Usually the same as [[creature_template_tc2#MovementType|creature_template.MovementType]] but can be different.

==== npcflag ====
Same as [[Creature_template_tc2#npcflag|creature_template.npcflag]]

NOTE: A creature.npcflag record will override a creature_template.npcflag record.

==== unit_flags ====
Same as [[Creature_template_tc2#unit_flags|creature_template.unit_flags]]

NOTE: A creature.unit_flags record will override a creature_template.unit_flags record.

==== dynamicflags ====
Same as [[Creature_template_tc2#dynamicflags|creature_template.dynamicflags]]

NOTE: A creature.dynamicflags record will override a creature_template.dynamicflags record.

Smart scripts SF

2011-09-04T20:57:14Z

Marqin: recategorized

Creature ai scripts SF

2011-09-04T20:57:01Z

Marqin: recategorized

IRC Rules

2011-09-04T20:50:21Z

Marqin: TOC

__TOC__

== Introduction ==

This document describes several guidelines which should be considered when taking part in #project_skyfire discussions.

The rizon network which #project_skyfire resides on has their own network policy which all users should read and understand. Should any of the guidelines laid out in this document conflict with existing rizon policy then the rizon policy will always take precedence.

The purpose of these guidelines is to ensure the well being of the channel and that its objectives are respected and maintained.

== Channel Rules ==

Respect the SkyFire License and EULA

Any breach of the SkyFire License and/or EULA within the confines of #project_skyfire will result in a permanent ban.

This can include supporting such violations via voice of personal opinion, linking and/or advertising public game servers, or anything which may be viewed as being contradictory to the SkyFire project objectives.

Ignorance of this rule will result in a permanent ban with no exceptions from both the IRC channel and official forum without prior warning.
RTFM

The SkyFire forums and IRC channel are for educational and development purposes only therefor it is expected that you have made a reasonable effort when undergoing tasks. Refer to the section seeking help for more information.

Speak English

You must speak English and English only while participating in public chat. Using an online translator is not acceptable.

Respect Your Audience

Everyone is entitled to their own opinion but not everyone will agree with it. Keep personal disputes out of the public channel. Make use of your IRC client /ignore nickname command.

Automatic Scripts

Please do not use scripts which will output to the public channel without human intervention. This can include the display of your away status, currently playing mp3, etc. Basically anything which can spam the channel with irrelevant information.

User activated scripts are acceptable to a certain extent although abuse of colors, ASCII or variants of l33tsp34k are greatly discouraged.

== Seeking Help ==
While #project_skyfire isn't considered a support channel there are many knowledgeable people who visit regularly. If you are seeking help in debugging or fixing a problem it is important that you convey your problem in a suitable manner.

When seeking assistance always note that:

Only the most recent official revision of SkyFire can be supported. If you are using an old revision you should update before asking for help.
There is extensive documentation for software which SkyFire relies on. This includes Windows/Linux administration, MySQL server etc.

How To Ask A Question

If you take the time to prepare your question you'll often find that your response will be equally informative.

Don't ask to ask, just ask.
Tell us what revision you are using.
Tell us what OS you are running.
Give a clear description of the problem.

And Then?

Please do not reward the generosity of your fellow users by repeatedly asking for help. We are not here to spoon feed you.

Credits to MaNGOS for the rule set.

{{Pp-vandalism}}
[[Category:Rules]]

IRC Rules

2011-09-04T20:47:17Z

Marqin: one more formating...

== Introduction ==

This document describes several guidelines which should be considered when taking part in #project_skyfire discussions.

The rizon network which #project_skyfire resides on has their own network policy which all users should read and understand. Should any of the guidelines laid out in this document conflict with existing rizon policy then the rizon policy will always take precedence.

The purpose of these guidelines is to ensure the well being of the channel and that its objectives are respected and maintained.

== Channel Rules ==

Respect the SkyFire License and EULA

Any breach of the SkyFire License and/or EULA within the confines of #project_skyfire will result in a permanent ban.

This can include supporting such violations via voice of personal opinion, linking and/or advertising public game servers, or anything which may be viewed as being contradictory to the SkyFire project objectives.

Ignorance of this rule will result in a permanent ban with no exceptions from both the IRC channel and official forum without prior warning.
RTFM

The SkyFire forums and IRC channel are for educational and development purposes only therefor it is expected that you have made a reasonable effort when undergoing tasks. Refer to the section seeking help for more information.

Speak English

You must speak English and English only while participating in public chat. Using an online translator is not acceptable.

Respect Your Audience

Everyone is entitled to their own opinion but not everyone will agree with it. Keep personal disputes out of the public channel. Make use of your IRC client /ignore nickname command.

Automatic Scripts

Please do not use scripts which will output to the public channel without human intervention. This can include the display of your away status, currently playing mp3, etc. Basically anything which can spam the channel with irrelevant information.

User activated scripts are acceptable to a certain extent although abuse of colors, ASCII or variants of l33tsp34k are greatly discouraged.

== Seeking Help ==
While #project_skyfire isn't considered a support channel there are many knowledgeable people who visit regularly. If you are seeking help in debugging or fixing a problem it is important that you convey your problem in a suitable manner.

When seeking assistance always note that:

Only the most recent official revision of SkyFire can be supported. If you are using an old revision you should update before asking for help.
There is extensive documentation for software which SkyFire relies on. This includes Windows/Linux administration, MySQL server etc.

How To Ask A Question

If you take the time to prepare your question you'll often find that your response will be equally informative.

Don't ask to ask, just ask.
Tell us what revision you are using.
Tell us what OS you are running.
Give a clear description of the problem.

And Then?

Please do not reward the generosity of your fellow users by repeatedly asking for help. We are not here to spoon feed you.

Credits to MaNGOS for the rule set.

{{Pp-vandalism}}
[[Category:Rules]]

IRC Rules

2011-09-04T20:45:23Z

Marqin: fix

This document describes several guidelines which should be considered when taking part in #project_skyfire discussions.

The rizon network which #project_skyfire resides on has their own network policy which all users should read and understand. Should any of the guidelines laid out in this document conflict with existing rizon policy then the rizon policy will always take precedence.

The purpose of these guidelines is to ensure the well being of the channel and that its objectives are respected and maintained.

== Channel Rules ==

Respect the SkyFire License and EULA

Any breach of the SkyFire License and/or EULA within the confines of #project_skyfire will result in a permanent ban.

This can include supporting such violations via voice of personal opinion, linking and/or advertising public game servers, or anything which may be viewed as being contradictory to the SkyFire project objectives.

Ignorance of this rule will result in a permanent ban with no exceptions from both the IRC channel and official forum without prior warning.
RTFM

The SkyFire forums and IRC channel are for educational and development purposes only therefor it is expected that you have made a reasonable effort when undergoing tasks. Refer to the section seeking help for more information.

Speak English

You must speak English and English only while participating in public chat. Using an online translator is not acceptable.

Respect Your Audience

Everyone is entitled to their own opinion but not everyone will agree with it. Keep personal disputes out of the public channel. Make use of your IRC client /ignore nickname command.

Automatic Scripts

Please do not use scripts which will output to the public channel without human intervention. This can include the display of your away status, currently playing mp3, etc. Basically anything which can spam the channel with irrelevant information.

User activated scripts are acceptable to a certain extent although abuse of colors, ASCII or variants of l33tsp34k are greatly discouraged.

== Seeking Help ==
While #project_skyfire isn't considered a support channel there are many knowledgeable people who visit regularly. If you are seeking help in debugging or fixing a problem it is important that you convey your problem in a suitable manner.

When seeking assistance always note that:

Only the most recent official revision of SkyFire can be supported. If you are using an old revision you should update before asking for help.
There is extensive documentation for software which SkyFire relies on. This includes Windows/Linux administration, MySQL server etc.

How To Ask A Question

If you take the time to prepare your question you'll often find that your response will be equally informative.

Don't ask to ask, just ask.
Tell us what revision you are using.
Tell us what OS you are running.
Give a clear description of the problem.

And Then?

Please do not reward the generosity of your fellow users by repeatedly asking for help. We are not here to spoon feed you.

Credits to MaNGOS for the rule set.

{{Pp-vandalism}}
[[Category:Rules]]

IRC Rules

2011-09-04T20:43:58Z

Marqin: change formating

This document describes several guidelines which should be considered when taking part in #project_skyfire discussions.

The rizon network which #project_skyfire resides on has their own network policy which all users should read and understand. Should any of the guidelines laid out in this document conflict with existing rizon policy then the rizon policy will always take precedence.

The purpose of these guidelines is to ensure the well being of the channel and that its objectives are respected and maintained.

=== Channel Rules ===

Respect the SkyFire License and EULA

Any breach of the SkyFire License and/or EULA within the confines of #project_skyfire will result in a permanent ban.

This can include supporting such violations via voice of personal opinion, linking and/or advertising public game servers, or anything which may be viewed as being contradictory to the SkyFire project objectives.

Ignorance of this rule will result in a permanent ban with no exceptions from both the IRC channel and official forum without prior warning.
RTFM

The SkyFire forums and IRC channel are for educational and development purposes only therefor it is expected that you have made a reasonable effort when undergoing tasks. Refer to the section seeking help for more information.

Speak English

You must speak English and English only while participating in public chat. Using an online translator is not acceptable.

Respect Your Audience

Everyone is entitled to their own opinion but not everyone will agree with it. Keep personal disputes out of the public channel. Make use of your IRC client /ignore nickname command.

Automatic Scripts

Please do not use scripts which will output to the public channel without human intervention. This can include the display of your away status, currently playing mp3, etc. Basically anything which can spam the channel with irrelevant information.

User activated scripts are acceptable to a certain extent although abuse of colors, ASCII or variants of l33tsp34k are greatly discouraged.

=== Seeking Help ===
While #project_skyfire isn't considered a support channel there are many knowledgeable people who visit regularly. If you are seeking help in debugging or fixing a problem it is important that you convey your problem in a suitable manner.

When seeking assistance always note that:

Only the most recent official revision of SkyFire can be supported. If you are using an old revision you should update before asking for help.
There is extensive documentation for software which SkyFire relies on. This includes Windows/Linux administration, MySQL server etc.

How To Ask A Question

If you take the time to prepare your question you'll often find that your response will be equally informative.

Don't ask to ask, just ask.
Tell us what revision you are using.
Tell us what OS you are running.
Give a clear description of the problem.

And Then?

Please do not reward the generosity of your fellow users by repeatedly asking for help. We are not here to spoon feed you.

Credits to MaNGOS for the rule set.

{{Pp-vandalism}}
[[Category:Rules]]

IRC Rules

2011-09-04T20:20:35Z

Marqin:

This document describes several guidelines which should be considered when taking part in #project_skyfire discussions.

The rizon network which #project_skyfire resides on has their own network policy which all users should read and understand. Should any of the guidelines laid out in this document conflict with existing rizon policy then the rizon policy will always take precedence.

The purpose of these guidelines is to ensure the well being of the channel and that its objectives are respected and maintained.

This document has been split in to sections for easy reading:

Channel Rules
Seeking Help

'''Channel Rules'''

Respect the SkyFire License and EULA

Any breach of the SkyFire License and/or EULA within the confines of #project_skyfire will result in a permanent ban.

This can include supporting such violations via voice of personal opinion, linking and/or advertising public game servers, or anything which may be viewed as being contradictory to the SkyFire project objectives.

Ignorance of this rule will result in a permanent ban with no exceptions from both the IRC channel and official forum without prior warning.
RTFM

The SkyFire forums and IRC channel are for educational and development purposes only therefor it is expected that you have made a reasonable effort when undergoing tasks. Refer to the section seeking help for more information.

Speak English

You must speak English and English only while participating in public chat. Using an online translator is not acceptable.

Respect Your Audience

Everyone is entitled to their own opinion but not everyone will agree with it. Keep personal disputes out of the public channel. Make use of your IRC client /ignore nickname command.

Automatic Scripts

Please do not use scripts which will output to the public channel without human intervention. This can include the display of your away status, currently playing mp3, etc. Basically anything which can spam the channel with irrelevant information.

User activated scripts are acceptable to a certain extent although abuse of colors, ASCII or variants of l33tsp34k are greatly discouraged.

'''Seeking Help'''

While #project_skyfire isn't considered a support channel there are many knowledgeable people who visit regularly. If you are seeking help in debugging or fixing a problem it is important that you convey your problem in a suitable manner.

When seeking assistance always note that:

Only the most recent official revision of SkyFire can be supported. If you are using an old revision you should update before asking for help.
There is extensive documentation for software which SkyFire relies on. This includes Windows/Linux administration, MySQL server etc.

How To Ask A Question

If you take the time to prepare your question you'll often find that your response will be equally informative.

Don't ask to ask, just ask.
Tell us what revision you are using.
Tell us what OS you are running.
Give a clear description of the problem.

And Then?

Please do not reward the generosity of your fellow users by repeatedly asking for help. We are not here to spoon feed you.

Credits to MaNGOS for the rule set.

{{Pp-vandalism}}
[[Category:Rules]]

Category:Rules

2011-09-04T20:20:11Z

Marqin: Created page with ""

IRC Rules

2011-09-04T20:18:56Z

Marqin: Protected "IRC Rules" ([edit=sysop] (indefinite) [move=sysop] (indefinite))

This document describes several guidelines which should be considered when taking part in #project_skyfire discussions.

The rizon network which #project_skyfire resides on has their own network policy which all users should read and understand. Should any of the guidelines laid out in this document conflict with existing rizon policy then the rizon policy will always take precedence.

The purpose of these guidelines is to ensure the well being of the channel and that its objectives are respected and maintained.

This document has been split in to sections for easy reading:

Channel Rules
Seeking Help

'''Channel Rules'''

Respect the SkyFire License and EULA

Any breach of the SkyFire License and/or EULA within the confines of #project_skyfire will result in a permanent ban.

This can include supporting such violations via voice of personal opinion, linking and/or advertising public game servers, or anything which may be viewed as being contradictory to the SkyFire project objectives.

Ignorance of this rule will result in a permanent ban with no exceptions from both the IRC channel and official forum without prior warning.
RTFM

The SkyFire forums and IRC channel are for educational and development purposes only therefor it is expected that you have made a reasonable effort when undergoing tasks. Refer to the section seeking help for more information.

Speak English

You must speak English and English only while participating in public chat. Using an online translator is not acceptable.

Respect Your Audience

Everyone is entitled to their own opinion but not everyone will agree with it. Keep personal disputes out of the public channel. Make use of your IRC client /ignore nickname command.

Automatic Scripts

Please do not use scripts which will output to the public channel without human intervention. This can include the display of your away status, currently playing mp3, etc. Basically anything which can spam the channel with irrelevant information.

User activated scripts are acceptable to a certain extent although abuse of colors, ASCII or variants of l33tsp34k are greatly discouraged.

'''Seeking Help'''

While #project_skyfire isn't considered a support channel there are many knowledgeable people who visit regularly. If you are seeking help in debugging or fixing a problem it is important that you convey your problem in a suitable manner.

When seeking assistance always note that:

Only the most recent official revision of SkyFire can be supported. If you are using an old revision you should update before asking for help.
There is extensive documentation for software which SkyFire relies on. This includes Windows/Linux administration, MySQL server etc.

How To Ask A Question

If you take the time to prepare your question you'll often find that your response will be equally informative.

Don't ask to ask, just ask.
Tell us what revision you are using.
Tell us what OS you are running.
Give a clear description of the problem.

And Then?

Please do not reward the generosity of your fellow users by repeatedly asking for help. We are not here to spoon feed you.

Credits to MaNGOS for the rule set.

User talk:Locario

2011-09-04T17:35:34Z

Marqin: Created page with "{{Welcome|--~~~~}}"

Template:Back-to:World

2011-09-03T21:50:01Z

Marqin:

<noinclude>
[[Category:Templates]]
{{Pp-vandalism}}
</noinclude>

Template:Back-to:Auth

2011-09-03T21:49:54Z

Marqin:

The Auth database, Is used to hold all information that is passed between the servers, if more than one is being used.
<noinclude>
[[Category:Templates]]
{{Pp-vandalism}}
</noinclude>

Template:Userbox

2011-09-03T21:49:36Z

Marqin:

{| style="float:left; border:solid 1px {{{border|{{{bg1|#884410}}}}}}; width:240px;" cellspacing="0"
|-
| style="width:45px; height:45px; padding:0; background:{{{bg1|#cccccc}}}; text-align:center; font-size:{{{rozmiar1|16}}}px; border-right:solid 1px {{{border|{{{bg1|#cccccc}}}}}}; color: {{{size1|black}}};" | '''{{{1}}}'''
| style="font-size:{{{size2|11}}}px; padding: 1px 6px 1px 6px; line-height:1.25em; background:{{{bg2|#eeeeee}}}; color: {{{color2|black}}};" | {{{2}}}
|-
|}<noinclude>
<div style="clear:{{{1|both}}};"></div>

[[Category:Templates]]
{{Pp-vandalism}}

</noinclude>

Template:Welcome

2011-09-03T21:49:00Z

Marqin: Protected "Template:Welcome" ([edit=sysop] (indefinite) [move=sysop] (indefinite))

__NOEDITSECTION__
==Welcome, {{PAGENAME}}!==
Welcome to [http://www.projectskyfire.org Project Skyfire] Wiki!

Remember to sign all your posts on discussion pages with ''<nowiki>~~~~</nowiki>'' , but don't sign articles.
Before you post any new article - check how look existing ones. If you have any doubts or questions how to write - ask any of [http://wiki.projectskyfire.org/index.php?title=Special:ListUsers&group=sysop Administrators].

We hope you will enjoy this Wiki and will improve it with us!

Best Regards,

{{{1}}}
<noinclude>
{{Pp-vandalism}}
[[Category:Templates]]
</noinclude>

User talk:Marqin

2011-09-03T21:48:34Z

Marqin: Protected "User talk:Marqin" ([edit=sysop] (indefinite) [move=sysop] (indefinite))