summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorKenpachi Developer <Kenpachi.Developer@gmx.de>2020-07-06 13:51:16 +0200
committerKenpachi Developer <Kenpachi.Developer@gmx.de>2020-07-06 13:51:16 +0200
commitf2d7f16d0e4162afa2dd32d1bab4e76550d8ca59 (patch)
treee667c289b4ad8537e7f6358436df53e5b6c4793d /src
parent1dfebbd4966310387357cbddae600418a56df658 (diff)
downloadhercules-f2d7f16d0e4162afa2dd32d1bab4e76550d8ca59.tar.gz
hercules-f2d7f16d0e4162afa2dd32d1bab4e76550d8ca59.tar.bz2
hercules-f2d7f16d0e4162afa2dd32d1bab4e76550d8ca59.tar.xz
hercules-f2d7f16d0e4162afa2dd32d1bab4e76550d8ca59.zip
Update SQL query in char_change_sex_sub() to update character's gender and robe view ID, too
Diffstat (limited to 'src')
-rw-r--r--src/char/char.c10
1 files changed, 8 insertions, 2 deletions
diff --git a/src/char/char.c b/src/char/char.c
index c61b6107a..04a72fb6b 100644
--- a/src/char/char.c
+++ b/src/char/char.c
@@ -2566,9 +2566,15 @@ static void char_change_sex_sub(int sex, int acc, int char_id, int class, int gu
if (SQL_ERROR == SQL->Query(inter->sql_handle, "UPDATE `%s` SET `equip`='0' WHERE `char_id`='%d'", inventory_db, char_id))
Sql_ShowDebug(inter->sql_handle);
+#if PACKETVER >= 20141016
+ char gender = (sex == SEX_MALE) ? 'M' : ((sex == SEX_FEMALE) ? 'F' : 'U');
+#else
+ char gender = 'U';
+#endif
+
if (SQL_ERROR == SQL->Query(inter->sql_handle, "UPDATE `%s` SET `class`='%d', `weapon`='0', `shield`='0', "
- "`head_top`='0', `head_mid`='0', `head_bottom`='0' WHERE `char_id`='%d'",
- char_db, class, char_id))
+ "`head_top`='0', `head_mid`='0', `head_bottom`='0', `robe`='0', `sex`='%c' "
+ "WHERE `char_id`='%d' ", char_db, class, gender, char_id))
Sql_ShowDebug(inter->sql_handle);
if (guild_id) // If there is a guild, update the guild_member data [Skotlex]
inter_guild->sex_changed(guild_id, acc, char_id, sex);