Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 17:36

  • Please register to post and access all features, it's quick, easy and FREE!

 

Remove NPC or edit

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2009
Posts: 44
Received Thanks: 0
Remove NPC or edit

Is there a way to edit npc's and remove because i have some npc's ingame and they will crash the client when click on it



rickske95 is offline  
Old   #2
 
elite*gold: 0
Join Date: Jun 2013
Posts: 31
Received Thanks: 3
SQL Server --> Arcadia --> NPCResource (Right Click) --> Edit Top Rows

Then, edit or delete


Dyson49 is offline  
Old   #3
 
elite*gold: 0
Join Date: Jul 2012
Posts: 231
Received Thanks: 65
use arcadia
delete from npcresource
where id = xxxx
eziorav is offline  
Old   #4
 
elite*gold: 0
Join Date: Jul 2012
Posts: 147
Received Thanks: 196
Quote:
Originally Posted by eziorav View Post
use arcadia
delete from npcresource
where id = xxxx
Don't do this. ^

Just find the npc in arcadia and change the flag.


TheChinStrap is offline  
Old   #5
 
elite*gold: 0
Join Date: Jul 2012
Posts: 231
Received Thanks: 65
Quote:
Originally Posted by TheChinStrap View Post
Don't do this. ^

Just find the npc in arcadia and change the flag.
Yep u are right
the code will remove any Npc with the same id
just change the flag as he said

update npcresource
set local_flag = 18937 where contact_script like "%xxxxx%"
eziorav is offline  
Old   #6
 
elite*gold: 0
Join Date: Jul 2012
Posts: 147
Received Thanks: 196
Quote:
Originally Posted by eziorav View Post
Yep u are right
the code will remove any Npc with the same id
just change the flag as he said

update npcresource
set local_flag = 18937 where contact_script like "%xxxxx%"
Don't do this ^ either.

Use this script to find the id:

Then:
TheChinStrap is offline  
Old   #7
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
Quote:
Originally Posted by TheChinStrap View Post
Then:

UPDATE dbo.StringResource
SET local_flag = XXXX
WHERE id = XXXX
You Serious?

Im sure you meant this or?
Update arcadia.dbo.npcresource set local_flag = xx where id = xx
TheOnlyOneRaskim is offline  
Old   #8
 
elite*gold: 0
Join Date: Jul 2012
Posts: 147
Received Thanks: 196
Quote:
Originally Posted by TheOnlyOneRaskim View Post
You Serious?

Im sure you meant this or?
Update arcadia.dbo.npcresource set local_flag = xx where id = xx
Ha ha ha. Yeah, I must have been tired. Post corrected. Thanks, Raskim, for pointing out my shortcomings, yet again. XD
TheChinStrap is offline  
Old   #9
 
elite*gold: 0
Join Date: Jun 2012
Posts: 49
Received Thanks: 48
some note : if you want to edit the NPC you must edit in Database and in RDB
But , if you just want to edit the location ( x,y) you can edit it in Database only


rakanomar is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Request Help] Remove mobs / remove eur items / remove npc
Iam sure all now saies this guy is mad :D why not remove the db i want to know how i can remove mobs from samrkand and add alex mobs there and...
0 Replies - SRO PServer Ask the Experts
[HELP]How To Remove GM messages or Edit them
i got a 5065 source from somewhere :pimp: it works great but there are alot of GM messages popping up at GM broadcast The Server Is Free And...
4 Replies - CO2 PServer - Discussions / Questions



All times are GMT +2. The time now is 17:36.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.