Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 13:20

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

 

[Help Thread] Please post your questions here.

Reply
 
Old   #3331
 
elite*gold: 0
Join Date: Jun 2010
Posts: 129
Received Thanks: 2
Hello here is I ask you how the second measures to server



guildeur is offline  
Old   #3332
 
elite*gold: 0
Join Date: May 2010
Posts: 2
Received Thanks: 0
Loot Pet ID

Deutsch:
Hi ich bin auf der Suche nach den Loot Pets IDs der neueren Looter sprich dem Blättergeist, dem "Igel", Pengi, etc. (die genauen Namen kenne ich leider nicht)
auch bin ich auf der suche nach der ID der Kukuriflüsterin.
Ich hab nur die regulären Looter IDs gefunden.


Englisch:
Hi
i´m looking for the loot pet IDs from the looter Leefli, Mohi, ****** etc.
also for the loot pet Holly.
Hope someone can help me.
I only found the common one.


Phouria is offline  
Old   #3333
 
elite*gold: 0
Join Date: Sep 2012
Posts: 62
Received Thanks: 3
Horison Yak Farm

Hey there

I there an easy way to make the four fenced off areas in the yak farm accessible, when I teleport into that area I get a message You cannot move to that area, thanks guys
Domesday Brock is offline  
Old   #3334
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,002
Received Thanks: 957
Find some way to edit the NFA files for the map area.

mongreldogg has been working on one, but at the moment it can only add new collision points, not remove existing ones...



ThunderNikk is offline  
Thanks
1 User
Old   #3335
 
elite*gold: 0
Join Date: Sep 2012
Posts: 62
Received Thanks: 3
Quote:
Originally Posted by thndr View Post
Find some way to edit the NFA files for the map area.

mongreldogg has been working on one, but at the moment it can only add new collision points, not remove existing ones...

Always to the rescue
Thanks mate
Domesday Brock is offline  
Old   #3336
 
elite*gold: 30
Join Date: Mar 2012
Posts: 625
Received Thanks: 280
Quote:
Originally Posted by Domesday Brock View Post
Always to the rescue
Thanks mate
i made new thread with a release of 2 tools for map edit and there is an NFA editor that allows to remove collisions too.

mongreldogg is offline  
Thanks
1 User
Old   #3337
 
elite*gold: 0
Join Date: May 2011
Posts: 23
Received Thanks: 1
Hi guys, searched around the forum and well found most of the information that was nessesary, but there are still a lot of questions..... So I decided to check my luck.
First of all I don't remember whose server files and databases I have on my hands, but well everything seems to work fine(at least for now), the only things which are bothering me are : 1 - How to turn off the x-mass event?(where to dig, searched luas and found nothing, searched the database tables and still nothing). 2 - I have a online npc who sells capes, helmets, but they are a mess(when talking to the npc he gives you a list of items he has, but they duplicate one item is dispayed 4 times and they are all the same) so where and how can I find this npc in the database? 3 - A nother of the npc's sells shop items for ruppies ingame, he has almost everything needed except for the fairy *** what ever bottles and locks(to prevent items falling out on death), looking around the forums I found the fairy *** bottle code and tried my luck simply by adding the item to my inventory as gm, and got a empty string error in the ingame chat, so I guess this means there is no such item in my database? I want to custom my npc's normally to sell all items and to fix the duplication of the helmets and capes(2nd question)

Edit : After messing around with the database and hitting the "Edit first 1000 rows) I found the capes and helmets now I'll have to delete the useless rows and replace some of the item codes, but still wasn't able to find how to edit the other shop npc and how to turn off the x-mass event
Wir7- is offline  
Old   #3338
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,002
Received Thanks: 957
1. How to turn off the Christmas event and decorations...

Turns it on

Code:
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_tree'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_ornament01'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_ornament02'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_ornament03'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_ornament04'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_decoration01'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_decoration02'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_decoration06'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_decoration07'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_decoration08'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_decoration09'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_decoration10'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_ornament11_01'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_ornament11_02'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'ccommon_event_rangifer_ornament11_03'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = 0
where file_name like'common_event_rangifer_eventpack01'
go
Turns it off

Code:
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_tree'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_ornament01'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_ornament02'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_ornament03'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_ornament04'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_decoration01'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_decoration02'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_decoration06'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_decoration07'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_decoration08'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_decoration09'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_decoration10'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_ornament11_01'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_ornament11_02'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'ccommon_event_rangifer_ornament11_03'
go
Update Arcadia.dbo.FieldPropResource
set local_flag = -1
where file_name like'common_event_rangifer_eventpack01'
go
I don't have the SQL written for these yet but you also have to set the local flag on the NPCs in dbo.NPCResource to get rid of them...

Code:
11816	100011816	105011816	3	2	152519	77121	0	270	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	2	-3	16	gam	101	205	2000243	0	0	0	2000238	2000242	2000290	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_m()	-1	0
11817	100011817	105011817	3	2	6847	6573	0	270	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	2	-3	16	gam	101	205	2000243	0	0	0	2000238	2000242	2000290	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_m()	-1	0
11818	100011818	105011818	3	2	116870	57088	0	0	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	2	-3	16	gam	101	205	2000243	0	0	0	2000238	2000242	2000290	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_m()	-1	0
11819	100011819	105011819	3	2	221792	19911	0	225	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	2	-3	16	gam	101	205	2000243	0	0	0	2000238	2000242	2000290	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_m()	-1	0
11820	100011820	105011820	3	2	137537	105532	0	270	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	2	-3	16	gam	101	205	2000243	0	0	0	2000238	2000242	2000290	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_m()	-1	0
11821	100011821	105011821	3	1	152409	77118	0	270	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	0	-5	14	npc_gaf_common005	10105	10201	2000243	0	0	0	0	2589012	304301	0	306204	413100	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_f_1()	-1	0
11822	100011822	105011822	3	1	6690	6597	0	270	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	0	-5	14	npc_gaf_common005	10105	10201	2000243	0	0	0	0	2589012	304301	0	306204	413100	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_f_2()	-1	0
11823	100011823	105011823	3	1	116663	57286	0	180	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	-1	-4	14	npc_asf_common004	10106	10202	2000243	0	0	0	0	2589012	304301	0	306204	412100	423102	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_f_3()	-1	0
11824	100011824	105011824	3	1	221707	20017	0	225	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	-1	-4	14	npc_asf_common004	10106	10202	2000243	0	0	0	0	2589012	304301	0	306204	412100	423102	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_f_4()	-1	0
11825	100011825	105011825	3	1	137467	105428	0	180	-1	False	2012-09-06 08:00:00.000	2012-11-22 08:00:00.000	-1	-4	14	npc_asf_common004	10106	10202	2000243	0	0	0	0	2589012	304301	0	306204	412100	423102	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	NPC_event_2012_Xmas_f_5()	-1	0
2. You should find the shop NPCs in a lua file and in the lua file it will tell you the contact script of the shop that is being opened.

Then you edit everything under the shop contact in dbo.MarketResource.

3.This should narrow the search down for you a little bit...

Code:
select * from .dbo.ItemResource where icon_file_name like '%fairy%'
Code:
select * from .dbo.ItemResource where icon_file_name like '%lock%'
Or if you want to see most of the cash shop items...

Code:
select * from .dbo.ItemResource where icon_file_name like '%commerce%'
ThunderNikk is offline  
Thanks
1 User
Old   #3339
 
elite*gold: 0
Join Date: May 2011
Posts: 23
Received Thanks: 1
Thank you a lot for your help and support!
Still trying to figure this part out "I don't have the SQL written for these yet but you also have to set the local flag on the NPCs in dbo.NPCResource to get rid of them..." using the script hid most of the decorations.
Searched the database and found the bottle code, it is the same as the one in the server commands guide, but can't get a hold of it, it seems after I've restarted the server I can not use the #insert_item from the server console anymore.... I've heard of a query for that, but still am trying to do something with those npc's
Wir7- is offline  
Old   #3340
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,002
Received Thanks: 957
Code:
update arcadia.dbo.NPCResource set local_flag = -1 where contact_script like '%NPC_event_2012_Xmas%'
Use the chat window commands...

//item <item number> 1

Or

/run insert_item(Pet_Card_ID, ?, Stage, ?, "char_name")

/run insert_item(540001, 1, 0, 1, -2147483648, "CharacterName")
ThunderNikk is offline  
Old   #3341
 
elite*gold: 0
Join Date: Dec 2008
Posts: 39
Received Thanks: 48
hi,

need help, i already copied monster resource from 8.3 called "snowman" and "snowmanbigdaddy" and also added data into database. but, the monster doesnt appear in-game. only can see their name, but the model i cant see it . Please help .
malaysiawap is offline  
Old   #3342
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
looking for item_rdb to sql tool , raskim database manager 2013 not seems to work.
Mslolita is offline  
Old   #3343
 
elite*gold: 70
Join Date: Dec 2012
Posts: 276
Received Thanks: 155
Works but not for 8.3
can't really give you mine since I lost all my tools and Files couple of days ago sorry
But you still can try Glandu's one :
.BlackCat. is offline  
Thanks
1 User
Old   #3344
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
null
Mslolita is offline  
Old   #3345
 
elite*gold: 0
Join Date: May 2011
Posts: 23
Received Thanks: 1
Use the chat window commands...

//item <item number> 1

Or

/run insert_item(Pet_Card_ID, ?, Stage, ?, "char_name")

/run insert_item(540001, 1, 0, 1, -2147483648, "CharacterName")

Unfortunately none of them work for me oO #insert_item worked only serveral times and stoped, and my AllowedCommandsForPermission is empty, nothing is in there oO


Wir7- is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 13:20.


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

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