Skills recall Scroll

[Hamza FiGo]

Skills recall Scroll

Simply this scroll set ur Skills at ( S ) to 0 with one shot. Not like skill edit.

*********
Data Base
*********

RefObjCommon

1	70005	ITEM_MALL_SKILL_RECALL	???? ???? ??? (???)	xxx	SN_ITEM_MALL_SKILL_POINT_RECALL_A	SN_ITEM_MALL_SKILL_POINT_RECALL_A_TT_DESC	1	0	3	3	13	14	180000	3	0	1	1	1	255	0	1	0	0	129	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\mall_skill_point_recall_a.ddj	xxx	xxx	60002

RefObjItem

60002	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????(?)	1	[USU1:SKILL_MALL_SKILL_POINT_RECALL_A1]                                                                                          	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

Refskill

1	59702	1013	SKILL_MALL_SKILL_POINT_RECALL_A1	???? ????	SKILL_MALL_SKILL_POINT_RECALL_A1	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_MALL_CHANGENAME	xxx	SN_SKILL_MALL_CHANGENAME_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

_AddTimedJob procedure

if(@JobID= '59702')
		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 <= '130'
			SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '130' 
			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 <= '130' 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 <= '130' 
		return -3
		end

**********
Media Side
**********

itemdata_45000

1	60091	ITEM_MALL_SKILL_RECALL	???? ???? ??? (???)	xxx	SN_ITEM_MALL_SKILL_POINT_RECALL_A	SN_ITEM_MALL_SKILL_POINT_RECALL_A_TT_DESC	1	0	3	3	13	14	180000	3	0	1	1	1	255	0	1	0	0	129	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\mall_skill_point_recall_a.ddj	xxx	xxx	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????(?)	1	[USU1:SKILL_MALL_SKILL_POINT_RECALL_A1]                                                                                          	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

skilldata_xxxxxenc

1	59669	1013	SKILL_MALL_SKILL_POINT_RECALL_A1	???? ????	SKILL_MALL_SKILL_POINT_RECALL_A1	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_MALL_CHANGENAME	xxx	SN_SKILL_MALL_CHANGENAME_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

skilleffect

1	귀환서 사용전	SKILL_MALL_SKILL_POINT_RECALL_A1	0	FALSE	0	DEFAULT	none	none	none	none	none	none	none	none	0	0,0,0,0	ONE	none	none	none	none	none	none	none	0	1	



귀환서 사용전	SKILL_MALL_SKILL_POINT_RECALL_A1	ACT_S	0	FALSE	none	none	0	0	0	0	1	0,0	AT_LOOP	MOV_NONE,0,0,0	0,0,0	false,0,0,0,0,false	system\	item_returnscroll.efp	none	0,0,0	none	0,0,0	none	0	none	none	none

textdata_object

1	SN_ITEM_MALL_SKILL_POINT_RECALL_A								Skill Reset Scroll

I don`t know its released before or not. Just made it for who need it.
If released before. just ignore it

[Crue*]

too old
and there's alot of threads about it

[Hamza FiGo]

Originally Posted by Crue*

too old
and there's alot of threads about it

Ah ok sry. didn`t notice.

I don`t know its released before or not. Just made it for who need it.
If released before. just ignore it

[pushipu]

And like any skill reset, you must to Change map to take effect, too bad is not possible to make it working like in official.

[Syloxx]

Originally Posted by pushipu

And like any skill reset, you must to Change map to take effect, too bad is not possible to make it working like in official.

auto teleport after activating the scroll is possible

[Hamza FiGo]

nothin impossible pro. just make it like that

[Syloxx]

find your misstake

[​Exo]

_RefObjItem=> Make it a return scroll

[Tyr*]

I prefer copying the return scrolls _refobjcommon and _refobjitem lines . then add this trigger to _AddLogItem at LOG DB It will be better and easier ^^ btw thanks for this release

Also add these to your release so it's a good collection ^^

Change name
add this to _AddLogItem at log db

If(@Operation = '41' and @ItemRefID = '41412')

begin
declare @CharName16 varchar(64)
Select @CharName16=CharName16 from SRO_VT_SHARD.._Char where CharID = @CharID
Update SRO_VT_SHARD.._Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID
Declare @NewCharName varchar (64) = (select CharName16 from SRO_VT_SHARD.._Char where CharID = @CharID and Charname 16 not like '%@%')
update SRO_VT_SHARD.._CharNameList set Charname16 = @NewCharName
update SRO_VT_SHARD.._Friend set FriendCharname = @NewCharName where FriendCharName = @CharName16
Update SRO_VT_SHARD.._GuildMember set CharName = @NewCharName where CharName = @CharName16
end

Stats Reset
Add this to _AddLogItem at Log db

if(@Operation = '41' and @RefItemID = '41415') -- 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

Remove Premium
Add this to _AddLogChar @ Log DB

If(@Operation= '41')
if(@ItemRefID= '41894')
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

Remove Adv Elixir
Add this to _AddLogItem @ Log DB

if(@operation = '41' and @ItemRefID = '90015') -- Adv Remover
begin
DECLARE @ItemID varchar (64)
SELECT @ItemID=ItemID from SRO_VT_SHARD.._Inventory where CharID = @CharID AND Slot = '13'
DELETE FROM SRO_VT_SHARD.._BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM SRO_VT_SHARD.._Inventory WHERE Slot = '13' AND CharID=@CharID) and bOptType=2
end

[Hamza FiGo]

If i could n`t make it teleporting auto, simply i can give a DC by adding return -3.

[pushipu]

Originally Posted by hamzafigo

If i could n`t make it teleporting auto, simply i can give a DC by adding return -3.

Everyone can do that, but it's not sexy

[​Exo]

Originally Posted by Tyr*

then add this trigger to _AddLogItem at LOG DB
Also add these to your release so it's a good collection ^^

Sorry but adding a trigger for this is stupid, you have the SP, or make another SP so the original SP wouldn't be full of ****.

[Tyr*]

Originally Posted by hamzafigo

If i could n`t make it teleporting auto, simply i can give a DC by adding return -3.

NO, Return -3 cancels the sql query/command and dc's the user. simply, like nothing happened.

[​Exo]

Guys, JUST copy the instant return scroll lines, make another copy, problem solved!

[H3llkings]

Old But usefull