Tool Lineage 2 Classic 3 287 protocol

[irk]

Lineage2 Mobile: https://disk.yandex.com/d/NzFzHgbXJZUXWg

Classic 3 with Aden script: https://disk.yandex.com/d/cdgQKvSYTNaeGA

mirror https://disk.yandex.ru/d/BES2aj0tCAaQhA

[lewic1982]

On 5/8/2022 at 1:47 PM, irk said:

sql files but needs fixes

https://mega.nz/file/UdlHwbwT#lYk_dzEaEn6hAUK2cxgJCaj8XTVO7MiiV5TZlnhBWtM

 

all files https://drive.google.com/file/d/1spZidxWye4tP1P5yfClB1M7xs2hr35DD/view

 

can't down ,please fix..

[sandeagle]

what is Mobile server???its for mobile phone?

[hugolez]

Hi PPl, anyone have link to all svn files? plz, all link broken

Edited July 30, 2022 by hugolez

[TheRealOne]

On 5/8/2022 at 8:37 AM, pada said:

English clients also will not work, without at least a basic extender to fix opcode differences between KR builds and Global builds, also the fact that KR flat out has different formats for a few packets. And ya..anyone expecting someone to build this DB in even a month, let alone also pass it out for free, is kinda nuts, the sheer amount of things to rebuild, and then all the things that just need to be guessed, as there is no ref from older versions. also LOL at ncsoft, no wonders lag has been a issue on retail servers since ranking was added...really? they hit DB for every single instance of exp gained by every character at a time.

Got scammed by this guy Pada

[hugolez]

The first difficulty to start the server was the serial key, thanks for sharing the .exe that no longer had that problem. The second problem is a sql procedure called "lin_ExecuteDBJob", which writes a file in the scripts called "dbjob.txt", apparently it takes data from the Cached config and writes it there, there are 3 data: time, servertype and item_list. I was able to get around the procedure, but I need to write the 3 pieces of data to the dbjob.txt file. I share the procedure, in case any mssql expert helps us to correct the procedure. I know something is missing but I can't find it

Quote

CREATE PROCEDURE
[dbo].[lin_ExecuteDBJob] (
    @time         int,
    @servertype        int,
    @item_list         int
)
AS
SET @time = 'D:\Servidor (3.0)\script\dbjob.txt' --Your file
SET @servertype     = 'D:\Servidor (3.0)\script\dbjob.txt' --Your file
SET @item_list = 'D:\Servidor (3.0)\script\dbjob.txt' --Your file

GO

 

[atomicos]

On 8/22/2022 at 11:48 PM, hugolez said:

The first difficulty to start the server was the serial key, thanks for sharing the .exe that no longer had that problem. The second problem is a sql procedure called "lin_ExecuteDBJob", which writes a file in the scripts called "dbjob.txt", apparently it takes data from the Cached config and writes it there, there are 3 data: time, servertype and item_list. I was able to get around the procedure, but I need to write the 3 pieces of data to the dbjob.txt file. I share the procedure, in case any mssql expert helps us to correct the procedure. I know something is missing but I can't find it

 

querry "exec dbo.lin_ExecuteDBJob 0,6,3" i guess insert data to db
 

Quote

CREATE PROCEDURE [dbo].[lin_ExecuteDBJob]
(
@period int,
@servertype int,
@item_list int
)
AS
INSERT dbjob(period, servertype, item_list)  
  VALUES(@period,  @servertype, @item_list)
GO

Quote

/****** Object:  Table [dbo].[dbjob]  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[dbjob](
    [period] [int] NOT NULL,
    [servertype] [int] NOT NULL,
    [item_list] [int] NOT NULL
) ON [PRIMARY]
GO

every start data duplicate, dbo.lin_ExecuteDBJob need check function

 

some_db porting procedure and some table from god to leaked db

PS. im not programmer, just beginner  
 

[hugolez]

On 9/17/2022 at 8:44 AM, atomicos said:

querry "exec dbo.lin_ExecuteDBJob 0,6,3" i guess insert data to db

I haven't tried yet, register in the database. But I am assuming that it takes data from the cached.ini and inserts it into "dbjob.txt" which is in the script folder. It looks like a .txt that records the versions, or the changes made by the developers.

[lch]

All links are no longer valid,, please fix ..

[irk]

L2world restore
https://mega.nz/file/0V1zXSLT#3mQmnr..._TwcuaCg1hkgCw 
https://mega.nz/file/wMd21SDA#-369_I...f3bk9gNzVUUzPI

Does anyone know how to fix login errors?
https://gyazo.com/6c7dff87306deb2e33b3f796dc4cc7d6
https://prnt.sc/HkO6--ukasdL

bug fixed SQLGETDiagRec(100) {ap_SetServerStatus(0,0)}

https://gyazo.com/eb58ab4cbb8ef28fb4eb1cb06104fb41

 

 

Edited December 14, 2022 by irk

[sandeagle]

On 12/14/2022 at 1:28 AM, irk said:

L2world restore
https://mega.nz/file/0V1zXSLT#3mQmnr..._TwcuaCg1hkgCw 
https://mega.nz/file/wMd21SDA#-369_I...f3bk9gNzVUUzPI

Does anyone know how to fix login errors?
https://gyazo.com/6c7dff87306deb2e33b3f796dc4cc7d6
https://prnt.sc/HkO6--ukasdL

bug fixed SQLGETDiagRec(100) {ap_SetServerStatus(0,0)}

https://gyazo.com/eb58ab4cbb8ef28fb4eb1cb06104fb41

 

 

 

links dead...plz fixed it...

[irk]

https://gyazo.com/cd7af2ca99ef97e61d3445128e14d2c0
Need to define the procedure that is responsible for displaying already created characters in the game lobby!

[irk]

I've finished

https://www.youtube.com/watch?v=6D-6s8gyFYA

https://gyazo.com/9f964f13819c64408bab88e77685186b
https://gyazo.com/50c567039cbae283804b110df22ad8a3

Edited January 11, 2023 by irk

[Tunsuyoki]

7 hours ago, irk said:

I've finished

https://www.youtube.com/watch?v=6D-6s8gyFYA

https://gyazo.com/9f964f13819c64408bab88e77685186b
https://gyazo.com/50c567039cbae283804b110df22ad8a3

Don't poison my soul I'm trying to run xD

[kirayamatos]

If you succeed in entering the game, can you share it, the database you use