Need help!

07/29/2012 23:45 trident7#1

Hey can somone tell me how to make a permanent fix. Im making a shaiya server and when somone new spawns they start with a Star or 120k kills anyone know how i can fix that?

07/30/2012 00:20 JohnHeatz#2

This is not the first time this is being asked, all you have to do, actually, is use the search engine, there you will find the answer.

Just going to point you out in the right direction, in the create char procedure there must be one variable that is the kills of a character (k1) followed by k2,k3,k4; check them and see how are they starting, and simply make them start per default at 0.

07/30/2012 00:47 [SD]Jericho#3

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;