[DiscordArchive] Where can i see, in the database, what exact amount of health a creature has?
[DiscordArchive] Where can i see, in the database, what exact amount of health a creature has?
Original source
He has Entry 2784
rektbyfaith
02-23-2025, 08:58 PM #11Archived author: Remmo • Posted: 2025-02-23T20:58:57.136000+00:00
Original source
He has Entry 2784
Original source
If hes linked to somewhere over in creature_classlevelstats, what im i looking for over there?
rektbyfaith
02-23-2025, 08:59 PM #12Archived author: Remmo • Posted: 2025-02-23T20:59:59.734000+00:00
Original source
If hes linked to somewhere over in creature_classlevelstats, what im i looking for over there?
Original source
Gotta be some key identifier right
rektbyfaith
02-23-2025, 09:00 PM #13Archived author: Remmo • Posted: 2025-02-23T21:00:27.183000+00:00
Original source
Gotta be some key identifier right
Original source
```sql
SELECT basehp2 FROM acore_world.creature_classlevelstats WHERE LEVEL = 83 AND CLASS = 1
```
It will show 1 row. `13945`
rektbyfaith
02-23-2025, 09:01 PM #14Archived author: Ryan Turner • Posted: 2025-02-23T21:01:13.949000+00:00
Original source
```sql
SELECT basehp2 FROM acore_world.creature_classlevelstats WHERE LEVEL = 83 AND CLASS = 1
```
It will show 1 row. `13945`
Original source
That's the base value of ANY creature from exp 2 (wotlk) and class 1 (warrior)
rektbyfaith
02-23-2025, 09:01 PM #15Archived author: Ryan Turner • Posted: 2025-02-23T21:01:45.164000+00:00
Original source
That's the base value of ANY creature from exp 2 (wotlk) and class 1 (warrior)
Original source
Why level 83 and class 1 ?
rektbyfaith
02-23-2025, 09:01 PM #16Archived author: Remmo • Posted: 2025-02-23T21:01:56.273000+00:00
Original source
Why level 83 and class 1 ?
Original source
Magni has in his creature_template healthmodifier is `400`
rektbyfaith
02-23-2025, 09:02 PM #17Archived author: Ryan Turner • Posted: 2025-02-23T21:02:09.365000+00:00
Original source
Magni has in his creature_template healthmodifier is `400`
Original source
Is the information in creature_template
rektbyfaith
02-23-2025, 09:02 PM #18Archived author: Ryan Turner • Posted: 2025-02-23T21:02:15.272000+00:00
Original source
Is the information in creature_template
Original source
I dont see that. I dont even see that there is a Class column in creature_template.
rektbyfaith
02-23-2025, 09:03 PM #19Archived author: Remmo • Posted: 2025-02-23T21:03:26.499000+00:00
Original source
I dont see that. I dont even see that there is a Class column in creature_template.
Original source
And his healthmodifier is 300... but this is a repack based on Azerothcore so.....
rektbyfaith
02-23-2025, 09:04 PM #20Archived author: Remmo • Posted: 2025-02-23T21:04:09.658000+00:00
Original source
And his healthmodifier is 300... but this is a repack based on Azerothcore so.....
1 Guest(s)
1 Guest(s)