الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   مشكلة في Academy (https://silkroad4arab.com/vb/showthread.php?t=634778)

BlackClover 11-05-2020 06:40 PM
مشكلة في Academy
 
ندي مشكلة في الاكاديمي مش شغال عندي في السيرفر لما بدوس ع Academy Establishment بيسالني هتعمل اكاديمي for 100k ؟ بدوس نعم ! بس ما فيش حاجة بتحصل ولا فيه ايه form party بيتعمل
حد عنده خلفية اصلها ازاي ؟

MrGame3 11-05-2020 07:44 PM
رد: مشكلة في Academy
 
استخدم كويري ده
اقتباس:
TRUNCATE TABLE _TrainingCampHonorRank
GO
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)
في shard
و ده كمان
اقتباس:
exec _TRAINING_CAMP_UPDATEHONORRANK

BlackClover 11-05-2020 08:09 PM
رد: مشكلة في Academy
 
اقتباس:
المشاركة الأصلية كتبت بواسطة MrGame3 (المشاركة 5379779)
استخدم كويري ده

في shard
و ده كمان
تمام هجرب

BlackClover 11-05-2020 09:15 PM
رد: مشكلة في Academy
 
نفس المشكلة

MrGame3 12-05-2020 02:24 AM
رد: مشكلة في Academy
 
رسترت الجيم ؟

جرب ده
اقتباس:
TRUNCATE TABLE _TrainingCampHonorRank
DECLARE @num INT;
set @num = 1;
WHILE @num <= 50
BEGIN
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (@num)
SET @num = @num+1;
END;
exec _TRAINING_CAMP_UPDATEHONORRANK

BlackClover 12-05-2020 02:41 AM
رد: مشكلة في Academy
 
اقتباس:
المشاركة الأصلية كتبت بواسطة MrGame3 (المشاركة 5379790)
رسترت الجيم ؟

جرب ده
نفس المشكلة حضرتك
طيب academy ليها txt في الميديا ممكن يتعدل عليه ولا db بس ؟

BlackClover 12-05-2020 04:10 AM
رد: مشكلة في Academy
 
اتحلت الحمد لله
عملت الكوري دي واشتغلت

كود:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_TRAINING_CAMP_CREATE]    Script Date: 3/6/2017 7:20:20 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_TRAINING_CAMP_CREATE]
    @CreaterID    INT
AS
    SET NOCOUNT ON

    IF EXISTS (SELECT CharID FROM _TrainingCampMember WHERE CharID = @CreaterID)
    BEGIN
        RETURN -1001
    END

    DECLARE @CampID        INT
    DECLARE @FoundationDate    SMALLDATETIME
    SET @FoundationDate = GETDATE()

BEGIN TRANSACTION

    DECLARE @HonorPoint INT
    SET @HonorPoint = 0
    SELECT @HonorPoint = HonorPoint FROM _TrainingCampSubMentorHonorPoint WHERE CharID = @CreaterID   
   
    IF @HonorPoint <> 0
    BEGIN
        DELETE FROM _TrainingCampSubMentorHonorPoint WHERE  CharID = @CreaterID   
        IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
        BEGIN
            ROLLBACK TRANSACTION
            RETURN -6
        END
    END

    INSERT INTO _TrainingCamp (CreationDate, Rank, GraduateCount, EvaluationPoint,  LatestEvaluationDate, CommentTitle, Comment )
    VALUES ( @FoundationDate, 5, 0, 0,  @FoundationDate, '', '')

    SET @CampID = @@IDENTITY

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

    DECLARE @Ret INT
    EXEC @Ret = _TrainingCamp_FnAddMember  @CampID, @CreaterID, @HonorPoint
    IF (@@ERROR <> 0 OR @Ret <= 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN @Ret
    END

COMMIT TRANSACTION

    SET NOCOUNT OFF

    RETURN @CampID
شكرا MrGame3 للمتابعة معايا

MrGame3 12-05-2020 09:39 AM
رد: مشكلة في Academy
 
اقتباس:
المشاركة الأصلية كتبت بواسطة BlackClover (المشاركة 5379795)
اتحلت الحمد لله
عملت الكوري دي واشتغلت

كود:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_TRAINING_CAMP_CREATE]    Script Date: 3/6/2017 7:20:20 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_TRAINING_CAMP_CREATE]
    @CreaterID    INT
AS
    SET NOCOUNT ON

    IF EXISTS (SELECT CharID FROM _TrainingCampMember WHERE CharID = @CreaterID)
    BEGIN
        RETURN -1001
    END

    DECLARE @CampID        INT
    DECLARE @FoundationDate    SMALLDATETIME
    SET @FoundationDate = GETDATE()

BEGIN TRANSACTION

    DECLARE @HonorPoint INT
    SET @HonorPoint = 0
    SELECT @HonorPoint = HonorPoint FROM _TrainingCampSubMentorHonorPoint WHERE CharID = @CreaterID   
   
    IF @HonorPoint <> 0
    BEGIN
        DELETE FROM _TrainingCampSubMentorHonorPoint WHERE  CharID = @CreaterID   
        IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
        BEGIN
            ROLLBACK TRANSACTION
            RETURN -6
        END
    END

    INSERT INTO _TrainingCamp (CreationDate, Rank, GraduateCount, EvaluationPoint,  LatestEvaluationDate, CommentTitle, Comment )
    VALUES ( @FoundationDate, 5, 0, 0,  @FoundationDate, '', '')

    SET @CampID = @@IDENTITY

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

    DECLARE @Ret INT
    EXEC @Ret = _TrainingCamp_FnAddMember  @CampID, @CreaterID, @HonorPoint
    IF (@@ERROR <> 0 OR @Ret <= 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN @Ret
    END

COMMIT TRANSACTION

    SET NOCOUNT OFF

    RETURN @CampID
شكرا MrGame3 للمتابعة معايا
اهو بنساعد بعض بما أن المشرفين والمديرين مش موجودين


الساعة الآن 01:25 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.