[Mahmoud Rashwan]

SRO_VT_SHARDLOG-->Programmability-->Stored Procedure-->AddLogCher

كود PHP:

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,JobType)*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,JobType)*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*f
rom*SRO_VT_SHARD..****end* 


2-New Query

كود PHP:

USE*[SRO_VT_SHARDLOG]
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*