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 Thu Aug 16, 2018 2:30 am

  • Moderator
Genju
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