summaryrefslogtreecommitdiff
path: root/docs/creature_onkill_reputation.md
diff options
context:
space:
mode:
authorFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
committerFrancescoBorzi <borzifrancesco@gmail.com>2019-02-25 19:24:20 +0100
commita35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch)
tree91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/creature_onkill_reputation.md
parentd8d1823802ded97300fa57405d80b16736603489 (diff)
downloadwiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz
wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2
wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip
Import DB wiki from TC 335
Diffstat (limited to 'docs/creature_onkill_reputation.md')
-rw-r--r--docs/creature_onkill_reputation.md230
1 files changed, 216 insertions, 14 deletions
diff --git a/docs/creature_onkill_reputation.md b/docs/creature_onkill_reputation.md
index 715f9cb..d39127f 100644
--- a/docs/creature_onkill_reputation.md
+++ b/docs/creature_onkill_reputation.md
@@ -1,14 +1,216 @@
-[Database Structure](Database-Structure) > [World-Database](World-Database) > [creature_onkill_reputation](creature_onkill_reputation)
-
-Column | Type | Description
---- | --- | ---
-Creature_id | mediumint(8) unsigned |
-RewOnKillRepFaction1 | smallint(6) |
-RewOnKillRepFaction2 | smallint(6) |
-MaxStanding1 | tinyint(4) |
-IsTeamAward1 | tinyint(4) |
-RewOnKillRepValue1 | mediumint(8) |
-MaxStanding2 | tinyint(4) |
-IsTeamAward2 | tinyint(4) |
-RewOnKillRepValue2 | mediumint(9) |
-TeamDependent | tinyint(3) unsigned |
+# creature\_onkill\_reputation
+
+`Back-to:World`
+
+**The \`creature\_onkill\_reputation\` table**
+
+This table controls the reputation given by creatures when killed by other players.
+
+**Structure**
+
+<table>
+<colgroup>
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+<col width="12%" />
+</colgroup>
+<tbody>
+<tr class="odd">
+<td><p><strong>Field</strong></p></td>
+<td><p><strong>Type</strong></p></td>
+<td><p><strong>Attributes</strong></p></td>
+<td><p><strong>Key</strong></p></td>
+<td><p><strong>Null</strong></p></td>
+<td><p><strong>Default</strong></p></td>
+<td><p><strong>Extra</strong></p></td>
+<td><p><strong>Comment</strong></p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#creature_onkill_reputation-creature_id">creature_id</a></p></td>
+<td><p>mediumint(8)</p></td>
+<td><p>unsigned</p></td>
+<td><p>PRI</p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p>Creature Identifier</p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#creature_onkill_reputation-RewOnKillRepFaction">RewOnKillRepFaction1</a></p></td>
+<td><p>smallint(6)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#creature_onkill_reputation-RewOnKillRepFaction">RewOnKillRepFaction2</a></p></td>
+<td><p>smallint(6)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#creature_onkill_reputation-MaxStanding">MaxStanding1</a></p></td>
+<td><p>tinyint(4)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#creature_onkill_reputation-IsTeamAward">IsTeamAward1</a></p></td>
+<td><p>tinyint(4)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#creature_onkill_reputation-RewOnKillRepValue">RewOnKillRepValue1</a></p></td>
+<td><p>mediumint(9)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#creature_onkill_reputation-MaxStanding">MaxStanding2</a></p></td>
+<td><p>tinyint(4)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#creature_onkill_reputation-IsTeamAward">IsTeamAward2</a></p></td>
+<td><p>tinyint(4)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="even">
+<td><p><a href="#creature_onkill_reputation-RewOnKillRepValue">RewOnKillRepValue2</a></p></td>
+<td><p>mediumint(9)</p></td>
+<td><p>signed</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+<tr class="odd">
+<td><p><a href="#creature_onkill_reputation-TeamDependent">TeamDependent</a></p></td>
+<td><p>tinyint(3)</p></td>
+<td><p>unsigned</p></td>
+<td><p> </p></td>
+<td><p>NO</p></td>
+<td><p>0</p></td>
+<td><p> </p></td>
+<td><p> </p></td>
+</tr>
+</tbody>
+</table>
+
+**Description of the fields**
+
+### creature\_id
+
+The template ID of the creature. See [creature\_template.entry](http://collab.kpsn.org/display/tc/creature_template#creature_template-entry)
+
+### RewOnKillRepFaction
+
+The faction ID of the faction that the player will gain or lose points in. See Faction.dbc
+
+### MaxStanding
+
+The maximum standing that the creature will award reputation until. If the player achieves this standing or any other standing higher than this, the creature will not award any reputation.
+
+<table>
+<colgroup>
+<col width="50%" />
+<col width="50%" />
+</colgroup>
+<thead>
+<tr class="header">
+<th><p>ID</p></th>
+<th><p>Rank</p></th>
+</tr>
+</thead>
+<tbody>
+<tr class="odd">
+<td><p>0</p></td>
+<td><p>Hated</p></td>
+</tr>
+<tr class="even">
+<td><p>1</p></td>
+<td><p>Hostile</p></td>
+</tr>
+<tr class="odd">
+<td><p>2</p></td>
+<td><p>Unfriendly</p></td>
+</tr>
+<tr class="even">
+<td><p>3</p></td>
+<td><p>Neutral</p></td>
+</tr>
+<tr class="odd">
+<td><p>4</p></td>
+<td><p>Friendly</p></td>
+</tr>
+<tr class="even">
+<td><p>5</p></td>
+<td><p>Honored</p></td>
+</tr>
+<tr class="odd">
+<td><p>6</p></td>
+<td><p>Revered</p></td>
+</tr>
+<tr class="even">
+<td><p>7</p></td>
+<td><p>Exalted</p></td>
+</tr>
+</tbody>
+</table>
+
+### IsTeamAward
+
+Boolean 0 or 1 that controls if the player receives the reputation not only to the faction but also the faction team.
+
+- 0: Player receives reputation only for the faction
+- 1: Player receives reputation both for the faction and the faction's team
+
+NOTE: The reputation value that the player gains for the team (if the field is 1) is half of the value specified in [RewOnKillRepValue](#creature_onkill_reputation-RewOnKillRepValue)
+
+### RewOnKillRepValue
+
+The reputation value that the player gains (or loses if it's negative) by killing the creature.
+
+### TeamDependent
+
+Boolean 0 or 1.
+
+- 0: The creature will give reputation to the any player from both fields (RewOnKillRepFaction1 and RewOnKillRepFaction2) if both fields are non-zero.
+- 1: The creature will award alliance players the reputation from RewOnKillRepFaction1 and will award horde players the reputation from RewOnKillRepFaction2
+