[Request] Lines For Some Scrolls

MissinGDeaTh · 01/26/2015, 03:03

Quote:

Originally Posted by xExorcist

This can remove it lol just finish the other part, you only gave me 1 JobID for every premium so this will work...

@_AddLogItem

If @RefItemID = 'SCROLLIDHERE'
Begin
--the query from above
End

didn't work either :/

Snow* · 01/26/2015, 03:08

If you're using the SP Jocs posted then

Code:

If(@Operation= '41')
if(@ItemRefID= '41846') 
begin
declare @RemovePrem1 int 
declare @RemovePrem2 int
declare @RemovePrem3 int
declare @RemovePrem4 int
declare @RemovePrem5 int
declare @RemovePrem6 int
declare @RemovePrem7 int
declare @RemovePrem8 int
declare @RemovePrem9 INT
SET @RemovePrem1 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3847)
SET @RemovePrem2 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3783)
SET @RemovePrem3 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3769)
SET @RemovePrem4 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3795)
SET @RemovePrem5 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=10800)
SET @RemovePrem6 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=224)
SET @RemovePrem7 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=1)
SET @RemovePrem8 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=2)
SET @RemovePrem9 = (SELECT ID FROM SRO_VT_SHARD.DBO._TimedJob WHERE CharID=@CharID AND Data2=707799600)
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem1
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem2
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem3
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem4
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem5
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem6
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem7
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem8
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem9 
end
end

Simply add a new line with the data2 column from the lines you extracted

We are going to follow his code:
last lines are @RemovePrem9 So we are going to add after each one @RemovePrem10 and so on..

declare @RemovePrem9 int
declare @RemovePrem10 int

SET @RemovePrem9 = (SELECT ID FROM SRO_VT_SHARD.DBO._TimedJob WHERE CharID=@CharID AND Data2=707799600)
SET @RemovePrem10 = (SELECT ID FROM SRO_VT_SHARD.DBO._TimedJob WHERE CharID=@CharID AND Data2=707799600)

This will explain how to get the Data2 for the new lines you're going to add

Spoiler

delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem9
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem10

It's pretty easy but I wrote a lot for no reason.

MissinGDeaTh · 01/26/2015, 03:15

Quote:
Originally Posted by SnowStorm1
If you're using the SP Jocs posted then
Code:
If(@Operation= '41')
if(@ItemRefID= '41846') 
begin
declare @RemovePrem1 int 
declare @RemovePrem2 int
declare @RemovePrem3 int
declare @RemovePrem4 int
declare @RemovePrem5 int
declare @RemovePrem6 int
declare @RemovePrem7 int
declare @RemovePrem8 int
declare @RemovePrem9 INT
SET @RemovePrem1 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3847)
SET @RemovePrem2 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3783)
SET @RemovePrem3 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3769)
SET @RemovePrem4 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=3795)
SET @RemovePrem5 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=10800)
SET @RemovePrem6 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=224)
SET @RemovePrem7 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=1)
SET @RemovePrem8 = (Select ID From SRO_VT_SHARD.DBO._TimedJob Where CharID=@CharID and Data2=2)
SET @RemovePrem9 = (SELECT ID FROM SRO_VT_SHARD.DBO._TimedJob WHERE CharID=@CharID AND Data2=707799600)
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem1
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem2
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem3
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem4
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem5
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem6
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem7
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem8
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem9 
end
end
Simply add a new line with the data2 column from the lines you extracted

We are going to follow his code:
last lines are @RemovePrem9 So we are going to add after each one @RemovePrem10 and so on..

declare @RemovePrem9 int
declare @RemovePrem10 int

SET @RemovePrem9 = (SELECT ID FROM SRO_VT_SHARD.DBO._TimedJob WHERE CharID=@CharID AND Data2=707799600)
SET @RemovePrem10 = (SELECT ID FROM SRO_VT_SHARD.DBO._TimedJob WHERE CharID=@CharID AND Data2=707799600)

This will explain how to get the Data2 for the new lines you're going to add
Spoiler
or just do the following

1- remove all the buffs/scroll and all remaining wait time etc.. data from the _TimedJob belong to your character
Code:
delete from SRO_VT_SHARD.dbo._TimedJob where charid = (select CharID from SRO_VT_SHARD.dbo._Char where charname16 = 'WRITE YOUR YOUR CHAR NAME ')
2-go ingame and use the premium

3- select the Data2 which is needed to run in Jocs query at _AddLogItem procedure @LogDatabase
Code:
SELECT Data2 from SRO_VT_SHARD.dbo._TimedJob where Charid = (select CharID from SRO_VT_SHARD.dbo._Char where charname16 = 'WRITE YOUR YOUR CHAR NAME ')
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem9
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem10

It's pretty easy but I wrote a lot for no reason.

his sp is working well, but there was a problem.
if u saw the pic i posted for him you will understand.

when the remove premium scroll is used while godbless + premium is active it will only remove that helper, not the premium. and you can use another premium to give u another premium stats

Snow* · 01/26/2015, 03:19

I really wrote a lot for no reason xD

Okay... Do the following
Delete from _TimedJob where charid = (select charid from _char where charname16 = 'write_your_character_name')
Login to the game use the premium and use the removing the scroll

then use this

Code:

SELECT Data2 from SRO_VT_SHARD.dbo._TimedJob where Charid = (select CharID from SRO_VT_SHARD.dbo._Char where charname16 = 'WRITE YOUR YOUR CHAR NAME ')

copy and paste the result

MissinGDeaTh · 01/26/2015, 03:26

Quote:
Originally Posted by SnowStorm1
I really wrote a lot for no reason xD

Okay... Do the following
Delete from _TimedJob where charid = (select charid from _char where charname16 = 'write_your_character_name')
Login to the game use the premium and use the removing the scroll

then use this
Code:
SELECT Data2 from SRO_VT_SHARD.dbo._TimedJob where Charid = (select CharID from SRO_VT_SHARD.dbo._Char where charname16 = 'WRITE YOUR YOUR CHAR NAME ')
copy and paste the result

Result with the premium only

Quote:

3847
10800
224
1

Result with premium + extra godbless active

Quote:

3847
10800
224
1
1

i only want to remove premium nthing else

Exo · 01/26/2015, 03:28

Would you select the whole **** rows?

PHP Code:


			
SELECT * from SRO_VT_SHARD.dbo._TimedJob where Charid = (select CharID from SRO_VT_SHARD.dbo._Char where charname16 = 'WRITE YOUR YOUR CHAR NAME ')

Make sure you only have a premium activated JUST A PREM means no other scrolls.

MissinGDeaTh · 01/26/2015, 03:35

Quote:

Originally Posted by xExorcist

Would you select the whole damn rows?

PHP Code:

SELECT * from SRO_VT_SHARD.dbo._TimedJob where Charid = (select CharID from SRO_VT_SHARD.dbo._Char where charname16 = 'WRITE YOUR YOUR CHAR NAME ')

Make sure you only have a premium activated JUST A PREM means no other scrolls.

it shows 4 rows, but i activate only premium

Quote:

96 16364 5 67974 1424658840 1111902513 3847 0 0 0 0 0 0 72339069018671687 0
97 16364 3 9278 28 1422239640 10800 0 0 0 0 0 0 72339069018671687 0
98 16364 5 67974 1424658840 1431391281 224 2419200 1424658840 196611 0 0 0 72339069018671687 0
99 16364 0 29723 1424658840 0 1 0 0 0 0 0 0 72339069018671687 0

Exo · 01/26/2015, 03:38

PHP Code:


			

//Add this to your _AddLogItem SP

If  @ItemRefID = 'RefObjCommon_ID_HERE' // == Scroll RefID
Begin
DELETE FROM SRO_VT_SHARD.._TimedJob WHERE JobID in (67974,9278,67974,29723) AND CharID = @CharID
End

MissinGDeaTh · 01/26/2015, 03:41

Quote:

Originally Posted by xExorcist

PHP Code:

//Add this to your _AddLogItem SP If @ItemRefID = 'RefObjCommon_ID_HERE' Begin DELETE FROM SRO_VT_SHARD.._TimedJob WHERE JobID in (67974,9278,67974,29723) AND CharID = @CharID End

thanks alot it worked <3

Snow* · 01/26/2015, 03:47

If you want to keep on using the same query

Code:

  If(@Operation= '41')
if(@ItemRefID= '41846') 
begin
declare @RemovePrem1 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=3847)
declare @RemovePrem2 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=3783)
declare @RemovePrem3 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=3769)
declare @RemovePrem4 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=3795)
declare @RemovePrem5 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=10800)
declare @RemovePrem6 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=224)
declare @RemovePrem7 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=1)
declare @RemovePrem8 int = (Select ID From SRO_VT_SHARD.dbo._TimedJob Where CharID=@CharID and Data2=2)
declare @RemovePrem9 int = (SELECT ID FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID AND Data2=707799600)
declare @Verify int = (select id from SRO_VT_SHARD.dbo._TimedJob where CharID=@CharID and JobID = 67974)
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem1
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem2
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem3
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem4
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem5
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem6
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem7
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem8
delete from SRO_VT_SHARD.DBO._TimedJob WHERE ID=@RemovePrem9 
delete from SRO_VT_SHARD.dbo._TimedJob where ID=@Verify
end
end

Even though I'm not sure if something else using this jobid 67974. But this should remove the premium.

But it worked just fine with me

Spoiler

Exo · 01/26/2015, 03:56

I wonder if there could be any conflict between the JobIDs

Never came by any of them before, maybe I'm wrong.

Snow* · 01/26/2015, 04:09

Quote:

Originally Posted by xExorcist

I wonder if there could be any conflict between the JobIDs

Never came by any of them before, maybe I'm wrong.

I guess that JobId is only used by the premium (not sure so...)

Exo · 01/26/2015, 04:25

@OP is there any other problem regarding this case? or we can close it?

MissinGDeaTh · 01/26/2015, 05:02

well, it works fine now, thanks xExorcist,SnowStorm1 for helping me <3

Exo · 01/26/2015, 06:17

Here

PHP Code:


			
//Add this to your _AddLogItem SP 

If  @ItemRefID = 'RefObjCommon_ID_HERE' 
Begin 
UPDATE SRO_VT_SHARD.._Char
SET Strength=129, Intellect=129,RemainStatPoint=327 WHERE CharID = @ChardID
End