自学教程：C++ CalendarInviteStatus函数代码示例

void WorldSession::HandleCalendarEventSignup(WorldPacket& recv_data){    ObjectGuid guid = _player->GetObjectGuid();    DEBUG_LOG("WORLD: Received opcode CMSG_CALENDAR_EVENT_SIGNUP [%s]", guid.GetString().c_str());    uint64 eventId;    bool tentative;    recv_data >> eventId;    recv_data >> tentative; // uint8 == bool size in all compilator???    DEBUG_FILTER_LOG(LOG_FILTER_CALENDAR, "EventId [" UI64FMTD "] Tentative %u", eventId, uint32(tentative));    if (CalendarEvent* event = sCalendarMgr.GetEventById(eventId))    {        if (event->IsGuildEvent() && event->GuildId != _player->GetGuildId())        {            sCalendarMgr.SendCalendarCommandResult(_player, CALENDAR_ERROR_GUILD_PLAYER_NOT_IN_GUILD);            return;        }        CalendarInviteStatus status = tentative ? CALENDAR_STATUS_TENTATIVE : CALENDAR_STATUS_SIGNED_UP;        sCalendarMgr.AddInvite(event, guid, guid, CalendarInviteStatus(status), CALENDAR_RANK_PLAYER, "", time(nullptr));        sCalendarMgr.SendCalendarClearPendingAction(_player);    }    else        sCalendarMgr.SendCalendarCommandResult(_player, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventSignup(WorldPacket& recv_data){    ObjectGuid guid = _player->GetObjectGuid();    DEBUG_LOG("WORLD: CMSG_CALENDAR_EVENT_SIGNUP [%u]", guid.GetCounter());    ObjectGuid eventId;    bool tentative;    recv_data >> eventId;    recv_data >> tentative; // uint8 == bool size in all compilator???    DEBUG_FILTER_LOG(LOG_FILTER_CALENDAR, "WorldSession::HandleCalendarEventSignup [%u] EventId [%u] Tentative %u", guid.GetCounter(), uint32(eventId), tentative);    if (CalendarEvent* calendarEvent = sCalendarMgr.GetEventById(eventId))    {        if (calendarEvent->IsGuildEvent() && calendarEvent->GuildId != _player->GetGuildId())        {            sCalendarMgr.SendCalendarCommandResult(guid, CALENDAR_ERROR_GUILD_PLAYER_NOT_IN_GUILD);            return;        }        CalendarInviteStatus status = tentative ? CALENDAR_STATUS_TENTATIVE : CALENDAR_STATUS_SIGNED_UP;        sCalendarMgr.AddInvite(calendarEvent, guid, guid, CalendarInviteStatus(status), CALENDAR_RANK_PLAYER, "", time(NULL));        sCalendarMgr.SendCalendarClearPendingAction(guid);    }    else        sCalendarMgr.SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventRsvp(WorldPackets::Calendar::CalendarEventRSVP& calendarEventRSVP){    ObjectGuid guid = _player->GetGUID();    if (CalendarEvent* calendarEvent = sCalendarMgr->GetEvent(calendarEventRSVP.EventID))    {        // I think we still should be able to remove self from locked events        if (calendarEventRSVP.Status != CALENDAR_STATUS_REMOVED && calendarEvent->IsLocked())        {            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_LOCKED);            return;        }        if (CalendarInvite* invite = sCalendarMgr->GetInvite(calendarEventRSVP.InviteID))        {            invite->SetStatus(CalendarInviteStatus(calendarEventRSVP.Status));            invite->SetResponseTime(time(NULL));            sCalendarMgr->UpdateInvite(invite);            sCalendarMgr->SendCalendarEventStatus(*calendarEvent, *invite);            sCalendarMgr->SendCalendarClearPendingAction(guid);        }        else            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_INVITE); // correct?    }    else        sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventRsvp(WorldPacket& recvData){    uint64 guid = _player->GetGUID();    uint64 eventId;    uint64 inviteId;    uint32 status;    recvData >> eventId >> inviteId >> status;    if (CalendarEvent* calendarEvent = sCalendarMgr->GetEvent(eventId))    {        // i think we still should be able to remove self from locked events        if (status != CALENDAR_STATUS_REMOVED && calendarEvent->GetFlags() & CALENDAR_FLAG_INVITES_LOCKED)        {            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_LOCKED);            return;        }        if (CalendarInvite* invite = sCalendarMgr->GetInvite(inviteId))        {            invite->SetStatus(CalendarInviteStatus(status));            invite->SetStatusTime(time(NULL));            sCalendarMgr->UpdateInvite(invite);            sCalendarMgr->SendCalendarEventStatus(*calendarEvent, *invite);            sCalendarMgr->SendCalendarClearPendingAction(guid);        }        else            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_INVITE); // correct?    }    else        sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarAddEvent(WorldPackets::Calendar::CalendarAddEvent& calendarAddEvent){    ObjectGuid guid = _player->GetGUID();    // prevent events in the past    // To Do: properly handle timezones and remove the "- time_t(86400L)" hack    if (calendarAddEvent.EventInfo.Time < (time(NULL) - time_t(86400L)))        return;    CalendarEvent* calendarEvent = new CalendarEvent(sCalendarMgr->GetFreeEventId(), guid, UI64LIT(0), CalendarEventType(calendarAddEvent.EventInfo.EventType), calendarAddEvent.EventInfo.TextureID,        calendarAddEvent.EventInfo.Time, calendarAddEvent.EventInfo.Flags, calendarAddEvent.EventInfo.Title, calendarAddEvent.EventInfo.Description, time_t(0));    if (calendarEvent->IsGuildEvent() || calendarEvent->IsGuildAnnouncement())        if (Player* creator = ObjectAccessor::FindPlayer(guid))            calendarEvent->SetGuildId(creator->GetGuildId());    if (calendarEvent->IsGuildAnnouncement())    {        CalendarInvite invite(0, calendarEvent->GetEventId(), ObjectGuid::Empty, guid, CALENDAR_DEFAULT_RESPONSE_TIME, CALENDAR_STATUS_NOT_SIGNED_UP, CALENDAR_RANK_PLAYER, "");        // WARNING: By passing pointer to a local variable, the underlying method(s) must NOT perform any kind        // of storage of the pointer as it will lead to memory corruption        sCalendarMgr->AddInvite(calendarEvent, &invite);    }    else    {        SQLTransaction trans;        if (calendarAddEvent.EventInfo.Invites.size() > 1)            trans = CharacterDatabase.BeginTransaction();        for (uint32 i = 0; i < calendarAddEvent.EventInfo.Invites.size(); ++i)        {            CalendarInvite* invite = new CalendarInvite(sCalendarMgr->GetFreeInviteId(), calendarEvent->GetEventId(), calendarAddEvent.EventInfo.Invites[i].Guid,                guid, CALENDAR_DEFAULT_RESPONSE_TIME, CalendarInviteStatus(calendarAddEvent.EventInfo.Invites[i].Status),                CalendarModerationRank(calendarAddEvent.EventInfo.Invites[i].Moderator), "");            sCalendarMgr->AddInvite(calendarEvent, invite, trans);        }        if (calendarAddEvent.EventInfo.Invites.size() > 1)            CharacterDatabase.CommitTransaction(trans);    }    sCalendarMgr->AddEvent(calendarEvent, CALENDAR_SENDTYPE_ADD);}

void WorldSession::HandleCalendarAddEvent(WorldPacket& recvData){    uint64 guid = _player->GetGUID();    std::string title;    std::string description;    uint8 type;    uint8 repeatable;    uint32 maxInvites;    int32 dungeonId;    uint32 eventPackedTime;    uint32 unkPackedTime;    uint32 flags;    recvData >> title >> description >> type >> repeatable >> maxInvites >> dungeonId;    recvData.ReadPackedTime(eventPackedTime);    recvData.ReadPackedTime(unkPackedTime);    recvData >> flags;    CalendarEvent* calendarEvent = new CalendarEvent(sCalendarMgr->GetFreeEventId(), guid, 0, CalendarEventType(type), dungeonId,        time_t(eventPackedTime), flags, time_t(unkPackedTime), title, description);    if (calendarEvent->IsGuildEvent() || calendarEvent->IsGuildAnnouncement())        if (Player* creator = ObjectAccessor::FindPlayer(guid))            calendarEvent->SetGuildId(creator->GetGuildId());    if (calendarEvent->IsGuildAnnouncement())    {        // 946684800 is 01/01/2000 00:00:00 - default response time        CalendarInvite* invite = new CalendarInvite(0, calendarEvent->GetEventId(), 0, guid, 946684800, CALENDAR_STATUS_NOT_SIGNED_UP, CALENDAR_RANK_PLAYER, "");        sCalendarMgr->AddInvite(calendarEvent, invite);    }    else    {        uint32 inviteCount;        recvData >> inviteCount;        for (uint32 i = 0; i < inviteCount; ++i)        {            uint64 invitee = 0;            uint8 status = 0;            uint8 rank = 0;            recvData.readPackGUID(invitee);            recvData >> status >> rank;            // 946684800 is 01/01/2000 00:00:00 - default response time            CalendarInvite* invite = new CalendarInvite(sCalendarMgr->GetFreeInviteId(), calendarEvent->GetEventId(), invitee, guid, 946684800, CalendarInviteStatus(status), CalendarModerationRank(rank), "");            sCalendarMgr->AddInvite(calendarEvent, invite);        }    }    sCalendarMgr->AddEvent(calendarEvent, CALENDAR_SENDTYPE_ADD);}

void WorldSession::HandleCalendarAddEvent(WorldPacket& recvData){    ObjectGuid guid = _player->GetGUID();    std::string title;    std::string description;    uint8 type;    uint8 repeatable;    uint32 maxInvites;    int32 dungeonId;    uint32 eventPackedTime;    uint32 unkPackedTime;    uint32 flags;    recvData >> title >> description >> type >> repeatable >> maxInvites >> dungeonId;    recvData.ReadPackedTime(eventPackedTime);    recvData.ReadPackedTime(unkPackedTime);    recvData >> flags;    // prevent events in the past    // To Do: properly handle timezones and remove the "- time_t(86400L)" hack    if (time_t(eventPackedTime) < (time(NULL) - time_t(86400L)))    {        recvData.rfinish();        return;    }    CalendarEvent* calendarEvent = new CalendarEvent(sCalendarMgr->GetFreeEventId(), guid, 0, CalendarEventType(type), dungeonId,        time_t(eventPackedTime), flags, time_t(unkPackedTime), title, description);    if (calendarEvent->IsGuildEvent() || calendarEvent->IsGuildAnnouncement())        if (Player* creator = ObjectAccessor::FindPlayer(guid))            calendarEvent->SetGuildId(creator->GetGuildId());    if (calendarEvent->IsGuildAnnouncement())    {        // 946684800 is 01/01/2000 00:00:00 - default response time        CalendarInvite invite(0, calendarEvent->GetEventId(), ObjectGuid::Empty, guid, 946684800, CALENDAR_STATUS_NOT_SIGNED_UP, CALENDAR_RANK_PLAYER, "");        // WARNING: By passing pointer to a local variable, the underlying method(s) must NOT perform any kind        // of storage of the pointer as it will lead to memory corruption        sCalendarMgr->AddInvite(calendarEvent, &invite);    }    else    {        // client limits the amount of players to be invited to 100        const uint32 MaxPlayerInvites = 100;        uint32 inviteCount;        ObjectGuid invitee[MaxPlayerInvites];        uint8 status[MaxPlayerInvites];        uint8 rank[MaxPlayerInvites];        memset(status, 0, sizeof(status));        memset(rank, 0, sizeof(rank));        try        {            recvData >> inviteCount;            for (uint32 i = 0; i < inviteCount && i < MaxPlayerInvites; ++i)            {                recvData >> invitee[i].ReadAsPacked();                recvData >> status[i] >> rank[i];            }        }        catch (ByteBufferException const&)        {            delete calendarEvent;            calendarEvent = NULL;            throw;        }        SQLTransaction trans;        if (inviteCount > 1)            trans = CharacterDatabase.BeginTransaction();        for (uint32 i = 0; i < inviteCount && i < MaxPlayerInvites; ++i)        {            // 946684800 is 01/01/2000 00:00:00 - default response time            CalendarInvite* invite = new CalendarInvite(sCalendarMgr->GetFreeInviteId(), calendarEvent->GetEventId(), invitee[i], guid, 946684800, CalendarInviteStatus(status[i]), CalendarModerationRank(rank[i]), "");            sCalendarMgr->AddInvite(calendarEvent, invite, trans);        }        if (inviteCount > 1)            CharacterDatabase.CommitTransaction(trans);    }    sCalendarMgr->AddEvent(calendarEvent, CALENDAR_SENDTYPE_ADD);}

void CalendarMgr::LoadFromDB(){    // Loading calendar_events    {        QueryResult* result = CharacterDatabase.Query("SELECT entry, creator, title, description, type, dungeon, date, flags FROM calendar_events");        if (!result)        {            Log.Debug("CalendarMgr", "Table calendar_events is empty.");            return;        }        if (result == 0)            return;        uint32 count = 0;        do        {            Field* fields = result->Fetch();            uint64 entry = fields[0].GetUInt32();            uint32 creator = fields[1].GetUInt32();            std::string title = fields[2].GetString();            std::string description = fields[3].GetString();            CalendarEventType type = CalendarEventType(fields[4].GetUInt32());            uint32 dungeon = fields[5].GetUInt32();            time_t date = fields[6].GetUInt32();            uint32 flags = fields[7].GetUInt32();            CalendarEvent* calendarEvent = new CalendarEvent(entry, creator, title, description, type, dungeon, time_t(date), flags);            _events.insert(calendarEvent);            Log.Debug("CalendarMgr", "Title %s loaded", calendarEvent->title.c_str()); // remove me ;-)            ++count;        } while (result->NextRow());    }    Log.Success("CalendarMgr", "%u entries loaded from table calendar_events", _events.size());    {        QueryResult* result = CharacterDatabase.Query("SELECT invite_id, event, invitee, sender, status, statustime, rank, text FROM calendar_invites");        if (!result)        {            Log.Debug("CalendarMgr", "Table calendar_invites is empty.");            return;        }        if (result == 0)            return;        uint32 count = 0;        do        {            Field* fields = result->Fetch();            uint32 invite_id = fields[0].GetUInt32();               // entry of the calendar event (unique)            uint32 event = fields[1].GetUInt32();             // id of the character            uint32 invitee = fields[2].GetUInt32();            uint32 sender = fields[3].GetUInt32();            CalendarInviteStatus status = CalendarInviteStatus(fields[4].GetUInt32());            time_t statustime = fields[5].GetUInt32();            uint32 rank = fields[6].GetUInt32();            std::string text = fields[7].GetString();            CalendarInvite* invite = new CalendarInvite(invite_id, event, invitee, sender, status, time_t(statustime), rank, text);            _invites[event].push_back(invite);            ++count;        } while (result->NextRow());    }    Log.Success("CalendarMgr", "Loaded %u calendar invites", _invites.size());}

void WorldSession::HandleCalendarAddEvent(WorldPacket& recvData){    uint64 guid = _player->GetGUID();    std::string title;    std::string description;    uint8 type;    uint8 repeatable;    uint32 maxInvites;    int32 dungeonId;    uint32 eventPackedTime;    uint32 unkPackedTime;    uint32 flags;    recvData >> title >> description >> type >> repeatable >> maxInvites >> dungeonId;    recvData.ReadPackedTime(eventPackedTime);    recvData.ReadPackedTime(unkPackedTime);    recvData >> flags;    CalendarEvent calendarEvent(sCalendarMgr->GetFreeEventId(), guid, 0, CalendarEventType(type), dungeonId,        time_t(eventPackedTime), flags, time_t(unkPackedTime), title, description);    if (calendarEvent.IsGuildEvent() || calendarEvent.IsGuildAnnouncement())        if (Player* creator = ObjectAccessor::FindPlayer(guid))            calendarEvent.SetGuildId(creator->GetGuildId());    if (calendarEvent.IsGuildAnnouncement())    {        // 946684800 is 01/01/2000 00:00:00 - default response time        CalendarInvite invite(0, calendarEvent.GetEventId(), 0, guid, 946684800, CALENDAR_STATUS_NOT_SIGNED_UP, CALENDAR_RANK_PLAYER, "");        // WARNING: By passing pointer to a local variable, the underlying method(s) must NOT perform any kind        // of storage of the pointer as it will lead to memory corruption        sCalendarMgr->AddInvite(&calendarEvent, &invite);    }    else    {        uint32 inviteCount;        recvData >> inviteCount;        SQLTransaction trans;        if (inviteCount > 1)            trans = CharacterDatabase.BeginTransaction();        // client limits the amount of players to be invited to 100        const uint32 MaxPlayerInvites = 100;        for (uint32 i = 0; i < inviteCount && i < MaxPlayerInvites; ++i)        {            uint64 invitee = 0;            uint8 status = 0;            uint8 rank = 0;            recvData.readPackGUID(invitee);            recvData >> status >> rank;            // 946684800 is 01/01/2000 00:00:00 - default response time            CalendarInvite* invite = new CalendarInvite(sCalendarMgr->GetFreeInviteId(), calendarEvent.GetEventId(), invitee, guid, 946684800, CalendarInviteStatus(status), CalendarModerationRank(rank), "");            sCalendarMgr->AddInvite(&calendarEvent, invite, trans);        }        if (inviteCount > 1)            CharacterDatabase.CommitTransaction(trans);    }    sCalendarMgr->AddEvent(new CalendarEvent(calendarEvent, calendarEvent.GetEventId()), CALENDAR_SENDTYPE_ADD);}

void WorldSession::HandleCalendarAddEvent(WorldPacket& recvData){    uint64 guid = _player->GetGUID();    std::string title;    std::string description;    uint8 type;    int32 dungeonId;    uint32 eventPackedTime;    uint32 maxInvites;  // always 100, necesary? Not find the way how to change it    uint32 flags;    uint32 inviteeCount;    uint16 descriptionLength, titleLength;    recvData >> maxInvites >> flags >> dungeonId;    recvData.ReadPackedTime(eventPackedTime);    recvData >> type;    inviteeCount = recvData.ReadBits(22);    descriptionLength = recvData.ReadBits(11);    std::list<CalendarInvitePacketInfo> calendarInviteList;    for (uint32 i = 0; i < inviteeCount; i++)    {        CalendarInvitePacketInfo info;        info.Guid[7] = recvData.ReadBit();        info.Guid[2] = recvData.ReadBit();        info.Guid[6] = recvData.ReadBit();        info.Guid[3] = recvData.ReadBit();        info.Guid[5] = recvData.ReadBit();        info.Guid[1] = recvData.ReadBit();        info.Guid[0] = recvData.ReadBit();        info.Guid[4] = recvData.ReadBit();        calendarInviteList.push_back(info);    }    titleLength = recvData.ReadBits(8);    for (std::list<CalendarInvitePacketInfo>::iterator iter = calendarInviteList.begin(); iter != calendarInviteList.end(); ++iter)    {        recvData.ReadByteSeq(iter->Guid[4]);        recvData.ReadByteSeq(iter->Guid[2]);        recvData.ReadByteSeq(iter->Guid[3]);        recvData.ReadByteSeq(iter->Guid[1]);        recvData.ReadByteSeq(iter->Guid[0]);        recvData.ReadByteSeq(iter->Guid[6]);        recvData.ReadByteSeq(iter->Guid[7]);        recvData >> iter->Status;        recvData.ReadByteSeq(iter->Guid[5]);        recvData >> iter->ModerationRank;    }    title = recvData.ReadString(titleLength);    description = recvData.ReadString(descriptionLength);    CalendarEvent* calendarEvent = new CalendarEvent(sCalendarMgr->GetFreeEventId(), guid, 0, CalendarEventType(type), dungeonId,        time_t(eventPackedTime), flags, title, description);    if (calendarEvent->IsGuildEvent() || calendarEvent->IsGuildAnnouncement())        if (Player* creator = ObjectAccessor::FindPlayer(guid))            calendarEvent->SetGuildId(creator->GetGuildId());    if (calendarEvent->IsGuildAnnouncement())    {        // DEFAULT_STATUS_TIME is 01/01/2000 00:00:00 - default response time        CalendarInvite* invite = new CalendarInvite(0, calendarEvent->GetEventId(), 0, guid, DEFAULT_STATUS_TIME, CALENDAR_STATUS_NOT_SIGNED_UP, CALENDAR_RANK_PLAYER, "");        sCalendarMgr->AddInvite(calendarEvent, invite);    }    else    {        for (std::list<CalendarInvitePacketInfo>::const_iterator iter = calendarInviteList.begin(); iter != calendarInviteList.end(); ++iter)        {            // DEFAULT_STATUS_TIME is 01/01/2000 00:00:00 - default response time            CalendarInvite* invite = new CalendarInvite(sCalendarMgr->GetFreeInviteId(), calendarEvent->GetEventId(), (uint64)iter->Guid, guid, DEFAULT_STATUS_TIME, CalendarInviteStatus(iter->Status), CalendarModerationRank(iter->ModerationRank), "");            sCalendarMgr->AddInvite(calendarEvent, invite);        }    }    sCalendarMgr->AddEvent(calendarEvent, CALENDAR_SENDTYPE_ADD);}

// load all events and their related invites from invitevoid CalendarMgr::LoadCalendarsFromDB(){    // in case of reload (not yet implemented)    m_MaxInviteId = 0;    m_MaxEventId = 0;    m_EventStore.clear();    sLog.outString("Loading Calendar Events...");    //                                                          0        1            2        3     4      5          6          7      8    QueryResult* eventsQuery = CharacterDatabase.Query("SELECT eventId, creatorGuid, guildId, type, flags, dungeonId, eventTime, title, description FROM calendar_events ORDER BY eventId");    if (!eventsQuery)    {        BarGoLink bar(1);        bar.step();        sLog.outString();        sLog.outString(">> calendar_events table is empty!");    }    else    {        BarGoLink bar(eventsQuery->GetRowCount());        do        {            Field* field = eventsQuery->Fetch();            bar.step();            uint64 eventId         = field[0].GetUInt64();            CalendarEvent& newEvent = m_EventStore[eventId];            newEvent.EventId       = eventId;            newEvent.CreatorGuid   = ObjectGuid(HIGHGUID_PLAYER, field[1].GetUInt32());            newEvent.GuildId       = field[2].GetUInt32();            newEvent.Type          = CalendarEventType(field[3].GetUInt8());            newEvent.Flags         = field[4].GetUInt32();            newEvent.DungeonId     = field[5].GetInt32();            newEvent.EventTime     = time_t(field[6].GetUInt32());            newEvent.Title         = field[7].GetCppString();            newEvent.Description   = field[8].GetCppString();            m_MaxEventId = std::max(eventId, m_MaxEventId);        }        while (eventsQuery->NextRow());        sLog.outString();        sLog.outString(">> Loaded %u events!", uint32(eventsQuery->GetRowCount()));        delete eventsQuery;    }    sLog.outString("Loading Calendar invites...");    //                                                           0         1        2            3           4       5               6    QueryResult* invitesQuery = CharacterDatabase.Query("SELECT inviteId, eventId, inviteeGuid, senderGuid, status, lastUpdateTime, rank FROM calendar_invites ORDER BY inviteId");    if (!invitesQuery)    {        BarGoLink bar(1);        bar.step();        sLog.outString();        if (m_MaxEventId)                                   // An Event was loaded before        {            // delete all events (no event exist without at least one invite)            m_EventStore.clear();            m_MaxEventId = 0;            CharacterDatabase.DirectExecute("TRUNCATE TABLE calendar_events");            sLog.outString(">> calendar_invites table is empty, cleared calendar_events table!");        }        else            sLog.outString(">> calendar_invite table is empty!");    }    else    {        if (m_MaxEventId)        {            uint64 totalInvites = 0;            uint32 deletedInvites = 0;            BarGoLink bar(invitesQuery->GetRowCount());            do            {                Field* field = invitesQuery->Fetch();                uint64 inviteId             = field[0].GetUInt64();                uint64 eventId              = field[1].GetUInt64();                ObjectGuid inviteeGuid      = ObjectGuid(HIGHGUID_PLAYER, field[2].GetUInt32());                ObjectGuid senderGuid       = ObjectGuid(HIGHGUID_PLAYER, field[3].GetUInt32());                CalendarInviteStatus status = CalendarInviteStatus(field[4].GetUInt8());                time_t lastUpdateTime       = time_t(field[5].GetUInt32());                CalendarModerationRank rank = CalendarModerationRank(field[6].GetUInt8());                CalendarEvent* event = GetEventById(eventId);                if (!event)                {                    // delete invite                    CharacterDatabase.PExecute("DELETE FROM calendar_invites WHERE inviteId =" UI64FMTD, field[0].GetUInt64());                    ++deletedInvites;                    continue;                }                CalendarInvite* invite = new CalendarInvite(event, inviteId, senderGuid, inviteeGuid, lastUpdateTime, status, rank, "");                event->AddInvite(invite);//.........这里部分代码省略.........

void CalendarMgr::LoadFromDB(){    uint32 count = 0;    _maxEventId = 0;    _maxInviteId = 0;    //                                                       0   1        2      3            4     5        6          7      8    if (QueryResult result = CharacterDatabase.Query("SELECT id, creator, title, description, type, dungeon, eventtime, flags, time2 FROM calendar_events"))        do        {            Field* fields = result->Fetch();            uint64 eventId          = fields[0].GetUInt64();            uint64 creatorGUID      = MAKE_NEW_GUID(fields[1].GetUInt32(), 0, HIGHGUID_PLAYER);            std::string title       = fields[2].GetString();            std::string description = fields[3].GetString();            CalendarEventType type  = CalendarEventType(fields[4].GetUInt8());            int32 dungeonId         = fields[5].GetInt32();            uint32 eventTime        = fields[6].GetUInt32();            uint32 flags            = fields[7].GetUInt32();            uint32 timezoneTime     = fields[8].GetUInt32();            uint32 guildId = 0;            if (flags & CALENDAR_FLAG_GUILD_EVENT || flags & CALENDAR_FLAG_WITHOUT_INVITES)                guildId = Player::GetGuildIdFromDB(creatorGUID);            CalendarEvent* calendarEvent = new CalendarEvent(eventId, creatorGUID, guildId, type, dungeonId, time_t(eventTime), flags, time_t(timezoneTime), title, description);            _events.insert(calendarEvent);            _maxEventId = std::max(_maxEventId, eventId);            ++count;        }        while (result->NextRow());    sLog->outInfo(LOG_FILTER_SERVER_LOADING, ">> Loaded %u calendar events", count);    count = 0;    //                                                       0   1      2        3       4       5           6     7    if (QueryResult result = CharacterDatabase.Query("SELECT id, event, invitee, sender, status, statustime, rank, text FROM calendar_invites"))        do        {            Field* fields = result->Fetch();            uint64 inviteId             = fields[0].GetUInt64();            uint64 eventId              = fields[1].GetUInt64();            uint64 invitee              = MAKE_NEW_GUID(fields[2].GetUInt32(), 0, HIGHGUID_PLAYER);            uint64 senderGUID           = MAKE_NEW_GUID(fields[3].GetUInt32(), 0, HIGHGUID_PLAYER);            CalendarInviteStatus status = CalendarInviteStatus(fields[4].GetUInt8());            uint32 statusTime           = fields[5].GetUInt32();            CalendarModerationRank rank = CalendarModerationRank(fields[6].GetUInt8());            std::string text            = fields[7].GetString();            CalendarInvite* invite = new CalendarInvite(inviteId, eventId, invitee, senderGUID, time_t(statusTime), status, rank, text);            _invites[eventId].push_back(invite);            _maxInviteId = std::max(_maxInviteId, inviteId);            ++count;        }        while (result->NextRow());    sLog->outInfo(LOG_FILTER_SERVER_LOADING, ">> Loaded %u calendar invites", count);    for (uint64 i = 1; i < _maxEventId; ++i)        if (!GetEvent(i))            _freeEventIds.push_back(i);    for (uint64 i = 1; i < _maxInviteId; ++i)        if (!GetInvite(i))            _freeInviteIds.push_back(i);}

void CalendarMgr::LoadFromDB(){    uint32 oldMSTime = getMSTime();    uint32 count = 0;    _maxEventId = 0;    _maxInviteId = 0;    //                                                       0   1        2      3            4     5        6          7      8    if (QueryResult result = CharacterDatabase.Query("SELECT id, creator, title, description, type, dungeon, eventtime, flags, time2 FROM calendar_events"))        do        {            Field* fields = result->Fetch();            uint64 eventId          = fields[0].GetUInt64();            ObjectGuid creatorGUID  = ObjectGuid(HighGuid::Player, fields[1].GetUInt32());            std::string title       = fields[2].GetString();            std::string description = fields[3].GetString();            CalendarEventType type  = CalendarEventType(fields[4].GetUInt8());            int32 dungeonId         = fields[5].GetInt32();            uint32 eventTime        = fields[6].GetUInt32();            uint32 flags            = fields[7].GetUInt32();            uint32 timezoneTime     = fields[8].GetUInt32();            ObjectGuid::LowType guildId = 0;            if (flags & CALENDAR_FLAG_GUILD_EVENT || flags & CALENDAR_FLAG_WITHOUT_INVITES)                guildId = sCharacterCache->GetCharacterGuildIdByGuid(creatorGUID);            CalendarEvent* calendarEvent = new CalendarEvent(eventId, creatorGUID, guildId, type, dungeonId, time_t(eventTime), flags, time_t(timezoneTime), title, description);            _events.insert(calendarEvent);            _maxEventId = std::max(_maxEventId, eventId);            ++count;        }        while (result->NextRow());    TC_LOG_INFO("server.loading", ">> Loaded %u calendar events in %u ms", count, GetMSTimeDiffToNow(oldMSTime));    count = 0;    oldMSTime = getMSTime();    //                                                       0   1      2        3       4       5            6      7    if (QueryResult result = CharacterDatabase.Query("SELECT id, event, invitee, sender, status, statustime, `rank`, text FROM calendar_invites"))        do        {            Field* fields = result->Fetch();            uint64 inviteId             = fields[0].GetUInt64();            uint64 eventId              = fields[1].GetUInt64();            ObjectGuid invitee          = ObjectGuid(HighGuid::Player, fields[2].GetUInt32());            ObjectGuid senderGUID       = ObjectGuid(HighGuid::Player, fields[3].GetUInt32());            CalendarInviteStatus status = CalendarInviteStatus(fields[4].GetUInt8());            uint32 statusTime           = fields[5].GetUInt32();            CalendarModerationRank rank = CalendarModerationRank(fields[6].GetUInt8());            std::string text            = fields[7].GetString();            CalendarInvite* invite = new CalendarInvite(inviteId, eventId, invitee, senderGUID, time_t(statusTime), status, rank, text);            _invites[eventId].push_back(invite);            _maxInviteId = std::max(_maxInviteId, inviteId);            ++count;        }        while (result->NextRow());    TC_LOG_INFO("server.loading", ">> Loaded %u calendar invites in %u ms", count, GetMSTimeDiffToNow(oldMSTime));    for (uint64 i = 1; i < _maxEventId; ++i)        if (!GetEvent(i))            _freeEventIds.push_back(i);    for (uint64 i = 1; i < _maxInviteId; ++i)        if (!GetInvite(i))            _freeInviteIds.push_back(i);}

void CalendarMgr::LoadFromDB(){    Log.Notice("CalendarMgr", "Start loading calendar_events");    {        const char* loadCalendarEvents = "SELECT entry, creator, title, description, type, dungeon, date, flags FROM calendar_events";        bool success = false;        QueryResult* result = CharacterDatabase.Query(&success, loadCalendarEvents);        if (!success)        {            Log.Error("CalendarMgr", "Query failed: %s", loadCalendarEvents);            return;        }        if (result)        {            uint32 count = 0;            do            {                Field* fields = result->Fetch();                uint64 entry = fields[0].GetUInt32();                uint32 creator = fields[1].GetUInt32();                std::string title = fields[2].GetString();                std::string description = fields[3].GetString();                CalendarEventType type = CalendarEventType(fields[4].GetUInt32());                uint32 dungeon = fields[5].GetUInt32();                time_t date = fields[6].GetUInt32();                uint32 flags = fields[7].GetUInt32();                CalendarEvent* calendarEvent = new CalendarEvent(entry, creator, title, description, type, dungeon, time_t(date), flags);                _events.insert(calendarEvent);                Log.Debug("CalendarMgr", "Title %s loaded", calendarEvent->title.c_str()); // remove me ;-)                ++count;            }            while (result->NextRow());            delete result;            Log.Success("CalendarMgr", "%u calendar events loaded from table calendar_events", count);        }    }    Log.Notice("CalendarMgr", "Start loading calendar_invites");    {        const char* loadCalendarInvites = "SELECT id, event, invitee, sender, status, statustime, rank, text FROM calendar_invites";        bool success = false;        QueryResult* result = CharacterDatabase.Query(&success, loadCalendarInvites);        if (!success)        {            Log.Debug("CalendarMgr", "Query failed: %s", loadCalendarInvites);            return;        }        if (result)        {            uint32 count = 0;            do            {                Field* fields = result->Fetch();                uint32 invite_id = fields[0].GetUInt32();       // unique invite id                uint32 event = fields[1].GetUInt32();           // entry of the calendar event                uint32 invitee = fields[2].GetUInt32();         // player id                uint32 sender = fields[3].GetUInt32();          // player id                CalendarInviteStatus status = CalendarInviteStatus(fields[4].GetUInt32());                time_t statustime = fields[5].GetUInt32();                uint32 rank = fields[6].GetUInt32();                std::string text = fields[7].GetString();                CalendarInvite* invite = new CalendarInvite(invite_id, event, invitee, sender, status, time_t(statustime), rank, text);                _invites[event].push_back(invite);                ++count;            }            while (result->NextRow());            delete result;            Log.Success("CalendarMgr", "Loaded %u calendar invites", count);        }    }}