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

[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]

جرب ده طيب

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]

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