2 questions`

DECLARE @SERVICE varchar(52) = ( SELECT SERVICE FROM SRO_VT_SHARDLOG.DBO.TRADE_service ) DECLARE @CHARID VARCHAR(52) = (select CharID from _Char where CharName16 = @SenderCharName) DECLARE @ITEMID VARCHAR(52) = (SELECT ITEMID FROM DBO._Inventory WHERE SLOT = 6 AND CHARID = @CHARID) DECLARE @HOGO Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot = 6 and ItemID Between 1 AND 999999999)) DECLARE @HOGO0 Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot = 0 and ItemID Between 1 AND 999999999)) DECLARE @HOGO1 Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot = 1 and ItemID Between 1 AND 999999999)) DECLARE @HOGO2 Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot = 2 and ItemID Between 1 AND 999999999)) DECLARE @HOGO3 Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot = 3 and ItemID Between 1 AND 999999999)) DECLARE @HOGO4 Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot = 4 and ItemID Between 1 AND 999999999)) DECLARE @HOGO5 Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot = 5 and ItemID Between 1 AND 999999999)) If (@TargetCharName like @SenderCharName and @Message = 'Dagger' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_DAGGER_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'Sword' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_SWORD_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'Blade' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_BLADE_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'Glaive' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_TBLADE_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'Bow' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_BOW_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'Spear' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_SPEAR_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'OSword' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_SWORD_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'TSword' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_TSWORD_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'LStaff' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_STAFF_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'TStaff' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_TSTAFF_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'DStaff' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_DARKSTAFF_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'CBow' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_CROSSBOW_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End If (@TargetCharName like @SenderCharName and @Message = 'Axe' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID UPDATE DBO._InventoryForAvatar SET ITEMID = 0 WHERE SLOT = 6 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_AXE_11_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO END End
If (@TargetCharName like @SenderCharName and @Message = 'MLIGHT' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_LIGHT_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_LIGHT_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_LIGHT_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_LIGHT_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_LIGHT_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_LIGHT_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END End
If (@TargetCharName like @SenderCharName and @Message = 'FLIGHT' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_LIGHT_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_LIGHT_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_LIGHT_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_LIGHT_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_LIGHT_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_LIGHT_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END End If (@TargetCharName like @SenderCharName and @Message = 'MHEAVY' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_HEAVY_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_HEAVY_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_HEAVY_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_HEAVY_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_HEAVY_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_HEAVY_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END End If (@TargetCharName like @SenderCharName and @Message = 'FHEAVY' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_HEAVY_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_HEAVY_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_HEAVY_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_HEAVY_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_HEAVY_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_HEAVY_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END End If (@TargetCharName like @SenderCharName and @Message = 'MRobe' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_CLOTHES_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_CLOTHES_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_CLOTHES_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_CLOTHES_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_CLOTHES_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_M_CLOTHES_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END End If (@TargetCharName like @SenderCharName and @Message = 'FRobe' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END End
If (@TargetCharName like @SenderCharName and @Message = 'CHMHEAVY' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_HEAVY_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_HEAVY_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_HEAVY_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_HEAVY_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_HEAVY_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_HEAVY_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END END If (@TargetCharName like @SenderCharName and @Message = 'CHFHEAVY' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_HEAVY_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_HEAVY_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_HEAVY_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_HEAVY_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_HEAVY_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_HEAVY_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END END If (@TargetCharName like @SenderCharName and @Message = 'CHMLIGHT' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_LIGHT_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_LIGHT_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_LIGHT_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_LIGHT_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_LIGHT_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_LIGHT_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END END
If (@TargetCharName like @SenderCharName and @Message = 'CHFLIGHT' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_LIGHT_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_LIGHT_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_LIGHT_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_LIGHT_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_LIGHT_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_LIGHT_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END END If (@TargetCharName like @SenderCharName and @Message = 'CHMGARMENT' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_CLOTHES_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_CLOTHES_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_CLOTHES_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_CLOTHES_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_CLOTHES_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_M_CLOTHES_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END END
If (@TargetCharName like @SenderCharName and @Message = 'CHFGARMENT' ) begin IF @ITEMID BETWEEN 1 AND 99999999 BEGIN UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 0 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 1 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 2 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 3 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 4 AND CHARID = @CHARID UPDATE DBO._Inventory SET ITEMID = 0 WHERE SLOT = 5 AND CHARID = @CHARID Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_CLOTHES_11_HA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO0 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_CLOTHES_11_FA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO5 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_CLOTHES_11_BA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO1 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_CLOTHES_11_LA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO4 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_CLOTHES_11_SA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO2 Exec [_ADD_ITEM_EXTERN] @codename = 'ITEM_CH_W_CLOTHES_11_AA_SET_B_RARE' ,@data = 1 ,@charname = @SenderCharName,@opt_level = @HOGO3 END

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_RandomPlayerID] Script Date: 03/05/2015 03:59:56 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_RandomPlayerID] /*by Caipi*/

as

Declare @Random int = 1, @Bool bit = 0;

WHILE (@Bool = 0)
BEGIN
SET @Random = ROUND(RAND()*(SELECT MAX(CharID) FROM SRO_VT_SHARD.dbo._Char),0)
IF exists (SELECT CharID FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @Random)
BEGIN
SET @Bool = 1 /*true*/
END
END

return @Random