[DiscordArchive] How are you querying for the creatures in that map?
[DiscordArchive] How are you querying for the creatures in that map?
Original source
How are you querying for the creatures in that map?
rektbyfaith
03-02-2023, 03:16 AM #1Archived author: HelloKitty • Posted: 2023-03-02T03:16:36.847000+00:00
Original source
How are you querying for the creatures in that map?
Original source
Yup
rektbyfaith
03-02-2023, 03:18 AM #2Archived author: Saty • Posted: 2023-03-02T03:18:58.749000+00:00
Original source
Yup
Original source
Oh my dumb brain just ignored the "How" xD
`SELECT * FROM creature WHERE map = @Map AND position_y BETWEEN @MinY AND @MaxY AND position_x BETWEEN @MinX AND @MaxX`
rektbyfaith
03-02-2023, 03:24 AM #3Archived author: Saty • Posted: 2023-03-02T03:24:38.403000+00:00
Original source
Oh my dumb brain just ignored the "How" xD
`SELECT * FROM creature WHERE map = @Map AND position_y BETWEEN @MinY AND @MaxY AND position_x BETWEEN @MinX AND @MaxX`
Original source
I see I guess that would work assuming the Min/Max coords are correct. What are your inputs? When working on a new client from scratch in Unity3D I found that I had to often translate coordinates to and from WoW coordinates. Maybe your issue is something like that? Because I don't see any Arena Organizer that close to Goldshire. I checked them with: ```SELECT * FROM world.creature WHERE map = 0 AND id = 26012;```
rektbyfaith
03-02-2023, 03:29 AM #4Archived author: HelloKitty • Posted: 2023-03-02T03:29:07.481000+00:00
Original source
I see I guess that would work assuming the Min/Max coords are correct. What are your inputs? When working on a new client from scratch in Unity3D I found that I had to often translate coordinates to and from WoW coordinates. Maybe your issue is something like that? Because I don't see any Arena Organizer that close to Goldshire. I checked them with: ```SELECT * FROM world.creature WHERE map = 0 AND id = 26012;```
Original source
The coordinates are correct, I checked... and the positioning around the corner also seems to be way to perfect to just be "random data"
![[Image: Unity_VVaeRnw5zv.png?ex=690c169d&is=690a...3412af9f2&]](https://cdn.discordapp.com/attachments/870722120458600528/1080693889058488351/Unity_VVaeRnw5zv.png?ex=690c169d&is=690ac51d&hm=dad64297de01636d05a8d28b11b8e7cec42d2a7c36c46f46aaa4f513412af9f2&)
rektbyfaith
03-02-2023, 03:31 AM #5Archived author: Saty • Posted: 2023-03-02T03:31:41.585000+00:00
Original source
The coordinates are correct, I checked... and the positioning around the corner also seems to be way to perfect to just be "random data"
Original source
rektbyfaith
03-02-2023, 03:32 AM #6Archived author: HelloKitty • Posted: 2023-03-02T03:32:38.946000+00:00
Original source
Original source
Ok maybe I see now
rektbyfaith
03-02-2023, 03:32 AM #7Archived author: HelloKitty • Posted: 2023-03-02T03:32:41.115000+00:00
Original source
Ok maybe I see now
Original source
It looks like those repacks with Goblins standing around as vendors in a city.
rektbyfaith
03-02-2023, 03:32 AM #8Archived author: HelloKitty • Posted: 2023-03-02T03:32:50.241000+00:00
Original source
It looks like those repacks with Goblins standing around as vendors in a city.
Original source
Are you using a 3.3.5 TC DB?
rektbyfaith
03-02-2023, 03:32 AM #9Archived author: HelloKitty • Posted: 2023-03-02T03:32:58.197000+00:00
Original source
Are you using a 3.3.5 TC DB?
Original source
Yeah, but its the TC DB
rektbyfaith
03-02-2023, 03:33 AM #10Archived author: Saty • Posted: 2023-03-02T03:33:03.590000+00:00
Original source
Yeah, but its the TC DB