[Help Thread] Please post your questions here.

[Phouria]

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.

[Domesday Brock]

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

[ThunderNikk]

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...

[Domesday Brock]

Originally Posted by thndr

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

[mongreldogg]

Originally Posted by Domesday Brock

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.

[Wir7-]

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

[ThunderNikk]

1. How to turn off the Christmas event and decorations...

Turns it on

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

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...

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...

select * from .dbo.ItemResource where icon_file_name like '%fairy%'

select * from .dbo.ItemResource where icon_file_name like '%lock%'

Or if you want to see most of the cash shop items...

select * from .dbo.ItemResource where icon_file_name like '%commerce%'

[Wir7-]

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

[ThunderNikk]

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")

[malaysiawap]

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 .

[Mslolita]

looking for item_rdb to sql tool , raskim database manager 2013 not seems to work.

[.BlackCat.]

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 :

[Mslolita]

null

[Wir7-]

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

[ThunderNikk]

The commands I gave you will work in the chat window if the character you are using them on has their permission level set to GM level at permission 100 (1 for older epics)