X_Shadow
18-02-2015, 06:30 PM
السلام عليكم اعضاء s4a الكرام
النهاردة جايبلك System حلو كدة و ناس كتير نفسها تعملوا و هو معايا فــ قولت مش ابخل عليكوا..
الSystem ده عبارة عن:
لما تموت unique بيتحط فى table اللى هتعملها و اكتر واحد مموت unique هياخد reward title name من غير ما انت تديلوا يعنى automatic كدة..
و ممكن انت بخبرتك تديلوا item or silk :astroboy_h4h:
Create this table
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[Unique_Kill_Count_Joe] Script Date: 10/5/2014 5:00:52 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Unique_Kill_Count_Joe](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CharName] [varchar](64) NOT NULL,
[Counts] NOT NULL,
[lastUniqueKill] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Create this procedure
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[Unique_Count_Kill_Joe] Script Date: 10/5/2014 4:33:54 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[Unique_Count_Kill_Joe]
@CharName varchar(64)
AS
-- insert information :)
if not exists (select CharName from Unique_Kill_Count_Joe where CharName = @CharName)
begin
insert into Unique_Kill_Count_Joe (CharName,Counts,lastUniqueKill)
values (@CharName,1,GETDATE())
end
else if exists (select CharName from Unique_Kill_Count_Joe where CharName = @CharName)
begin
update Unique_Kill_Count_Joe set Counts = Counts +1, lastUniqueKill = GETDATE() where CharName = @CharName;
end
--- start giving the new title for the champion
DECLARE @TitleID int = Title Number
DECLARE @MaxCOunts bigint = (select MAX(Counts) from Unique_Kill_Count_Joe)
DECLARE @ChamCharName varchar(64) = (select TOP 1 CharName from Unique_Kill_Count_Joe where Counts = @MaxCOunts order by lastUniqueKill)
update SRO_VT_SHARD.dbo._Char set HwanLevel = 0 where HwanLevel = @TitleID
update SRO_VT_SHARD.dbo._Char set HwanLevel = @TitleID where CharName16 = @ChamCharName
كلمه شكرا تكفينى :mf_turban:[B] يارب يكون عجبكم
النهاردة جايبلك System حلو كدة و ناس كتير نفسها تعملوا و هو معايا فــ قولت مش ابخل عليكوا..
الSystem ده عبارة عن:
لما تموت unique بيتحط فى table اللى هتعملها و اكتر واحد مموت unique هياخد reward title name من غير ما انت تديلوا يعنى automatic كدة..
و ممكن انت بخبرتك تديلوا item or silk :astroboy_h4h:
Create this table
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[Unique_Kill_Count_Joe] Script Date: 10/5/2014 5:00:52 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Unique_Kill_Count_Joe](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CharName] [varchar](64) NOT NULL,
[Counts] NOT NULL,
[lastUniqueKill] [datetime] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Create this procedure
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[Unique_Count_Kill_Joe] Script Date: 10/5/2014 4:33:54 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[Unique_Count_Kill_Joe]
@CharName varchar(64)
AS
-- insert information :)
if not exists (select CharName from Unique_Kill_Count_Joe where CharName = @CharName)
begin
insert into Unique_Kill_Count_Joe (CharName,Counts,lastUniqueKill)
values (@CharName,1,GETDATE())
end
else if exists (select CharName from Unique_Kill_Count_Joe where CharName = @CharName)
begin
update Unique_Kill_Count_Joe set Counts = Counts +1, lastUniqueKill = GETDATE() where CharName = @CharName;
end
--- start giving the new title for the champion
DECLARE @TitleID int = Title Number
DECLARE @MaxCOunts bigint = (select MAX(Counts) from Unique_Kill_Count_Joe)
DECLARE @ChamCharName varchar(64) = (select TOP 1 CharName from Unique_Kill_Count_Joe where Counts = @MaxCOunts order by lastUniqueKill)
update SRO_VT_SHARD.dbo._Char set HwanLevel = 0 where HwanLevel = @TitleID
update SRO_VT_SHARD.dbo._Char set HwanLevel = @TitleID where CharName16 = @ChamCharName
كلمه شكرا تكفينى :mf_turban:[B] يارب يكون عجبكم