Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Development
You last visited: Today at 11:39

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old 05/23/2011, 05:32   #16
 
Veritas Aequitas's Avatar
 
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.
Veritas Aequitas is offline  
Old 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)
Infamous2012 is offline  
Thanks
4 Users
Old 08/19/2011, 09:57   #18
 
RebeccaBlack's Avatar
 
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;
RebeccaBlack is offline  
Thanks
16 Users
Old 12/17/2011, 16:22   #19
 
[DEV]Neo's Avatar
 
elite*gold: 0
Join Date: Dec 2011
Posts: 6
Received Thanks: 6
Quote:
Originally Posted by abrasive View Post
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'.
[DEV]Neo is offline  
Old 12/17/2011, 21:04   #20
 
JohnHeatz's Avatar
 
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
JohnHeatz is offline  
Old 03/13/2012, 15:52   #21
 
InigoFox's Avatar
 
elite*gold: 0
Join Date: Mar 2012
Posts: 11
Received Thanks: 0
Talking XD

Quote:
Originally Posted by Shaiya Xtreme View Post
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
InigoFox is offline  
Old 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
PrinciCh is offline  
Old 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
[Admin]UnderLord is offline  
Old 07/30/2012, 00:36   #24
 
[SD]Jericho's Avatar
 
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
[SD]Jericho is offline  
Old 09/11/2012, 13:29   #25
 
elite*gold: 0
Join Date: Mar 2009
Posts: 38
Received Thanks: 15
Quote:
Originally Posted by [Admin]UnderLord View Post
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...
Igris32 is offline  
Old 09/11/2012, 16:07   #26
 
x-DoeSn'TxMaTTeR-x's Avatar
 
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.
x-DoeSn'TxMaTTeR-x is offline  
Thanks
2 Users
Old 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 View Post
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.
Igris32 is offline  
Thanks
1 User
Old 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),
DEvolver is offline  
Thanks
1 User
Old 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,
_Diavolino_ is offline  
Old 12/04/2014, 23:41   #30
 
elite*gold: 0
Join Date: Nov 2014
Posts: 1
Received Thanks: 1
help me add skype : ca.mouldi2[
mouldi500 is offline  
Thanks
1 User
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.