Disable npc

10/29/2015 13:35 vollcanoo#1
hello guys :

i want to ask how i disable the npc trader in Bghadad name is : specialty trader sanmok

i just want to disable buying the goods of that npc from SQL


, if i'm right and it's enough to make the service 0 and it's from VT_Shard : _Refshop , i can't found the name of that trader that i should change service to 0 , cuz they have another name in _RefShop : CodeName128 .


thanks for all the people who spend there time to answer

cheers .
10/29/2015 14:58 PlantiX#2
They easiest solution is that you just delete it from _RefTactics, RefNest, _RefHive.
Get the NPC_ID from RefObjCommon, search in _RefTactics, get the NestID -> search in _RefNest, get the HiveID -> search in _RefHive and delete all 3 lines.

restart the server
done
10/29/2015 18:02 vollcanoo#3
Quote:
Originally Posted by PlantiX View Post
They easiest solution is that you just delete it from _RefTactics, RefNest, _RefHive.
Get the NPC_ID from RefObjCommon, search in _RefTactics, get the NestID -> search in _RefNest, get the HiveID -> search in _RefHive and delete all 3 lines.

restart the server
done

hello :

i got the ID from RefObJCommon , but i can't found that tables in VT_Shard : _RefTacTics , _RefNest , _RefHive , can you explain more :( .
10/29/2015 18:22 PlantiX#4
Quote:
Originally Posted by vollcanoo View Post
hello :

i got the ID from RefObJCommon , but i can't found that tables in VT_Shard : _RefTacTics , _RefNest , _RefHive , can you explain more :( .
dbo.Tab_RefHive
dbo.Tab_RefNest
dbo.Tab_RefTactics
10/30/2015 06:30 vollcanoo#5
Quote:
Originally Posted by PlantiX View Post
dbo.Tab_RefHive
dbo.Tab_RefNest
dbo.Tab_RefTactics
thanks dear :)