diff options
author | Shauren <shauren.trinity@gmail.com> | 2019-11-01 16:20:15 +0100 |
---|---|---|
committer | Shauren <shauren.trinity@gmail.com> | 2019-11-01 16:20:15 +0100 |
commit | 2072258ef44e89e30256d529686ae2b8dc2b5f0d (patch) | |
tree | 5f98ad5a82bea99456b7d3772bdf775dfa4311c4 /src/server/game/Instances/InstanceSaveMgr.cpp | |
parent | 00656713161a511ffe0ce622f28575cf03ff2bf9 (diff) |
Core/DBLayer: Escape mysql 8 keywords
Diffstat (limited to 'src/server/game/Instances/InstanceSaveMgr.cpp')
-rw-r--r-- | src/server/game/Instances/InstanceSaveMgr.cpp | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/server/game/Instances/InstanceSaveMgr.cpp b/src/server/game/Instances/InstanceSaveMgr.cpp index 26e1415fa85..e4e93f77915 100644 --- a/src/server/game/Instances/InstanceSaveMgr.cpp +++ b/src/server/game/Instances/InstanceSaveMgr.cpp @@ -286,7 +286,7 @@ void InstanceSaveManager::LoadInstances() // Delete invalid character_instance and group_instance references CharacterDatabase.DirectExecute("DELETE ci.* FROM character_instance AS ci LEFT JOIN characters AS c ON ci.guid = c.guid WHERE c.guid IS NULL"); - CharacterDatabase.DirectExecute("DELETE gi.* FROM group_instance AS gi LEFT JOIN groups AS g ON gi.guid = g.guid WHERE g.guid IS NULL"); + CharacterDatabase.DirectExecute("DELETE gi.* FROM group_instance AS gi LEFT JOIN `groups` AS g ON gi.guid = g.guid WHERE g.guid IS NULL"); // Delete invalid instance references CharacterDatabase.DirectExecute("DELETE i.* FROM instance AS i LEFT JOIN character_instance AS ci ON i.id = ci.instance LEFT JOIN group_instance AS gi ON i.id = gi.instance WHERE ci.guid IS NULL AND gi.guid IS NULL"); |