Jump to content
Andrew

PKO 2.4 + IGS

Recommended Posts

PKO 2.4:

https://mega.nz/#!ecNhhIbR!rfBLy43ujWJFbtamkPgozXcBZGT-Y54wzNxVOO9fB9I

- Client

- Server

- ICU

- Batabases

 

 

IGS:

https://mega.nz/#!nFkWSL6R!l8nKL21Amz7oOv60qOZ3T07JHq649Fjyb6JywjJ9x88

Create a DB "TradeDB" (Use the same of IGS 1.x version");

 

Use this code to modify AccountServer DB: (Code By Xeon);

[00:45:52] Xeon: /****** Object:  Table [dbo].[account_details]    Script Date: 6/6/2016 11:45:46 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[account_details](
 [acc_id] [int] NOT NULL,
 [vipstatus] [datetime] NULL CONSTRAINT [DF_account_details_vipstatus]  DEFAULT (((1)/(1))/(1970)),
 [credit] [float] NULL CONSTRAINT [DF_account_details_credit]  DEFAULT ((0)),
 CONSTRAINT [PK_account_details] PRIMARY KEY CLUSTERED 
(
 [acc_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
[00:46:52] Xeon: USE [AccountServer]
GO

/****** Object:  Table [dbo].[Trade_log]    Script Date: 6/7/2016 4:46:38 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Trade_log](
 [order] [varchar](50) NOT NULL,
 [current_time] [bigint] NOT NULL,
 [account] [varchar](50) NOT NULL,
 [character] [varchar](50) NOT NULL,
 [ip] [varchar](50) NOT NULL,
 [credit] [int] NOT NULL,
 [rate] [int] NOT NULL,
 [server_info] [varchar](50) NOT NULL,
 [memo] [varchar](50) NOT NULL,
 [create_time] [datetime] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

 

Create a New User to TradeDB;

 

Use this password: A$g6#¨&$2fgh*7gfgAdSe

 

infobill.cfg:

host = YourPC/YourInstance

hostT = YourPC/YourInstance

 

TradeServer.cfg:

serv = YourPC/YourInstance
usr = TradeDBUser

 

GameServer.Cfg

Add this line:

trade = YourIP,1985, 123456,1

*Change your IP ofc.

 

Done.

 

Edited by Andrew
  • Like 6

Share this post


Link to post
Share on other sites

I would like to know, What change does this byte? ( TradeServer.exe:0x00000227 0xC0 -> 0x40 )

 

The main database connection was fine(TradeDB) but not the one used by Infobill.

*I had to change `Address=%s;` to `Address=%s,1433;` and `Server=%s;` to `Server=%s\MyInstanceSQL;`

 

Here patch to who want to modify the database connection( infobill.dll )

http://www.filedropper.com/tradeserver

It changes the connection string to "FILEDSN=.\AccountServer.dsn;" (infobill.dll)

+ the dsn file to setup the connection :P

  • Like 1

Discord: andresc

Share this post


Link to post
Share on other sites
3 hours ago, Blanquitoh said:

Are those server files fiable? (no offence)

Yes, You only have to fix the gems in variable.lua and in stoneinfo.txt are in disorder there are gems that are not and the stoneinfo and another that are not in variable.lua like for example: the Gr8 are not in variable.lua but if in Stoneinfo.txt

Edited by Ximboliex
  • Like 1

xbx3.png

Share this post


Link to post
Share on other sites

@fabena

 

3 минуты назад, V3ct0r сказал:

AccountServer.exe can't connect to MSSQL Server.

Show us AccountServer.cfg. Have you entered correct MSSQL Server address in AccountServer.cfg? Have you created an user for AccountServer database in MSSQL Management Studio and entered its login and password in .cfg? Note: password should be encrypted.

 

Also there is a lot of threads about such problem in 'Questions & Help' section.


Share this post


Link to post
Share on other sites
On 9/15/2022 at 11:47 PM, Mesut said:
  Hide contents

anyone have this files pls post it here back thk u..

 

 

Are these files not here?

 


Share this post


Link to post
Share on other sites

For anyone needing a guide step by step, all the client and server+IGS files, all pre-configured, all setup and ready to play, literally a Plug'n Play Kit, well here you go:

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...