[DiscordArchive] I see that creature(29712) has waypoint(1206130) but can't understand how this wapoint (1206130) fro
[DiscordArchive] I see that creature(29712) has waypoint(1206130) but can't understand how this wapoint (1206130) fro
Original source
I see that creature(29712) has waypoint(1206130) but can't understand how this wapoint (1206130) from waypoint_data table:
```sql
SELECT * FROM acore_world.waypoint_data where id = 1206130;
'1206130', '1', '-8456.49', '1033.04', '59.47', NULL, '0', '0', '0', '100', '0'
'1206130', '2', '-8464.14', '1029.03', '59.49', NULL, '0', '0', '0', '100', '0'
'1206130', '3', '-8483.15', '1027.79', '59.72', NULL, '1000', '0', '0', '100', '0'
'1206130', '4', '-8464.14', '1029.03', '59.49', NULL, '0', '0', '0', '100', '0'
...
```
connected with creature(29712) from creature_template table:
```sql
'29712', '0', '0', '0', '0', '0', '3167', '5446', '0', '0', 'Stormwind Harbor Guard', '', 'Directions', '435', '65', '65', '1', '11', '1', '1', '1.42857', '1', '1', '20', '1', '0', '0', '1', '2000', '2000', '1', '1', '1', '32768', '2048', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '1', '2', '1', '1', '1', '0', '144', '1', '0', '0', '65536', '', '12340'
```
there are no mentions about foreign keys. How then this creature knows what waypoints to use?
rektbyfaith
11-19-2023, 11:48 AM #1Archived author: Blocker • Posted: 2023-11-19T11:48:07.439000+00:00
Original source
I see that creature(29712) has waypoint(1206130) but can't understand how this wapoint (1206130) from waypoint_data table:
```sql
SELECT * FROM acore_world.waypoint_data where id = 1206130;
'1206130', '1', '-8456.49', '1033.04', '59.47', NULL, '0', '0', '0', '100', '0'
'1206130', '2', '-8464.14', '1029.03', '59.49', NULL, '0', '0', '0', '100', '0'
'1206130', '3', '-8483.15', '1027.79', '59.72', NULL, '1000', '0', '0', '100', '0'
'1206130', '4', '-8464.14', '1029.03', '59.49', NULL, '0', '0', '0', '100', '0'
...
```
connected with creature(29712) from creature_template table:
```sql
'29712', '0', '0', '0', '0', '0', '3167', '5446', '0', '0', 'Stormwind Harbor Guard', '', 'Directions', '435', '65', '65', '1', '11', '1', '1', '1.42857', '1', '1', '20', '1', '0', '0', '1', '2000', '2000', '1', '1', '1', '32768', '2048', '0', '0', '0', '0', '0', '0', '7', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '1', '2', '1', '1', '1', '0', '144', '1', '0', '0', '65536', '', '12340'
```
there are no mentions about foreign keys. How then this creature knows what waypoints to use?
Original source
```sql
SELECT guid, path_id FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id1 = 29712 AND movementtype = 2)
```
rektbyfaith
11-19-2023, 12:03 PM #2Archived author: Kitzunu • Posted: 2023-11-19T12:03:14.145000+00:00
Original source
```sql
SELECT guid, path_id FROM creature_addon WHERE guid IN (SELECT guid FROM creature WHERE id1 = 29712 AND movementtype = 2)
```
Original source
<@464059448789434368>
rektbyfaith
11-19-2023, 12:06 PM #3Archived author: Kitzunu • Posted: 2023-11-19T12:06:06.872000+00:00
Original source
<@464059448789434368>
Original source
but creature is something what exist in game constantly, right? What if in BG I want creature to move, it's not possible? In Alterac Valley for example
rektbyfaith
11-19-2023, 01:44 PM #4Archived author: Blocker • Posted: 2023-11-19T13:44:02.393000+00:00
Original source
but creature is something what exist in game constantly, right? What if in BG I want creature to move, it's not possible? In Alterac Valley for example
Original source
they are also spawned always
rektbyfaith
11-19-2023, 02:10 PM #5Archived author: Kitzunu • Posted: 2023-11-19T14:10:27.938000+00:00
Original source
they are also spawned always
Original source
do I understand correctly, if I want to add waypoints to BG creature, then I update following tables: waypoint_data(to add path), creature_template(if another npc is needed), creature_addon + creature(to connect path with creature)?
rektbyfaith
11-19-2023, 02:16 PM #6Archived author: Blocker • Posted: 2023-11-19T14:16:11.649000+00:00
Original source
do I understand correctly, if I want to add waypoints to BG creature, then I update following tables: waypoint_data(to add path), creature_template(if another npc is needed), creature_addon + creature(to connect path with creature)?
Original source
The guid in the gameobject table can be entered arbitrarily, as long as it is not repeated？
rektbyfaith
11-19-2023, 02:16 PM #7Archived author: 老爷爷 • Posted: 2023-11-19T14:16:48.223000+00:00
Original source
The guid in the gameobject table can be entered arbitrarily, as long as it is not repeated？
Original source
sure
rektbyfaith
11-19-2023, 02:20 PM #8Archived author: Kitzunu • Posted: 2023-11-19T14:20:39.846000+00:00
Original source
sure
Original source
GUID is unique
rektbyfaith
11-19-2023, 02:20 PM #9Archived author: Kitzunu • Posted: 2023-11-19T14:20:48.453000+00:00
Original source
GUID is unique
Original source
Is it okay to have any value that is the only one that doesn't repeat？
rektbyfaith
11-19-2023, 02:23 PM #10Archived author: 老爷爷 • Posted: 2023-11-19T14:23:20.518000+00:00
Original source
Is it okay to have any value that is the only one that doesn't repeat？