|
You last visited: Today at 17:12
Advertisement
Name in use error. No solution
Discussion on Name in use error. No solution within the Shaiya Private Server forum part of the Shaiya category.
11/03/2011, 22:20
|
#1
|
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
|
Name in use error. No solution
I have just made a new server and i have come across a name in use error whenever trying to make a toon. This is the ONLY bug im experiencing this is the quiry i used to try and fix it
Code:
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
I have searched all over the forums and this is the only script i have found. Can anyone help to fix this?
|
|
|
11/04/2011, 15:26
|
#2
|
elite*gold: 0
Join Date: Apr 2011
Posts: 202
Received Thanks: 66
|
What error are you getting when you run it ?
|
|
|
11/04/2011, 19:28
|
#3
|
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
|
Quote:
Originally Posted by Da Boss
What error are you getting when you run it ?
|
there isnt 1 it says executed successfully then i restart server and bug is still there
|
|
|
07/20/2012, 15:46
|
#4
|
elite*gold: 0
Join Date: Mar 2012
Posts: 289
Received Thanks: 23
|
when i logg in game say failed to connect to server (C9)
What i Do Guys?
|
|
|
 |
Similar Threads
|
usp_Read_User_CashPoint_PayLetterT error 0. Any solution?
10/16/2011 - Shaiya Private Server - 3 Replies
Hello,
im having an error with my server.When I press the start button after the character screen it disconnects me with this error 0 here is the log.
Anyone can help me out ?
Thanks in advantance.
|
Need solution for bot error. please help me.
06/05/2011 - SRO Private Server - 0 Replies
Heya.
I lost hope.
Recently, I purchased HoLy bot for SWSRO 2 server.
Bought it, everything works fine, a couple of days ago, I wasn't able to login into the bot, first, I put inside the bot my login information, then the bot turns all white, and crash.
Someone is able to help?
I posted it also at HOLY bot forums but it appears that no one gives a shit in that forum except money -related issues. long story short, I know this forum is not really related to holy bot, but I have to find...
|
Critical Error (F*C*1nG) error - Solution WIN7???
10/25/2010 - RF Online - 1 Replies
why THE HELL in windows 7 this error is so idiot??
in other OS you get critical error, relog and its ok...
but in win7, its fucking annoying.... my char is stucked in ELAN!!! 2 days that i tried to log in and when i select my char i get critical error.... ¬¬ ¬¬ ¬¬ ¬¬
win7 x64 - ati radeon 5650 - 4gb ram
|
Easy solution for this NPG error
04/08/2006 - Silkroad Online - 6 Replies
Hi,
I found a realy easy solution for that NPG() =!blabla error.
1. Go into your Silkroad foulder and delet Gamgguard files. (The complete foulder)
2. Go into Windows/system32/driver/etc/host.txt (open with editor)
3. add 80.15.232.4 nprotect.nefficient.com to it
4. Save the file
5. Open Silkroad bot 1.07
6. Start Silkroad Dont use the start function of bot, it dont work with me, jsut opent he normaly silkroad button
7. Login
|
All times are GMT +1. The time now is 17:16.
|
|