[HELP Request]name already in use

oldjayy · 12/10/2012, 16:01

Hello there epvp members.I have got a little problem.Yesterday i executed the commands of Hoax to my SQL and they had no problem,were working and so,BUT when I try to make a character gives me the next error -name already in use.Some of you will say there are scripts to fix and USE search button,Did it many times,but there was no fix.
My logs aren't showing anything too.Hope someone can help me.
Thanks in advance.

nephren · 12/10/2012, 17:00

please use the search function, next time.

Philipp_ · 12/10/2012, 17:08

Quote:

Originally Posted by oldjayy

Some of you will say there are scripts to fix and USE search button,Did it many times,but there was no fix.

I can't believe that you tried to use the search engine, because the fix you are talking about is easy to find. Here's the tutorial how to use the search engine on elitepvpers:

First, navigate to the search engine

Then type in what you are looking for and click "SEARCH"

Now you have to click on the first result and you are done!

If you still don't find it »

«

nephren · 12/10/2012, 17:17

Use English Only on SQL - Languages - do not use any other languages.
Sometimes this error happens because different SQL language.

~~Murik13~~ · 12/10/2012, 17:18

Script work 100%

Philipp_ · 12/10/2012, 17:21

Did you restart your server after running this script? Any errors occurred while running the script?

nephren · 12/10/2012, 17:47

please try this:

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Create_Char_R2]    Script Date: 12/10/2012 17:47:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R    스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

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,
@Sex 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, Sex, [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, @Sex, @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

And this:

Code:

USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Create_Char_R]    Script Date: 12/10/2012 17:47:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** 개체: 저장 프로시저 dbo.usp_Create_Char_R    스크립트 날짜: 2006-05-30 오후 12:53:23 ******/

ALTER  Proc [dbo].[usp_Create_Char_R]

@ServerID tinyint,
@UserID varchar(12),
@UserUID int,
@CharName varchar(50) ,

@Slot Tinyint,
@Family Tinyint,
@Grow Tinyint,
@Hair Tinyint,
@Face Tinyint,
@Size Tinyint,
@Job Tinyint,
@Sex 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



SET @NameCnt = (SELECT ISNULL(COUNT(*),0) FROM Chars WHERE CharName=@CharName AND Del=0)

IF(@NameCnt <> 0)
BEGIN
	RETURN -2
END
ELSE
BEGIN
	IF EXISTS ( SELECT CharID FROM Chars WHERE CharName=@CharName AND Del = 1 AND [Level] >10 AND DeleteDate > DATEADD(dd, -7, GETDATE()) )
	BEGIN
		RETURN -2
	END

	BEGIN TRANSACTION

	INSERT INTO Chars(ServerID,UserID, UserUID, CharName, Slot, Family, Grow, 
	Hair, Face, [Size], Job, Sex, [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, @Sex, @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')
END

RETURN @CharID

SET NOCOUNT OFF

nephren · 12/10/2012, 18:20

2012-12-10 19:02:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'usp_Create_Char_R' expects parameter '@GM', which was not supplied., SQL STATE: 42000, NATIVE ERROR: 201 (0xC9)

you didn't run that query successfully, there is no var called @GM.

Please do the following steps:

Open SQL-Manager, Go to: PS_GameData > Expand it > Stored Procedures > Expand it
Search for:
usp_Create_Char_R and modify it with my Codes.
Search for:
usp_Create_Char_E2 and modify it with my Codes.

Execute it. And make sure that you restart your SQL-Services AND your Shaiya-Server,

oldjayy · 12/10/2012, 18:57

STILL no effect.Logs aren't showing anything.

nephren · 12/10/2012, 19:00

In this case you should think about a new Database and maybe new server-files.

If you have the server public, you can BackUP all Characters and Items by using SQLScripter or Export/Import which is already included.

guess you're already use "English-Language" on SQL eh?
If not: please do this first.

oldjayy · 12/11/2012, 16:15

Okay.Reinstalled the SQL(English ofc).Everything is good,but unfortunately 95% of the new commands aren' working.

Truth1010 · 12/11/2012, 16:20

What "new commands" would these be?
Try be a little more specific so we can help you easier

Truth1010 · 12/11/2012, 16:45

I have never used that release before, so I don't have much knowledge of it, but just taking a quick look through.. Are you sure your using the right type of character/account.

Status 16 seems to be the main key to it. Also Admin 1 is used a few times.

are you typing the commands in correctly how it states, and are you re-logging after you use a command, like it also states?

Found this at the bottom of the post, checked it ?

Quote:

1. Did you set Adminlevel to 255 on your Account in your PS_UserData.dbo.Users_Master?
2. Does your Chatlog work?
3. Check permissions for the script. Is it allowed to change Values in other Databases?
4. Can you find the command that you used in your Chatlog?