[Help Thread] Please post your questions here.

[diablo56140]

Bonsoir voila j'ai un soucie j'arrive pas a faire un Monster ressource rdb et j'arrive pas a faire un item Resource rdb serait t'il possible de me dire comment faire svp

[ffenril]

do you have lua for noob book pleas xd

[eziorav]

Originally Posted by ffenril

do you have lua for noob book pleas xd

[thund22222]

NULL.

[ThunderNikk]

Try the Client Creator release...



Sounds like that is what you are looking for, either that or glandu2's release for the data unpack /pack...

[ffenril]

where i find npc_id please

[ThunderNikk]

First column in dbo.NPCResource.

Go to the NPC you are looking for in game and type a little command in the chat box...

/position

It will return your x , y coordinates.

Type a little SQL query to find which NPC is listed in the dbo.NPCResource at those coordinates.

[ffenril]

ok nothing in my dbo.NPCResource in coordinates x 132814, y 86968 for moon 1 portal

[eziorav]

Originally Posted by ffenril

ok nothing in my dbo.NPCResource in coordinates x 132814, y 86968 for moon 1 portal

DECLARE @charname NVARCHAR(55)
SET @charname = 'Enter your char name'
declare @radius int 
set @radius = 30 --change radius for long or short search range 
--do not edit anything here :) --
---------------------------------
---------------------------------
-- by Eziorav/MasterX1-----------

select char.name  , npcres.id as near_npc_id, STRINGRES.value as npc_name , npcres.x, npcres.y
 from arcadia.dbo.NPCResource NPCRES
 INNER JOIN arcadia.dbo.StringResource STRINGRES
on STRINGRES.code = NPCRES.name_text_id
 INNER JOIN Telecaster.dbo.Character CHAR
 on CHAR.name = @charname
WHERE npcres.x between CHAR.x -@radius and CHAR.x +@radius and  NPCRES.y between CHAR.y -@radius and CHAR.y +@radius

this is a little query codded by me to help auto you find npc_id

[ThunderNikk]

LOL I guess I needed to mention unless he was dating the NPC there was going to need to be a little range value coded into the query.

To funny.

[ffenril]

this is my npc_dungeon lua

[ThunderNikk]

Why are you posting that? It has nothing to do with your previous issue not being able to enter through a portal which is a dungeon prop not an NPC.

So if you still are chasing the same issue, what is keeping you from asking in the release thread?

[ffenril]

because in this lua they are "npc_dungeon_teleport_in_contact" or this lua is just for dungeon siege ??

[ThunderNikk]

Dungeon portals are a warp prop...they are not an NPC.

You really need to start talking with other people who are running the 5.2 files, that is why I keep suggesting that you start using the release thread.

[ffenril]

i just found in etc_dungeon_prop to teleport in dungeon