Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Cenedril - Runes of Magic

Legendary Battlemage
Top Poster Of Month
Joined
Feb 16, 2014
Messages
669
Reaction score
295
I have no idea where is problem.I make one of the Quest to get Cenedril but after all when i logout and 20 minutes latter i login again to my account and sellect character i can't enter to game. i have hope you can help me with that.

Desktop 10-02-2021 01-00-29-846 - Cenedril - Runes of Magic - RaGEZONE Forums Desktop 10-02-2021 01-51-05-532 - Cenedril - Runes of Magic - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Skilled Illusionist
Joined
Jul 30, 2015
Messages
396
Reaction score
156
I regularly make a backup of my sql, so i restored it and my char is st the same state before cenedril quest :D
 
Upvote 0
Skilled Illusionist
Joined
Jul 30, 2015
Messages
396
Reaction score
156
As i said, i'm pretty sure that there is a lot of SQL Stuff missing on server side for Cenedrils.
 
Upvote 0
Legendary Battlemage
Top Poster Of Month
Joined
Feb 16, 2014
Messages
669
Reaction score
295
OK the problem with MirrorWorld Becon quest is inside this quest.

any way i remove some poop code from them and no more problem with this quest
 
Last edited:
Upvote 0
Skilled Illusionist
Joined
Jul 30, 2015
Messages
396
Reaction score
156
Has someone got the mirroworlds running ? For example the quest "The Mirrorworld Beckons" it will port me to somewehere. I have Zones 215-219 open, but it ports me nowhere to.

also the mirrorworld panel is empty
 
Upvote 0
Initiate Mage
Joined
Dec 21, 2021
Messages
39
Reaction score
1
shadow66 - Cenedril - Runes of Magic - RaGEZONE Forums


My MW list is not working. Any suggestions on how I can solve this? Also, Tauin Ardes and Garsit cenedrilles are not on the list.





My MW list is not working. Any suggestions on how I can solve this? Also, Tauin Ardes and Garsit cenedrilles are not on the list.
 
Upvote 0
RaGEZONE VIP
[VIP] Member
Joined
Sep 12, 2020
Messages
442
Reaction score
224
Even when you will not take this Quest there is still problem with Cenedril's same error in PlayerCenter log.

to fix the error log you need to fix Phantom

correct
[Phantom] varbinary(max) DEFAULT ((0)) NOT NULL,

incorrect
[Phantom] varchar(1) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,

Then when you log it will stay,

Janebug

Note: if you do this you will need to restart a toon ...
 
Last edited:
Upvote 0
RaGEZONE VIP
[VIP] Member
Joined
Sep 12, 2020
Messages
442
Reaction score
224
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 ?
 
Last edited:
Upvote 0
RaGEZONE VIP
[VIP] Member
Joined
Sep 12, 2020
Messages
442
Reaction score
224
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
 
Last edited:
Upvote 0
RaGEZONE VIP
[VIP] Member
Joined
Sep 12, 2020
Messages
442
Reaction score
224
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
 
Last edited:
Upvote 0
RaGEZONE VIP
[VIP] Member
Joined
Sep 12, 2020
Messages
442
Reaction score
224
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?
 
Upvote 0
RaGEZONE VIP
[VIP] Member
Joined
Sep 12, 2020
Messages
442
Reaction score
224


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

Janebug
 
Upvote 0
Back
Top