[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:20:53.226000+00:00
Original source
when i shift click i do see some sort of selection but it selsects rows instead , but in any case the only pasted data if from the last cell i shift clicked on
![[Image: image.png?ex=690bf80d&is=690aa68d&hm=23c...de4ac7356&]](https://cdn.discordapp.com/attachments/284406375495368704/1233407559784730634/image.png?ex=690bf80d&is=690aa68d&hm=23c9aa31d4f0c2f5debcf287472cab0c68c92326f6b9f7a4334fb2fde4ac7356&)
Archived author: Kristodian • Posted: 2024-04-26T13:21:17.915000+00:00
Original source
![[Image: image.png?ex=690bf80d&is=690aa68d&hm=23c...de4ac7356&]](https://cdn.discordapp.com/attachments/284406375495368704/1233407559784730634/image.png?ex=690bf80d&is=690aa68d&hm=23c9aa31d4f0c2f5debcf287472cab0c68c92326f6b9f7a4334fb2fde4ac7356&)
Archived author: Revision • Posted: 2024-04-26T13:21:27.003000+00:00
Original source
For instance, this would cut the respawn time in half:
```sql
UPDATE `creature` SET `spawntimesecs`=`spawntimesecs`/2 WHERE `id1` IN (SELECT `entry` FROM `creature_template` WHERE `rank` IN (2, 4));
```
while this would double it:
```sql
UPDATE `creature` SET `spawntimesecs`=`spawntimesecs`*2 WHERE `id1` IN (SELECT `entry` FROM `creature_template` WHERE `rank` IN (2, 4));
```
The drawback is you can't run it multiple times in a row or it would do it over and over again.
Archived author: Kristodian • Posted: 2024-04-26T13:21:38.783000+00:00
Original source
it look at this keira for now
Archived author: Kristodian • Posted: 2024-04-26T13:22:05.166000+00:00
Original source
hmm...
Archived author: Kristodian • Posted: 2024-04-26T13:22:12.744000+00:00
Original source
this might work
Archived author: Kristodian • Posted: 2024-04-26T13:22:33.042000+00:00
Original source
but for an example i dont want to cut times for mobs who already have less then 10 min respawn time
Archived author: Rymercyble • Posted: 2024-04-26T13:22:52.846000+00:00
Original source
u can do anything u want its just programming....it just makes it more complicated
Archived author: Kristodian • Posted: 2024-04-26T13:23:17.013000+00:00
Original source
if id knew this stuff i would not spam this chat here lol
Archived author: Kristodian • Posted: 2024-04-26T13:23:52.558000+00:00
Original source
what programming language is this