|
You last visited: Today at 18:32
Advertisement
[Request] Lines For Some Scrolls
Discussion on [Request] Lines For Some Scrolls within the SRO Private Server forum part of the Silkroad Online category.
01/26/2015, 03:03
|
#16
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
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 :/
|
|
|
01/26/2015, 03:08
|
#17
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,429
|
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
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.
|
|
|
01/26/2015, 03:15
|
#18
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
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
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
|
|
|
01/26/2015, 03:19
|
#19
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,429
|
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
|
|
|
01/26/2015, 03:26
|
#20
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
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:
Result with premium + extra godbless active
Quote:
i only want to remove premium nthing else
|
|
|
01/26/2015, 03:28
|
#21
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
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.
|
|
|
01/26/2015, 03:35
|
#22
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
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
|
|
|
|
01/26/2015, 03:38
|
#23
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
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
|
|
|
01/26/2015, 03:41
|
#24
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
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
|
|
|
01/26/2015, 03:47
|
#25
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,429
|
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
delete the rows you posted
|
|
|
01/26/2015, 03:56
|
#26
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
I wonder if there could be any conflict between the JobIDs
Never came by any of them before, maybe I'm wrong.
|
|
|
01/26/2015, 04:09
|
#27
|
elite*gold: 1
Join Date: Nov 2011
Posts: 2,532
Received Thanks: 1,429
|
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...)
|
|
|
01/26/2015, 04:25
|
#28
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
@OP is there any other problem regarding this case? or we can close it?
|
|
|
01/26/2015, 05:02
|
#29
|
elite*gold: 15
Join Date: Jul 2014
Posts: 146
Received Thanks: 6
|
well, it works fine now, thanks xExorcist,SnowStorm1 for helping me <3
|
|
|
01/26/2015, 06:17
|
#30
|
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
|
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
|
|
|
|
|
Similar Threads
|
[Request] easy way to add lines to skilldata_35000enc
01/24/2015 - SRO Private Server - 11 Replies
as title said i want easy way to add lines to skilldata_35000enc
because i try every guide on epvpers, and still get crashed after launching the client + i can't add any new stuff to my server w/o knowing how to add lines to
skilldata_35000enc
and i want to limit guild members for 20 or 25 players and union to only 2 guilds
it that's possiple ?
|
[Request] Scrolls (addTimedJop)
11/06/2013 - SRO Private Server - 2 Replies
Hello guys i made some scrolls into my server and through _AddTimedJop and iam trying to make those scrolls act like Lottery as example give player Lucky powder or Magic lucky powder i tried every thing but still can't figure how to do it if any one know any thing about that please let me know
ThnX in adv
|
Request| Lines
06/01/2012 - SRO Private Server - 5 Replies
i almost finish with jsro server files they state on 98% working
i just need to extract from characterdata.txt of jsro
the part of refobjchar.
if someone know a good way to do it , i be glad to hear.
|
[Request]a npc that makes db/met scrolls
05/29/2009 - CO2 Private Server - 4 Replies
hi guys,im useing tq binarys 5065 and im requesting from you a NPC that cam pack 10dbs/mets in 1 scroll.Thanks !
best regards
|
[REQUEST] Location of random portal scrolls
03/10/2009 - EO Weapon, Armor, Effects & Interface edits - 2 Replies
i need the location of the random portal scrolls .dds file for laying on ground and in bag... anyone who knows where they are please let me know via PM or reply :)
im sure its in /ani/MapItemIcon.ani but the WDF Extractor isnt working for me on vista... i tryed on a windows XP system and nothing extracted from said file
... WTF>>?
http://www.mediafire.com/?uzziy5zlqjz
http://www.mediafire.com/?zhkgmcznwnf
|
All times are GMT +2. The time now is 18:32.
|
|