[Request] Lines For Some Scrolls

MissinGDeaTh · 01/24/2015, 06:55

if it's possible i need full lines + procuders for these scrolls
1-Premium Remover.
2-Reset stats.
3-Reset scrolls.

i searched alot but can't find a working release :/

Aaron* · 01/24/2015, 13:17

1- :

Quote:

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

2-

Quote:

if(@Operation = '41' and @RefItemID = '41847') -- remove stats
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from SRO_VT_SHARD.._Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE SRO_VT_SHARD.._Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
end

3-

Quote:

if(Operation = 41 and @ItemRefID= '41848') -- remove skills
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM SRO_VT_SHARD.._CharSkillMastery, SRO_VT_SHARD.._RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '130'
UPDATE SRO_VT_SHARD.._Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE SRO_VT_SHARD.._CharSkill FROM SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '130'
end

add all of these to _AddLogItem procedure @ Log DB

Little Messi · 01/24/2015, 19:07

Quote:

Originally Posted by Jocs

1- :

2-

3-

add all of these to _AddLogItem procedure @ Log DB

tested remove premium, it worked successfuly with the normal premiums. but i have a new premium added wont be removed. can u tell me where to edit the procuder to remove that new premium ?

MissinGDeaTh · 01/24/2015, 20:36

Quote:

Originally Posted by Jocs

1- :

2-

3-

add all of these to _AddLogItem procedure @ Log DB

that's what happens if i use the scroll when i have a godbless + premium on the char

Aaron* · 01/24/2015, 21:17

about removing premium , try this

Quote:

IF ( @Operation = 41 and @ItemRefID = 6768605)
BEGIN
UPDATE SRO_VT_SHARD.._TimedJob SET TimeToKeep='28', Data6='0' WHERE CharID=@CharID AND Category='3'
DELETE FROM SRO_VT_SHARD.._TimedJob WHERE CharID=@CharID AND Category='3'
DELETE FROM SRO_VT_SHARD.dbo._TimedJob WHERE CharID=@CharID AND Category='5'
DELETE FROM SRO_VT_SHARD.._TimedJob WHERE CharID=@CharID And Category='0'

end

MissinGDeaTh · 01/25/2015, 01:16

Quote:

Originally Posted by Jocs

about removing premium , try this

working, but removing every single buff that's next to the premium :/

Exo · 01/25/2015, 11:52

Quote:

Originally Posted by MissinGDeaTh

working, but removing every single buff that's next to the premium :/

Okay start a premium, just a premium to be on the character. Copy the _TimedJob lines, paste them here. I'll write that query for you

MissinGDeaTh · 01/25/2015, 17:30

Quote:

Originally Posted by xExorcist

Okay start a premium, just a premium to be on the character. Copy the _TimedJob lines, paste them here. I'll write that query for you

Quote:

89 16371 0 29723 1424621987 0 1 0 0 0 0 0 0 72339069018671701 0

Quote:

96 16372 0 5412 1424622145 0 1 0 0 0 0 0 0 72339069018671729 0

Quote:

103 16373 0 59695 1424622286 0 1 0 0 0 0 0 0 72339069018671755 0

these are the 3 new premium i got .. i need the procuder to remove them, w/o removing all buffs

Exo · 01/25/2015, 17:51

You only get 1 row added when using the premium O.o?

Snow* · 01/25/2015, 18:30

Quote:

Originally Posted by xExorcist

You only get 1 row added when using the premium O.o?

Premium got more than one item/skill (4 as far as I remember)

Exo · 01/25/2015, 18:33

Quote:

Originally Posted by SnowStorm1

Premium got more than one item/skill (4 as far as I remember)

I'd test it myself but for some reason I don't feel like opening my test server just for that, so unless he can help me and give me the exact rows when he uses that premium there's no way I can give him a decent answer.

MissinGDeaTh · 01/25/2015, 18:43

Quote:

Originally Posted by xExorcist

You only get 1 row added when using the premium O.o?

yes, but these are diff premiums.
i created 3 chars every char with 1 premium, so the query u make will remove all kind of premiums..

Quote:

Originally Posted by xExorcist

I'd test it myself but for some reason I don't feel like opening my test server just for that, so unless he can help me and give me the exact rows when he uses that premium there's no way I can give him a decent answer.

these are the exact rows for the 3 premiums as i mentioned before
i posted these 3 rows cuz i want the procuder to remove these 3 premiums

Quote:

89 16371 0 29723 1424621987 0 1 0 0 0 0 0 0 72339069018671701 0

Quote:

96 16372 0 5412 1424622145 0 1 0 0 0 0 0 0 72339069018671729 0

Quote:

103 16373 0 59695 1424622286 0 1 0 0 0 0 0 0 72339069018671755 0

Exo · 01/25/2015, 19:20

Try this xD

PHP Code:


			
DELETE FROM _TimedJob WHERE JobID in (29723,5412,59695) AND CharID = @CharID

MissinGDeaTh · 01/25/2015, 19:46

Quote:

Originally Posted by xExorcist

Try this xD

PHP Code:

DELETE FROM _TimedJob WHERE JobID in (29723,5412,59695) AND CharID = @CharID

dude, i want to add the query in procuder _AddLogItem, for scroll. when some one uses the scroll it removes his premium :/
and i can't write the full procuder :/

Exo · 01/26/2015, 02:51

Quote:

Originally Posted by MissinGDeaTh

dude, i want to add the query in procuder _AddLogItem, for scroll. when some one uses the scroll it removes his premium :/
and i can't write the full procuder :/

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