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/creature_onkill_reputation.md | 230 ++++++++++++++++++++++++++++++++++--- 1 file changed, 216 insertions(+), 14 deletions(-) (limited to 'docs/creature_onkill_reputation.md') 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** + + ++++++++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Field

Type

Attributes

Key

Null

Default

Extra

Comment

creature_id

mediumint(8)

unsigned

PRI

NO

0

 

Creature Identifier

RewOnKillRepFaction1

smallint(6)

signed

 

NO

0

 

 

RewOnKillRepFaction2

smallint(6)

signed

 

NO

0

 

 

MaxStanding1

tinyint(4)

signed

 

NO

0

 

 

IsTeamAward1

tinyint(4)

signed

 

NO

0

 

 

RewOnKillRepValue1

mediumint(9)

signed

 

NO

0

 

 

MaxStanding2

tinyint(4)

signed

 

NO

0

 

 

IsTeamAward2

tinyint(4)

signed

 

NO

0

 

 

RewOnKillRepValue2

mediumint(9)

signed

 

NO

0

 

 

TeamDependent

tinyint(3)

unsigned

 

NO

0

 

 

+ +**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. + + ++++ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

ID

Rank

0

Hated

1

Hostile

2

Unfriendly

3

Neutral

4

Friendly

5

Honored

6

Revered

7

Exalted

+ +### 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 + -- cgit