Lock / Unlock Scroll

Hamza FiGo · 11/02/2015, 16:45

Lock / Unlock Scroll

Hello everyone, many ppl asked me about this system. So her it is. I hope it us useful for who still don't have my LOG [ yet ]

1- Create this table:

Code:

Use [SRO_VT_SHARDLOG]
Create Table [dbo].[LockItemsID]
([LockItemID] [Int] NOT NULL PRIMARY KEY ,
[ReqItemID] [Int] NOT NULL)

2- Make a new lines from the weapon u want to lock/unlock them.

Copy the lines and change the name

Important:

You must update Can traded Can Drop Can Borrow = 0 in the new lines

Example:

** The original 15D weapon:

Code:

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

** The locked 15D weapons:

Code:

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

I think u got the idea. Add this at LOG db at AddLogItem

Code:

-- 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

Then create this :

Code:

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

Code:

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

Nothing special now ~_^

Regards

ownkhan · 11/02/2015, 16:57

hamza this system only ur items can not be 'untraded'

hossamxt · 11/02/2015, 17:07

Great move Hamza <3

Hamza FiGo · 11/02/2015, 17:28

Quote:

Originally Posted by ownkhan

hamza this system only ur items can not be 'untraded'

I said (example). And this system simply like the upgrade scroll. Upgrade the normal weapon to the locked weapon. And the unlocked weapon to the normal weapon

Locked means ( no trade - no sell - no drop - no stall - no storage.. nothing ^^ ). To avoid hacking. If some one hack an acc, he just can + it. And i'm trying on a new system to avoid +ing on the locked items.

Quote:

Originally Posted by hossamxt

Great move Hamza <3

Released cus u need it hossam

~~Zargrin~~ · 11/02/2015, 17:44

Good job

Dracula Untold · 11/02/2015, 18:05

COPY / PASTE hahah i think u will release that SHARD complet

AceSpace · 11/02/2015, 18:07

This was used in Elamidas with the name 'Bound' and it's basically a model switcher while the switched item has CanTrade = 0, CanBorrow = 0, CanDrop = 0.

Hamza FiGo · 11/02/2015, 18:19

Quote:

Originally Posted by SensationSro

COPY / PASTE hahah i think u will release that SHARD complet

COPY / PASTE !! huh copy paste from my DB!

nothin to say

Quote:

Originally Posted by Skipper*

This was used in Elamidas with the name 'Bound' and it's basically a model switcher while the switched item has CanTrade = 0, CanBorrow = 0, CanDrop = 0.

ya this is a simple system and useful for me. The only thing left is how i can make it can not be +ed. Working on it.

hossamxt · 11/02/2015, 19:37

Quote:

Originally Posted by SensationSro

COPY / PASTE hahah i think u will release that SHARD complet

Bla Bla Bla

Quote:

Originally Posted by hamzafigo

I said (example). And this system simply like the upgrade scroll. Upgrade the normal weapon to the locked weapon. And the unlocked weapon to the normal weapon

Locked means ( no trade - no sell - no drop - no stall - no storage.. nothing ^^ ). To avoid hacking. If some one hack an acc, he just can + it. And i'm trying on a new system to avoid +ing on the locked items.

Released cus u need it hossam

Thank You

matrixasd2 · 11/03/2015, 04:26

Good job

Bocc1337 · 11/03/2015, 05:06

You should add a pass word system to the locking scroll. Anyone can still hack the items by simply getting a unlock scroll..Just a thought

xaladim · 11/03/2015, 06:09

Good job

Hamza FiGo · 11/03/2015, 06:48

Quote:

Originally Posted by sonsof2004

You should add a pass word system to the locking scroll. Anyone can still hack the items by simply getting a unlock scroll..Just a thought

i just add the lock scroll to the NPC. Unlock with the GM only. If someone want to unlock, so the owner of the acc must contact with me.

~~Anonymous-6723~~ · 11/03/2015, 18:36

Contacting you makes things quite impossible at some point

(Except your bed, kitchen, life is in front of the PC

)

Just a thought if you are using a filter + HWID limit, (Don't know if possible btw..).. Let's say that someone creates an account "test", then there are (on some websites..) possibilities to choose a different ingame password right? Same way you could make them to choose (after first login) if they want to do alchemy only from that HWID ( or you could just say Computer for the mass ).. You will need a custom filter or pay someone like SUPERMAN/Torque boys to make a function where it check if that option is choosen and once alchemy is started to check that.

Spoiler

ON: Ohhh, forgot to mention, good release!

Exo · 11/03/2015, 19:27

This is really bad if you ask me! There're a lot of possibilities in which you didn't handle. Code is bad/unorganized/not optimized. And again 'not recommended'.

*my own useless opinion on which you don't have to agree and yes you shouldn't care*