Cenedril - Runes of Magic

**Janebug** · 08-06-22

Originally Posted by shadow66

I just update my client to 6.5.x (not all files most of them was textures and some quest files) like for now I suspend all RoM project.

So you just got lucky then ?

I have done all of the following to even get them to show in the mirrorworld window Mirrorworld started on March 17th, 2016. with Patch 6.5.5. and updated again on 7.0.2 then again it was Patch 7.1.1 added 3 new instances and Patch 7.2.1.2823 added 3 more new instances . i have done all of them NONE of them work ?

**shadow66** · 12-06-22

I use 6.5.5 Update, and like i show on short video they are showed on UI any way this things still need some rework.

**Janebug** · 06-07-22

ok no thanks to any one I fixed it .....

Only thing i need is the Values for Table_MoneyExchange

Any help from anyone would be nice

Janebug

**shadow66** · 06-07-22

Nice Janebug. well done.

**Janebug** · 06-07-22

Here is how i fixed it ... i used 7.2.1.2823 patched files for it ... and lua file.... allready in my client release.
Then you have to do is fix the names in my ObjectData and use this from ROM_ImportDB to fix this table Table_MoneyExchange

Code:


INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (1, 'MailUnit', 1, 0, 0, 0, N'Bulk mail (called base 20)', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (2, 'temp01', 0, 0, 0, 0, N'temp are all alternate field', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (3, 'temp02', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (4, 'temp03', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (5, 'temp04', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (6, 'temp05', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (7, 'temp06', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (8, 'temp07', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (9, 'temp08', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (10, 'temp09', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (11, 'temp10', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (12, 'temp11', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (13, 'temp12', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (14, 'temp13', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (15, 'temp14', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (16, 'temp15', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (17, 'temp16', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (18, 'temp17', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (19, 'temp18', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (20, 'temp19', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (21, 'BankBagLet00', 4320, 5, 0, 0, N'Bank Page rental, 3 day', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (22, 'BankBagLet01', 10080, 9, 0, 0, N'Bank Page rental, 7 day', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (23, 'BankBagLet02', 21600, 16, 0, 0, N'Bank Page rental, 15 day', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (24, 'BankBagLet03', 43200, 22, 0, 0, N'Bank Page rental, 30 day', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (25, 'BankBagLet04', 129600, 50, 0, 0, N'Bank Page rental, 90 day', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (26, 'BankBagLet05', 259200, 80, 0, 0, N'Bank Page rental, 180 day', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (27, 'BankBagLet06', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (28, 'BankBagLet07', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (29, 'BankBagLet08', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (30, 'BankBagLet09', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (31, 'BankBagLet10', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (32, 'BankBagLet11', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (33, 'BankBagLet12', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (34, 'BankBagLet13', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (35, 'BankBagLet14', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (36, 'BankBagLet15', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (37, 'BankBagLet16', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (38, 'BankBagLet17', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (39, 'BankBagLet18', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (40, 'BankBagLet19', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (41, 'HouseEnergy00', 1000, 15, 0, 0, N'House Energy 1000', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (42, 'HouseEnergy01', 5000, 60, 0, 0, N'House Energy 5000', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (43, 'HouseEnergy02', 10000, 110, 0, 0, N'House Energy 10000', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (44, 'HouseEnergy03', 30000, 300, 0, 0, N'House Energy 30000', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (45, 'HouseEnergy04', 50000, 450, 0, 0, N'House Energy 50000', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (46, 'HouseEnergy05', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (47, 'HouseEnergy06', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (48, 'HouseEnergy07', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (49, 'HouseEnergy08', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (50, 'HouseEnergy09', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (51, 'HouseEnergy10', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (52, 'HouseEnergy11', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (53, 'HouseEnergy12', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (54, 'HouseEnergy13', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (55, 'HouseEnergy14', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (56, 'HouseEnergy15', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (57, 'HouseEnergy16', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (58, 'HouseEnergy17', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (59, 'HouseEnergy18', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (60, 'HouseEnergy19', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (61, 'BankLet00', 4320, 20, 0, 0, N'Portable Bank, 3 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (62, 'BankLet01', 10080, 40, 0, 0, N'Portable Bank, 7 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (63, 'BankLet02', 21600, 80, 0, 0, N'Portable Bank, 15 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (64, 'BankLet03', 43200, 140, 0, 0, N'Portable Bank, 30 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (65, 'BankLet04', 129600, 360, 0, 0, N'Portable Bank, 90 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (66, 'BankLet05', 259200, 600, 0, 0, N'Portable Bank, 180 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (67, 'BankLet06', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (68, 'BankLet07', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (69, 'BankLet08', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (70, 'BankLet09', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (71, 'BankLet10', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (72, 'BankLet11', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (73, 'BankLet12', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (74, 'BankLet13', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (75, 'BankLet14', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (76, 'BankLet15', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (77, 'BankLet16', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (78, 'BankLet17', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (79, 'BankLet18', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (80, 'BankLet19', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (81, 'AuctionLet00', 4320, 4, 0, 0, N'Portable Auction, 3 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (82, 'AuctionLet01', 10080, 7, 0, 0, N'Portable Auction, 7 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (83, 'AuctionLet02', 21600, 12, 0, 0, N'Portable Auction, 15 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (84, 'AuctionLet03', 43200, 16, 0, 0, N'Portable Auction, 30 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (85, 'AuctionLet04', 129600, 40, 0, 0, N'Portable Auction, 90 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (86, 'AuctionLet05', 259200, 60, 0, 0, N'Portable Auction, 180 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (87, 'AuctionLet06', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (88, 'AuctionLet07', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (89, 'AuctionLet08', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (90, 'AuctionLet09', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (91, 'AuctionLet10', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (92, 'AuctionLet11', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (93, 'AuctionLet12', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (94, 'AuctionLet13', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (95, 'AuctionLet14', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (96, 'AuctionLet15', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (97, 'AuctionLet16', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (98, 'AuctionLet17', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (99, 'AuctionLet18', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (100, 'AuctionLet19', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (101, 'MailLet00', 4320, 10, 0, 0, N'Portable Mailbox, 3 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (102, 'MailLet01', 10080, 20, 0, 0, N'Portable Mailbox, 7 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (103, 'MailLet02', 21600, 40, 0, 0, N'Portable Mailbox, 15 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (104, 'MailLet03', 43200, 70, 0, 0, N'Portable Mailbox, 30 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (105, 'MailLet04', 129600, 180, 0, 0, N'Portable Mailbox, 90 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (106, 'MailLet05', 259200, 180, 0, 0, N'Portable Mailbox, 180 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (107, 'MailLet06', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (108, 'MailLet07', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (109, 'MailLet08', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (110, 'MailLet09', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (111, 'MailLet10', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (112, 'MailLet11', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (113, 'MailLet12', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (114, 'MailLet13', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (115, 'MailLet14', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (116, 'MailLet15', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (117, 'MailLet16', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (118, 'MailLet17', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (119, 'MailLet18', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (120, 'MailLet19', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (121, 'BagLet00', 4320, 5, 0, 0, N'Backpack Page rental, 3 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (122, 'BagLet01', 10080, 9, 0, 0, N'Backpack Page rental, 7 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (123, 'BagLet02', 21600, 16, 0, 0, N'Backpack Page rental, 15 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (124, 'BagLet03', 43200, 22, 0, 0, N'Backpack Page rental, 30 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (125, 'BagLet04', 129600, 50, 0, 0, N'Backpack Page rental, 90 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (126, 'BagLet05', 259200, 80, 0, 0, N'Backpack Page rental, 180 days', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (127, 'BagLet06', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (128, 'BagLet07', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (129, 'BagLet08', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (130, 'BagLet09', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (131, 'BagLet10', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (132, 'BagLet11', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (133, 'BagLet12', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (134, 'BagLet13', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (135, 'BagLet14', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (136, 'BagLet15', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (137, 'BagLet16', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (138, 'BagLet17', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (139, 'BagLet18', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (140, 'BagLet19', 0, 0, 0, 0, N'', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (141, 'ColoringHorseCost', 30, 0, 0, 0, N'Mount Dye per area', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (142, 'ColoringCost', 5, 0, 0, 0, N'Equipment Dye', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (143, 'ColoringHair', 10, 0, 0, 0, N'Hair Color', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (144, 'ColoringBody', 10, 0, 0, 0, N'Skin Color', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (145, 'HairStyle', 100, 0, 0, 0, N'Hair Style Change', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (146, 'FaceStyle', 100, 0, 0, 0, N'Face style change', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (147, 'BodyShop', 100, 0, 0, 0, N'body bone change', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (148, 'SlotMachineCost', 8, 0, 0, 0, N'Wheel of Fortune Price ', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (149, 'Wardrobe_PageCost1', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (150, 'Wardrobe_PageCost2', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (151, 'Wardrobe_PageCost3', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (152, 'Wardrobe_PageCost4', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (153, 'Wardrobe_PageCost5', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (154, 'Wardrobe_PageCost6', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (155, 'Wardrobe_PageCost7', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (156, 'Wardrobe_PageCost8', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (157, 'Wardrobe_PageCost9', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (158, 'Wardrobe_PageCost10', 0, 0, 100, 0, N'Magic Wardrobe Extra Page', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (159, 'Wardrobe_SetCost6', 0, 0, 100, 0, N'Magic Wardrobe Set', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (160, 'Wardrobe_SetCost7', 0, 0, 100, 0, N'Magic Wardrobe Set', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (161, 'Wardrobe_SetCost8', 0, 0, 100, 0, N'Magic Wardrobe Set', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (162, 'Wardrobe_SetCost9', 0, 0, 100, 0, N'Magic Wardrobe Set', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (163, 'Wardrobe_SetCost10', 0, 0, 100, 0, N'Magic Wardrobe Set', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (159, 'SlotMachineMaxFreeCount', 0, 0, 0, 0, N'Free Count', 0);
INSERT INTO [dbo].[Table_MoneyExchange]([GUID], [KeyStr], [Value0], [Value1], [Value2], [Value3], [Note], [isOK]) VALUES (160, 'WeekInstReset', 7, 0, 0, 0, N'Reset MirrorWorld', 0);

shut the server down , restart it and all should be up to this ... as for the reset not sure yet including the Abilitys unless someone wants to share this info ?

Janebug

**Janebug** · 10-07-22

OK damn please anyone who can help where is the Ability seen from ? i got it this far after you add in what i have above it works but you need to add the ability Please anyone where is it located ? what Sql file do i need to fix to show it ,,,,
'

Here i gave my self 50 Hearts and it lets you pick after..

Anyone ......Or just point me in the right direction ill figure it out sooner or later but it would be nice for a HINT...

Janebug

**Janebug** · 12-07-22

ok i figured out where the ability comes from but the lua code is above me .....can anyone figure this out let me know what table has the ability's need's added

Code:

int LuaFunc_GetPhantomAbility(lua_State* L)
{
    int OrgObjID = luaL_checkint(L, 1);
    int Idx         = luaL_checkint(L, 2)-1;

    float        Result1 = 0;
    std::string Result2 = "";

    GameObjDbStructEx* pObjDB = g_ObjectData->GetObj(OrgObjID);

    if (pObjDB != NULL)
    {
        if (pObjDB->IsPhantom() == true)
        {
            RoleDataEx*    pRole = CNetGlobal::RoleData();

            if(pRole != NULL)
            {
                int Pos = OrgObjID % 1000;

                if (Pos < MAX_PHANTOM_COUNT)
                {
                    WearEqTypeENUM Type = pObjDB->Phantom.abi_Phantom.EqType[Idx];                    

                    if((Type > 0) && (Type < EM_WearEqType_MaxCount))
                    {
                        //撸balance そΑ =  handle * single  * single handle meter * ( 1 + top  * top  handle ) * 枯
                        float Value   = (float)pObjDB->Phantom.abi_Phantom.EqTypeValue[Idx];
                        float Lv      = (float)pRole->PlayerBaseData->Phantom.Info[Pos].Lv;
                        float Rank      = (float)pRole->PlayerBaseData->Phantom.Info[Pos].Rank;
                        float LvArg   = pRole->FixArg().PhantomLvArg;
                        float RankArg = pRole->FixArg().PhantomRankArg;
                        float AbiArg  = RoleDataEx::PhantomAbiArg[Type];

                        if (Lv == 0)
                            Lv = 1;

                        if (Rank == 0)
                            Rank = 1;

                        Result1 = (Value * Lv * LvArg * (1.0f + (Rank * RankArg)) * AbiArg);

                        char Buff[256];
                        g_ObjectData->GetWearEqTypeString(Type, Result1, Buff, 256);
                        Result2 = Buff;
                    }
                }
            }
        }
    }

    lua_pushnumber(L, Result1);
    lua_pushstring(L, Result2.c_str());
    return 2;
}

anyone? or maybe iam wrong?

**shadow66** · 12-07-22

i will be not surprised if will be missing some column in DB or some code inside client exe.

**Janebug** · 12-07-22

Originally Posted by shadow66

i will be not surprised if will be missing some column in DB or some code inside client exe.

.... everything else works but client is only set up for 3 ...

ok all the code is in it

**Janebug** · 13-07-22

Sure would be nice if i got a little help , even if its a confirmation telling me theirs missing code in source ......

Janebug

**Janebug** · 15-07-22

ok i figured out where its missing not sure how or what i need to add to fix it ....

Any help would be Great!!!!

Janebug

**Janebug** · 12-08-22

@fht
Mail box full

But this is only if i can fix the PhantomObject.DB table ? so far not sure how to create a new one with out the Objecteditor ....

But thank you

**Janebug** · 16-08-22

@fht

For the win!!!!! thanks

I will not post the fix Unless fht does not mind, Clue Error in Source!!!

**shadow66** · 16-08-22

Grate job Janebug keep going :)

**Janebug** · 16-08-22

Next Days of the Week or this menu here

This is all handled out of the ROM_ImportDB - tables SysKeyValue and WeekInstances....

any other Info would be great .......

Janebug

Cenedril - Runes of Magic

Thread Tools

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Re: Cenedril - Runes of Magic

Advertisement