Vsro Kod Paylaşım Yeni Açılan Guildleri 5 Level Olarak Başlatmak (1 Viewer)

USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
—
ALTER PROCEDURE [dbo].[_Guild_Create]
@guildName varchar(64),
@createrID int
as
if (exists (select id from _Guild where Name = @guildName))
begin
return -1000
end
if (exists (select CharID from _GuildMember where CharID = @createrID))
begin
return -1001
end
begin transaction
declare @guildID int
declare @FoundationDate smalldatetime
set @FoundationDate = GetDate()
insert _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) values @guildName, 5, 123456, @FoundationDate,0,0)
set @guildID = @@identity
if (@@error <> 0 or @@rowcount = 0 or @guildID = 0)
begin
rollback transaction
return -5
end
–???? ???? 0xffffffff !!
declare @rvalue int
exec @rvalue = _Guild_FnAddMember @guildID, @createrID, 0, @FoundationDate,0xffffffff
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
— ?? ??? ????
exec @rvalue = _Guild_CreateChest_NoTX @guildID
if (@@error <> 0 or @rvalue <= 0)
begin
rollback transaction
return @rvalue
end
commit transaction
return @guildID