Hello everybody, recently noticed an error on the purchase characters. It has some the price is 999999999, and do not know how to solve. Can someone help me?
Printable View
Hello everybody, recently noticed an error on the purchase characters. It has some the price is 999999999, and do not know how to solve. Can someone help me?
Configure price chars in
NaviCat > WarZ > dbo > Items_Gear
Get Character Name go to database search and change PriceP(GC) or GProceP(Dollar) .
All prices had been changed but continues the same way 999999
Did you Execute Query in the DB?
Execute this when
use at your risk
Code:USE warz;
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20170
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20170, N'Zombie', N'Basic Zombie Character', N'', 16, -1, 0, 0, 5, 5, 5, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20171
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20171, N'UpperBody_Shirt_01', N'', N'', 14, 0, 0, 0, 0, 0, 0, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20172
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20172, N'LowerBody_Jeans_01', N'', N'', 14, 0, 0, 0, 0, 0, 0, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20173
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20173, N'Head_Bald_01', N'', N'', 14, 0, 0, 0, 0, 0, 0, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20174
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20174, N'RegularGuy', N'Ex Military', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20182
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20182, N'MohawkGuy', N'Ex cage fighter', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20183
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20183, N'Zombie_Woman', N'Zombie_Woman', N'', 16, -1, 0, 0, 5, 5, 5, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20184
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20184, N'AsianGirl', N'Hunter', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20186
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20186, N'Zombie_man', N'Zombie man', N'', 16, -1, 0, 0, 5, 5, 5, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20189
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20189, N'CharacterMale_01', N'Male Character', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20190
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20190, N'Zombie_Military', N'Zombie Military', N'', 16, -1, 0, 0, 5, 5, 5, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20191
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20191, N'Zombie_man_02', N'Zombie Man 2', N'', 16, -1, 0, 0, 5, 5, 5, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20193
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20193, N'CharacterMale_02', N'Average Joe', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20194
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20194, N'CharacterFemale_01', N'CharacterFemale_01', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20195
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20195, N'CharacterFemale_02', N'CharacterFemale_02', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
DELETE FROM [dbo].[Items_Gear] WHERE ItemID=20201
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20201, N'CharacterMale_Asian', N'Asian Male', N'', 16, -1, 0, 0, 4, 4, 4, 1, 7, 30, 215, 0, 1, 0, 11, 77, 3030, 500)
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20203, N'CharacterMale_Black', N'Ex Military', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
INSERT [dbo].[Items_Gear] ([ItemID], [FNAME], [Name], [Description], [Category], [Weight], [DamagePerc], [DamageMax], [Bulkiness], [Inaccuracy], [Stealth], [Price1], [Price7], [Price30], [PriceP], [IsNew], [ProtectionLevel], [LevelRequired], [GPrice1], [GPrice7], [GPrice30], [GPriceP]) VALUES (20202, N'CharacterMale_05', N'Ex Military', N'', 16, 0, 0, 0, 4, 4, 4, 1, 7, 30, 314, 0, 1, 0, 11, 77, 3030, 3141)
GO
Yes ,,,
- - - Updated - - -
Not work :(
Wrong version of your frontend.swf