weapon at npc's belt

[aidarius]

Hi
Because i cant solve how to make weapons visible at npc's belt i decide ask for help here. What sql table contains that option ?
in effect it should look like on global http://images1.wikia.nocookie.net/__...l_Retainer.jpg

[stoneharry]

I was in the process of writing a ArcEmu to TrinityCore world database converter (logon/char one already exists) however, got stuck with the horrible structure and misleading field names/table names.

Anyway, looking at my code:

	// Equipment ID
	$string = $string . "REPLACE INTO creature_equip_template VALUES (";
	$string = $string . "'{$equipmentid}', '{$row['slot1item']}', '{$row['slot2item']}', '{$row['slot3item']}'";
	$string = $string . ");\n";

So the table: creature_equip_template

Takes: Creature GUID, ItemSlot1, ItemSlot2, ItemSlot3.

So you would insert:

Creature GUID, WeaponDisplayID (or entry id? not sure), 0, 0.

With ArcEmu, just use this command in game:

.npc equip1 weaponEntryID

[aidarius]

Thanks for advice Stoneharry, it works