Genju1 Add GM IP ingame Thu Aug 16, 2018 2:30 am
SIMP cabal version info:
client_version=369
NormalClientMagicKey=543957823
How to become GM ingame:
Go to db Account create procedure
Then do exec cabal_addgmip 'YOURIP'
Then go to Server01 DB - cabal_character_table find your character change nation to 3
For MSSQL enable named pipes in MSSQL configuration for MSSQLSERVER instance, and install as Chinese_PRC (accent sensitive)
To send items ingame exec on cabalcash
client_version=369
NormalClientMagicKey=543957823
How to become GM ingame:
Go to db Account create procedure
- Code:
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
Then do exec cabal_addgmip 'YOURIP'
Then go to Server01 DB - cabal_character_table find your character change nation to 3
For MSSQL enable named pipes in MSSQL configuration for MSSQLSERVER instance, and install as Chinese_PRC (accent sensitive)
To send items ingame exec on cabalcash
- Code:
exec up_AddMyCashItemByItem 'ACCOUNTID','0','SERVERID','ITEMID','ITEMOPTION','DURATIONID"