Bug with ShardManager

[Chinaya]

حل المشكله Vsro Ver .193 ياريت مساعده
بيقفل معايا بعد الرساله دي
lمش فريجين 1.88

[Chinaya]

الملفات اللي شغال بيها فيرجن 1.93
مش فيرجن 1.88

[Helper4You]

مش فاهم مشكلتك بصراحه

[Chinaya]

يا باشا مشكلتي ان ال SR_ShardManager
[يقفل بعد الرساله اللي في الصورة اللي فوق
بعد الرساله دي بيقفل وبيختفي
وانا شغال بي ملفات فيرجن 1.93
مش 1.88

[Helper4You]

اعملو تثبيت ... .

واتاكد من Setup Server ...

ان شاء الله هتكون المشكله منها ان شاء الله

على العموم اعملى اضافه على الفيس بوك وانا هسعدك ان شاء الله

[Dev.Ri3o]

هتعمل دول

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_DeleteCharPermanently]    Script Date: 02/14/2012 12:54:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


--!!!CHECK!!!
ALTER              PROCEDURE [dbo].[_DeleteCharPermanently]
@CharID	as int
as
	------------------------------------
	-- ى‌¼ë‹¨ ى‚*ى*œëگœ ى؛گë¦*ى‌¸ى§€ 부ي„° ê²€ى‚¬!
	------------------------------------
	if (not exists(select charid from _deletedchar where charid = @CharID))
	begin
		return -1
	end
	------------------------------------
	-- ى‚*ى*œي›„ 경과ëگœ ى‹œê°„ى‌´ 대ë‍µ 7ى‌¼ى‌´ ë§‍ëٹ”ê°€ ي™•ى‌¸ (ىƒ¤ë“œى—گ يک¹ى‹œ 버그가 ى‍ˆى‌„ى§€ ëھ¨ë¥´ë‹ˆê¹گ...)
	------------------------------------
	declare @deleted_date datetime
	declare @cur_date 	  datetime
	declare @elapsed_min int
	declare @UserJID		 int
--	declare @deleted_slot  int
	set @cur_date = getdate()
	select @UserJID = UserJID, /*@deleted_slot = CharSlot,*/ @deleted_date = deleteddate  from _deletedchar with (nolock) where charid = @CharID
	
	-- ى‚*ى*œى‹œي‚¨ى§€ 6ى‌¼ + 23ى‹œê°„ ى‌´ىƒپى‌´ ى§€ë‚œ ى؛گë¦*ى‌¸ê°€? (1ى‹œê°„ ى*•ëڈ„ى‌ک ىک¤ى°¨ë‌¼ë©´ ى‌¸ى*•ي•´ ى¤€ë‹¤ ëƒگي•ک~)
	set @elapsed_min = datediff(minute, @deleted_date, @cur_date)
	if (@elapsed_min < ((60 * 24 * 6) + (60 * 23))) 
	begin
		return -2
	end
	------------------------------------
	-- ى‚*ى*œëگœ ى؛گë¦*ى‌´ ë§‍ëٹ”ى§€ 다ى‹œي•œë²ˆ ي™•ى‌¸
	------------------------------------
	declare @is_deleted tinyint
	select @is_deleted = deleted from _Char where CharID = @CharID
	if (@is_deleted <> 1)
	begin
		return -3
	end

	------------------------------------
	-- ى§€ىڑ¸ ى؛گë¦*ى‌´ _User ى—گ ى‍ˆëٹ” CharIDى™€ ى‌¼ى¹کي•کëٹ”ê°€ ê²€ى‚¬
	------------------------------------
	declare @char_id_to_check	 	int
	set @char_id_to_check = 0

/*	-- commented by novice. for server integration.
	if (@deleted_slot = 0)
		begin	select @char_id_to_check = CharID1 from _User where UserJID = @UserJID end
	else if (@deleted_slot = 1)
		begin	select @char_id_to_check = CharID2 from _User where UserJID = @UserJID end
	else if (@deleted_slot = 2)
		begin	select @char_id_to_check = CharID3 from _User where UserJID = @UserJID end
	else
		begin
			return -4
		end
	-- ى¼پ! ى–´ë–»ê²Œ ëگœê±°ى•¼?  ى‌´ىƒپي•œ ë„کى‌´ ى‍گ리를 ى°¨ى§€ي•کê³* ى‍ˆë‹¤!
	if (@char_id_to_check <> @CharID)
	begin
		return -5
	end
*/
	-- start by novice.
	select @char_id_to_check = CharID from _User where UserJID = @UserJID and CharID = @CharID
	
	if (@char_id_to_check = 0)
	begin
		-- ى§€ىڑ¸ ى؛گë¦*ي„°ê°€ _User ى—گ ى—†ى–´?
		return -5
	end
	-- finish by novice.
	
begin transaction
	
	declare @GuildID int
	exec @GuildID = _DeleteCharPermanently_NoTX  @UserJID, @CharID --, @deleted_slot
	if (@GuildID is null)
		set @GuildID = -10000	
	if (@GuildID < 0)
	begin
		rollback transaction
		return @GuildID
	end	
commit transaction
	
	return @GuildID

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_DeleteCharPermanently_NoTX]    Script Date: 02/14/2012 12:54:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_DeleteCharPermanently_NoTX]
	@UserJID	INT
,	@CharID		INT
AS
	------------------------------------
	-- Inventory¶û ±×¾أˆآ؟آ، °آ،أپأ¶°أ* أ€أ–´أ¸ ¾أ†أ€أŒأ…أ›µé ³¯·أپ¹أ¶¸®أ€أڑ...
	------------------------------------
	-------------- أ†ê ¼أ’أˆ¯ ¾أ†أ€أŒأ…أ›آ؛أژأ…أچ أ€أڈ´أœ »èأپ¦ ----------------
	declare @result int
	declare @Slot tinyint
	declare @RefItemID int
	
	declare pc_inv_cursor cursor fast_forward for
	select inv.slot
	from _Inventory as inv join _Items as it on inv.ItemID = it.ID64 
	where 
	(inv.CharID = @CharID and inv.Slot >= 13 and inv.ItemID > 0) and 	-- أ€أ¥آ؛أ±أƒ¢ أپ¦آ؟أœأ‡أڈ°أ* ¾أ†أ€أŒأ…أ› أ€أ–´أ‚ ¼أ¸¼أ¶ أ€أژآ؛¥أ…أ¤¸® ¾أˆآ؟آ، µé¾îأ€أ–أ€¸¸ç
	(it.Data <> 0) 											 and	-- ¼أ’أˆ¯¼أ¶¸¦ °آ،أپأ¶°أ* أ€أ–´أ‚
	(exists (select top 1 ID from _RefObjCommon where ID = it.RefItemID and TypeID1 = 3 and TypeID2 = 2)) -- أ†ê¼أ’أˆ¯ ¾أ†أ€أŒأ…أ›µé أƒ£¾أ†أپà~
	
	open pc_inv_cursor 
	fetch next from pc_inv_cursor  into @slot
	while @@fetch_status = 0
	begin
			exec @result = _STRG_DEL_ITEM_NoTX 1, @CharID, @Slot	
			if (@result < 0)
			begin
				close pc_inv_cursor 
				deallocate pc_inv_cursor 
				return @result
			end
						
			fetch next from pc_inv_cursor  into @Slot
	end
	
	close pc_inv_cursor 
	deallocate pc_inv_cursor 
	------------------- ³²أ€آ؛ ¾أ†أ€أŒأ…أ›µé ¸ùأƒ¢ »èأپ¦  -------------------
	-- ¾أ†أ€أŒأ…أ›أ€أŒ أ‡أڈ³آھ¶أ³µµ أ€أ–´أ™¸é...
	if (exists (select top 1 itemID from _Inventory where CharID = @CharID AND ItemID <> 0))
	begin
		update _ItemPool Set InUse = 0 
		from _ItemPool as pool join _Inventory as inv on pool.ItemID = Inv.ItemID
		where Inv.CharID = @CharID and Inv.ItemID <> 0
	end
	----------- ¾أ†أ€أŒأ…أ›µé ³¯·أˆأ€¸´أڈ أƒأ–أپ¾أ€ûأ€¸·ç أ€أژآ؛¥أ…أ¤¸® »èأپ¦  ------------
	delete from _Inventory where CharID = @CharID
	if (@@error <> 0)
	begin
		return -10001
	end

	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
	--		APPLY_AVATAR_SYSTEM (أ‡أ£½أ‚آ؟أ*) 
	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

	------------------- ³²أ€آ؛ ¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® ¾أ†أ€أŒأ…أ›µé ¸ùأƒ¢ »èأپ¦  -------------------
	-- ¾أ†أ€أŒأ…أ›أ€أŒ أ‡أڈ³آھ¶أ³µµ أ€أ–´أ™¸é...
	if (exists (select top 1 itemID from _InventoryForAvatar where CharID = @CharID AND ItemID <> 0))
	begin
		update _ItemPool Set InUse = 0 
		from _ItemPool as pool join _InventoryForAvatar as InvAva on pool.ItemID = InvAva.ItemID
		where InvAva.CharID = @CharID and InvAva.ItemID <> 0
	end
	----------- ¾أ†أ€أŒأ…أ›µé ³¯·أˆأ€¸´أڈ أƒأ–أپ¾أ€ûأ€¸·ç ¾أ†¹أ™أ…¸ أ€أژآ؛¥أ…أ¤¸® »èأپ¦  ------------
	delete from _InventoryForAvatar where CharID = @CharID
	if (@@error <> 0)
	begin
		return -10008
	end

	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
	--		APPLY_AVATAR_SYSTEM (أ‡أ£½أ‚آ؟أ*) 
	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

	------------------------------------
	-- COS »èأپ¦
	------------------------------------
/*
	declare @engaged_cos int
	set @engaged_cos = 0
	select @engaged_cos = EngagedCOS from _char with (nolock) where CharID = @CharID
	
	if (@engaged_cos = 0)
	begin
		-- آ؟أ– ¹أں»أ½أ‡أڈ´أ‚ أپأ¶ أ€أں ¸أ°¸£°أڑأپأ¶¸¸... ¾أ†أپأ– µأ¥¹°°أ” COS ¸¸ ³²¾أ†أ€أ–´أ‚ °أ¦آ؟أ¬°آ، أ€أ–´أµ¶أ³°أ*... -_-;
		select @engaged_cos = ID from _CharCOS with (nolock) where OwnerCharID = @CharID
		if (@engaged_cos is null)
			set @engaged_cos = 0
	end
	if (@engaged_cos is not null and @engaged_cos <> 0)
	begin
		declare @Return_Del_COS int
		exec @Return_Del_COS = _DeleteCharCOS_NoTX  @CharID, @engaged_cos
		if (@Return_Del_COS < 0)
		begin
			return -10002
		end
	end
*/
	------------------------------------
	-- Trijob µ¥أ€أŒأ…أچ »èأپ¦
	------------------------------------
	delete from _CharTrijob where CharID = @CharID
	------------------------------------
	-- ½آ؛أ…³ »èأپ¦
	------------------------------------
	delete _CharSkill where CharId = @CharID
	delete _CharSkillMastery where charId = @CharID
	------------------------------------
	-- أ„ù½آ؛أ†® »èأپ¦
	------------------------------------
	delete _CharQuest where CharID = @CharID
	------------------------------------
	-- ±أ¦µأ¥ ¸â¹أ¶ »èأپ¦
	------------------------------------
	-- !!! ¸¸¾à آ؟©±â¼* Guild ¸â¹أ¶ »èأپ¦°آ، أ€أڈ¾î³آھأپأ¶ ¾أٹأ€¸¸é ShardManager آ؟آ،¼* 
	-- _Guild_DelMember أˆ£أƒâأ‡أک أپأ–µµ·أڈ ¼أ¶أپ¤أ‡أک¾أں أ‡أ‘´أ™! أپأ¶±أ‌أ€آ؛ ±× °أ؛أپ¤أ€آ؛ Skipأ‡أڈ°أ* 
	-- ¸أ‍¸أ°¸®آ؟آ،¼* »èأپ¦¸¸ أ€أڈ¾î³آھ°أ” µأ‡¾î أ€أ–°أ…µ¢...
	declare @GuildID int
	set @GuildID = 0
	select @GuildID = GuildID from _char where charid = @CharID
	if (@GuildID is not null and @GuildID <> 0)
	begin
		if (not exists (select ID from _Guild where ID = @GuildID))
		begin
			update _Char set GuildID = 0 where CharID = @CharID
		end
		else
		begin
			declare @Return_Del_GuildMember int
			exec @Return_Del_GuildMember = _Guild_DelMember_NoTX @GuildID, @CharID
			if (@Return_Del_GuildMember < 0)
				return -10003
		end
	end

	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
	--		APPLY_MENTOR_SYSTEM (أƒأ–أ€أژأˆ£) 
	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
	DECLARE @CampID INT
	SET @CampID = 0
	SELECT @CampID = CampID FROM _TrainingCampMember WHERE CharID = @CharID 
	IF (@CampID IS NOT NULL AND @CampID <> 0)
	BEGIN
		DECLARE @Ret_DelCampMember INT
		EXEC @Ret_DelCampMember = _TRAINING_CAMP_DELMEMBER @CampID, @CharID, 0
		IF (@Ret_DelCampMember < 0)
			RETURN -10007
	END

	-- أ€أ–أ€¸¸é أپأ¶آ؟أ¶¹أ¶¸®أ€أڑ~ ¹¹.
	DELETE FROM _TrainingCampSubMentorHonorPoint WHERE CharID = @CharID

	-- °أ¦أ‡èأ„آ، ¹أ¶أ‡أپ ·¹أ„أڑµأ¥µµ~~ ¤»¤»
	DELETE FROM _TrainingCampBuffStatus WHERE CampID = @CampID

	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
	--		APPLY_MENTOR_SYSTEM (أƒأ–أ€أژأˆ£) 
	--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

	-----------------------------------
	-- أ„£±¸ ¸®½آ؛أ†® »èأپ¦ ( ³آھأ€أ‡ أ„£±¸ ¸®½آ؛أ†® + أ„£±¸أ€أ‡ أ„£±¸ ¸®½آ؛أ†®أپأں ³آھ )
	-----------------------------------
	-- ³» أ„£±¸µé..
	declare @FriendCharID	int
	declare @cursor_var 	cursor
	
	set @cursor_var = cursor fast_forward
	for
	select FriendCharID
	from _Friend
	where CharID = @CharID
	
	open @cursor_var
	
	fetch next from @cursor_var into @FriendCharID
	
	while( @@FETCH_STATUS = 0 )
	begin
		delete _Friend where CharID = @FriendCharID and FriendCharID = @CharID
	
		fetch next from @cursor_var into @FriendCharID
	end
	close @cursor_var
	deallocate @cursor_var
	-- ³آھ..
	delete _Friend where CharID = @CharID
	-----------------------------------
	-----------------------------------
	-- أ‚أٹأپأ¶ »èأپ¦
	-----------------------------------
	delete _Memo where CharID = @CharID
	------------------------------------
	-- TimedJob »èأپ¦أ‡أڈ±â
	------------------------------------
	delete _TimedJob where CharID = @CharID
	------------------------------------
	-- Static Avatar أپ¤آ؛¸ »èأپ¦
	------------------------------------	
	delete from _staticavatar where charid = @charid
	------------------------------------
	-- ±أ“¸» آ؛أ*·° أپ¤آ؛¸ »èأپ¦
	------------------------------------	
	delete from _BlockedWhisperers where OwnerID = @charid	
	------------------------------------
	-- أ†أ„أ†¼أƒأٹ´ë آ؛أ*·° أپ¤آ؛¸ »èأپ¦ 10.06.07
	------------------------------------
	DELETE FROM _BlockedPartyInviter WHERE CharID = @charid	
	------------------------------------
	-- _DeletedChar Entry »èأپ¦
	------------------------------------
	delete from _DeletedChar where CharID = @CharID
	if (@@error <> 0)
	begin
		return -10004
	end
	-- start by novice.
	DELETE FROM _User WHERE UserJID = @UserJID and CharID = @CharID
	-- finish by novice.

	------------------------------------
	-- commit !!!
	------------------------------------
	
	-- أ…¬¶أ³أ€أŒ¾أ°أ†®آ؟ë أ„ü½½·أ” أپ¤آ؛¸ أ€أ؛أ€أ¥ أ…×أ€أŒآ؛أ* ³¯¸®±â!!!
	exec _RemoveClientConfig @CharID		-- by novice...... for saving client configurations...
	return @GuildID

[Dev.Ri3o]

##