From 2b5634faa20cdac69f94ba5abd4ea3fca8c44c2d Mon Sep 17 00:00:00 2001 From: zephyrus Date: Tue, 2 Sep 2008 21:18:33 +0000 Subject: - Fixed problem deleting characters. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@13186 54d463be-8e91-2dee-dedb-b68131a5f0ec --- src/char_sql/char.c | 16 +++++++--------- src/char_sql/int_mercenary.c | 6 +++--- 2 files changed, 10 insertions(+), 12 deletions(-) (limited to 'src') diff --git a/src/char_sql/char.c b/src/char_sql/char.c index 52572fa88..93a7563d2 100644 --- a/src/char_sql/char.c +++ b/src/char_sql/char.c @@ -1297,11 +1297,11 @@ int delete_char_sql(int char_id) { char name[NAME_LENGTH]; char esc_name[NAME_LENGTH*2+1]; //Name needs be escaped. - int account_id, party_id, guild_id, hom_id, mer_id, base_level, partner_id, father_id, mother_id; + int account_id, party_id, guild_id, hom_id, base_level, partner_id, father_id, mother_id; char* data; size_t len; - if( SQL_ERROR == Sql_Query(sql_handle, "SELECT `name`,`account_id`,`party_id`,`guild_id`,`base_level`,`homun_id`,`mer_id`,`partner_id`,`father`,`mother` FROM `%s` WHERE `char_id`='%d'", char_db, char_id) ) + if( SQL_ERROR == Sql_Query(sql_handle, "SELECT `name`,`account_id`,`party_id`,`guild_id`,`base_level`,`homun_id`,`partner_id`,`father`,`mother` FROM `%s` WHERE `char_id`='%d'", char_db, char_id) ) Sql_ShowDebug(sql_handle); if( SQL_SUCCESS != Sql_NextRow(sql_handle) ) @@ -1317,10 +1317,9 @@ int delete_char_sql(int char_id) Sql_GetData(sql_handle, 3, &data, NULL); guild_id = atoi(data); Sql_GetData(sql_handle, 4, &data, NULL); base_level = atoi(data); Sql_GetData(sql_handle, 5, &data, NULL); hom_id = atoi(data); - Sql_GetData(sql_handle, 6, &data, NULL); mer_id = atoi(data); - Sql_GetData(sql_handle, 7, &data, NULL); partner_id = atoi(data); - Sql_GetData(sql_handle, 8, &data, NULL); father_id = atoi(data); - Sql_GetData(sql_handle, 9, &data, NULL); mother_id = atoi(data); + Sql_GetData(sql_handle, 6, &data, NULL); partner_id = atoi(data); + Sql_GetData(sql_handle, 7, &data, NULL); father_id = atoi(data); + Sql_GetData(sql_handle, 8, &data, NULL); mother_id = atoi(data); Sql_EscapeStringLen(sql_handle, esc_name, name, min(len, NAME_LENGTH)); Sql_FreeResult(sql_handle); @@ -1374,9 +1373,8 @@ int delete_char_sql(int char_id) /* remove homunculus */ if( hom_id ) mapif_homunculus_delete(hom_id); - /* remove mercenary */ - if( mer_id ) - mapif_mercenary_delete(mer_id); + + /* remove mercenary data */ mercenary_owner_delete(char_id); /* delete char's friends list */ diff --git a/src/char_sql/int_mercenary.c b/src/char_sql/int_mercenary.c index 8658707f5..b6c4d6313 100644 --- a/src/char_sql/int_mercenary.c +++ b/src/char_sql/int_mercenary.c @@ -58,10 +58,10 @@ bool mercenary_owner_tosql(int char_id, struct mmo_charstatus *status) bool mercenary_owner_delete(int char_id) { if( SQL_ERROR == Sql_Query(sql_handle, "DELETE FROM `mercenary_owner` WHERE `char_id` = '%d'", char_id) ) - { Sql_ShowDebug(sql_handle); - return false; - } + + if( SQL_ERROR == Sql_Query(sql_handle, "DELETE FROM `mercenary` WHERE `char_id` = '%d'", char_id) ) + Sql_ShowDebug(sql_handle); return true; } -- cgit v1.2.3-70-g09d2