Jump to content
MaxCheaters Official Group on X
MaxCheaters Official Group on Discord
--> Place your ad text here <--

Lineage 2 Classic 3 287 protocol

irk
 Share

Recommended Posts

  • 1 month later...
  • 4 weeks later...
TheRealOne Explorer

TheRealOne

Posted
Posted
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 Contributor

hugolez

Posted
Posted

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

 

  • 4 weeks later...
atomicos Apprentice

atomicos

Posted
Posted
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 😧 
 

  • Like 2
hugolez Contributor

hugolez

Posted
Posted
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.

  • 2 months later...
irk Enthusiast

irk

Posted
  • Author
Posted (edited)

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 by irk
  • Downvote 1
sandeagle Collaborator

sandeagle

Posted
Posted
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...

  • 4 weeks later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  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.

×
 Share
Go to topic listing
×
×
  • Create New...