Remove Points from STR/INT and Reset Skills from Char

MGProjects · May 29, 2013

Skill Reset
RefObjCommon

PHP:

1	43592	ITEM_MALL_SKILL_POINT_RECALL_A	???? ???? ??? (???)	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	21481

RefObjItem

PHP:

21481	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_A]                                                                                           	-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

PHP:

1	33801	1012	SKILL_MALL_SKILL_POINT_RECALL_A	???? ????	SKILL_MALL_SKILL_POINT_RECALL_A	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_skill_point_recall_a.ddj	SN_ITEM__MALL_SKILL_POINT_RECALL_A	xxx	SN_ITEM_MALL_SKILL_POINT_RECALL_A_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

Procedure

_TimedJob

PHP:

	  if(@JobID= '33801')
		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'
			return -3
		end

Points Reset
RefObjCommon

PHP:

1	43593	ITEM_MALL_STATS_POINT_RECALL_A	???? ???? ??? (???)	xxx	SN_ITEM_MALL_STATS_POINT_RECALL_A	SN_ITEM_MALL_STATS_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_stats_point_recall_a.ddj	xxx	xxx	21482

RefObjItem

PHP:

21482	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_STATS_POINT_RECALL_A]                                                                                           	-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

PHP:

1	33802	1013	SKILL_MALL_STATS_POINT_RECALL_A	???? ????	SKILL_MALL_STATS_POINT_RECALL_A	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_stats_point_recall_a.ddj	SN_ITEM__MALL_STATS_POINT_RECALL_A	xxx	SN_ITEM_MALL_STATS_POINT_RECALL_A_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

Procedure

_TimedJob

PHP:

	if(@JobID = '33802')
		begin
			declare @Strength int
			declare @Intellect int
			declare @MaxLevel int
			declare @RemainStatPoint int
			select @MaxLevel = MaxLevel from _Char where CharID = @CharID
			set @RemainStatPoint = (@MaxLevel*3)-3
			set @MaxLevel = @MaxLevel+19
			UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
			return -3
		end

concucu021 · May 30, 2013

i'm try skills reset, but it dont work

Hex1337 · May 30, 2013

testing.

longway · Jun 1, 2013

not working with me

lemoniscool · Jun 1, 2013

@longway look at my answeres in the other posts you answered to they might help you

Hex1337 · Jun 1, 2013

lol there is a problem wired problem.......

when chr teleport its back to lvl 100 and stats reset..... !!! automatic

any answer?

Mixizi · Jun 1, 2013

This wont work if the character is online ^^' and he can't use it when he is offline so IMPOSSIBLE ! and useless

adminsxza · Jun 2, 2013

how i can modify _TimedJob ??

Caosfox · Jun 2, 2013

looks nice, but i do the same from a web panel, still i like it

MaDenGo · Jun 2, 2013

Caosfox said:
looks nice, but i do the same from a web panel, still i like it

can you share to us please ?...

Caosfox · Jun 3, 2013

is not mine, so cant

lemoniscool · Jun 3, 2013

MaDenGo said:
can you share to us please ?...

if you want these features on a web panel, you can use the sql given here you just need some other queries to get charname/id etc and the put it together on a nice form ^^

keshk2007 · Jun 5, 2013

Nice Worked With Me

concucu021 · Jun 5, 2013

KAKA worked for me

MaDenGo · Jun 6, 2013

Thank you worked with me

Credit to Caosfox & lemoniscool they told me my wrong on AddTimedJop

arabcart · Jun 7, 2013

i add it but when i use the scroll it appear like skill then nothing happen
So Where The Problem ??
Thats's My _AddTimeJob After Edit

Code:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 06/07/2013 22:32:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddTimedJob]
@CharID            int,
@Category        tinyint,
@JobID            int,
@TimeToKeep    int,
@Data1            int,
@Data2            int,
--##begin due to develop composite item
@Data3            int,
@Data4            int,
@Data5            int,
@Data6            int,
@Data7            int,
@Data8            int,
@Serial64        bigint,
@JID            int
--##end due to develop composite item
as
    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
                return -1
            if (@TimeToKeep <= 0)
                return -2
            declare @NewJobID int
            set @NewJobID = 0

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
            --##If you want to only have one not both, then just modify the line below!
            if (@JobID = 1 or @JobID = 2)
            BEGIN
                return -1
            END
            ELSE
            BEGIN
            --##begin due to develop composite item
            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
            --##end due to develop composite item
            set @NewJobID = @@identity
            if (@@error <> 0 or @@rowcount = 0)
                
                return -3
     return @NewJobID
  if(@JobID= '35228')
        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'
            return -3 
     END
          return @NewJobID

thanks Fixed

Working With me

What About Skill Effect Do you Have It Please

MaDenGo · Jun 7, 2013

add any effect of any skill

Juilet · Jun 14, 2013

arabcart said:

i add it but when i use the scroll it appear like skill then nothing happen
So Where The Problem ??
Thats's My _AddTimeJob After Edit

Code:

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 06/07/2013 22:32:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddTimedJob]
@CharID            int,
@Category        tinyint,
@JobID            int,
@TimeToKeep    int,
@Data1            int,
@Data2            int,
--##begin due to develop composite item
@Data3            int,
@Data4            int,
@Data5            int,
@Data6            int,
@Data7            int,
@Data8            int,
@Serial64        bigint,
@JID            int
--##end due to develop composite item
as
    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
                return -1
            if (@TimeToKeep <= 0)
                return -2
            declare @NewJobID int
            set @NewJobID = 0

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
            --##If you want to only have one not both, then just modify the line below!
            if (@JobID = 1 or @JobID = 2)
            BEGIN
                return -1
            END
            ELSE
            BEGIN
            --##begin due to develop composite item
            insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
            values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
            --##end due to develop composite item
            set @NewJobID = @@identity
            if (@@error <> 0 or @@rowcount = 0)
                
                return -3
     return @NewJobID
  if(@JobID= '35228')
        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'
            return -3 
     END
          return @NewJobID

thanks Fixed

Working With me

What About Skill Effect Do you Have It Please

how you fixed it please? it's my problem too :S

thebigbody · Jun 17, 2013

when i click on it it show me cannot find target why this ?

loveme · Jul 8, 2013

skill reset add dont dont closed skills ?

Welcome!

Remove Points from STR/INT and Reset Skills from Char

Skilled Illusionist

Junior Spellweaver

Junior Spellweaver

Newbie Spellweaver

Master Summoner

Junior Spellweaver

Junior Spellweaver

Experienced Elementalist

In the Emperor name

SilkRoad vSro Service

In the Emperor name

Master Summoner

Newbie Spellweaver

Junior Spellweaver

SilkRoad vSro Service

AssassinS Silkroad

SilkRoad vSro Service

Junior Spellweaver

Skilled Illusionist

Elite Diviner

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor