GM CrazyViper
29-12-2014, 08:12 PM
http://im58.gulfup.com/mLMTsm.png
النهارده جايب ليكم موضوع مهم
Get honor point by Job
بمعني اوضح انك لما تطلع Trade
hunter
Thief
بدل ما هتأخد جولد هتأخد Honor points
addlogchar
declare @jobtype int,@jobnames varchar(50)
set @jobtype=(select jobtype from SRO_VT_SHARD.._chartrijob where charid=@charid)
select @jobnames=case when @jobtype =1 then 'Trader'
when @jobtype=2 then 'Thief'
when @jobtype=3 then 'Hunter'
end
if @eventid in (4,6) and ((select contribution from SRO_VT_SHARD.._CharTrijob where CharID=@CharID) >=436657932) and ((select jobtype from SRO_VT_SHARD.._CharTrijob where CHARid=@CharID)>0)
begin
if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=1
begin
exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
insert into [dbo].[SaveTrade_Mr.x] (Charname,Charid,CampID,HonorPoints,TradeCount,Job Type) values ((select charname16 from SRO_VT_SHARD.._char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
end
if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
end
end
if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=2
begin
exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
insert into [dbo].[SaveTrade_Mr.x] (Charname,Charid,CampID,HonorPoints,TradeCount,Job Type) values ((select charname16 from SRO_VT_SHARD.._char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
end
if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
end
end
if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=3
begin
exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
insert into [dbo].[SaveTrade_Mr.x] (Charname,C_char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
end
if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
end
update SRO_VT_SHARD.._CharTrijob set Contribution=Contribution+1000 where CharID=@CharID
end
harid,CampID,HonorPoints,TradeCount,JobType) values ((select charname16 from SRO_VT_SHARD.. end
USE [DB_LOG]
GO
/****** Object: Table [dbo].[SaveTrade_Mr.x] Script Date: 12/29/2014 6:38:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SaveTrade_Mr.x](
[No] [int] IDENTITY(1,1) NOT NULL,
[Charname] [varchar](50) NULL,
[Charid] [bigint] NULL,
[CampID] [bigint] NULL,
[HonorPoints] [int] NULL,
[TradeCount] [bigint] NULL,
[JobType] [varchar](50) NULL,
CONSTRAINT [PK_SaveTrade_Mr.x] PRIMARY KEY CLUSTERED
(
[No] 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
النهارده جايب ليكم موضوع مهم
Get honor point by Job
بمعني اوضح انك لما تطلع Trade
hunter
Thief
بدل ما هتأخد جولد هتأخد Honor points
addlogchar
declare @jobtype int,@jobnames varchar(50)
set @jobtype=(select jobtype from SRO_VT_SHARD.._chartrijob where charid=@charid)
select @jobnames=case when @jobtype =1 then 'Trader'
when @jobtype=2 then 'Thief'
when @jobtype=3 then 'Hunter'
end
if @eventid in (4,6) and ((select contribution from SRO_VT_SHARD.._CharTrijob where CharID=@CharID) >=436657932) and ((select jobtype from SRO_VT_SHARD.._CharTrijob where CHARid=@CharID)>0)
begin
if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=1
begin
exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
insert into [dbo].[SaveTrade_Mr.x] (Charname,Charid,CampID,HonorPoints,TradeCount,Job Type) values ((select charname16 from SRO_VT_SHARD.._char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
end
if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
end
end
if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=2
begin
exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
insert into [dbo].[SaveTrade_Mr.x] (Charname,Charid,CampID,HonorPoints,TradeCount,Job Type) values ((select charname16 from SRO_VT_SHARD.._char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
end
if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
end
end
if (select jobtype from SRO_VT_SHARD.._CharTrijob where CharID=@CharID)=3
begin
exec SRO_VT_SHARD.._TRAINING_CAMP_CREATE @charid
update SRO_VT_SHARD.._CharTrijob set Contribution=0 where CharID=@CharID
update SRO_VT_SHARD.._TrainingCamp set EvaluationPoint+=10,GraduateCount+=10 where id in (Select campid from SRO_VT_SHARD.._TrainingCampMember where charid=@charid)
if not exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
insert into [dbo].[SaveTrade_Mr.x] (Charname,C_char where CharID=@CharID),@CharID,(select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID),(select GraduateCount from SRO_VT_SHARD.._TrainingCamp where id in (select campid from SRO_VT_SHARD.._TrainingCampMember where CharID=@CharID)),0,@jobnames)
end
if exists (select campid from [dbo].[SaveTrade_Mr.x] where Charid=@CharID)
begin
update [dbo].[SaveTrade_Mr.x] set TradeCount+=1,HonorPoints+=10 where Charid=@CharID
end
update SRO_VT_SHARD.._CharTrijob set Contribution=Contribution+1000 where CharID=@CharID
end
harid,CampID,HonorPoints,TradeCount,JobType) values ((select charname16 from SRO_VT_SHARD.. end
USE [DB_LOG]
GO
/****** Object: Table [dbo].[SaveTrade_Mr.x] Script Date: 12/29/2014 6:38:31 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SaveTrade_Mr.x](
[No] [int] IDENTITY(1,1) NOT NULL,
[Charname] [varchar](50) NULL,
[Charid] [bigint] NULL,
[CampID] [bigint] NULL,
[HonorPoints] [int] NULL,
[TradeCount] [bigint] NULL,
[JobType] [varchar](50) NULL,
CONSTRAINT [PK_SaveTrade_Mr.x] PRIMARY KEY CLUSTERED
(
[No] 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