Scroll Recall Skills (Auto Teleport)

[D3vil Power]

Made ur own Scroll ..

ِAdd To _AddLogItem

PHP Code:

IF ((@Operation = 41 ) AND (@ItemRefID = 61508)) 
BEGIN 
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID 
END 


Create New Procedure

PHP Code:

USE [SRO_VT_SHARD] 
GO 

/****** Object:  StoredProcedure [dbo].[_Scroll_Reset]    Script Date: 2/21/2016 4:06:44 PM ******/ 
SET ANSI_NULLS ON 
GO 

SET QUOTED_IDENTIFIER OFF 
GO 




CREATE PROCEDURE [dbo].[_Scroll_Reset] 
@CharID INT 
AS 

BEGIN 

        declare @TotalSP int  
        declare @TotalSPMastery int  
        SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' 
        SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '120'  
        UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 WHERE CharID=@CharID  
        DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)  
            UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'  

END 


Change 120 to your server level ,
Regards,

[NoIdeaForAName]

How did you make it with auto teleport?

exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID ?

[leo2111]

Originally Posted by NoIdeaForAName

How did you make it with auto teleport?

exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID ?

Auto teleport by clicking on the scroll

[NoIdeaForAName]

Originally Posted by leo2111

Auto teleport by clicking on the scroll

Yes, but can you point out the rows that made it a return scroll ?

[blapanda]

Originally Posted by NoIdeaForAName

Yes, but can you point out the rows that made it a return scroll ?

You easily copy the parameters of an existing "Teleport Scroll"-Item to your new scroll.
Find the [Link] of an already existing return scroll and use it at the _RefObjItem table for the [ID] column.

Best to use is the regular "Return Scroll", shorten its "time to take till teleport" to approx 1-2 seconds, done.

Return scroll, regular one, parameters:

Param1	Desc1_128	Param2	Desc2_128	Param3	Desc3_128
30000	????		1	??????		-1	RESURRECT

30(.000) seconds till teleport, stated as "resurrect" (teleports to town with the specification of "revive there if paralyzed/dead"). Other options were teleporting to the thieves den and few others (which have to be datamined at the gameserver ).
Take the Item [ID] of the new teleport scroll and replace the one given here previously as "61508":

IF ((@Operation = 41 ) AND (@ItemRefID = 61508)) 
BEGIN 
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID 
END

Done.

[NoIdeaForAName]

Originally Posted by blapanda

You easily copy the parameters of an existing "Teleport Scroll"-Item to your new scroll.
Find the [Link] of an already existing return scroll and use it at the _RefObjItem table for the [ID] column.

Best to use is the regular "Return Scroll", shorten its "time to take till teleport" to approx 1-2 seconds, done.

Return scroll, regular one, parameters:

Param1	Desc1_128	Param2	Desc2_128	Param3	Desc3_128
30000	????		1	??????		-1	RESURRECT

30(.000) seconds till teleport, stated as "resurrect" (teleports to town with the specification of "revive there if paralyzed/dead"). Other options were teleporting to the thieves den and few others (which have to be datamined at the gameserver ).
Take the Item [ID] of the new teleport scroll and replace the one given here previously as "61508":

IF ((@Operation = 41 ) AND (@ItemRefID = 61508)) 
BEGIN 
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID 
END

Done.

Thank you, panda-daddy. I spent my entire day on these procedures and I start to understand them. I'll test later.

[D3vil Power]

Originally Posted by NoIdeaForAName

How did you make it with auto teleport?

exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID ?

Originally Posted by NoIdeaForAName

Yes, but can you point out the rows that made it a return scroll ?

Originally Posted by blapanda

You easily copy the parameters of an existing "Teleport Scroll"-Item to your new scroll.
Find the [Link] of an already existing return scroll and use it at the _RefObjItem table for the [ID] column.

Best to use is the regular "Return Scroll", shorten its "time to take till teleport" to approx 1-2 seconds, done.

Return scroll, regular one, parameters:

Param1	Desc1_128	Param2	Desc2_128	Param3	Desc3_128
30000	????		1	??????		-1	RESURRECT

30(.000) seconds till teleport, stated as "resurrect" (teleports to town with the specification of "revive there if paralyzed/dead"). Other options were teleporting to the thieves den and few others (which have to be datamined at the gameserver ).
Take the Item [ID] of the new teleport scroll and replace the one given here previously as "61508":

IF ((@Operation = 41 ) AND (@ItemRefID = 61508)) 
BEGIN 
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID 
END

Done.

good job blapanda.
i wasn't here ((

[where_love2003]

Originally Posted by D3vil Power

Made ur own Scroll ..

ِAdd To _AddLogItem

PHP Code:

IF ((@Operation = 41 ) AND (@ItemRefID = 61508)) 
BEGIN 
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID 
END 


Create New Procedure

PHP Code:

USE [SRO_VT_SHARD] 
GO 

/****** Object:  StoredProcedure [dbo].[_Scroll_Reset]    Script Date: 2/21/2016 4:06:44 PM ******/ 
SET ANSI_NULLS ON 
GO 

SET QUOTED_IDENTIFIER OFF 
GO 




CREATE PROCEDURE [dbo].[_Scroll_Reset] 
@CharID INT 
AS 

BEGIN 

        declare @TotalSP int  
        declare @TotalSPMastery int  
        SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' 
        SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '120'  
        UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 WHERE CharID=@CharID  
        DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)  
            UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'  

END 


Change 120 to your server level ,
Regards,

why this all

[NoIdeaForAName]

Originally Posted by blapanda

Param1	Desc1_128	Param2	Desc2_128	Param3	Desc3_128
30000	????		1	??????		-1	RESURRECT

PHP Code:

local overlap job exception!! : CServerProcessesOverlap 


[blapanda]

Originally Posted by NoIdeaForAName

PHP Code:

local overlap job exception!! : CServerProcessesOverlap 


You might did something wrong.
Copy the entire return scroll as it is, from common and item, adjust the id of both entries and the link, and also change the item string.
It is a failsafe method doing so.

The result will look similar to this:

[NoIdeaForAName]

Originally Posted by blapanda

You might did something wrong.
Copy the entire return scroll as it is, from common and item, adjust the id of both entries and the link, and also change the item string.
It is a failsafe method doing so.

The result will look similar to this:

Thank you for the explanation, I really appreciate members like you.

Edit : Now it says "Cannot find target" when I use it X.X

Edit 2 : I made sure the lines from itemdata45000 & RefObjCommon are the same.
The ''Cannot find target'' error is gone but when I press on the scroll, nothing happens.

PHP Code:

if(@Operation = 41 and @ItemRefID = '41807') 
BEGIN  
UPDATE SRO_VT_SHARD.._CharSkillMastery
SET Level = '100' where MasteryID =518
END 


This is what I use at _AddTimedJob

I wonder if I have to create the skilldata/skillefect again for that scroll?

Edit : Yes, the itemdata had to be same as the one of a return scroll, but it teleports me and doesn't do shit, nothing.

[Xutan*]

Originally Posted by NoIdeaForAName

Thank you for the explanation, I really appreciate members like you.

Edit : Now it says "Cannot find target" when I use it X.X

Edit 2 : I made sure the lines from itemdata45000 & RefObjCommon are the same.
The ''Cannot find target'' error is gone but when I press on the scroll, nothing happens.

PHP Code:

if(@Operation = 41 and @ItemRefID = '41807') 
BEGIN  
UPDATE SRO_VT_SHARD.._CharSkillMastery
SET Level = '100' where MasteryID =518
END 


This is what I use at _AddTimedJob

I wonder if I have to create the skilldata/skillefect again for that scroll?

Edit : Yes, the itemdata had to be same as the one of a return scroll, but it teleports me and doesn't do shit, nothing.

logdb.._AddLogItem

[blapanda]

Yea, have to be at the _AddLogItem PROC @SRO_VT_LOG.

Every item behavior and usage will be channeled through that procedure, if specifically defining an action or event with the respective item (in this case, using the new teleport scroll -> executing a new procedure -> refreshing altered skill tables @'CharID after teleport).

[NoIdeaForAName]

Originally Posted by Xutan*

logdb.._AddLogItem

Originally Posted by blapanda

Yea, have to be at the _AddLogItem PROC @SRO_VT_LOG.

Every item behavior and usage will be channeled through that procedure, if specifically defining an action or event with the respective item (in this case, using the new teleport scroll -> executing a new procedure -> refreshing altered skill tables @'CharID after teleport).

Hello and thank you for the reply.

I have added it at [dbo].[_AddLogItem] (SRO_VT_LOG) and it works flawlessly.

Moreover, I added CharID = @CharID so it will give the respective player the mastery, not every player from the server.

[GMCreative]

Originally Posted by D3vil Power

Made ur own Scroll ..

ِAdd To _AddLogItem

PHP Code:

IF ((@Operation = 41 ) AND (@ItemRefID = 61508)) 
BEGIN 
exec SRO_VT_SHARD.dbo._Scroll_Reset @CharID 
END 


Create New Procedure

PHP Code:

USE [SRO_VT_SHARD] 
GO 

/****** Object:  StoredProcedure [dbo].[_Scroll_Reset]    Script Date: 2/21/2016 4:06:44 PM ******/ 
SET ANSI_NULLS ON 
GO 

SET QUOTED_IDENTIFIER OFF 
GO 




CREATE PROCEDURE [dbo].[_Scroll_Reset] 
@CharID INT 
AS 

BEGIN 

        declare @TotalSP int  
        declare @TotalSPMastery int  
        SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' 
        SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '120'  
        UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 WHERE CharID=@CharID  
        DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '120' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)  
            UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'  

END 


Change 120 to your server level ,
Regards,

Perfect