Bug with ShardManager

[Chinaya]

http://i.epvpimg.com/v0R7d.jpg

حل المشكله 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]

##