19-02-2015, 11:52 AM
|
#20
|
|
|
• الانـتـسـاب » Nov 2007
|
|
• رقـم العـضـويـة » 5370
|
|
• المشـــاركـات » 1,261
|
|
• الـدولـة » https://t.me/pump_upp
|
|
• الـهـوايـة » database editor
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 19
|
|
|
  
|
.gif)
رد: Skills recall Scroll
للاسف يا حمزه انا كنت حاطيط الاسكرول ده قبلك :)
كود PHP:
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
Skilldata_3500enc
1 90020 2125 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
SkillEffect:
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
----------------------
database Line:
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
SkillGroup:
1029 SKILL_AZM0S_RESETSKILLS
---------------------------------
Produce:
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
و الموضوع بتاعي اهو
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
|
|
|
|