[xerk]

ممكن توضح سؤالك يعنى ايه بيسافر من مدينه لاخرى لو قصدك من جوه التون يبقى بص على _RefTeleport
وى
_RefTeleLink

غير كده ارجو توضحلى
وى بنسبه لعدم مسح الاكونت خد ده ضيفه عندك وى هيتمسح عادى بعد 7 ايام

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_DeleteCharTemporal]    Script Date: 7/31/2018 8:46:10 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
---------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[_DeleteCharTemporal]
@UserJID	as 	int,
-- @CharSlot	as 	int
@char_id_to_del as int
as
	------------------------------------
	-- step1. ى‌¼ë‹¨ ى؛گë¦*ى‌´ ى،´ى‍¬ي•کëٹ”ى§€ 부ي„° ê²€ى‚¬!
	------------------------------------
--	declare @char_id_to_del	 	int
--	set @char_id_to_del = 0
	/* -- commented by novice. for server integration.
	if (@CharSlot = 0)
		begin	select @char_id_to_del = CharID1 from _User with (nolock) where UserJID = @UserJID end
	else if (@CharSlot = 1)
		begin	select @char_id_to_del = CharID2 from _User with (nolock) where UserJID = @UserJID end
	else if (@CharSlot = 2)
		begin	select @char_id_to_del = CharID3 from _User with (nolock) where UserJID = @UserJID end
	else
		begin
			return -1
		end
	*/
	------------------------------------
	-- step2. 너 ى„¤ë§ˆ dummy character를 ى§€ىڑ°ê³* ى‹¶ى‌€ê²Œëƒگ? -_-+
	------------------------------------
	if (@char_id_to_del = 0)
	begin
		return -2
	end
	------------------------------------
	-- step3. ى™œ! ى§€ىڑ´ ê±° ëکگ ى§€ىڑ¸ë‌¼êµ¬?
	-- 0: ى*•ىƒپ ى؛گë¦*
	-- 1: ى‍„ى‹œ ى‚*ى*œ
	------------------------------------
	declare @is_deleted	tinyint
	select @is_deleted = deleted from _char where charid = @char_id_to_del
	if (@is_deleted <> 0)
	begin
		return -3
	end
	
begin transaction
	------------------------------------
	-- step4. recycle bin ى—گ ë„£ى–´ى£¼ê³*...
	------------------------------------
	insert _DeletedChar values(@char_id_to_del, @UserJID, GetDate())
	if (@@error <> 0)
	begin
		rollback transaction
		return -4
	end
	
	------------------------------------
	-- step5. ى‍„ى‹œ ى‚*ى*œëگ¬ë‹¤êµ¬ ي‘œى‹œي•´ë‘گى‍گ.
	------------------------------------
	update _Char set deleted = 1 where CharID = @char_id_to_del
	if (@@error <> 0)
	begin
		rollback transaction
		return -5
	end
	------------------------------------
	-- step6. commit !!!
	------------------------------------
	commit transaction
	
	return 1