27-02-2013, 08:48 PM
|
#2
|
|
• الانـتـسـاب » Oct 2009
|
• رقـم العـضـويـة » 65207
|
• المشـــاركـات » 4,627
|
• الـدولـة » ¦♥~ G!Za ~♥¦
|
• الـهـوايـة » DeveloPer -DB-SQL-PK2 Edit- Anti DDOS ATACK
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 48
|
|
|
كود PHP:
USE [SRO_VT_SHARD] DECLARE @CharName Varchar (MAX) DECLARE @Graduates INT DECLARE @HonorPoints INT DECLARE @CharID INT DECLARE @CampID INT SET @CharName = '[GM]Mario$' SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID) SET @Graduates = '1234' SET @HonorPoints= @Graduates * 39
--------------------
UPDATE [Dbo].[_TrainingCamp] SET GraduateCount = @Graduates WHERE [Dbo].[_TrainingCamp].[ID] = @CampID UPDATE [dbo].[_TrainingCampMember] SET HonorPoint = @HonorPoints WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID
|
|
|