[DiscordArchive] Visibility.ObjectQuestMarkers
[DiscordArchive] Visibility.ObjectQuestMarkers
Original source
Can someone tell me if I am doing this right? Trying to backup SQL statements of some of my creatures. I went to this one in particular and copied the template and spawn statements. Can I just save the SQL statement like this or should I change them in some way? I want to put them in my server folder so they re-apply on server launch
![[Image: image.png?ex=690bedfe&is=690a9c7e&hm=308...56278d4d8&]](https://cdn.discordapp.com/attachments/1255602330431127753/1433434859614896228/image.png?ex=690bedfe&is=690a9c7e&hm=30857b7cb5b2a21877f1b3b4ac8175134b230bdb184385debe8987d56278d4d8&)
rektbyfaith
10-30-2025, 12:38 PM #11Archived author: Band • Posted: 2025-10-30T12:38:22.546000+00:00
Original source
Can someone tell me if I am doing this right? Trying to backup SQL statements of some of my creatures. I went to this one in particular and copied the template and spawn statements. Can I just save the SQL statement like this or should I change them in some way? I want to put them in my server folder so they re-apply on server launch
Original source
that is the way to go
rektbyfaith
10-30-2025, 12:39 PM #12Archived author: Tereneckla • Posted: 2025-10-30T12:39:28.661000+00:00
Original source
that is the way to go
Original source
i mean, aside from the parts that are cut off and cant be seen, everything looks good there
rektbyfaith
10-30-2025, 12:39 PM #13Archived author: Mithria • Posted: 2025-10-30T12:39:37.433000+00:00
Original source
i mean, aside from the parts that are cut off and cant be seen, everything looks good there
Original source
one thing i'll caution, is depending on what table you're working with and what you're altering, you might need to be more specific with your delete statements, since custom sql apply after everything else. So for example, if a creature already has an entry in smart_scripts, and you want to add a couple more scripts to it, make your delete only delete those additional scripts.
for what you have in that screenshot though it seems good
rektbyfaith
10-30-2025, 12:41 PM #14Archived author: Mithria • Posted: 2025-10-30T12:41:54.960000+00:00
Original source
one thing i'll caution, is depending on what table you're working with and what you're altering, you might need to be more specific with your delete statements, since custom sql apply after everything else. So for example, if a creature already has an entry in smart_scripts, and you want to add a couple more scripts to it, make your delete only delete those additional scripts.
for what you have in that screenshot though it seems good
Original source
as with rm in linux, delete in sql is VERY DANGEROUS. lol. before you ; and hit enter, always check.
rektbyfaith
10-30-2025, 12:42 PM #15Archived author: greywolfe • Posted: 2025-10-30T12:42:30.490000+00:00
Original source
as with rm in linux, delete in sql is VERY DANGEROUS. lol. before you ; and hit enter, always check.
Original source
Ahhh I understand, so just make sure I include everything that was there originally when adding to
rektbyfaith
10-30-2025, 12:45 PM #16Archived author: Band • Posted: 2025-10-30T12:45:02.734000+00:00
Original source
Ahhh I understand, so just make sure I include everything that was there originally when adding to
Original source
no
rektbyfaith
10-30-2025, 12:45 PM #17Archived author: Mithria • Posted: 2025-10-30T12:45:36.636000+00:00
Original source
no
Original source
you dont have to include original stuff, just make sure your delete statement isnt so general that it removes original stuff if you're adding additional things
rektbyfaith
10-30-2025, 12:45 PM #18Archived author: Mithria • Posted: 2025-10-30T12:45:59.400000+00:00
Original source
you dont have to include original stuff, just make sure your delete statement isnt so general that it removes original stuff if you're adding additional things
Original source
for example
rektbyfaith
10-30-2025, 12:46 PM #19Archived author: Mithria • Posted: 2025-10-30T12:46:00.984000+00:00
Original source
for example
Original source
if a creature has some entries in `creature_text` for `CreatureID` 5000, and you want that creature to say more things, dont
```
DELETE FROM `creature_text` WHERE `CreatureID` = 5000;
```
before your inserts, because in addition to deleting your custom entries before readding them, it would also delete all original entries for that creature.
instead, you could have your delete target creature id AND the specific text id's you added. so if that creature already had 2 text options in the table, and you added 3 more, you could instead do
```
DELETE FROM `creature_text` WHERE `CreatureID` = 5000 AND `ID` IN (2, 3, 4);
```
rektbyfaith
10-30-2025, 12:50 PM #20Archived author: Mithria • Posted: 2025-10-30T12:50:55.762000+00:00
Original source
if a creature has some entries in `creature_text` for `CreatureID` 5000, and you want that creature to say more things, dont
```
DELETE FROM `creature_text` WHERE `CreatureID` = 5000;
```
before your inserts, because in addition to deleting your custom entries before readding them, it would also delete all original entries for that creature.
instead, you could have your delete target creature id AND the specific text id's you added. so if that creature already had 2 text options in the table, and you added 3 more, you could instead do
```
DELETE FROM `creature_text` WHERE `CreatureID` = 5000 AND `ID` IN (2, 3, 4);
```
1 Guest(s)
1 Guest(s)