Caste Bug K5.2

Results 1 to 6 of 6
  1. #1
    Apprentice Itachi is offline
    MemberRank
    Aug 2016 Join Date
    7Posts

    Caste Bug K5.2

    Help please I was following hetero's tutorial for caste level but I got have problems
    My Rank00.txt and MRank00.txt doesn't update and I'm stuck at Waisya 1
    In my SQL Server 2008 R2
    TantraBackUp00 works fine
    GameInfo00 doesn't work
    ODBC has no problem

    my config.txt in SQLDAEMON is
    Tantra sa PASSWORD

    After a few mins after running DBSRV>MSGSRV>SQLDAEMON>ZONE1>ZONE6 only the TantraBackUp00 updates, there is no data in GameInfo00 and in Rank00.txt and MRank00.txt
    Attached Thumbnails Attached Thumbnails 3.jpg   2.jpg   1.jpg   0.jpg  


  2. #2
    Ronin Dev John is offline
    MemberRank
    Mar 2011 Join Date
    /dev/nullLocation
    382Posts

    Re: Caste Bug K5.2

    Test in a new query

    Code:
    USE Tantra;
    GO
    CREATE TRIGGER UpdateRank
        ON TantraBackup00
        AFTER INSERT,UPDATE,DELETE
    AS
        BEGIN
            DELETE FROM GameInfo00
            INSERT INTO GameInfo00
            SELECT
                UserID,
                CharacterName,
                CharacterLevel,
                BrahmanPoint,
                MBrahmanPoint,
                Tribe,
                Trimurity,
                GuildName,
                GuildID,
                GuildRank,
                curtime,
                Name1,
                Name2,
                Name3,
                Level1,
                Level2,
                Level3,
                TotalMoney
            FROM TantraBackup00
        END
    GO
    Last edited by John; 17-08-16 at 02:03 AM.

  3. #3
    Apprentice Itachi is offline
    MemberRank
    Aug 2016 Join Date
    7Posts

    Re: Caste Bug K5.2

    Quote Originally Posted by John View Post
    Test in a new query

    Code:
    USE Tantra;
    GO
    CREATE TRIGGER UpdateRank
        ON TantraBackup00
        AFTER INSERT,UPDATE,DELETE
    AS
        BEGIN
            DELETE FROM GameInfo00
            INSERT INTO GameInfo00
            SELECT
                UserID,
                CharacterName,
                CharacterLevel,
                BrahmanPoint,
                MBrahmanPoint,
                Tribe,
                Trimurity,
                GuildName,
                GuildID,
                GuildRank,
                curtime,
                Name1,
                Name2,
                Name3,
                Level1,
                Level2,
                Level3,
                TotalMoney
            FROM TantraBackup00
        END
    GO
    Thumbs up, thanks it seems I was missing the "MBrahmanpoint"

    Also I have another question, when I open my param on my GMTool I can see my mounts (tiger,white tiger etc) and their ID is 37401, but when I open my xml I cant see it, my param ends in 36537, where can I see the other ID's?

    P.S. I'm using the same TantraParam.tpa on my client,server and GMTool

    Thanks :)

  4. #4
    Apprentice asuarezv is offline
    MemberRank
    Aug 2016 Join Date
    9Posts

    Re: Caste Bug K5.2

    Quote Originally Posted by Itachi View Post
    Thumbs up, thanks it seems I was missing the "MBrahmanpoint"

    Also I have another question, when I open my param on my GMTool I can see my mounts (tiger,white tiger etc) and their ID is 37401, but when I open my xml I cant see it, my param ends in 36537, where can I see the other ID's?

    P.S. I'm using the same TantraParam.tpa on my client,server and GMTool

    Thanks :)
    Use Ctrl + B on your excel to search for that ID and enable options "in the book", "match the contents of the entire cell" and click "Find all", then click on each line of the result, you must run this search on your TantraParam and Clientres files.
    Attached Thumbnails Attached Thumbnails captura.png  

  5. #5
    Apprentice Itachi is offline
    MemberRank
    Aug 2016 Join Date
    7Posts

    Re: Caste Bug K5.2

    Quote Originally Posted by asuarezv View Post
    Use Ctrl + B on your excel to search for that ID and enable options "in the book", "match the contents of the entire cell" and click "Find all", then click on each line of the result, you must run this search on your TantraParam and Clientres files.

    Hi asuaresv, thank you for your response but when I did that nothing happened and I'm still frustrated about it because I found out that my Mauraba set, Adbaya Set, Sefar Weapons and Mounts are all hidden or encrypted or missing in my TantraParam.tpa

    Do you have a facebook so I can just PM you and provide screenshots?

  6. #6
    Apprentice asuarezv is offline
    MemberRank
    Aug 2016 Join Date
    9Posts

    Re: Caste Bug K5.2

    Quote Originally Posted by Itachi View Post
    Hi asuaresv, thank you for your response but when I did that nothing happened and I'm still frustrated about it because I found out that my Mauraba set, Adbaya Set, Sefar Weapons and Mounts are all hidden or encrypted or missing in my TantraParam.tpa

    Do you have a facebook so I can just PM you and provide screenshots?
    fb/GameMasterDragos



Advertisement