problem with Reset/Change Scrolls

[devdash]

help me to find those files cuz everytime i found it i discover the links are dead or the files are messing something
1. Premium Remove Scroll
2. Premium and Godbless Remove Scroll " remove everything beside the char name"
3. Reset char stats Scroll
4. Reset char skills Scroll
5. Greduate Char Scroll " this scroll give u graduate char like u leveled up a person to lv40 throw acadmy "
6. Change Char name Scroll

please i would be happy if it addlogitem_ thing because autoteleport is the best, trust me i tried before i came here so please dont call me lazy....

THANKS IN ADVANCED

[NorseGodTyr]

Originally Posted by alydandy

help me to find those files cuz everytime i found it i discover the links are dead or the files are messing something
1. Premium Remove Scroll
2. Premium and Godbless Remove Scroll " remove everything beside the char name"
3. Reset char stats Scroll
4. Reset char skills Scroll
5. Greduate Char Scroll " this scroll give u graduate char like u leveled up a person to lv40 throw acadmy "
6. Change Char name Scroll

please i would be happy if it addlogitem_ thing because autoteleport is the best, trust me i tried before i came here so please dont call me lazy....

THANKS IN ADVANCED

use your brain is easy


Skill / Stats / Change Name

RefObjCommon

1 50062 ITEM_SCROLL_VALTYR_1 ???? ???? ??? (???) xxx SN_ITEM_SCROLL_VALTYR SN_ITEM_SCROLL_VALTYR_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 ovh\change_name.ddj xxx xxx 24141
1 50063 ITEM_SCROLL_VALTYR_3 ???? ???? ??? (???) xxx SN_ITEM_SCROLL_VALTYR SN_ITEM_SCROLL_VALTYR_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 ovh\state_reset.ddj xxx xxx 24142
1 50064 ITEM_SCROLL_VALTYR_2 ???? ???? ??? (???) xxx SN_ITEM_SCROLL_VALTYR SN_ITEM_SCROLL_VALTYR_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 ovh\skill_reset.ddj xxx xxx 24143

RefObjItem

24141 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_SCROLL_VALTYR_1] -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
24142 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_SCROLL_VALTYR_2] -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
24143 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_SCROLL_VALTYR_3] -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 34595 0 SKILL_SCROLL_VALTYR_1 ???? ???? NEW_ITEMS 0 1 1 0 0 0 0 0 1000 0 0 0 0 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 ovh\change_name.ddj SN_SKILL_MALL_REMOVETEMPLE xxx SN_SKILL_MALL_REMOVETEMPLE_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
1 34596 0 SKILL_SCROLL_VALTYR_2 ???? ???? NEW_ITEMS 0 1 1 0 0 0 0 0 1000 0 0 0 0 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 ovh\state_reset.ddj SN_SKILL_MALL_REMOVETEMPLE xxx SN_SKILL_MALL_REMOVETEMPLE_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
1 34597 0 SKILL_SCROLL_VALTYR_3 ???? ???? NEW_ITEMS 0 1 1 0 0 0 0 0 1000 0 0 0 0 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 ovh\skill_reset.ddj SN_SKILL_MALL_REMOVETEMPLE xxx SN_SKILL_MALL_REMOVETEMPLE_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

SRO_VT_SHARD Procedure _AddTimedJob

if(@JobID= '34597')
begin
Declare @cname16 varchar(256);
SET @cname16 = (Select charname16 from _Char where CharID = @CharID)
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 <= '110'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '110'
UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+300000 WHERE CharID=@CharID
DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '110' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '80'
return -3
end
if(@JobID = '34596')
begin
declare @Strength int
, @Intellect int
, @MaxLevel int
, @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+29
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
return -3
end
if(@JobID = '34595') -- Change Char Name Scroll
BEGIN
Select @cname16=CharName16 from _Char where CharID = @CharID
Update _Char Set CharName16 = '@'+ @cname16 Where CharID = @CharID
return -3
END

and for add Graduates make a scroll
and add this line in SRO_VT_SHARDLOG _AddLogItem

IF(@ItemRefID = '50134' and @Operation=16) -- Job reward Valtyr Honor System
Begin
DECLARE @CampID INT
DECLARE @KillerID int SET @KillerID = @CharID
SELECT @CampID = CampID FROM SRO_VT_SHARD.[dbo].[_TrainingCampMember] WHERE CharID = @KillerID AND MemberClass = 0
IF (@CampID <> 0)
BEGIN
-- Set graduate
UPDATE [SRO_VT_SHARD].[dbo].[_TrainingCamp] SET GraduateCount = GraduateCount + 1 WHERE ID = @CampID
UPDATE [SRO_VT_SHARD].[dbo].[_TrainingCamp] SET EvaluationPoint = EvaluationPoint + 5 WHERE ID = @CampID
-- Add honor point
UPDATE SRO_VT_SHARD.[dbo].[_TrainingCampMember] SET HonorPoint = HonorPoint + 5 WHERE CharID = @KillerID
END
END

[devdash]

Originally Posted by mialuisa

use your brain is easy


Skill / Stats / Change Name

RefObjCommon


RefObjItem


RefSkill


SRO_VT_SHARD Procedure _AddTimedJob



and for add Graduates make a scroll
and add this line in SRO_VT_SHARDLOG _AddLogItem

thanks i will try that now and i will be back with the results.

Originally Posted by mialuisa

use your brain is easy


Skill / Stats / Change Name

RefObjCommon


RefObjItem


RefSkill


SRO_VT_SHARD Procedure _AddTimedJob



and for add Graduates make a scroll
and add this line in SRO_VT_SHARDLOG _AddLogItem

graduate scroll not working when i put the lines on SQL the SR_GameServer not starting.....