|
You last visited: Today at 03:25
Advertisement
Name already in use?
Discussion on Name already in use? within the Shaiya Private Server forum part of the Shaiya category.
05/13/2011, 16:41
|
#1
|
elite*gold: 0
Join Date: Mar 2010
Posts: 29
Received Thanks: 0
|
Name already in use?
hello
i have a problem... when i click on create, edit the race, bla, bla, write the name and click on okay, the error: "name already in use" appears.
does anyone have an idea to fix that?
and sorry for my bad english^^
mfg dennis
|
|
|
05/13/2011, 17:33
|
#2
|
elite*gold: 0
Join Date: Jan 2011
Posts: 526
Received Thanks: 175
|
You can use the SearchFunction but today is a niceDay:
USE [PS_GameData]
GO
drop procedure [dbo].[usp_Save_Char_Item_Add_E]
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
/****** 개체: 저장 프로시저 dbo.usp_Save_Char_Item_Add_E ******/
CREATE Proc usp_Save_Char_Item_Add_E
@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality int,
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@MaketimeZ varchar(50),
@Maketype char(1)
AS
DECLARE @Maketime as datetime
SELECT @Maketime = CONVERT(datetime, @MaketimeZ, 120)
--SET NOCOUNT ON
IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END
INSERT INTO CharItems
(CharID, bag, slot, ItemID, Type, TypeID, ItemUID, quality, gem1, gem2, gem3, gem4,
gem5, gem6, craftname, [count], maketime, maketype)
VALUES(@CharID, @Bag, @Slot, @ItemID, @Type, @TypeID, @ItemUID, @Quality, @Gem1, @Gem2, @Gem3, @Gem4,
@Gem5, @Gem6, @Craftname, @Count, @Maketime, @Maketype)
IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END
--SET NOCOUNT OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
|
|
|
05/13/2011, 18:10
|
#3
|
elite*gold: 0
Join Date: Mar 2010
Posts: 29
Received Thanks: 0
|
i hava nothing found at the search function^^ should i copy and paste that text in the ps game data?
|
|
|
05/14/2011, 08:45
|
#4
|
elite*gold: 0
Join Date: Mar 2011
Posts: 92
Received Thanks: 24
|
Yes
|
|
|
05/14/2011, 11:27
|
#5
|
elite*gold: 0
Join Date: Jan 2011
Posts: 526
Received Thanks: 175
|
no execute this command in sql >.>
|
|
|
08/26/2011, 23:15
|
#6
|
elite*gold: 0
Join Date: Aug 2011
Posts: 2
Received Thanks: 0
|
hey admin help me too i have same problem add my skype : kleneiman or responds here same please
|
|
|
08/26/2011, 23:21
|
#7
|
elite*gold: 0
Join Date: Mar 2010
Posts: 2,334
Received Thanks: 1,777
|
Why not just use the quiry if you have the same problem?
|
|
|
All times are GMT +2. The time now is 03:25.
|
|