[Help] Chars price 9999999999

[Carlos Dorelli]

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?

[MentaL]

[LukasCCB]

Configure price chars in
NaviCat > WarZ > dbo > Items_Gear

Get Character Name go to database search and change PriceP(GC) or GProceP(Dollar) .

[Carlos Dorelli]

All prices had been changed but continues the same way 999999

[The Unknown]

Did you Execute Query in the DB?

[LukasCCB]

Execute this when

use at your risk

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

[Carlos Dorelli]

Yes ,,,

- - - Updated - - -

Not work :(

[AimZMMo]

Wrong version of your frontend.swf