USE [Account]
GO
/****** Object: StoredProcedure [dbo].[cabal_addgmip] Script Date: 01/24/2013 07:13:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[cabal_addgmip] (@fromip VARCHAR(15), @toip VARCHAR(15) = @fromip) AS
BEGIN
DECLARE @IP1 VARCHAR(15), @IP2 VARCHAR(15)
SET @IP1 =
(
CAST( PARSENAME( @fromIP, 4 ) AS BIGINT ) * 16777216 +
CAST( PARSENAME( @fromIP, 3 ) AS BIGINT ) * 65536 +
CAST( PARSENAME( @fromIP, 2 ) AS BIGINT ) * 256 +
CAST( PARSENAME( @fromIP, 1 ) AS BIGINT )
)
SET @IP2 =
(
CAST( PARSENAME( @toIP, 4 ) AS BIGINT ) * 16777216 +
CAST( PARSENAME( @toIP, 3 ) AS BIGINT ) * 65536 +
CAST( PARSENAME( @toIP, 2 ) AS BIGINT ) * 256 +
CAST( PARSENAME( @toIP, 1 ) AS BIGINT )
)
IF @IP1 = @IP2
BEGIN
INSERT INTO cabal_GM_ip_table (fromip, toip) VALUES (@IP1, @IP2)
END
ELSE IF @IP1 <> @IP2
BEGIN
INSERT INTO cabal_GM_ip_table (fromip, toip) VALUES (@IP1, @IP2)
END
END
SET NOCOUNT OFF