Npc responsesTable: Difference between revisions
		
		
		
		Jump to navigation
		Jump to search
		
|  Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | id | integer |  |  |- | trigger_id | integer |  |  |- | response1 | longvarchar |  |  |- | response2 | longvarcha…' | No edit summary | ||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| {|  | |||
| {| class="wikitable" | |||
| |+ | |||
| !UE | |||
| !Field | |||
| !Type | |||
| !Key Type | |||
| !Default | |||
| !Extra | |||
| !Description | |||
| |- | |- | ||
| | | |||
| |id | |||
| |int(10) unsigned | |||
| |PRI | |||
| | | |||
| |auto_increment | |||
| |  | |||
| |- | |- | ||
| |  | | | ||
| |  | |trigger_id | ||
| |int(10) unsigned | |||
| | | |||
| |0 | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |response1 | |||
| |text | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |response2 | ||
| |text | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |response3 | |||
| |text | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |response4 | ||
| |text | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |||
| | | |||
| |response5 | |||
| |text | |||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |pronoun_him | ||
| |   | |varchar(30) | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |pronoun_her | ||
| |   | |varchar(30) | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |pronoun_it | ||
| |   | |varchar(30) | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |pronoun_them | ||
| |   | |varchar(30) | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |script | ||
| |   | |blob | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |prerequisite | ||
| |   | |blob | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| |  | |quest_id | ||
| |   | |int(10) unsigned | ||
| | | |||
| | | |||
| | | |||
| |   | |   | ||
| |- | |- | ||
| |  | | | ||
| | varchar | |audio_path1 | ||
| |   | |varchar(100) | ||
| |   | | | ||
| | | |||
| | | |||
| |This holds an optional VFS path to a speech file to be sent to the client and played on demand for response1.  | |||
| |- | |- | ||
| |  | | | ||
| |  | |audio_path2 | ||
| |   | |varchar(100) | ||
| |   | | | ||
| | | |||
| | | |||
| |This holds an optional VFS path to a speech file to be sent to the client and played on demand for response2.  | |||
| |- | |- | ||
| |  | | | ||
| |  | |audio_path3 | ||
| |   | |varchar(100) | ||
| |   | | | ||
| | | |||
| | | |||
| |This holds an optional VFS path to a speech file to be sent to the client and played on demand for response3.  | |||
| |- | |- | ||
| |  | | | ||
| |  | |audio_path4 | ||
| |   | |varchar(100) | ||
| |   | | | ||
| | | |||
| | | |||
| |This holds an optional VFS path to a speech file to be sent to the client and played on demand for response4.  | |||
| |- | |- | ||
| |  | | | ||
| | varchar | |audio_path5 | ||
| |   | |varchar(100) | ||
| |   | | | ||
| | | |||
| | | |||
| |This holds an optional VFS path to a speech file to be sent to the client and played on demand for response5.  | |||
| |} | |} | ||
| [[Category:Engine documents]] | |||
Latest revision as of 12:47, 11 January 2022
| UE | Field | Type | Key Type | Default | Extra | Description | 
|---|---|---|---|---|---|---|
| id | int(10) unsigned | PRI | auto_increment | |||
| trigger_id | int(10) unsigned | 0 | ||||
| response1 | text | |||||
| response2 | text | |||||
| response3 | text | |||||
| response4 | text | |||||
| response5 | text | |||||
| pronoun_him | varchar(30) | |||||
| pronoun_her | varchar(30) | |||||
| pronoun_it | varchar(30) | |||||
| pronoun_them | varchar(30) | |||||
| script | blob | |||||
| prerequisite | blob | |||||
| quest_id | int(10) unsigned | |||||
| audio_path1 | varchar(100) | This holds an optional VFS path to a speech file to be sent to the client and played on demand for response1. | ||||
| audio_path2 | varchar(100) | This holds an optional VFS path to a speech file to be sent to the client and played on demand for response2. | ||||
| audio_path3 | varchar(100) | This holds an optional VFS path to a speech file to be sent to the client and played on demand for response3. | ||||
| audio_path4 | varchar(100) | This holds an optional VFS path to a speech file to be sent to the client and played on demand for response4. | ||||
| audio_path5 | varchar(100) | This holds an optional VFS path to a speech file to be sent to the client and played on demand for response5. |