Skip to content

Bug: table arena_team_member does not have column 'type' #63

@chaosua

Description

@chaosua

Current Behaviour

arena_team_member does not have column 'type'. This column is in arena_team
but in SQL request in npc_arena1v1.cpp function void deleteTeamArenaForPlayer(Player* player) we have
CharacterDatabase.Execute("DELETE FROM arena_team_member WHERE guid={} AND type=1", player->GetGUID().GetCounter());

Expected Behaviour

CharacterDatabase.Execute("DELETE FROM arena_team_member WHERE guid={} ", player->GetGUID().GetCounter());

Steps to reproduce the problem

https://github.com/azerothcore/mod-1v1-arena/blob/master/src/npc_arena1v1.cpp look there

void deleteTeamArenaForPlayer(Player* player)
{
QueryResult queryPlayerTeam = CharacterDatabase.Query("SELECT arenaTeamId FROM arena_team WHERE captainGuid={} AND type=1", player->GetGUID().GetCounter());
if (queryPlayerTeam)
{
CharacterDatabase.Execute("DELETE FROM arena_team WHERE captainGuid={} AND type=1", player->GetGUID().GetCounter());
CharacterDatabase.Execute("DELETE FROM arena_team_member WHERE guid={} AND **type**=1", player->GetGUID().GetCounter());
}
}

Extra Notes

No response

AC rev. hash/commit

80220f9178fd8d2a5c1a261ee42b2bf4584bbe89

Operating system

Windows 10

Custom changes or Modules

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions