[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
```sql
SELECT minlevel, maxlevel, EXP, unit_class, HealthModifier FROM creature_template WHERE `entry` = 2784
```
Run the query above, updated
rektbyfaith
02-23-2025, 09:04 PM #21Archived author: Ryan Turner • Posted: 2025-02-23T21:04:09.756000+00:00
Original source
```sql
SELECT minlevel, maxlevel, EXP, unit_class, HealthModifier FROM creature_template WHERE `entry` = 2784
```
Run the query above, updated
Original source
Ah unitclass, gotcha. See it now
rektbyfaith
02-23-2025, 09:04 PM #22Archived author: Remmo • Posted: 2025-02-23T21:04:38.938000+00:00
Original source
Ah unitclass, gotcha. See it now
Original source
400 * 13945 = 5'578'000
rektbyfaith
02-23-2025, 09:05 PM #23Archived author: Ryan Turner • Posted: 2025-02-23T21:05:05.728000+00:00
Original source
400 * 13945 = 5'578'000
Original source
Why level 83 though? Is he not level 63?
rektbyfaith
02-23-2025, 09:05 PM #24Archived author: Remmo • Posted: 2025-02-23T21:05:09.666000+00:00
Original source
Why level 83 though? Is he not level 63?
Original source
I added the levels in the query he's 83
rektbyfaith
02-23-2025, 09:05 PM #25Archived author: Ryan Turner • Posted: 2025-02-23T21:05:50.842000+00:00
Original source
I added the levels in the query he's 83
Original source
Also we don't support or endorse repacks, we always recommend in compiling your own core
rektbyfaith
02-23-2025, 09:06 PM #26Archived author: Ryan Turner • Posted: 2025-02-23T21:06:28.813000+00:00
Original source
Also we don't support or endorse repacks, we always recommend in compiling your own core
Original source
![[Image: image.png?ex=690c6544&is=690b13c4&hm=aff...848d6ced2&]](https://cdn.discordapp.com/attachments/1255602330431127753/1343328349279355022/image.png?ex=690c6544&is=690b13c4&hm=afff37117d6dfcd7e97d8b0d5aebffc951ddd496c2c5b17485dd407848d6ced2&)
![[Image: image.png?ex=690c6544&is=690b13c4&hm=6b4...10c442e22&]](https://cdn.discordapp.com/attachments/1255602330431127753/1343328349627617362/image.png?ex=690c6544&is=690b13c4&hm=6b4b9df070e50927280d9751657f999588b412044c5307d8c20283410c442e22&)
rektbyfaith
02-23-2025, 09:07 PM #27Archived author: Ryan Turner • Posted: 2025-02-23T21:07:16.441000+00:00
Original source
Original source
Ok. Thats fine, but that will never happen Im only looking to learn some stuff in this database. Ok... So if a creature has level 60, and his class is 1, i know where to find him now in creature_classlevelstats. Can you explain to me, where there is 3 x basehp columns?
rektbyfaith
02-23-2025, 09:07 PM #28Archived author: Remmo • Posted: 2025-02-23T21:07:39.490000+00:00
Original source
Ok. Thats fine, but that will never happen Im only looking to learn some stuff in this database. Ok... So if a creature has level 60, and his class is 1, i know where to find him now in creature_classlevelstats. Can you explain to me, where there is 3 x basehp columns?
Original source
Everytime I see *repack* I die a little
rektbyfaith
02-23-2025, 09:08 PM #29Archived author: Kitzunu • Posted: 2025-02-23T21:08:11.050000+00:00
Original source
Everytime I see *repack* I die a little
Original source
Not today man! Not today!
rektbyfaith
02-23-2025, 09:08 PM #30Archived author: Remmo • Posted: 2025-02-23T21:08:31.130000+00:00
Original source
Not today man! Not today!
1 Guest(s)
1 Guest(s)