TLOG databases

[mrbrick]

Hi. Where can I get TLOG0 and TLOG1 database?
I have TLOG0 one, but it's not working at all. I can't connect to it with TLogTool :/

[AncientCompiler]

Just create a new database and create a table in there with the following name format:
ITEMLOGTLYYYYMMDD like ITEMLOGTL20161104 as example. The struct of the tables you can find in the source for the logservice.
Well you can add these procedures to create them automatically by just entering the date suffix.

TCreateNewDayTable

 Spoiler

ALTER PROCEDURE [dbo].[TCreateNewDayTable]
@szDate as VARCHAR(50)
AS

DECLARE @TB as VARCHAR(50)
DECLARE @laceholder as VARCHAR(50)

BEGIN
SET @laceholder = 'ITEMLOGTL'
SET @TB = @laceholder + @szDate

Exec TCreateTable @TB
END

TCreateTable

 Spoiler

ALTER PROCEDURE [dbo].[TCreateTable] @ewTable as NVARCHAR(50)
AS

DECLARE @QL NVARCHAR(1200)

BEGIN

SET @QL = 'CREATE TABLE [dbo].[' + @ewTable + '] (
[LT_SEQ] bigint NOT NULL IDENTITY(1,1) ,
[LT_LOGDATE] varchar(50) NULL ,
[LT_SERVERID] varchar(50) NULL ,
[LT_CLIENTIP] varchar(50) NULL ,
[LT_ACTION] int NULL ,
[LT_MAPID] int NULL ,
[LT_X] real NULL ,
[LT_Y] real NULL ,
[LT_Z] real NULL ,
[LT_DWKEY1] bigint NULL ,
[LT_DWKEY2] bigint NULL ,
[LT_DWKEY3] bigint NULL ,
[LT_DWKEY4] bigint NULL ,
[LT_DWKEY5] bigint NULL ,
[LT_DWKEY6] bigint NULL ,
[LT_DWKEY7] bigint NULL ,
[LT_DWKEY8] bigint NULL ,
[LT_DWKEY9] bigint NULL ,
[LT_DWKEY10] bigint NULL ,
[LT_DWKEY11] bigint NULL ,
[LT_KEY1] varchar(255) NULL ,
[LT_KEY2] varchar(255) NULL ,
[LT_KEY3] varchar(255) NULL ,
[LT_KEY4] varchar(255) NULL ,
[LT_KEY5] varchar(255) NULL ,
[LT_KEY6] varchar(255) NULL ,
[LT_KEY7] varchar(255) NULL ,
[LT_FMT] int NULL ,
[LT_LOG] varchar(255) NULL
)

ALTER TABLE [dbo].[' + @ewTable + '] ADD PRIMARY KEY ([LT_SEQ])'

EXECUTE @QL)

END

Simply run "TCreateNewDayTable" and enter the date in the format YYYYMMDD like 20161104 as example.

[mrbrick]

@
Thanks

I have found this function

that creates exactly the same tables

The main problem is that I can't open tables with TLogTool.
LogTool opens connection to DB well, but it can't read the data.

[AncientCompiler]

Are you sure that you have picked in the "Search" only the days for that are tables existing on the logdb? If you accidently choosed like 27 or 29 and you just have a table for the 28 the tool is going to fail to load the records.