Help

03/12/2012 23:48 Mitk0o0#1
Hi all i wanna change starting kills to 0 but i put 0 and i close the tables and he back again 120k how to i save TY.
03/13/2012 02:06 mfrowen#2
Did you save the changes :P
03/13/2012 02:25 RebeccaBlack#3
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.
[Only registered and activated users can see links. Click Here To Register...]

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;