Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 14:03

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

Advertisement



Probelem in global manger Pleas Help

Discussion on Probelem in global manger Pleas Help within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Dec 2012
Posts: 10
Received Thanks: 0
Exclamation Probelem in global manger Pleas Help

global manager
Query Error!!! Query Result : -1, Query : exec _ManageShardCharName 1, 7227, 64, 'ertyry', ''
SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SR_CharAppoint'.
exec _ManageShardCharName 1, 7227, 64, 'ertyry', ''
Any Help Pleas
thx
Systametic is offline  
Old 05/27/2013, 20:18   #2
 
elite*gold: 0
Join Date: May 2013
Posts: 1,447
Received Thanks: 1,044
Code:
USE [SRO_VT_ACCOUNT]
GO
/****** Object:  StoredProcedure [dbo].[_ManageShardCharName]    Script Date: 05/27/2013 21:16:21 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_ManageShardCharName]
	@job		tinyint,
	@UserJID   	int,
	@ShardID   	smallint,
	@CharName 	varchar(64),
	@OldName 	varchar(64)
as
	-- add new char name
	if (@job = 0)
	begin
		if (not exists(select * from SR_ShardCharNames where UserJID = @UserJID and ShardID = @ShardID and CharName = @CharName))
		begin
			insert SR_ShardCharNames values(@UserJID, @ShardID, @CharName)
		end
		if (not exists(select * from SR_CharAppoint where UserJID = @UserJID and ShardID = @ShardID and CharID = @CharName))
		begin
			insert SR_CharAppoint values(@UserJID, @ShardID, @CharName)
		end
	end
	-- remove char name
	else if (@job = 1)
	begin
		delete SR_ShardCharNames where UserJID = @UserJID and ShardID = @ShardID and CharName = @CharName
		delete SR_CharAppoint    where UserJID = @UserJID and ShardID = @ShardID and CharID = @CharName
	end
	-- rename previous one
	else if (@job = 2)
	begin
		update SR_ShardCharNames set CharName = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharName = @OldName
		update SR_CharAppoint set CharID = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharID = @OldName
	end
Execute + Restart.
Anonymous-6723 is offline  
Old 05/27/2013, 20:26   #3
 
elite*gold: 0
Join Date: Dec 2012
Posts: 10
Received Thanks: 0
Same Problem

give me your skype
and come team

and this problem when any one make grant name in guild say Invalid Too.
Systametic is offline  
Reply


Similar Threads Similar Threads
Bitte um Hilfe / Pleas Help (DayZ Global Ban #3845)
09/16/2012 - DayZ - 7 Replies
Hey Leute, Vorgestern hab ich mit ein paar kumpels DayZ gespielt.. Dann hab ich den server gewechselt und dann kam KEY CODE is in USE ?! -> PC Neugestartet und dann Player Kicked Global Ban #3845 .... Ich hab echt kein plan was ,dass sein soll-.- Und ich hab nichtmal gehackt !!! Gleich Battle-Eye Support angeschrieben aber keine Antwort erhalten.. Bitte helft mir :( http://www.youtube.com/watch?v=8zVYHe9241A&fe ature=plcp
Global manger problem !
07/02/2012 - SRO Private Server - 4 Replies
Hello E*PVP i get this error when i open global manger or getway on anything its has been failed to request certification http://img339.imageshack.us/img339/8885/26951096. png
I have Problem In Global Manger Please Help
02/27/2012 - SRO Private Server - 0 Replies
http://www7.0zz0.com/2012/02/27/09/908035275.png I need Help To Fix This PLease
[Help] Please Help Me Global Manger Vsro Files
01/31/2012 - SRO Private Server - 0 Replies
http://i42.tinypic.com/v6na1k.png BUMP
Pleas pleas pleas (where is new Skill hack??) ty Eliteee
10/08/2010 - Metin2 - 2 Replies
the old Skill hack has been disabled :((((( any new PC pack files?????????



All times are GMT +2. The time now is 14:03.


Powered by vBulletin®
Copyright ©2000 - 2024, 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 ©2024 elitepvpers All Rights Reserved.