Editting CHI and Jiang in database

01/04/2014 07:04 .Light#1

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

01/04/2014 10:06 The-Dreamer#2

BLOB is a byte array saved on mysql >> as far as i know :D
An easy way for editing it, is changing the values from the source and saving it again :D >> 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

Code:

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

and for showing them ..

Code:

 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 :)

01/04/2014 10:11 MeGaMaX#3

(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

[Only registered and activated users can see links. Click Here To Register...]

01/04/2014 11:23 abdoumatrix#4

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

01/05/2014 00:56 .Light#5

Quote:

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

01/05/2014 11:03 abdoumatrix#6

Quote:

Originally Posted by .Light

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

@matrixchi x x x

Spoiler