Register for your free account! | Forgot your password?

You last visited: Today at 05:46

  • Please register to post and access all features, it's quick, easy and FREE!

 

[My first release] Trading items by message

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jun 2012
Posts: 38
Received Thanks: 6
[My first release] Trading items by message

Hello elitepvpers members ,

By this system , you can trade your items by message system but you have to wear what you want to trade first !

_memo_add
PHP Code:
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 AND CHARID = @CHARID)
    DECLARE @
HOGO Varchar(52) =(SELECT OPTLEVEL FROM DBO._ITEMS WHERE ID64 in (select ItemID from _Inventory where CharID = @CHARID and Slot 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 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 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 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 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 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 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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_DAGGER_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_SWORD_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_BLADE_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_TBLADE_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_BOW_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_SPEAR_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_SWORD_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_TSWORD_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_STAFF_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_TSTAFF_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_DARKSTAFF_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_CROSSBOW_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._InventoryForAvatar SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID 
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_AXE_11_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_LIGHT_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_LIGHT_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_LIGHT_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_LIGHT_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_LIGHT_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_LIGHT_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_LIGHT_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_LIGHT_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_LIGHT_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_LIGHT_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_LIGHT_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_LIGHT_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_HEAVY_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_HEAVY_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_HEAVY_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_HEAVY_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_HEAVY_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_HEAVY_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
      Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_HEAVY_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_HEAVY_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_HEAVY_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_HEAVY_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_HEAVY_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_HEAVY_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_CLOTHES_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_CLOTHES_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_CLOTHES_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_CLOTHES_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_CLOTHES_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_M_CLOTHES_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_HEAVY_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_HEAVY_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_HEAVY_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_HEAVY_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_HEAVY_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_HEAVY_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_HEAVY_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_HEAVY_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_HEAVY_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_HEAVY_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_HEAVY_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_HEAVY_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_LIGHT_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_LIGHT_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_LIGHT_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_LIGHT_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_LIGHT_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_LIGHT_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_LIGHT_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_LIGHT_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_LIGHT_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_LIGHT_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_LIGHT_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_LIGHT_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_CLOTHES_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_CLOTHES_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_CLOTHES_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_CLOTHES_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_CLOTHES_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_M_CLOTHES_11_AA_SET_B_RARE' ,@data ,@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 AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
    UPDATE DBO
._Inventory SET ITEMID 0 WHERE SLOT AND CHARID = @CHARID
     Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_CLOTHES_11_HA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO0
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_CLOTHES_11_FA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO5
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_CLOTHES_11_BA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO1
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_CLOTHES_11_LA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO4
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_CLOTHES_11_SA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO2
   Exec 
[_ADD_ITEM_EXTERN] @codename 'ITEM_CH_W_CLOTHES_11_AA_SET_B_RARE' ,@data ,@charname = @SenderCharName,@opt_level = @HOGO3
   
   END 
Note::: You can edit it according to your server

I only tried to help



zizo200004 is offline  
Thanks
2 Users
Old   #2
 
elite*gold: 200
Join Date: Nov 2008
Posts: 1,261
Received Thanks: 673
Lol? Waaaat is dat?


flozz is offline  
Old   #3
 
elite*gold: 0
Join Date: Jun 2012
Posts: 38
Received Thanks: 6
Quote:
Originally Posted by Crue* View Post
your first and last release
don't release anything again
i didn't tell you that i am a professional one -_- , i told you that its the first one and i only tried to help !
zizo200004 is offline  
Thanks
2 Users
Old   #4
 
elite*gold: 0
Join Date: Mar 2012
Posts: 573
Received Thanks: 17
How do I make the system coin job?


ILowe is offline  
Old   #5
 
elite*gold: 737
Join Date: Oct 2007
Posts: 478
Received Thanks: 112
nice bro . don't listen to the haters. good work anyways it works fine
Bocc1337 is offline  
Old   #6
 
elite*gold: 0
Join Date: Nov 2014
Posts: 14
Received Thanks: 4
So Nice , But Stop Here !!!
Junkle is offline  
Old   #7
 
elite*gold: 0
Join Date: Jan 2015
Posts: 94
Received Thanks: 115
What this xD big **** ????
X-Vortex is offline  
Old   #8
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,110
Received Thanks: 584
Quote:
Originally Posted by TheRunner View Post
Everyone wants to review the talents here on this emerging He said he does not have sufficient experience and he just trying to help So if one of you can handle as a mature and corrects his mistakes will be much better than this ridiculous replies But you always stop at these responses is feasible
Message to Owner Thread ...
Tried repeatedly biggest mistake is not the end, people who are on the scene now their starting were not better than your starting
sadly... fixing this would take much longer then write a new system :S

@ziso:

take a look on my upgrade query maybe it can help you abit
http://www.elitepvpers.com/forum/pri...de-system.html
Syloxx is offline  
Old   #9
 
elite*gold: 0
Join Date: Sep 2014
Posts: 75
Received Thanks: 92
Nice try.

However, when modifying procedures you must take in to consideration EVERY possible scenario otherwise you will cause many unsolvable bugs.
SROConnect is offline  
Old   #10
 
elite*gold: 0
Join Date: Jun 2012
Posts: 38
Received Thanks: 6
Quote:
Originally Posted by The SROConnect Network View Post
Nice try.

However, when modifying procedures you must take in to consideration EVERY possible scenario otherwise you will cause many unsolvable bugs.
can you tell me what kinds of bugs i have done by this procedure ?
zizo200004 is offline  
Old   #11
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,110
Received Thanks: 584
actually your query is a goldmaker machine

buy Lv 1 weapon, equip it
use the query get any wepaon you want and sell it to npc
Syloxx is offline  
Old   #12
 
elite*gold: 0
Join Date: Jun 2012
Posts: 38
Received Thanks: 6
You can edit it , i have released beacuase it may be useful for anyone and to know what problems it does
zizo200004 is offline  
Old   #13
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,110
Received Thanks: 584
Quote:
Originally Posted by zizo200004 View Post
You can edit it , i have released beacuase it may be useful for anyone and to know what problems it does
ye, its a nice try actually but ppl can learn these stuff from some queries i released already

how i said you should check it out too

maybe next time you should release smt that isn't released yet (or if its released release at lease a better version)
Syloxx is offline  
Old   #14
 
elite*gold: 0
Join Date: Jun 2012
Posts: 38
Received Thanks: 6
Quote:
Originally Posted by Syloxx View Post
ye, its a nice try actually but ppl can learn these stuff from some queries i released already

how i said you should check it out too

maybe next time you should release smt that isn't released yet (or if its released release at lease a better version)
You are right
zizo200004 is offline  
Old   #15
 
elite*gold: 6
Join Date: Oct 2013
Posts: 1,110
Received Thanks: 584
Quote:
Originally Posted by Leonius* View Post
Still using google translate? And remove your ****** signature, I'm not gonna accept your apologizes.
@Original Post
Did you even test it? and why is @Itemid between 1 and 99999999999999999999999999999999999999999 required when i can make @ItemID > 0 ? Should i post the other mistakes here or stop? Whatever, it would be better if you deleted it and requested closing this thread.


exec _ADD_ITEM_Extern @Charname = @sendercharname? epic fail.. I advise you to delete this procedure.
actually the _ADD_ITEM_EXTERN part is correct


Syloxx is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Release]Quarry to stop trading silk items :)
well as we know ,,, every one have a server with free silks ! might face a small problem That the players make lot of different account and start...
39 Replies - SRO PServer - Discussions / Questions



All times are GMT +1. The time now is 05:46.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.