Citação:
CREATE Procedure [dbo].[WZ_SetGuildRei]
@Account varchar(10),
@Name varchar(10),
@Guild varchar(8)
AS
BEGIN
SET NOCOUNT ON
SET XACT_ABORT ON
UPDATE Guild set Owner = 0 where Owner = 1
UPDATE Guild set Owner = 1, Owner_count = Owner_count + 1 where G_Name = @Guild
UPDATE guildmember set Event_Count = Event_Count +1 where Name = @Name and g_name= @Guild
UPDATE character set eventos=eventos+1, eventos_semanal=eventos_semanal+1, eventos_mensal=eventos_mensal+1, exp_war=exp_war+0 where name=@Name
--INSERT INTO MK_Murkut_News ( nome,valor,tipo ) values (@Name,'1','14')
--INSERT INTO LOG_REI_MK ( login,name,guild) values (@Account,@Name,@Guild)
SET NOCOUNT OFF
SET XACT_ABORT OFF
END
SET NOCOUNT OFF