how Remove Traders KTS ?

[badboy5]

How ? ~~

[korrex]

By using the search function, and by learning MSSQL. (I REFUSE TO LEARN IT! MySQL<3)

[91ervans]

You can remove the Traders at SQL->Arcadia->dbo.NPCResource .

91ervans

[ByeByeRappelz]

Hello Again,
Can you be a lil bit more specific please and ty.




Updated:
Figured it out, All removed. Thank You Again

[lawlywood]

/position is your friend

[h96vy]

don't help him please

[Yunchen]

= 0 means enable, = -1 means disable

USE Arcadia
GO
UPDATE dbo.NPCResource
set local_flag = -1
where contact_script like '%crushop%'

USE Arcadia
GO
UPDATE dbo.NPCResource
set local_flag = -1
where contact_script like '%event%'

USE Arcadia
GO
UPDATE dbo.NPCResource
set local_flag = -1
where contact_script like '%rank%'

USE Arcadia
GO
UPDATE dbo.NPCResource
set local_flag = -1
where contact_script like '%creature%'

[ismokedrow]

Eh Yunchen, you need just a hair more than that.

USE Arcadia
UPDATE dbo.NPCResource
SET local_flag = 65519
WHERE contact_script LIKE '%crushop%'
GO

USE Arcadia
UPDATE dbo.NPCResource
SET is_periodic = True
WHERE contact_script LIKE '%crushop%'
GO

At-least that's what I've done to hide all unwanted NPC, credits to me :P + Original Credits to Kale.

[Yunchen]

Originally Posted by speedy-nl

realy ?

you shoud look better at the name who posted that lil script

if you give credits do it right or don't give any

Always u,well i dont care ur post getting killed like always.

[Yunchen]

Originally Posted by speedy-nl

sure next thing you post is how to add npc's and give credits to yourself right

why should i?its already public so i have to give right credits.

[ismokedrow]

Yunchen, I guess he got tired of getting stone walled by me every time he posts here at EPVP, I don't have to be an EPVP *** to tell some little ***** off. Anyway, Yun don't worry about anything he has to say -- At-least you are being helpful to the community and trying to issue correct credits, that mores than most.

As for you Speedy, oh Speedy.... heh. You need to go ahead and accept that your part in the whole Rappelz P-Server Scheme is limited at best. I dare you to put your knowledge up against mine, I would indeed love to see you lose horridly. I don't understand why you are even here, did it get tiresome always kissing NCarbons ***?

Or do they just ignore you almost constantly, I'm leaning toward the latter. You're posts are hard to understand at most times if not down right jibberish, you need to quit trying to garner the attention of people like me. We don't want you and we don't care what you want in the slightest, so take your *** back to the Arcadia Forums. OH! That's right basically NO ONE posts there due to YOU.

Have a good day and enjoy sucking at life.

[Yunchen]

U got absolutely right,ofc im not the best.. but im trying to help this big Community.
Ok it was my bad i wrote wrong Credits,but where is the problem?
I think Speedy got bored on Acradia Forums and going to post on Epvp.