Problem with Scroll Title

1	418222	ITEM_SRONAY_TITLE_01	?????	xxx	SN_ITEM_SRONAY_TITLE_01	SN_ITEM_SRONAY_TITLE_01_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	0	0	0	0	0	0	1	1	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	AccessUPG.ddj	xxx	xxx	21547

21547	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	????	1	?????? **************************************************************************************************************************	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

1	418222	ITEM_SRONAY_TITLE_01	?????	xxx	SN_ITEM_SRONAY_TITLE_01	SN_ITEM_SRONAY_TITLE_01_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	0	1	0	0	1	0	0	0	0	0	0	0	1	1	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\mall_server_change_scroll.ddj	xxx	xxx	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	????	1	??????	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

1	UIO_SECOND_HWAN_CH_NAME_LEVEL_7	????	0	0	0	0	0	King	King	0	0	0	0	0	0

1	SN_ITEM_SRONAY_TITLE_01	???? ??	0	0	0	0	0	Scroll King	Scroll King	0	0	0	0	0	0

USE [SRO_VT_LOG]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogChar]    Script Date: 5/11/2017 00:36:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER   procedure [dbo].[_AddLogChar] 
 [MENTION=395373]Chari[/MENTION]D        int,
  [MENTION=1134588]item[/MENTION]RefID	int,   [MENTION=1059401]operation[/MENTION]	tinyint,
  [MENTION=2220328]Eventi[/MENTION]D        tinyint,
 [MENTION=2397832]data1[/MENTION]        int,
 [MENTION=336745]DaTa[/MENTION]2        int,   [MENTION=414808]str[/MENTION]Pos        varchar(64),
 [MENTION=316630]DEsc[/MENTION]        varchar(128)
as

    -- Title Scroll
  IF   [MENTION=1059401]operation[/MENTION] = '16'
  BEGIN
  IF   [MENTION=1134588]item[/MENTION]RefID = 418222)
  BEGIN
  DECLARE  [MENTION=325360]hwan[/MENTION]Level tinyint
  SELECT  [MENTION=325360]hwan[/MENTION]Level=HwanLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharID = [MENTION=395373]Chari[/MENTION]D
  UPDATE SRO_VT_SHARD.dbo._Char SET HwanLevel = 3 WHERE CharID = [MENTION=395373]Chari[/MENTION]D
  END
  END


IF    ( -- Skips over the unnecessary Records
          [MENTION=2220328]Eventi[/MENTION]D != 11) AND 
          [MENTION=2220328]Eventi[/MENTION]D NOT BETWEEN 21 AND 27) AND
          [MENTION=2220328]Eventi[/MENTION]D NOT BETWEEN 200 AND 202) AND
          [MENTION=2220328]Eventi[/MENTION]D NOT BETWEEN 204 AND 206) AND 
          [MENTION=2220328]Eventi[/MENTION]D != 210) AND   [MENTION=2220328]Eventi[/MENTION]D != 214) AND   [MENTION=2220328]Eventi[/MENTION]D != 244)
    )BEGIN

    declare  [MENTION=319410]Len[/MENTION]_pos     int
    declare  [MENTION=319410]Len[/MENTION]_desc    int
    set  [MENTION=319410]Len[/MENTION]_pos = len    [MENTION=414808]str[/MENTION]Pos)
    set  [MENTION=319410]Len[/MENTION]_desc = len [MENTION=316630]DEsc[/MENTION])
    if   [MENTION=319410]Len[/MENTION]_pos > 0 and  [MENTION=319410]Len[/MENTION]_desc > 0)
    begin    
        insert _LogEventChar values [MENTION=395373]Chari[/MENTION]D, GetDate(),  [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2,    [MENTION=414808]str[/MENTION]Pos, [MENTION=316630]DEsc[/MENTION])    
    end
    else if   [MENTION=319410]Len[/MENTION]_pos > 0 and  [MENTION=319410]Len[/MENTION]_desc = 0)
    begin     
        insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values [MENTION=395373]Chari[/MENTION]D, GetDate(),  [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2,    [MENTION=414808]str[/MENTION]Pos)
    end
    else if   [MENTION=319410]Len[/MENTION]_pos = 0 and  [MENTION=319410]Len[/MENTION]_desc > 0)
    begin     
        insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values [MENTION=395373]Chari[/MENTION]D, GetDate(),  [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2, [MENTION=316630]DEsc[/MENTION])
    end
    else
    begin
        insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values [MENTION=395373]Chari[/MENTION]D, GetDate(),  [MENTION=2220328]Eventi[/MENTION]D, [MENTION=2397832]data1[/MENTION], [MENTION=336745]DaTa[/MENTION]2)
    end
    
/*Extension*/--> by Caipi

IF not exists (SELECT CharID FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D)
    BEGIN
        INSERT INTO _OnlineOffline (CharID, Charname, [Status], [Date], [Minutes], [tMinutes], eSilk, mOnline, [Silk/Hour], [stillOnline@])
        VALUES (
                [MENTION=395373]Chari[/MENTION]D,
                (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = [MENTION=395373]Chari[/MENTION]D),
                'OnHold',
                GETDATE(),
                0,0,0,
                NULL,(SELECT DefaultSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates'),
                NULL
                );
    END

IF   [MENTION=2220328]Eventi[/MENTION]D = 4 OR  [MENTION=2220328]Eventi[/MENTION]D = 6)
    BEGIN

    IF   [MENTION=2220328]Eventi[/MENTION]D = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) like 'OnHold'))
        BEGIN
            UPDATE _OnlineOffline
            SET [Status] = 'Offline'
            WHERE CharID = [MENTION=395373]Chari[/MENTION]D
        END
        
    IF   [MENTION=2220328]Eventi[/MENTION]D = 6 AND ((SELECT [Status] FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) like 'Online'))
        BEGIN
            UPDATE _OnlineOffline
            SET
                [Status] = 'Offline',
                [Minutes] = [Minutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
                [tMinutes] = [tMinutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
                [mOnline] = NULL,
                [stillOnline@] = NULL
            WHERE CharID = [MENTION=395373]Chari[/MENTION]D    
        END
        
    IF   [MENTION=2220328]Eventi[/MENTION]D = 4)
        BEGIN
            UPDATE _OnlineOffline
            SET 
                [Status] = 'Online',
                [Date] = GETDATE(),
                [stillOnline@] = GETDATE()
            WHERE CharID = [MENTION=395373]Chari[/MENTION]D
        END
    END

    
UPDATE _OnlineOffline
SET 
    [mOnline] = CAST((DATEDIFF(MINUTE,[Date],GETDATE()))as varchar(max)) + ' minute(s) Online',
    [Minutes] = [Minutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
    [tMinutes] = [tMinutes] + (DATEDIFF(MINUTE,[stillOnline@],GETDATE())),
    [stillOnline@] = GETDATE()
WHERE [Status] like 'Online'

/*Silk/Hour basic calc*/

IF   [MENTION=2220328]Eventi[/MENTION]D = '4' OR  [MENTION=2220328]Eventi[/MENTION]D = '6')
BEGIN
UPDATE SRO_VT_SHARD.DBO._Items SET OptLevel = '12' where OptLevel > '13'
end



IF ((SELECT [tMinutes] from _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) >= (SELECT [Step1Silk] FROM [_Silk/Hour-Config] WHERE [Desc] like 'Requirements'))
    BEGIN
        Declare    [MENTION=955435]SPH[/MENTION] int;
        exec    [MENTION=955435]SPH[/MENTION] = [_GetSilkperHour] [MENTION=395373]Chari[/MENTION]D
        UPDATE _OnlineOffline SET [Silk/Hour] =    [MENTION=955435]SPH[/MENTION] WHERE CharID = [MENTION=395373]Chari[/MENTION]D
    END
/*!Silk/Hour basic calc*/

IF (((SELECT NextDate FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next') IS NULL))
    BEGIN
        DECLARE  [MENTION=486595]First[/MENTION]Date datetime,    [MENTION=456996]today[/MENTION] datetime = GETDATE(),  [MENTION=486595]First[/MENTION]CharID int;

        exec  [MENTION=486595]First[/MENTION]CharID = SRO_VT_SHARD.dbo._RandomPlayerID
        exec SRO_VT_SHARD.dbo._GetRandomTime    [MENTION=456996]today[/MENTION],  [MENTION=486595]First[/MENTION]Date OUTPUT
        
        UPDATE [_RandomPlayer&Date] 
            SET 
                NextDate =  [MENTION=486595]First[/MENTION]Date,
                RefreshedDate = GETDATE(),
                CharID =  [MENTION=486595]First[/MENTION]CharID,
                Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID =  [MENTION=486595]First[/MENTION]CharID)
            WHERE [Desc] like 'Next';
    END
    
IF ((SELECT NextDate FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next') <= GETDATE())
    BEGIN
        UPDATE _OnlineOffline
            SET [Silk/Hour] = (SELECT RewardSilk FROM [_Silk/Hour-Config] WHERE [Desc] like 'Rates')
            WHERE CharID = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next');
        Declare
                [MENTION=3483390]CurSi[/MENTION]lkperHour int, 
                  [MENTION=2256426]OldC[/MENTION]harID int = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Current');
        IF    [MENTION=2256426]OldC[/MENTION]harID IS NOT NULL)
            BEGIN
                exec [MENTION=3483390]CurSi[/MENTION]lkperHour = _GetSilkperHour   [MENTION=2256426]OldC[/MENTION]harID
                UPDATE _OnlineOffline
                    SET [Silk/Hour] = [MENTION=3483390]CurSi[/MENTION]lkperHour
                    WHERE CharID =   [MENTION=2256426]OldC[/MENTION]harID;
            END
        UPDATE [_RandomPlayer&Date]
            SET
                NextDate = NULL,
                RefreshedDate = GETDATE(),
                CharID = (SELECT CharID FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next'),
                Charname = (SELECT Charname FROM [_RandomPlayer&Date] WHERE [Desc] like 'Next')
            WHERE [Desc] like 'Current'
        
        /*new Random Time of Today+1*/
        DECLARE   [MENTION=2919027]nextdate[/MENTION] datetime,    [MENTION=348406]Tomorrow[/MENTION] datetime = GETDATE()+1,   [MENTION=993253]newchar[/MENTION]ID int;
        
        exec   [MENTION=993253]newchar[/MENTION]ID = SRO_VT_SHARD.dbo._RandomPlayerID
        exec SRO_VT_SHARD.dbo._GetRandomTime    [MENTION=348406]Tomorrow[/MENTION],   [MENTION=2919027]nextdate[/MENTION] OUTPUT
        
        UPDATE [_RandomPlayer&Date] 
            SET 
                NextDate =   [MENTION=2919027]nextdate[/MENTION],
                RefreshedDate = GETDATE(),
                CharID =   [MENTION=993253]newchar[/MENTION]ID,
                Charname = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID =   [MENTION=993253]newchar[/MENTION]ID)
            WHERE [Desc] like 'Next'
        /*!new Random...*/
    END
    
    /*Calculation of the silk amount*/
    Declare    [MENTION=3394895]Tmi[/MENTION]nutes bigint = (SELECT [Minutes] from _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D),   [MENTION=292158]Silk[/MENTION] int;
    
        IF     [MENTION=3394895]Tmi[/MENTION]nutes >= 60)
            BEGIN
                SET   [MENTION=292158]Silk[/MENTION] = CAST(((SELECT [Minutes] FROM _OnlineOffline WHERE CharID = [MENTION=395373]Chari[/MENTION]D) / 60) as int)
                UPDATE _OnlineOffline
                SET [Minutes] = [Minutes] % 60
                WHERE CharID = [MENTION=395373]Chari[/MENTION]D
                
            IF exists (SELECT [WEEKDAYS] FROM [_Silk/Hour-Config] WHERE [WEEKDAYS] like DATENAME(WEEKDAY, GETDATE()))
                BEGIN
                    UPDATE _OnlineOffline
                    SET [eSilk] = [eSilk] +    [MENTION=292158]Silk[/MENTION]*[Silk/Hour])
                    WHERE CharID = [MENTION=395373]Chari[/MENTION]D
                    
                    exec SRO_VT_ACCOUNT.dbo._extraSilk [MENTION=395373]Chari[/MENTION]D,   [MENTION=292158]Silk[/MENTION]
                END
            END
    /*!Calc*/
    
/*!Extension*/

END -- !Skipping

IF	(   [MENTION=1059401]operation[/MENTION]=41)	AND	  [MENTION=1134588]item[/MENTION]RefID=418222))
BEGIN
UPDATE SRO_VT_SHARD.dbo._Char SET HwanLevel = 7 Where CharID = [MENTION=395373]Chari[/MENTION]D
END