Problem tittle scroll

[Tripple2]

hello anyone help me ?
i made tittle scroll and use in game and not change tittle

AddTimedJob

 Spoiler

if(@JobID = '33829')
BEGIN
update SRO_VT_SHARD.dbo._Char set HwanLevel = 8 where CharID = @D
return -3
end

id reskill

 Spoiler

1 33829 1027 SKILL_MALL_CHANGETITLE_SYSTEM ???? ???? SKILL_MALL_CHANGETITLE_SYSTEM 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_CHANGETITLE *** SN_SKILL_MALL_CHANGETITLE_TT_DESC *** 0 0 3 1667396966 1851946342 1685418593 1500 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

idk why not change name tittle number corect and not work

[ZαKuRα]

if(@JobID = '54381')
BEGIN
UPDATE dbo._Char SET HwanLevel = 15 Where CharID = @D
END

[Tripple2]

Originally Posted by ZαKuRα

if(@JobID = '54381')
BEGIN
UPDATE dbo._Char SET HwanLevel = 15 Where CharID = @D
END

not work again

[Ɗoc]

Check textuisystem and the spaces between the title and the name.

[Tripple2]

Originally Posted by Ɗoc

Check textuisystem and the spaces between the title and the name.

i know is correct

[Tripple2]

nothing help ty

[HECKT0R]

hello
execute this as query

PHP Code:

UPDATE dbo._Char SET HwanLevel = 15 Where    CharID    = (select charid from _char where charname16='write here your charname') 


if the query above works then you got a problem with your _AddTimedJob procedure .

[ZαKuRα]

Originally Posted by HECKT0R

hello
execute this as query

PHP Code:

UPDATE dbo._Char SET HwanLevel = 15 Where    CharID    = (select charid from _char where charname16='write here your charname') 


if the query above works then you got a problem with your _AddTimedJob procedure .

this query is to update the HwanLevel by query this is not the procedure that is going to execute the scroll when using any player

[Tripple2]

i have bad luck xd

[NagySandor96]

try to add it into addlogitem / log db

IF (@ ItemRefID= 'paste here item ID from refobjcommon' and @ Operation = 41)
BEGIN
UPDATE SRO_VT_SHARD.dbo._Char SET HwanLevel = 15 
WHERE
CharID=@CharID
END

*ps. if nothing works, then try to exchange your game server

[Tripple2]

Originally Posted by NagySandor96

try to add it into addlogitem / log db

IF (@ ItemRefID= 'paste here item ID from refobjcommon' and @ Operation = 41)
BEGIN
UPDATE SRO_VT_SHARD.dbo._Char SET HwanLevel = 15 
WHERE
CharID=@CharID
END

*ps. if nothing works, then try to exchange your game server

Finally work ty for help

[HECKT0R]

Originally Posted by ZαKuRα

this query is to update the HwanLevel by query this is not the procedure that is going to execute the scroll when using any player

it was just for testing purpose to check if his _addtimedjob procedure working or not

and in such case i was going to fix his _addtimedjob proc or he can simply use _addlogitem proc .