[Request] Lines For Some Scrolls

01/24/2015 06:55 MissinGDeaTh#1
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 :/
01/24/2015 13:17 Aaron*#2
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
01/24/2015 19:07 Little Messi#3
Quote:
Originally Posted by Jocs View Post
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 ?
01/24/2015 20:36 MissinGDeaTh#4
Quote:
Originally Posted by Jocs View Post
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

[Only registered and activated users can see links. Click Here To Register...]
01/24/2015 21:17 Aaron*#5
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
01/25/2015 01:16 MissinGDeaTh#6
Quote:
Originally Posted by Jocs View Post
about removing premium , try this
working, but removing every single buff that's next to the premium :/
01/25/2015 11:52 ​Exo#7
Quote:
Originally Posted by MissinGDeaTh View Post
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:rolleyes:
01/25/2015 17:30 MissinGDeaTh#8
Quote:
Originally Posted by xExorcist View Post
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:rolleyes:

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
01/25/2015 17:51 ​Exo#9
You only get 1 row added when using the premium O.o?
01/25/2015 18:30 Snow*#10
Quote:
Originally Posted by xExorcist View Post
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)
01/25/2015 18:33 ​Exo#11
Quote:
Originally Posted by SnowStorm1 View Post
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.
01/25/2015 18:43 MissinGDeaTh#12
Quote:
Originally Posted by xExorcist View Post
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 View Post
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
01/25/2015 19:20 ​Exo#13
Try this xD

PHP Code:
DELETE FROM _TimedJob WHERE JobID in (29723,5412,59695) AND CharID = @CharID 
01/25/2015 19:46 MissinGDeaTh#14
Quote:
Originally Posted by xExorcist View Post
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 :/
01/26/2015 02:51 ​Exo#15
Quote:
Originally Posted by MissinGDeaTh View Post
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