[DiscordArchive] https://discord.com/channels/217589275766685707/805053246502076436/887289271126462465
[DiscordArchive] https://discord.com/channels/217589275766685707/805053246502076436/887289271126462465
Archived author: Cold • Posted: 2021-09-14T10:54:09.695000+00:00
Original source
https://discord.com/channels/21758927576...1126462465
My first ever PR, any feedback would be greatly appreciated.
Maybe a stupid question, I did some random changes to random creatures to test out how things work. Obviously I need a new database now with everything back to normal. Do I need to make a new build, or is it possible to get a new database copy-pasta'd easily somewhere?
Archived author: Asthalor • Posted: 2021-09-14T10:57:16.246000+00:00
Original source
You should have the tables archived on data\sql\base\db_world. More info here https://www.azerothcore.org/wiki/sql-directory
[Embed: SQL Directory]
Wiki and Documentation of the AzerothCore project
https://www.azerothcore.org/wiki/sql-directory
Archived author: Asthalor • Posted: 2021-09-14T10:58:05.783000+00:00
Original source
You can restore them from 0 from there i think.
Archived author: Cold • Posted: 2021-09-14T11:08:09.714000+00:00
Original source
thanks for the reply
Archived author: Cold • Posted: 2021-09-14T11:10:31.368000+00:00
Original source
<@!224931509046345729>
UPDATE 'creature' SET 'wander_distance' = 5 WHERE 'GUID' IN (56058, 56059, 56086, 56127, 56160, 56162, 56125, 56123, 56166, 56150);
Would this be the proper way? for https://github.com/azerothcore/azerothco...a3ec8fbd92
Archived author: Kitzunu • Posted: 2021-09-14T11:12:23.023000+00:00
Original source
```sql
UPDATE 'creature' SET 'wander_distance' = 5 WHERE 'GUID' IN (56058, 56059, 56086, 56127, 56160, 56162, 56125, 56123, 56166, 56150) AND `id` = xxx;
```
Archived author: Kitzunu • Posted: 2021-09-14T11:12:24.183000+00:00
Original source
yep
Archived author: Kitzunu • Posted: 2021-09-14T11:12:31.762000+00:00
Original source
oh wait
Archived author: Kitzunu • Posted: 2021-09-14T11:12:34.981000+00:00
Original source
you used ''
Archived author: Kitzunu • Posted: 2021-09-14T11:12:42.966000+00:00
Original source
should be backticks like \` \`