Index: 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);