Npc spellclick spells SF - Revision history

Cheapgamer: Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} '''The `npc_spellclick_spells` table''' {{table-no-description}}
2012-07-06T19:44:18Z

Created page with "{| align="right" | TOC |} Category: SkyFire World database tables {{Back-to:World}} <big>'''The `npc_spellclick_spells` table'''</big> {{table-no-description}} <b..."

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

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

{{table-no-description}}

<big>'''Structure'''</big>
{| border="1"
|'''Field'''
|'''Type'''
|'''Attributes'''
|'''Key'''
|'''Null'''
|'''Default'''
|'''Extra'''
|'''Comment''''
|-
|[[#npc_entry|npc_entry]]
|int(10)
|unsigned
|
|NO
|NULL
|
|reference to creature_template
|-
|[[#spell_id|spell_id]]
|int(10)
|unsigned
|
|NO
|NULL
|
|spell which should be casted
|-
|[[#cast_flags|cast_flags]]
|tinyint(3)
|unsigned
|
|NO
|NULL
|
|first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit
|-
|[[#user_type|user_type]]
|smallint(3)
|unsigned
|
|NO
|0
|
|relation with summoner: 0-no 1-friendly 2-raid 3-party player can click
|}

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

====npc_entry====
Reference to [[Creature_template SF#entry|creature_template.entry]]

====spell_id====
The spell which should be cast.

====cast_flags====

On every spellclick event a player and a creature "participate". This field defines who casts the spell on who.
Lower bit defines caster: 1=player, 0=creature; higher bit defines target, same mapping as caster bit.
You can use that table for the actual value:

{| class="wikitable"
|-
! Caster
! Target
! cast_flags value
|-
| Creature
| Creature
| 0
|-
| Player
| Creature
| 1
|-
| Creature
| Player
| 2
|-
| Player
| Player
| 3
|}

====user_type====
Relation with summoner: defines who is able to use this spellclick.

{| class="wikitable"
|-
! Value
! Description
|-
| 0
| Only self
|-
| 1
| Friendly
|-
| 2
| Raid
|-
| 3
| Party
|}