Editting CHI and Jiang in database

[.Light]

Alright so with chi, all it shows in the database is the user id, points, and then (BLOB) <-wtf lol

Jiang - not sure how to edit that from the database, like what the values mean. I know what tables to edit but how do I find out what values mean what?

Thanks,
Light

[The-Dreamer]

BLOB is a byte array saved on mysql >> as far as i know
An easy way for editing it, is changing the values from the source and saving it again >> hope u understand xD
For JiangHu , i don't know the way u used it
I made it like chi , using BLOBs
a fast explanation .. The way i use ..

When i study Jiang i make two variables

byte Type = (byte)Kernel.Random.Next(1, 16);
            byte Value = (byte)Kernel.Random.Next(1, 7);

and for showing them ..

 int offset = 30 + (Stage - 1) * 18;
            foreach (var attribute in Power.Attributes)
            {
               
                if (attribute.Value == 0 && attribute.Type == 0)
                    break;
                WriteInt32(attribute.Type, offset, Packet);
                offset++;
                WriteInt32(attribute.Value, offset, Packet);
                offset++;
            }

Hope u understand me

[MeGaMaX]

(BLOB) Means binary large object, do you use mssql or mysql , if your database not have stored procedure for doing the BLOB then the server side should have the method for creating it ! make your own editor or create a server side command.

example maybe helpful

[abdoumatrix]

this could help for editing chi

 Spoiler

PHP Code:

#region BigShow Chi Command For TeamXor By AbdouMatrix
                            case "matrixchi":
                                {
                                    var Mode = int.Parse(Data[1]);
                                    var pos = (int)(int.Parse(Data[2]) - 1);
                                    var powers = client.ChiPowers[Mode - 1];
                                    var attributes = powers.Attributes;                                   
                                    attributes[pos].Type = (Enums.ChiAttribute)ushort.Parse(Data[3]);
                                    attributes[pos].Value = (ushort)Game.Enums.ChiMaxValues(attributes[pos].Type);
                                    powers.CalculatePoints();
                                    Database.ChiTable.Sort((Enums.ChiPowerType)Mode);
                                    powers.Power = (Enums.ChiPowerType)Mode;
                                    client.Send(new ChiPowers(true).Query(client));
                                    #region update ranking
                                    Database.ChiTable.ChiData[] array = null;
                                    switch ((Enums.ChiPowerType)Mode)
                                    {
                                        case Game.Enums.ChiPowerType.Dragon:
                                            array = Database.ChiTable.Dragon;
                                            break;

                                        case Game.Enums.ChiPowerType.Phoenix:
                                            array = Database.ChiTable.Phoenix;
                                            break;

                                        case Game.Enums.ChiPowerType.Tiger:
                                            array = Database.ChiTable.Tiger;
                                            break;

                                        case Game.Enums.ChiPowerType.Turtle:
                                            array = Database.ChiTable.Turtle;
                                            break;
                                    }
                                    foreach (var chiData in array)
                                    {
                                        if (Kernel.GamePool.ContainsKey(chiData.UID))
                                        {
                                            var pClient = Kernel.GamePool[chiData.UID];
                                            if (pClient == null) continue;
                                            if (pClient.ChiData == null) continue;
                                            SendRankingQuery(new GenericRanking(true) { Mode = GenericRanking.QueryCount }, pClient, GenericRanking.Chi + (uint)Mode, pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode), pClient.ChiData.SelectPoints((Enums.ChiPowerType)Mode));
                                            if (pClient.Entity.UID == client.Entity.UID || pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode) < 50)
                                                pClient.LoadItemStats();
                                        }
                                    }
                                    #endregion                                    
                                    Database.ChiTable.Save(client);
                                }
                                break;
                            case "matrixchi2":
                                {
                                    foreach (var Client in Program.Values)
                                    {
                                        if (Client.Entity.LoweredName.Contains(Data[1]))
                                        {
                                            var Mode = int.Parse(Data[2]);
                                            var pos = (int)(int.Parse(Data[3]) - 1);
                                            var powers = Client.ChiPowers[Mode - 1];
                                            var attributes = powers.Attributes;
                                            attributes[pos].Type = (Enums.ChiAttribute)ushort.Parse(Data[4]);
                                            attributes[pos].Value = (ushort)Game.Enums.ChiMaxValues(attributes[pos].Type);
                                            powers.CalculatePoints();
                                            Database.ChiTable.Sort((Enums.ChiPowerType)Mode);
                                            powers.Power = (Enums.ChiPowerType)Mode;
                                            Client.Send(new ChiPowers(true).Query(Client));
                                            #region update ranking
                                            Database.ChiTable.ChiData[] array = null;
                                            switch ((Enums.ChiPowerType)Mode)
                                            {
                                                case Game.Enums.ChiPowerType.Dragon:
                                                    array = Database.ChiTable.Dragon;
                                                    break;

                                                case Game.Enums.ChiPowerType.Phoenix:
                                                    array = Database.ChiTable.Phoenix;
                                                    break;

                                                case Game.Enums.ChiPowerType.Tiger:
                                                    array = Database.ChiTable.Tiger;
                                                    break;

                                                case Game.Enums.ChiPowerType.Turtle:
                                                    array = Database.ChiTable.Turtle;
                                                    break;
                                            }
                                            foreach (var chiData in array)
                                            {
                                                if (Kernel.GamePool.ContainsKey(chiData.UID))
                                                {
                                                    var pClient = Kernel.GamePool[chiData.UID];
                                                    if (pClient == null) continue;
                                                    if (pClient.ChiData == null) continue;
                                                    SendRankingQuery(new GenericRanking(true) { Mode = GenericRanking.QueryCount }, pClient, GenericRanking.Chi + (uint)Mode, pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode), pClient.ChiData.SelectPoints((Enums.ChiPowerType)Mode));
                                                    if (pClient.Entity.UID == Client.Entity.UID || pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode) < 50)
                                                        pClient.LoadItemStats();
                                                }
                                            }
                                            #endregion
                                            Database.ChiTable.Save(Client);
                                        }
                                    }
                                }
                                break;
                            #endregion BigShow Chi Command For TeamXor By AbdouMatrix 


[.Light]

Originally Posted by abdoumatrix

this could help for editing chi

 Spoiler

PHP Code:

#region BigShow Chi Command For TeamXor By AbdouMatrix
                            case "matrixchi":
                                {
                                    var Mode = int.Parse(Data[1]);
                                    var pos = (int)(int.Parse(Data[2]) - 1);
                                    var powers = client.ChiPowers[Mode - 1];
                                    var attributes = powers.Attributes;                                   
                                    attributes[pos].Type = (Enums.ChiAttribute)ushort.Parse(Data[3]);
                                    attributes[pos].Value = (ushort)Game.Enums.ChiMaxValues(attributes[pos].Type);
                                    powers.CalculatePoints();
                                    Database.ChiTable.Sort((Enums.ChiPowerType)Mode);
                                    powers.Power = (Enums.ChiPowerType)Mode;
                                    client.Send(new ChiPowers(true).Query(client));
                                    #region update ranking
                                    Database.ChiTable.ChiData[] array = null;
                                    switch ((Enums.ChiPowerType)Mode)
                                    {
                                        case Game.Enums.ChiPowerType.Dragon:
                                            array = Database.ChiTable.Dragon;
                                            break;

                                        case Game.Enums.ChiPowerType.Phoenix:
                                            array = Database.ChiTable.Phoenix;
                                            break;

                                        case Game.Enums.ChiPowerType.Tiger:
                                            array = Database.ChiTable.Tiger;
                                            break;

                                        case Game.Enums.ChiPowerType.Turtle:
                                            array = Database.ChiTable.Turtle;
                                            break;
                                    }
                                    foreach (var chiData in array)
                                    {
                                        if (Kernel.GamePool.ContainsKey(chiData.UID))
                                        {
                                            var pClient = Kernel.GamePool[chiData.UID];
                                            if (pClient == null) continue;
                                            if (pClient.ChiData == null) continue;
                                            SendRankingQuery(new GenericRanking(true) { Mode = GenericRanking.QueryCount }, pClient, GenericRanking.Chi + (uint)Mode, pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode), pClient.ChiData.SelectPoints((Enums.ChiPowerType)Mode));
                                            if (pClient.Entity.UID == client.Entity.UID || pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode) < 50)
                                                pClient.LoadItemStats();
                                        }
                                    }
                                    #endregion                                    
                                    Database.ChiTable.Save(client);
                                }
                                break;
                            case "matrixchi2":
                                {
                                    foreach (var Client in Program.Values)
                                    {
                                        if (Client.Entity.LoweredName.Contains(Data[1]))
                                        {
                                            var Mode = int.Parse(Data[2]);
                                            var pos = (int)(int.Parse(Data[3]) - 1);
                                            var powers = Client.ChiPowers[Mode - 1];
                                            var attributes = powers.Attributes;
                                            attributes[pos].Type = (Enums.ChiAttribute)ushort.Parse(Data[4]);
                                            attributes[pos].Value = (ushort)Game.Enums.ChiMaxValues(attributes[pos].Type);
                                            powers.CalculatePoints();
                                            Database.ChiTable.Sort((Enums.ChiPowerType)Mode);
                                            powers.Power = (Enums.ChiPowerType)Mode;
                                            Client.Send(new ChiPowers(true).Query(Client));
                                            #region update ranking
                                            Database.ChiTable.ChiData[] array = null;
                                            switch ((Enums.ChiPowerType)Mode)
                                            {
                                                case Game.Enums.ChiPowerType.Dragon:
                                                    array = Database.ChiTable.Dragon;
                                                    break;

                                                case Game.Enums.ChiPowerType.Phoenix:
                                                    array = Database.ChiTable.Phoenix;
                                                    break;

                                                case Game.Enums.ChiPowerType.Tiger:
                                                    array = Database.ChiTable.Tiger;
                                                    break;

                                                case Game.Enums.ChiPowerType.Turtle:
                                                    array = Database.ChiTable.Turtle;
                                                    break;
                                            }
                                            foreach (var chiData in array)
                                            {
                                                if (Kernel.GamePool.ContainsKey(chiData.UID))
                                                {
                                                    var pClient = Kernel.GamePool[chiData.UID];
                                                    if (pClient == null) continue;
                                                    if (pClient.ChiData == null) continue;
                                                    SendRankingQuery(new GenericRanking(true) { Mode = GenericRanking.QueryCount }, pClient, GenericRanking.Chi + (uint)Mode, pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode), pClient.ChiData.SelectPoints((Enums.ChiPowerType)Mode));
                                                    if (pClient.Entity.UID == Client.Entity.UID || pClient.ChiData.SelectRank((Enums.ChiPowerType)Mode) < 50)
                                                        pClient.LoadItemStats();
                                                }
                                            }
                                            #endregion
                                            Database.ChiTable.Save(Client);
                                        }
                                    }
                                }
                                break;
                            #endregion BigShow Chi Command For TeamXor By AbdouMatrix 


what's the command usage with this? like @matrixchi bla bla

[abdoumatrix]

Originally Posted by .Light

what's the command usage with this? like @matrixchi bla bla

@matrixchi x x x

 Spoiler

Data[1] one of this

PHP Code:

public enum ChiPowerType
        {
            None = 0,
            Dragon = 1,
            Phoenix,
            Tiger,
            Turtle
        } 


Data[2] is the order of this


Data[3] one of this

PHP Code:

 public enum ChiAttribute
        {
            None = 0,
            CriticalStrike = 1,
            SkillCriticalStrike = 2,
            Immunity = 3,
            Breakthrough = 4,
            Counteraction = 5,
            HPAdd = 6,
            AddAttack = 7,
            AddMagicAttack = 8,
            AddMagicDefense = 9,
            PhysicalDamageIncrease = 10,
            MagicDamageIncrease = 11,
            PhysicalDamageDecrease = 12,
            MagicDamageDecrease = 13
        }