14-12-2017, 02:41 AM
|
#14
|
|
• الانـتـسـاب » May 2010
|
• رقـم العـضـويـة » 71047
|
• المشـــاركـات » 1,604
|
• الـدولـة » المــــــــــــنصورة
|
• الـهـوايـة » 1337
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 445
|
|
|
رد: Union fix
استخدم القوري
دا
اقتباس:
USE [SRO_VT_SHARD]
GO
/****** 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' -- << Userr Limit Credits by GhaiBoba
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
|
|
|
التعديل الأخير تم بواسطة GhaiBoba ; 14-12-2017 الساعة 02:47 AM
|