Disable/DEL Shop/NPC

02/09/2013 22:01 sybtek#1

hi guy is there any query to disable (better DEL) a specific shop from database?
i found a very nice DB but there are shops and itmes i dont like for my server.

thx for help

02/09/2013 22:36 Snow*#2

You don't have to use query, deactivate it your self.
_RefShop @ DB and refshop.txt @ media.pk2, set the service to 0.

02/09/2013 22:53 sybtek#3

Thais all? And how to del complet from database? How can i know witch One is The right? In database they dont have The Same Name like ingame :(

02/10/2013 00:30 Snow*#4

Quote:

Originally Posted by sybtek

Thais all? And how to del complet from database? How can i know witch One is The right? In database they dont have The Same Name like ingame :(

Open the textdata_object.txt from the media.pk2, and search for the NPC name.
For example

Spoiler

Now go to the refshop.txt in media.pk2 and _RefShop @ DB.
Set the service 0

Spoiler

You wont find the NPC in da game anymore.
Press thanks if I helped >.<

02/10/2013 00:33 zikor1337#5

Deactivate it on the server side. It shouldn't need a deactivation on the client side.

02/10/2013 17:09 sybtek#6

Quote:

Originally Posted by SnowStorm1

Open the textdata_object.txt from the media.pk2, and search for the NPC name.
For example

Spoiler

[Only registered and activated users can see links. Click Here To Register...]
Blacksmith Chulsan is the NPC name.
NPC_CH_SMITH = the NPC code. ( you will change NPC to STORE)

Now go to the refshop.txt in media.pk2 and _RefShop @ DB.
Set the service 0

Spoiler

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

You wont find the NPC in da game anymore.
Press thanks if I helped >.<

sry not working :(

02/10/2013 17:36 zikor1337#7

go to RefObject in shard db. Search for the npc you wanna deactivate Service 1 to 0 . Done!