Guild House Renewal Bug

[NGxBing]

Escuse me, Does anyone know how to fix the guild house renewal error that is in every basic source, which does not allow the user to renew their guild house after it has expired but instead it says "Please, try again later!" when you click pay maintenance fee. If anyone is aware of how to fix this in the source, please help me out.

Thankayou in advance! ^_^

 

[Cait]

I had that befor.. this is how I fixed it..

Delete
"CHARACTER_O1_DBF > Programmability > Stored Procedures -> dbo.usp_GuildHouse_Update.
Then make a New Query like this:

USE [CHARACTER_01_DBF]
GO
CREATE  proc [dbo].[usp_GuildHouse_Update]
	@serverindex char(2),
	@m_idGuild char(6), 
	@tKeepTime int
as

set nocount on
set xact_abort on

	if exists ( select * from tblGuildHouse (nolock) where serverindex = @serverindex and m_idGuild = @m_idGuild)
	begin
		update tblGuildHouse
		set tKeepTime = @tKeepTime
		where serverindex = @serverindex and m_idGuild = @m_idGuild
	end
GO

Hit [! Execute] and its done.

Credits to ShadowDragon42..

 

[NGxBing]

Thankayou for this information, it worked perfectly. ^_^ tt1: