الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**Hamza FiGo** · 03-01-2015, 03:04 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة _Miss_AngeL_ عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

MASTERY LIMIT !!@@ ليه برنامج ؟!
مش عارف تعمله في لـ Procedure ؟!!
و بتقولي مش المفروض تتقالي ؟@ طب المصحف ما انا رادد

لا للاسف معرفش اعملة في Procedure وارينا انت . ولا انت شاطر في النقض بس. مشوفتلكش رد علي واحد نفعته بكلمة

ناس عايشة للنقض وياريته نقض بناء . طالما مش عايز تساعد حد يبقي ميلزمناش ردك من اساسة وخلي معلوماتك لنفسك

**Hamza FiGo** · 03-01-2015, 05:40 PM

Just i`m done with u. No more speaking with.... don`t have to complete

**merazz012** · 04-01-2015, 04:08 AM

تمام ؟ ! يا حمزه اخلص امتاحنات وراجع تاني اشاء الله

**Hero** · 08-01-2015, 04:09 PM

يا جدعان هوا لازم فى كل موضوع حوار

**Hamza FiGo** · 08-01-2015, 06:18 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Hero عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

يا جدعان هوا لازم فى كل موضوع حوار

انا مش عارف بصراحة لازم الناس تفتي وتعرفنا انها فاهمة . كلمة كويسة كانت تكفي ولو مش عاجبة الموضوع ميردش ويريحنا

**Hero** · 08-01-2015, 07:36 PM

حصل خير يا معلم

**Dev. iLegend** · 08-01-2015, 09:06 PM

تسلم يا باشا مجهود رائع في إنتظار المزيد

**Hamza FiGo** · 09-01-2015, 03:50 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة Lazcano عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

تسلم يا باشا مجهود رائع في إنتظار المزيد

فية بس لسة ماتوافقش علية ^_^ . شكرا علي مرورك

**™Shi6on** · 09-01-2015, 10:40 PM

اسـتمر يا باشا ... والله معلـــم ^_^

**Dev. iLegend** · 10-01-2015, 12:14 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة hamzafigo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

Exclusive: Mastery lvlup SCROLL

الموضوع باين من عنوانة . اخيرا بعد معاناه قدرت اعرف لية الاسكرولات دي مش شغالة . انا شوفت الموضوع هنا بس مش كامل

قولت افيد الناس بيةوالاسكرول دي محدش ومفيش حد كان هيرضي ينزلها. المهم نيجي للــ Lines علي طول

RefObjCommon

كود:

1	70009	ITEM_SWORD_MASTRY_UP	?? ???	xxx	SN_ITEM_SWORD_MASTRY_UP	SN_ITEM_SWORD_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_sword.ddj	xxx	xxx	60010
1	70010	ITEM_GLAIVE_MASTRY_UP	?? ???	xxx	SN_ITEM_GLAIVE_MASTRY_UP	SN_ITEM_GLAIVE_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_spear.ddj	xxx	xxx	60011
1	70011	ITEM_BOW_MASTRY_UP	?? ???	xxx	SN_ITEM_BOW_MASTRY_UP	SN_ITEM_BOW_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_bow.ddj	xxx	xxx	60012
1	70012	ITEM_COLD_MASTRY_UP	?? ???	xxx	SN_ITEM_COLD_MASTRY_UP	SN_ITEM_COLD_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_cold.ddj	xxx	xxx	60013
1	70013	ITEM_LIGHT_MASTRY_UP	?? ???	xxx	SN_ITEM_LIGHT_MASTRY_UP	SN_ITEM_LIGHT_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_lighting.ddj	xxx	xxx	60014
1	70014	ITEM_FIRE_MASTRY_UP	?? ???	xxx	SN_ITEM_FIRE_MASTRY_UP	SN_ITEM_FIRE_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_fire.ddj	xxx	xxx	60015
1	70015	ITEM_FORCE_MASTRY_UP	?? ???	xxx	SN_ITEM_FORCE_MASTRY_UP	SN_ITEM_FORCE_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_WATER.ddj	xxx	xxx	60016

RefObjItem

كود:

60010	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
60011	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
60012	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
60013	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
60014	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
60015	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
60016	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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	59705	1013	SKILL_SWORD_MASTRY_UP	???? ????	SKILL_SWORD_MASTRY_UP	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_SWORD_MASTRY_UP	xxx	SN_SKILL_SWORD_MASTRY_UP_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
1	59706	1013	SKILL_GLAIVE_MASTRY_UP	???? ????	SKILL_GLAIVE_MASTRY_UP	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_GLAIVE_MASTRY_UP	xxx	SN_SKILL_GLAIVE_MASTRY_UP_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
1	59707	1013	SKILL_BOW_MASTRY_UP	???? ????	SKILL_BOW_MASTRY_UP	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_BOW_MASTRY_UP	xxx	SN_SKILL_BOW_MASTRY_UP_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
1	59708	1013	SKILL_COLD_MASTRY_UP	???? ????	SKILL_COLD_MASTRY_UP	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_COLD_MASTRY_UP	xxx	SN_SKILL_COLD_MASTRY_UP_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
1	59709	1013	SKILL_LIGHT_MASTRY_UP	???? ????	SKILL_LIGHT_MASTRY_UP	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_LIGHT_MASTRY_UP	xxx	SN_SKILL_LIGHT_MASTRY_UP_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
1	59710	1013	SKILL_FIRE_MASTRY_UP	???? ????	SKILL_FIRE_MASTRY_UP	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_FIRE_MASTRY_UP	xxx	SN_SKILL_FIRE_MASTRY_UP_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
1	59711	1013	SKILL_FORCE_MASTRY_UP	???? ????	SKILL_FORCE_MASTRY_UP	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_FORCE_MASTRY_UP	xxx	SN_SKILL_FORCE_MASTRY_UP_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

_AddLogItem >> at ShardLog
دي اللي كانت مدوخة الناس واهم حاجة علشان الاسكرولات تشتغل

كود:

if(@Operation = 41 and @ItemRefID= '70009')
BEGIN 
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level = '130' WHERE MasteryID=257

INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,2,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,40,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,70,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,298,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,306,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,314,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,322,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,346,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,378,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,418,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,463,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,558,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,569,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,580,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,588,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,596,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,604,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,647,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,655,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,672,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,689,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,699,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3149,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7139,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7159,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7203,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7322,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7385,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7390,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7392,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7404,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7418,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7474,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7484,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7513,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7520,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30578,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30584,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30590,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30596,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,30600,1) 
end
if(@Operation = 41 and @ItemRefID= '70013')
BEGIN 
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level = '130' WHERE MasteryID=274

INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1253,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1261,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1269,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1271,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1273,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1275,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1286,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1297,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1308,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1316,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1324,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1332,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1337,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1342,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1350,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1358,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1368,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3406,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3409,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3415,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8129,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8133,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8142,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8150,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8164,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8171,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8183,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8195,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8204,1) 
end
if(@Operation = 41 and @ItemRefID= '70010')
BEGIN 
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level = '130' WHERE MasteryID=258

INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,708,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,716,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,724,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,735,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,746,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,757,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,765,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,773,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,781,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,789,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,797,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,805,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,813,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,821,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,829,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,853,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,885,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,925,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,933,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,943,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3167,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3176,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3224,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7536,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7554,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7577,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7582,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7584,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7596,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7612,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7637,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7651,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7672,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7675,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7688,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7798,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7805,1) 
end
if(@Operation = 41 and @ItemRefID= '70015')
BEGIN 
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level = '130' WHERE MasteryID=276

INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1518,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1526,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1534,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1539,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1544,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1549,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1557,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1565,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1573,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1578,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1583,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1588,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1593,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1598,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1609,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1617,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1628,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3461,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3467,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3473,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8338,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8347,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8348,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8361,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8370,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8379,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8383,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8390,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8399,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8405,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8410,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8414,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8416,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20494,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20497,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,20500,1) 
end
if(@Operation = 41 and @ItemRefID= '70014')
BEGIN 
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level = '130' WHERE MasteryID=275

INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1377,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1385,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1393,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1398,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1403,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1408,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1410,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1412,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1414,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1422,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1430,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1438,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1443,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1448,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1465,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1482,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1499,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1509,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3430,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3431,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3446,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8214,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8220,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8221,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8238,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8239,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8250,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8253,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8276,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8291,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8304,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8316,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8320,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21215,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,21217,1) 
end
if(@Operation = 41 and @ItemRefID= '70012')
BEGIN 
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level = '130' WHERE MasteryID=273

INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1108,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1116,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1124,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1132,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1140,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1148,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1153,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1158,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1163,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1168,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1173,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1178,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1189,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1200,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1217,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1234,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1244,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3364,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3379,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3391,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7972,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7980,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7995,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7997,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8010,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8024,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8050,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8084,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8097,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8103,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8109,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8115,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,8119,1) 
end
if(@Operation = 41 and @ItemRefID= '70011')
BEGIN 
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level = '130' WHERE MasteryID=259

INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,952,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,960,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,968,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,976,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,984,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,992,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1003,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1014,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1025,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1033,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1041,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1049,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1053,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1057,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1065,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1073,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1081,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1089,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,1099,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3340,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,3349,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7829,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7838,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7839,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7853,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7862,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7877,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7881,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7894,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7899,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7907,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7919,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7931,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7938,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7947,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7953,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7959,1) 
INSERT INTO SRO_VT_SHARD.._CharSkill VALUES (@CharID,7962,1) 
end

itemdata_xxxxx

كود:

1	70009	ITEM_SWORD_MASTRY_UP	?? ???	xxx	SN_ITEM_SWORD_MASTRY_UP	SN_ITEM_SWORD_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_sword.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
1	70010	ITEM_GLAIVE_MASTRY_UP	?? ???	xxx	SN_ITEM_GLAIVE_MASTRY_UP	SN_ITEM_GLAIVE_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_spear.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
1	70011	ITEM_BOW_MASTRY_UP	?? ???	xxx	SN_ITEM_BOW_MASTRY_UP	SN_ITEM_BOW_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_bow.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
1	70012	ITEM_COLD_MASTRY_UP	?? ???	xxx	SN_ITEM_COLD_MASTRY_UP	SN_ITEM_COLD_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_cold.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
1	70013	ITEM_LIGHT_MASTRY_UP	?? ???	xxx	SN_ITEM_LIGHT_MASTRY_UP	SN_ITEM_LIGHT_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_lightning.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
1	70014	ITEM_FIRE_MASTRY_UP	?? ???	xxx	SN_ITEM_FIRE_MASTRY_UP	SN_ITEM_FIRE_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_fire.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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
1	70015	ITEM_FORCE_MASTRY_UP	?? ???	xxx	SN_ITEM_FORCE_MASTRY_UP	SN_ITEM_FORCE_MASTRY_UP_TT_DESC	0	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-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	skillmastery\china\mastery_WATER.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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_xxxxenc

كود:

1	59705	1013	SKILL_SWORD_MASTRY_UP	???? ????	SKILL_SWORD_MASTRY_UP	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_SWORD_MASTRY_UP	xxx	SN_SKILL_SWORD_MASTRY_UP_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
1	59706	1013	SKILL_GLAIVE_MASTRY_UP	???? ????	SKILL_GLAIVE_MASTRY_UP	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_GLAIVE_MASTRY_UP	xxx	SN_SKILL_GLAIVE_MASTRY_UP_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
1	59707	1013	SKILL_BOW_MASTRY_UP	???? ????	SKILL_BOW_MASTRY_UP	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_BOW_MASTRY_UP	xxx	SN_SKILL_BOW_MASTRY_UP_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
1	59708	1013	SKILL_COLD_MASTRY_UP	???? ????	SKILL_COLD_MASTRY_UP	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_COLD_MASTRY_UP	xxx	SN_SKILL_COLD_MASTRY_UP_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
1	59709	1013	SKILL_LIGHT_MASTRY_UP	???? ????	SKILL_LIGHT_MASTRY_UP	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_LIGHT_MASTRY_UP	xxx	SN_SKILL_LIGHT_MASTRY_UP_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
1	59710	1013	SKILL_FIRE_MASTRY_UP	???? ????	SKILL_FIRE_MASTRY_UP	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_FIRE_MASTRY_UP	xxx	SN_SKILL_FIRE_MASTRY_UP_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
1	59711	1013	SKILL_FORCE_MASTRY_UP	???? ????	SKILL_FORCE_MASTRY_UP	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_FORCE_MASTRY_UP	xxx	SN_SKILL_FORCE_MASTRY_UP_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

textdata_object

كود:

1	SN_ITEM_SWORD_MASTRY_UP								Sword Mastery UP Scroll							
1	SN_ITEM_GLAIVE_MASTRY_UP								Glaive Mastery UP Scroll							
1	SN_ITEM_BOW_MASTRY_UP								BOW Mastery UP Scroll							
1	SN_ITEM_COLD_MASTRY_UP								Cold Mastery UP Scroll							
1	SN_ITEM_LIGHT_MASTRY_UP								Lighting Mastery UP Scroll							
1	SN_ITEM_FIRE_MASTRY_UP								Fire Mastery UP Scroll							
1	SN_ITEM_FORCE_MASTRY_UP								Force Mastery UP Scroll							
1	SN_ITEM_SWORD_MASTRY_UP_TT_DESC								Sword Mastery UP Scroll By [GM] Figoz.							
1	SN_ITEM_GLAIVE_MASTRY_UP_TT_DESC								Glaive Mastery UP Scroll By [GM] Figoz.	 						
1	SN_ITEM_BOW_MASTRY_UP_TT_DESC								BOW Mastery UP Scroll By [GM] Figoz.							
1	SN_ITEM_COLD_MASTRY_UP_TT_DESC								Cold Mastery UP Scroll By [GM] Figoz.							
1	SN_ITEM_LIGHT_MASTRY_UP_TT_DESC								Lighting Mastery UP Scroll By [GM] Figoz.							
1	SN_ITEM_FIRE_MASTRY_UP_TT_DESC								Fire Mastery UP Scroll By [GM] Figoz.							
1	SN_ITEM_FORCE_MASTRY_UP_TT_DESC								Force Mastery UP Scroll By [GM] Figoz.

هيطلعلي واحد يقولي الــ Procedure طويلة كدة لية اقولة لو عندك حاجة احسن نزلها وفيد بيها الناس احسن ما تقول كلمتين زي دول

ودا فيديو للتاكيد

[YOUTUBE]CSoI4dHZFb8[/YOUTUBE]

الموضوع مش منقول. تحياتي

باشا ممكن سؤال معلش مدام انت عامل الـ Procedure يشتغل على الـ RefItemID بالـ dbo._AddLogItem
عامل ليه RefSkill اصل الاكواد اللي انا شايفها دي في الـ RefObjItem مش مربوطة بسكيلس في Refskill دي معمولة RESURRECT يعني ريترن سكرول .. مش لازملها RefSkill تقريباً مدام انت شغال ع الـ RefItemID

**Hamza FiGo** · 10-01-2015, 02:50 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة Lazcano عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

باشا ممكن سؤال معلش مدام انت عامل الـ Procedure يشتغل على الـ RefItemID بالـ dbo._AddLogItem
عامل ليه RefSkill اصل الاكواد اللي انا شايفها دي في الـ RefObjItem مش مربوطة بسكيلس في Refskill دي معمولة RESURRECT يعني ريترن سكرول .. مش لازملها RefSkill تقريباً مدام انت شغال ع الـ RefItemID

كلامك سليم يا باشا. ضايف انا الـ RefSkills علشان لو حد عندة procedure تانية يستخدمها علي طول

يعني هيا فعلا زيادة بس زيادة للي يحب يشتغل علي حاجة تانية

**Dev. iLegend** · 10-01-2015, 03:26 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة hamzafigo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

كلامك سليم يا باشا. ضايف انا الـ RefSkills علشان لو حد عندة procedure تانية يستخدمها علي طول

يعني هيا فعلا زيادة بس زيادة للي يحب يشتغل علي حاجة تانية

أهــا تمام يا برنس .. سؤال تاني معلش :) انا عملت بنفس الطريقة دي الـ Reset stats scroll
ولغيت طبعاً لينك الـ RefObjItem اللي بيربط بالـ RefSkill وشيلتها من الـ dbo._AddTimedJob تمام وعملتها RESURRECT
انها تبقا ريترن سكرول .. وروحت حطيت الـ Procedure بتاعها في الـ dbo._AddLogItem مع تغيير طبعاً اول سطر بتاع الـ Operation والـ RefItemID
وعدلت كذا حاجة كدا عشان الـ Procedure مش فى الـ Shard دا في الـ Log db .. وعمل Excute تمام بس الاسكرول بتعمل ريترن للمدينة ومش بتشغل وظيفية الريسيت ستيت

**Hamza FiGo** · 11-01-2015, 01:52 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة Lazcano عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

أهــا تمام يا برنس .. سؤال تاني معلش :) انا عملت بنفس الطريقة دي الـ Reset stats scroll
ولغيت طبعاً لينك الـ RefObjItem اللي بيربط بالـ RefSkill وشيلتها من الـ dbo._AddTimedJob تمام وعملتها RESURRECT
انها تبقا ريترن سكرول .. وروحت حطيت الـ Procedure بتاعها في الـ dbo._AddLogItem مع تغيير طبعاً اول سطر بتاع الـ Operation والـ RefItemID
وعدلت كذا حاجة كدا عشان الـ Procedure مش فى الـ Shard دا في الـ Log db .. وعمل Excute تمام بس الاسكرول بتعمل ريترن للمدينة ومش بتشغل وظيفية الريسيت ستيت

لو مش بتعمل وظيفتها يبقي الــ Procedure فيها حاجة غلط. لازم الــ Procedure تكون مظبوطة بنسبة 100% علشان الاسكرول تشتغل

**pop2009** · 12-01-2015, 01:27 AM

عايزين ال Euro تعرف تجبهلنا ؟ انا شوفت كذه لعبه عملاها

**Hamza FiGo** · 12-01-2015, 01:47 AM

اقتباس:

المشاركة الأصلية كتبت بواسطة pop2009 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

عايزين ال Euro تعرف تجبهلنا ؟ انا شوفت كذه لعبه عملاها

ياباشا اولا انا مش جايب الــ CHN انا اللي عاملها . واظن مش هتلاقيها في مكان تاني غير هنا

ثانيا بالنسبة للـ Euro المشكلة الوحيدة بس في الــ ID كتيير ومملة

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟

شـريـط الاهـداءات