[DiscordArchive] Let's say, for example, I wanted to change the name of the "Lazy Peon"s in the den of trials to "Laz
[DiscordArchive] Let's say, for example, I wanted to change the name of the "Lazy Peon"s in the den of trials to "Laz
Original source
Let's say, for example, I wanted to change the name of the "Lazy Peon"s in the den of trials to "Lazy Worker". Would I change it in creature_template.sql and place that changed file in custom/db_world?
rektbyfaith
09-24-2025, 09:26 PM #1Archived author: Bauf • Posted: 2025-09-24T21:26:42.118000+00:00
Original source
Let's say, for example, I wanted to change the name of the "Lazy Peon"s in the den of trials to "Lazy Worker". Would I change it in creature_template.sql and place that changed file in custom/db_world?
Original source
No, don't export all of creature_template or edit the existing files in azerothcore. Create a file in the custom/db_world folder, using a unique name like for your example `update_lazy_peon_lazy_worker.sql` and add your changes to it. Like this:
```sql
UPDATE `creature_template` SET `name` = 'Lazy Worker' WHERE `entry` = 10556;
```
rektbyfaith
09-24-2025, 09:30 PM #2Archived author: Revision • Posted: 2025-09-24T21:30:48.924000+00:00
Original source
No, don't export all of creature_template or edit the existing files in azerothcore. Create a file in the custom/db_world folder, using a unique name like for your example `update_lazy_peon_lazy_worker.sql` and add your changes to it. Like this:
```sql
UPDATE `creature_template` SET `name` = 'Lazy Worker' WHERE `entry` = 10556;
```
Original source
If you use Keira it will also add a convenient query at the top of the window when you edit something that you can just copy and paste into a file
rektbyfaith
09-24-2025, 09:32 PM #3Archived author: Revision • Posted: 2025-09-24T21:32:30.467000+00:00
Original source
If you use Keira it will also add a convenient query at the top of the window when you edit something that you can just copy and paste into a file
Original source
That's exactly what I needed. But it also did not work. Am I correct that the custom/db_world folder I should be using is in the folder I cloned git into. And that config files point to it via SourceDirectory = "" entry.
rektbyfaith
09-24-2025, 09:49 PM #4Archived author: Bauf • Posted: 2025-09-24T21:49:52.704000+00:00
Original source
That's exactly what I needed. But it also did not work. Am I correct that the custom/db_world folder I should be using is in the folder I cloned git into. And that config files point to it via SourceDirectory = "" entry.
Original source
`data/sql/custom/db_world` inside the azerothcore folder, yes. But you don't have to set SourceDirectory unless you actually move the source after compiling it.
rektbyfaith
09-24-2025, 09:51 PM #5Archived author: Revision • Posted: 2025-09-24T21:51:09.886000+00:00
Original source
`data/sql/custom/db_world` inside the azerothcore folder, yes. But you don't have to set SourceDirectory unless you actually move the source after compiling it.
Original source
I have not. Its the same folder path I used with CMAKE.
rektbyfaith
09-24-2025, 09:51 PM #6Archived author: Bauf • Posted: 2025-09-24T21:51:54.713000+00:00
Original source
I have not. Its the same folder path I used with CMAKE.
Original source
just installed Challenge Modes (no errors) can't see Shrine of Challenge at graveyeard? anyhelp would be great thanks.
rektbyfaith
09-24-2025, 10:33 PM #7Archived author: Subzeroevil • Posted: 2025-09-24T22:33:23.642000+00:00
Original source
just installed Challenge Modes (no errors) can't see Shrine of Challenge at graveyeard? anyhelp would be great thanks.
Original source
I renamed a creature successfully, thank you for that. But I have a new issue. I tried creating a new creature via the INSERT query. And I got this error "Creature (Entry: 100000) does not have any existing display id in creature_template_model." when I launched my server. I understand this error and how to fix it. But I have since deleted the INSERT query and am still receiving the error. I assume the entry is still in the database. Is there an easy way to rebuild or clean the database of this?
rektbyfaith
09-24-2025, 11:00 PM #8Archived author: Bauf • Posted: 2025-09-24T23:00:31.851000+00:00
Original source
I renamed a creature successfully, thank you for that. But I have a new issue. I tried creating a new creature via the INSERT query. And I got this error "Creature (Entry: 100000) does not have any existing display id in creature_template_model." when I launched my server. I understand this error and how to fix it. But I have since deleted the INSERT query and am still receiving the error. I assume the entry is still in the database. Is there an easy way to rebuild or clean the database of this?
Original source
Can I just delete the whole database with Heidi and let worldserver rebuild it?
rektbyfaith
09-24-2025, 11:06 PM #9Archived author: Bauf • Posted: 2025-09-24T23:06:05.486000+00:00
Original source
Can I just delete the whole database with Heidi and let worldserver rebuild it?
Original source
You could either delete what you added or drop the world db entirely and let worldserver rebuild it
rektbyfaith
09-24-2025, 11:14 PM #10Archived author: Mithria • Posted: 2025-09-24T23:14:46.988000+00:00
Original source
You could either delete what you added or drop the world db entirely and let worldserver rebuild it
1 Guest(s)
1 Guest(s)