Skip to main content

iaccount

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)        ,