|
You last visited: Today at 01:15
Advertisement
How fix this?
Discussion on How fix this? within the Shaiya Private Server forum part of the Shaiya category.
12/09/2012, 14:58
|
#1
|
elite*gold: 0
Join Date: Nov 2011
Posts: 340
Received Thanks: 405
|
How fix this?
Hello, I've got a problem with me server, When i make a character and put 20,000 kills or more I character screen , make a new character and i click T i got 20,000 kills to.. Anyone know how fix this and if it in server files or database and tell me where is please thanks.
|
|
|
12/09/2012, 15:06
|
#2
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
Open Sql>Open Ps_GameData>Tables>dbo.Chars>Right click on dbo.Chars>Design>search K1>In deafult value or blinding change in (( )) to 0 like this ((0)) maybe you understand me
or use this topic
|
|
|
12/09/2012, 15:14
|
#3
|
elite*gold: 0
Join Date: Nov 2011
Posts: 340
Received Thanks: 405
|
Quote:
Originally Posted by Murik13
Open Sql>Open Ps_GameData>Tables>dbo.Chars>Right click on dbo.Chars>Design>search K1>In deafult value or blinding change in (( )) to 0 like this ((0)) maybe you understand me
or use this topic
|
I understand but i already fixed this it not this, it like if i create a character i do /set XXXX Kill 23484 I make a character and CLICK T and Got 23484 kill.. Anyone know how fix it please?
|
|
|
12/09/2012, 15:18
|
#4
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
Try to run this:
Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Create_Char_R2] Script Date: 12/09/2012 15:07:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
/****** dbo.usp_Create_Char_R ******/
ALTER Proc [dbo].[usp_Create_Char_R2]
@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,
@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@*** Tinyint,
@Level Smallint,
@Statpoint Smallint,
@Skillpoint Smallint,
@Str Smallint,
@Dex Smallint,
@Rec Smallint,
@Int Smallint,
@Luc Smallint,
@Wis Smallint,
@Hp Smallint,
@Mp Smallint,
@Sp Smallint,
@Map Smallint,
@Dir Smallint,
@Exp Int,
@Money Int,
@Posx Real,
@Posy Real,
@Posz Real,
@Hg Smallint,
@Vg Smallint,
@Cg Tinyint,
@Og Tinyint,
@Ig Tinyint,
/* 여기까지 인자값 주어져야 함 */
/* SP 내부 참조용 변수 */
@CharID int = 0,
@NameCnt tinyint = 0
AS
SET NOCOUNT ON
DECLARE @Ret int
SET @CharName = LTRIM(RTRIM(@CharName))
SET @SkillPoint = 5
SET @Ret = 0
BEGIN TRANSACTION
INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow,
Hair, Face, [Size], Job, ***, [Level], StatPoint, SkillPoint,
[Str], Dex, Rec, [Int], Luc, Wis, HP, MP, SP, Map, Dir, [Exp], [Money],
PosX, PosY, Posz, Hg, Vg, Cg, Og, Ig, RenameCnt, RemainTime)
VALUES(@ServerID,@UserID, @UserUID, @CharName, @Slot, @Family, @Grow,
@Hair, @Face, @Size, @Job, @***, @Level, @StatPoint, @SkillPoint,
@Str, @Dex, @Rec, @Int, @Luc, @Wis, @HP, @MP, @SP, @Map, @Dir, @Exp, @Money,
@PosX, @PosY, @Posz, @Hg, @Vg, @Cg, @Og, @Ig, 0, 0)
IF( @@ERROR=0 )
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
RETURN -1
END
SET @CharID = IDENT_CURRENT('Chars')
RETURN @CharID
SET NOCOUNT OFF
|
|
|
12/09/2012, 20:53
|
#5
|
elite*gold: 0
Join Date: Nov 2011
Posts: 340
Received Thanks: 405
|
Thanks, thread can be closed.
|
|
|
12/09/2012, 21:43
|
#6
|
elite*gold: 0
Join Date: Nov 2012
Posts: 142
Received Thanks: 153
|
Quote:
Originally Posted by JujiPoli
Thanks, thread can be closed.
|
Use the Explanation point to pm the mods in closing the thread thanks.
|
|
|
12/10/2012, 02:27
|
#7
|
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,977
|
#Closed as requested
|
|
|
All times are GMT +2. The time now is 01:15.
|
|