Mastery Scrolls New System

Dev.Ri3o

V.I.P
SQL Developer
عضو
2 فبراير 2017
289
53
17
44

المستوي:

الرابط مخفي تسجيل الدخول او تسجيل !!


الرابط مخفي تسجيل الدخول او تسجيل !!


الرابط مخفي تسجيل الدخول او تسجيل !!


الرابط مخفي تسجيل الدخول او تسجيل !!

Mastery Scrolls

طبعا كلنا عارفين ال Mastery Scrolls ومشاكل ان فى Players كتير بتعمل Bug وتفتح اكتر من Skill
عملت موضوع كامل متجرب من غير اى مشكلة ...
الرابط مخفي تسجيل الدخول او تسجيل !!

_RefObjCommon
كود:
1	49925	ITEM_MALL_MASTERY_PACHEON	?????	xxx	SN_ITEM_MALL_MASTERY_PACHEON	SN_ITEM_MALL_MASTERY_PACHEON_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_bow.ddj	xxx	xxx	81443
1	49926	ITEM_MALL_MASTERY_HEUKSAL	?????	xxx	SN_ITEM_MALL_MASTERY_HEUKSAL	SN_ITEM_MALL_MASTERY_HEUKSAL_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_spear.ddj	xxx	xxx	81444
1	49927	ITEM_MALL_MASTERY_BICHEON	?????	xxx	SN_ITEM_MALL_MASTERY_BICHEON	SN_ITEM_MALL_MASTERY_BICHEON_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_sword.ddj	xxx	xxx	81445
1	49928	ITEM_MALL_MASTERY_FIRE	?????	xxx	SN_ITEM_MALL_MASTERY_FIRE	SN_ITEM_MALL_MASTERY_FIRE_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_fire.ddj	xxx	xxx	81446
1	49929	ITEM_MALL_MASTERY_LIGHTNING	?????	xxx	SN_ITEM_MALL_MASTERY_LIGHTNING	SN_ITEM_MALL_MASTERY_LIGHTNING_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_lightning.ddj	xxx	xxx	81447
1	49930	ITEM_MALL_MASTERY_COLD	?????	xxx	SN_ITEM_MALL_MASTERY_COLD	SN_ITEM_MALL_MASTERY_COLD_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_cold.ddj	xxx	xxx	81448
1	49931	ITEM_MALL_MASTERY_FORCE	?????	xxx	SN_ITEM_MALL_MASTERY_FORCE	SN_ITEM_MALL_MASTERY_FORCE_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_water.ddj	xxx	xxx	81449
1	49932	ITEM_MALL_MASTERY_WIZARD	?????	xxx	SN_ITEM_MALL_MASTERY_WIZARD	SN_ITEM_MALL_MASTERY_WIZARD_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_wizard.ddj	xxx	xxx	81450
1	49933	ITEM_MALL_MASTERY_WARRIOR	?????	xxx	SN_ITEM_MALL_MASTERY_WARRIOR	SN_ITEM_MALL_MASTERY_WARRIOR_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_warrior.ddj	xxx	xxx	81451
1	49934	ITEM_MALL_MASTERY_ROUGE	?????	xxx	SN_ITEM_MALL_MASTERY_ROUGE	SN_ITEM_MALL_MASTERY_ROUGE_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_rog.ddj	xxx	xxx	81452
1	49935	ITEM_MALL_MASTERY_CLERICE	?????	xxx	SN_ITEM_MALL_MASTERY_CLERIC	SN_ITEM_MALL_MASTERY_CLERIC_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_cleric.ddj	xxx	xxx	81453
1	49936	ITEM_MALL_MASTERY_BARD	?????	xxx	SN_ITEM_MALL_MASTERY_BARD	SN_ITEM_MALL_MASTERY_BARD_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_bard.ddj	xxx	xxx	81454
1	49937	ITEM_MALL_MASTERY_WARLOCK	?????	xxx	SN_ITEM_MALL_MASTERY_WARLOCK	SN_ITEM_MALL_MASTERY_WARLOCK_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_warlock.ddj	xxx	xxx	81455
الرابط مخفي تسجيل الدخول او تسجيل !!

RefObjItem
كود:
81443	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	??????                                                                                                                           	-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
81444	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	??????                                                                                                                           	-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
81445	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	??????                                                                                                                           	-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
81446	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	??????                                                                                                                           	-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
81447	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	??????                                                                                                                           	-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
81448	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	??????                                                                                                                           	-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
81449	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	??????                                                                                                                           	-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
81450	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	??????                                                                                                                           	-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
81451	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	??????                                                                                                                           	-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
81452	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	??????                                                                                                                           	-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
81453	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	??????                                                                                                                           	-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
81454	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	??????                                                                                                                           	-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
81455	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	??????                                                                                                                           	-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
الرابط مخفي تسجيل الدخول او تسجيل !!

Itemdata_xxxxx
كود:
1	49925	ITEM_MALL_MASTERY_PACHEON	?????	xxx	SN_ITEM_MALL_MASTERY_PACHEON	SN_ITEM_MALL_MASTERY_PACHEON_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_bow.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	1000	????	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	49926	ITEM_MALL_MASTERY_HEUKSAL	?????	xxx	SN_ITEM_MALL_MASTERY_HEUKSAL	SN_ITEM_MALL_MASTERY_HEUKSAL_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_spear.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	1000	????	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	49927	ITEM_MALL_MASTERY_BICHEON	?????	xxx	SN_ITEM_MALL_MASTERY_BICHEON	SN_ITEM_MALL_MASTERY_BICHEON_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_sword.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	1000	????	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	49928	ITEM_MALL_MASTERY_FIRE	?????	xxx	SN_ITEM_MALL_MASTERY_FIRE	SN_ITEM_MALL_MASTERY_FIRE_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_fire.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	1000	????	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	49929	ITEM_MALL_MASTERY_LIGHTNING	?????	xxx	SN_ITEM_MALL_MASTERY_LIGHTNING	SN_ITEM_MALL_MASTERY_LIGHTNING_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_lightning.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	1000	????	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	49930	ITEM_MALL_MASTERY_COLD	?????	xxx	SN_ITEM_MALL_MASTERY_COLD	SN_ITEM_MALL_MASTERY_COLD_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_cold.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	1000	????	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	49931	ITEM_MALL_MASTERY_FORCE	?????	xxx	SN_ITEM_MALL_MASTERY_FORCE	SN_ITEM_MALL_MASTERY_FORCE_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\mastery_water.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	1000	????	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	49932	ITEM_MALL_MASTERY_WIZARD	?????	xxx	SN_ITEM_MALL_MASTERY_WIZARD	SN_ITEM_MALL_MASTERY_WIZARD_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_wizard.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	1000	????	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	49933	ITEM_MALL_MASTERY_WARRIOR	?????	xxx	SN_ITEM_MALL_MASTERY_WARRIOR	SN_ITEM_MALL_MASTERY_WARRIOR_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_warrior.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	1000	????	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	49934	ITEM_MALL_MASTERY_ROUGE	?????	xxx	SN_ITEM_MALL_MASTERY_ROUGE	SN_ITEM_MALL_MASTERY_ROUGE_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_rog.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	1000	????	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	49935	ITEM_MALL_MASTERY_CLERICE	?????	xxx	SN_ITEM_MALL_MASTERY_CLERIC	SN_ITEM_MALL_MASTERY_CLERIC_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_cleric.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	1000	????	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	49936	ITEM_MALL_MASTERY_BARD	?????	xxx	SN_ITEM_MALL_MASTERY_BARD	SN_ITEM_MALL_MASTERY_BARD_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_bard.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	1000	????	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	49937	ITEM_MALL_MASTERY_WARLOCK	?????	xxx	SN_ITEM_MALL_MASTERY_WARLOCK	SN_ITEM_MALL_MASTERY_WARLOCK_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	223	0	1	0	0	1	0	1	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\eu_warlock.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	1000	????	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
الرابط مخفي تسجيل الدخول او تسجيل !!

Textdata_Object
كود:
1	SN_ITEM_MALL_MASTERY_PACHEON								Mastery Level Up (Pacheon)
1	SN_ITEM_MALL_MASTERY_HEUKSAL								Mastery Level Up (Heuksal)
1	SN_ITEM_MALL_MASTERY_BICHEON								Mastery Level Up (Bicheon)
1	SN_ITEM_MALL_MASTERY_FIRE								Mastery Level Up (Fire)
1	SN_ITEM_MALL_MASTERY_LIGHTNING								Mastery Level Up (Lightning)
1	SN_ITEM_MALL_MASTERY_COLD								Mastery Level Up (Cold)
1	SN_ITEM_MALL_MASTERY_FORCE								Mastery Level Up (Force)
1	SN_ITEM_MALL_MASTERY_WIZARD								Mastery Level Up (Wizard)
1	SN_ITEM_MALL_MASTERY_WARRIOR								Mastery Level Up (Warrior)
1	SN_ITEM_MALL_MASTERY_ROUGE								Mastery Level Up (Rouge)
1	SN_ITEM_MALL_MASTERY_CLERIC								Mastery Level Up (Cleric)
1	SN_ITEM_MALL_MASTERY_BARD								Mastery Level Up (Bard)
1	SN_ITEM_MALL_MASTERY_WARLOCK								Mastery Level Up (Warlock)  
1	SN_ITEM_MALL_MASTERY_PACHEON_TT_DESC								<sml2>Use this scroll for Up your Pacheon Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 3 Skills For CH Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_HEUKSAL_TT_DESC								<sml2>Use this scroll for Up your Heuksal Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 3 Skills For CH Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_BICHEON_TT_DESC								<sml2>Use this scroll for Up your Bicheon Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 3 Skills For CH Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_FIRE_TT_DESC								<sml2>Use this scroll for Up your Fire Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 3 Skills For CH Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_LIGHTNING_TT_DESC								<sml2>Use this scroll for Up your Lightning Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 3 Skills For CH Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_COLD_TT_DESC								<sml2>Use this scroll for Up your Cold Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 3 Skills For CH Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_FORCE_TT_DESC								<sml2>Use this scroll for Up your Force Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 3 Skills For CH Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_WIZARD_TT_DESC								<sml2>Use this scroll for Up your Wizard Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 2 Skills For EU Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_WARRIOR_TT_DESC								<sml2>Use this scroll for Up your Warrior Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 2 Skills For EU Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_ROUGE_TT_DESC								<sml2>Use this scroll for Up your Rouge Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 2 Skills For EU Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_CLERIC_TT_DESC								<sml2>Use this scroll for Up your Cleric Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 2 Skills For EU Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_BARD_TT_DESC								<sml2>Use this scroll for Up your Bard Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 2 Skills For EU Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>  
1	SN_ITEM_MALL_MASTERY_WARLOCK_TT_DESC								<sml2>Use this scroll for Up your Warlock Skills.<br><br><strong><font color="255,236,219,156">Limits:</font></strong><br>-You Can't Open More Than 2 Skills For EU Build .<br>-use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">Dev.Ri3o</font></strong></sml2>
الرابط مخفي تسجيل الدخول او تسجيل !!

وهتعمل Excute لده
كود:
USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsBard]    Script Date: 6/12/2017 12:17:19 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsBard](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsBicheon]    Script Date: 6/12/2017 12:17:34 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsBicheon](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsClaric]    Script Date: 6/12/2017 12:17:48 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsClaric](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsCold]    Script Date: 6/12/2017 12:17:58 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsCold](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsFire]    Script Date: 6/12/2017 12:18:08 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsFire](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsForce]    Script Date: 6/12/2017 12:18:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsForce](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsHeuksal]    Script Date: 6/12/2017 12:18:39 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsHeuksal](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsLightning]    Script Date: 6/12/2017 12:18:49 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsLightning](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsPacheon]    Script Date: 6/12/2017 12:18:58 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsPacheon](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsRogue]    Script Date: 6/12/2017 12:19:07 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsRogue](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
 CONSTRAINT [PK__SkillsRogue] PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsWarlock]    Script Date: 6/12/2017 12:19:17 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWarlock](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsWarrior]    Script Date: 6/12/2017 12:19:26 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWarrior](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
 CONSTRAINT [PK__SkillsWarrior] PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_SkillsWizard]    Script Date: 6/12/2017 12:19:34 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_SkillsWizard](
	[Service] [tinyint] NOT NULL,
	[SkillID] [int] NOT NULL,
	[SkillName] [varchar](max) NOT NULL,
	[MasteryID] [int] NULL,
 CONSTRAINT [PK__SkillsWizard] PRIMARY KEY CLUSTERED 
(
	[SkillID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
الرابط مخفي تسجيل الدخول او تسجيل !!

وفى كل Table هتحط اللى مكتوب عليه اسمو

_SkillsBard
كود:
1	11189	Vibration	517
1	11199	Echo	NULL
1	11210	Music Life	NULL
1	11217	Prism	NULL
1	11245	Horror Chord	NULL
1	11261	Weird Chord	NULL
1	11284	Booming Wave	NULL
1	11295	Moving March	NULL
1	11300	Swing March	NULL
1	11311	Guard Tambour	NULL
1	11321	Mana Tambour	NULL
1	11337	Hit March	NULL
1	11340	Clout March	NULL
1	11351	Holding Clamor	NULL
1	11356	Patter Clamor	NULL
1	11363	Temptation	NULL
1	11366	Curious Temptation	NULL
1	11376	Cure Melody	NULL
1	11380	Cure Music	NULL
1	11387	Rave Melody	NULL
1	11389	Rave Harmony	NULL
1	11400	Noise	NULL
1	11432	Tuning Noise	NULL
1	11445	Tuning Sound	NULL
1	11464	Mana Wind	NULL
1	11472	Mana Breeze	NULL
1	11480	Tripping	NULL
1	11486	Screen Dance	NULL
0	11492	Dancing of Valor	NULL
0	11497	Dancing of Fight	NULL
0	11503	Dancing of Magic	NULL
0	11507	Dancing of Wizardry	NULL
0	11513	Dancing of Healing	NULL
0	11516	Dancing of Vitality	NULL
0	11522	Dancing of Mana	NULL
0	11524	Dancing of Mentality	NULL
1	30197	Booming Chord	NULL
1	30215	Mana Switch	NULL
1	30224	Discord Wave	NULL
1	30243	Mana Cycle	NULL
1	30249	Mana Orbit	NULL
_SkillsBicheon
كود:
1	298	Strike Smash	257
1	306	Stab Smash	NULL
1	314	Crosswise Smash	NULL
1	322	Illusion Chain	NULL
1	346	Blood Chain	NULL
1	378	Billow Chain	NULL
1	418	Ascension Chain	NULL
1	463	Heaven Chain	NULL
1	558	Castle Shield	NULL
1	569	Mountain Shield	NULL
1	580	Ironwall Shield	NULL
1	588	Soul Cut Blade	NULL
1	596	Evil Cut Blade	NULL
1	604	Devil Cut Blade	NULL
1	621	Blood Blade Force	NULL
1	638	Soul Blade Force	NULL
1	647	Flower Bloom Blade	NULL
1	655	Flower Bud Blade	NULL
1	672	Snake Sword Dance	NULL
1	689	Petal Sword Dance	NULL
1	699	Shield Protection	NULL
1	3140	Demon Blade Force	NULL
1	3149	Dragon Sore Blade	NULL
1	7139	Flying Stone Smash	NULL
1	7159	Twin Energy Smash	NULL
1	7203	Lightning Chain	NULL
1	7322	Thousand Army Chain	NULL
1	7371	Heavenly Chain	NULL
1	7385	Giant Shield	NULL
1	7390	Iron Castle Shield	NULL
1	7392	Sun Guard Shield	NULL
1	7404	Demon Cut Blade	NULL
1	7418	Ghost Cut Blade	NULL
1	7435	Emperor Blade	NULL
1	7450	Ocean Blade Force	NULL
1	7460	Sky Blade Force	NULL
1	7474	Asura Cut Blade	NULL
1	7484	Heavenly Blade	NULL
1	7494	Mad Dragon Blade	NULL
1	7513	Typhoon Sword Dance	NULL
1	7520	Chaotic Sword Dance	NULL
1	7526	Heaven Sword Dance	NULL
1	30578	Glacial Flame Bicheon Force	NULL
1	30584	Storm Bicheon Force	NULL
1	30590	Banshee Bicheon Force	NULL
1	30596	Summit & Depth Bicheon Force	NULL
1	30600	Celestial Ground Bicheon Force	NULL
1	30603	Light Bearers Bicheon Force	NULL
0	34009	Celestial Protection	NULL
__SkillsClaric
كود:
1	11553	Heavenly Rage	518
1	11583	Trial Cross	NULL
1	11599	Justice Cross	NULL
1	11611	Healing	NULL
1	11620	Healing Breath	NULL
1	11627	Reverse	NULL
1	11632	Grad Reverse	NULL
1	11642	Innocent	NULL
1	11648	Integrity	NULL
1	11666	Faith	NULL
1	11684	Over Healing	NULL
1	11692	Glut Healing	NULL
1	11702	Group Healing	NULL
1	11709	Group Healing Breath	NULL
1	11719	Healing Division	NULL
1	11726	Healing Favor	NULL
1	11742	Healing Cycle	NULL
1	11750	Healing Orbit	NULL
1	11766	Bless Spell	NULL
1	11776	Recovery	NULL
1	11782	Holy Recovery	NULL
1	11791	Recovery Division	NULL
1	11795	Holy Recovery Division	NULL
1	11805	Group Recovery	NULL
1	11809	Holy Group Recovery	NULL
1	11816	Group Reverse	NULL
1	11818	Holy Group Reverse	NULL
1	11823	Reverse Oblation	NULL
1	11849	Charity	NULL
1	11867	Glory Armor	NULL
1	11882	Favor Armor	NULL
1	11893	Offering	NULL
1	11901	Pure Offering	NULL
1	11913	Heaven Flash	NULL
1	11918	Heaven Glare	NULL
1	11929	Holy Word	NULL
1	11934	Holy Spell	NULL
0	11943	Force Blessing	NULL
0	11952	Force Deity	NULL
0	11961	Mental Blessing	NULL
0	11968	Mental Deity	NULL
1	11978	Body Blessing	NULL
1	11984	Body Deity	NULL
1	11993	Soul Blessing	NULL
1	11997	Soul Deity	NULL
1	33993	[Luck Increase Skill]	NULL
_SkillsCold
كود:
1	1108	Ice River Force	273
1	1116	Ice Jade Force	NULL
1	1124	Ice Ocean Force	NULL
1	1132	Weak Guard of Ice	NULL
1	1140	Soft Guard of Ice	NULL
1	1148	Power Guard of Ice	NULL
1	1153	Cold wave - Arrest	NULL
1	1158	Cold wave - Binding	NULL
1	1163	Cold wave - Shackle	NULL
1	1168	Crystal Wall	NULL
1	1173	Snow Wall	NULL
1	1178	Extreme Wall	NULL
1	1189	Frost Nova - Wind	NULL
1	1200	Frost Nova - Woods	NULL
1	1217	Snow Storm - Ice shot	NULL
1	1234	Snow Storm - Ice rain	NULL
1	1244	Cold Armor	NULL
1	3364	Ice Cloud Force	NULL
1	3379	Might Guard of Ice	NULL
1	3391	Frost Nova - Storm	NULL
1	7972	Ice Air Force	NULL
1	7975	Ice final Force	NULL
1	7980	Final Guard of Ice	NULL
1	7995	Cold Wave - Freeze	NULL
1	7998	Cold Wave - Soul	NULL
1	8010	Iceberg Wall	NULL
1	8011	Spikey Wall	NULL
1	8024	Frost Nova - Ice Field	NULL
1	8027	Frost Nova - destruction	NULL
1	8050	Snow Storm - Double Shot	NULL
1	8084	Snow Storm - Multi Shot	NULL
1	8090	Snow Storm - destruction	NULL
1	8097	Snow Shield - Novice	NULL
1	8103	Snow Shield - Adept	NULL
1	8109	Snow Shield - Freeze	NULL
1	8115	Snow Shield - Intensify	NULL
1	8119	Snow Shield - Swift	NULL
1	8122	Snow Shield _ Death	NULL
1	33933	Cold Storm	NULL
_SkillsFire
كود:
1	1377	River Fire force	275
1	1385	Extreme Fire force	NULL
1	1393	Poison Fire force	NULL
1	1398	Fire Shield - Phoenix	NULL
1	1403	Fire Shield - Flower	NULL
1	1408	Fire Shield - King	NULL
1	1410	Flame body - Wisdom	NULL
1	1412	Flame body - Power	NULL
1	1414	Flame body - Extreme	NULL
1	1422	Basic Fire protection	NULL
1	1430	Divine Fire protection	NULL
1	1438	Hard Fire protection	NULL
1	1443	Fire Wall - Tower	NULL
1	1448	Fire Wall - Mountain	NULL
1	1465	Flame Wave - Arrow	NULL
1	1482	Flame Wave - Burning	NULL
1	1499	Flame Wave - Wide	NULL
1	1509	Flame Devil Force	NULL
1	3430	Soul Fire force	NULL
1	3436	Fire Shield - Emperor	NULL
1	3446	Fire Wall - Castle	NULL
1	8214	Cloud Fire force	NULL
1	8217	God Fire Force	NULL
1	8220	Flame Body - Trial	NULL
1	8221	Flame Body - God	NULL
1	8222	Flame Body - God	NULL
1	8238	Earth Fire Protection	NULL
1	8239	God Fire Protection	NULL
1	8250	Fire Wall - Fortress	NULL
1	8254	Fire Wall - God	NULL
1	8276	Flame Wave - Bomb	NULL
1	8291	Flame Wave - HellFire	NULL
1	8304	Flame Wave - Disintegrate	NULL
1	8310	Flame Wave - God	NULL
1	8316	Fire Combustion - Firefly	NULL
1	8320	Fire Combustion - Light	NULL
1	21215	Vision Fire Combustion	NULL
1	21217	Sunrise combustion	NULL
1	33935	Flame Body - Yang	NULL
1	33936	Flame Wave - Legend	NULL
_SkillsForce
كود:
1	1518	Self Breathe Heal	276
1	1526	Self Force Heal	NULL
1	1534	Self Wounds Heal	NULL
1	1539	Force Cure - Poison	NULL
1	1544	Force Cure - Body	NULL
1	1549	Force Cure - Condiion	NULL
1	1557	Heal - Medical Hand	NULL
1	1565	Heal - Ghost Hand	NULL
1	1573	Heal - Taoist Hand	NULL
1	1578	Soul Rebirth Art	NULL
1	1583	Ghost Rebirth Art	NULL
1	1588	Spirit Rebirth Art	NULL
1	1593	Harmony Therapy	NULL
1	1598	Adaptation Therapy	NULL
1	1609	Vital Spot - Muscle	NULL
1	1617	Vital Spot - Spirit	NULL
1	1628	Force Increasing	NULL
1	3461	Self Vital Heal	NULL
1	3467	Force Cure - Vital	NULL
1	3473	Whole Therapy	NULL
1	8338	Self Breathing Heal	NULL
1	8347	Force Cure - Meditation	NULL
1	8348	Force Cure - overall	NULL
1	8361	Heal - Mysterious Hand	NULL
1	8370	Heal - Full Hand	NULL
1	8379	Return Rebirth Art	NULL
1	8383	Godly Rebirth Art	NULL
1	8390	Source Therapy	NULL
1	8399	Vital Spot - Body	NULL
1	8405	Vital Spot - Mind	NULL
1	8410	Vital Spot - Zero	NULL
1	8414	Vital Spot - Brain	NULL
1	8416	Vital Spot - Faint	NULL
1	20494	Cure Therapy - Pure	NULL
1	20497	Cure Therapy - Protection	NULL
1	20500	Cure Therapy - Clarity	NULL
1	33991	[Balance Legend Skill]	NULL
1	33992	[Luck Increase Skill]	NULL
1	34019	Resurrection - Spirit Binding	NULL
1	34021	Resurrection - Spirit Calling	NULL
_SkillsHeuksal
كود:
1	708	Wolf Bite Spear	258
1	716	Waning Moon Spear	NULL
1	724	Yuhon Spear	NULL
1	735	Bloody Fan Storm	NULL
1	746	Bloody Wolf Storm	NULL
1	757	Bloody Snake Storm	NULL
1	765	Dancing Demon Spear	NULL
1	773	Jade Breaking Spear	NULL
1	781	Spirit Crash Spear	NULL
1	789	Soul Spear - Move	NULL
1	797	Soul Spear - Truth	NULL
1	805	Soul Spear - Soul	NULL
1	813	Ghost Spear - Petal	NULL
1	821	Ghost Spear - Prince	NULL
1	829	Chain Spear - Tiger	NULL
1	853	Chain Spear - Nachal	NULL
1	885	Chain Spear - Shura	NULL
1	925	Flying Dragon - Flow	NULL
1	933	Flying Dragon - Fly	NULL
1	943	Cheolsam Force	NULL
1	3167	Ghost Spear - Mars	NULL
1	3176	Chain Spear - Pluto	NULL
1	3224	Chain Spear - Dragon	NULL
1	7536	Lightning Bird Spear	NULL
1	7554	Celestial Cloud Spear	NULL
1	7564	Asura Spear	NULL
1	7577	Bloody Demon Storm	NULL
1	7582	Bloody Ghost Storm	NULL
1	7584	Bloody Emperor Storm	NULL
1	7596	Windless Spear	NULL
1	7612	Death Bringer Spear	NULL
1	7620	Pitch Black Spear	NULL
1	7637	Soul Spear - Emperor	NULL
1	7651	Soul Spear - Destruction	NULL
1	7661	Soul Spear - Emptiness	NULL
1	7672	Ghost Spear - Storm Cloud	NULL
1	7675	Ghost Spear - Emperor	NULL
1	7678	Ghost Spear - Sea God	NULL
1	7688	Chain Spear - Phoenix	NULL
1	7769	Chain Spear - Heaven	NULL
1	7798	Flying Dragon - Bless	NULL
1	7805	Flying Dragon - Flash	NULL
1	7819	Flying Dragon - Sky	NULL
1	33931	Heuksal storm	NULL
0	34014	Immortal Victor	NULL
_SkillsLightning
كود:
1	1253	Thunder Tiger Force	274
1	1261	Thunder Sky Force	NULL
1	1269	Thunder King Force	NULL
1	1271	Must - Piercing Force	NULL
1	1273	Flow - Piercing Force	NULL
1	1275	Speed - Piercing Force	NULL
1	1286	Grass Walk - Flow	NULL
1	1297	Ghost Walk - phantom	NULL
1	1308	Grass Walk - Speed	NULL
1	1316	Shock Lion Shout	NULL
1	1324	Heaven Lion Shout	NULL
1	1332	Earth Lion Shout	NULL
1	1337	Concentration - 1st	NULL
1	1342	Concentration - 2nd	NULL
1	1350	Wolf's Thunderbolt	NULL
1	1358	Tiger's Thunderbolt	NULL
1	1368	Heaven's Force	NULL
1	3406	Thunder Dragon Force	NULL
1	3409	Force - Piercing Force	NULL
1	3415	Concentration - 3rd	NULL
1	8129	Thunder Phoenix Force	NULL
1	8132	Thunder God Force	NULL
1	8134	God - Piercing Force	NULL
1	8142	Ghost Walk - Shadow	NULL
1	8150	Ghost Walk - God	NULL
1	8164	Power Lion Shout	NULL
1	8171	Execution Lion Shout	NULL
1	8174	God Lion Shout	NULL
1	8183	Concentration - 4th	NULL
1	8184	Concentration - 5th	NULL
1	8195	Horse's Thunderbolt	NULL
1	8204	Crane's Thunderbolt	NULL
1	8205	God's Thunderbolt	NULL
1	33934	Light Storm	NULL
_SkillsPacheon
كود:
1	952	Anti Devil Bow - Missile	259
1	960	Anti Devil Bow - Wave	NULL
1	968	Anti Devil Bow - Steel	NULL
1	976	2 Arrow Combo	NULL
1	984	3 Arrow Combo	NULL
1	992	4 Arrow Combo	NULL
1	1003	White Hawk Summon	NULL
1	1014	Black Hawk Summon	NULL
1	1025	Blue Hawk Summon	NULL
1	1033	Autumn Wind - Flame	NULL
1	1041	Autumn Wind - Snake	NULL
1	1049	Autumn Wind - Blood	NULL
1	1053	Demon Soul Arrow	NULL
1	1057	Bloody Soul Arrow	NULL
1	1065	Berserker Arrow	NULL
1	1073	Demon Arrow	NULL
1	1081	Strong Bow - Spirit	NULL
1	1089	Strong Bow - Vision	NULL
1	1099	Mind Concentration	NULL
1	3340	Dragon Soul Arrow	NULL
1	3349	Devil Arrow	NULL
1	7829	Anti Devil Bow - Strike	NULL
1	7838	Anti Devil Bow - Annihilate	NULL
1	7839	Anti Devil Bow - Demolition	NULL
1	7844	Anti Devil Bow - Moon light	NULL
1	7853	5 Arrow Combo	NULL
1	7862	6 Arrow Combo	NULL
1	7877	Lightning Hawk Summon	NULL
1	7881	Ice Hawk	NULL
1	7885	Fire Hawk	NULL
1	7894	Autumn Wind - Red	NULL
1	7899	Autumn Wind - Devil	NULL
1	7902	Autumn Wind - Dragon	NULL
1	7907	Phoenix Soul Arrow	NULL
1	7908	Ice Hawk Soul Arrow	NULL
1	7919	Celestial Beast Arrow	NULL
1	7920	Pitch Black Arrow	NULL
1	7931	Strong Bow - Craft	NULL
1	7938	Strong Bow - Will	NULL
1	7941	Strong Bow - Destruction	NULL
1	7947	Mind Bow - Flower	NULL
1	7953	Mind Bow - Butterfly	NULL
1	7959	Mind Bow - Swift	NULL
1	7963	Mind Bow - Lighting	NULL
1	33932	Bow Storm	NULL
1	34004	Dragon Scale	NULL
_SkillsRogue
كود:
1	9364	Stealth Extension	515
1	9369	Scorn	NULL
1	9373	Gross Scorn	NULL
1	9378	Stealth	NULL
1	9382	Intensive Stealth	NULL
1	9388	Destealth	NULL
1	9392	Intensive Destealth	NULL
1	9397	Tag Point	NULL
1	9400	Hunting Point	NULL
1	9407	Poison Weapons	NULL
1	9411	Vein Weapon	NULL
1	9417	Poison Circle	NULL
1	9421	Vein Circle	NULL
1	9428	Poison Field	NULL
1	9430	Bane Field	NULL
1	9437	Poison Trap	NULL
1	9438	Vein Trap	NULL
1	9444	Monster Mask	NULL
1	9449	Beast Mask	NULL
1	9453	Duplicate	NULL
1	9454	Sable Duplicate	NULL
1	9481	Crossbow Power Up	NULL
1	9489	Wide Sight	NULL
1	9499	Avoid	NULL
1	9516	Crossbow Extreme	NULL
1	9528	Power Shot	NULL
1	9544	Intense Shot	NULL
1	9574	Fast Shot	NULL
1	9587	Rapid Shot	NULL
1	9601	Long Shot	NULL
1	9612	Distance Shot	NULL
1	9623	Blast Shot	NULL
1	9631	Hurricane Shot	NULL
1	9672	Dagger Power Up	NULL
1	9686	Hawk Eye	NULL
1	9703	Dagger Desperate	NULL
1	9714	Poison Power Up	NULL
1	9721	Venom Extension	NULL
1	9736	Stealth Dagger	NULL
1	9742	Quick Step	NULL
1	9770	Spinning	NULL
1	9785	Wounds	NULL
1	9798	Mortal Wounds	NULL
1	9844	Scud	NULL
1	9868	Screw	NULL
1	9880	Combo Blow	NULL
1	9897	Butterfly Blow	NULL
1	9940	Prick	NULL
_SkillsWarlock
كود:
1	10652	Dark Seed	516
1	10659	Strap	NULL
1	10687	Blaze	NULL
1	10705	Dark Blaze	NULL
1	10733	Toxin	NULL
1	10748	Toxin Invasion	NULL
1	10774	Decayed	NULL
1	10787	Dark Decayed	NULL
1	10807	Curse Breath	NULL
1	10818	Dark Breath	NULL
1	10831	Physical Raze	NULL
1	10837	Physical Ravage	NULL
1	10847	Medical Raze	NULL
1	10852	Magical Ravage	NULL
1	10861	Combat Raze	NULL
1	10865	Combat Ravage	NULL
1	10873	Courage Raze	NULL
1	10876	Courage Ravage	NULL
1	10904	Red Flower	NULL
1	10916	Trap Booster	NULL
1	10944	Blood Flower	NULL
1	10963	Death Flower	NULL
1	10972	Bloody Trap	NULL
1	10976	Death Trap	NULL
1	10987	Daze	NULL
1	10992	Wrath Daze	NULL
1	11002	Fog Sight	NULL
1	11006	Curse Sight	NULL
1	11011	Illusion	NULL
1	11015	Shade Illusion	NULL
1	11042	Blood Aim	NULL
1	11072	Vampire Kiss	NULL
1	11086	Shadow Armor	NULL
1	11097	Dusk Armor	NULL
0	11108	Scream Mask	NULL
1	11117	Advanced Reflect	NULL
1	11128	Slumber	NULL
1	11133	Deep Slumber	NULL
1	11143	Wheel Bind	NULL
1	11147	Recovery Bind	NULL
1	11154	Mirage	NULL
1	11160	Phantasma	NULL
1	30186	Vampire Touch	NULL
1	30193	Reflect	NULL
_SkillsWarrior
كود:
1	8438	Taunting Target	513
1	8449	Howling Shout	NULL
1	8467	Vital Increase	NULL
1	8477	Descry	NULL
1	8499	Sprint Assault	NULL
1	8513	Iron Skin	NULL
1	8524	Mana Skin	NULL
0	8531	Pain Quota	NULL
0	8545	Physical Fence	NULL
0	8558	Magical Fence	NULL
1	8572	Protect	NULL
1	8583	Physical Screen	NULL
1	8597	Ultimate Screen	NULL
1	8626	One-Handed Arms	NULL
1	8647	Power Shield	NULL
1	8659	Blockade	NULL
1	8669	Critical Void	NULL
1	8697	Slash	NULL
1	8710	Shield Trash	NULL
1	8723	Shield Crush	NULL
1	8752	Double Stab	NULL
1	8775	Cunning Stab	NULL
1	8812	Berserker	NULL
1	8829	Daring Berserker	NULL
1	8881	Two-Handed Arms	NULL
1	8894	Concentration	NULL
1	8904	Damage Return	NULL
1	8932	Bash	NULL
1	8961	Turn Rising	NULL
1	8974	Charge Swing	NULL
1	8997	Triple Swing	NULL
1	9034	Maddening	NULL
1	9042	Dare Devil	NULL
1	9073	Warcry	NULL
1	9102	Dual Arms	NULL
1	9115	Accuracy	NULL
1	9125	Protection	NULL
1	9143	Dual Defense	NULL
1	9172	Down Cross	NULL
1	9187	Double Twist	NULL
1	9212	Sudden Twist	NULL
1	9249	Axis Quiver	NULL
1	9262	Dual Counter	NULL
1	9285	Deadly Counter	NULL
1	9322	Crisis Rush	NULL
1	9339	Crutial Rush	NULL
1	21225	Morale Screen	NULL
_SkillsWizard
كود:
1	9951	Intelligence	514
1	9956	Magic Bound	NULL
1	9965	Life Control	NULL
1	9972	Life Turnover	NULL
1	10001	Earth Spirit	NULL
1	10017	Ground Charge	NULL
1	10030	Ground Rave	NULL
1	10042	Root	NULL
1	10047	Mesh Root	NULL
1	10062	Earth Shock	NULL
1	10070	Earth Quake	NULL
1	10076	Earth Barrier	NULL
1	10078	Earth Fence	NULL
1	10106	Cold Spirit	NULL
1	10122	Ice Bolt	NULL
1	10135	Frozen Spear	NULL
1	10162	Mana Drain	NULL
1	10167	Mana Drought	NULL
1	10182	Snow Wind	NULL
1	10190	Blizzard	NULL
1	10201	Invisible	NULL
1	10206	Crystal Invisible	NULL
1	10234	Fire Spirit	NULL
1	10264	Fire Bolt	NULL
1	10280	Meteor	NULL
1	10296	Fire Trap	NULL
1	10307	Lava Trap	NULL
1	10323	Fire Blow	NULL
1	10415	Salamander Blow	NULL
1	10489	Detect	NULL
1	10493	Sprawl Detect	NULL
1	10521	Lightning Spirit	NULL
1	10537	Lightning Bolt	NULL
1	10550	Chain Lightning	NULL
1	10562	Lightning Shock	NULL
1	10567	Lightning Impact	NULL
1	10582	Charged Wind	NULL
1	10604	Charged Squall	NULL
1	10621	Teleport	NULL
1	10623	Aerial Teleport	NULL
الرابط مخفي تسجيل الدخول او تسجيل !!

شوية صور... فاتح 2 Mastery

الرابط مخفي تسجيل الدخول او تسجيل !!

ولو جربت تفتح ال 3
الرابط مخفي تسجيل الدخول او تسجيل !!

مش هيحصل اى حاجة
الرابط مخفي تسجيل الدخول او تسجيل !!

الرابط مخفي تسجيل الدخول او تسجيل !!

انا عامل Select لل CH او EU يعنى تقدر لو معاك برنامج Notice تعمل بى Else الاول عشان لو فى اكتر من 2 ده لل EU و 3 لل CH و Else وتحط شرط ان لو ال CharObjID يبعت Notice ان ال scroll مش للنوع بتاعو وممكن تحط شرط لو ال mastery مفتوحة يقولو دى مفتوحة مينعش تفتحها تانى
الرابط مخفي تسجيل الدخول او تسجيل !!

Procedure #AddlogItem
كود:
------------------------Mastery Scrolls ------#Ri3o
---- Warrior Skills Scroll 
----------------------------------
   Declare @CharObjID Int, @MasteryCount Int, @MasteryID Int
   Select @CharObjID = RefObjID From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
   Set @MasteryCount = (Select Count (*) From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and Level > 0)
  IF (@ItemRefID = 49933) 
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarrior] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarrior] Where Service = 1
		 END
		 END
		 END
		 END
---- Dagger Skills Scroll 
----------------------------------
		  IF (@ItemRefID = 49934) 
       Begin
		 IF @CharObjID > 3000
		 Begin
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsRogue] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsRogue] Where Service = 1
		 END
		 END
		 END
		 END
---- Wizard Skills Scroll 
----------------------------------
      IF (@ItemRefID = 49932) 
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWizard] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWizard] Where Service = 1
		 End 
		 END
		 END
       End
---- Warlock Skills Scroll 
----------------------------------
      IF (@ItemRefID = 49937)
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarlock] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarlock] Where Service = 1
		 End 
		 END
		 End
       End

 -- Bard Skills Scroll 
-------------------------------
      IF (@ItemRefID = 49936) 
       Begin
		 IF @CharObjID > 3000
		 Begin
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBard] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBard] Where Service = 1
		 End 
		 END
		 End
       End

  -- Claric Skills Scroll 
---------------------------------
      IF (@ItemRefID = 49935) 
       Begin
		 IF @CharObjID > 3000
		 Begin 
		 IF @MasteryCount between 0 and 1 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsClaric] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsClaric] Where Service = 1
		 End 
		 End
         End
		 END
 ---- Bicheon Skills Scroll 
----------------------------------
      IF (@ItemRefID = 49927) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBicheon] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBicheon] Where Service = 1
		 End 
		 END
		 End
       End

 ---- Heuksal Skills Scroll
----------------------------------
      IF (@ItemRefID = 49926) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsHeuksal] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsHeuksal] Where Service = 1
		 End 
		 END
		 END
       End

 ---- Pacheon Skills Scroll
----------------------------------
      IF (@ItemRefID = 49925) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsPacheon] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsPacheon] Where Service = 1
		 End 
		 END
		 End
       End

 ---- Cold Skills Scroll 
-------------------------------
      IF (@ItemRefID = 49930) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsCold] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsCold] Where Service = 1
		 End 
		 End
		 End
       End

 ---- Lightning Skills Scroll 
-------------------------------------
      IF (@ItemRefID = 49929) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsLightning] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsLightning] Where Service = 1
		 End 
		 End
		 End
       End

 ---- Fire Skills Scroll 
--------------------------------
      IF (@ItemRefID = 49928) 
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsFire] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsFire] Where Service = 1
		 End 
		 End
		 End
       End

 ---- Force Skills Scroll 
---------------------------------
      IF (@ItemRefID = 49931) -- RefObjCommon ID
       Begin
		 IF @CharObjID < 3000
		 Begin 
		 IF @MasteryCount between 0 and 2 
		 Begin
		 Set @MasteryID = (Select MasteryID From [dbo].[_SkillsForce] Where MasteryID Is Not Null)
		 IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
		 Begin
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
		 Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
		 Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsForce] Where Service = 1
		 End 
		 End
       End
	   END
الرابط مخفي تسجيل الدخول او تسجيل !!

Icons
الرابط مخفي تسجيل الدخول او تسجيل !!

pw : Dev.Ri3o

الرابط مخفي تسجيل الدخول او تسجيل !!

طبعا واحد هيجى يقولى طب لو انا سيرفرى 120 او 125 او 130 او حتى 140 اعمل ايه .. ؟
بسيطة جدا ... ايه اللى انت بتضيفو فى ال Table ؟ هو Max Up من كل skill يعنى شوف اخر lvl لكل خانة فيها Skill كام واكتب ال ID بتاعو ... خلى بالك لو انت 120 مش هتضيف IDs جديدة انت هتعدل بس على ال 110 اللى موجودة فى ال Table

الرابط مخفي تسجيل الدخول او تسجيل !!

الرابط مخفي تسجيل الدخول او تسجيل !!

 




التعديل الأخير:

Dev.Ri3o

V.I.P
SQL Developer
عضو
2 فبراير 2017
289
53
17
44

المستوي:

رد: Mastery Scrolls New System

تمم انا معدل علي ال 110 و ظبط الايدي بتاع ال RefObjcommon علي ال prodacure و الاسكيل مش بتفتح اي حاجة من اي بقا

اتأكد من ال IDs بتاعة ال scroll انك مش عامل ال RefObjCommon Identity لل ID عشان ميرتبهمش لوحدو خلى ال IDs بتاعة ال RefObjCommon هى هى اللى فى ال Procedure
 




ahmedayman

عضو
9 يناير 2018
4
0
1
cairo

المستوي:

رد: Mastery Scrolls New System

I have problem here sql error
-------------------
------------------------Mastery Scrolls ------#Ri3o
---- Warrior Skills Scroll
----------------------------------
Declare @CharObjID Int, @MasteryCount Int, @MasteryID Int
Select @CharObjID = RefObjID From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @MasteryCount = (Select Count (*) From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and Level > 0)
IF (@ItemRefID = 49933)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarrior] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarrior] Where Service = 1
END
END
END
END
---- Dagger Skills Scroll
----------------------------------
IF (@ItemRefID = 49934)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsRogue] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsRogue] Where Service = 1
END
END
END
END
---- Wizard Skills Scroll
----------------------------------
IF (@ItemRefID = 49932)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWizard] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWizard] Where Service = 1
End
END
END
End
---- Warlock Skills Scroll
----------------------------------
IF (@ItemRefID = 49937)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsWarlock] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsWarlock] Where Service = 1
End
END
End
End

-- Bard Skills Scroll
-------------------------------
IF (@ItemRefID = 49936)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBard] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBard] Where Service = 1
End
END
End
End

-- Claric Skills Scroll
---------------------------------
IF (@ItemRefID = 49935)
Begin
IF @CharObjID > 3000
Begin
IF @MasteryCount between 0 and 1
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsClaric] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsClaric] Where Service = 1
End
End
End
END
---- Bicheon Skills Scroll
----------------------------------
IF (@ItemRefID = 49927)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsBicheon] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsBicheon] Where Service = 1
End
END
End
End

---- Heuksal Skills Scroll
----------------------------------
IF (@ItemRefID = 49926)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsHeuksal] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsHeuksal] Where Service = 1
End
END
END
End

---- Pacheon Skills Scroll
----------------------------------
IF (@ItemRefID = 49925)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsPacheon] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsPacheon] Where Service = 1
End
END
End
End

---- Cold Skills Scroll
-------------------------------
IF (@ItemRefID = 49930)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsCold] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsCold] Where Service = 1
End
End
End
End

---- Lightning Skills Scroll
-------------------------------------
IF (@ItemRefID = 49929)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsLightning] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsLightning] Where Service = 1
End
End
End
End

---- Fire Skills Scroll
--------------------------------
IF (@ItemRefID = 49928)
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsFire] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsFire] Where Service = 1
End
End
End
End

---- Force Skills Scroll
---------------------------------
IF (@ItemRefID = 49931) -- RefObjCommon ID
Begin
IF @CharObjID < 3000
Begin
IF @MasteryCount between 0 and 2
Begin
Set @MasteryID = (Select MasteryID From [dbo].[_SkillsForce] Where MasteryID Is Not Null)
IF Not Exists (Select * From [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Where CharID = @CharID and MasteryID = @MasteryID and Level > 1)
Begin
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 0 Where CharID = @CharID and Level = 1
Update [SRO_VT_SHARD].[dbo].[_CharSkillMastery] Set Level = 110 Where MasteryID = @MasteryID and CharID = @CharID
Insert Into [SRO_VT_SHARD].[dbo].[_CharSkill] (CharID,SkillID,Enable) Select @CharID, SkillID, '1' From [dbo].[_SkillsForce] Where Service = 1
End
End
End
END