From a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 Mon Sep 17 00:00:00 2001
From: FrancescoBorzi <borzifrancesco@gmail.com>
Date: Mon, 25 Feb 2019 19:24:20 +0100
Subject: Import DB wiki from TC 335

---
 docs/phase_area.md | 104 +++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 104 insertions(+)
 create mode 100644 docs/phase_area.md

(limited to 'docs/phase_area.md')

diff --git a/docs/phase_area.md b/docs/phase_area.md
new file mode 100644
index 0000000..2a7f54f
--- /dev/null
+++ b/docs/phase_area.md
@@ -0,0 +1,104 @@
+# phase\_area
+
+[Back-to:World](World)
+
+# Tables**:** phase\_area
+
+## General
+
+PhaseIds added to player by zone/area events. 
+Each line holds one Zone or Area with one phaseId and a description.  Each line is active by default. With the table [conditions](conditions)you can edit the working range of the phase.
+
+## Structure
+
+<table>
+<thead>
+<tr class="header">
+<th>Field</th>
+<th>Type</th>
+<th>Null</th>
+<th>Key</th>
+<th>Default</th>
+<th>Extra</th>
+</tr>
+</thead>
+<tbody>
+<tr class="odd">
+<td><a href="#phase_area-AreaId">AreaId</a></td>
+<td>int</td>
+<td>No</td>
+<td>Pri</td>
+<td>0</td>
+<td><br />
+</td>
+</tr>
+<tr class="even">
+<td><a href="#phase_area-PhaseId">PhaseId</a></td>
+<td>int</td>
+<td>No</td>
+<td>Pri</td>
+<td>0</td>
+<td><br />
+</td>
+</tr>
+<tr class="odd">
+<td><a href="#phase_area-Comment">Comment</a></td>
+<td>varchar</td>
+<td><br />
+</td>
+<td><br />
+</td>
+<td><br />
+</td>
+<td><br />
+</td>
+</tr>
+</tbody>
+</table>
+
+## Description of the fields
+
+### AreaId
+
+This is the Zone or Area identifier, see [AreaTrigger.dbc](http://collab.kpsn.org/display/tc/AreaTrigger)
+
+### PhaseId
+
+This is the connected PhaseId 
+
+### Comment
+
+A free description.
+
+**
+Examples**
+
+As Demo we look at Kezan, Startarea Goblin.
+
+The Player-Character is starting with PhaseId 378 and change on Quest Reward 14109 to Phase 379.
+
+So first we set the definition of both phaseIds to table phase\_area
+
+| AreaId | PhaseId | Comment         |
+|--------|---------|-----------------|
+| 4737   | 378     | Kezan startarea |
+| 4737   | 379     | Kezan startarea |
+
+Now we must declare the Quest-Range by using conditions. Note: we starting from start in phase 378, so we need no start-range, only the end range
+
+| SourceTypeOrReferenceId | SourceGroup | SourceEntry | ConditionTypeOrReference | ConditionValue1 | NegativeCondition | Comment                                            |
+|-------------------------|-------------|-------------|--------------------------|-----------------|-------------------|----------------------------------------------------|
+| 26                      | 378         | 4737        | 8                        | 14109           | 1                 | Kezan Set in Phase 378 from start to -Reward 14109 |
+
+Next we declare the following range for phase 379 starting with reward on quest 10109 and end on reward quest 14153
+
+| SourceTypeOrReferenceId | SourceGroup | SourceEntry | ConditionTypeOrReference | ConditionValue1 | NegativeCondition | Comment                                  |
+|-------------------------|-------------|-------------|--------------------------|-----------------|-------------------|------------------------------------------|
+| 26                      | 379         | 4737        | 8                        | 14109           | 0                 | Kezan Set in Phase 379 from reward 14109 |
+| 26                      | 379         | 4737        | 8                        | 14153           | 1                 | Kezan Set in Phase 379 to reward 14153   |
+
+And so on....
+
+Note: The quest 14109/14110 14113/14153 are Required Gender Quest.
+
+
-- 
cgit