Datenbank 'characters'
account_data
account_instance_times
account_tutorial
addons
arena_team
arena_team_member
auctionhouse
banned_addons
bugreport
calendar_events
calendar_invites
channels
characters
character_account_data
character_achievement
character_achievement_progress
character_action
character_arena_stats
character_aura
character_banned
character_battleground_data
character_battleground_random
character_declinedname
character_equipmentsets
character_gifts
character_glyphs
character_homebind
character_instance
character_inventory
character_pet
character_pet_declinedname
character_queststatus
character_queststatus_daily
character_queststatus_monthly
character_queststatus_rewarded
character_queststatus_seasonal
character_queststatus_weekly
character_reputation
character_skills
character_social
character_spell
character_spell_cooldown
character_stats
character_talent
corpse
creature_respawn
gameobject_respawn
game_event_condition_save
game_event_save
gm_subsurvey
gm_survey
gm_ticket
groups
group_instance
group_member
guild
guild_bank_eventlog
guild_bank_item
guild_bank_right
guild_bank_tab
guild_eventlog
guild_member
guild_member_withdraw
guild_rank
instance
instance_reset
item_instance
item_loot_items
item_loot_money
item_refund_instance
item_soulbound_trade_data
lag_reports
lfg_data
mail
mail_items
petition
petition_sign
pet_aura
pet_spell
pet_spell_cooldown
pool_quest_save
pvpstats_battlegrounds
pvpstats_players
quest_tracker
reserved_name
updates
updates_include
warden_action
worldstates
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'characters'

Tabelle: 'item_loot_items'

The `item_loot_items` table

Contains the items associated with a lootable inventory item such as a "watertight trunk"or "Bulging Sack of Gems"

This table is populated the first time the player right-clicks to open an item. Rows are deleted when
the player either removes an item or destroys the container item.

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
container_idint(10)vorzeichenlosnein0
item_idint(10)vorzeichenlosnein0
item_countint(10)

NO

0
follow_rulestinyint(1)nein0
ffatinyint(1)nein0
blocked

tinyint(1)

nein0
countedtinyint(1)nein0
under_thresholdtinyint(1)nein0

needs_questtinyint(1)nein0
rnd_propint(10)nein0
rnd_suffixint(10)

NO

0

Description of the fields

container_id

The GUID of the container item that holds the loot item(s). See item_instance.guid

Note: A container_id can have more than one item_id associated with it.

item_id

The entry of the loot item. See item_instance.itemEntry

Note: It is possible for there to be more than one of the same item in a container.

item_count

The stack size of the item. Only stackable items can be > 1.

follow_rules

Flag to determine if the core should apply additional loot rules when the item
is removed from the container.

ffa

Flag to determine if free-for-all looting applies. This should typically be 0 because the items are inside

an item in the character's inventory.

blocked

field-no-description|6

counted

field-no-description|6

under_threshold

field-no-description|6

needs_quest

Flag to determine if the item is a quest item to be counted as a "quest drop".

rnd_prop

The random enchantment (if any) that was rolled and added to the item when the loot container was
originally opened.

For example: "Ebon Scimitar" (as opposed to a plain "Scimitar").

rnd_suffix

The random suffix (if any) that was rolled and added to the item when the loot container was
originally opened.

For example: "of the Monkey"


Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
WoW Portal MPOG TOP WoW Servers NET Private Server
Gametoor Top 100 Arena Top G Top of Games Oxigen Top 100 List
Facebook YouTube
Impressum