مشكله فى التريده

[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

[ModySe]

اه بيحمل التريده وبيسافرمن جوا المدينه