Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 17:12

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old   #1
 
[Dev]RiseAgainst's Avatar
 
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?
[Dev]RiseAgainst is offline  
Old 11/04/2011, 15:26   #2
 
Da Boss's Avatar
 
elite*gold: 0
Join Date: Apr 2011
Posts: 202
Received Thanks: 66
What error are you getting when you run it ?
Da Boss is offline  
Old 11/04/2011, 19:28   #3
 
[Dev]RiseAgainst's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 54
Received Thanks: 13
Quote:
Originally Posted by Da Boss View Post
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
[Dev]RiseAgainst is offline  
Old 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?
mohamedlove1 is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.