Hello, I think the due help me for the guild. Create a guild and do not privileges as leader. How can I fix the problem?
FN_GetGuildCode
/************************************************** ****************************
이 름 : FN_GetGuildCode
설 명 : character_name을 입력하면 guild_code를 반환한다.
반환값 : Guild_info.Guild_Code
예 제 : select dbo.FN_GetGuildCode('jjugi')
수정내역:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2005-05-28 한지욱 1. 초기생성
************************************************** ****************************/
CREATE Function dbo.FN_GetGuildCode (
@i_character_name varchar(40) -- Character_Name
) RETURNS char(10)
AS
BEGIN
DECLARE @v_guild_code char(10)
IF Len(IsNull(@i_character_name, '')) > 0
BEGIN
SELECT @v_guild_code = guild_code
FROM Guild_Char_Info WITH(NOLOCK)
WHERE character_name = @i_character_name
END
RETURN ISNULL(@v_guild_code,'')
END
FN_GetGuildMasterName :
/************************************************** ****************************
이 름 : dbo.FN_GetGuildMasterName
설 명 : 길드의 마스터명을 반환한다.
반환값 : dbo.GUILD_CHAR_INFO.character_name
예 제 : SELECT dbo.FN_GetGuildMasterName('MASTERCODE')
수정내역:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2006-05-15 Han JiWook 1. 초기생성
************************************************** ****************************/
CREATE FUNCTION dbo.FN_GetGuildMasterName (
@i_guild_code varchar(20)
) RETURNS varchar(50)
AS
BEGIN
DECLARE @v_guildmaster_name varchar(50)
IF Len(IsNull(@i_guild_code, '')) > 0
BEGIN
SELECT @v_guildmaster_name = character_name
FROM dbo.GUILD_CHAR_INFO WITH(NOLOCK)
WHERE guild_code = @i_guild_code
AND peerage_code = 0
END
RETURN ISNULL(@v_guildmaster_name, '')
END
FN_GetGuildPeerageName :
/************************************************** ****************************
이 름 : FN_GetGuildPeerageName
설 명 : 길드의 작위명을 반환한다.
반환값 : GUILD_PEERAGE.peerage_name
예 제 : select dbo.FN_GetGuildPeerageName('0506000070', 0) -- 반환값=길드마스터
수정내역:
Ver Date Author Description
--------- ---------- --------------- ------------------------------------
1.0 2005-07-04 최지환 1. 초기생성
************************************************** ****************************/
CREATE Function dbo.FN_GetGuildPeerageName (
@i_guild_code varchar(20),
@i_peerage_code int -- Character_No
) RETURNS varchar(40)
AS
BEGIN
DECLARE @v_peerage_name varchar(40)
IF Len(IsNull(@i_guild_code, '')) > 0 AND @i_peerage_code IS NOT NULL
BEGIN
SELECT @v_peerage_name = peerage_name
FROM dbo.GUILD_PEERAGE WITH(NOLOCK)
WHERE guild_code = @i_guild_code
AND peerage_code = @i_peerage_code
END
RETURN ISNULL(@v_peerage_name, '')
END
This I think is good and I do not think there can be trouble. If you can, I would be very grateful for the help.
Maybe you have a fixed version of the guild is very good, if you divide.
That's not deaf second theme, which is another problem with me.
Aloken throws client can not connect as soon as you want to choose Aloken may have fixed the files?
Sorry for bad english, I'm from Lithuania.
 |
