[DiscordArchive] I trying to find where supply crates is located on game map (like x/y/z coordinates). How can I do
[DiscordArchive] I trying to find where supply crates is located on game map (like x/y/z coordinates). How can I do
Original source
I trying to find where supply crates is located on game map (like x/y/z coordinates). How can I do it in a proper way?
![[Image: unknown.png?ex=690bdd1d&is=690a8b9d&hm=d...0990f0b1e&]](https://cdn.discordapp.com/attachments/284406375495368704/999457266476531732/unknown.png?ex=690bdd1d&is=690a8b9d&hm=d1c5e89744d780fb6376cbb396447a0ddb3ac63768c1a52b31cca550990f0b1e&)
rektbyfaith
07-20-2022, 11:26 PM #1Archived author: Everjunior • Posted: 2022-07-20T23:26:21.524000+00:00
Original source
I trying to find where supply crates is located on game map (like x/y/z coordinates). How can I do it in a proper way?
Original source
how can I find it in gameobject table ?
![[Image: unknown.png?ex=690bdda4&is=690a8c24&hm=4...b800cdfbd&]](https://cdn.discordapp.com/attachments/284406375495368704/999457834938945536/unknown.png?ex=690bdda4&is=690a8c24&hm=40889820b809873bf802f8b745bd643914eca2187adde9721231939b800cdfbd&)
rektbyfaith
07-20-2022, 11:28 PM #2Archived author: Everjunior • Posted: 2022-07-20T23:28:37.089000+00:00
Original source
how can I find it in gameobject table ?
Original source
You are needing a query like this:
`SELECT guid, id, map, position_x, position_y, position_z FROM gameobject WHERE id IN (SELECT entry FROM gameobject_template WHERE NAME LIKE '%crate%');`
rektbyfaith
07-20-2022, 11:29 PM #3Archived author: 郑佩茹 • Posted: 2022-07-20T23:29:46.398000+00:00
Original source
You are needing a query like this:
`SELECT guid, id, map, position_x, position_y, position_z FROM gameobject WHERE id IN (SELECT entry FROM gameobject_template WHERE NAME LIKE '%crate%');`
Original source
is it right ?
![[Image: unknown.png?ex=690bdef2&is=690a8d72&hm=e...f053778d8&]](https://cdn.discordapp.com/attachments/284406375495368704/999459233508642866/unknown.png?ex=690bdef2&is=690a8d72&hm=efdafff520ba45ae6c08990bc80973c669135e4e671294cbf7591b8f053778d8&)
![[Image: unknown.png?ex=690bdef2&is=690a8d72&hm=5...99dbd5e8d&]](https://cdn.discordapp.com/attachments/284406375495368704/999459233823207464/unknown.png?ex=690bdef2&is=690a8d72&hm=552ebe529133e11997b48514da40663fa0b350bafee9607d1c9ca7899dbd5e8d&)
rektbyfaith
07-20-2022, 11:34 PM #4Archived author: Everjunior • Posted: 2022-07-20T23:34:10.760000+00:00
Original source
is it right ?
Original source
![[Image: unknown.png?ex=690bdf26&is=690a8da6&hm=b...30343e69e&]](https://cdn.discordapp.com/attachments/284406375495368704/999459452036067328/unknown.png?ex=690bdf26&is=690a8da6&hm=b176c9f59390817952102605cd7527a22255b17398a92a27e819dde30343e69e&)
rektbyfaith
07-20-2022, 11:35 PM #5Archived author: Everjunior • Posted: 2022-07-20T23:35:02.593000+00:00
Original source
Original source
I think i'm doing it in a wrong way
rektbyfaith
07-20-2022, 11:43 PM #6Archived author: Everjunior • Posted: 2022-07-20T23:43:18.512000+00:00
Original source
I think i'm doing it in a wrong way
Original source
I can't see what software you are using to see the database, but it looks like it has "Query" tab or menu. You will need to paste that Query there instead of as a filter.
rektbyfaith
07-21-2022, 12:05 AM #7Archived author: 郑佩茹 • Posted: 2022-07-21T00:05:19.316000+00:00
Original source
I can't see what software you are using to see the database, but it looks like it has "Query" tab or menu. You will need to paste that Query there instead of as a filter.
Original source
guess i found the solution but now i have a question why i dont have any strings in AreaTable.dbc.
![[Image: unknown.png?ex=690be6a9&is=690a9529&hm=2...698e21cf3&]](https://cdn.discordapp.com/attachments/284406375495368704/999467518768980068/unknown.png?ex=690be6a9&is=690a9529&hm=2d8c41a98f0e074da0f8131ad909e7e7cf219d8c7e2f7c05dc258ee698e21cf3&)
rektbyfaith
07-21-2022, 12:07 AM #8Archived author: Everjunior • Posted: 2022-07-21T00:07:05.864000+00:00
Original source
guess i found the solution but now i have a question why i dont have any strings in AreaTable.dbc.
Original source
dbc data is loaded from dbc files extracted from the client. The dbc tables in the DB are only used for server-side overwrites, which is usually not needed.
rektbyfaith
07-21-2022, 12:08 AM #9Archived author: 郑佩茹 • Posted: 2022-07-21T00:08:04.984000+00:00
Original source
dbc data is loaded from dbc files extracted from the client. The dbc tables in the DB are only used for server-side overwrites, which is usually not needed.
Original source
so, i guess i can find it in RelWithDebInfo\Data\dbc folder
rektbyfaith
07-21-2022, 12:10 AM #10Archived author: Everjunior • Posted: 2022-07-21T00:10:42.539000+00:00
Original source
so, i guess i can find it in RelWithDebInfo\Data\dbc folder