-
Notifications
You must be signed in to change notification settings - Fork 57
Description
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