|
You last visited: Today at 11:39
Advertisement
[FIX] Character starting kills (120000)
Discussion on [FIX] Character starting kills (120000) within the Shaiya PServer Development forum part of the Shaiya Private Server category.
05/23/2011, 05:32
|
#16
|
elite*gold: 0
Join Date: May 2011
Posts: 51
Received Thanks: 4
|
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.
|
|
|
08/19/2011, 09:31
|
#17
|
elite*gold: 0
Join Date: Dec 2009
Posts: 4
Received Thanks: 5
|
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)
|
|
|
08/19/2011, 09:57
|
#18
|
elite*gold: 0
Join Date: Sep 2010
Posts: 520
Received Thanks: 1,286
|
Or use this...
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;
|
|
|
12/17/2011, 16:22
|
#19
|
elite*gold: 0
Join Date: Dec 2011
Posts: 6
Received Thanks: 6
|
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'.
|
|
|
12/17/2011, 21:04
|
#20
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,976
|
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
|
|
|
03/13/2012, 15:52
|
#21
|
elite*gold: 0
Join Date: Mar 2012
Posts: 11
Received Thanks: 0
|
XD
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
|
|
|
03/14/2012, 19:57
|
#22
|
elite*gold: 0
Join Date: Jun 2011
Posts: 89
Received Thanks: 6
|
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
|
|
|
07/30/2012, 00:05
|
#23
|
elite*gold: 0
Join Date: Jul 2012
Posts: 2
Received Thanks: 0
|
This is not permanent it is only a fix for people who have already made there toons
|
|
|
07/30/2012, 00:36
|
#24
|
elite*gold: 0
Join Date: Jul 2012
Posts: 23
Received Thanks: 14
|
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
|
|
|
09/11/2012, 13:29
|
#25
|
elite*gold: 0
Join Date: Mar 2009
Posts: 38
Received Thanks: 15
|
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...
|
|
|
09/11/2012, 16:07
|
#26
|
elite*gold: 0
Join Date: Aug 2012
Posts: 152
Received Thanks: 71
|
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.
|
|
|
09/12/2012, 00:47
|
#27
|
elite*gold: 0
Join Date: Mar 2009
Posts: 38
Received Thanks: 15
|
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.
|
|
|
01/23/2013, 15:52
|
#28
|
elite*gold: 0
Join Date: Oct 2008
Posts: 71
Received Thanks: 15
|
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),
|
|
|
01/23/2013, 17:44
|
#29
|
elite*gold: 0
Join Date: May 2010
Posts: 342
Received Thanks: 87
|
Hello go here u can get some interesting informations...
Regards,
|
|
|
12/04/2014, 23:41
|
#30
|
elite*gold: 0
Join Date: Nov 2014
Posts: 1
Received Thanks: 1
|
help me add skype : ca.mouldi2[
|
|
|
|
|
Similar Threads
|
WTT iSRO(RedSea)lvl 106 character for rSRO Artemis character!
09/07/2010 - Silkroad Online Trading - 10 Replies
Hey guys/girls,
I want to trade my lvl 106 rogue/bard on RedSea server.
Rev6.com - The 6th Revolution
Character information:
-name : SrO_Diabolik
-build : rogue/bard full STR
-skills : rogue/bard lvl 106 with skills up to date with about 250 k sp left
-items:+2 +3 items with blue,101+5 dagger crit 18,shield 101+5 br 18
-never banned
|
cabal new character starting location
04/18/2009 - Cabal Online - 4 Replies
i am new to cabal and i discovered that different battle style starts at different location and receives different quests.
my question is,when can different battle styles take the same quest and work together in hunting?because im going to play this game with friends with different battle styles and decided to work together in hunting.
plz help me,thx a lot.
|
[Help] Character starting stuff
07/04/2008 - EO PServer Hosting - 19 Replies
any1 know how to change the default character stuff like they get mads and wads and 2 starting gear, where do i look to change this, and its got nothing t odo with right clicking design table in cq_user
also how to change the map that u start in, if any1 knows plz reply asap
|
All times are GMT +1. The time now is 11:39.
|
|