الـجـروب الـرسـمـي لـلـمـنـتـدى Silkroad4arab Facebook | Official Group

**zizo200004** · 05-04-2015, 02:32 AM

hello silkroad4arab members , this system enables you to trade the items you are wearing with the items you want be message !
_Memo_add
كود PHP:

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
Notes :::
اقتباس:

1- You can add the conditions you want according to your server

2- I did it and i don't know if there is any thread about this

**Hamza FiGo** · 05-04-2015, 04:32 PM

Approved##

تسلم ايدك

بس حضرتك ياريت توضيح والكلام يكون بالعربي احنا منتدي عربي

وشرح مبسط كدة بيعمل اية وازاي. هنديلك مهلة علشان تعدل علي موضوعك

**UnStoppable!** · 05-04-2015, 05:12 PM

و ده بيعمل ايه :D

**Dev. iLegend** · 05-04-2015, 07:59 PM

كفكرة أكثر من روعة بس كتنفيذ ..
لامؤاخذة فى الكلمة دا شغل شقلب وإقلب ،،
بص انا مش هنتقد شغلك بس فى أحسن من كدا تقدر تطلعه فكر شوية فى طريقة تانية هتلاقيها سهلة جداً ومش هتاخد كل اللى انت عامله دا ..

**zizo200004** · 05-04-2015, 10:06 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Lazcano عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

كفكرة أكثر من روعة بس كتنفيذ ..
لامؤاخذة فى الكلمة دا شغل شقلب وإقلب ،،
بص انا مش هنتقد شغلك بس فى أحسن من كدا تقدر تطلعه فكر شوية فى طريقة تانية هتلاقيها سهلة جداً ومش هتاخد كل اللى انت عامله دا ..

الموضوع ده من مدة و انا حاولت اني اعملو بشكل كان بانسبة ليا بسيط مش اكتر , شوف حضرتك اعدل عليه في ايه و قولي

**zizo200004** · 05-04-2015, 10:16 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Hamza FiGo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

Approved##

تسلم ايدك

بس حضرتك ياريت توضيح والكلام يكون بالعربي احنا منتدي عربي

وشرح مبسط كدة بيعمل اية وازاي. هنديلك مهلة علشان تعدل علي موضوعك

ممكن حضرتك تشيلو لحد ما اعدل علليه و اظبطو اكتر

**Hero** · 05-04-2015, 10:20 PM

يا باشا الف شكر
الموضوع اكيد مش هيتشال
بس انت اللى عليك انك تفهم الناس بيعمل اية من صورة من الجيم بتاعك
عشان تاكد لية الناس انك عامل الموضوع دى و سليم 100%
و الف شكر تانى

**zizo200004** · 05-04-2015, 10:28 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة Hero عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

يا باشا الف شكر
الموضوع اكيد مش هيتشال
بس انت اللى عليك انك تفهم الناس بيعمل اية من صورة من الجيم بتاعك
عشان تاكد لية الناس انك عامل الموضوع دى و سليم 100%
و الف شكر تانى

لا انا اقصد اني احسنو يا باشا مش اكتر بس عايز حد يقولي انا ممكن اعملو بطريقة تانية ازاي لانه فس ناس معترضة علي ان كل ده يكون في ال memo_add

**Dev. iLegend** · 05-04-2015, 10:54 PM

شوف الفيديو دا كدا

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

**zizo200004** · 05-04-2015, 11:04 PM

حضرتك هو مفيش فرق غير في ال pm اللي بيجيلو تحت و ان انا عاملها قاصد انو مياخدش adv ولا stat ولا blue علشان ال trade بين ال players ميوقفش

**Dev. iLegend** · 05-04-2015, 11:04 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة zizo200004 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

لا انا اقصد اني احسنو يا باشا مش اكتر بس عايز حد يقولي انا ممكن اعملو بطريقة تانية ازاي لانه فس ناس معترضة علي ان كل ده يكون في ال memo_add

يا باشا حضرتك فهمتني غلط .. أنا أقصد انه طويل جداً ومش منظم وفى حاجات مش مظبوطة يعني اي حد هياخده يعمله Execute عنده هيجبله ايررور كتيير
أنا مقصدش انك تغير طريقته من Memo_Add
أنا أقصد انك ممكن تعمله يغير الـ RefItemID أسهلك بدل متروح تمسح الأيتم وتضيفله أيتم جديد من غير Stats or Blues
فاهم قصدي ؟
اتفرج ع الفيديو دا انا عملت بنفس الفكرة سيستم صغير كدا لتغيير الويبون بس .

**Dev. iLegend** · 05-04-2015, 11:08 PM

هو مجرد انك تخليه يعمل Stats 0 هتنشط حوار التريد بين البلايرس ودي ممكنه برضه فى انك تعدل على dbo._Items عشان انت لو جيت أصلاً تعمل Delete للأيتم فى خطوة ناقصة .. انك تروح فى dbo._ItemPool وتخلى الأيتم InUse = 0 عشان ميبقاش موجود فى الداتا بيز ع الفاضي

**zizo200004** · 05-04-2015, 11:27 PM

تمام فهمتك عندك حق

**Hamza FiGo** · 05-04-2015, 11:41 PM

حضرتك محدش قال اننا هنشيلة. انا بقول عدل علية بالعربي وشرح مبسط للناس مش اكتر

ياريت حضرتك تعمل اللي قولتلك علية. وتشوف Lazcano قال اية علشان هو اللي خبير هنا ^^

وكلنا بنستفيد من بعض . اسرة مع بعضينا

**Dev. iLegend** · 05-04-2015, 11:53 PM

وحضرتك انا بالفعل جربت الموضوع بتاعك شيلت العلامات دي [*] لحد مظبطه وعمل Execute بس لقيت فيه بج ومش اي بج ،، شوف الفيديو ده .. عشان كدا عملت كيوري صغيرة كدا للويبون بس مش للايتم كلها .. اللى انت شوفتها فى الفيديو اللى فوق

[YOUTUBE]_9bxTJXjprA[/YOUTUBE]

	ط§ظ„ط¨ظ‚ط§ط، ظ…ط³ط¬ظ„ ط¯ط§ط¦ظ…ط¢

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)