“dbscripts_on_gossip” table

The dbscripts_on_gossip table holds holds scripts which are executed upon gossip option usage.

Table structure

Field Type Null Key Default Extra
id mediumint(8) unsigned NO   0  
delay int(10) unsigned NO   0  
command mediumint(8) unsigned NO   0  
datalong mediumint(8) unsigned NO   0  
datalong2 int(10) unsigned NO   0  
buddy_entry mediumint(8) unsigned NO   0  
search_radius mediumint(8) unsigned NO   0  
data_flags tinyint(3) unsigned NO   0  
dataint int(11) NO   0  
dataint2 int(11) NO   0  
dataint3 int(11) NO   0  
dataint4 int(11) NO   0  
x float NO   0  
y float NO   0  
z float NO   0  
o float NO   0  
comments varchar(255) NO   NULL  

Fields

id

This references the column script_id of the “gossip_menu_option” table table.

delay

The delay in seconds to apply before starting the script command. Setting the value to 0 will instantly execute the command.

Note

Delay is accumulated over all events with identical id values.

command

The action to execute once the delay defined has been reached. The following list shows all available actions.

Value Command Description
0 SCRIPT_COMMAND_TALK Creature will send a text emote (say, yell, whisper)
1 SCRIPT_COMMAND_EMOTE Creature/character will play an emote
2 SCRIPT_COMMAND_FIELD_SET Modifies a character variable
3 SCRIPT_COMMAND_MOVE_TO Moves a creature to a new location
4 SCRIPT_COMMAND_FLAG_SET Turns on bits on character variable
5 SCRIPT_COMMAND_FLAG_REMOVE Turns off bits on character variable
6 SCRIPT_COMMAND_TELEPORT_TO Teleports a character to a new location
7 SCRIPT_COMMAND_QUEST_EXPLORED Marks a quest exploration requirement as done
8 SCRIPT_COMMAND_KILL_CREDIT Marks a quest kill requirement as done
9 SCRIPT_COMMAND_RESPAWN_GAMEOBJECT Respawns a despawned game object
10 SCRIPT_COMMAND_TEMP_SUMMON_CREATURE Summons one/multiple temporary creature(s)
11 SCRIPT_COMMAND_OPEN_DOOR Opens a game object of type 0 (aka. a door)
12 SCRIPT_COMMAND_CLOSE_DOOR Closes a game object of type 0 (aka. a door)
13 SCRIPT_COMMAND_ACTIVATE_OBJECT Uses a game object
14 SCRIPT_COMMAND_REMOVE_AURA Removes an aura using a spell
15 SCRIPT_COMMAND_CAST_SPELL Cast a spell
16 SCRIPT_COMMAND_PLAY_SOUND Play a sound entry
17 SCRIPT_COMMAND_CREATE_ITEM Create an item
18 SCRIPT_COMMAND_DESPAWN_SELF Despawns a creature using an optional delay
19 SCRIPT_COMMAND_PLAY_MOVIE Play a move for the targeted character
20 SCRIPT_COMMAND_MOVEMENT Change the movement type of a creature
21 SCRIPT_COMMAND_SET_ACTIVEOBJECT Set a creature as active object
22 SCRIPT_COMMAND_SET_FACTION Change the faction of a creature
23 SCRIPT_COMMAND_MORPH_TO_ENTRY_OR_MODEL Changes a creature model displayed
24 SCRIPT_COMMAND_MOUNT_TO_ENTRY_OR_MODEL Mounts a creature with the given model
25 SCRIPT_COMMAND_SET_RUN Let a creature walk or run
26 SCRIPT_COMMAND_ATTACK_START Makes a creature attack within a given radius
27 SCRIPT_COMMAND_GO_LOCK_STATE Changes the lock/interaction state of a game object
28 SCRIPT_COMMAND_STAND_STATE Changes the stand state of a creature
29 SCRIPT_COMMAND_MODIFY_NPC_FLAGS Change the npcflag settings of a creature
30 SCRIPT_COMMAND_SEND_TAXI_PATH Puts a character on a given taxi path
31 SCRIPT_COMMAND_TERMINATE_SCRIPT Stops script execution on a creature if it meets a condition
32 SCRIPT_COMMAND_PAUSE_WAYPOINTS Pause or continue waypoint movement of a creature
33 SCRIPT_COMMAND_RESERVED_1 Reserved for later usage
34 SCRIPT_COMMAND_TERMINATE_COND Stops script execution if a condition is met
35 SCRIPT_COMMAND_TURN_TO Change a creature orientation towards a target

datalong

A multi-purpose field storing raw data as unsigned integer value.

datalong2

A multi-purpose field storing raw data as unsigned integer value.

buddy_entry

If the command used has a buddy entry, this references either an entry in the “gameobject_template” table or “creature_template” table table.

search_radius

The range in which the buddy’s entry will be search for.

Note

If data_flags has SCRIPT_FLAG_BUDDY_BY_GUID set, this references an entry in the “gameobject” table or “creature” table table.

data_flags

Holds a flag or a combination for flags for the script command. The following table contains all valid flags

Value Name
1 SCRIPT_FLAG_BUDDY_AS_TARGET
2 SCRIPT_FLAG_REVERSE_DIRECTION
4 SCRIPT_FLAG_SOURCE_TARGETS_SELF
8 SCRIPT_FLAG_COMMAND_ADDITIONAL
16 SCRIPT_FLAG_BUDDY_BY_GUID
32 SCRIPT_FLAG_BUDDY_IS_PET

dataint

A multi-purpose data field storing signed integer values.

Note

Currently these fields are only used as text identifiers for the SCRIPT_COMMAND_TALK and SCRIPT_COMMAND_TERMINATE_SCRIPT commands.

dataint2

A multi-purpose data field storing signed integer values.

Note

Currently these fields are only used as text identifiers for the SCRIPT_COMMAND_TALK and SCRIPT_COMMAND_TERMINATE_SCRIPT commands.

dataint3

A multi-purpose data field storing signed integer values.

Note

Currently these fields are only used as text identifiers for the SCRIPT_COMMAND_TALK and SCRIPT_COMMAND_TERMINATE_SCRIPT commands.

dataint4

A multi-purpose data field storing signed integer values.

Note

Currently these fields are only used as text identifiers for the SCRIPT_COMMAND_TALK and SCRIPT_COMMAND_TERMINATE_SCRIPT commands.

x

A X position on the map which the command needs.

y

A Y position on the map which the command needs.

z

A Z position on the map which the command needs.

o

An orientation on the map which the command needs.

comments

A comment describing the purpose of the script.