From 2bf8110032e84796f21d4d44d72e33abc58a4e1e Mon Sep 17 00:00:00 2001
From: Shauren <shauren.trinity@gmail.com>
Date: Sat, 2 Oct 2021 21:46:58 +0200
Subject: Core/Players: Do not show zone on character list before first login

---
 sql/updates/characters/master/2021_10_02_01_characters.sql | 1 +
 1 file changed, 1 insertion(+)
 create mode 100644 sql/updates/characters/master/2021_10_02_01_characters.sql

(limited to 'sql/updates')

diff --git a/sql/updates/characters/master/2021_10_02_01_characters.sql b/sql/updates/characters/master/2021_10_02_01_characters.sql
new file mode 100644
index 00000000000..e4c6a5e83b0
--- /dev/null
+++ b/sql/updates/characters/master/2021_10_02_01_characters.sql
@@ -0,0 +1 @@
+UPDATE `characters` SET `zone`=0 WHERE (`at_login` & 0x20) != 0;
-- 
cgit v1.2.3