[DiscordArchive] oh, yeah that, no I have no clue if AC can do that by default. Why would you want to re-create the
[DiscordArchive] oh, yeah that, no I have no clue if AC can do that by default. Why would you want to re-create the
Original source
oh, yeah that, no I have no clue if AC can do that by default. Why would you want to re-create the world database every restart?
rektbyfaith
08-12-2025, 05:42 AM #1Archived author: [PD] Tlosk • Posted: 2025-08-12T05:42:08.262000+00:00
Original source
oh, yeah that, no I have no clue if AC can do that by default. Why would you want to re-create the world database every restart?
Original source
The XY of this is what I want to disable repair vendors (ie, removing the npcflag) from all vendors that offer repairs. This is most easily done through an SQL query that updates every NPC entry to remove that flag. Except this is an extremely irreversible thing... like... I don't even want to attempt to make a `.down.sql` query to reverse this.
So what I was thinking was: *"Have the 'acore_world' restore itself from backup every restart and then re-apply all my SQL scripts, because if there's ever a time I want to allow repair vendors again, I can just delete that SQL script, restart the server, and have all the repair vendors back."*
rektbyfaith
08-12-2025, 05:44 AM #2Archived author: Dioxain • Posted: 2025-08-12T05:44:48.365000+00:00
Original source
The XY of this is what I want to disable repair vendors (ie, removing the npcflag) from all vendors that offer repairs. This is most easily done through an SQL query that updates every NPC entry to remove that flag. Except this is an extremely irreversible thing... like... I don't even want to attempt to make a `.down.sql` query to reverse this.
So what I was thinking was: *"Have the 'acore_world' restore itself from backup every restart and then re-apply all my SQL scripts, because if there's ever a time I want to allow repair vendors again, I can just delete that SQL script, restart the server, and have all the repair vendors back."*
Original source
I mean you could possibly build a script that deletes the world database every time you shutdown/restart the server. So you want to have more of a equipment hardcore mode where once it wears out, you cant use it anymore?
rektbyfaith
08-12-2025, 05:45 AM #3Archived author: [PD] Tlosk • Posted: 2025-08-12T05:45:59.812000+00:00
Original source
I mean you could possibly build a script that deletes the world database every time you shutdown/restart the server. So you want to have more of a equipment hardcore mode where once it wears out, you cant use it anymore?
Original source
you could just delete that sql script, drop the world db, then start worldserver and it will rebuild the entire thing and then run ur sql scripts minus the one you removed
rektbyfaith
08-12-2025, 05:46 AM #4Archived author: Mithria • Posted: 2025-08-12T05:46:01.102000+00:00
Original source
you could just delete that sql script, drop the world db, then start worldserver and it will rebuild the entire thing and then run ur sql scripts minus the one you removed
1 Guest(s)
1 Guest(s)