Trading items by message [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

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

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

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

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

zizo200004

05-04-2015, 10:16 PM

Approved##

تسلم ايدك

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

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

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

Hero

05-04-2015, 10:20 PM

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

zizo200004

05-04-2015, 10:28 PM

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

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

Dev. iLegend

05-04-2015, 10:54 PM

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

https://youtu.be/JdZvq7BOyeI

zizo200004

05-04-2015, 11:04 PM

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

Dev. iLegend

05-04-2015, 11:04 PM

لا انا اقصد اني احسنو يا باشا مش اكتر بس عايز حد يقولي انا ممكن اعملو بطريقة تانية ازاي لانه فس ناس معترضة علي ان كل ده يكون في ال 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 قال اية علشان هو اللي خبير هنا ^^

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

Dev. iLegend

05-04-2015, 11:53 PM

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

_9bxTJXjprA

zizo200004

05-04-2015, 11:55 PM

بس اناعاملو عندي في السيرفر و تمام , عاملو علي شكل ايفينت ال GM يقدر يشغلها و يقفلها بال message

Dev. iLegend

06-04-2015, 12:34 AM

يا باشا منا فاهم انت تقصد أيه انك عاملها بـ Service
بس الفيديو اللى عامله لحضرتك دا انا مسكت سلاح ليفل 1 نورمال وبعت رسالة بـ Sword شالي السلاح اللى ليفل 1 ده واداني سلاح Egy B وده بج مينفعش يتغض النظر عنه

شوف دي يا باشا كدا ممكن تساعدك
Update dbo._Items Set RefItemID='25673',CreaterName='iLegend' Where ID64 = (Select ItemID From _Inventory Where CharID = @CharID and Slot = '6' and ItemID>0) and RefItemID in (25669,25670,25671,25672)

zizo200004

06-04-2015, 01:29 AM

لاحظ ال note اللي انا كاتبها + انه اساسا معول لسيرفر ال EGY B = 1 gold

Dev. iLegend

06-04-2015, 04:13 AM

يا معلم مهو مش كل السيرفرات بنفس نظامك يعني فى سيرفر البج دا يبوظ معاه الدنيا خالص لما الـ Egy B يجي من حاجة صعبة جداً أو دونيت بس ..

Hamza FiGo

06-04-2015, 09:35 AM

لاحظ ال note اللي انا كاتبها + انه اساسا معول لسيرفر ال EGY B = 1 gold

كلامك تمام طيب وبالنسبة للسيرفرات التانية اللي بيكلم عليها Lazcano ؟

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

UnStoppable!

06-04-2015, 01:46 PM

طب باردو محدش عاوز يقولى ده بيعمل ايه

Dev. iLegend

06-04-2015, 05:44 PM

طب باردو محدش عاوز يقولى ده بيعمل ايه

شوف الاتنين فيديو اللي حاطط اللينك بتاعهم فى الردود اللى فاتت فى الموضوع دا وانت تفهم السيستم دا بيحكي فى أيه

zizo200004

06-04-2015, 08:48 PM

كلام كدة عندكم حق فيه ساعتها زي ما قال Lazcano بال itemid او ممكن نعمل condition ان لو معاه عدد معين من ال coins في ال 1st slot يبدل تمام

Dev. iLegend

06-04-2015, 09:14 PM

وعلى فكرة انا كل ردودي اللى فاتت دي مش بحبطك والله ولا بتريق عليك زي الأجانب على Elitepvpers انا بحاول اني اساعدك واوصلك انك تصغر البروسيدور بأقل حجم ممكن عشان برضه تعمل حساب اللاج اللى هيجي من الموضوع دا فى ال Memo_Add
ضيف الفيس (https://www.facebook.com/designer.ramy.saied)بتاعي ونتواصل

zizo200004

06-04-2015, 09:34 PM

تمام

Hamza FiGo

06-04-2015, 10:15 PM

عاش يا شباب :angel1:

HangoverS

22-04-2015, 08:14 AM

مش شغال

merazz012

22-04-2015, 03:09 PM

errors كتير في الكويري ؟