- Joined
- Feb 16, 2014
- Messages
- 632
- Reaction score
- 237
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!Even when you will not take this Quest there is still problem with Cenedril's same error in PlayerCenter log.
[Phantom] varbinary(max) DEFAULT ((0)) NOT NULL,
[Phantom] varchar(1) COLLATE SQL_Latin1_General_CP1_CI_AS DEFAULT '' NOT NULL,
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.
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);
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;
}
i will be not surprised if will be missing some column in DB or some code inside client exe.