rendered paste bodyIndex: src/game/Guild.cpp===================================================================--- src/game/Guild.cpp (revision 2554)+++ src/game/Guild.cpp (working copy)@@ -692,7 +692,7 @@ pMember->m_loggedInPlayer->SetGuildRank(r->iId); } - CharacterDatabase.Execute("INSERT INTO guild_data VALUES(%u, %u, %u, '', '', 0, 0, 0, 0)", m_guildId, pMember->guid, r->iId);+ CharacterDatabase.Execute("INSERT INTO guild_data VALUES(%u, %u, %u, '', '', 0, 0, 0, 0,0)", m_guildId, pMember->guid, r->iId); LogGuildEvent(GUILD_EVENT_JOINED, 1, pMember->name); AddGuildLogEntry(GUILD_LOG_EVENT_JOIN, 1, pMember->guid); m_lock.Release();@@ -1168,7 +1168,7 @@ m_bankTabCount++; CharacterDatabase.Execute("INSERT INTO guild_banktabs VALUES(%u, %u, '', '')", m_guildId, (uint32)pTab->iTabId);- CharacterDatabase.Execute("UPDATE guilds SET bankTabCount = %u WHERE guildId = %u", (uint32)pTab->iTabId, m_guildId);+ CharacterDatabase.Execute("UPDATE guilds SET bankTabCount = %u WHERE guildId = %u", (uint32)pTab->iTabId+1, m_guildId); m_lock.Release(); } @@ -1281,6 +1282,9 @@ // subtract the balance m_bankBalance -= uAmount; + // update in db+ CharacterDatabase.Execute("UPDATE guilds SET bankBalance = %u WHERE guildId = %u", m_bankBalance, m_guildId);+ // notify everyone with the new balance char buf[20]; snprintf(buf, 20, I64FMT, (uint64)m_bankBalance);