From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001 From: FrancescoBorzi Date: Mon, 25 Feb 2019 19:24:20 +0100 Subject: Import DB wiki from TC 335 --- docs/game_event_condition.md | 130 +++++++++++++++++++++++++++++++++++++++---- 1 file changed, 120 insertions(+), 10 deletions(-) (limited to 'docs/game_event_condition.md') diff --git a/docs/game_event_condition.md b/docs/game_event_condition.md index 87de598..98363f4 100644 --- a/docs/game_event_condition.md +++ b/docs/game_event_condition.md @@ -1,10 +1,120 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [game_event_condition](game_event_condition) - -Column | Type | Description ---- | --- | --- -EventEntry | tinyint(3) unsigned | -Condition_id | mediumint(8) unsigned | -Req_num | float | -Max_world_state_field | smallint(5) unsigned | -Done_world_state_field | smallint(5) unsigned | -Description | varchar(25) | +# game\_event\_condition + +`Back-to:World` + +**The \`game\_event\_condition\` table** + +This table contains conditions to meet for the specified game event to be completed. Also contains the world state fields used for reporting the given conditions progress and/or max required value. This table will do absolutely nothing if you have not set the event to be a world event. + +**Structure** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

eventEntry

tinyint(3)

unsigned

PRI

NO

 

 

Entry of the game event

condition_id

mediumint(8)

unsigned

PRI

NO

0

 

 

req_num

float

signed

 

YES

0

 

 

max_world_state_field

smallint(5)

unsigned

 

NO

0

 

 

done_world_state_field

smallint(5)

unsigned

 

NO

0

 

 

description

varchar(25)

signed

 

NO

"

 

 

+ +**Description of the fields** + +### eventEntry + +This is a link to the event entry in the game\_event table. + +### condition\_id + +This is the condition ID for this particular world event condition. It is an arbitrary number, and you can have multiple conditions for each world event. It links to the condition\_id field of the game\_event\_quest\_condition table. + +### req\_num + +This is an arbitrary value that determines when this condition is met. For example, if you set this value to 1000, and there is only one quest in game\_event\_quest\_condition that will fulfill this condition, and it increases this condition by 100 (by setting the num field to 100), then you would need to have your players complete 10 of that quest to fulfill this condition. + +### max\_world\_state\_field + +This is the world state update field number sent to the client that is used to report the maximum number of needed points in order to satisfy this condition. It can be found in gossip texts referenced with $XXXXw where XXXX is the world state number that will be sent when that gossip is displayed. If you are doing a custom event, you can pick any number you want that isn't in use, it just needs to match the custom text that you put into the npc\_text table. + +### done\_world\_state\_field + +This is the world state update field number sent to the client that is used to report the number of accumulated points so far for this condition. It can be found in gossip texts referenced with $XXXXw where XXXX is the world state number that will be sent when that gossip is displayed. If you are doing a custom event, you can pick any number you want that isn't in use, it just needs to match the custom text that you put into the npc\_text table. + +### description + +Arbitrary text field describing this condition. -- cgit