[DiscordArchive] can anyone help me with the following SQL?
[DiscordArchive] can anyone help me with the following SQL?
Archived author: Lonk • Posted: 2023-06-05T10:43:01.573000+00:00
Original source
so:
```USE acore_world;
UPDATE creature_loot_template SET Chance=100 WHERE QuestRequired=1;```
Archived author: Tereneckla • Posted: 2023-06-05T10:43:13.555000+00:00
Original source
yeah
Archived author: Lonk • Posted: 2023-06-05T10:43:18.256000+00:00
Original source
Brill, thank you
Archived author: Lonk • Posted: 2023-06-05T10:43:30.880000+00:00
Original source
watch my DB go byebye now
Archived author: Tereneckla • Posted: 2023-06-05T10:44:37.700000+00:00
Original source
best make it a file and put it into data\sql\custom\db_world btw
Archived author: Tereneckla • Posted: 2023-06-05T10:44:47.048000+00:00
Original source
for when you update your server in the future
Archived author: Lonk • Posted: 2023-06-05T10:45:14.306000+00:00
Original source
Ah, ran it already, when I update will it revert the changes in that db back to stock?
Archived author: Tereneckla • Posted: 2023-06-05T10:45:52.227000+00:00
Original source
no, but an update could change the drop chance of items
Archived author: Lonk • Posted: 2023-06-05T10:47:05.475000+00:00
Original source
Gotchya, makes sense a fix may change a drop chance, thanks
Archived author: Lonk • Posted: 2023-06-05T10:47:17+00:00
Original source
I assume I just save it with an sql extension?