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.
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
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
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...
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
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 .
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
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)
[Helping Topic] 24/7 Helping Services! 08/27/2008 - EO PServer Hosting - 31 Replies 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 :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
![[Help Thread] Please post your questions here.](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-thread-please-post-your-questions-here_ltr.gif){kind=small}
)
