[Help Thread] Please post your questions here.

Page 231 of 586

231

04/21/2014 00:02 diablo56140#3451

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

04/21/2014 18:39 ffenril#3452

do you have lua for noob book pleas xd

04/21/2014 20:54 eziorav#3453

Quote:

Originally Posted by ffenril

do you have lua for noob book pleas xd

[Only registered and activated users can see links. Click Here To Register...]

04/22/2014 23:17 thund22222#3454

NULL.

04/22/2014 23:50 ThunderNikk#3455

Try the Client Creator release...

[Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]

04/23/2014 17:48 ffenril#3456

where i find npc_id please

04/23/2014 18:02 ThunderNikk#3457

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.

04/23/2014 18:46 ffenril#3458

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

04/23/2014 19:41 eziorav#3459

Quote:

Originally Posted by ffenril

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

Code:

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

04/23/2014 20:01 ThunderNikk#3460

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.

04/23/2014 22:50 ffenril#3461

this is my npc_dungeon lua

[Only registered and activated users can see links. Click Here To Register...]

04/23/2014 22:54 ThunderNikk#3462

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?

04/23/2014 23:15 ffenril#3463

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

04/23/2014 23:43 ThunderNikk#3464

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.

04/23/2014 23:58 ffenril#3465

i just found in etc_dungeon_prop to teleport in dungeon

Page 231 of 586

231