[DiscordArchive] In AC (TC may be very similar here) is there a ...
[DiscordArchive] In AC (TC may be very similar here) is there a ...
Original source
rektbyfaith
11-03-2024, 08:38 PM #1Archived author: Needle • Posted: 2024-11-03T20:38:25.657000+00:00
Original source
Original source
Thread automatically created by Mew in <#415944535718494208>
rektbyfaith
11-03-2024, 08:38 PM #2Archived author: Needle • Posted: 2024-11-03T20:38:26.355000+00:00
Original source
Thread automatically created by Mew in <#415944535718494208>
Original source
```sql
SELECT creature_addon.path_id, creature.map, creature_template.name
FROM creature_addon
INNER JOIN creature ON creature_addon.guid = creature.guid
INNER JOIN creature_template ON creature.id1 = creature_template.entry
WHERE creature_addon.path_id > 0 AND creature.map = 1;
```
give this a try
rektbyfaith
11-03-2024, 09:32 PM #3Archived author: Degen • Posted: 2024-11-03T21:32:08.350000+00:00
Original source
```sql
SELECT creature_addon.path_id, creature.map, creature_template.name
FROM creature_addon
INNER JOIN creature ON creature_addon.guid = creature.guid
INNER JOIN creature_template ON creature.id1 = creature_template.entry
WHERE creature_addon.path_id > 0 AND creature.map = 1;
```
give this a try
Original source
Thank You
rektbyfaith
11-03-2024, 10:16 PM #4Archived author: Go'Vic.Ϻέψ • Posted: 2024-11-03T22:16:09.498000+00:00
Original source
Thank You
Original source
```sql
SET @map_id = 530;
SET @positionx_min = 3750;
SET @positionx_max = 11460;
SET @positiony_min = -8500;
SET @positiony_max = -3200;
SELECT wd.*
FROM waypoint_data wd
WHERE
wd.position_x BETWEEN @positionx_min AND @positionx_max AND
wd.position_y BETWEEN @positiony_min AND @positiony_max AND
EXISTS (
SELECT 1
FROM creature_addon
INNER JOIN creature ON creature_addon.guid = creature.guid
INNER JOIN creature_template ON creature.id1 = creature_template.entry
WHERE creature_addon.path_id > 0 AND creature.map = @map_id
AND creature_addon.path_id = wd.id
);
```
rektbyfaith
11-03-2024, 10:40 PM #5Archived author: Go'Vic.Ϻέψ • Posted: 2024-11-03T22:40:55.022000+00:00
Original source
```sql
SET @map_id = 530;
SET @positionx_min = 3750;
SET @positionx_max = 11460;
SET @positiony_min = -8500;
SET @positiony_max = -3200;
SELECT wd.*
FROM waypoint_data wd
WHERE
wd.position_x BETWEEN @positionx_min AND @positionx_max AND
wd.position_y BETWEEN @positiony_min AND @positiony_max AND
EXISTS (
SELECT 1
FROM creature_addon
INNER JOIN creature ON creature_addon.guid = creature.guid
INNER JOIN creature_template ON creature.id1 = creature_template.entry
WHERE creature_addon.path_id > 0 AND creature.map = @map_id
AND creature_addon.path_id = wd.id
);
```
Original source
Does this extension of your code seem correct to return those waypoints on map id 530?
rektbyfaith
11-03-2024, 10:41 PM #6Archived author: Go'Vic.Ϻέψ • Posted: 2024-11-03T22:41:22.130000+00:00
Original source
Does this extension of your code seem correct to return those waypoints on map id 530?
Original source
Yea looks like that works
rektbyfaith
11-03-2024, 10:49 PM #7Archived author: Degen • Posted: 2024-11-03T22:49:50.453000+00:00
Original source
Yea looks like that works
Original source
what data are you after?
rektbyfaith
11-03-2024, 10:52 PM #8Archived author: Degen • Posted: 2024-11-03T22:52:06.168000+00:00
Original source
what data are you after?
Original source
id do it like this so you can see some info about the creature
```sql
SET @map_id = 530;
SET @positionx_min = 3750;
SET @positionx_max = 11460;
SET @positiony_min = -8500;
SET @positiony_max = -3200;
SELECT wd.*, cr.map Map, ct.name Creature, cr.guid CreatureGUID
FROM waypoint_data wd
INNER JOIN creature_addon ca ON wd.id = ca.path_id
INNER JOIN creature cr ON ca.guid = cr.guid
INNER JOIN creature_template ct ON cr.id1 = ct.entry
WHERE wd.position_x BETWEEN @positionx_min AND @positionx_max
AND wd.position_y BETWEEN @positiony_min AND @positiony_max
AND ca.path_id > 0 AND cr.map = @map_id;
```
rektbyfaith
11-03-2024, 11:00 PM #9Archived author: Degen • Posted: 2024-11-03T23:00:15.445000+00:00
Original source
id do it like this so you can see some info about the creature
```sql
SET @map_id = 530;
SET @positionx_min = 3750;
SET @positionx_max = 11460;
SET @positiony_min = -8500;
SET @positiony_max = -3200;
SELECT wd.*, cr.map Map, ct.name Creature, cr.guid CreatureGUID
FROM waypoint_data wd
INNER JOIN creature_addon ca ON wd.id = ca.path_id
INNER JOIN creature cr ON ca.guid = cr.guid
INNER JOIN creature_template ct ON cr.id1 = ct.entry
WHERE wd.position_x BETWEEN @positionx_min AND @positionx_max
AND wd.position_y BETWEEN @positiony_min AND @positiony_max
AND ca.path_id > 0 AND cr.map = @map_id;
```
Original source
Thanks,
I'm trying to locate all the waypoints on Quelthalas so I can update their coordinates
rektbyfaith
11-03-2024, 11:30 PM #10Archived author: Go'Vic.Ϻέψ • Posted: 2024-11-03T23:30:22.300000+00:00
Original source
Thanks,
I'm trying to locate all the waypoints on Quelthalas so I can update their coordinates
1 Guest(s)
1 Guest(s)