[VSRO188] Reworked Auto-Equipment [QUERIES]

[brklol]

First of all, credits go to DePiedra for creating this. Although I found many, many bugs within his queries and decided to rework it and actually make it work.

This system adds NORMAL +4 gears to chars with added Str/int blues. These can be changed in the procedure & trigger.

Let's go

### Table ###

Create this table which contains the gear which will be given to the chars on level up:

 Spoiler

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_ItemPoolAutoEquipment]    Script Date: 03/26/2017 00:27:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_ItemPoolAutoEquipment](
	[Service] [int] NOT NULL,
	[ID] [int] NOT NULL,
	[CodeName128] [varchar](129) NOT NULL,
	[TypeID1] [tinyint] NOT NULL,
	[TypeID2] [tinyint] NOT NULL,
	[TypeID3] [tinyint] NOT NULL,
	[TypeID4] [tinyint] NOT NULL,
	[Country] [tinyint] NOT NULL,
	[Rarity] [tinyint] NOT NULL,
	[ReqLevelType1] [int] NOT NULL,
	[ReqLevel1] [tinyint] NOT NULL,
	[ReqLevelType2] [int] NOT NULL,
	[ReqLevel2] [tinyint] NOT NULL,
	[ReqLevelType3] [int] NOT NULL,
	[ReqLevel3] [tinyint] NOT NULL,
	[ReqLevelType4] [int] NOT NULL,
	[ReqLevel4] [tinyint] NOT NULL,
 CONSTRAINT [PK__ItemPoolAutoEquipment] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

### Table contents ###

The table contains 2D-9D normal gears. You can always add new gears to the table if you wish to reward players with different gears (sox for instance).

 Spoiler

1	74	ITEM_CH_SWORD_02_A	3	1	6	2	0	2	1	8	-1	0	-1	0	-1	0
1	75	ITEM_CH_SWORD_02_B	3	1	6	2	0	0	1	10	-1	0	-1	0	-1	0
1	76	ITEM_CH_SWORD_02_C	3	1	6	2	0	0	1	13	-1	0	-1	0	-1	0
1	77	ITEM_CH_SWORD_03_A	3	1	6	2	0	2	1	16	-1	0	-1	0	-1	0
1	78	ITEM_CH_SWORD_03_B	3	1	6	2	0	0	1	18	-1	0	-1	0	-1	0
1	79	ITEM_CH_SWORD_03_C	3	1	6	2	0	0	1	21	-1	0	-1	0	-1	0
1	80	ITEM_CH_SWORD_04_A	3	1	6	2	0	2	1	24	-1	0	-1	0	-1	0
1	81	ITEM_CH_SWORD_04_B	3	1	6	2	0	0	1	26	-1	0	-1	0	-1	0
1	82	ITEM_CH_SWORD_04_C	3	1	6	2	0	0	1	29	-1	0	-1	0	-1	0
1	83	ITEM_CH_SWORD_05_A	3	1	6	2	0	2	1	32	-1	0	-1	0	-1	0
1	84	ITEM_CH_SWORD_05_B	3	1	6	2	0	0	1	35	-1	0	-1	0	-1	0
1	85	ITEM_CH_SWORD_05_C	3	1	6	2	0	0	1	38	-1	0	-1	0	-1	0
1	86	ITEM_CH_SWORD_06_A	3	1	6	2	0	2	1	42	-1	0	-1	0	-1	0
1	87	ITEM_CH_SWORD_06_B	3	1	6	2	0	0	1	45	-1	0	-1	0	-1	0
1	88	ITEM_CH_SWORD_06_C	3	1	6	2	0	0	1	48	-1	0	-1	0	-1	0
1	89	ITEM_CH_SWORD_07_A	3	1	6	2	0	2	1	52	-1	0	-1	0	-1	0
1	90	ITEM_CH_SWORD_07_B	3	1	6	2	0	0	1	56	-1	0	-1	0	-1	0
1	91	ITEM_CH_SWORD_07_C	3	1	6	2	0	0	1	60	-1	0	-1	0	-1	0
1	92	ITEM_CH_SWORD_08_A	3	1	6	2	0	2	1	64	-1	0	-1	0	-1	0
1	93	ITEM_CH_SWORD_08_B	3	1	6	2	0	0	1	68	-1	0	-1	0	-1	0
1	94	ITEM_CH_SWORD_08_C	3	1	6	2	0	0	1	72	-1	0	-1	0	-1	0
1	95	ITEM_CH_SWORD_09_A	3	1	6	2	0	2	1	64	-1	0	-1	0	-1	0
1	96	ITEM_CH_SWORD_09_B	3	1	6	2	0	0	1	80	-1	0	-1	0	-1	0
1	97	ITEM_CH_SWORD_09_C	3	1	6	2	0	0	1	85	-1	0	-1	0	-1	0
1	110	ITEM_CH_BLADE_02_A	3	1	6	3	0	2	1	8	-1	0	-1	0	-1	0
1	111	ITEM_CH_BLADE_02_B	3	1	6	3	0	0	1	10	-1	0	-1	0	-1	0
1	112	ITEM_CH_BLADE_02_C	3	1	6	3	0	0	1	13	-1	0	-1	0	-1	0
1	113	ITEM_CH_BLADE_03_A	3	1	6	3	0	2	1	16	-1	0	-1	0	-1	0
1	114	ITEM_CH_BLADE_03_B	3	1	6	3	0	0	1	18	-1	0	-1	0	-1	0
1	115	ITEM_CH_BLADE_03_C	3	1	6	3	0	0	1	21	-1	0	-1	0	-1	0
1	116	ITEM_CH_BLADE_04_A	3	1	6	3	0	2	1	24	-1	0	-1	0	-1	0
1	117	ITEM_CH_BLADE_04_B	3	1	6	3	0	0	1	26	-1	0	-1	0	-1	0
1	118	ITEM_CH_BLADE_04_C	3	1	6	3	0	0	1	29	-1	0	-1	0	-1	0
1	119	ITEM_CH_BLADE_05_A	3	1	6	3	0	2	1	32	-1	0	-1	0	-1	0
1	120	ITEM_CH_BLADE_05_B	3	1	6	3	0	0	1	35	-1	0	-1	0	-1	0
1	121	ITEM_CH_BLADE_05_C	3	1	6	3	0	0	1	38	-1	0	-1	0	-1	0
1	122	ITEM_CH_BLADE_06_A	3	1	6	3	0	2	1	42	-1	0	-1	0	-1	0
1	123	ITEM_CH_BLADE_06_B	3	1	6	3	0	0	1	45	-1	0	-1	0	-1	0
1	124	ITEM_CH_BLADE_06_C	3	1	6	3	0	0	1	48	-1	0	-1	0	-1	0
1	125	ITEM_CH_BLADE_07_A	3	1	6	3	0	2	1	52	-1	0	-1	0	-1	0
1	126	ITEM_CH_BLADE_07_B	3	1	6	3	0	0	1	56	-1	0	-1	0	-1	0
1	127	ITEM_CH_BLADE_07_C	3	1	6	3	0	0	1	60	-1	0	-1	0	-1	0
1	128	ITEM_CH_BLADE_08_A	3	1	6	3	0	2	1	64	-1	0	-1	0	-1	0
1	129	ITEM_CH_BLADE_08_B	3	1	6	3	0	0	1	68	-1	0	-1	0	-1	0
1	130	ITEM_CH_BLADE_08_C	3	1	6	3	0	0	1	72	-1	0	-1	0	-1	0
1	131	ITEM_CH_BLADE_09_A	3	1	6	3	0	2	1	64	-1	0	-1	0	-1	0
1	132	ITEM_CH_BLADE_09_B	3	1	6	3	0	0	1	80	-1	0	-1	0	-1	0
1	133	ITEM_CH_BLADE_09_C	3	1	6	3	0	0	1	85	-1	0	-1	0	-1	0
1	146	ITEM_CH_SPEAR_02_A	3	1	6	4	0	2	1	8	-1	0	-1	0	-1	0
1	147	ITEM_CH_SPEAR_02_B	3	1	6	4	0	0	1	10	-1	0	-1	0	-1	0
1	148	ITEM_CH_SPEAR_02_C	3	1	6	4	0	0	1	13	-1	0	-1	0	-1	0
1	149	ITEM_CH_SPEAR_03_A	3	1	6	4	0	2	1	16	-1	0	-1	0	-1	0
1	150	ITEM_CH_SPEAR_03_B	3	1	6	4	0	0	1	18	-1	0	-1	0	-1	0
1	151	ITEM_CH_SPEAR_03_C	3	1	6	4	0	0	1	21	-1	0	-1	0	-1	0
1	152	ITEM_CH_SPEAR_04_A	3	1	6	4	0	2	1	24	-1	0	-1	0	-1	0
1	153	ITEM_CH_SPEAR_04_B	3	1	6	4	0	0	1	26	-1	0	-1	0	-1	0
1	154	ITEM_CH_SPEAR_04_C	3	1	6	4	0	0	1	29	-1	0	-1	0	-1	0
1	155	ITEM_CH_SPEAR_05_A	3	1	6	4	0	2	1	32	-1	0	-1	0	-1	0
1	156	ITEM_CH_SPEAR_05_B	3	1	6	4	0	0	1	35	-1	0	-1	0	-1	0
1	157	ITEM_CH_SPEAR_05_C	3	1	6	4	0	0	1	38	-1	0	-1	0	-1	0
1	158	ITEM_CH_SPEAR_06_A	3	1	6	4	0	2	1	42	-1	0	-1	0	-1	0
1	159	ITEM_CH_SPEAR_06_B	3	1	6	4	0	0	1	45	-1	0	-1	0	-1	0
1	160	ITEM_CH_SPEAR_06_C	3	1	6	4	0	0	1	48	-1	0	-1	0	-1	0
1	161	ITEM_CH_SPEAR_07_A	3	1	6	4	0	2	1	52	-1	0	-1	0	-1	0
1	162	ITEM_CH_SPEAR_07_B	3	1	6	4	0	0	1	56	-1	0	-1	0	-1	0
1	163	ITEM_CH_SPEAR_07_C	3	1	6	4	0	0	1	60	-1	0	-1	0	-1	0
1	164	ITEM_CH_SPEAR_08_A	3	1	6	4	0	2	1	64	-1	0	-1	0	-1	0
1	165	ITEM_CH_SPEAR_08_B	3	1	6	4	0	0	1	68	-1	0	-1	0	-1	0
1	166	ITEM_CH_SPEAR_08_C	3	1	6	4	0	0	1	72	-1	0	-1	0	-1	0
1	167	ITEM_CH_SPEAR_09_A	3	1	6	4	0	2	1	64	-1	0	-1	0	-1	0
1	168	ITEM_CH_SPEAR_09_B	3	1	6	4	0	0	1	80	-1	0	-1	0	-1	0
1	169	ITEM_CH_SPEAR_09_C	3	1	6	4	0	0	1	85	-1	0	-1	0	-1	0
1	182	ITEM_CH_TBLADE_02_A	3	1	6	5	0	2	1	8	-1	0	-1	0	-1	0
1	183	ITEM_CH_TBLADE_02_B	3	1	6	5	0	0	1	10	-1	0	-1	0	-1	0
1	184	ITEM_CH_TBLADE_02_C	3	1	6	5	0	0	1	13	-1	0	-1	0	-1	0
1	185	ITEM_CH_TBLADE_03_A	3	1	6	5	0	2	1	16	-1	0	-1	0	-1	0
1	186	ITEM_CH_TBLADE_03_B	3	1	6	5	0	0	1	18	-1	0	-1	0	-1	0
1	187	ITEM_CH_TBLADE_03_C	3	1	6	5	0	0	1	21	-1	0	-1	0	-1	0
1	188	ITEM_CH_TBLADE_04_A	3	1	6	5	0	2	1	24	-1	0	-1	0	-1	0
1	189	ITEM_CH_TBLADE_04_B	3	1	6	5	0	0	1	26	-1	0	-1	0	-1	0
1	190	ITEM_CH_TBLADE_04_C	3	1	6	5	0	0	1	29	-1	0	-1	0	-1	0
1	191	ITEM_CH_TBLADE_05_A	3	1	6	5	0	2	1	32	-1	0	-1	0	-1	0
1	192	ITEM_CH_TBLADE_05_B	3	1	6	5	0	0	1	35	-1	0	-1	0	-1	0
1	193	ITEM_CH_TBLADE_05_C	3	1	6	5	0	0	1	38	-1	0	-1	0	-1	0
1	194	ITEM_CH_TBLADE_06_A	3	1	6	5	0	2	1	42	-1	0	-1	0	-1	0
1	195	ITEM_CH_TBLADE_06_B	3	1	6	5	0	0	1	45	-1	0	-1	0	-1	0
1	196	ITEM_CH_TBLADE_06_C	3	1	6	5	0	0	1	48	-1	0	-1	0	-1	0
1	197	ITEM_CH_TBLADE_07_A	3	1	6	5	0	2	1	52	-1	0	-1	0	-1	0
1	198	ITEM_CH_TBLADE_07_B	3	1	6	5	0	0	1	56	-1	0	-1	0	-1	0
1	199	ITEM_CH_TBLADE_07_C	3	1	6	5	0	0	1	60	-1	0	-1	0	-1	0
1	200	ITEM_CH_TBLADE_08_A	3	1	6	5	0	2	1	64	-1	0	-1	0	-1	0
1	201	ITEM_CH_TBLADE_08_B	3	1	6	5	0	0	1	68	-1	0	-1	0	-1	0
1	202	ITEM_CH_TBLADE_08_C	3	1	6	5	0	0	1	72	-1	0	-1	0	-1	0
1	203	ITEM_CH_TBLADE_09_A	3	1	6	5	0	2	1	64	-1	0	-1	0	-1	0
1	204	ITEM_CH_TBLADE_09_B	3	1	6	5	0	0	1	80	-1	0	-1	0	-1	0
1	205	ITEM_CH_TBLADE_09_C	3	1	6	5	0	0	1	85	-1	0	-1	0	-1	0
1	218	ITEM_CH_BOW_02_A	3	1	6	6	0	2	1	8	-1	0	-1	0	-1	0
1	219	ITEM_CH_BOW_02_B	3	1	6	6	0	0	1	10	-1	0	-1	0	-1	0
1	220	ITEM_CH_BOW_02_C	3	1	6	6	0	0	1	13	-1	0	-1	0	-1	0
1	221	ITEM_CH_BOW_03_A	3	1	6	6	0	2	1	16	-1	0	-1	0	-1	0
1	222	ITEM_CH_BOW_03_B	3	1	6	6	0	0	1	18	-1	0	-1	0	-1	0
1	223	ITEM_CH_BOW_03_C	3	1	6	6	0	0	1	21	-1	0	-1	0	-1	0
1	224	ITEM_CH_BOW_04_A	3	1	6	6	0	2	1	24	-1	0	-1	0	-1	0
1	225	ITEM_CH_BOW_04_B	3	1	6	6	0	0	1	26	-1	0	-1	0	-1	0
1	226	ITEM_CH_BOW_04_C	3	1	6	6	0	0	1	29	-1	0	-1	0	-1	0
1	227	ITEM_CH_BOW_05_A	3	1	6	6	0	2	1	32	-1	0	-1	0	-1	0
1	228	ITEM_CH_BOW_05_B	3	1	6	6	0	0	1	35	-1	0	-1	0	-1	0
1	229	ITEM_CH_BOW_05_C	3	1	6	6	0	0	1	38	-1	0	-1	0	-1	0
1	230	ITEM_CH_BOW_06_A	3	1	6	6	0	2	1	42	-1	0	-1	0	-1	0
1	231	ITEM_CH_BOW_06_B	3	1	6	6	0	0	1	45	-1	0	-1	0	-1	0
1	232	ITEM_CH_BOW_06_C	3	1	6	6	0	0	1	48	-1	0	-1	0	-1	0
1	233	ITEM_CH_BOW_07_A	3	1	6	6	0	2	1	52	-1	0	-1	0	-1	0
1	234	ITEM_CH_BOW_07_B	3	1	6	6	0	0	1	56	-1	0	-1	0	-1	0
1	235	ITEM_CH_BOW_07_C	3	1	6	6	0	0	1	60	-1	0	-1	0	-1	0
1	236	ITEM_CH_BOW_08_A	3	1	6	6	0	2	1	64	-1	0	-1	0	-1	0
1	237	ITEM_CH_BOW_08_B	3	1	6	6	0	0	1	68	-1	0	-1	0	-1	0
1	238	ITEM_CH_BOW_08_C	3	1	6	6	0	0	1	72	-1	0	-1	0	-1	0
1	239	ITEM_CH_BOW_09_A	3	1	6	6	0	2	1	64	-1	0	-1	0	-1	0
1	240	ITEM_CH_BOW_09_B	3	1	6	6	0	0	1	80	-1	0	-1	0	-1	0
1	241	ITEM_CH_BOW_09_C	3	1	6	6	0	0	1	85	-1	0	-1	0	-1	0
1	254	ITEM_CH_SHIELD_02_A	3	1	4	1	0	2	1	8	-1	0	-1	0	-1	0
1	255	ITEM_CH_SHIELD_02_B	3	1	4	1	0	0	1	10	-1	0	-1	0	-1	0
1	256	ITEM_CH_SHIELD_02_C	3	1	4	1	0	0	1	13	-1	0	-1	0	-1	0
1	257	ITEM_CH_SHIELD_02_A	3	1	4	1	0	2	1	16	-1	0	-1	0	-1	0
1	258	ITEM_CH_SHIELD_03_B	3	1	4	1	0	0	1	18	-1	0	-1	0	-1	0
1	259	ITEM_CH_SHIELD_03_C	3	1	4	1	0	0	1	21	-1	0	-1	0	-1	0
1	260	ITEM_CH_SHIELD_04_A	3	1	4	1	0	2	1	24	-1	0	-1	0	-1	0
1	261	ITEM_CH_SHIELD_04_B	3	1	4	1	0	0	1	26	-1	0	-1	0	-1	0
1	262	ITEM_CH_SHIELD_04_C	3	1	4	1	0	0	1	29	-1	0	-1	0	-1	0
1	263	ITEM_CH_SHIELD_05_A	3	1	4	1	0	2	1	32	-1	0	-1	0	-1	0
1	264	ITEM_CH_SHIELD_05_B	3	1	4	1	0	0	1	35	-1	0	-1	0	-1	0
1	265	ITEM_CH_SHIELD_05_C	3	1	4	1	0	0	1	38	-1	0	-1	0	-1	0
1	266	ITEM_CH_SHIELD_06_A	3	1	4	1	0	2	1	42	-1	0	-1	0	-1	0
1	267	ITEM_CH_SHIELD_06_B	3	1	4	1	0	0	1	45	-1	0	-1	0	-1	0
1	268	ITEM_CH_SHIELD_06_C	3	1	4	1	0	0	1	48	-1	0	-1	0	-1	0
1	269	ITEM_CH_SHIELD_07_A	3	1	4	1	0	2	1	52	-1	0	-1	0	-1	0
1	270	ITEM_CH_SHIELD_07_B	3	1	4	1	0	0	1	56	-1	0	-1	0	-1	0
1	271	ITEM_CH_SHIELD_07_C	3	1	4	1	0	0	1	60	-1	0	-1	0	-1	0
1	272	ITEM_CH_SHIELD_08_A	3	1	4	1	0	2	1	64	-1	0	-1	0	-1	0
1	273	ITEM_CH_SHIELD_08_B	3	1	4	1	0	0	1	68	-1	0	-1	0	-1	0
1	274	ITEM_CH_SHIELD_08_C	3	1	4	1	0	0	1	72	-1	0	-1	0	-1	0
1	275	ITEM_CH_SHIELD_09_A	3	1	4	1	0	2	1	64	-1	0	-1	0	-1	0
1	276	ITEM_CH_SHIELD_09_B	3	1	4	1	0	0	1	80	-1	0	-1	0	-1	0
1	277	ITEM_CH_SHIELD_09_C	3	1	4	1	0	0	1	85	-1	0	-1	0	-1	0
1	10900	ITEM_EU_DAGGER_02_A	3	1	6	13	0	2	1	8	-1	0	-1	0	-1	0
1	10901	ITEM_EU_DAGGER_02_B	3	1	6	13	1	0	1	10	-1	0	-1	0	-1	0
1	10902	ITEM_EU_DAGGER_02_C	3	1	6	13	1	0	1	13	-1	0	-1	0	-1	0
1	10903	ITEM_EU_DAGGER_03_A	3	1	6	13	0	2	1	16	-1	0	-1	0	-1	0
1	10904	ITEM_EU_DAGGER_03_B	3	1	6	13	1	0	1	18	-1	0	-1	0	-1	0
1	10905	ITEM_EU_DAGGER_03_C	3	1	6	13	1	0	1	21	-1	0	-1	0	-1	0
1	10906	ITEM_EU_DAGGER_04_A	3	1	6	13	0	2	1	24	-1	0	-1	0	-1	0
1	10907	ITEM_EU_DAGGER_04_B	3	1	6	13	1	0	1	26	-1	0	-1	0	-1	0
1	10908	ITEM_EU_DAGGER_04_C	3	1	6	13	1	0	1	29	-1	0	-1	0	-1	0
1	10909	ITEM_EU_DAGGER_05_A	3	1	6	13	0	2	1	32	-1	0	-1	0	-1	0
1	10910	ITEM_EU_DAGGER_05_B	3	1	6	13	1	0	1	35	-1	0	-1	0	-1	0
1	10911	ITEM_EU_DAGGER_05_C	3	1	6	13	1	0	1	38	-1	0	-1	0	-1	0
1	10912	ITEM_EU_DAGGER_06_A	3	1	6	13	0	2	1	42	-1	0	-1	0	-1	0
1	10913	ITEM_EU_DAGGER_06_B	3	1	6	13	1	0	1	45	-1	0	-1	0	-1	0
1	10914	ITEM_EU_DAGGER_06_C	3	1	6	13	1	0	1	48	-1	0	-1	0	-1	0
1	10915	ITEM_EU_DAGGER_07_A	3	1	6	13	0	2	1	52	-1	0	-1	0	-1	0
1	10916	ITEM_EU_DAGGER_07_B	3	1	6	13	1	0	1	56	-1	0	-1	0	-1	0
1	10917	ITEM_EU_DAGGER_07_C	3	1	6	13	1	0	1	60	-1	0	-1	0	-1	0
1	10918	ITEM_EU_DAGGER_08_A	3	1	6	13	0	2	1	64	-1	0	-1	0	-1	0
1	10919	ITEM_EU_DAGGER_08_B	3	1	6	13	1	0	1	68	-1	0	-1	0	-1	0
1	10920	ITEM_EU_DAGGER_08_C	3	1	6	13	1	0	1	72	-1	0	-1	0	-1	0
1	10921	ITEM_EU_DAGGER_09_A	3	1	6	13	0	2	1	64	-1	0	-1	0	-1	0
1	10922	ITEM_EU_DAGGER_09_B	3	1	6	13	1	0	1	80	-1	0	-1	0	-1	0
1	10923	ITEM_EU_DAGGER_09_C	3	1	6	13	1	0	1	85	-1	0	-1	0	-1	0
1	10936	ITEM_EU_SWORD_02_A	3	1	6	7	0	2	1	8	-1	0	-1	0	-1	0
1	10937	ITEM_EU_SWORD_02_B	3	1	6	7	1	0	1	10	-1	0	-1	0	-1	0
1	10938	ITEM_EU_SWORD_02_C	3	1	6	7	1	0	1	13	-1	0	-1	0	-1	0
1	10939	ITEM_EU_SWORD_03_A	3	1	6	7	0	2	1	16	-1	0	-1	0	-1	0
1	10940	ITEM_EU_SWORD_03_B	3	1	6	7	1	0	1	18	-1	0	-1	0	-1	0
1	10941	ITEM_EU_SWORD_03_C	3	1	6	7	1	0	1	21	-1	0	-1	0	-1	0
1	10942	ITEM_EU_SWORD_04_A	3	1	6	7	0	2	1	24	-1	0	-1	0	-1	0
1	10943	ITEM_EU_SWORD_04_B	3	1	6	7	1	0	1	26	-1	0	-1	0	-1	0
1	10944	ITEM_EU_SWORD_04_C	3	1	6	7	1	0	1	29	-1	0	-1	0	-1	0
1	10945	ITEM_EU_SWORD_05_A	3	1	6	7	0	2	1	32	-1	0	-1	0	-1	0
1	10946	ITEM_EU_SWORD_05_B	3	1	6	7	1	0	1	35	-1	0	-1	0	-1	0
1	10947	ITEM_EU_SWORD_05_C	3	1	6	7	1	0	1	38	-1	0	-1	0	-1	0
1	10948	ITEM_EU_SWORD_06_A	3	1	6	7	0	2	1	42	-1	0	-1	0	-1	0
1	10949	ITEM_EU_SWORD_06_B	3	1	6	7	1	0	1	45	-1	0	-1	0	-1	0
1	10950	ITEM_EU_SWORD_06_C	3	1	6	7	1	0	1	48	-1	0	-1	0	-1	0
1	10951	ITEM_EU_SWORD_07_A	3	1	6	7	0	2	1	52	-1	0	-1	0	-1	0
1	10952	ITEM_EU_SWORD_07_B	3	1	6	7	1	0	1	56	-1	0	-1	0	-1	0
1	10953	ITEM_EU_SWORD_07_C	3	1	6	7	1	0	1	60	-1	0	-1	0	-1	0
1	10954	ITEM_EU_SWORD_08_A	3	1	6	7	0	2	1	64	-1	0	-1	0	-1	0
1	10955	ITEM_EU_SWORD_08_B	3	1	6	7	1	0	1	68	-1	0	-1	0	-1	0
1	10956	ITEM_EU_SWORD_08_C	3	1	6	7	1	0	1	72	-1	0	-1	0	-1	0
1	10957	ITEM_EU_SWORD_09_A	3	1	6	7	0	2	1	64	-1	0	-1	0	-1	0
1	10958	ITEM_EU_SWORD_09_B	3	1	6	7	1	0	1	80	-1	0	-1	0	-1	0
1	10959	ITEM_EU_SWORD_09_C	3	1	6	7	1	0	1	85	-1	0	-1	0	-1	0
1	10972	ITEM_EU_TSWORD_02_A	3	1	6	8	0	2	1	8	-1	0	-1	0	-1	0
1	10973	ITEM_EU_TSWORD_02_B	3	1	6	8	1	0	1	10	-1	0	-1	0	-1	0
1	10974	ITEM_EU_TSWORD_02_C	3	1	6	8	1	0	1	13	-1	0	-1	0	-1	0
1	10975	ITEM_EU_TSWORD_03_A	3	1	6	8	0	2	1	16	-1	0	-1	0	-1	0
1	10976	ITEM_EU_TSWORD_03_B	3	1	6	8	1	0	1	18	-1	0	-1	0	-1	0
1	10977	ITEM_EU_TSWORD_03_C	3	1	6	8	1	0	1	21	-1	0	-1	0	-1	0
1	10978	ITEM_EU_TSWORD_04_A	3	1	6	8	0	2	1	24	-1	0	-1	0	-1	0
1	10979	ITEM_EU_TSWORD_04_B	3	1	6	8	1	0	1	26	-1	0	-1	0	-1	0
1	10980	ITEM_EU_TSWORD_04_C	3	1	6	8	1	0	1	29	-1	0	-1	0	-1	0
1	10981	ITEM_EU_TSWORD_05_A	3	1	6	8	0	2	1	32	-1	0	-1	0	-1	0
1	10982	ITEM_EU_TSWORD_05_B	3	1	6	8	1	0	1	35	-1	0	-1	0	-1	0
1	10983	ITEM_EU_TSWORD_05_C	3	1	6	8	1	0	1	38	-1	0	-1	0	-1	0
1	10984	ITEM_EU_TSWORD_06_A	3	1	6	8	0	2	1	42	-1	0	-1	0	-1	0
1	10985	ITEM_EU_TSWORD_06_B	3	1	6	8	1	0	1	45	-1	0	-1	0	-1	0
1	10986	ITEM_EU_TSWORD_06_C	3	1	6	8	1	0	1	48	-1	0	-1	0	-1	0
1	10987	ITEM_EU_TSWORD_07_A	3	1	6	8	0	2	1	52	-1	0	-1	0	-1	0
1	10988	ITEM_EU_TSWORD_07_B	3	1	6	8	1	0	1	56	-1	0	-1	0	-1	0
1	10989	ITEM_EU_TSWORD_07_C	3	1	6	8	1	0	1	60	-1	0	-1	0	-1	0
1	10990	ITEM_EU_TSWORD_08_A	3	1	6	8	0	2	1	64	-1	0	-1	0	-1	0
1	10991	ITEM_EU_TSWORD_08_B	3	1	6	8	1	0	1	68	-1	0	-1	0	-1	0
1	10992	ITEM_EU_TSWORD_08_C	3	1	6	8	1	0	1	72	-1	0	-1	0	-1	0
1	10993	ITEM_EU_TSWORD_09_A	3	1	6	8	0	2	1	64	-1	0	-1	0	-1	0
1	10994	ITEM_EU_TSWORD_09_B	3	1	6	8	1	0	1	80	-1	0	-1	0	-1	0
1	10995	ITEM_EU_TSWORD_09_C	3	1	6	8	1	0	1	85	-1	0	-1	0	-1	0
1	11008	ITEM_EU_AXE_02_A	3	1	6	9	0	2	1	8	-1	0	-1	0	-1	0
1	11009	ITEM_EU_AXE_02_B	3	1	6	9	1	0	1	10	-1	0	-1	0	-1	0
1	11010	ITEM_EU_AXE_02_C	3	1	6	9	1	0	1	13	-1	0	-1	0	-1	0
1	11011	ITEM_EU_AXE_03_A	3	1	6	9	0	2	1	16	-1	0	-1	0	-1	0
1	11012	ITEM_EU_AXE_03_B	3	1	6	9	1	0	1	18	-1	0	-1	0	-1	0
1	11013	ITEM_EU_AXE_03_C	3	1	6	9	1	0	1	21	-1	0	-1	0	-1	0
1	11014	ITEM_EU_AXE_04_A	3	1	6	9	0	2	1	24	-1	0	-1	0	-1	0
1	11015	ITEM_EU_AXE_04_B	3	1	6	9	1	0	1	26	-1	0	-1	0	-1	0
1	11016	ITEM_EU_AXE_04_C	3	1	6	9	1	0	1	29	-1	0	-1	0	-1	0
1	11017	ITEM_EU_AXE_05_A	3	1	6	9	0	2	1	32	-1	0	-1	0	-1	0
1	11018	ITEM_EU_AXE_05_B	3	1	6	9	1	0	1	35	-1	0	-1	0	-1	0
1	11019	ITEM_EU_AXE_05_C	3	1	6	9	1	0	1	38	-1	0	-1	0	-1	0
1	11020	ITEM_EU_AXE_06_A	3	1	6	9	0	2	1	42	-1	0	-1	0	-1	0
1	11021	ITEM_EU_AXE_06_B	3	1	6	9	1	0	1	45	-1	0	-1	0	-1	0
1	11022	ITEM_EU_AXE_06_C	3	1	6	9	1	0	1	48	-1	0	-1	0	-1	0
1	11023	ITEM_EU_AXE_07_A	3	1	6	9	0	2	1	52	-1	0	-1	0	-1	0
1	11024	ITEM_EU_AXE_07_B	3	1	6	9	1	0	1	56	-1	0	-1	0	-1	0
1	11025	ITEM_EU_AXE_07_C	3	1	6	9	1	0	1	60	-1	0	-1	0	-1	0
1	11026	ITEM_EU_AXE_08_A	3	1	6	9	0	2	1	64	-1	0	-1	0	-1	0
1	11027	ITEM_EU_AXE_08_B	3	1	6	9	1	0	1	68	-1	0	-1	0	-1	0
1	11028	ITEM_EU_AXE_08_C	3	1	6	9	1	0	1	72	-1	0	-1	0	-1	0
1	11029	ITEM_EU_AXE_09_A	3	1	6	9	0	2	1	64	-1	0	-1	0	-1	0
1	11030	ITEM_EU_AXE_09_B	3	1	6	9	1	0	1	80	-1	0	-1	0	-1	0
1	11031	ITEM_EU_AXE_09_C	3	1	6	9	1	0	1	85	-1	0	-1	0	-1	0
1	11044	ITEM_EU_CROSSBOW_02_A	3	1	6	12	0	2	1	8	-1	0	-1	0	-1	0
1	11045	ITEM_EU_CROSSBOW_02_B	3	1	6	12	1	0	1	10	-1	0	-1	0	-1	0
1	11046	ITEM_EU_CROSSBOW_02_C	3	1	6	12	1	0	1	13	-1	0	-1	0	-1	0
1	11047	ITEM_EU_CROSSBOW_03_A	3	1	6	12	0	2	1	16	-1	0	-1	0	-1	0
1	11048	ITEM_EU_CROSSBOW_03_B	3	1	6	12	1	0	1	18	-1	0	-1	0	-1	0
1	11049	ITEM_EU_CROSSBOW_03_C	3	1	6	12	1	0	1	21	-1	0	-1	0	-1	0
1	11050	ITEM_EU_CROSSBOW_04_A	3	1	6	12	0	2	1	24	-1	0	-1	0	-1	0
1	11051	ITEM_EU_CROSSBOW_04_B	3	1	6	12	1	0	1	26	-1	0	-1	0	-1	0
1	11052	ITEM_EU_CROSSBOW_04_C	3	1	6	12	1	0	1	29	-1	0	-1	0	-1	0
1	11053	ITEM_EU_CROSSBOW_05_A	3	1	6	12	0	2	1	32	-1	0	-1	0	-1	0
1	11054	ITEM_EU_CROSSBOW_05_B	3	1	6	12	1	0	1	35	-1	0	-1	0	-1	0
1	11055	ITEM_EU_CROSSBOW_05_C	3	1	6	12	1	0	1	38	-1	0	-1	0	-1	0
1	11056	ITEM_EU_CROSSBOW_06_A	3	1	6	12	0	2	1	42	-1	0	-1	0	-1	0
1	11057	ITEM_EU_CROSSBOW_06_B	3	1	6	12	1	0	1	45	-1	0	-1	0	-1	0
1	11058	ITEM_EU_CROSSBOW_06_C	3	1	6	12	1	0	1	48	-1	0	-1	0	-1	0
1	11059	ITEM_EU_CROSSBOW_07_A	3	1	6	12	0	2	1	52	-1	0	-1	0	-1	0
1	11060	ITEM_EU_CROSSBOW_07_B	3	1	6	12	1	0	1	56	-1	0	-1	0	-1	0
1	11061	ITEM_EU_CROSSBOW_07_C	3	1	6	12	1	0	1	60	-1	0	-1	0	-1	0
1	11062	ITEM_EU_CROSSBOW_08_A	3	1	6	12	0	2	1	64	-1	0	-1	0	-1	0
1	11063	ITEM_EU_CROSSBOW_08_B	3	1	6	12	1	0	1	68	-1	0	-1	0	-1	0
1	11064	ITEM_EU_CROSSBOW_08_C	3	1	6	12	1	0	1	72	-1	0	-1	0	-1	0
1	11065	ITEM_EU_CROSSBOW_09_A	3	1	6	12	0	2	1	64	-1	0	-1	0	-1	0
1	11066	ITEM_EU_CROSSBOW_09_B	3	1	6	12	1	0	1	80	-1	0	-1	0	-1	0
1	11067	ITEM_EU_CROSSBOW_09_C	3	1	6	12	1	0	1	85	-1	0	-1	0	-1	0
1	11080	ITEM_EU_DARKSTAFF_02_A	3	1	6	10	0	2	1	8	-1	0	-1	0	-1	0
1	11081	ITEM_EU_DARKSTAFF_02_B	3	1	6	10	1	0	1	10	-1	0	-1	0	-1	0
1	11082	ITEM_EU_DARKSTAFF_02_C	3	1	6	10	1	0	1	13	-1	0	-1	0	-1	0
1	11083	ITEM_EU_DARKSTAFF_03_A	3	1	6	10	0	2	1	16	-1	0	-1	0	-1	0
1	11084	ITEM_EU_DARKSTAFF_03_B	3	1	6	10	1	0	1	18	-1	0	-1	0	-1	0
1	11085	ITEM_EU_DARKSTAFF_03_C	3	1	6	10	1	0	1	21	-1	0	-1	0	-1	0
1	11086	ITEM_EU_DARKSTAFF_04_A	3	1	6	10	0	2	1	24	-1	0	-1	0	-1	0
1	11087	ITEM_EU_DARKSTAFF_04_B	3	1	6	10	1	0	1	26	-1	0	-1	0	-1	0
1	11088	ITEM_EU_DARKSTAFF_04_C	3	1	6	10	1	0	1	29	-1	0	-1	0	-1	0
1	11089	ITEM_EU_DARKSTAFF_05_A	3	1	6	10	0	2	1	32	-1	0	-1	0	-1	0
1	11090	ITEM_EU_DARKSTAFF_05_B	3	1	6	10	1	0	1	35	-1	0	-1	0	-1	0
1	11091	ITEM_EU_DARKSTAFF_05_C	3	1	6	10	1	0	1	38	-1	0	-1	0	-1	0
1	11092	ITEM_EU_DARKSTAFF_06_A	3	1	6	10	0	2	1	42	-1	0	-1	0	-1	0
1	11093	ITEM_EU_DARKSTAFF_06_B	3	1	6	10	1	0	1	45	-1	0	-1	0	-1	0
1	11094	ITEM_EU_DARKSTAFF_06_C	3	1	6	10	1	0	1	48	-1	0	-1	0	-1	0
1	11095	ITEM_EU_DARKSTAFF_07_A	3	1	6	10	0	2	1	52	-1	0	-1	0	-1	0
1	11096	ITEM_EU_DARKSTAFF_07_B	3	1	6	10	1	0	1	56	-1	0	-1	0	-1	0
1	11097	ITEM_EU_DARKSTAFF_07_C	3	1	6	10	1	0	1	60	-1	0	-1	0	-1	0
1	11098	ITEM_EU_DARKSTAFF_08_A	3	1	6	10	0	2	1	64	-1	0	-1	0	-1	0
1	11099	ITEM_EU_DARKSTAFF_08_B	3	1	6	10	1	0	1	68	-1	0	-1	0	-1	0
1	11100	ITEM_EU_DARKSTAFF_08_C	3	1	6	10	1	0	1	72	-1	0	-1	0	-1	0
1	11101	ITEM_EU_DARKSTAFF_09_A	3	1	6	10	0	2	1	64	-1	0	-1	0	-1	0
1	11102	ITEM_EU_DARKSTAFF_09_B	3	1	6	10	1	0	1	80	-1	0	-1	0	-1	0
1	11103	ITEM_EU_DARKSTAFF_09_C	3	1	6	10	1	0	1	85	-1	0	-1	0	-1	0
1	11116	ITEM_EU_TSTAFF_02_A	3	1	6	11	0	2	1	8	-1	0	-1	0	-1	0
1	11117	ITEM_EU_TSTAFF_02_B	3	1	6	11	1	0	1	10	-1	0	-1	0	-1	0
1	11118	ITEM_EU_TSTAFF_02_C	3	1	6	11	1	0	1	13	-1	0	-1	0	-1	0
1	11119	ITEM_EU_TSTAFF_03_A	3	1	6	11	0	2	1	16	-1	0	-1	0	-1	0
1	11120	ITEM_EU_TSTAFF_03_B	3	1	6	11	1	0	1	18	-1	0	-1	0	-1	0
1	11121	ITEM_EU_TSTAFF_03_C	3	1	6	11	1	0	1	21	-1	0	-1	0	-1	0
1	11122	ITEM_EU_TSTAFF_04_A	3	1	6	11	0	2	1	24	-1	0	-1	0	-1	0
1	11123	ITEM_EU_TSTAFF_04_B	3	1	6	11	1	0	1	26	-1	0	-1	0	-1	0
1	11124	ITEM_EU_TSTAFF_04_C	3	1	6	11	1	0	1	29	-1	0	-1	0	-1	0
1	11125	ITEM_EU_TSTAFF_05_A	3	1	6	11	0	2	1	32	-1	0	-1	0	-1	0
1	11126	ITEM_EU_TSTAFF_05_B	3	1	6	11	1	0	1	35	-1	0	-1	0	-1	0
1	11127	ITEM_EU_TSTAFF_05_C	3	1	6	11	1	0	1	38	-1	0	-1	0	-1	0
1	11128	ITEM_EU_TSTAFF_06_A	3	1	6	11	0	2	1	42	-1	0	-1	0	-1	0
1	11129	ITEM_EU_TSTAFF_06_B	3	1	6	11	1	0	1	45	-1	0	-1	0	-1	0
1	11130	ITEM_EU_TSTAFF_06_C	3	1	6	11	1	0	1	48	-1	0	-1	0	-1	0
1	11131	ITEM_EU_TSTAFF_07_A	3	1	6	11	0	2	1	52	-1	0	-1	0	-1	0
1	11132	ITEM_EU_TSTAFF_07_B	3	1	6	11	1	0	1	56	-1	0	-1	0	-1	0
1	11133	ITEM_EU_TSTAFF_07_C	3	1	6	11	1	0	1	60	-1	0	-1	0	-1	0
1	11134	ITEM_EU_TSTAFF_08_A	3	1	6	11	0	2	1	64	-1	0	-1	0	-1	0
1	11135	ITEM_EU_TSTAFF_08_B	3	1	6	11	1	0	1	68	-1	0	-1	0	-1	0
1	11136	ITEM_EU_TSTAFF_08_C	3	1	6	11	1	0	1	72	-1	0	-1	0	-1	0
1	11137	ITEM_EU_TSTAFF_09_A	3	1	6	11	0	2	1	64	-1	0	-1	0	-1	0
1	11138	ITEM_EU_TSTAFF_09_B	3	1	6	11	1	0	1	80	-1	0	-1	0	-1	0
1	11139	ITEM_EU_TSTAFF_09_C	3	1	6	11	1	0	1	85	-1	0	-1	0	-1	0
1	11152	ITEM_EU_HARP_02_A	3	1	6	14	0	2	1	8	-1	0	-1	0	-1	0
1	11153	ITEM_EU_HARP_02_B	3	1	6	14	1	0	1	10	-1	0	-1	0	-1	0
1	11154	ITEM_EU_HARP_02_C	3	1	6	14	1	0	1	13	-1	0	-1	0	-1	0
1	11155	ITEM_EU_HARP_03_A	3	1	6	14	0	2	1	16	-1	0	-1	0	-1	0
1	11156	ITEM_EU_HARP_03_B	3	1	6	14	1	0	1	18	-1	0	-1	0	-1	0
1	11157	ITEM_EU_HARP_03_C	3	1	6	14	1	0	1	21	-1	0	-1	0	-1	0
1	11158	ITEM_EU_HARP_04_A	3	1	6	14	0	2	1	24	-1	0	-1	0	-1	0
1	11159	ITEM_EU_HARP_04_B	3	1	6	14	1	0	1	26	-1	0	-1	0	-1	0
1	11160	ITEM_EU_HARP_04_C	3	1	6	14	1	0	1	29	-1	0	-1	0	-1	0
1	11161	ITEM_EU_HARP_05_A	3	1	6	14	0	2	1	32	-1	0	-1	0	-1	0
1	11162	ITEM_EU_HARP_05_B	3	1	6	14	1	0	1	35	-1	0	-1	0	-1	0
1	11163	ITEM_EU_HARP_05_C	3	1	6	14	1	0	1	38	-1	0	-1	0	-1	0
1	11164	ITEM_EU_HARP_06_A	3	1	6	14	0	2	1	42	-1	0	-1	0	-1	0
1	11165	ITEM_EU_HARP_06_B	3	1	6	14	1	0	1	45	-1	0	-1	0	-1	0
1	11166	ITEM_EU_HARP_06_C	3	1	6	14	1	0	1	48	-1	0	-1	0	-1	0
1	11167	ITEM_EU_HARP_07_A	3	1	6	14	0	2	1	52	-1	0	-1	0	-1	0
1	11168	ITEM_EU_HARP_07_B	3	1	6	14	1	0	1	56	-1	0	-1	0	-1	0
1	11169	ITEM_EU_HARP_07_C	3	1	6	14	1	0	1	60	-1	0	-1	0	-1	0
1	11170	ITEM_EU_HARP_08_A	3	1	6	14	0	2	1	64	-1	0	-1	0	-1	0
1	11171	ITEM_EU_HARP_08_B	3	1	6	14	1	0	1	68	-1	0	-1	0	-1	0
1	11172	ITEM_EU_HARP_08_C	3	1	6	14	1	0	1	72	-1	0	-1	0	-1	0
1	11173	ITEM_EU_HARP_09_A	3	1	6	14	0	2	1	64	-1	0	-1	0	-1	0
1	11174	ITEM_EU_HARP_09_B	3	1	6	14	1	0	1	80	-1	0	-1	0	-1	0
1	11175	ITEM_EU_HARP_09_C	3	1	6	14	1	0	1	85	-1	0	-1	0	-1	0
1	11188	ITEM_EU_STAFF_02_A	3	1	6	14	0	2	1	8	-1	0	-1	0	-1	0
1	11189	ITEM_EU_STAFF_02_B	3	1	6	15	1	0	1	10	-1	0	-1	0	-1	0
1	11190	ITEM_EU_STAFF_02_C	3	1	6	15	1	0	1	13	-1	0	-1	0	-1	0
1	11191	ITEM_EU_STAFF_03_A	3	1	6	15	0	2	1	16	-1	0	-1	0	-1	0
1	11192	ITEM_EU_STAFF_03_B	3	1	6	15	1	0	1	18	-1	0	-1	0	-1	0
1	11193	ITEM_EU_STAFF_03_C	3	1	6	15	1	0	1	21	-1	0	-1	0	-1	0
1	11194	ITEM_EU_STAFF_04_A	3	1	6	15	0	2	1	24	-1	0	-1	0	-1	0
1	11195	ITEM_EU_STAFF_04_B	3	1	6	15	1	0	1	26	-1	0	-1	0	-1	0
1	11196	ITEM_EU_STAFF_04_C	3	1	6	15	1	0	1	29	-1	0	-1	0	-1	0
1	11197	ITEM_EU_STAFF_05_A	3	1	6	15	0	2	1	32	-1	0	-1	0	-1	0
1	11198	ITEM_EU_STAFF_05_B	3	1	6	15	1	0	1	35	-1	0	-1	0	-1	0
1	11199	ITEM_EU_STAFF_05_C	3	1	6	15	1	0	1	38	-1	0	-1	0	-1	0
1	11200	ITEM_EU_STAFF_06_A	3	1	6	15	0	2	1	42	-1	0	-1	0	-1	0
1	11201	ITEM_EU_STAFF_06_B	3	1	6	15	1	0	1	45	-1	0	-1	0	-1	0
1	11202	ITEM_EU_STAFF_06_C	3	1	6	15	1	0	1	48	-1	0	-1	0	-1	0
1	11203	ITEM_EU_STAFF_07_A	3	1	6	15	0	2	1	52	-1	0	-1	0	-1	0
1	11204	ITEM_EU_STAFF_07_B	3	1	6	15	1	0	1	56	-1	0	-1	0	-1	0
1	11205	ITEM_EU_STAFF_07_C	3	1	6	15	1	0	1	60	-1	0	-1	0	-1	0
1	11206	ITEM_EU_STAFF_08_A	3	1	6	15	0	2	1	64	-1	0	-1	0	-1	0
1	11207	ITEM_EU_STAFF_08_B	3	1	6	15	1	0	1	68	-1	0	-1	0	-1	0
1	11208	ITEM_EU_STAFF_08_C	3	1	6	15	1	0	1	72	-1	0	-1	0	-1	0
1	11209	ITEM_EU_STAFF_09_A	3	1	6	15	0	2	1	64	-1	0	-1	0	-1	0
1	11210	ITEM_EU_STAFF_09_B	3	1	6	15	1	0	1	80	-1	0	-1	0	-1	0
1	11211	ITEM_EU_STAFF_09_C	3	1	6	15	1	0	1	85	-1	0	-1	0	-1	0
1	11548	ITEM_EU_SHIELD_02_A	3	1	4	2	0	2	1	8	-1	0	-1	0	-1	0
1	11549	ITEM_EU_SHIELD_02_B	3	1	4	2	1	0	1	10	-1	0	-1	0	-1	0
1	11550	ITEM_EU_SHIELD_02_C	3	1	4	2	1	0	1	13	-1	0	-1	0	-1	0
1	11551	ITEM_EU_SHIELD_03_A	3	1	4	2	0	2	1	16	-1	0	-1	0	-1	0
1	11552	ITEM_EU_SHIELD_03_B	3	1	4	2	1	0	1	18	-1	0	-1	0	-1	0
1	11553	ITEM_EU_SHIELD_03_C	3	1	4	2	1	0	1	21	-1	0	-1	0	-1	0
1	11554	ITEM_EU_SHIELD_04_A	3	1	4	2	0	2	1	24	-1	0	-1	0	-1	0
1	11555	ITEM_EU_SHIELD_04_B	3	1	4	2	1	0	1	26	-1	0	-1	0	-1	0
1	11556	ITEM_EU_SHIELD_04_C	3	1	4	2	1	0	1	29	-1	0	-1	0	-1	0
1	11557	ITEM_EU_SHIELD_05_A	3	1	4	2	0	2	1	32	-1	0	-1	0	-1	0
1	11558	ITEM_EU_SHIELD_05_B	3	1	4	2	1	0	1	35	-1	0	-1	0	-1	0
1	11559	ITEM_EU_SHIELD_05_C	3	1	4	2	1	0	1	38	-1	0	-1	0	-1	0
1	11560	ITEM_EU_SHIELD_06_A	3	1	4	2	0	2	1	42	-1	0	-1	0	-1	0
1	11561	ITEM_EU_SHIELD_06_B	3	1	4	2	1	0	1	45	-1	0	-1	0	-1	0
1	11562	ITEM_EU_SHIELD_06_C	3	1	4	2	1	0	1	48	-1	0	-1	0	-1	0
1	11563	ITEM_EU_SHIELD_07_A	3	1	4	2	0	2	1	52	-1	0	-1	0	-1	0
1	11564	ITEM_EU_SHIELD_07_B	3	1	4	2	1	0	1	56	-1	0	-1	0	-1	0
1	11565	ITEM_EU_SHIELD_07_C	3	1	4	2	1	0	1	60	-1	0	-1	0	-1	0
1	11566	ITEM_EU_SHIELD_08_A	3	1	4	2	0	2	1	64	-1	0	-1	0	-1	0
1	11567	ITEM_EU_SHIELD_08_B	3	1	4	2	1	0	1	68	-1	0	-1	0	-1	0
1	11568	ITEM_EU_SHIELD_08_C	3	1	4	2	1	0	1	72	-1	0	-1	0	-1	0
1	11569	ITEM_EU_SHIELD_09_A	3	1	4	2	0	2	1	64	-1	0	-1	0	-1	0
1	11570	ITEM_EU_SHIELD_09_B	3	1	4	2	1	0	1	80	-1	0	-1	0	-1	0
1	11571	ITEM_EU_SHIELD_09_C	3	1	4	2	1	0	1	85	-1	0	-1	0	-1	0

### Procedure ###

Execute the following query to create the required procedure:

 Spoiler

 USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_FN_ADD_INITIAL_EQUIP_DEPI]    Script Date: 03/26/2017 00:24:35 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
-------------------------------------------------------------------------------------
CREATE PROCEDURE [dbo].[_FN_ADD_INITIAL_EQUIP_DEPI] @charname AS varchar(64), @slot AS TINYINT, @codename AS varchar(129), @data AS INT
AS
----------------------------------------------------------
-- Step1. ì•”�����žì�´í...ş“ 집씓´ ë”�����ž£ìş“¼ë ¤ëş ”������ ì�¸ë²¤í”����� 리 ìş ¬ë¡¯ì�´ ë¹”�����žì”�����”�����Ë”���� ëş ”������ê°â”����ş¡¬ íâ”����ž¢•ì�¸
---------------------------------------------------------- 
DECLARE @charID INT
SET @charID = (select CharID from _Char where CharName16 = @charname)
DECLARE @ItemInSlot BIGINT
SET @ItemInSlot = 0
SELECT @ItemInSlot = ItemID FROM _Inventory WHERE CharID = @charID AND Slot = @slot
IF (@ItemInSlot <> 0)
BEGIN
RETURN -1
END
----------------------------------------------------------
-- Step2. ì•”�����žì�´í...ş“ ìÆ’�ì”�����ž±
---------------------------------------------------------- 
DECLARE @refItemID INT
SET @refItemID = (select ID from _RefObjCommon where CodeName128 = @codename)
DECLARE @NewItem BIGINT
DECLARE @serial BIGINT
SET @serial = 0

EXEC @NewItem = _STRG_ALLOC_ITEM_NoTX @serial OUTPUT
IF (@NewItem = 0)
BEGIN
RETURN -2
END

IF (EXISTS(SELECT ItemID FROM _Inventory WHERE ItemID = @NewItem))
BEGIN
RETURN -181818
END
IF (EXISTS(SELECT ItemID FROM _Chest WHERE ItemID = @NewItem))
BEGIN
RETURN -282828
END
UPDATE _Items SET RefItemID = @refItemID, OptLevel = 4, Variance = 34359738367, Data = @data, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' WHERE ID64 = @NewItem
IF (@@ERROR <> 0)
BEGIN
RETURN -3
END
----------------------------------------------------------
-- Step3. ì•”�����žì�´í...ş“ ì”�����ž¸íş’...
---------------------------------------------------------- 
UPDATE _Inventory SET ItemID = @NewItem WHERE CharID = @charID AND Slot = @slot
IF (@@ERROR <> 0)
BEGIN
RETURN -4
END
RETURN @NewItem

### Trigger ###

Execute the following query to create a trigger on _Char table, which gives chars specific gears based on their level. I based it on lvl 13-99, you can always change this.

 Spoiler

 USE [SRO_VT_SHARD]
GO
/****** Object:  Trigger [dbo].[TR_AUTOEQUIP_DEPIEDRA]    Script Date: 03/26/2017 00:19:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[TR_AUTOEQUIP_DEPIEDRA] ON [dbo].[_Char] AFTER UPDATE
AS
BEGIN
declare @Newlvl as tinyint = (select CurLevel from inserted)
declare @charID as int = (select CharID from inserted)
if @Newlvl between 13 and 99
begin
declare @refCharID int
declare @charname varchar(64)
declare @charLevel tinyint
set @refCharID = (select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @charID)
set @charname = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @charID)
set @charLevel = (select CurLevel from SRO_VT_SHARD.dbo._Char where CharID = @charID)
Declare @refMail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID) 
AND Slot ='1')
Declare @refMailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @refMail)
Declare @refWeapon INT
Declare @weapon INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID) 
AND Slot ='6')
Declare @refWeaponID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @weapon)
Declare @weaponType Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @refWeaponID)
Declare @refShield INT
Declare @Shield INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID) 
AND Slot ='7')
Declare @refShieldID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @Shield)
Declare @ShieldType Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @refShieldID)
declare @mail_codename varchar(250)
declare @chr_gender varchar(250)
declare @item_level varchar(250)
declare @itemcodename varchar(250)
select @mail_codename = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @refMailID
declare @degree varchar(25)


Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 0
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 1
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 2
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 3
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 4
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 5
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 9
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 10
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 11
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 12

if (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID) 
AND Slot ='6') != 0
begin
If ((Select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = (Select top 1 RefItemID from SRO_VT_SHARD.dbo._items where id64 = @weapon))
= @weaponType ) -- Weapon
Begin
Set @refWeapon = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment where 
Service = 1 AND
TypeID1=3 AND --- Weapon
TypeID2=1 AND
TypeID3=6 AND
TypeID4=@weaponType
Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
having (MAX(ReqLevel1)<= @Newlvl)
Order By ReqLevel1 Desc 
)
Update SRO_VT_SHARD.dbo._Items set RefItemID= @refWeapon where ID64= @weapon
Update SRO_VT_SHARD.dbo._Items set OptLevel= 4,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= @weapon
END 
end

if (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID) 
AND Slot ='7') != 0
begin
If ((Select ID from SRO_VT_SHARD.dbo._RefObjCommon where ID in (Select Refitemid from SRO_VT_SHARD.dbo._Items where ID64 = @Shield)) not in (62,3655))
Begin
Set @refShield = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment WITH (Nolock) where 
Service = 1 AND
TypeID1=3 AND --- Shield
TypeID2=1 AND
TypeID3=4 AND
TypeID4=@ShieldType
Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
having (MAX(ReqLevel1)<= @Newlvl)
Order By ReqLevel1 Desc 
)
Update SRO_VT_SHARD.dbo._Items set RefItemID= @refShield where ID64= @Shield
Update SRO_VT_SHARD.dbo._Items set OptLevel= 4,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= @Shield
END
end

IF @Newlvl >= 90 and @Newlvl <= 99
BEGIN
set @item_level = '09' --DG
set @degree = '_C'
end
end

IF @Newlvl >= 85 and @Newlvl <= 89
BEGIN
set @item_level = '09' --DG
set @degree = '_B'
end
end

IF @Newlvl >= 81 and @Newlvl <= 84
BEGIN
set @item_level = '09' --DG
set @degree = '_A'
end 

IF @Newlvl >= 77 and @Newlvl <= 80
BEGIN
set @item_level = '08' --DG
IF @item_level = '09'
begin
set @degree = '_A'
end
else if @item_level = '08'
begin
set @degree = '_C'
end
end

IF @Newlvl >= 73 and @Newlvl <= 76
BEGIN
set @item_level = '08' --DG
IF @item_level = '09'
begin
set @degree = '_A'
end
else if @item_level = '08'
begin
set @degree = '_B'
end
end

IF @Newlvl >= 69 and @Newlvl <= 72
BEGIN
set @item_level = '08' --DG
set @degree = '_A'
end

IF @Newlvl >= 65 and @Newlvl <= 68
BEGIN
set @item_level = '07' --DG
IF @item_level = '08'
begin
set @degree = '_A'
end
else if @item_level = '07'
begin
set @degree = '_C'
end
end

IF @Newlvl >= 61 and @Newlvl <= 64
BEGIN
set @item_level = '07' --DG
IF @item_level = '08'
begin
set @degree = '_A'
end
else if @item_level = '07'
begin
set @degree = '_B'
end
end

IF @Newlvl >= 57 and @Newlvl <= 60
BEGIN
set @item_level = '07' --DG
set @degree = '_A'
end 

IF @Newlvl >= 53 and @Newlvl <= 56
BEGIN
set @item_level = '06' --DG
IF @item_level = '07'
begin
set @degree = '_A'
end
else if @item_level = '06'
begin
set @degree = '_C'
end
end

IF @Newlvl >= 50 and @Newlvl <= 52
BEGIN
set @item_level = '06' --DG
IF @item_level = '07'
begin
set @degree = '_A'
end
else if @item_level = '06'
begin
set @degree = '_B'
end
end

IF @Newlvl >= 47 and @Newlvl <= 49
BEGIN
set @item_level = '06' --DG
set @degree = '_A'
end 

IF @Newlvl >= 43 and @Newlvl <= 46
BEGIN
set @item_level = '05' --DG
IF @item_level = '06'
begin
set @degree = '_A'
end
else if @item_level = '05'
begin
set @degree = '_C'
end
end

IF @Newlvl >= 40 and @Newlvl <= 42
BEGIN
set @item_level = '05' --DG
IF @item_level = '06'
begin
set @degree = '_A'
end
else if @item_level = '05'
begin
set @degree = '_B'
end
end

IF @Newlvl >= 37 and @Newlvl <= 39
BEGIN
set @item_level = '05' --DG
set @degree = '_A'
end

IF @Newlvl >= 34 and @Newlvl <= 36
BEGIN
set @item_level = '04' --DG
IF @item_level = '05'
begin
set @degree = '_A'
end
else if @item_level = '05'
begin
set @degree = '_C'
end
end

IF @Newlvl >= 31 and @Newlvl <= 33
BEGIN
set @item_level = '04' --DG
IF @item_level = '05'
begin
set @degree = '_A'
end
else if @item_level = '04'
begin
set @degree = '_B'
end
end

IF @Newlvl >= 29 and @Newlvl <= 30
BEGIN
set @item_level = '04' --DG
set @degree = '_A'
end 

IF @Newlvl >= 26 and @Newlvl <= 28
BEGIN
set @item_level = '03' --DG
IF @item_level = '04'
begin
set @degree = '_A'
end
else if @item_level = '03'
begin
set @degree = '_C'
end
end

IF @Newlvl >= 23 and @Newlvl <= 25
BEGIN
set @item_level = '03' --DG
IF @item_level = '04'
begin
set @degree = '_A'
end
else if @item_level = '03'
begin
set @degree = '_B'
end
end

IF @Newlvl = 21 or @Newlvl = 22
BEGIN
set @item_level = '03' --DG
set @degree = '_A'
end 

IF @Newlvl >= 18 and @Newlvl <= 20
BEGIN
set @item_level = '02' --DG
IF @item_level = '03'
begin
set @degree = '_B'
end
else if @item_level = '02'
begin
set @degree = '_C'
end
end

IF @Newlvl >= 15 and @Newlvl <= 17
BEGIN
set @item_level = '02' --DG
IF @item_level = '03'
begin
set @degree = '_A'
end
else if @item_level = '02'
begin
set @degree = '_B'
end
end

IF @Newlvl >= 13 and @Newlvl <= 14
BEGIN
set @item_level = '02' --DG
set @degree = '_A'
end

if @refCharID between 1907 and 1919 or @refCharID between 14875 and 14887
begin
set @chr_gender = 'M' --male
end

if @refCharID between 1920 and 1932 or @refCharID between 14888 and 14900
begin
set @chr_gender = 'W' --female
end


if @refCharID between 1907 and 1919 or @refCharID between 1920 and 1932
begin
set @itemcodename = 'ITEM_CH_RING_' + @item_level + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,11,@itemcodename,200
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,12,@itemcodename,200
set @itemcodename = 'ITEM_CH_EARRING_' + @item_level + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,9,@itemcodename,200
set @itemcodename = 'ITEM_CH_NECKLACE_' + @item_level + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,10,@itemcodename,200
end
if @refCharID between 14875 and 14887 or @refCharID between 14888 and 14900
begin
set @itemcodename = 'ITEM_EU_RING_' + @item_level + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,11,@itemcodename,200
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,12,@itemcodename,200
set @itemcodename = 'ITEM_EU_EARRING_' + @item_level + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,9,@itemcodename,200
set @itemcodename = 'ITEM_EU_NECKLACE_' + @item_level + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,10,@itemcodename,200
end


--//ARMOR\\--
if @mail_codename like 'ITEM_CH_%_LIGHT%'
begin
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_LIGHT_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_CH_%_HEAVY%'
begin
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_HEAVY_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_CH_%_CLOTHES%'
begin
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_CH_' + @chr_gender + '_CLOTHES_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_EU_%_LIGHT%'
begin
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_LIGHT_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_EU_%_HEAVY%'
begin
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_HEAVY_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end
else if @mail_codename like 'ITEM_EU_%_CLOTHES%'
begin
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_HA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,0,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_SA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,2,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_BA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,1,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_LA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,4,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_AA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,3,@itemcodename,200
set @itemcodename = 'ITEM_EU_' + @chr_gender + '_CLOTHES_' + @item_level + '_FA' + @degree
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,5,@itemcodename,200
end

That's it

If you need help customizing it, feel free to contact me.

[B1Q]

nice query m8

[brklol]

Originally Posted by B1QB0SS :3

nice query m8

nice you read through it that fast?

[JekaBlue]

nice work dud but are you sure he is completed ?

[lordshreck]

works

[brklol]

Originally Posted by JekaBlue

nice work dud but are you sure he is completed ?

I had issues before but fixed them and tested on pretty much all levels.. so should be workin. tell me if u find any bugs

[JekaBlue]

I add it into my test server but it,s not working idk why ?

[brklol]

Originally Posted by JekaBlue

I add it into my test server but it,s not working idk why ?

Any errors? is your char lvl 13++?

[nemo08]

Originally Posted by JekaBlue

I add it into my test server but it,s not working idk why ?

it works very well but u didnt insert the required Lines to _ItemPoolAutoEquipment for all items .

[brklol]

updated, fixed an issue with lvl 18-20 gear

[Mangetsu||]

well, at least a trigger wont be that big deal causing a serious lag
like in the case of massively calling _AddLogChar

[revldo1]

bolts have bug bolts change to shield pleaase fix fast and how i can change normal set to sun

[Laag#82]

System bad

Trigger = Bug _char

[nour_eldin]

Thanks

[Donjiwan]

thank you
but i have a problem
its work but when the char get lvl 13++ stuck no cant use return.rev cant move any help