AuthD classic off

Ребят, ни у кого проблемы с клиентом не было? Почему-то закрывается все таки клиент при попытке логина)
 
PaNtHeR, When you are not busy, please share the establishment of docker paserver. I need to learn how to use paserver, please record a teaching video, thanks again.
 
Осталось мейн запустить
 
i get stuck in server selection screen x.x
 
I cant enter in game. Looks like is missing this store procedure: lin_SaveAutoSoulShotUI

Used lin2db and lin2world databases from package.


Previous error from lin_SaveAutoSoulShotUI can be temp fixed in l2server.ini (UseAutoSoulShotUI=false).

Now theres another problem with stored procedure: lin_CreateChar

I'm using this client: L2KR-P287-D20200616-G574 with system_287-kr-nogg-strings-ENG from package
 
dude ,what's the databse you use?
 
Запрещено публиковать исходный код без BB-кода — CODE
I cant enter in game. Looks like is missing this store procedure: lin_SaveAutoSoulShotUI

Used lin2db and lin2world databases from package.
Посмотреть вложение 47651
try this:

SQL:
CREATE TABLE [dbo].[SoulshotSaveData](
    [char_id] [int] NOT NULL,
    [par1] [int] NOT NULL,
    [par2] [int] NOT NULL,
    [par3] [int] NOT NULL,
    [par4] [int] NOT NULL,
    [par5] [int] NOT NULL,
    [par6] [int] NOT NULL,
    [par7] [int] NOT NULL,
    [par8] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par1]  DEFAULT ((0)) FOR [par1]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par2]  DEFAULT ((0)) FOR [par2]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par3]  DEFAULT ((0)) FOR [par3]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par4]  DEFAULT ((0)) FOR [par4]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par5]  DEFAULT ((0)) FOR [par5]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par6]  DEFAULT ((0)) FOR [par6]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par7]  DEFAULT ((0)) FOR [par7]
GO

ALTER TABLE [dbo].[SoulshotSaveData] ADD  CONSTRAINT [DF_SoulshotSaveData_par8]  DEFAULT ((0)) FOR [par8]
GO




create procedure lin_SaveAutoSoulShotUI (
    @charId int,
    @par1 int = 0,
    @par2 int = 0,
    @par3 int = 0,
    @par4 int = 0,
    @par5 int = 0,
    @par6 int = 0,
    @par7 int = 0,
    @par8 int = 0
)

as

begin
    if((select count(1) from SoulshotSaveData where char_id=@charId)>0)
    begin
        update SoulshotSaveData
        set par1=@par1,
            par2=@par2,
            par3=@par3,
            par4=@par4,
            par5=@par5,
            par6=@par6,
            par7=@par7,
            par8=@par8
        where char_id=@charId
    --insert into SoulshotSaveData
    end
    else
    begin
        insert into SoulshotSaveData(char_id, par1, par2, par3, par4, par5, par6, par7, par8)
        values(@charId, @par1, @par2, @par3, @par4, @par5, @par6, @par7, @par8)
    end
end

GO
 
Последнее редактирование модератором:
Реакции: kick
Could you share the link of the Server package?
 
Well now no error in cached, but I cant create any character
 
CONVERT DATETIME ERROR - CHECK CacheD/l2cacheExt.ini [SettingExt] try set AltDateTimeConvertFormat=0 and restore default sql script

закрывается если три раза ввести неправильный, или если приходит сообщение неправильный пароль крашится просто (именно эта версия клиента)
 
У кого были проблемы с System 287 kr nogg strings ENG. Решение в l2.ini
INI:
; in-Game Secondary( Character ) Password
UseSecondaryAuth=true
 
guys, which version of sql server use? 2019? 2018 ? or?