[DiscordArchive] sure about that?
[DiscordArchive] sure about that?
Archived author: Stitchen • Posted: 2025-07-16T18:59:32.839000+00:00
Original source
surely they wouldn't decode/encode internally for no reason /s
Archived author: Crane • Posted: 2025-07-16T19:00:07.061000+00:00
Original source
<@200677690838220800>Can you maybe help me with the correct query, because this is really new territory for me?
```uint32 GetWeeklyQuestFromPool()
{
QueryResult result = WorldDatabase.PQuery("SELECT quest_id FROM pool_quest_save WHERE pool_id = {}", WEEKLY_POOL_ID);
if (!result)
return 0;
Field* fields = result->Fetch();
return fields[0].GetUInt32();
}
};
```
The script compiles, but when I log in, the server crashes.
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders. and says the table doesn't exist, but it does.
Archived author: Northstrider • Posted: 2025-07-16T19:02:48.654000+00:00
Original source
the crashlog tells you exactly what causes the crash
Archived author: Tea • Posted: 2025-07-16T19:03:28.368000+00:00
Original source
its pretty obvious
Archived author: Tea • Posted: 2025-07-16T19:03:42.881000+00:00
Original source
you try to read character database table from WorldDatabase
Archived author: Tea • Posted: 2025-07-16T19:04:04.809000+00:00
Original source
holidays.dbc
Archived author: Tea • Posted: 2025-07-16T19:04:50.556000+00:00
Original source
not that it matters because im pretty sure all events except the weekly repeating fishing thing dont have a valid date anymore
Archived author: Tea • Posted: 2025-07-16T19:05:04.881000+00:00
Original source
if thats even in the 335 calendar
Archived author: Northstrider • Posted: 2025-07-16T19:05:55.724000+00:00
Original source
they don't. that's why I changed the db table to allow expanding the dates
Archived author: Stitchen • Posted: 2025-07-16T19:08:40.285000+00:00
Original source
yeah new dates need to be sent through SMSG_CALENDAR_SEND_CALENDAR anyhow