ممكن توضح سؤالك يعنى ايه بيسافر من مدينه لاخرى لو قصدك من جوه التون يبقى بص على _RefTeleport
وى
_RefTeleLink
غير كده ارجو توضحلى
وى بنسبه لعدم مسح الاكونت خد ده ضيفه عندك وى هيتمسح عادى بعد 7 ايام
كود بلغة HTML:
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