asmodeosnetworkco / module_blizzcms-armory Goto Github PK

no work

Hi i have a problem with search player ...

Other module work on the CMS...

while using this module with Azerothcore, the gear equipped is not correct. The reason behind this is the code is looking in character_inventory.item for the item number. The actual number for items is stored in item_instance.itemEntry. the thing is, we do need the current number that is being pulled from character_inventory.item, as it references to item_instance.guid. and then finally the proper item number is found in item_instance.itemEntry. I tried creating a join. but my coding abilities are trash at best.

this is what I came up with, but obviously it doesn't work. so if someone that knows more can assist in actual functioning join.

Armory_model.php

public function getCharInvHead($MultiRealm, $id)
{
	$this->multirealm = $MultiRealm;
    $this->multirealm->select('item')->where('guid',$id)->where('bag','0')->where('slot','0')->get('character_inventory');
    $this->multirealm->join('item_instance', 'item_instance.guid = character_inventory.item');
    $this->multirealm->where('guid','item'); 
    $query = $this->multirealm->get();
    return $query->result();
 }

I was then thinking I could reference itemEntry field in view.

whenever using the search feature with a single realm. this is the message my firefox browser tells me.

but when using on a site that has more than 1 realm. the search feature is instant. so it would appear there is a connection to multirealm?