[DiscordArchive] Did acore recently change their database but not the documentation?
[DiscordArchive] Did acore recently change their database but not the documentation?
Original source
Sec
rektbyfaith
04-17-2024, 01:23 PM #21Archived author: Bench • Posted: 2024-04-17T13:23:56.942000+00:00
Original source
Sec
Original source
```sql
ALTER TABLE `quest_template`
ADD COLUMN `RewardBonusMoney` int unsigned NOT NULL DEFAULT '0' AFTER `RewardMoneyDifficulty`;
```
rektbyfaith
04-17-2024, 01:25 PM #22Archived author: Bench • Posted: 2024-04-17T13:25:38.843000+00:00
Original source
```sql
ALTER TABLE `quest_template`
ADD COLUMN `RewardBonusMoney` int unsigned NOT NULL DEFAULT '0' AFTER `RewardMoneyDifficulty`;
```
Original source
This works!
rektbyfaith
04-17-2024, 01:27 PM #23Archived author: Cyanide • Posted: 2024-04-17T13:27:05.861000+00:00
Original source
This works!
Original source
Thank you so much
rektbyfaith
04-17-2024, 01:27 PM #24Archived author: Cyanide • Posted: 2024-04-17T13:27:38.027000+00:00
Original source
Thank you so much
Original source
Sorry, had a bad comma
rektbyfaith
04-17-2024, 01:27 PM #25Archived author: Bench • Posted: 2024-04-17T13:27:40.172000+00:00
Original source
Sorry, had a bad comma
Original source
Is it possible to just leave that column there hanging about?
rektbyfaith
04-17-2024, 01:27 PM #26Archived author: Cyanide • Posted: 2024-04-17T13:27:55.265000+00:00
Original source
Is it possible to just leave that column there hanging about?
Original source
It is possible, yes, but if there are future changes to that table (I don't expect any) it might cause problems trying to update
rektbyfaith
04-17-2024, 01:28 PM #27Archived author: Bench • Posted: 2024-04-17T13:28:26.444000+00:00
Original source
It is possible, yes, but if there are future changes to that table (I don't expect any) it might cause problems trying to update
Original source
I'll kick the rock down the road and hope there aren't. I'd do what you suggest, column, query, kill column, export but
rektbyfaith
04-17-2024, 01:29 PM #28Archived author: Cyanide • Posted: 2024-04-17T13:29:00.483000+00:00
Original source
I'll kick the rock down the road and hope there aren't. I'd do what you suggest, column, query, kill column, export but
Original source
The quests are neatly arranged into subfolders like "wetlands x/badlands y" and it'd take about an hour to imp/export bit by bit
rektbyfaith
04-17-2024, 01:29 PM #29Archived author: Cyanide • Posted: 2024-04-17T13:29:30.712000+00:00
Original source
The quests are neatly arranged into subfolders like "wetlands x/badlands y" and it'd take about an hour to imp/export bit by bit
Original source
So a dead column and just going "run these 60 files" is quick and easy (if dirty)
rektbyfaith
04-17-2024, 01:29 PM #30Archived author: Cyanide • Posted: 2024-04-17T13:29:44.686000+00:00
Original source
So a dead column and just going "run these 60 files" is quick and easy (if dirty)