|
|
• الانـتـسـاب » Nov 2007
|
|
• رقـم العـضـويـة » 5370
|
|
• المشـــاركـات » 1,261
|
|
• الـدولـة » https://t.me/pump_upp
|
|
• الـهـوايـة » database editor
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 19
|
|
|
  
|
.gif)
حصريا Reset Skill Scroll & Reset Holy Water Temple Time
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
اولا: ٌReset Skill Scroll
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
1029 SKILL_AZM0S_RESETSKILLS
|
Itemdata_45000
|
|
|
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
|
|
|
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
|
|
|
1 SN_ITEM_AZM0S_RESETSKILLS Skills reset scroll
|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
ثانيا Reset Holy Water Temple Time
|
|
|
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
|
|
|
-----------------------
--By:PoP2009--
-----------------------
if(@JobID= 'Job ID')-- Holy temple remove
begin
delete from _CharInstanceWorldData where CharID= @CharID
return -3
end
|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تم بحمد الله
|
08-09-2014, 02:59 PM
المواضيع المتشابهه
العرض العادي
