طلب

[Dev.Ri3o]

مفيش مشكلة انت هتشغل ال Vsro Multi Tool وبالتسبة انو يرجع لل PLayer ال Old Title الى كان معاه اما تشيل منو Title ال Auto Billionarie
هتعمل ال Table ده

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_OldTitles]    Script Date: 24/03/2016 09:50:27 أ• ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_OldTitles](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[CharName] [varchar](50) NOT NULL,
	[OldHwan] [int] NULL,
	[UName] [varchar](50) NULL,
 CONSTRAINT [PK__OldTitles] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

وبعد كدة تحط ال Procedure ده فى Memo_Add

 If  (@TargetCharName like 'TesT' and @message = 'Back My Title')  
 begin 
 DECLARE @OLDHWAN int = (Select OldHwan From [SRO_VT_SHARDLOG].[dbo].[_OldTitles] where CharName = @SenderCharName) 
 UPDATE [SRO_VT_SHARD].[dbo].[_Char] Set HwanLevel = @OLDHWAN where CharName16=@SenderCharName 
 Insert Into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@SenderCharName,'Plz Teleport To Get ur Old Title',Getdate())   
end

وهتشيل السطر ده من ال Procedure بتاع Auto Billionaire System

Update SH_OWOJuStiCe.dbo._Char Set HwanLevel = '0' Where HwanLevel = 'your Billionaire number' and not CharID = @CharID And HwanLevel not in (Team Titlename Number,Team Titlename Number,Team Titlename Number)