[DiscordArchive] how do sql servers update their content, is it automatic?
[DiscordArchive] how do sql servers update their content, is it automatic?
Original source
how do sql servers update their content, is it automatic?
rektbyfaith
05-16-2022, 06:40 PM #1Archived author: Kiffy • Posted: 2022-05-16T18:40:43.448000+00:00
Original source
how do sql servers update their content, is it automatic?
Original source
im talking in regards to the worldserver
rektbyfaith
05-16-2022, 06:42 PM #2Archived author: Kiffy • Posted: 2022-05-16T18:42:02.265000+00:00
Original source
im talking in regards to the worldserver
Original source
In some cases u can use a ingame command to reload some templates, but the worldserver does "snapshot" alot of data so it would need a restart depending on the edits. But overall most of SQL is live but it does call for data from .DBC files and editing those would require a restart to work properly with the SQL edits, Like Enchants and Items for example
rektbyfaith
05-16-2022, 06:45 PM #3Archived author: Jyria • Posted: 2022-05-16T18:45:39.969000+00:00
Original source
In some cases u can use a ingame command to reload some templates, but the worldserver does "snapshot" alot of data so it would need a restart depending on the edits. But overall most of SQL is live but it does call for data from .DBC files and editing those would require a restart to work properly with the SQL edits, Like Enchants and Items for example
Original source
Each world update increments the world database 'version' table. So when you apply updates it knows that update has been applied
rektbyfaith
05-16-2022, 06:46 PM #4Archived author: stoneharry • Posted: 2022-05-16T18:46:26.190000+00:00
Original source
Each world update increments the world database 'version' table. So when you apply updates it knows that update has been applied
Original source
In TC it is configurable whether SQL updates are applied automatically on startup
rektbyfaith
05-16-2022, 06:46 PM #5Archived author: stoneharry • Posted: 2022-05-16T18:46:37.075000+00:00
Original source
In TC it is configurable whether SQL updates are applied automatically on startup
Original source
so does it only require you to restart the worldserver to apply changes?
rektbyfaith
05-16-2022, 06:46 PM #6Archived author: Kiffy • Posted: 2022-05-16T18:46:52.759000+00:00
Original source
so does it only require you to restart the worldserver to apply changes?
Original source
In theory, yes
rektbyfaith
05-16-2022, 06:46 PM #7Archived author: stoneharry • Posted: 2022-05-16T18:46:58.321000+00:00
Original source
In theory, yes
Original source
Sometimes the mmaps, vmaps, or map version might change, or there might be new config to uptake etc
rektbyfaith
05-16-2022, 06:47 PM #8Archived author: stoneharry • Posted: 2022-05-16T18:47:22.051000+00:00
Original source
Sometimes the mmaps, vmaps, or map version might change, or there might be new config to uptake etc
Original source
bit late, but `...` = optional number of arguments, so it is trying to select from this optional set of arguments
rektbyfaith
05-16-2022, 06:48 PM #9Archived author: stoneharry • Posted: 2022-05-16T18:48:34.483000+00:00
Original source
bit late, but `...` = optional number of arguments, so it is trying to select from this optional set of arguments
Original source
well i could explain my situation here directly if ur able to give insight.
so, I have modified and built the core files required for a 12th class, added the necessary race and class creation information in the SQL database , and the DBCs are the same on client and server - yet i get the same error message. Is there something else?
![[Image: unknown.png?ex=690c4546&is=690af3c6&hm=5...cd0f423a7&]](https://cdn.discordapp.com/attachments/415944535718494208/975832701833728060/unknown.png?ex=690c4546&is=690af3c6&hm=5e46fefe5f69999748290a5b613c2f306717e6b7f21b4bcff412080cd0f423a7&)
![[Image: unknown.png?ex=690c4546&is=690af3c6&hm=0...4f14f1a05&]](https://cdn.discordapp.com/attachments/415944535718494208/975832702160887888/unknown.png?ex=690c4546&is=690af3c6&hm=0318891ec29fb7157abae710d6c72dcb20f62e71f0fccbaa1b26e694f14f1a05&)
rektbyfaith
05-16-2022, 06:50 PM #10Archived author: Kiffy • Posted: 2022-05-16T18:50:46.586000+00:00
Original source
well i could explain my situation here directly if ur able to give insight.
so, I have modified and built the core files required for a 12th class, added the necessary race and class creation information in the SQL database , and the DBCs are the same on client and server - yet i get the same error message. Is there something else?