-
Remove Points from STR/INT and Reset Skills from Char
Skill Reset
RefObjCommon
PHP Code:
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 Code:
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 Code:
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 Code:
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 Code:
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 Code:
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 Code:
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 Code:
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
-
Re: Remove Points from STR/INT and Reset Skills from Char
i'm try skills reset, but it dont work
-
Re: Remove Points from STR/INT and Reset Skills from Char
-
Re: Remove Points from STR/INT and Reset Skills from Char
-
Re: Remove Points from STR/INT and Reset Skills from Char
@longway look at my answeres in the other posts you answered to they might help you
-
Re: Remove Points from STR/INT and Reset Skills from Char
lol there is a problem wired problem.......
when chr teleport its back to lvl 100 and stats reset..... !!! automatic
any answer?
-
Re: Remove Points from STR/INT and Reset Skills from Char
This wont work if the character is online ^^' and he can't use it when he is offline so IMPOSSIBLE ! and useless
-
Re: Remove Points from STR/INT and Reset Skills from Char
how i can modify _TimedJob ??
-
Re: Remove Points from STR/INT and Reset Skills from Char
looks nice, but i do the same from a web panel, still i like it
-
Re: Remove Points from STR/INT and Reset Skills from Char
Quote:
Originally Posted by
Caosfox
looks nice, but i do the same from a web panel, still i like it
can you share to us please ?...
-
Re: Remove Points from STR/INT and Reset Skills from Char
-
Re: Remove Points from STR/INT and Reset Skills from Char
Quote:
Originally Posted by
MaDenGo
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 ^^
-
Re: Remove Points from STR/INT and Reset Skills from Char
-
Re: Remove Points from STR/INT and Reset Skills from Char
-
Re: Remove Points from STR/INT and Reset Skills from Char
Thank you worked with me :)
Credit to Caosfox & lemoniscool they told me my wrong on AddTimedJop :)
-
Re: Remove Points from STR/INT and Reset Skills from Char
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 :D Working With me
What About Skill Effect Do you Have It Please
-
Re: Remove Points from STR/INT and Reset Skills from Char
add any effect of any skill :)
-
Re: Remove Points from STR/INT and Reset Skills from Char
Quote:
Originally Posted by
arabcart
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 :D Working With me
What About Skill Effect Do you Have It Please
how you fixed it please? it's my problem too :S
-
Re: Remove Points from STR/INT and Reset Skills from Char
when i click on it it show me cannot find target why this ?
-
Re: Remove Points from STR/INT and Reset Skills from Char
skill reset add dont dont closed skills ?
-
Re: Remove Points from STR/INT and Reset Skills from Char
i'm add Reset stats and worked with me.. but after some edit's :D
-
Re: Remove Points from STR/INT and Reset Skills from Char
sherio can you share it with us ?
-
Re: Remove Points from STR/INT and Reset Skills from Char
Don't use MaxLevel use current level :P lolol
-
Re: Remove Points from STR/INT and Reset Skills from Char
Working for me but i get dc message when i use it (not crash).
any idea?
-
Re: Remove Points from STR/INT and Reset Skills from Char
for no DC remove
return -3
