المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : مشكله بسيطه


BonBOoony
23-12-2012, 11:54 AM
انا جربت الكوير بتاع ال honor رانك وبرده مش شغال ممكن اعرف ايه السبب ؟!

[GM]Tormentor
23-12-2012, 12:11 PM
عملت ذى الموضوع دوا USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '_2ReaiS_'
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

BonBOoony
23-12-2012, 12:30 PM
عملت ذى الموضوع دوا USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = '_2ReaiS_'
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

انا عيز اشغل الهونور رانك ازاى مش عايز احط لوحد باس buff

Bouken
23-12-2012, 01:39 PM
حط دول هنا

_TrainingCampHonorRank

1 NULL NULL
2 NULL NULL
3 NULL NULL
4 NULL NULL
5 NULL NULL
6 NULL NULL
7 NULL NULL
8 NULL NULL
9 NULL NULL
10 NULL NULL
11 NULL NULL
12 NULL NULL
13 NULL NULL
14 NULL NULL
15 NULL NULL
16 NULL NULL
17 NULL NULL
18 NULL NULL
19 NULL NULL
20 NULL NULL
21 NULL NULL
22 NULL NULL
23 NULL NULL
24 NULL NULL
25 NULL NULL
26 NULL NULL
27 NULL NULL
28 NULL NULL
29 NULL NULL
30 NULL NULL
31 NULL NULL
32 NULL NULL
33 NULL NULL
34 NULL NULL
35 NULL NULL
36 NULL NULL
37 NULL NULL
38 NULL NULL
39 NULL NULL
40 NULL NULL
41 NULL NULL
42 NULL NULL
43 NULL NULL
44 NULL NULL
45 NULL NULL
46 NULL NULL
47 NULL NULL
48 NULL NULL
49 NULL NULL
50 NULL NULL
NULL NULL NULL