2 questions`

[Maddona]

1st

i made system silk per hour i want ppl get silk when they rich lv120 any idea ?

2nd

this query to trading items by msg any idea to fix errors ?!?! cuz there is alot of errors in query ?!

 Spoiler

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

[​Exo]

The one and only tip I am going to give you here is:
Don't use this query. Why?, just don't.

As for the Silk/H thing, just add a condition that checks the level of the character.

[Xutan*]

this query will rape your memo procedure.
bout silk per hour, use this

PHP Code:

DECLARE
@Level INT = (SELECT MaxLevel FROM _Char WHERE CharID = @CharID)
if @MaxLevel = 120
begin
YOUR SILK PER HOUR CODES HERE
end
--it's just simple.. if u want better use google. 


[Maddona]

Originally Posted by Xutan*

this query will rape your memo procedure.
bout silk per hour, use this

PHP Code:

DECLARE
@Level INT = (SELECT MaxLevel FROM _Char WHERE CharID = @CharID)
if @MaxLevel = 120
begin
YOUR SILK PER HOUR CODES HERE
end
--it's just simple.. if u want better use google. 


WHAT DO U MEAN BY SILK PER HOUR CODES ?! !

[Warnuk3r]

Originally Posted by Maddona

WHAT DO U MEAN BY SILK PER HOUR CODES ?! !

Well his code is only checking the level and not doing anything else, the code that is giving silk per hour needs to be added there. Thats the System silk per hour u talked about that u've made.

[Xutan*]

Originally Posted by Maddona

WHAT DO U MEAN BY SILK PER HOUR CODES ?! !

replace that line with your silk per hour query.
if u don't understand add me on skype xutan1337 i'll help you (it's not free service).

[Maddona]

 Spoiler

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

?! DO U MEAN THATS ? RIGHT ?!

[$WeGs]

change YOUR SILK PER HOUR CODES HERE to your silk per hour codes in addlogchar