[FIX] Character starting kills (120000)

SQL 2005 will edit the table just fine, its what im running. Open the GameData database, then open tables. Find the Chars table then right click and choose edit. It should open the table in a new sql script. Scroll down until you find K1 and change the value from 120000 to 0.

I have SP4 for sql 2005 so the option of unmarking prevent saving changes isnt available. Confirm you can bring up the edit command with right click on the Chars database and then let us know which version of sql you are using. Express or Standard, also include SP.

I know this is old. The correct way to fix this would be:
Right-click dbo.Chars>Design
Find K1 under General
"Default Value or Binding = 120000"
Change 120k to (0)

Or use this...

Quote:

Originally Posted by abrasive I think you need to change the K1 column in PS_GameData.dbo.Chars to default to zero instead of 120000.

i try it to modify but i got this error :

Msg 102, Level 15, State 1, Line 1
Sintassi non corretta in prossimità di '0'.

Post the exact query you are currently using, so that we can see if there is any little mistake that is causing you that issue

Quote:

Originally Posted by Shaiya Xtreme this glitch was by a friend ^^ and for few min a member ask me how he can change this too per PN ^^

i guess a bug or a glitch isn't that 120k kills problem, i mean when someone edit something in a server that is not a glitch or a bug XD. Plis tell this to AriezOMG.

well ty for the topic anyway helped me to correct that "edition". XD

Open it Ps_GameData edit dbo.chars click on Go, k1 120k kills and do think dan to 0 delete the dbo.chars tabele you have. thanks to make the edited dbo.chars tabele run, save, get a new start with dbo.chars tabele kills 0th

This is not permanent it is only a fix for people who have already made there toons

And that is why this doesn't say that it is the change on the actual procedure of creating a toon.

With a little thought anyone following this is able to do the "permanent" fix, if someone can't do an easy fix like that on their database, that would be something to think about if they want to make a public server...

Interesting fact is that some posts above yours is the actual fix for this situation, but obviously people don´t even read before posting

Quote:

Originally Posted by [Admin]UnderLord This is not permanent it is only a fix for people who have already made there toons

Thtas true.
Make this: PS_GameData -> dbo.chars go modify mode then to k1 -4 and look where is the 120000 kills change to 0.
Is the same if u go in game and do: /set "name" kill 0
U didnt solve anything by doing that cuz the next player who make new char,this new char will have 120k kill
The question was:
"[FIX] Character starting kills (120000)"
and not
"How to set existent players kill to 0"
Soo u didnt explain what im looking for...

Not really.You probably didn't understood what he said.
You don't have to change the K1 to K4 columns but the DEFAULT VALUE.
I said enough.

Quote:

Originally Posted by x-DoeSn'TxMaTTeR-x Not really.You probably didn't understood what he said. You don't have to change the K1 to K4 columns but the DEFAULT VALUE. I said enough.

PS_GameData -> dbo.chars go modify mode then to k1 -4 and look where is the 120000 kills change to 0.
Thats what i miss...since my SQL is in anather lenguage i didnt understand.
My fail :/ But now is solved.

Ok ill be the nice guy and put it in plain english.

I'm using sql 2005.

Expand PS_GameData > Right click dbo.Chars > Click Modify/Edit > Scroll Down til you see this > Change the "120000" to 0.

There ya go

[K1] [int] NOT NULL CONSTRAINT [DF_Chars_K1] DEFAULT (120000),
[K2] [int] NOT NULL CONSTRAINT [DF_Chars_K2] DEFAULT (0),
[K3] [int] NOT NULL CONSTRAINT [DF_Chars_K3] DEFAULT (0),
[K4] [int] NOT NULL CONSTRAINT [DF_Chars_K4] DEFAULT (0),

Hello go here u can get some interesting informations...

[Only registered and activated users can see links. Click Here To Register...]

Regards,

:rtfm:help me add skype : ca.mouldi2[