IF @iGu = 'I1' -- ?? ?? ??
BEGIN
IF (SELECT COUNT(*) AS [Count] FROM [CHARACTER_TBL] WHERE [account] = @iaccount AND [isblock] = 'F' AND [playerslot] = @iplayerslot AND [serverindex] = @iserverindex) > 0
BEGIN
SELECT fError = '0', fText = 'Can not overwrite player!'
RETURN
END
-- 20100218 ¡Ãy¨ù¨¬ A©ø¢¬?AI 3¡Æ©ø AE¡Æu ¨öA
declare @i1_cnt int
select @i1_cnt = count(*) from CHARACTER_TBL where account = @iaccount and isblock = 'F'
if @i1_cnt > 2
begin
SELECT fError = '0', fText = 'A©ø¢¬?AI ¢¬©öA¨ö!'
RETURN
end
IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
WHERE (( lower(m_szName) = lower(@im_szName) ) OR (playerslot = @iPlayerslot AND account = @iaccount ) ) AND isblock = 'F' AND serverindex = @iserverindex )
BEGIN
SELECT fError = '0', fText = 'Can not overwrite player!' -- fix char overwrite
RETURN
END
ELSE
BEGIN
DECLARE
@om_idPlayer CHAR (7) ,
BEGIN
IF (SELECT COUNT(*) AS [Count] FROM [CHARACTER_TBL] WHERE [account] = @iaccount AND [isblock] = 'F' AND [playerslot] = @iplayerslot AND [serverindex] = @iserverindex) > 0
BEGIN
SELECT fError = '0', fText = 'Can not overwrite player!'
RETURN
END
-- 20100218 ¡Ãy¨ù¨¬ A©ø¢¬?AI 3¡Æ©ø AE¡Æu ¨öA
declare @i1_cnt int
select @i1_cnt = count(*) from CHARACTER_TBL where account = @iaccount and isblock = 'F'
if @i1_cnt > 2
begin
SELECT fError = '0', fText = 'A©ø¢¬?AI ¢¬©öA¨ö!'
RETURN
end
IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
WHERE (( lower(m_szName) = lower(@im_szName) ) OR (playerslot = @iPlayerslot AND account = @iaccount ) ) AND isblock = 'F' AND serverindex = @iserverindex )
BEGIN
SELECT fError = '0', fText = 'Can not overwrite player!' -- fix char overwrite
RETURN
END
ELSE
BEGIN
DECLARE
@om_idPlayer CHAR (7) ,