vSro Guild Limit Ayarlama = ornek query 24 e ayarlidir..

Konuyu başlatan #1
Katılım
15 Ara 2018
Mesajlar
58
Beğeniler
2
Konum
İstanbul
Herkese Merhaba Arkadaslar Paylasmis oldugum Query 24kisiye ayarlidir.. (
as
Declare @Limit int = '24' -- <
if (exists (select CharID from _GuildMember where CharID = @memberID))
begin
return -1001
end) yazan kisimdaki 24 ile ayarliyabilirsiniz hepinize bol sans bol kazanclar






USE
[SRO_VT_SHARD]
/****** Object: StoredProcedure [dbo].[_Guild_FnAddMember] Script Date: 15.06.2014 11:08:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
















ALTER PROCEDURE [dbo].[_Guild_FnAddMember]
@guildID int,
@memberID int,
@memberClass tinyint,
@joinDate smalldatetime,
@permission int

as
Declare @Limit int = '24' -- <
if (exists (select CharID from _GuildMember where CharID = @memberID))
begin
return -1001
end








declare @memberName varchar(64)
declare @curLevel tinyint
select @memberName = CharName16, @curLevel = CurLevel from _Char with (nolock) where CharID = @memberID
if (@@error <> 0 or @@rowcount = 0)
begin
return -1
end
if (exists (select CharID from _GuildMember with (nolock) where GuildID = @guildID and CharID = @memberID))
begin
return -2
end

declare @refObjID int
select @refObjID = RefObjID from _Char with (nolock) where CharID = @memberID

if (@@error <> 0 or @@rowcount = 0)
begin
return -5
end
























declare @siegeAuthority tinyint
set @siegeAuthority = 0








if @memberClass = 0 -- ±æ¸¶ÀÌ¸é °ø¼º±ÇÇÑÀ» commander·Î ¼¼ÆÃ! ±× ¿Ü´Â ÀϹY member·Î ¼¼ÆÃÇÑ´Ù.
begin
set @siegeAuthority = 1
end
Declare @GC int = (Select COUNT(*) from _GuildMember where GuildID = @guildID )
if @GC <= @LiMiT begin
insert _GuildMember values (@guildID , @memberID, @memberName, @memberClass, @curLevel, 0, @joinDate, @permission, 0, 0, 0, null, @refObjID, @siegeAuthority)
end
if (@@error <> 0 or @@rowcount = 0)
begin
return -3
end

if @GC <= @LiMiT begin
update _Char Set GuildID = @guildID where CharID = @memberID
end
if (@@error <> 0 or @@rowcount = 0)
begin
return -4
end
return 1
 
Üst