- Joined
- Dec 10, 2011
- Messages
- 477
- Reaction score
- 27
First of all, my English is poor,
1, you need to play in the game for a period of time and complete those tasks to achieve certain achievements and get some Ruby icons(blue icon)
or you can run sql command in mssql:
------------
SET IDENTITY_INSERT ICARUS_Char_Database.dbo.Table_CharItem ON
INSERT INTO [dbo].[Table_CharItem]([Owner], [Slot], [Deleted], [ItemSerial], [StrRecordKind], [Account], [RecId], [Amount], [ClientSlot], [ClientEquip], [Durability], [ReinforceLevel], [SellerDbKey], [SellerName], [SellPrice], [RegisterDate], [SoldDate], [bSold], [MailDbKey], [Belong], [RemoveBelongCount], [Quality], [Storage], [FellowDbKey], [Toggle], [Color], [SubColor], [ProducerName], [ROEffect01], [ROEffectValue01], [ROEffect02], [ROEffectValue02], [ROEffect03], [ROEffectValue03], [ROEffect04], [ROEffectValue04], [ROEffect05], [ROEffectValue05], [ROEffect06], [ROEffectValue06], [SealedFellowEffect01], [SealedFellowEValue01], [SealedFellowEffect02], [SealedFellowEValue02], [SealedFellowSlotCount], [SealedFellow01], [SealedFellow01_Effect01], [SealedFellow01_EValue01], [SealedFellow01_Effect02], [SealedFellow01_EValue02], [SealedFellow02], [SealedFellow02_Effect01], [SealedFellow02_EValue01], [SealedFellow02_Effect02], [SealedFellow02_EValue02], [SealedFellow03], [SealedFellow03_Effect01], [SealedFellow03_EValue01], [SealedFellow03_Effect02], [SealedFellow03_EValue02], [ExpirationDate], [CharItemID], [ItemGrade], [bSeize], [SealedFellowEffect03], [SealedFellowEValue03], [SealedFellow01_Effect03], [SealedFellow01_EValue03], [SealedFellow02_Effect03], [SealedFellow02_EValue03], [SealedFellow03_Effect03], [SealedFellow03_EValue03], [SealedFellowEffect04], [SealedFellowEValue04], [SealedFellow01_Effect04], [SealedFellow01_EValue04], [SealedFellow02_Effect04], [SealedFellow02_EValue04], [SealedFellow03_Effect04], [SealedFellow03_EValue04], [SealedFellow01_ExpirationDate], [SealedFellow02_ExpirationDate], [SealedFellow03_ExpirationDate], [CarvedPeriodDate], [OverriseCount], [ReverseReinforceAttemptCount], [ReverseReinforceCount], [ROEffect07], [ROEffectValue07], [SealedFellow04], [SealedFellow04_Effect01], [SealedFellow04_EValue01], [SealedFellow04_Effect02], [SealedFellow04_EValue02], [SealedFellow04_Effect03], [SealedFellow04_EValue03], [SealedFellow04_Effect04], [SealedFellow04_EValue04], [SealedFellow04_ExpirationDate], [SealedFellow01_ReinforceLv], [SealedFellow02_ReinforceLv], [SealedFellow03_ReinforceLv], [SealedFellow04_ReinforceLv]) VALUES (1, 91, 0, 657129996292, 'in', 0, 'CA_IT_BP_0062', 1, 5, '*', 0, 0, 0, N'*', 0, '2021-02-23 20:29:51.817', '2021-02-23 20:29:51.817', 0, 0, 0, 0, 0, 'cr', 0, 0, 0, 0, N'', '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, 0, '*', '*', 0, '*', 0, '*', '*', 0, '*', 0, '*', '*', 0, '*', 0, '2000-01-01 00:00:00.000', 268, 'normal', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '2000-01-01 00:00:00.000', '2000-01-01 00:00:00.000', '2000-01-01 00:00:00.000', '2000-01-01 00:00:00.000', 0, 0, 0, '*', 0, '*', '*', 0, '*', 0, '*', 0, '*', 0, '2000-01-01 00:00:00.000', 0, 0, 0, 0);
----------
the VALUES (1 1 is the owner DBKey in ICARUS_Char_Database.Table_CharBase
IF you earn som ruby icon in your backbag,you can run this sql command:
SET IDENTITY_INSERT ICARUS_Char_Database.dbo.Table_CharItem ON
UPDATE Table_CharItem SET Amount = Amount + 5000 WHERE OWNER ='1' AND RecId = 'ry_0_0000'
-------
the better way is get ruby coin at first and then to change it in sql's table
2.open your ICARUS_User_Database.Table_CashShopAll
look the selltype,change all cash to ruby
look the rubycost,change all 0 to 1
look the cashcost,change all 1 to 0
this is all , restart your server and client,have fun
====================
btw:
i want to know how to add goods in shop ,
i had try this:add goods in Table_CashShopAll and Table_CashShopSell is not ok,
it not show at client,maybe we need fix something in .bin files.
Don't change the value in the database directly,
he will only have the following results:
1.Everything will be restored after login, such as the modification of some attribute points
2.Nothing will take effect, such as modifying runspeed walkspeed and so on
3.Fatal error, it will be a tragedy, the game will show the character data error, code 330
Many times, even if you restore the modified things, it will not change the result
The character has been abandoned.
Especially with the modification of money, it is easy to have this problem.
Therefore, we need a gmtool to modify the game data more safely. Unfortunately, gmserver is not in it. It has been deleted
1, you need to play in the game for a period of time and complete those tasks to achieve certain achievements and get some Ruby icons(blue icon)
or you can run sql command in mssql:
------------
SET IDENTITY_INSERT ICARUS_Char_Database.dbo.Table_CharItem ON
INSERT INTO [dbo].[Table_CharItem]([Owner], [Slot], [Deleted], [ItemSerial], [StrRecordKind], [Account], [RecId], [Amount], [ClientSlot], [ClientEquip], [Durability], [ReinforceLevel], [SellerDbKey], [SellerName], [SellPrice], [RegisterDate], [SoldDate], [bSold], [MailDbKey], [Belong], [RemoveBelongCount], [Quality], [Storage], [FellowDbKey], [Toggle], [Color], [SubColor], [ProducerName], [ROEffect01], [ROEffectValue01], [ROEffect02], [ROEffectValue02], [ROEffect03], [ROEffectValue03], [ROEffect04], [ROEffectValue04], [ROEffect05], [ROEffectValue05], [ROEffect06], [ROEffectValue06], [SealedFellowEffect01], [SealedFellowEValue01], [SealedFellowEffect02], [SealedFellowEValue02], [SealedFellowSlotCount], [SealedFellow01], [SealedFellow01_Effect01], [SealedFellow01_EValue01], [SealedFellow01_Effect02], [SealedFellow01_EValue02], [SealedFellow02], [SealedFellow02_Effect01], [SealedFellow02_EValue01], [SealedFellow02_Effect02], [SealedFellow02_EValue02], [SealedFellow03], [SealedFellow03_Effect01], [SealedFellow03_EValue01], [SealedFellow03_Effect02], [SealedFellow03_EValue02], [ExpirationDate], [CharItemID], [ItemGrade], [bSeize], [SealedFellowEffect03], [SealedFellowEValue03], [SealedFellow01_Effect03], [SealedFellow01_EValue03], [SealedFellow02_Effect03], [SealedFellow02_EValue03], [SealedFellow03_Effect03], [SealedFellow03_EValue03], [SealedFellowEffect04], [SealedFellowEValue04], [SealedFellow01_Effect04], [SealedFellow01_EValue04], [SealedFellow02_Effect04], [SealedFellow02_EValue04], [SealedFellow03_Effect04], [SealedFellow03_EValue04], [SealedFellow01_ExpirationDate], [SealedFellow02_ExpirationDate], [SealedFellow03_ExpirationDate], [CarvedPeriodDate], [OverriseCount], [ReverseReinforceAttemptCount], [ReverseReinforceCount], [ROEffect07], [ROEffectValue07], [SealedFellow04], [SealedFellow04_Effect01], [SealedFellow04_EValue01], [SealedFellow04_Effect02], [SealedFellow04_EValue02], [SealedFellow04_Effect03], [SealedFellow04_EValue03], [SealedFellow04_Effect04], [SealedFellow04_EValue04], [SealedFellow04_ExpirationDate], [SealedFellow01_ReinforceLv], [SealedFellow02_ReinforceLv], [SealedFellow03_ReinforceLv], [SealedFellow04_ReinforceLv]) VALUES (1, 91, 0, 657129996292, 'in', 0, 'CA_IT_BP_0062', 1, 5, '*', 0, 0, 0, N'*', 0, '2021-02-23 20:29:51.817', '2021-02-23 20:29:51.817', 0, 0, 0, 0, 0, 'cr', 0, 0, 0, 0, N'', '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, 0, '*', '*', 0, '*', 0, '*', '*', 0, '*', 0, '*', '*', 0, '*', 0, '2000-01-01 00:00:00.000', 268, 'normal', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '*', 0, '2000-01-01 00:00:00.000', '2000-01-01 00:00:00.000', '2000-01-01 00:00:00.000', '2000-01-01 00:00:00.000', 0, 0, 0, '*', 0, '*', '*', 0, '*', 0, '*', 0, '*', 0, '2000-01-01 00:00:00.000', 0, 0, 0, 0);
----------
the VALUES (1 1 is the owner DBKey in ICARUS_Char_Database.Table_CharBase
IF you earn som ruby icon in your backbag,you can run this sql command:
SET IDENTITY_INSERT ICARUS_Char_Database.dbo.Table_CharItem ON
UPDATE Table_CharItem SET Amount = Amount + 5000 WHERE OWNER ='1' AND RecId = 'ry_0_0000'
-------
the better way is get ruby coin at first and then to change it in sql's table
2.open your ICARUS_User_Database.Table_CashShopAll
look the selltype,change all cash to ruby
look the rubycost,change all 0 to 1
look the cashcost,change all 1 to 0
this is all , restart your server and client,have fun
====================
btw:
i want to know how to add goods in shop ,
i had try this:add goods in Table_CashShopAll and Table_CashShopSell is not ok,
it not show at client,maybe we need fix something in .bin files.
Don't change the value in the database directly,
he will only have the following results:
1.Everything will be restored after login, such as the modification of some attribute points
2.Nothing will take effect, such as modifying runspeed walkspeed and so on
3.Fatal error, it will be a tragedy, the game will show the character data error, code 330
Many times, even if you restore the modified things, it will not change the result
The character has been abandoned.
Especially with the modification of money, it is easy to have this problem.
Therefore, we need a gmtool to modify the game data more safely. Unfortunately, gmserver is not in it. It has been deleted
Last edited: