تم الحل .. مشكله الجيم سيرفر انو مظبطش ال IP في الcfg في المسار ده : server_files/srZor/cfg/misc.ini
السيستم مداش سيلك عشان الtrigger كان فيها مشكله ... عدلتلوا عليها في كلمتين كده واشتغلت .. دي ال trigger لل srZor_GameServer :
كود:
USE [SRO_VT_ACCOUNT]
GO
/****** Object: Trigger [dbo].[_UniquesForSilk] Script Date: 4/1/2016 6:40:50 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[_UniquesSilkReward]
ON [SRO_VT_ACCOUNT].[dbo].[srZor_uniques]
after insert
as begin
DECLARE @MobName varchar(128) , @CharName varchar(128) SELECT @MobName = MobName,@CharName=CharName FROM [SRO_VT_ACCOUNT].[dbo].[srZor_uniques]
DECLARE @CharID int = (SELECT CharID FROM SRO_VT_SHARD.dbo._Char where (CharName16 = @CharName OR NickName16 = @CharName))
DECLARE @UserID varchar(max) = (select UserJID from [SRO_VT_SHARD].dbo._User where CharID = @CharID)
DECLARE @SILK int
SELECT @SILK =
CASE WHEN @MobName = 'MOB_CH_TIGERWOMAN' Then '3'
WHEN @MobName = 'MOB_EU_KERBEROS' Then '3'
WHEN @MobName = 'MOB_OA_URUCHI' Then '5'
WHEN @MobName = 'MOB_AM_IVY' Then '3'
WHEN @MobName = 'MOB_KK_ISYUTARU' Then '5'
WHEN @MobName = 'MOB_TK_BONELORD' Then '7'
WHEN @MobName = 'MOB_RM_TAHOMET' Then '7'
WHEN @MobName = 'MOB_RM_ROC' Then '15'
WHEN @MobName = 'MOB_SD_NEITH' Then '6'
WHEN @MobName = 'MOB_SD_SELKIS' Then '6'
WHEN @MobName = 'MOB_SD_SETH' Then '10'
WHEN @MobName = 'MOB_SD_ANUBIS' Then '7'
WHEN @MobName = 'MOB_SD_ISIS' Then '6'
WHEN @MobName = 'MOB_SD_HAROERIS' Then '13'
ELSE 0 END
BEGIN
UPDATE [SRO_VT_ACCOUNT].dbo.SK_Silk set silk_own = silk_own + @SILK
END
END