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

void WorldSession::HandleCalendarEventModeratorStatus(WorldPacket& recv_data){    ObjectGuid guid = _player->GetObjectGuid();    DEBUG_LOG("WORLD: CMSG_CALENDAR_EVENT_MODERATOR_STATUS [%u]", guid.GetCounter());    ObjectGuid invitee;    ObjectGuid eventId;    ObjectGuid inviteId;    ObjectGuid ownerInviteId; // isn't it sender's inviteId?    uint32 rank;    recv_data >> invitee.ReadAsPacked();    recv_data >> eventId >>  inviteId >> ownerInviteId >> rank;    DEBUG_FILTER_LOG(LOG_FILTER_CALENDAR, "WorldSession::HandleCalendarEventModeratorStatus [%u] EventId [%u] ownerInviteId [%u], Invitee ([%u] id: [%u], rank %u",        guid.GetCounter(), eventId.GetCounter(), ownerInviteId.GetCounter(), invitee.GetCounter(), inviteId.GetCounter(), rank);    if (CalendarEvent* calendarEvent = sCalendarMgr.GetEventById(eventId))    {        if (CalendarInvite* invite = calendarEvent->GetInviteById(inviteId))        {            if (invite->InviteeGuid != guid)            {                CalendarInvite* updaterInvite = calendarEvent->GetInviteByGuid(guid);                if (updaterInvite == NULL)                {                    sCalendarMgr.SendCalendarCommandResult(guid, CALENDAR_ERROR_NOT_INVITED);                    return ;                }                if (updaterInvite->Rank != CALENDAR_RANK_MODERATOR && updaterInvite->Rank != CALENDAR_RANK_OWNER)                {                    // remover have not enough right to change invite status                    sCalendarMgr.SendCalendarCommandResult(guid, CALENDAR_ERROR_PERMISSIONS);                    return;                }            }            if (CalendarModerationRank(rank) == CALENDAR_RANK_OWNER)            {                 // cannot set owner                 sCalendarMgr.SendCalendarCommandResult(guid, CALENDAR_ERROR_PERMISSIONS);                 return;            }            invite->RemoveFlag(CALENDAR_STATE_FLAG_SAVED);            invite->AddFlag(CALENDAR_STATE_FLAG_UPDATED);            invite->Rank = CalendarModerationRank(rank);            sCalendarMgr.SendCalendarEventModeratorStatusAlert(invite);        }        else            sCalendarMgr.SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_INVITE);    }    else        sCalendarMgr.SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventModeratorStatus(WorldPacket& recv_data){    ObjectGuid guid = _player->GetObjectGuid();    DEBUG_LOG("WORLD: Received opcode CMSG_CALENDAR_EVENT_MODERATOR_STATUS [%s]", guid.GetString().c_str());    ObjectGuid invitee;    uint64 eventId;    uint64 inviteId;    uint64 ownerInviteId; // isn't it sender's inviteId?    uint32 rank;    recv_data >> invitee.ReadAsPacked();    recv_data >> eventId >>  inviteId >> ownerInviteId >> rank;    DEBUG_FILTER_LOG(LOG_FILTER_CALENDAR, "EventId [" UI64FMTD "] ownerInviteId [" UI64FMTD "], Invitee ([%s] id: [" UI64FMTD "], rank %u",                     eventId, ownerInviteId, invitee.GetString().c_str(), inviteId, rank);    if (CalendarEvent* event = sCalendarMgr.GetEventById(eventId))    {        if (CalendarInvite* invite = event->GetInviteById(inviteId))        {            if (invite->InviteeGuid != guid)            {                CalendarInvite* updaterInvite = event->GetInviteByGuid(guid);                if (updaterInvite == nullptr)                {                    sCalendarMgr.SendCalendarCommandResult(_player, CALENDAR_ERROR_NOT_INVITED);                    return ;                }                if (updaterInvite->Rank != CALENDAR_RANK_MODERATOR && updaterInvite->Rank != CALENDAR_RANK_OWNER)                {                    // remover have not enough right to change invite status                    sCalendarMgr.SendCalendarCommandResult(_player, CALENDAR_ERROR_PERMISSIONS);                    return;                }            }            if (CalendarModerationRank(rank) == CALENDAR_RANK_OWNER)            {                // cannot set owner                sCalendarMgr.SendCalendarCommandResult(_player, CALENDAR_ERROR_PERMISSIONS);                return;            }            CharacterDatabase.PExecute("UPDATE calendar_invites SET rank = %u WHERE inviteId=" UI64FMTD, rank, invite->InviteId);            invite->Rank = CalendarModerationRank(rank);            sCalendarMgr.SendCalendarEventModeratorStatusAlert(invite);        }        else            sCalendarMgr.SendCalendarCommandResult(_player, CALENDAR_ERROR_NO_INVITE);    }    else        sCalendarMgr.SendCalendarCommandResult(_player, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventModeratorStatus(WorldPacket& recvData){    uint64 guid = _player->GetGUID();    uint64 invitee;    uint64 eventId;    uint64 inviteId;    uint64 ownerInviteId; // isn't it sender's inviteId?    uint8 rank;    recvData.readPackGUID(invitee);    recvData >> eventId >>  inviteId >> ownerInviteId >> rank;    sLog->outDebug(LOG_FILTER_NETWORKIO, "CMSG_CALENDAR_EVENT_MODERATOR_STATUS [" UI64FMTD "] EventId ["        UI64FMTD "] ownerInviteId [" UI64FMTD "], Invitee ([" UI64FMTD "] id: ["        UI64FMTD "], rank %u", guid, eventId, ownerInviteId, invitee, inviteId, rank);    if (CalendarEvent* calendarEvent = sCalendarMgr->GetEvent(eventId))    {        if (CalendarInvite* invite = sCalendarMgr->GetInvite(inviteId))        {            invite->SetRank(CalendarModerationRank(rank));            sCalendarMgr->UpdateInvite(invite);            sCalendarMgr->SendCalendarEventModeratorStatusAlert(*calendarEvent, *invite);        }        else            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_INVITE); // correct?    }    else        sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventModeratorStatus(WorldPacket& recvData){    ObjectGuid guid = _player->GetGUID();    ObjectGuid invitee;    uint64 eventId;    uint64 inviteId;    uint64 ownerInviteId; // isn't it sender's inviteId?    uint8 rank;    recvData >> invitee.ReadAsPacked();    recvData >> eventId >> inviteId >> ownerInviteId >> rank;    TC_LOG_DEBUG("network", "CMSG_CALENDAR_EVENT_MODERATOR_STATUS [%s] EventId ["        UI64FMTD "] ownerInviteId [" UI64FMTD "], Invitee ([%s] id: ["        UI64FMTD "], rank %u", guid.ToString().c_str(), eventId, ownerInviteId, invitee.ToString().c_str(), inviteId, rank);    if (CalendarEvent* calendarEvent = sCalendarMgr->GetEvent(eventId))    {        if (CalendarInvite* invite = sCalendarMgr->GetInvite(inviteId))        {            invite->SetRank(CalendarModerationRank(rank));            sCalendarMgr->UpdateInvite(invite);            sCalendarMgr->SendCalendarEventModeratorStatusAlert(*calendarEvent, *invite);        }        else            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_INVITE); // correct?    }    else        sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventModeratorStatus(WorldPacket& recvData){    uint64 guid = _player->GetGUID();    uint64 invitee;    uint64 eventId;    uint64 inviteId;    uint64 ownerInviteId; // isn't it sender's inviteId?    uint8 rank;    recvData.readPackGUID(invitee);    recvData >> eventId >>  inviteId >> ownerInviteId >> rank;    if (CalendarEvent* calendarEvent = sCalendarMgr->GetEvent(eventId))    {        if (CalendarInvite* invite = sCalendarMgr->GetInvite(inviteId))        {            invite->SetRank(CalendarModerationRank(rank));            sCalendarMgr->UpdateInvite(invite);            sCalendarMgr->SendCalendarEventModeratorStatusAlert(*calendarEvent, *invite);        }        else            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_INVITE); // correct?    }    else        sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

void WorldSession::HandleCalendarEventModeratorStatus(WorldPacket& recvData){    uint64 guid = _player->GetGUID();    ObjectGuid invitee;    uint64 eventId;    uint64 inviteId;    uint64 senderId;    uint8 rank;    recvData >> rank >> eventId >> senderId >> inviteId;    invitee[6] = recvData.ReadBit();    invitee[5] = recvData.ReadBit();    invitee[1] = recvData.ReadBit();    invitee[3] = recvData.ReadBit();    invitee[4] = recvData.ReadBit();    invitee[7] = recvData.ReadBit();    invitee[0] = recvData.ReadBit();    invitee[2] = recvData.ReadBit();    recvData.ReadByteSeq(invitee[7]);    recvData.ReadByteSeq(invitee[5]);    recvData.ReadByteSeq(invitee[0]);    recvData.ReadByteSeq(invitee[4]);    recvData.ReadByteSeq(invitee[1]);    recvData.ReadByteSeq(invitee[3]);    recvData.ReadByteSeq(invitee[2]);    recvData.ReadByteSeq(invitee[6]);    TC_LOG_DEBUG("network", "CMSG_CALENDAR_EVENT_MODERATOR_STATUS [" UI64FMTD "] EventId ["        UI64FMTD "] senderId [" UI64FMTD "], Invitee ([" UI64FMTD "] id: ["        UI64FMTD "], rank %u", guid, eventId, senderId, (uint64)invitee, inviteId, rank);    if (CalendarEvent* calendarEvent = sCalendarMgr->GetEvent(eventId))    {        if (calendarEvent->IsGuildEvent())        {            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_MODERATOR);            return;        }        if (CalendarInvite* invite = sCalendarMgr->GetInvite(inviteId))        {            invite->SetRank(CalendarModerationRank(rank));            sCalendarMgr->UpdateInvite(invite);            sCalendarMgr->SendCalendarEventModeratorStatus(*calendarEvent, *invite);        }        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::HandleCalendarEventModeratorStatus(WorldPackets::Calendar::CalendarEventModeratorStatus& calendarEventModeratorStatus){    ObjectGuid guid = _player->GetGUID();    TC_LOG_DEBUG("network", "CMSG_CALENDAR_EVENT_MODERATOR_STATUS [%s] EventID ["        UI64FMTD "] ModeratorID [" UI64FMTD "], Invitee ([%s] InviteID: ["        UI64FMTD "], Status %u", guid.ToString().c_str(), calendarEventModeratorStatus.EventID, calendarEventModeratorStatus.ModeratorID, calendarEventModeratorStatus.Guid.ToString().c_str(), calendarEventModeratorStatus.InviteID, calendarEventModeratorStatus.Status);    if (CalendarEvent* calendarEvent = sCalendarMgr->GetEvent(calendarEventModeratorStatus.EventID))    {        if (CalendarInvite* invite = sCalendarMgr->GetInvite(calendarEventModeratorStatus.InviteID))        {            invite->SetRank(CalendarModerationRank(calendarEventModeratorStatus.Status));            sCalendarMgr->UpdateInvite(invite);            sCalendarMgr->SendCalendarEventModeratorStatusAlert(*calendarEvent, *invite);        }        else            sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_NO_INVITE); // correct?    }    else        sCalendarMgr->SendCalendarCommandResult(guid, CALENDAR_ERROR_EVENT_INVALID);}

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 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(){    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 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);//.........这里部分代码省略.........