| pop2009 |
08-09-2014 02:59 PM |
حصريا Reset Skill Scroll & Reset Holy Water Temple Time
http://imageshack.com/a/img743/1483/jz3ewZ.gif
اولا: ٌReset Skill Scroll
http://imageshack.com/a/img631/4807/8CIOYC.gif
كود PHP:
if(@JobID= '90020') -- remove skills
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'
end
RefObjCommon
كود PHP:
1 91682 ITEM_AZM0S_RESETSKILLS ???? ???? xxx SN_ITEM_AZM0S_RESETSKILLS SN_ITEM_AZM0S_RESETSKILLS_TT_DESC 0 0 3 3 13 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_ch_eventbox.bsr item\etc\mall_skill_point_recall_a.ddj xxx xxx 91682
RefObjItem
كود PHP:
21485 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 0 SKILL_AZM0S_RESETSKILLS -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 -1 xxx 0 0 0
RefSkill
كود PHP:
1 33915 1029 SKILL_AZM0S_RESETSKILLS ???? ???? SKILL_AZM0S_RESETSKILLS 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_dungeon_free_ticket_forgotten_world.ddj SN_ITEM_AZM0S_RESETSKILLS xxx SN_ITEM_AZM0S_RESETSKILLS_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 6000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Skill Group
كود PHP:
1029 SKILL_AZM0S_RESETSKILLS
Itemdata_45000
كود PHP:
1 91682 ITEM_AZM0S_RESETSKILLS ???? ???? xxx SN_ITEM_AZM0S_RESETSKILLS SN_ITEM_AZM0S_RESETSKILLS_TT_DESC 0 0 3 3 13 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -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 0 SKILL_AZM0S_RESETSKILLS -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 -1 xxx 0 0
Skill Effect
كود PHP:
1 ??? ??? SKILL_AZM0S_RESETSKILLS 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_AZM0S_RESETSKILLS 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
كود PHP:
1 SN_ITEM_AZM0S_RESETSKILLS Skills reset scroll
http://imageshack.com/a/img631/4807/8CIOYC.gif
ثانيا Reset Holy Water Temple Time
كود PHP:
RefObjCommon:
1 45981 ITEM_MALL_HOLY_WATER ???? ???? ??? (???) xxx SN_ITEM_MALL_HOLY_WATER SN_ITEM_MALL_HOLY_WATER_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_change_name.ddj xxx xxx 21554
RefObjItem:
21554 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_HOLY_WATER] -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 33796 1012 SKILL_MALL_HOLY_WATER ???? ???? SKILL_MALL_HOLY_WATER 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_HOLY_WATER xxx SN_SKILL_MALL_HOLY_WATER_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
RefSkillGroup:
1012 SKILL_MALL_HOLY_WATER
____________________
Media Side :
ITEMDATA_45000:
1 45981 ITEM_MALL_HOLY_WATER ???? ???? ??? (???) xxx SN_ITEM_MALL_HOLY_WATER SN_ITEM_MALL_HOLY_WATER_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_change_name.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 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 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_CHANGENAME_KARA] -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
Textdata_Object:
1 SN_ITEM_MALL_HOLY_WATER Reset Temple Time Scroll
1 SN_ITEM_MALL_HOLY_WATER_TT_DESC Reset Temple Time by Sheko.
Skilleffect:
1 ??? ??? SKILL_MALL_HOLY_WATER 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_HOLY_WATER 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
Produce
كود PHP:
-----------------------
--By:PoP2009--
-----------------------
if(@JobID= 'Job ID')-- Holy temple remove
begin
delete from _CharInstanceWorldData where CharID= @CharID
return -3
end
http://imageshack.com/a/img631/4807/8CIOYC.gif
تم بحمد الله
|
