Marquel World Information Technology

We allready update to new theme & 2 GDesign custom theme coming up. Stay tuned for more updates coming soon By: Admin Kosmyn and the rest of the staff of this support forum
ChatBox

You are not connected. Please login or register

Genju1Hot Add GM IP ingame on Thu Aug 16, 2018 2:30 am

  • Moderator
avatar
Moderator
SIMP cabal version info:

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"

View previous topic View next topic Back to top Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum