[DiscordArchive] i dont need to "save" the db do i?
[DiscordArchive] i dont need to "save" the db do i?
Archived author: Kristodian • Posted: 2024-04-26T13:01:49.889000+00:00
Original source
probably got killed by my roaming bots
Archived author: Revision • Posted: 2024-04-26T13:01:55.891000+00:00
Original source
I would say so, yes
Archived author: Kristodian • Posted: 2024-04-26T13:01:57.934000+00:00
Original source
and 5h to respawn
Archived author: Kristodian • Posted: 2024-04-26T13:02:05.436000+00:00
Original source
meaning i need to edit rares respawn times
Archived author: Revision • Posted: 2024-04-26T13:02:27.364000+00:00
Original source
the respawnTime there is in unix timestamp btw so if you ever want to you can use https://www.epochconverter.com/ to convert it
Archived author: Kristodian • Posted: 2024-04-26T13:02:31.053000+00:00
Original source
so following question . can i single out only the rares in DB so i can export their respawn timers and edit?
Archived author: Kristodian • Posted: 2024-04-26T13:03:03.966000+00:00
Original source
since i dont know who are the mobs behind the IDs
Archived author: Kristodian • Posted: 2024-04-26T13:03:17.769000+00:00
Original source
do rares have any speacial markings?
Archived author: Kristodian • Posted: 2024-04-26T13:03:25.528000+00:00
Original source
in db that is
Archived author: Revision • Posted: 2024-04-26T13:03:37.355000+00:00
Original source
```sql
SELECT * FROM `creature` WHERE `id1` IN (SELECT `entry` FROM `creature_template` WHERE `rank` IN (2, 4));
```
This would list **all** rare spawns