|
You last visited: Today at 11:10
Advertisement
[VSRO188] Reworked Auto-Equipment [QUERIES]
Discussion on [VSRO188] Reworked Auto-Equipment [QUERIES] within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
08/13/2017, 23:25
|
#16
|
elite*gold: 70 
Join Date: Apr 2017
Posts: 1,024
Received Thanks: 511
|
that system work?
|
|
|
|
08/14/2017, 17:27
|
#17
|
elite*gold: 0
Join Date: Aug 2017
Posts: 53
Received Thanks: 11
|
Good query , but does it give a bug ? because I've used quieres before for the auto equip and it sometimes bugs the char , it gives DC's , or unable to move bug , i hope these works .
|
|
|
|
|
08/15/2017, 00:31
|
#18
|
elite*gold: 0
Join Date: Mar 2009
Posts: 102
Received Thanks: 14
|
Quote:
Originally Posted by EpicKyrex
Good query , but does it give a bug ? because I've used quieres before for the auto equip and it sometimes bugs the char , it gives DC's , or unable to move bug , i hope these works .
|
for me it work but with unable to move bug 
|
|
|
|
|
08/15/2017, 03:17
|
#19
|
elite*gold: 737
Join Date: Oct 2007
Posts: 730
Received Thanks: 133
|
Back to the drawing board ?
|
|
|
|
|
12/09/2017, 17:43
|
#20
|
elite*gold: 0
Join Date: Feb 2014
Posts: 1,862
Received Thanks: 517
|
working good but after i add 10 dg wep on a char .. ater teleport it change back to 9 dg on the item that give u AQ .
any fix?
|
|
|
|
|
12/10/2017, 14:08
|
#21
|
elite*gold: 0
Join Date: Nov 2016
Posts: 454
Received Thanks: 121
|
Quote:
Originally Posted by Dracula Untold
working good but after i add 10 dg wep on a char .. ater teleport it change back to 9 dg on the item that give u AQ .
any fix?
|
change the type in trigger like IF @Newlvl >= 90 and @Newlvl <= 99
BEGIN
set @item_level = '09' --DG
set @degree = '_C'
end
|
|
|
|
|
12/10/2017, 23:20
|
#22
|
elite*gold: 0
Join Date: Feb 2014
Posts: 885
Received Thanks: 1,419
|
a trigger on _Char table updates? 
|
|
|
|
|
02/22/2018, 17:54
|
#23
|
elite*gold: 0
Join Date: Jan 2018
Posts: 103
Received Thanks: 71
|
works 100% Thanks
|
|
|
|
|
02/23/2018, 01:25
|
#24
|
elite*gold: 0
Join Date: Nov 2014
Posts: 106
Received Thanks: 22
|
need make items to dg 11
|
|
|
|
|
03/10/2018, 19:44
|
#25
|
elite*gold: 0
Join Date: Feb 2018
Posts: 14
Received Thanks: 0
|
This system working please ?
thanks its work
how to work trigger to set dg11 pls
|
|
|
|
|
03/12/2018, 02:51
|
#26
|
elite*gold: 85
Join Date: Feb 2014
Posts: 1,056
Received Thanks: 1,643
|
I don't understand you people. Why are you re-creating autoequipment in 2018?
There are at least 10 different released queries for it. Including mine which is a lot shorter & faster than this.
|
|
|
|
|
03/12/2018, 23:21
|
#27
|
elite*gold: 0
Join Date: Feb 2018
Posts: 14
Received Thanks: 0
|
How to get it queries bro 
|
|
|
|
|
11/21/2018, 16:59
|
#28
|
elite*gold: 0
Join Date: Nov 2018
Posts: 6
Received Thanks: 0
|
Quote:
Originally Posted by legendworld
change the type in trigger like IF @Newlvl >= 90 and @Newlvl <= 99
BEGIN
set @item_level = '09' --DG
set @degree = '_C'
end
|
hi.i cant find trigger dbo i sql.can you help me?
Quote:
Originally Posted by legendworld
change the type in trigger like IF @Newlvl >= 90 and @Newlvl <= 99
BEGIN
set @item_level = '09' --DG
set @degree = '_C'
end
|
hi.can you help me?i cant find TRIGGER [dbo].[TR_AUTOEQUIP_DEPIEDRA]
for make some changes
Quote:
Originally Posted by 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:
Code:
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).
Code:
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:
Code:
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.
Code:
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. |
how i can change trigger need change _C to C_RARE
|
|
|
|
|
03/10/2019, 22:03
|
#29
|
elite*gold: 0
Join Date: Mar 2019
Posts: 3
Received Thanks: 0
|
thanks for file
|
|
|
|
|
03/26/2019, 16:34
|
#30
|
elite*gold: 0
Join Date: Aug 2015
Posts: 67
Received Thanks: 13
|
Is there a video tutorial to make it easier please?
|
|
|
|
 |
|
Similar Threads
|
[VSRO188] (Job)Coin/Gift reward system [QUERIES]
04/08/2017 - SRO PServer Guides & Releases - 13 Replies
Hi guys, I've been working on this for a while. This system currently rewards players on unique kills, converts job contribution into coins/giftsilk, on completion of certain quests.
To use the reward on unique kill, I personally use Evangelion gameserver (Thanks cherno) as it records unique kills to a table in SRO_VT_ACCOUNT. So I based my procedures/triggers on Evangelion. Downloads links will be provided on the bottom of the post.
Requirements:
- If you want to use (MY) unique...
|
Maul-Online D11 / Auto System / Auto Equipment / Uniuqe Rank / Auto Event Fun
01/26/2015 - SRO PServer Advertising - 5 Replies
Welcome to Maul-Online official thread!
I'm proud to finally present to you the server we spent long time
working hard on just to keep it well-established
Maul-Online online is based on Vsro files
Server Will lunched 22/01/2015
Server : Online
We Are Here To Represent To You A Server Which Is The Best Old School Server
With The Old iSro Features .
|
Maul-Online D11 / Auto System / Auto Equipment / Uniuqe Rank / Auto Event Fun
01/25/2015 - SRO PServer Advertising - 51 Replies
http://i.epvpimg.com/pcfKe.jpg
Welcome to Maul-Online official
I'm proud to finally present to you the server we spent long time thread!
working hard on just to keep it well-established
Online-Online online is based on Vsro files
Server is lunched 22/01/2015
Server time : Online
http://i.epvpimg.com/V53Ge.png
|
All times are GMT +1. The time now is 11:10.
|
|
![[VSRO188] Reworked Auto-Equipment [QUERIES]](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/vsro188-reworked-auto-equipment-queries_ltr.gif){kind=small}
