To set everyone's kills to 0, run a query:
PHP Code:
UPDATE PS_GameData.dbo.Chars SET k1=0
Just specific people?
PHP Code:
UPDATE PS_GameData.dbo.Chars
SET k1=0
WHERE CharName IN ('Name1', 'Name2', 'Name3')
But that only does people currently created. To change the default, you need to modify the table itself to stop those dirty deeds.
That is one method to fix the table, the other was posted by myself, and is below:
PHP Code:
--Removes the default of 120k kills
ALTER TABLE [PS_GameData].[dbo].[Chars]
DROP CONSTRAINT DF_Chars_K1;
--Adds the default of 0 kills
ALTER TABLE [PS_GameData].[dbo].[Chars]
ADD CONSTRAINT DF_Chars_K1 DEFAULT ((0)) FOR K1;
