[DiscordArchive] Is there something I am missing? some context?
[DiscordArchive] Is there something I am missing? some context?
Original source
Is there something I am missing? some context?
rektbyfaith
10-29-2025, 02:06 PM #1Archived author: Band • Posted: 2025-10-29T14:06:28.335000+00:00
Original source
Is there something I am missing? some context?
Original source
Each modification should be done with an SQL script (which ideally you keep around for using it again in case you need to do a clean install or database drop).
In addition you should probably keep a "revert" script to revert your changes back to the default values, just in case.
As far as I know, both can be exported from Keira
rektbyfaith
10-29-2025, 02:15 PM #2Archived author: Tecc • Posted: 2025-10-29T14:15:14.590000+00:00
Original source
Each modification should be done with an SQL script (which ideally you keep around for using it again in case you need to do a clean install or database drop).
In addition you should probably keep a "revert" script to revert your changes back to the default values, just in case.
As far as I know, both can be exported from Keira
Original source
You should always store SQL queries that change stuff in a SQL file so you can easily import it again if you lose the world database, have to reset it or anything along those lines.
rektbyfaith
10-29-2025, 02:15 PM #3Archived author: Revision • Posted: 2025-10-29T14:15:15.814000+00:00
Original source
You should always store SQL queries that change stuff in a SQL file so you can easily import it again if you lose the world database, have to reset it or anything along those lines.
Original source
Yes, Keira will show you the query it generates when you change stuff so you can easily copy-paste it
rektbyfaith
10-29-2025, 02:15 PM #4Archived author: Revision • Posted: 2025-10-29T14:15:37.440000+00:00
Original source
Yes, Keira will show you the query it generates when you change stuff so you can easily copy-paste it
Original source
Even if you back up the world database, there are instances where resetting the world database is the only solution and if you rely on world backups you are screwed
rektbyfaith
10-29-2025, 02:16 PM #5Archived author: Revision • Posted: 2025-10-29T14:16:18.563000+00:00
Original source
Even if you back up the world database, there are instances where resetting the world database is the only solution and if you rely on world backups you are screwed
Original source
Doing it the way you're doing it is generally considered bad practice
rektbyfaith
10-29-2025, 02:16 PM #6Archived author: Revision • Posted: 2025-10-29T14:16:52.182000+00:00
Original source
Doing it the way you're doing it is generally considered bad practice
Original source
Dang I wish I knew this early on, I will start doing this going forward. I haven't made a TON of changes yet, so I might be able to salvage it
rektbyfaith
10-29-2025, 02:38 PM #7Archived author: Band • Posted: 2025-10-29T14:38:05.310000+00:00
Original source
Dang I wish I knew this early on, I will start doing this going forward. I haven't made a TON of changes yet, so I might be able to salvage it
Original source
How do you organize your SQL statements? Do you use a big one for all your creature modifications or do you do it really granular?
rektbyfaith
10-29-2025, 02:43 PM #8Archived author: Band • Posted: 2025-10-29T14:43:20.902000+00:00
Original source
How do you organize your SQL statements? Do you use a big one for all your creature modifications or do you do it really granular?
Original source
I tend to store them in separate files based on the table they change. It's not bad to keep them all in a single file though if that's what you prefer. Essentially it's personal preference.
rektbyfaith
10-29-2025, 02:46 PM #9Archived author: Revision • Posted: 2025-10-29T14:46:07.251000+00:00
Original source
I tend to store them in separate files based on the table they change. It's not bad to keep them all in a single file though if that's what you prefer. Essentially it's personal preference.
Original source
My queries are merged when they can. For example if I change the level of a creature and then a number of other creatures are changed to the same level I just use a `IN` to merge them into a single query. The same for other columns. I never merge queries if the columns changed aren't identical.
rektbyfaith
10-29-2025, 02:47 PM #10Archived author: Revision • Posted: 2025-10-29T14:47:02.973000+00:00
Original source
My queries are merged when they can. For example if I change the level of a creature and then a number of other creatures are changed to the same level I just use a `IN` to merge them into a single query. The same for other columns. I never merge queries if the columns changed aren't identical.
1 Guest(s)
1 Guest(s)