[DiscordArchive] there are 65 displayed with a 2 hour respawn. How do I change them to 15 min?
[DiscordArchive] there are 65 displayed with a 2 hour respawn. How do I change them to 15 min?
Original source
there are 65 displayed with a 2 hour respawn. How do I change them to 15 min?
rektbyfaith
01-04-2025, 06:11 PM #1Archived author: Fixitman • Posted: 2025-01-04T18:11:16.647000+00:00
Original source
there are 65 displayed with a 2 hour respawn. How do I change them to 15 min?
Original source
reduce the spawntimesecs to 15*60
rektbyfaith
01-04-2025, 06:11 PM #2Archived author: sudlud • Posted: 2025-01-04T18:11:38.289000+00:00
Original source
reduce the spawntimesecs to 15*60
Original source
key for gameobject table is guid and id1
rektbyfaith
01-04-2025, 06:13 PM #3Archived author: sudlud • Posted: 2025-01-04T18:13:33.203000+00:00
Original source
key for gameobject table is guid and id1
Original source
or just by guid
rektbyfaith
01-04-2025, 06:13 PM #4Archived author: sudlud • Posted: 2025-01-04T18:13:38.027000+00:00
Original source
or just by guid
Original source
do I have to edit each one individually, or can I change the original query to change all at one time?
rektbyfaith
01-04-2025, 06:14 PM #5Archived author: Fixitman • Posted: 2025-01-04T18:14:38.040000+00:00
Original source
do I have to edit each one individually, or can I change the original query to change all at one time?
Original source
Well if the same object is spawned in multiple places it makes sense to just update the id (it doesn't have multiple ids so there's no id1, id2 etc) rather than find and add all guids
rektbyfaith
01-04-2025, 06:14 PM #6Archived author: Revision • Posted: 2025-01-04T18:14:59.637000+00:00
Original source
Well if the same object is spawned in multiple places it makes sense to just update the id (it doesn't have multiple ids so there's no id1, id2 etc) rather than find and add all guids
Original source
something like
rektbyfaith
01-04-2025, 06:15 PM #7Archived author: sudlud • Posted: 2025-01-04T18:15:25.149000+00:00
Original source
something like
Original source
```sql
UPDATE `gameobject` SET `spawntimesecs` = (15*60) WHERE `id` IN (...);
``` or```sql
UPDATE `gameobject` SET `spawntimesecs` = (15*60) WHERE `guid` IN (...);
```
rektbyfaith
01-04-2025, 06:15 PM #8Archived author: sudlud • Posted: 2025-01-04T18:15:41.151000+00:00
Original source
```sql
UPDATE `gameobject` SET `spawntimesecs` = (15*60) WHERE `id` IN (...);
``` or```sql
UPDATE `gameobject` SET `spawntimesecs` = (15*60) WHERE `guid` IN (...);
```
Original source
`id`, not `id1`
rektbyfaith
01-04-2025, 06:16 PM #9Archived author: Revision • Posted: 2025-01-04T18:16:27.539000+00:00
Original source
`id`, not `id1`
Original source
true
rektbyfaith
01-04-2025, 06:16 PM #10Archived author: sudlud • Posted: 2025-01-04T18:16:30.649000+00:00
Original source
true
1 Guest(s)
1 Guest(s)