[Tutorials]Icarus shop coin change(del the cash (yellow)cointo ruby coin(blue coin))

[exe19890522]

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.

- - - Updated - - -

Therefore, we need a gmtool to modify the game data more safely. Unfortunately, gmserver is not in it. It has been deleted

[MentaL]

[Taha]

don't do it. the server dies from it. the login server and world server will not start due to .bin files

[exe19890522]

don't do it. the server dies from it. the login server and world server will not start due to .bin files

what did you do ,so the server is down?
i fix this is well ,restart server and client is well too,
if i did not change the exp to large value,it is all well.