Tutorials for EP8 Server Files

Re: Tutorials for EP8 Server Files (DETAILED)

@dragonrojo "And the carpet" you mean folder lol..

TG client mirrors:



Add ESTsoft to credits :P
 
Re: Tutorials for EP8 Server Files (DETAILED)

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'
 
Last edited:
Re: Tutorials for EP8 Server Files (DETAILED)

i download the centos i download 2 centos and i have this errors 2323 - Tutorials for EP8 Server Files - RaGEZONE Forums 22222 - Tutorials for EP8 Server Files - RaGEZONE Forums


pls help how intall and the real link
 
Re: Tutorials for EP8 Server Files (DETAILED)

[Thu Jan 24 2013 02:06:04.920451 3086764944]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Jan 24 2013 02:06:04.920497 3086764944]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Jan 24 2013 02:06:04.920511 3086764944]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Jan 24 2013 02:06:04.920524 3086764944]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Jan 24 2013 02:06:04.920537 3086764944]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Jan 24 2013 02:06:04.920549 3086764944]: [##ERROR##] Database Connect Fail ((null))
[Thu Jan 24 2013 02:06:04.920574 3086764944]: [##ERROR##] check 'pDB' fail
[Thu Jan 24 2013 02:06:04.920588 3086764944]: [##ERROR##] 'LordofWarSchedule' fail (Database/InstantWar.cpp:290)


already tried everything and not able to figure out: (
 
Re: Tutorials for EP8 Server Files (DETAILED)

i have 2 error in my log maybe database problem :

1 _ EventDBAgent.log :

[##ERROR##] OnIPCEMSGetEvents fail
[##ERROR##] DB ERROR(MSG) : Incompatible data types in stream operation
[##ERROR##] DB ERROR(CODE) : 32000
[##ERROR##] DB ERROR(VAR_INFO) : Column: 3<TIMESTAMP>, datatype in operator <</>>: INT
[##ERROR##] DB ERROR(SQLSTATE) :
[##ERROR##] DB ERROR(STM_TEXT) : {call dbo.cabal_sp_ems_get_events}
Database Connect success!

2_ EventMgrSvr.log :

[##ERROR##] Failed to Get Events
[##ERROR##] 'OnIPCDBGetEventsResult' fail (Proc/GetDataFromDBA.cpp:57)
[##ERROR##] UsrMap Fail : MainCmd(3103) Ret(39:0:57) Addr(127.0.0.1) CharIdx(0)
 
Re: Tutorials for EP8 Server Files (DETAILED)

A question, when restore Server01 file, what is the database name I should create? Server01 or GameDB?
 
Back