قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
• الـهـوايـة » Private server developing and designing [ 2D -3D - Pk2 ]
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 89
3271
[Release]Model Switchers Vsro
أهلا بأعضاء Silkroad4arab
النهاردة جايبلكم سيستم مشهور جدا .. بس بعض الناس بتدور عليه
لانه تقريبا مش موجود على النت او مش كامل ومش عارف على الموقع هنا ولا لا
وللناس اللى متعرفش ايه هو السيستم ده .. ده عباره عن Scrolls هتغير شكل ال Weapon بتاع ال Char
لشكل Weapon تانى بنفس ال States وال Blues بال Degree اللى يحدده اللاعب
Database Side
Procedure
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_ModelSwitcher] Script Date: 3/31/2016 7:36:27 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_ModelSwitcher]
@CharID int,
@ItemRefID int
AS
DECLARE @ItemID int
,@RefItemID int
,@DG int
,@NoItem int
,@Color varchar(50)
,@GEN varchar(50)
,@RARET VARCHAR(50)
,@T1 tinyint
,@T2 tinyint
,@T3 tinyint
,@T4 tinyint
SELECT @DG = CASE WHEN @ItemRefID = '63630' THEN '1'
WHEN @ItemRefID = '63631' THEN '2'
WHEN @ItemRefID = '63632' THEN '3'
WHEN @ItemRefID = '63633' THEN '4'
WHEN @ItemRefID = '63634' THEN '5'
WHEN @ItemRefID = '63635' THEN '6'
WHEN @ItemRefID = '63636' THEN '7'
WHEN @ItemRefID = '63637' THEN '8'
WHEN @ItemRefID = '63638' THEN '9'
WHEN @ItemRefID = '63639' THEN '10'
WHEN @ItemRefID = '63640' THEN '11'
WHEN @ItemRefID = '63641' THEN '12'
ELSE NULL END
SELECT @ItemID=I.ID64 , @RefItemID = I.RefItemID
FROM SRO_VT_SHARD.dbo._Items I INNER JOIN SRO_Vt_SHARD.dbo._Inventory Iv
ON I.ID64 = Iv.ItemID
WHERE Iv.Slot = '13' AND Iv.CharID = @CharID
-- First item
SELECT @T1 = TypeID1 , @T2 = TypeID2 , @T3 = TypeID3 , @T4 = TypeID4 ,@Color = Color , @GEN = Gender , @RareT = RareT
FROM SRO_VT_SHARDLOG.dbo._ModelSwitchers WHERE ID = @RefItemID
-- Second item
SELECT TOP 1 @NoItem = ID FROM SRO_VT_SHARDLOG.dbo._ModelSwitchers
WHERE TypeID1 = @T1
AND TypeID2 = @T2
AND TypeID3 = @T3
AND TypeID4 = @T4
AND Color = @Color
AND DG = @DG
AND Gender = @GEN
AND RareT = @RareT
-- Upcating
UPDATE SRO_VT_SHARD.dbo._Items SET RefItemID = @NoItem WHERE ID64 = @ItemID
وهتضيف دول فى AddLogItem_
كود PHP:
/*Mod Switcher*/
IF @ItemRefID BETWEEN '63630' and '63641' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ModelSwitcher @CharId, @ItemRefID
END
Create Table
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_ModelSwitchers] Script Date: 4/1/2016 3:13:24 AM ******/
SET ANSI_NULLS ON
GO
هتضيف فى ال Table ال Items اللى عايز يتعملها السيستم ده ..
انا هديلكوا مثال على ال D10 واى Degree تانى بنفس الطريقة بس اتأكد انك حاطط كل حاجة صح
كود PHP:
98 ITEM_CH_SWORD_10_A 3 1 6 2 NORMAL A_TYPE 10 USELSS
99 ITEM_CH_SWORD_10_B 3 1 6 2 NORMAL B_TYPE 10 USELSS
100 ITEM_CH_SWORD_10_C 3 1 6 2 NORMAL C_TYPE 10 USELSS
134 ITEM_CH_BLADE_10_A 3 1 6 3 NORMAL A_TYPE 10 USELSS
135 ITEM_CH_BLADE_10_B 3 1 6 3 NORMAL B_TYPE 10 USELSS
136 ITEM_CH_BLADE_10_C 3 1 6 3 NORMAL C_TYPE 10 USELSS
170 ITEM_CH_SPEAR_10_A 3 1 6 4 NORMAL A_TYPE 10 USELSS
171 ITEM_CH_SPEAR_10_B 3 1 6 4 NORMAL B_TYPE 10 USELSS
172 ITEM_CH_SPEAR_10_C 3 1 6 4 NORMAL C_TYPE 10 USELSS
206 ITEM_CH_TBLADE_10_A 3 1 6 5 NORMAL A_TYPE 10 USELSS
207 ITEM_CH_TBLADE_10_B 3 1 6 5 NORMAL B_TYPE 10 USELSS
208 ITEM_CH_TBLADE_10_C 3 1 6 5 NORMAL C_TYPE 10 USELSS
242 ITEM_CH_BOW_10_A 3 1 6 6 NORMAL A_TYPE 10 USELSS
243 ITEM_CH_BOW_10_B 3 1 6 6 NORMAL B_TYPE 10 USELSS
244 ITEM_CH_BOW_10_C 3 1 6 6 NORMAL C_TYPE 10 USELSS
278 ITEM_CH_SHIELD_10_A 3 1 4 1 NORMAL A_TYPE 10 USELSS
279 ITEM_CH_SHIELD_10_B 3 1 4 1 NORMAL B_TYPE 10 USELSS
280 ITEM_CH_SHIELD_10_C 3 1 4 1 NORMAL C_TYPE 10 USELSS
314 ITEM_CH_M_HEAVY_10_HA_A 3 1 3 1 NORMAL A_TYPE 10 M
315 ITEM_CH_M_HEAVY_10_HA_B 3 1 3 1 NORMAL B_TYPE 10 M
316 ITEM_CH_M_HEAVY_10_HA_C 3 1 3 1 NORMAL C_TYPE 10 M
350 ITEM_CH_M_HEAVY_10_CA_A 3 1 3 1 NORMAL A_TYPE 10 M
351 ITEM_CH_M_HEAVY_10_CA_B 3 1 3 1 NORMAL B_TYPE 10 M
352 ITEM_CH_M_HEAVY_10_CA_C 3 1 3 1 NORMAL C_TYPE 10 M
386 ITEM_CH_M_HEAVY_10_SA_A 3 1 3 2 NORMAL A_TYPE 10 M
387 ITEM_CH_M_HEAVY_10_SA_B 3 1 3 2 NORMAL B_TYPE 10 M
388 ITEM_CH_M_HEAVY_10_SA_C 3 1 3 2 NORMAL C_TYPE 10 M
422 ITEM_CH_M_HEAVY_10_BA_A 3 1 3 3 NORMAL A_TYPE 10 M
423 ITEM_CH_M_HEAVY_10_BA_B 3 1 3 3 NORMAL B_TYPE 10 M
424 ITEM_CH_M_HEAVY_10_BA_C 3 1 3 3 NORMAL C_TYPE 10 M
458 ITEM_CH_M_HEAVY_10_LA_A 3 1 3 4 NORMAL A_TYPE 10 M
459 ITEM_CH_M_HEAVY_10_LA_B 3 1 3 4 NORMAL B_TYPE 10 M
460 ITEM_CH_M_HEAVY_10_LA_C 3 1 3 4 NORMAL C_TYPE 10 M
494 ITEM_CH_M_HEAVY_10_AA_A 3 1 3 5 NORMAL A_TYPE 10 M
495 ITEM_CH_M_HEAVY_10_AA_B 3 1 3 5 NORMAL B_TYPE 10 M
496 ITEM_CH_M_HEAVY_10_AA_C 3 1 3 5 NORMAL C_TYPE 10 M
530 ITEM_CH_M_HEAVY_10_FA_A 3 1 3 6 NORMAL A_TYPE 10 M
531 ITEM_CH_M_HEAVY_10_FA_B 3 1 3 6 NORMAL B_TYPE 10 M
532 ITEM_CH_M_HEAVY_10_FA_C 3 1 3 6 NORMAL C_TYPE 10 M
566 ITEM_CH_M_LIGHT_10_HA_A 3 1 2 1 NORMAL A_TYPE 10 M
567 ITEM_CH_M_LIGHT_10_HA_B 3 1 2 1 NORMAL B_TYPE 10 M
568 ITEM_CH_M_LIGHT_10_HA_C 3 1 2 1 NORMAL C_TYPE 10 M
602 ITEM_CH_M_LIGHT_10_CA_A 3 1 2 1 NORMAL A_TYPE 10 M
603 ITEM_CH_M_LIGHT_10_CA_B 3 1 2 1 NORMAL B_TYPE 10 M
604 ITEM_CH_M_LIGHT_10_CA_C 3 1 2 1 NORMAL C_TYPE 10 M
638 ITEM_CH_M_LIGHT_10_SA_A 3 1 2 2 NORMAL A_TYPE 10 M
639 ITEM_CH_M_LIGHT_10_SA_B 3 1 2 2 NORMAL B_TYPE 10 M
640 ITEM_CH_M_LIGHT_10_SA_C 3 1 2 2 NORMAL C_TYPE 10 M
674 ITEM_CH_M_LIGHT_10_BA_A 3 1 2 3 NORMAL A_TYPE 10 M
675 ITEM_CH_M_LIGHT_10_BA_B 3 1 2 3 NORMAL B_TYPE 10 M
676 ITEM_CH_M_LIGHT_10_BA_C 3 1 2 3 NORMAL C_TYPE 10 M
710 ITEM_CH_M_LIGHT_10_LA_A 3 1 2 4 NORMAL A_TYPE 10 M
711 ITEM_CH_M_LIGHT_10_LA_B 3 1 2 4 NORMAL B_TYPE 10 M
712 ITEM_CH_M_LIGHT_10_LA_C 3 1 2 4 NORMAL C_TYPE 10 M
746 ITEM_CH_M_LIGHT_10_AA_A 3 1 2 5 NORMAL A_TYPE 10 M
747 ITEM_CH_M_LIGHT_10_AA_B 3 1 2 5 NORMAL B_TYPE 10 M
748 ITEM_CH_M_LIGHT_10_AA_C 3 1 2 5 NORMAL C_TYPE 10 M
782 ITEM_CH_M_LIGHT_10_FA_A 3 1 2 6 NORMAL A_TYPE 10 M
783 ITEM_CH_M_LIGHT_10_FA_B 3 1 2 6 NORMAL B_TYPE 10 M
784 ITEM_CH_M_LIGHT_10_FA_C 3 1 2 6 NORMAL C_TYPE 10 M
818 ITEM_CH_M_CLOTHES_10_HA_A 3 1 1 1 NORMAL A_TYPE 10 M
819 ITEM_CH_M_CLOTHES_10_HA_B 3 1 1 1 NORMAL B_TYPE 10 M
820 ITEM_CH_M_CLOTHES_10_HA_C 3 1 1 1 NORMAL C_TYPE 10 M
854 ITEM_CH_M_CLOTHES_10_CA_A 3 1 1 1 NORMAL A_TYPE 10 M
855 ITEM_CH_M_CLOTHES_10_CA_B 3 1 1 1 NORMAL B_TYPE 10 M
856 ITEM_CH_M_CLOTHES_10_CA_C 3 1 1 1 NORMAL C_TYPE 10 M
890 ITEM_CH_M_CLOTHES_10_SA_A 3 1 1 2 NORMAL A_TYPE 10 M
891 ITEM_CH_M_CLOTHES_10_SA_B 3 1 1 2 NORMAL B_TYPE 10 M
892 ITEM_CH_M_CLOTHES_10_SA_C 3 1 1 2 NORMAL C_TYPE 10 M
926 ITEM_CH_M_CLOTHES_10_BA_A 3 1 1 3 NORMAL A_TYPE 10 M
927 ITEM_CH_M_CLOTHES_10_BA_B 3 1 1 3 NORMAL B_TYPE 10 M
928 ITEM_CH_M_CLOTHES_10_BA_C 3 1 1 3 NORMAL C_TYPE 10 M
962 ITEM_CH_M_CLOTHES_10_LA_A 3 1 1 4 NORMAL A_TYPE 10 M
963 ITEM_CH_M_CLOTHES_10_LA_B 3 1 1 4 NORMAL B_TYPE 10 M
964 ITEM_CH_M_CLOTHES_10_LA_C 3 1 1 4 NORMAL C_TYPE 10 M
998 ITEM_CH_M_CLOTHES_10_AA_A 3 1 1 5 NORMAL A_TYPE 10 M
999 ITEM_CH_M_CLOTHES_10_AA_B 3 1 1 5 NORMAL B_TYPE 10 M
1000 ITEM_CH_M_CLOTHES_10_AA_C 3 1 1 5 NORMAL C_TYPE 10 M
1034 ITEM_CH_M_CLOTHES_10_FA_A 3 1 1 6 NORMAL A_TYPE 10 M
1035 ITEM_CH_M_CLOTHES_10_FA_B 3 1 1 6 NORMAL B_TYPE 10 M
1036 ITEM_CH_M_CLOTHES_10_FA_C 3 1 1 6 NORMAL C_TYPE 10 M
1070 ITEM_CH_W_HEAVY_10_HA_A 3 1 3 1 NORMAL A_TYPE 10 W
1071 ITEM_CH_W_HEAVY_10_HA_B 3 1 3 1 NORMAL B_TYPE 10 W
1072 ITEM_CH_W_HEAVY_10_HA_C 3 1 3 1 NORMAL C_TYPE 10 W
1106 ITEM_CH_W_HEAVY_10_CA_A 3 1 3 1 NORMAL A_TYPE 10 W
1107 ITEM_CH_W_HEAVY_10_CA_B 3 1 3 1 NORMAL B_TYPE 10 W
1108 ITEM_CH_W_HEAVY_10_CA_C 3 1 3 1 NORMAL C_TYPE 10 W
1142 ITEM_CH_W_HEAVY_10_SA_A 3 1 3 2 NORMAL A_TYPE 10 W
1143 ITEM_CH_W_HEAVY_10_SA_B 3 1 3 2 NORMAL B_TYPE 10 W
1144 ITEM_CH_W_HEAVY_10_SA_C 3 1 3 2 NORMAL C_TYPE 10 W
1178 ITEM_CH_W_HEAVY_10_BA_A 3 1 3 3 NORMAL A_TYPE 10 W
1179 ITEM_CH_W_HEAVY_10_BA_B 3 1 3 3 NORMAL B_TYPE 10 W
1180 ITEM_CH_W_HEAVY_10_BA_C 3 1 3 3 NORMAL C_TYPE 10 W
1214 ITEM_CH_W_HEAVY_10_LA_A 3 1 3 4 NORMAL A_TYPE 10 W
1215 ITEM_CH_W_HEAVY_10_LA_B 3 1 3 4 NORMAL B_TYPE 10 W
1216 ITEM_CH_W_HEAVY_10_LA_C 3 1 3 4 NORMAL C_TYPE 10 W
1250 ITEM_CH_W_HEAVY_10_AA_A 3 1 3 5 NORMAL A_TYPE 10 W
1251 ITEM_CH_W_HEAVY_10_AA_B 3 1 3 5 NORMAL B_TYPE 10 W
1252 ITEM_CH_W_HEAVY_10_AA_C 3 1 3 5 NORMAL C_TYPE 10 W
1286 ITEM_CH_W_HEAVY_10_FA_A 3 1 3 6 NORMAL A_TYPE 10 W
1287 ITEM_CH_W_HEAVY_10_FA_B 3 1 3 6 NORMAL B_TYPE 10 W
1288 ITEM_CH_W_HEAVY_10_FA_C 3 1 3 6 NORMAL C_TYPE 10 W
1322 ITEM_CH_W_LIGHT_10_HA_A 3 1 2 1 NORMAL A_TYPE 10 W
1323 ITEM_CH_W_LIGHT_10_HA_B 3 1 2 1 NORMAL B_TYPE 10 W
1324 ITEM_CH_W_LIGHT_10_HA_C 3 1 2 1 NORMAL C_TYPE 10 W
1358 ITEM_CH_W_LIGHT_10_CA_A 3 1 2 1 NORMAL A_TYPE 10 W
1359 ITEM_CH_W_LIGHT_10_CA_B 3 1 2 1 NORMAL B_TYPE 10 W
1360 ITEM_CH_W_LIGHT_10_CA_C 3 1 2 1 NORMAL C_TYPE 10 W
1394 ITEM_CH_W_LIGHT_10_SA_A 3 1 2 2 NORMAL A_TYPE 10 W
1395 ITEM_CH_W_LIGHT_10_SA_B 3 1 2 2 NORMAL B_TYPE 10 W
1396 ITEM_CH_W_LIGHT_10_SA_C 3 1 2 2 NORMAL C_TYPE 10 W
1430 ITEM_CH_W_LIGHT_10_BA_A 3 1 2 3 NORMAL A_TYPE 10 W
1431 ITEM_CH_W_LIGHT_10_BA_B 3 1 2 3 NORMAL B_TYPE 10 W
1432 ITEM_CH_W_LIGHT_10_BA_C 3 1 2 3 NORMAL C_TYPE 10 W
1466 ITEM_CH_W_LIGHT_10_LA_A 3 1 2 4 NORMAL A_TYPE 10 W
1467 ITEM_CH_W_LIGHT_10_LA_B 3 1 2 4 NORMAL B_TYPE 10 W
1468 ITEM_CH_W_LIGHT_10_LA_C 3 1 2 4 NORMAL C_TYPE 10 W
1502 ITEM_CH_W_LIGHT_10_AA_A 3 1 2 5 NORMAL A_TYPE 10 W
1503 ITEM_CH_W_LIGHT_10_AA_B 3 1 2 5 NORMAL B_TYPE 10 W
1504 ITEM_CH_W_LIGHT_10_AA_C 3 1 2 5 NORMAL C_TYPE 10 W
1538 ITEM_CH_W_LIGHT_10_FA_A 3 1 2 6 NORMAL A_TYPE 10 W
1539 ITEM_CH_W_LIGHT_10_FA_B 3 1 2 6 NORMAL B_TYPE 10 W
1540 ITEM_CH_W_LIGHT_10_FA_C 3 1 2 6 NORMAL C_TYPE 10 W
1574 ITEM_CH_W_CLOTHES_10_HA_A 3 1 1 1 NORMAL A_TYPE 10 W
1575 ITEM_CH_W_CLOTHES_10_HA_B 3 1 1 1 NORMAL B_TYPE 10 W
1576 ITEM_CH_W_CLOTHES_10_HA_C 3 1 1 1 NORMAL C_TYPE 10 W
1610 ITEM_CH_W_CLOTHES_10_CA_A 3 1 1 1 NORMAL A_TYPE 10 W
1611 ITEM_CH_W_CLOTHES_10_CA_B 3 1 1 1 NORMAL B_TYPE 10 W
1612 ITEM_CH_W_CLOTHES_10_CA_C 3 1 1 1 NORMAL C_TYPE 10 W
1646 ITEM_CH_W_CLOTHES_10_SA_A 3 1 1 2 NORMAL A_TYPE 10 W
1647 ITEM_CH_W_CLOTHES_10_SA_B 3 1 1 2 NORMAL B_TYPE 10 W
1648 ITEM_CH_W_CLOTHES_10_SA_C 3 1 1 2 NORMAL C_TYPE 10 W
1682 ITEM_CH_W_CLOTHES_10_BA_A 3 1 1 3 NORMAL A_TYPE 10 W
1683 ITEM_CH_W_CLOTHES_10_BA_B 3 1 1 3 NORMAL B_TYPE 10 W
1684 ITEM_CH_W_CLOTHES_10_BA_C 3 1 1 3 NORMAL C_TYPE 10 W
1718 ITEM_CH_W_CLOTHES_10_LA_A 3 1 1 4 NORMAL A_TYPE 10 W
1719 ITEM_CH_W_CLOTHES_10_LA_B 3 1 1 4 NORMAL B_TYPE 10 W
1720 ITEM_CH_W_CLOTHES_10_LA_C 3 1 1 4 NORMAL C_TYPE 10 W
1754 ITEM_CH_W_CLOTHES_10_AA_A 3 1 1 5 NORMAL A_TYPE 10 W
1755 ITEM_CH_W_CLOTHES_10_AA_B 3 1 1 5 NORMAL B_TYPE 10 W
1756 ITEM_CH_W_CLOTHES_10_AA_C 3 1 1 5 NORMAL C_TYPE 10 W
1790 ITEM_CH_W_CLOTHES_10_FA_A 3 1 1 6 NORMAL A_TYPE 10 W
1791 ITEM_CH_W_CLOTHES_10_FA_B 3 1 1 6 NORMAL B_TYPE 10 W
1792 ITEM_CH_W_CLOTHES_10_FA_C 3 1 1 6 NORMAL C_TYPE 10 W
1826 ITEM_CH_RING_10_A 3 1 5 3 NORMAL A_TYPE 10 USELSS
1827 ITEM_CH_RING_10_B 3 1 5 3 NORMAL B_TYPE 10 USELSS
1828 ITEM_CH_RING_10_C 3 1 5 3 NORMAL C_TYPE 10 USELSS
1862 ITEM_CH_EARRING_10_A 3 1 5 1 NORMAL A_TYPE 10 USELSS
1863 ITEM_CH_EARRING_10_B 3 1 5 1 NORMAL B_TYPE 10 USELSS
1864 ITEM_CH_EARRING_10_C 3 1 5 1 NORMAL C_TYPE 10 USELSS
1898 ITEM_CH_NECKLACE_10_A 3 1 5 2 NORMAL A_TYPE 10 USELSS
1899 ITEM_CH_NECKLACE_10_B 3 1 5 2 NORMAL B_TYPE 10 USELSS
1900 ITEM_CH_NECKLACE_10_C 3 1 5 2 NORMAL C_TYPE 10 USELSS
4041 ITEM_CH_SWORD_10_A_RARE 3 1 6 2 NORMAL SOS 10 USELSS
4042 ITEM_CH_SWORD_10_B_RARE 3 1 6 2 NORMAL SOM 10 USELSS
4043 ITEM_CH_SWORD_10_C_RARE 3 1 6 2 NORMAL SUN 10 USELSS
4077 ITEM_CH_BLADE_10_A_RARE 3 1 6 3 NORMAL SOS 10 USELSS
4078 ITEM_CH_BLADE_10_B_RARE 3 1 6 3 NORMAL SOM 10 USELSS
4079 ITEM_CH_BLADE_10_C_RARE 3 1 6 3 NORMAL SUN 10 USELSS
4113 ITEM_CH_SPEAR_10_A_RARE 3 1 6 4 NORMAL SOS 10 USELSS
4114 ITEM_CH_SPEAR_10_B_RARE 3 1 6 4 NORMAL SOM 10 USELSS
4115 ITEM_CH_SPEAR_10_C_RARE 3 1 6 4 NORMAL SUN 10 USELSS
4149 ITEM_CH_TBLADE_10_A_RARE 3 1 6 5 NORMAL SOS 10 USELSS
4150 ITEM_CH_TBLADE_10_B_RARE 3 1 6 5 NORMAL SOM 10 USELSS
4151 ITEM_CH_TBLADE_10_C_RARE 3 1 6 5 NORMAL SUN 10 USELSS
4185 ITEM_CH_BOW_10_A_RARE 3 1 6 6 NORMAL SOS 10 USELSS
4186 ITEM_CH_BOW_10_B_RARE 3 1 6 6 NORMAL SOM 10 USELSS
4187 ITEM_CH_BOW_10_C_RARE 3 1 6 6 NORMAL SUN 10 USELSS
4221 ITEM_CH_SHIELD_10_A_RARE 3 1 4 1 NORMAL SOS 10 USELSS
4222 ITEM_CH_SHIELD_10_B_RARE 3 1 4 1 NORMAL SOM 10 USELSS
4223 ITEM_CH_SHIELD_10_C_RARE 3 1 4 1 NORMAL SUN 10 USELSS
4257 ITEM_CH_M_HEAVY_10_HA_A_RARE 3 1 3 1 NORMAL SOS 10 M
4258 ITEM_CH_M_HEAVY_10_HA_B_RARE 3 1 3 1 NORMAL SOM 10 M
4259 ITEM_CH_M_HEAVY_10_HA_C_RARE 3 1 3 1 NORMAL SUN 10 M
4293 ITEM_CH_M_HEAVY_10_CA_A_RARE 3 1 3 1 NORMAL SOS 10 M
4294 ITEM_CH_M_HEAVY_10_CA_B_RARE 3 1 3 1 NORMAL SOM 10 M
4295 ITEM_CH_M_HEAVY_10_CA_C_RARE 3 1 3 1 NORMAL SUN 10 M
4329 ITEM_CH_M_HEAVY_10_SA_A_RARE 3 1 3 2 NORMAL SOS 10 M
4330 ITEM_CH_M_HEAVY_10_SA_B_RARE 3 1 3 2 NORMAL SOM 10 M
4331 ITEM_CH_M_HEAVY_10_SA_C_RARE 3 1 3 2 NORMAL SUN 10 M
4365 ITEM_CH_M_HEAVY_10_BA_A_RARE 3 1 3 3 NORMAL SOS 10 M
4366 ITEM_CH_M_HEAVY_10_BA_B_RARE 3 1 3 3 NORMAL SOM 10 M
4367 ITEM_CH_M_HEAVY_10_BA_C_RARE 3 1 3 3 NORMAL SUN 10 M
4401 ITEM_CH_M_HEAVY_10_LA_A_RARE 3 1 3 4 NORMAL SOS 10 M
4402 ITEM_CH_M_HEAVY_10_LA_B_RARE 3 1 3 4 NORMAL SOM 10 M
4403 ITEM_CH_M_HEAVY_10_LA_C_RARE 3 1 3 4 NORMAL SUN 10 M
4437 ITEM_CH_M_HEAVY_10_AA_A_RARE 3 1 3 5 NORMAL SOS 10 M
4438 ITEM_CH_M_HEAVY_10_AA_B_RARE 3 1 3 5 NORMAL SOM 10 M
4439 ITEM_CH_M_HEAVY_10_AA_C_RARE 3 1 3 5 NORMAL SUN 10 M
4473 ITEM_CH_M_HEAVY_10_FA_A_RARE 3 1 3 6 NORMAL SOS 10 M
4474 ITEM_CH_M_HEAVY_10_FA_B_RARE 3 1 3 6 NORMAL SOM 10 M
4475 ITEM_CH_M_HEAVY_10_FA_C_RARE 3 1 3 6 NORMAL SUN 10 M
4509 ITEM_CH_M_LIGHT_10_HA_A_RARE 3 1 2 1 NORMAL SOS 10 M
4510 ITEM_CH_M_LIGHT_10_HA_B_RARE 3 1 2 1 NORMAL SOM 10 M
4511 ITEM_CH_M_LIGHT_10_HA_C_RARE 3 1 2 1 NORMAL SUN 10 M
4545 ITEM_CH_M_LIGHT_10_CA_A_RARE 3 1 2 1 NORMAL SOS 10 M
4546 ITEM_CH_M_LIGHT_10_CA_B_RARE 3 1 2 1 NORMAL SOM 10 M
4547 ITEM_CH_M_LIGHT_10_CA_C_RARE 3 1 2 1 NORMAL SUN 10 M
4581 ITEM_CH_M_LIGHT_10_SA_A_RARE 3 1 2 2 NORMAL SOS 10 M
4582 ITEM_CH_M_LIGHT_10_SA_B_RARE 3 1 2 2 NORMAL SOM 10 M
4583 ITEM_CH_M_LIGHT_10_SA_C_RARE 3 1 2 2 NORMAL SUN 10 M
4617 ITEM_CH_M_LIGHT_10_BA_A_RARE 3 1 2 3 NORMAL SOS 10 M
4618 ITEM_CH_M_LIGHT_10_BA_B_RARE 3 1 2 3 NORMAL SOM 10 M
4619 ITEM_CH_M_LIGHT_10_BA_C_RARE 3 1 2 3 NORMAL SUN 10 M
4653 ITEM_CH_M_LIGHT_10_LA_A_RARE 3 1 2 4 NORMAL SOS 10 M
4654 ITEM_CH_M_LIGHT_10_LA_B_RARE 3 1 2 4 NORMAL SOM 10 M
4655 ITEM_CH_M_LIGHT_10_LA_C_RARE 3 1 2 4 NORMAL SUN 10 M
4689 ITEM_CH_M_LIGHT_10_AA_A_RARE 3 1 2 5 NORMAL SOS 10 M
4690 ITEM_CH_M_LIGHT_10_AA_B_RARE 3 1 2 5 NORMAL SOM 10 M
4691 ITEM_CH_M_LIGHT_10_AA_C_RARE 3 1 2 5 NORMAL SUN 10 M
4725 ITEM_CH_M_LIGHT_10_FA_A_RARE 3 1 2 6 NORMAL SOS 10 M
4726 ITEM_CH_M_LIGHT_10_FA_B_RARE 3 1 2 6 NORMAL SOM 10 M
4727 ITEM_CH_M_LIGHT_10_FA_C_RARE 3 1 2 6 NORMAL SUN 10 M
4761 ITEM_CH_M_CLOTHES_10_HA_A_RARE 3 1 1 1 NORMAL SOS 10 M
4762 ITEM_CH_M_CLOTHES_10_HA_B_RARE 3 1 1 1 NORMAL SOM 10 M
4763 ITEM_CH_M_CLOTHES_10_HA_C_RARE 3 1 1 1 NORMAL SUN 10 M
4797 ITEM_CH_M_CLOTHES_10_CA_A_RARE 3 1 1 1 NORMAL SOS 10 M
4798 ITEM_CH_M_CLOTHES_10_CA_B_RARE 3 1 1 1 NORMAL SOM 10 M
4799 ITEM_CH_M_CLOTHES_10_CA_C_RARE 3 1 1 1 NORMAL SUN 10 M
4833 ITEM_CH_M_CLOTHES_10_SA_A_RARE 3 1 1 2 NORMAL SOS 10 M
4834 ITEM_CH_M_CLOTHES_10_SA_B_RARE 3 1 1 2 NORMAL SOM 10 M
4835 ITEM_CH_M_CLOTHES_10_SA_C_RARE 3 1 1 2 NORMAL SUN 10 M
4869 ITEM_CH_M_CLOTHES_10_BA_A_RARE 3 1 1 3 NORMAL SOS 10 M
4870 ITEM_CH_M_CLOTHES_10_BA_B_RARE 3 1 1 3 NORMAL SOM 10 M
4871 ITEM_CH_M_CLOTHES_10_BA_C_RARE 3 1 1 3 NORMAL SUN 10 M
4905 ITEM_CH_M_CLOTHES_10_LA_A_RARE 3 1 1 4 NORMAL SOS 10 M
4906 ITEM_CH_M_CLOTHES_10_LA_B_RARE 3 1 1 4 NORMAL SOM 10 M
4907 ITEM_CH_M_CLOTHES_10_LA_C_RARE 3 1 1 4 NORMAL SUN 10 M
4941 ITEM_CH_M_CLOTHES_10_AA_A_RARE 3 1 1 5 NORMAL SOS 10 M
4942 ITEM_CH_M_CLOTHES_10_AA_B_RARE 3 1 1 5 NORMAL SOM 10 M
4943 ITEM_CH_M_CLOTHES_10_AA_C_RARE 3 1 1 5 NORMAL SUN 10 M
4977 ITEM_CH_M_CLOTHES_10_FA_A_RARE 3 1 1 6 NORMAL SOS 10 M
4978 ITEM_CH_M_CLOTHES_10_FA_B_RARE 3 1 1 6 NORMAL SOM 10 M
4979 ITEM_CH_M_CLOTHES_10_FA_C_RARE 3 1 1 6 NORMAL SUN 10 M
5013 ITEM_CH_W_HEAVY_10_HA_A_RARE 3 1 3 1 NORMAL SOS 10 W
5014 ITEM_CH_W_HEAVY_10_HA_B_RARE 3 1 3 1 NORMAL SOM 10 W
5015 ITEM_CH_W_HEAVY_10_HA_C_RARE 3 1 3 1 NORMAL SUN 10 W
5049 ITEM_CH_W_HEAVY_10_CA_A_RARE 3 1 3 1 NORMAL SOS 10 W
5050 ITEM_CH_W_HEAVY_10_CA_B_RARE 3 1 3 1 NORMAL SOM 10 W
5051 ITEM_CH_W_HEAVY_10_CA_C_RARE 3 1 3 1 NORMAL SUN 10 W
5085 ITEM_CH_W_HEAVY_10_SA_A_RARE 3 1 3 2 NORMAL SOS 10 W
5086 ITEM_CH_W_HEAVY_10_SA_B_RARE 3 1 3 2 NORMAL SOM 10 W
5087 ITEM_CH_W_HEAVY_10_SA_C_RARE 3 1 3 2 NORMAL SUN 10 W
5121 ITEM_CH_W_HEAVY_10_BA_A_RARE 3 1 3 3 NORMAL SOS 10 W
5122 ITEM_CH_W_HEAVY_10_BA_B_RARE 3 1 3 3 NORMAL SOM 10 W
5123 ITEM_CH_W_HEAVY_10_BA_C_RARE 3 1 3 3 NORMAL SUN 10 W
5157 ITEM_CH_W_HEAVY_10_LA_A_RARE 3 1 3 4 NORMAL SOS 10 W
5158 ITEM_CH_W_HEAVY_10_LA_B_RARE 3 1 3 4 NORMAL SOM 10 W
5159 ITEM_CH_W_HEAVY_10_LA_C_RARE 3 1 3 4 NORMAL SUN 10 W
5193 ITEM_CH_W_HEAVY_10_AA_A_RARE 3 1 3 5 NORMAL SOS 10 W
5194 ITEM_CH_W_HEAVY_10_AA_B_RARE 3 1 3 5 NORMAL SOM 10 W
5195 ITEM_CH_W_HEAVY_10_AA_C_RARE 3 1 3 5 NORMAL SUN 10 W
5229 ITEM_CH_W_HEAVY_10_FA_A_RARE 3 1 3 6 NORMAL SOS 10 W
5230 ITEM_CH_W_HEAVY_10_FA_B_RARE 3 1 3 6 NORMAL SOM 10 W
5231 ITEM_CH_W_HEAVY_10_FA_C_RARE 3 1 3 6 NORMAL SUN 10 W
5265 ITEM_CH_W_LIGHT_10_HA_A_RARE 3 1 2 1 NORMAL SOS 10 W
5266 ITEM_CH_W_LIGHT_10_HA_B_RARE 3 1 2 1 NORMAL SOM 10 W
5267 ITEM_CH_W_LIGHT_10_HA_C_RARE 3 1 2 1 NORMAL SUN 10 W
5301 ITEM_CH_W_LIGHT_10_CA_A_RARE 3 1 2 1 NORMAL SOS 10 W
5302 ITEM_CH_W_LIGHT_10_CA_B_RARE 3 1 2 1 NORMAL SOM 10 W
5303 ITEM_CH_W_LIGHT_10_CA_C_RARE 3 1 2 1 NORMAL SUN 10 W
5337 ITEM_CH_W_LIGHT_10_SA_A_RARE 3 1 2 2 NORMAL SOS 10 W
5338 ITEM_CH_W_LIGHT_10_SA_B_RARE 3 1 2 2 NORMAL SOM 10 W
5339 ITEM_CH_W_LIGHT_10_SA_C_RARE 3 1 2 2 NORMAL SUN 10 W
5373 ITEM_CH_W_LIGHT_10_BA_A_RARE 3 1 2 3 NORMAL SOS 10 W
5374 ITEM_CH_W_LIGHT_10_BA_B_RARE 3 1 2 3 NORMAL SOM 10 W
5375 ITEM_CH_W_LIGHT_10_BA_C_RARE 3 1 2 3 NORMAL SUN 10 W
5409 ITEM_CH_W_LIGHT_10_LA_A_RARE 3 1 2 4 NORMAL SOS 10 W
5410 ITEM_CH_W_LIGHT_10_LA_B_RARE 3 1 2 4 NORMAL SOM 10 W
5411 ITEM_CH_W_LIGHT_10_LA_C_RARE 3 1 2 4 NORMAL SUN 10 W
5445 ITEM_CH_W_LIGHT_10_AA_A_RARE 3 1 2 5 NORMAL SOS 10 W
5446 ITEM_CH_W_LIGHT_10_AA_B_RARE 3 1 2 5 NORMAL SOM 10 W
5447 ITEM_CH_W_LIGHT_10_AA_C_RARE 3 1 2 5 NORMAL SUN 10 W
5481 ITEM_CH_W_LIGHT_10_FA_A_RARE 3 1 2 6 NORMAL SOS 10 W
5482 ITEM_CH_W_LIGHT_10_FA_B_RARE 3 1 2 6 NORMAL SOM 10 W
5483 ITEM_CH_W_LIGHT_10_FA_C_RARE 3 1 2 6 NORMAL SUN 10 W
5517 ITEM_CH_W_CLOTHES_10_HA_A_RARE 3 1 1 1 NORMAL SOS 10 W
5518 ITEM_CH_W_CLOTHES_10_HA_B_RARE 3 1 1 1 NORMAL SOM 10 W
5519 ITEM_CH_W_CLOTHES_10_HA_C_RARE 3 1 1 1 NORMAL SUN 10 W
5553 ITEM_CH_W_CLOTHES_10_CA_A_RARE 3 1 1 1 NORMAL SOS 10 W
5554 ITEM_CH_W_CLOTHES_10_CA_B_RARE 3 1 1 1 NORMAL SOM 10 W
5555 ITEM_CH_W_CLOTHES_10_CA_C_RARE 3 1 1 1 NORMAL SUN 10 W
5589 ITEM_CH_W_CLOTHES_10_SA_A_RARE 3 1 1 2 NORMAL SOS 10 W
5590 ITEM_CH_W_CLOTHES_10_SA_B_RARE 3 1 1 2 NORMAL SOM 10 W
5591 ITEM_CH_W_CLOTHES_10_SA_C_RARE 3 1 1 2 NORMAL SUN 10 W
5625 ITEM_CH_W_CLOTHES_10_BA_A_RARE 3 1 1 3 NORMAL SOS 10 W
5626 ITEM_CH_W_CLOTHES_10_BA_B_RARE 3 1 1 3 NORMAL SOM 10 W
5627 ITEM_CH_W_CLOTHES_10_BA_C_RARE 3 1 1 3 NORMAL SUN 10 W
5661 ITEM_CH_W_CLOTHES_10_LA_A_RARE 3 1 1 4 NORMAL SOS 10 W
5662 ITEM_CH_W_CLOTHES_10_LA_B_RARE 3 1 1 4 NORMAL SOM 10 W
5663 ITEM_CH_W_CLOTHES_10_LA_C_RARE 3 1 1 4 NORMAL SUN 10 W
5697 ITEM_CH_W_CLOTHES_10_AA_A_RARE 3 1 1 5 NORMAL SOS 10 W
5698 ITEM_CH_W_CLOTHES_10_AA_B_RARE 3 1 1 5 NORMAL SOM 10 W
5699 ITEM_CH_W_CLOTHES_10_AA_C_RARE 3 1 1 5 NORMAL SUN 10 W
5733 ITEM_CH_W_CLOTHES_10_FA_A_RARE 3 1 1 6 NORMAL SOS 10 W
5734 ITEM_CH_W_CLOTHES_10_FA_B_RARE 3 1 1 6 NORMAL SOM 10 W
5735 ITEM_CH_W_CLOTHES_10_FA_C_RARE 3 1 1 6 NORMAL SUN 10 W
5769 ITEM_CH_RING_10_A_RARE 3 1 5 3 NORMAL SOS 10 USELSS
5770 ITEM_CH_RING_10_B_RARE 3 1 5 3 NORMAL SOM 10 M
5771 ITEM_CH_RING_10_C_RARE 3 1 5 3 NORMAL SUN 10 M
5805 ITEM_CH_EARRING_10_A_RARE 3 1 5 1 NORMAL SOS 10 USELSS
5806 ITEM_CH_EARRING_10_B_RARE 3 1 5 1 NORMAL SOM 10 USELSS
5807 ITEM_CH_EARRING_10_C_RARE 3 1 5 1 NORMAL SOM 10 USELSS
5841 ITEM_CH_NECKLACE_10_A_RARE 3 1 5 2 NORMAL SOS 10 USELSS
5842 ITEM_CH_NECKLACE_10_B_RARE 3 1 5 2 NORMAL SOM 10 M
5843 ITEM_CH_NECKLACE_10_C_RARE 3 1 5 2 NORMAL SUN 10 M
1 SN_ITEM_MULTI_MODEL_01 Model Switcher 1Dg
1 SN_ITEM_MULTI_MODEL_02 Model Switcher 2Dg
1 SN_ITEM_MULTI_MODEL_03 Model Switcher 3Dg
1 SN_ITEM_MULTI_MODEL_04 Model Switcher 4Dg
1 SN_ITEM_MULTI_MODEL_05 Model Switcher 5Dg
1 SN_ITEM_MULTI_MODEL_06 Model Switcher 6Dg
1 SN_ITEM_MULTI_MODEL_07 Model Switcher 7Dg
1 SN_ITEM_MULTI_MODEL_08 Model Switcher 8Dg
1 SN_ITEM_MULTI_MODEL_09 Model Switcher 9Dg
1 SN_ITEM_MULTI_MODEL_10 Model Switcher 10Dg
1 SN_ITEM_MULTI_MODEL_11 Model Switcher 11Dg
1 SN_ITEM_MULTI_MODEL_12 Model Switcher 12Dg
1 SN_ITEM_MULTI_MODEL_01_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>First Degree<br><br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_02_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Second Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_03_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Third Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_04_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Fourth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_05_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Fifth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_06_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Sixth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_07_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Seventh Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_08_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Eighth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_09_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Ninth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_10_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Tenth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_11_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Eleventh Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_12_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Twelfth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
USE [SRO_VT_RAMY] GO /****** Object: StoredProcedure [dbo].[_DyeSysSHSP] Script Date: 01/04/2016 04:39:43 م ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
DECLARE @ItemID int ,@RefItemID int ,@Color varchar(16) ,@RareT varchar(16) ,@NItem int ,@DG INT
,@T1 tinyint ,@T2 tinyint ,@T3 tinyint ,@T4 tinyint SELECT @Color = CASE WHEN @ItemRefID = '48041' THEN 'BLUE' WHEN @ItemRefID = '48042' THEN 'BODH' WHEN @ItemRefID = '48043' THEN 'BODZ' WHEN @ItemRefID = '48044' THEN 'FIRE' WHEN @ItemRefID = '48045' THEN 'FIRE_1' WHEN @ItemRefID = '48046' THEN 'GREEN' WHEN @ItemRefID = '48047' THEN 'RED' WHEN @ItemRefID = '48048' THEN 'YELLOW' WHEN @ItemRefID = '48049' THEN 'RAINBOW' WHEN @ItemRefID = '48050' THEN 'PURB' WHEN @ItemRefID = '48051' THEN 'ORANGE' WHEN @ItemRefID = '48052' THEN 'NORMAL' ELSE NULL END
SELECT @ItemID=I.ID64 , @RefItemID = I.RefItemID FROM SRO_VT_SHARD.dbo._Items I INNER JOIN SRO_Vt_SHARD.dbo._Inventory Iv ON I.ID64 = Iv.ItemID WHERE Iv.Slot = '13' AND Iv.CharID = @CharID
-- First item SELECT @T1 = TypeID1 , @T2 = TypeID2 , @T3 = TypeID3 , @T4 = TypeID4 , @DG = DG FROM SRO_VT_RAMY.dbo._DyeSysSH WHERE ID = @RefItemID
-- Secound item SELECT @NItem = ID FROM SRO_VT_RAMY.dbo._DyeSysSH
WHERE TypeID1 = @T1 AND TypeID2 = @T2 AND TypeID3 = @T3 AND TypeID4 = @T4 AND Color = @Color AND DG = @DG -- Upcating UPDATE SRO_VT_SHARD.dbo._Items SET RefItemID = @NItem WHERE ID64 = @ItemID
التعديل الأخير تم بواسطة HLP ; 01-04-2016 الساعة 05:48 PM
• الـهـوايـة » Private server developing and designing [ 2D -3D - Pk2 ]
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 89
3271
رد: [Release]Model Switchers Vsro
اقتباس:
المشاركة الأصلية كتبت بواسطة Dangers SrO
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
حلو بس في واحد اسهل من ده كمان انا عملو هبقي انزلو
تقريبا مفيش Proc اسرع من كده ^^ بس هستنى موضوعك لو لقيتو احسن يبقى الله ينور ومنك نستفيد
===================
اقتباس:
المشاركة الأصلية كتبت بواسطة HLP
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
تسلم ايدك بس ده قديم اوي
كود PHP:
USE [SRO_VT_RAMY] GO /****** Object: StoredProcedure [dbo].[_DyeSysSHSP] Script Date: 01/04/2016 04:39:43 م ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO
DECLARE @ItemID int ,@RefItemID int ,@Color varchar(16) ,@RareT varchar(16) ,@NItem int ,@DG INT
,@T1 tinyint ,@T2 tinyint ,@T3 tinyint ,@T4 tinyint SELECT @Color = CASE WHEN @ItemRefID = '48041' THEN 'BLUE' WHEN @ItemRefID = '48042' THEN 'BODH' WHEN @ItemRefID = '48043' THEN 'BODZ' WHEN @ItemRefID = '48044' THEN 'FIRE' WHEN @ItemRefID = '48045' THEN 'FIRE_1' WHEN @ItemRefID = '48046' THEN 'GREEN' WHEN @ItemRefID = '48047' THEN 'RED' WHEN @ItemRefID = '48048' THEN 'YELLOW' WHEN @ItemRefID = '48049' THEN 'RAINBOW' WHEN @ItemRefID = '48050' THEN 'PURB' WHEN @ItemRefID = '48051' THEN 'ORANGE' WHEN @ItemRefID = '48052' THEN 'NORMAL' ELSE NULL END
SELECT @ItemID=I.ID64 , @RefItemID = I.RefItemID FROM SRO_VT_SHARD.dbo._Items I INNER JOIN SRO_Vt_SHARD.dbo._Inventory Iv ON I.ID64 = Iv.ItemID WHERE Iv.Slot = '13' AND Iv.CharID = @CharID
-- First item SELECT @T1 = TypeID1 , @T2 = TypeID2 , @T3 = TypeID3 , @T4 = TypeID4 , @DG = DG FROM SRO_VT_RAMY.dbo._DyeSysSH WHERE ID = @RefItemID
-- Secound item SELECT @NItem = ID FROM SRO_VT_RAMY.dbo._DyeSysSH
WHERE TypeID1 = @T1 AND TypeID2 = @T2 AND TypeID3 = @T3 AND TypeID4 = @T4 AND Color = @Color AND DG = @DG -- Upcating UPDATE SRO_VT_SHARD.dbo._Items SET RefItemID = @NItem WHERE ID64 = @ItemID
هو مش قديم اوى كده ^^ بس مش موجود على الموقع فقولت افيد الناس
====================
تسلموا يا رجالة .. بالتوفيق
التعديل الأخير تم بواسطة Jayden ; 01-04-2016 الساعة 06:58 PM
• الـهـوايـة » Private server developing and designing [ 2D -3D - Pk2 ]
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 89
3271
رد: [Release]Model Switchers Vsro
اقتباس:
المشاركة الأصلية كتبت بواسطة BashA_Mn_Youme
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
يا استاذ انا مشيت بالموضوع وضفت الاسكرول لكن مش راضيه تضرب
انا غيرتها ل Dg14
مع العمل ال RefobjItem بايظة و انا حطيط بدالها من عندي
مفيش حاجة بايظة يا باشا .. السيستم ده اشتغلت بيه مليون مره
وانت مش محتاج تغير حاجة .. وانا مش فاهم اللى بتقولو بصراحه
بس انت اتأكد من أشكال الأسلحه فى الميديا .. ال Scroll لو عندك شغالة وبتغير من سلاح لسلاح فخلاص هى كده شغالة
شـريـط الاهـداءات
01-04-2016, 04:58 AM
.gif){kind=icon}
العرض العادي
