cached & SQL lin_SetLastTaxUpdate

[smeli]

кешед иногда посылает (packet219_RequestSetLastResidenceTaxUpdate.cpp) странныe данные серверу

04/16/2018 12:00:36.287, Error sql: EXEC lin_SetLastTaxUpdate '1970-0-1 2:0:0', '1970-0-1 2:0:0' (0) 04/16/2018 12:00:36.287, Error 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to datetime. 04/16/2018 12:00:36.287, [.][49] cannot update last tax change date.

[Master Toma]

Original CacheD has same error, but values are correct:

original: 03/29/2018 12:00:55.581, Error sql: EXEC lin_SetLastTaxUpdate '2018-2-29 12:0:55', '2017-11-12 0:0:57' (0)

[smeli]

после етого исправления оригинальный кешед перестал ругатся

USE [lin2world]
GO
/****** Object:  StoredProcedure [dbo].[lin_SetLastTaxUpdate]    Script Date: 2018-04-11 11:42:31 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO



/********************************************    
lin_SetLastTaxUpdate  

INPUT     
@income  datetime,
@tax datetime
OUTPUT    
made by    
 carrot    
date    
 2004-02-29  
********************************************/    
ALTER PROCEDURE [dbo].[lin_SetLastTaxUpdate]  
(  
@income  datetime,
@tax datetime
)  
AS    

-- date fix addon, smeli

declare @income_ datetime 
declare @tax_ datetime 

--set @income_ = CONVERT(Datetime, '2011-09-28 18:01:00', 120)
set @income_ = CONVERT(Datetime, @income, 120)
set @tax_ = CONVERT(Datetime, @tax, 120)

-- end date fix addon, smeli


SET NOCOUNT ON 
IF EXISTS(SELECT * FROM castle_tax) 
BEGIN 
UPDATE castle_tax SET income_update = @income_, tax_change = @tax_
END 
ELSE 
BEGIN 
INSERT INTO castle_tax VALUES 
( @income_, @tax_) 



END

[Master Toma]

Fix applied: https://bitbucket.org/master_toma/lineage2-c1-harbingers-of-war/commits/e01d1c93422fda8bb52bd4208440c13e2dcab860