مشكله فى الهونر بف

[loverslove]

انا سيلفر pve الناس بتعمل هونر بف بس المشكله مش بيضافه فى list ولا بيجلهم بف ارجو الحل

[loverslove]

???

[Dev.Ri3o]

اعمل ال Query ده

USE SRO_VT_SHARD  
TRUNCATE TABLE _TrainingCampHonorRank  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)   
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29) 
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49)  
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50) 
exec _TRAINING_CAMP_UPDATEHONORRANK

[loverslove]

عملتها ومفيش فايده

[loverslove]

??

[Blizzard]

جرب ده طيب

كود PHP:

USE [SRO_VT_SHARD]
TRUNCATE TABLE [dbo].[_TrainingCampBuffStatus]
TRUNCATE TABLE [dbo].[_TrainingCampHonorRank]
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (1)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (2)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (3)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (4)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (5)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (6)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (7)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (8)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (9)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (10)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (11)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (12)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (13)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (14)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (15)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (16)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (17)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (18)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (19)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (20)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (21)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (22)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (23)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (24)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (25)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (26)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (27)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (28)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (29)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (30)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (31)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (32)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (33)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (34)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (35)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (36)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (37)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (38)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (39)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (40)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (41)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (42)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (43)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (44)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (45)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (46)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (47)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (48)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (49)
INSERT INTO [dbo].[_TrainingCampHonorRank](Ranking) VALUES (50)
EXEC [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
DELETE FROM [dbo].[_TrainingCamp] 


[loverslove]

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 547, Level 16, State 0, Line 55
The DELETE statement conflicted with the REFERENCE constraint "FK__TrainingCampMember__TrainingCamp". The conflict occurred in database "SRO_VT_SHARD", table "dbo._TrainingCampMember", column 'CampID'.
The statement has been terminated.

[loverslove]

ظبط الايرور المشكله عندى ان البيعمله بف اكاديمى مش بيجلهم بف يعنى مش بيتحط اسمهم اتوماتك فى _TrainingCampHonorRank ايه الحل بقى انا جبت اخرى فى الموضوع ده

[loverslove]

؟؟

[loverslove]

طب ايه الحل

[loverslove]

حل يا جدعان

[Dev.Ri3o]

هتخش على ال Database ال Clean وهتاخد منها ال Procedure بتاعة ال TrainingCamp وبدلها باللى عندك
واعمل ال Query ده

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]    Script Date: 06/03/2012 10:09:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_TRAINING_CAMP_UPDATEHONORRANK]
AS
    SET NOCOUNT ON

    -- ÀÏ´Ü ·©Å· Å×À̺íÀ» ¼¼ÆÃÇÑ´Ù.
    DECLARE @Ranking    INT
    SET @Ranking = 1

    DECLARE @CampID    INT
    DECLARE @Rank    TINYINT

BEGIN TRANSACTION

    DECLARE RankCursor CURSOR FAST_FORWARD FOR
    SELECT TOP 50 [ID] FROM _TrainingCamp WITH (NOLOCK)
    WHERE EvaluationPoint >= 10
    ORDER BY EvaluationPoint DESC, LatestEvaluationDate ASC

    -- ÀÏ´Ü Àüü ·©Å·À» ¾øÀ½À¸·Î Ç¥½ÃÇÏÀÚ.
    UPDATE _TrainingCamp SET Rank = 5 WHERE Rank <> 5
    IF (@@ERROR <> 0)
    BEGIN
        ROLLBACK TRANSACTION

        DEALLOCATE RankCursor
        RETURN -1
    END

    -- ·©Å· Å×ÀÌºíµµ ÃʱâÈ*ÇÏÀÚ.
    UPDATE _TrainingCampHonorRank SET CampID = null, Rank = null
    IF (@@ERROR <> 0)
    BEGIN
        ROLLBACK TRANSACTION

        DEALLOCATE RankCursor
        RETURN -1
    END

    OPEN RankCursor
    FETCH NEXT FROM RankCursor INTO @CampID
    WHILE @@FETCH_STATUS = 0
    BEGIN
        IF @Ranking <= 5
        BEGIN
            SET @Rank = 1
        END
        ELSE IF @Ranking <= 15
        BEGIN
            SET @Rank = 2
        END
        ELSE IF @Ranking <= 30
        BEGIN
            SET @Rank = 3
        END
        ELSE
        BEGIN
            SET @Rank = 4
        END

        UPDATE _TrainingCamp SET Rank = @Rank WHERE [ID] = @CampID    
        IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
        BEGIN
            ROLLBACK TRANSACTION
            CLOSE RankCursor
            DEALLOCATE RankCursor

            RETURN -2
        END
        UPDATE _TrainingCampHonorRank SET CampID = @CampID, Rank = @Rank WHERE Ranking = @Ranking    
        IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
        BEGIN
            ROLLBACK TRANSACTION
            CLOSE RankCursor
            DEALLOCATE RankCursor

            RETURN -3
        END 
        
        SET @Ranking = @Ranking + 1

        FETCH NEXT FROM RankCursor INTO @CampID
    END

    CLOSE RankCursor
    DEALLOCATE RankCursor

    -- ¸¶Áö¸·À¸·Î °»½ÅÇÑ ³¯Â¥¸¦ Àû¾îº¸ÀÚ!!!
    IF EXISTS (SELECT LastUpdateDate FROM _TrainingCampHonorRankUpdateDate)
    BEGIN
        UPDATE _TrainingCampHonorRankUpdateDate SET LastUpdateDate = GETDATE()
    END
    ELSE
    BEGIN
        INSERT INTO _TrainingCampHonorRankUpdateDate VALUES (GETDATE())
    END

    IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN -4
    END

COMMIT TRANSACTION

    SET NOCOUNT OFF

    RETURN 1

[loverslove]

معلش معنديش داتا كلين اعمل ايه ؟ ممكن تجبلى بعد ازنك