|
You last visited: Today at 19:02
Advertisement
[HELP Request]name already in use
Discussion on [HELP Request]name already in use within the Shaiya Private Server forum part of the Shaiya category.
12/10/2012, 16:01
|
#1
|
elite*gold: 16
Join Date: Jun 2011
Posts: 63
Received Thanks: 159
|
[HELP Request]name already in use
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.
|
|
|
12/10/2012, 17:00
|
#2
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
please use the search function, next time.
|
|
|
12/10/2012, 17:08
|
#3
|
elite*gold: 576
Join Date: Mar 2011
Posts: 348
Received Thanks: 994
|
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 » «
|
|
|
12/10/2012, 17:17
|
#4
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
Use English Only on SQL - Languages - do not use any other languages.
Sometimes this error happens because different SQL language.
|
|
|
12/10/2012, 17:18
|
#5
|
elite*gold: 0
Join Date: Jun 2011
Posts: 218
Received Thanks: 153
|
Script work 100%
|
|
|
12/10/2012, 17:21
|
#6
|
elite*gold: 576
Join Date: Mar 2011
Posts: 348
Received Thanks: 994
|
Did you restart your server after running this script? Any errors occurred while running the script?
|
|
|
12/10/2012, 17:47
|
#7
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
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
|
|
|
12/10/2012, 18:20
|
#8
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
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,
|
|
|
12/10/2012, 18:57
|
#9
|
elite*gold: 16
Join Date: Jun 2011
Posts: 63
Received Thanks: 159
|
STILL no effect.Logs aren't showing anything.
|
|
|
12/10/2012, 19:00
|
#10
|
elite*gold: 92
Join Date: Aug 2009
Posts: 731
Received Thanks: 971
|
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.
|
|
|
12/11/2012, 16:15
|
#11
|
elite*gold: 16
Join Date: Jun 2011
Posts: 63
Received Thanks: 159
|
Okay.Reinstalled the SQL(English ofc).Everything is good,but unfortunately 95% of the new commands aren' working.
|
|
|
12/11/2012, 16:20
|
#12
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 391
|
What "new commands" would these be?
Try be a little more specific so we can help you easier
|
|
|
12/11/2012, 16:45
|
#13
|
elite*gold: 0
Join Date: May 2012
Posts: 394
Received Thanks: 391
|
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?
|
|
|
|
All times are GMT +2. The time now is 19:02.
|
|