Problem tittle scroll

04/24/2018 17:33 Tripple2#1

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

AddTimedJob

id reskill

idk why not change name tittle number corect and not work

04/24/2018 18:55 ZαKuRα#2

if(@JobID = '54381')
BEGIN
UPDATE dbo._Char SET HwanLevel = 15 Where CharID = @[Only registered and activated users can see links. Click Here To Register...]D
END

04/24/2018 23:11 Tripple2#3

Quote:

Originally Posted by ZαKuRα

if(@JobID = '54381')
BEGIN
UPDATE dbo._Char SET HwanLevel = 15 Where CharID = @[Only registered and activated users can see links. Click Here To Register...]D
END

not work again :(

04/25/2018 11:40 Ɗoc#4

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

04/25/2018 12:03 Tripple2#5

Quote:

Originally Posted by Ɗoc

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

i know is correct

04/27/2018 11:11 Tripple2#6

nothing help ty

04/27/2018 21:09 HECKT0R#7

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 .

04/27/2018 21:48 ZαKuRα#8

Quote:

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:)

04/27/2018 23:34 Tripple2#9

i have bad luck xd

04/28/2018 16:40 NagySandor96#10

try to add it into addlogitem / log db

Code:

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

04/28/2018 18:38 Tripple2#11

Quote:
Originally Posted by NagySandor96
try to add it into addlogitem / log db
Code:
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

04/28/2018 19:48 HECKT0R#12

Quote:

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 .