vSro İtem Kilitleme Sistemi

Musa KURTGÖZ

ViP Üye
Katılım
23 Tem 2015
Mesajlar
1,698
Puanları
38
Yaş
21
Konum
K.MARAŞ
bu sistem bir çok kişi tarafından aranmakta idi bir forumda gördüm paylaşmak istedim. silkroad item kilit sistemidir. Çoğu kişi bunu ücretli olarak vermekte ama vsroforum.com farkı ile ücretsiz şekilde kullanabilirsiniz.

ilk olarak yeni tablo oluşturun:

Kod:
Use [SRO_VT_SHARDLOG]
Create Table [dbo].[LockItemsID]
([LockItemID] [Int] NOT NULL PRIMARY KEY ,
[ReqItemID] [Int] NOT NULL)
kilitlemek istediğiniz silahları kod içerisinde değiştirin kodlarda 15dg silahlar bulunmaktadır.

örnek olarak
Kod:
1	40315	ITEM_EU_DAGGER_15_A_RARE	15? ?? (??)	xxx	SN_ITEM_EU_DAGGER_15_A_RARE	SN_ITEM_EU_DAGGER_15_A_RARE_TT_DESC	0	0	3	1	6	13	180000	1	2	1	1	1	255	3	1	1	1	0	0	19748000	14667	22000	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\dagger_91.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\dagger_15.ddj	xxx	xxx	1	2	0	0	43	0	157	236	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	3	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	4	25	1	ITEM_EU_DAGGER_15_A_RARE	1	ITEM_EU_DAGGER_15_B_RARE	1	ITEM_EU_DAGGER_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40336	ITEM_EU_SWORD_15_A_RARE	15? ??? (??)	xxx	SN_ITEM_EU_SWORD_15_A_RARE	SN_ITEM_EU_SWORD_15_A_RARE_TT_DESC	0	0	3	1	6	7	180000	1	2	1	1	1	255	3	1	1	1	0	0	17773000	10353	15530	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\sword_91.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\sword_15.ddj	xxx	xxx	1	2	0	0	43	0	111	167	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	2	15	1	ITEM_EU_SWORD_15_A_RARE	1	ITEM_EU_SWORD_15_B_RARE 	1	ITEM_EU_SWORD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40357	ITEM_EU_TSWORD_15_A_RARE	15? ??? (??)	xxx	SN_ITEM_EU_TSWORD_15_A_RARE	SN_ITEM_EU_TSWORD_15_A_RARE_TT_DESC	0	0	3	1	6	8	180000	1	2	1	1	1	255	3	1	1	1	0	0	19748000	8628	12941	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\tsword_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\tsword_15.ddj	xxx	xxx	1	2	0	0	43	0	93	139	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	18	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	2	15	1	ITEM_EU_TSWORD_15_A_RARE	1	ITEM_EU_TSWORD_15_B_RARE	1	ITEM_EU_TSWORD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40378	ITEM_EU_AXE_15_A_RARE	15? ???? (??)	xxx	SN_ITEM_EU_AXE_15_A_RARE	SN_ITEM_EU_AXE_15_A_RARE_TT_DESC	0	0	3	1	6	9	180000	1	2	1	1	1	255	3	1	1	1	0	0	19748000	14667	22000	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\axe_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\axe_15.ddj	xxx	xxx	1	2	0	0	43	0	157	236	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	6	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	2	15	1	ITEM_EU_AXE_15_A_RARE	1	ITEM_EU_AXE_15_B_RARE	1	ITEM_EU_AXE_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40399	ITEM_EU_CROSSBOW_15_A_RARE	15? ????? (??)	xxx	SN_ITEM_EU_CROSSBOW_15_A_RARE	SN_ITEM_EU_CROSSBOW_15_A_RARE_TT_DESC	0	0	3	1	6	12	180000	1	2	1	1	1	255	3	1	1	1	0	0	19748000	10353	15530	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\crossbow_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\crossbow_15.ddj	xxx	xxx	1	2	0	0	43	0	111	167	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	180	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	4	20	1	ITEM_EU_CROSSBOW_15_A_RARE	1	ITEM_EU_CROSSBOW_15_B_RARE 	1	ITEM_EU_CROSSBOW_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40420	ITEM_EU_DARKSTAFF_15_A_RARE	15? ???? (??)	xxx	SN_ITEM_EU_DARKSTAFF_15_A_RARE	SN_ITEM_EU_DARKSTAFF_15_A_RARE_TT_DESC	0	0	3	1	6	10	180000	1	2	1	1	1	255	3	1	1	1	0	0	17773000	8628	12941	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\darkstaff_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\darkstaff_15.ddj	xxx	xxx	1	2	0	0	43	0	185	278	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_DARKSTAFF_15_A_RARE	1	ITEM_EU_DARKSTAFF_15_B_RARE	1	ITEM_EU_DARKSTAFF_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40441	ITEM_EU_TSTAFF_15_A_RARE	15? ??? (??)	xxx	SN_ITEM_EU_TSTAFF_15_A_RARE	SN_ITEM_EU_TSTAFF_15_A_RARE_TT_DESC	0	0	3	1	6	11	180000	1	2	1	1	1	255	3	1	1	1	0	0	19748000	8628	12941	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\tstaff_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\tstaff_15.ddj	xxx	xxx	1	2	0	0	43	0	93	139	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_TSTAFF_15_A_RARE	1	ITEM_EU_TSTAFF_15_B_RARE	1	ITEM_EU_TSTAFF_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40462	ITEM_EU_HARP_15_A_RARE	15? ?? (??)	xxx	SN_ITEM_EU_HARP_15_A_RARE	SN_ITEM_EU_HARP_15_A_RARE_TT_DESC	0	0	3	1	6	14	180000	1	2	1	1	1	255	3	1	1	1	0	0	19748000	7765	11647	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\harp_12.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\harp_15.ddj	xxx	xxx	1	2	0	0	43	0	83	125	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_HARP_15_A_RARE	1	ITEM_EU_HARP_15_B_RARE	1	ITEM_EU_HARP_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40483	ITEM_EU_STAFF_15_A_RARE	15? ??? ?? (??)	xxx	SN_ITEM_EU_STAFF_15_A_RARE	SN_ITEM_EU_STAFF_15_A_RARE_TT_DESC	0	0	3	1	6	15	180000	1	2	1	1	1	255	3	1	1	1	0	0	19748000	8628	12941	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\staff_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\staff_15.ddj	xxx	xxx	1	2	0	0	43	0	93	139	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_STAFF_15_A_RARE	1	ITEM_EU_STAFF_15_B_RARE 	1	ITEM_EU_STAFF_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	40504	ITEM_EU_SHIELD_15_A_RARE	15? ?? ?? (??)	xxx	SN_ITEM_EU_SHIELD_15_A_RARE	SN_ITEM_EU_SHIELD_15_A_RARE_TT_DESC	0	0	3	1	4	2	180000	1	2	1	1	1	255	3	1	1	1	0	0	9874000	9059	13588	0	9000	3455900	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\shield\shield_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\shield\shield_15.ddj	xxx	xxx	1	2	0	0	43	0	97	146	648.4	683.8	17.9	0	0	0	0	0	0	14	23	1037.4	1094	28.6	0	0	0	721	796	1153	1273	0	0	0	0	0	0	2	0	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	ITEM_EU_SHIELD_15_A_RARE	1	ITEM_EU_SHIELD_15_B_RARE	1	ITEM_EU_SHIELD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S	-1	xxx	-1	xxx	-1	xxx	-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	?? ??? ?? ?? ?	9	0

1	39370	ITEM_CH_SWORD_15_A_RARE	15? ? (??)	xxx	SN_ITEM_CH_SWORD_15_A_RARE	SN_ITEM_CH_SWORD_15_A_RARE_TT_DESC	0	0	3	1	6	2	180000	0	2	1	1	1	255	3	1	1	1	0	0	17773000	12294	18441	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\sword_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\sword_15.ddj	xxx	xxx	1	2	0	0	43	0	148	181	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	4349	4586	4902	5169	127.7	7400	7804	8507	8971	219.6	4930	5130	5558	5782	8390	8729	9645	10035	142	303	0	4	16	1	ITEM_CH_SWORD_15_A_RARE	1	ITEM_CH_SWORD_15_B_RARE 	1	ITEM_CH_SWORD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	39391	ITEM_CH_BLADE_15_A_RARE	15? ? (??)	xxx	SN_ITEM_CH_BLADE_15_A_RARE	SN_ITEM_CH_BLADE_15_A_RARE_TT_DESC	0	0	3	1	6	3	180000	0	2	1	1	1	255	3	1	1	1	0	0	17773000	13588	20382	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\blade_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\blade_15.ddj	xxx	xxx	1	2	0	0	43	0	164	200	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	4625	4878	5317	5607	137.3	6958	7337	7843	8271	204.4	5244	5456	6028	6272	7889	8207	8892	9251	142	303	0	3	15	1	ITEM_CH_BLADE_15_A_RARE	1	ITEM_CH_BLADE_15_B_RARE 	1	ITEM_CH_BLADE_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	39412	ITEM_CH_SPEAR_15_A_RARE	15? ? (??)	xxx	SN_ITEM_CH_SPEAR_15_A_RARE	SN_ITEM_CH_SPEAR_15_A_RARE_TT_DESC	0	0	3	1	6	4	180000	0	2	1	1	1	255	3	1	1	1	0	0	19748000	8196	12294	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\spear_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\spear_15.ddj	xxx	xxx	1	2	0	0	43	0	99	121	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	18	4539	4786	5403	5698	137.3	7781	8205	9510	10029	238.8	5146	5354	6126	6374	8822	9178	10782	11218	142	303	0	5	17	1	ITEM_CH_SPEAR_15_A_RARE	1	ITEM_CH_SPEAR_15_B_RARE 	1	ITEM_CH_SPEAR_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	39433	ITEM_CH_TBLADE_15_A_RARE	15? ?? (??)	xxx	SN_ITEM_CH_TBLADE_15_A_RARE	SN_ITEM_CH_TBLADE_15_A_RARE_TT_DESC	0	0	3	1	6	5	180000	0	2	1	1	1	255	3	1	1	1	0	0	19748000	9059	13588	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\tblade_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\tblade_15.ddj	xxx	xxx	1	2	0	0	43	0	109	134	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	18	4863	5128	5944	6268	149.2	7262	7658	8645	9117	219.6	5514	5736	6739	7011	8234	8566	9802	10198	142	303	0	4	16	1	ITEM_CH_TBLADE_15_A_RARE	1	ITEM_CH_TBLADE_15_B_RARE	1	ITEM_CH_TBLADE_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	39454	ITEM_CH_BOW_15_A_RARE	15? ? (??)	xxx	SN_ITEM_CH_BOW_15_A_RARE	SN_ITEM_CH_BOW_15_A_RARE_TT_DESC	0	0	3	1	6	6	180000	0	2	1	1	1	255	3	1	1	1	0	0	19748000	9318	13977	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\bow_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\bow_15.ddj	xxx	xxx	1	2	0	0	43	0	112	137	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	2	1	180	4399	4639	5391	5686	135.2	7039	7423	8626	9097	216.3	4988	5189	6113	6360	7981	8303	9780	10175	142	303	0	4	14	1	ITEM_CH_BOW_15_A_RARE	1	ITEM_CH_BOW_15_B_RARE	1	ITEM_CH_BOW_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	39475	ITEM_CH_SHIELD_15_A_RARE	15? ?? (??)	xxx	SN_ITEM_CH_SHIELD_15_A_RARE	SN_ITEM_CH_SHIELD_15_A_RARE_TT_DESC	0	0	3	1	4	1	180000	0	2	1	1	1	255	3	1	1	1	0	0	9874000	9059	13588	0	9000	3455900	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\shield\shield_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\shield\shield_15.ddj	xxx	xxx	1	2	0	0	43	0	109	134	648.4	683.8	17.9	0	0	0	0	0	0	14	23	1037.4	1094	28.6	0	0	0	735	765	1235	1285	0	0	0	0	0	0	2	0	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	ITEM_CH_SHIELD_15_A_RARE	1	ITEM_CH_SHIELD_15_B_RARE	1	ITEM_CH_SHIELD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S	-1	xxx	-1	xxx	-1	xxx	-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	?? ??? ?? ?? ?	9	0
15dg kilitli silahlar:
Kod:
1	80315	ITEM_EU_DAGGER_15_A_RARE_CHAOS	15? ?? (??)	xxx	SN_ITEM_EU_DAGGER_15_A_RARE_CHAOS	SN_ITEM_EU_DAGGER_15_A_RARE_TT_DESC	0	0	3	1	6	13	180000	1	2	0	0	0	0	0	0	0	0	0	0	19748000	14667	22000	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\dagger_91.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\dagger_15.ddj	xxx	xxx	1	2	0	0	43	0	157	236	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	3	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	4	25	1	ITEM_EU_DAGGER_15_A_RARE_CHAOS	1	ITEM_EU_DAGGER_15_B_RARE	1	ITEM_EU_DAGGER_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80336	ITEM_EU_SWORD_15_A_RARE_CHAOS	15? ??? (??)	xxx	SN_ITEM_EU_SWORD_15_A_RARE_CHAOS	SN_ITEM_EU_SWORD_15_A_RARE_TT_DESC	0	0	3	1	6	7	180000	1	2	0	0	0	0	0	0	0	0	0	0	17773000	10353	15530	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\sword_91.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\sword_15.ddj	xxx	xxx	1	2	0	0	43	0	111	167	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	2	15	1	ITEM_EU_SWORD_15_A_RARE_CHAOS	1	ITEM_EU_SWORD_15_B_RARE 	1	ITEM_EU_SWORD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80357	ITEM_EU_TSWORD_15_A_RARE_CHAOS	15? ??? (??)	xxx	SN_ITEM_EU_TSWORD_15_A_RARE_CHAOS	SN_ITEM_EU_TSWORD_15_A_RARE_TT_DESC	0	0	3	1	6	8	180000	1	2	0	0	0	0	0	0	0	0	0	0	19748000	8628	12941	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\tsword_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\tsword_15.ddj	xxx	xxx	1	2	0	0	43	0	93	139	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	18	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	2	15	1	ITEM_EU_TSWORD_15_A_RARE_CHAOS	1	ITEM_EU_TSWORD_15_B_RARE	1	ITEM_EU_TSWORD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80378	ITEM_EU_AXE_15_A_RARE_CHAOS	15? ???? (??)	xxx	SN_ITEM_EU_AXE_15_A_RARE_CHAOS	SN_ITEM_EU_AXE_15_A_RARE_TT_DESC	0	0	3	1	6	9	180000	1	2	0	0	0	0	0	0	0	0	0	0	19748000	14667	22000	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\axe_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\axe_15.ddj	xxx	xxx	1	2	0	0	43	0	157	236	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	6	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	2	15	1	ITEM_EU_AXE_15_A_RARE_CHAOS	1	ITEM_EU_AXE_15_B_RARE	1	ITEM_EU_AXE_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80399	ITEM_EU_CROSSBOW_15_A_RARE_CHAOS	15? ????? (??)	xxx	SN_ITEM_EU_CROSSBOW_15_A_RARE_CHAOS	SN_ITEM_EU_CROSSBOW_15_A_RARE_TT_DESC	0	0	3	1	6	12	180000	1	2	0	0	0	0	0	0	0	0	0	0	19748000	10353	15530	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\crossbow_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\crossbow_15.ddj	xxx	xxx	1	2	0	0	43	0	111	167	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	180	5836	6154	7132	7521	179.1	0	0	0	0	0	6487	7162	7928	8753	0	0	0	0	142	303	0	4	20	1	ITEM_EU_CROSSBOW_15_A_RARE_CHAOS	1	ITEM_EU_CROSSBOW_15_B_RARE 	1	ITEM_EU_CROSSBOW_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80420	ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS	15? ???? (??)	xxx	SN_ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS	SN_ITEM_EU_DARKSTAFF_15_A_RARE_TT_DESC	0	0	3	1	6	10	180000	1	2	0	0	0	0	0	0	0	0	0	0	17773000	8628	12941	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\darkstaff_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\darkstaff_15.ddj	xxx	xxx	1	2	0	0	43	0	185	278	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS	1	ITEM_EU_DARKSTAFF_15_B_RARE	1	ITEM_EU_DARKSTAFF_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80441	ITEM_EU_TSTAFF_15_A_RARE_CHAOS	15? ??? (??)	xxx	SN_ITEM_EU_TSTAFF_15_A_RARE_CHAOS	SN_ITEM_EU_TSTAFF_15_A_RARE_TT_DESC	0	0	3	1	6	11	180000	1	2	0	0	0	0	0	0	0	0	0	0	19748000	8628	12941	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\tstaff_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\tstaff_15.ddj	xxx	xxx	1	2	0	0	43	0	93	139	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_TSTAFF_15_A_RARE_CHAOS	1	ITEM_EU_TSTAFF_15_B_RARE	1	ITEM_EU_TSTAFF_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80462	ITEM_EU_HARP_15_A_RARE_CHAOS	15? ?? (??)	xxx	SN_ITEM_EU_HARP_15_A_RARE_CHAOS	SN_ITEM_EU_HARP_15_A_RARE_TT_DESC	0	0	3	1	6	14	180000	1	2	0	0	0	0	0	0	0	0	0	0	19748000	7765	11647	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\harp_12.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\harp_15.ddj	xxx	xxx	1	2	0	0	43	0	83	125	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_HARP_15_A_RARE_CHAOS	1	ITEM_EU_HARP_15_B_RARE	1	ITEM_EU_HARP_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80483	ITEM_EU_STAFF_15_A_RARE_CHAOS	15? ??? ?? (??)	xxx	SN_ITEM_EU_STAFF_15_A_RARE_CHAOS	SN_ITEM_EU_STAFF_15_A_RARE_TT_DESC	0	0	3	1	6	15	180000	1	2	0	0	0	0	0	0	0	0	0	0	19748000	8628	12941	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\weapon\staff_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\weapon\staff_15.ddj	xxx	xxx	1	2	0	0	43	0	93	139	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	0	0	0	0	0	9337	9846	11412	12034	286.5	0	0	0	0	10378	11459	12685	14005	142	303	0	2	2	1	ITEM_EU_STAFF_15_A_RARE_CHAOS	1	ITEM_EU_STAFF_15_B_RARE 	1	ITEM_EU_STAFF_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80504	ITEM_EU_SHIELD_15_A_RARE_CHAOS	15? ?? ?? (??)	xxx	SN_ITEM_EU_SHIELD_15_A_RARE_CHAOS	SN_ITEM_EU_SHIELD_15_A_RARE_TT_DESC	0	0	3	1	4	2	180000	1	2	0	0	0	0	0	0	0	0	0	0	9874000	9059	13588	0	9000	3455900	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\europe\shield\shield_20.bsr	item\etc\drop_eu_equip_rare.bsr	item\europe\shield\shield_15.ddj	xxx	xxx	1	2	0	0	43	0	97	146	648.4	683.8	17.9	0	0	0	0	0	0	14	23	1037.4	1094	28.6	0	0	0	721	796	1153	1273	0	0	0	0	0	0	2	0	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	ITEM_EU_SHIELD_15_A_RARE_CHAOS	1	ITEM_EU_SHIELD_15_B_RARE	1	ITEM_EU_SHIELD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S	-1	xxx	-1	xxx	-1	xxx	-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	?? ??? ?? ?? ?	9	0

1	80370	ITEM_CH_SWORD_15_A_RARE_CHAOS	15? ? (??)	xxx	SN_ITEM_CH_SWORD_15_A_RARE_CHAOS	SN_ITEM_CH_SWORD_15_A_RARE_TT_DESC	0	0	3	1	6	2	180000	0	2	0	0	0	0	0	0	0	0	0	0	17773000	12294	18441	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\sword_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\sword_15.ddj	xxx	xxx	1	2	0	0	43	0	148	181	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	4349	4586	4902	5169	127.7	7400	7804	8507	8971	219.6	4930	5130	5558	5782	8390	8729	9645	10035	142	303	0	4	16	1	ITEM_CH_SWORD_15_A_RARE_CHAOS	1	ITEM_CH_SWORD_15_B_RARE 	1	ITEM_CH_SWORD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80391	ITEM_CH_BLADE_15_A_RARE_CHAOS	15? ? (??)	xxx	SN_ITEM_CH_BLADE_15_A_RARE_CHAOS	SN_ITEM_CH_BLADE_15_A_RARE_TT_DESC	0	0	3	1	6	3	180000	0	2	0	0	0	0	0	0	0	0	0	0	17773000	13588	20382	0	9000	6220550	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\blade_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\blade_15.ddj	xxx	xxx	1	2	0	0	43	0	164	200	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	6	4625	4878	5317	5607	137.3	6958	7337	7843	8271	204.4	5244	5456	6028	6272	7889	8207	8892	9251	142	303	0	3	15	1	ITEM_CH_BLADE_15_A_RARE_CHAOS	1	ITEM_CH_BLADE_15_B_RARE 	1	ITEM_CH_BLADE_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80412	ITEM_CH_SPEAR_15_A_RARE_CHAOS	15? ? (??)	xxx	SN_ITEM_CH_SPEAR_15_A_RARE_CHAOS	SN_ITEM_CH_SPEAR_15_A_RARE_TT_DESC	0	0	3	1	6	4	180000	0	2	0	0	0	0	0	0	0	0	0	0	19748000	8196	12294	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\spear_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\spear_15.ddj	xxx	xxx	1	2	0	0	43	0	99	121	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	18	4539	4786	5403	5698	137.3	7781	8205	9510	10029	238.8	5146	5354	6126	6374	8822	9178	10782	11218	142	303	0	5	17	1	ITEM_CH_SPEAR_15_A_RARE_CHAOS	1	ITEM_CH_SPEAR_15_B_RARE 	1	ITEM_CH_SPEAR_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80433	ITEM_CH_TBLADE_15_A_RARE_CHAOS	15? ?? (??)	xxx	SN_ITEM_CH_TBLADE_15_A_RARE_CHAOS	SN_ITEM_CH_TBLADE_15_A_RARE_TT_DESC	0	0	3	1	6	5	180000	0	2	0	0	0	0	0	0	0	0	0	0	19748000	9059	13588	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\tblade_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\tblade_15.ddj	xxx	xxx	1	2	0	0	43	0	109	134	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	2	1	18	4863	5128	5944	6268	149.2	7262	7658	8645	9117	219.6	5514	5736	6739	7011	8234	8566	9802	10198	142	303	0	4	16	1	ITEM_CH_TBLADE_15_A_RARE_CHAOS	1	ITEM_CH_TBLADE_15_B_RARE	1	ITEM_CH_TBLADE_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80454	ITEM_CH_BOW_15_A_RARE_CHAOS	15? ? (??)	xxx	SN_ITEM_CH_BOW_15_A_RARE_CHAOS	SN_ITEM_CH_BOW_15_A_RARE_TT_DESC	0	0	3	1	6	6	180000	0	2	0	0	0	0	0	0	0	0	0	0	19748000	9318	13977	0	9000	6911800	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\weapon\bow_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\weapon\bow_15.ddj	xxx	xxx	1	2	0	0	43	0	112	137	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	0	0	0	0	2	1	180	4399	4639	5391	5686	135.2	7039	7423	8626	9097	216.3	4988	5189	6113	6360	7981	8303	9780	10175	142	303	0	4	14	1	ITEM_CH_BOW_15_A_RARE_CHAOS	1	ITEM_CH_BOW_15_B_RARE	1	ITEM_CH_BOW_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	3	?? ??? ?? ?? ?	9	0
1	80475	ITEM_CH_SHIELD_15_A_RARE_CHAOS	15? ?? (??)	xxx	SN_ITEM_CH_SHIELD_15_A_RARE_CHAOS	SN_ITEM_CH_SHIELD_15_A_RARE_TT_DESC	0	0	3	1	4	1	180000	0	2	0	0	0	0	0	0	0	0	0	0	9874000	9059	13588	0	9000	3455900	1	101	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	item\china\shield\shield_20.bsr	item\etc\drop_ch_equip_rare.bsr	item\china\shield\shield_15.ddj	xxx	xxx	1	2	0	0	43	0	109	134	648.4	683.8	17.9	0	0	0	0	0	0	14	23	1037.4	1094	28.6	0	0	0	735	765	1235	1285	0	0	0	0	0	0	2	0	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	ITEM_CH_SHIELD_15_A_RARE_CHAOS	1	ITEM_CH_SHIELD_15_B_RARE	1	ITEM_CH_SHIELD_15_C_RARE	1	ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S	-1	xxx	-1	xxx	-1	xxx	-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	?? ??? ?? ?? ?	9	0
AddLogItem'e ekleyin
Kod:
-- Lock
    IF (@operation = 41 and @ItemRefID = '81023')
       Begin
         Declare @ID64 Int , @RefItemID Int , @NewRefID Int
          Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID  From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join  [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64  Where  Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
         Select Top 1 @NewRefID = LockItemID From [dbo].[LockItemsID] Where ReqItemID = @RefItemID
         IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
         Begin
          Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
         End
       End

    -- Unlock
    IF (@operation = 41 and @ItemRefID = '81024')
       Begin
          Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID  From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join  [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64  Where  Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
         Select Top 1 @NewRefID = ReqItemID From [dbo].[LockItemsID] Where LockItemID = @RefItemID
         IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
         Begin
          Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
         End
       End
sonra da bunu oluşturun
Kod:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_HamzaLockSystemD15]    Script Date: 11/1/2015 10:25:15 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_HamzaLockSystemD15]
 @CharID   Int
  As

 -- Declare expression.
   Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
   @Slot Int = '13' ,  -- char inventory slot 1.
   @ReqOptLevel Int = '0' ,  -- Requiared Opt Level to upgrade
   @OptDifference Int = '2' ,  -- Set the difference optlevel between old plus and new plus.
   @OldOptLevel Int ,
   @NewOptLevel Int ,
   @AdvValue Int ,
   @ID64 Int ,
-------------------------

   -- Set Old and New Item RefObjCommon ID below
   -- Use This Query to get each item ID by Codename128
   -- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

   ---> Old weapon ID's				  ---> New weapons ID's
     @Old_CH_SWORD_ID Int  = 39368    , @New_CH_SWORD_ID Int  = 80370  ,    --@New Chinese Sword
   @Old_CH_BLADE_ID Int  = 39391    , @New_CH_BLADE_ID Int  = 80391  ,    --@Chinese Blade
   @Old_CH_SPEAR_ID Int  = 39412    , @New_CH_SPEAR_ID Int  = 80412  ,    --@Chinese Spear
   @Old_CH_TBLADE_ID Int = 39433    , @New_CH_TBLADE_ID Int = 80433  ,    --@Chinese Glaive
   @Old_CH_BOW_ID Int    = 39454    , @New_CH_BOW_ID Int    = 80454  ,    --@Chinese Bow
   @Old_CH_SHIELD_ID Int = 39475    , @New_CH_SHIELD_ID Int = 80475  ,    --@Chinese Shield
   @Old_EU_DAGGER_ID Int = 40315    , @New_EU_DAGGER_ID Int = 80315  ,    --@European Dagger
   @Old_EU_XBOW_ID Int   = 40399    , @New_EU_XBOW_ID Int   = 80399  ,    --@European CrossBow
   @Old_EU_AXE_ID Int    = 40378    , @New_EU_AXE_ID Int    = 80378  ,    --@European Axe
   @Old_EU_SWORD_ID Int  = 40336    , @New_EU_SWORD_ID Int  = 80336  ,    --@European One Hand Sword
   @Old_EU_TSWORD_ID Int = 40357    , @New_EU_TSWORD_ID Int = 80357  ,    --@European Two Hand Sword
   @Old_EU_TSTAFF_ID Int = 40441    , @New_EU_TSTAFF_ID Int = 80441  ,    --@European Two Hand Staff
   @Old_EU_STAFF_ID Int  = 40483    , @New_EU_STAFF_ID Int  = 80483  ,    --@European Claric Rod
   @Old_EU_DSTAFF_ID Int = 40420    , @New_EU_DSTAFF_ID Int = 80420  ,    --@European Warlock Rod
   @Old_EU_HARP_ID Int   = 40462    , @New_EU_HARP_ID Int   = 80462  ,    --@European Harp
   @Old_EU_SHIELD_ID Int = 40504    , @New_EU_SHIELD_ID Int = 80504  --@European Shield
  --------------------------------------------------------------------------------------------
   Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
   Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)
   
 -- Start Lock system :

	-- First Case : 
	-- IF Item has not advanced elixir :
	
  IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
   Begin
	IF @OldOptLevel >= @ReqOptLevel
	Begin
	Set @NewOptLevel = @OldOptLevel - @OptDifference
	-- CH Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID  and (OptLevel = @OldOptLevel)	--@Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID  and (OptLevel = @OldOptLevel)	--@Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID  and (OptLevel = @OldOptLevel)	--@Spear
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel)	--@T-Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID    and (OptLevel = @OldOptLevel)	--@Bow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	-- EU Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel)	--@Dagger
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID   and (OptLevel = @OldOptLevel)	--@Crossbow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID    and (OptLevel = @OldOptLevel)	--@Axe
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID  and (OptLevel = @OldOptLevel)	--@OneHand Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel)	--@T-Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel)	--@T-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID  and (OptLevel = @OldOptLevel)	--@Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel)	--@Dark-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID   and (OptLevel = @OldOptLevel)	--@Harp
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	End
   End

	-- Second Case : 
	-- IF Item has advanced elixir :

  ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
   Begin
	Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
	IF @OldOptLevel >= @ReqOptLevel
	Begin
	Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
	-- CH Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID  and (OptLevel = @OldOptLevel)	--@Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID  and (OptLevel = @OldOptLevel)	--@Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID  and (OptLevel = @OldOptLevel)	--@Spear
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel)	--@T-Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID    and (OptLevel = @OldOptLevel)	--@Bow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	-- EU Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel)	--@Dagger
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID   and (OptLevel = @OldOptLevel)	--@Crossbow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID    and (OptLevel = @OldOptLevel)	--@Axe
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID  and (OptLevel = @OldOptLevel)	--@OneHand Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel)	--@T-Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel)	--@T-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID  and (OptLevel = @OldOptLevel)	--@Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel)	--@Dark-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID   and (OptLevel = @OldOptLevel)	--@Harp
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	End
   End
Kod:
USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_HamzaLockSystemD15Unlock]    Script Date: 11/2/2015 5:46:40 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_HamzaLockSystemD15Unlock]
 @CharID   Int
  As

 -- Declare expression.
   Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
   @Slot Int = '13' ,  -- char inventory slot 1.
   @ReqOptLevel Int = '0' ,  -- Requiared Opt Level to upgrade
   @OptDifference Int = '2' ,  -- Set the difference optlevel between old plus and new plus.
   @OldOptLevel Int ,
   @NewOptLevel Int ,
   @AdvValue Int ,
   @ID64 Int ,
-------------------------

   -- Set Old and New Item RefObjCommon ID below
   -- Use This Query to get each item ID by Codename128
   -- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

   ---> Old weapon ID's				  ---> New weapons ID's
     @Old_CH_SWORD_ID Int  = 80370    , @New_CH_SWORD_ID Int  = 39370  ,    --@New Chinese Sword
   @Old_CH_BLADE_ID Int  = 80391    , @New_CH_BLADE_ID Int  = 39391  ,    --@Chinese Blade
   @Old_CH_SPEAR_ID Int  = 80412    , @New_CH_SPEAR_ID Int  = 39412  ,    --@Chinese Spear
   @Old_CH_TBLADE_ID Int = 80433    , @New_CH_TBLADE_ID Int = 39433  ,    --@Chinese Glaive
   @Old_CH_BOW_ID Int    = 80454    , @New_CH_BOW_ID Int    = 39454  ,    --@Chinese Bow
   @Old_CH_SHIELD_ID Int = 80475    , @New_CH_SHIELD_ID Int = 39475  ,    --@Chinese Shield
   @Old_EU_DAGGER_ID Int = 80315    , @New_EU_DAGGER_ID Int = 40315  ,    --@European Dagger
   @Old_EU_XBOW_ID Int   = 80399    , @New_EU_XBOW_ID Int   = 40399  ,    --@European CrossBow
   @Old_EU_AXE_ID Int    = 80378    , @New_EU_AXE_ID Int    = 40378  ,    --@European Axe
   @Old_EU_SWORD_ID Int  = 80336    , @New_EU_SWORD_ID Int  = 40336  ,    --@European One Hand Sword
   @Old_EU_TSWORD_ID Int = 80357    , @New_EU_TSWORD_ID Int = 40357  ,    --@European Two Hand Sword
   @Old_EU_TSTAFF_ID Int = 80441    , @New_EU_TSTAFF_ID Int = 40441  ,    --@European Two Hand Staff
   @Old_EU_STAFF_ID Int  = 80483    , @New_EU_STAFF_ID Int  = 40483  ,    --@European Claric Rod
   @Old_EU_DSTAFF_ID Int = 80420    , @New_EU_DSTAFF_ID Int = 40420  ,    --@European Warlock Rod
   @Old_EU_HARP_ID Int   = 80462    , @New_EU_HARP_ID Int   = 40462  ,    --@European Harp
   @Old_EU_SHIELD_ID Int = 80504    , @New_EU_SHIELD_ID Int = 40504  --@European Shield
  --------------------------------------------------------------------------------------------
   Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
   Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)
   
 -- Start Lock system :

	-- First Case : 
	-- IF Item has not advanced elixir :
	
  IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
   Begin
	IF @OldOptLevel >= @ReqOptLevel
	Begin
	Set @NewOptLevel = @OldOptLevel - @OptDifference
	-- CH Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID  and (OptLevel = @OldOptLevel)	--@Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID  and (OptLevel = @OldOptLevel)	--@Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID  and (OptLevel = @OldOptLevel)	--@Spear
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel)	--@T-Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID    and (OptLevel = @OldOptLevel)	--@Bow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	-- EU Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel)	--@Dagger
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID   and (OptLevel = @OldOptLevel)	--@Crossbow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID    and (OptLevel = @OldOptLevel)	--@Axe
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID  and (OptLevel = @OldOptLevel)	--@OneHand Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel)	--@T-Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel)	--@T-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID  and (OptLevel = @OldOptLevel)	--@Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel)	--@Dark-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID   and (OptLevel = @OldOptLevel)	--@Harp
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	End
   End

	-- Second Case : 
	-- IF Item has advanced elixir :

  ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
   Begin
	Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
	IF @OldOptLevel >= @ReqOptLevel
	Begin
	Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
	-- CH Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID  and (OptLevel = @OldOptLevel)	--@Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID  and (OptLevel = @OldOptLevel)	--@Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID  and (OptLevel = @OldOptLevel)	--@Spear
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel)	--@T-Blade
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID    and (OptLevel = @OldOptLevel)	--@Bow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	-- EU Weapons Upgrade.
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel)	--@Dagger
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID   and (OptLevel = @OldOptLevel)	--@Crossbow
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID    , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID    and (OptLevel = @OldOptLevel)	--@Axe
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID  and (OptLevel = @OldOptLevel)	--@OneHand Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel)	--@T-Sword
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel)	--@T-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID  , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID  and (OptLevel = @OldOptLevel)	--@Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel)	--@Dark-Staff
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID   , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID   and (OptLevel = @OldOptLevel)	--@Harp
	Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel  Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel)	--@Shield
	End
   End
 

Nyrox

Üye
Katılım
18 Ağu 2015
Mesajlar
255
Puanları
18
Yaş
25
Konum
İSTANBUL
Cvp: vSro İtem Kilitleme Sistemi

En iyisi txt şeklinde paylaşmak böyle göz yoruyor.Teşekkürler paylaşım için.
 

Musa KURTGÖZ

ViP Üye
Katılım
23 Tem 2015
Mesajlar
1,698
Puanları
38
Yaş
21
Konum
K.MARAŞ
Cvp: vSro İtem Kilitleme Sistemi

flash3606' Alıntı:
göz yorması birşey degilde bu şekil satırlarda kaymalar oluyor.böyle oluncada hata!!
kod tagında hata olduğu için böyle paylaşmıştım. satırlarda kayma olmaz hocam konuyuda düzenledim.
 

vSionic

Üye
Katılım
17 Ocak 2016
Mesajlar
62
Puanları
6
Yaş
26
Konum
İZMİR
Cvp: vSro İtem Kilitleme Sistemi

Usta; anladığım kadarıyla, bu bildiğimiz model switcher mantığıyla çalışıyor gibi ama bu sefer item görünümü değişik silah yerine cantrade,candrop kapalı silah ile değiştiriyoruz. Ama  paylaştıgın prosedurlerde ve tablolarda fazlalık var sanki? yada ben yanlış anladım.
 
Üst