From 17d49e6f6d6cd11d75bd40fb7f578536f19f8f3b Mon Sep 17 00:00:00 2001 From: skotlex Date: Thu, 14 Sep 2006 18:39:18 +0000 Subject: - Likely fixed "half" of the alliance being saved, which ends up in guilds that can attack another, but not viceversa. git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@8761 54d463be-8e91-2dee-dedb-b68131a5f0ec --- src/char_sql/int_guild.c | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) (limited to 'src/char_sql/int_guild.c') diff --git a/src/char_sql/int_guild.c b/src/char_sql/int_guild.c index 1d190300a..af302346b 100644 --- a/src/char_sql/int_guild.c +++ b/src/char_sql/int_guild.c @@ -294,8 +294,12 @@ int inter_guild_tosql(struct guild *g,int flag) if (flag&GS_ALLIANCE) { - // Delete current alliances - sprintf(tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d' OR `alliance_id`='%d'",guild_alliance_db, g->guild_id,g->guild_id); + // Delete current alliances + // NOTE: no need to do it on both sides since both guilds in memory had + // their info changed, not to mention this would also mess up oppositions! + // [Skotlex] +// sprintf(tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d' OR `alliance_id`='%d'",guild_alliance_db, g->guild_id,g->guild_id); + sprintf(tmp_sql, "DELETE FROM `%s` WHERE `guild_id`='%d'",guild_alliance_db, g->guild_id); if(mysql_query(&mysql_handle, tmp_sql) ) { ShowSQL("DB error - %s\n",mysql_error(&mysql_handle)); -- cgit v1.2.3-60-g2f50