Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
Disconnect after select server Disconnect after select server
You last visited: Today at 00:14

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

Advertisement


Advertise with us!

Disconnect after select server

Discussion on Disconnect after select server within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 22
Received Thanks: 5
Unhappy Disconnect after select server

Hey, im getting Disconnected after i select server and press ok. why? :P and just give me a answer please... ive been trying to search for a really long time
Heres the latest logs i got after this happend:


Quote:
2012-06-18 09:12:16 PS_DBAGENT__system log start (DBAgent01)

2012-06-18 09:12:23 connect game, Name=



2012-06-18 09:12:23 connect game, Name=



2012-06-18 09:42:18 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-06-18 09:42:18 VerifyReConnect : The Connection has been lost, SQLHDBC=801b38

2012-06-18 09:42:18 SDatabasePool::Reconnect:: success...

2012-06-18 11:20:52 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-18 11:20:52 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 11:49:31 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-18 11:49:31 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 11:55:58 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-18 11:55:58 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 17:13:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-18 17:13:42 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 17:17:33 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-18 17:17:33 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1

2012-06-18 17:38:01 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-18 17:38:01 ::LoadBillingItem 1 qerr=-1, EXEC usp_Read_Char_Product_Item_E 1



and second log

Quote:
2012-06-18 09:12:18 PS_LOGIN__system log start (Login01)

2012-06-18 09:15:13 <Console input> /vchkoff

2012-06-18 09:15:13 <Console output> cmd version chk off ok

2012-06-18 10:12:30 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 10:12:30 T=001:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0

2012-06-18 10:12:30 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(0/0)

2012-06-18 11:08:07 err=-1, [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send())., SQL STATE: 01000, NATIVE ERROR: 10054 (0x2746)

2012-06-18 11:08:07 SDatabase::GetErrorMsg:: disconnected...

2012-06-18 11:08:07 GetUser(): err=-1, query=EXEC usp_Try_GameLogin_Taiwan 'admin','0777', 3577179747173531649,'5.153.0.227', [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation., SQL STATE: 08S01, NATIVE ERROR: 11 (0xB)

2012-06-18 11:08:08 SDatabasePool::Reconnect:: success...

2012-06-18 11:12:30 cmd_auto server info log

user = 1 (0/5000)

2012-06-18 11:12:30 T=002:00:00:000, NumC=1,CMin=0,CMax=1,CAvg=0.00, CAva=2,CReq=2,CCnt=2,DCCnt=1, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=488,RBS=0,RBSC=12,SBT=502,SBS=0,SBSC=12

2012-06-18 11:12:30 SContext=3(1021/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=3(1021/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 11:27:42 <Console input> /vchkoff

2012-06-18 11:27:42 <Console output> cmd version chk off ok

2012-06-18 12:12:35 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 12:12:35 T=003:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 12:12:35 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 13:12:38 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 13:12:38 T=004:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 13:12:38 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 14:12:39 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 14:12:39 T=005:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 14:12:39 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 15:12:39 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 15:12:39 T=006:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 15:12:39 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 16:12:39 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 16:12:39 T=007:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 16:12:39 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 17:12:40 cmd_auto server info log

user = 0 (0/5000)

2012-06-18 17:12:40 T=008:00:00:000, NumC=0,CMin=0,CMax=1,CAvg=0.00, CAva=4,CReq=4,CCnt=4,DCCnt=4, CTimeT=000:12:00:000,CTimeAvg=000:03:00:000, RBT=953,RBS=0,RBSC=1,SBT=1134,SBS=0,SBSC=1

2012-06-18 17:12:40 SContext=2(1022/1024)

SContextSend=0(1024/1024)

SContextAccept=0(0/0)

SPacketBufferSendS=1(1023/1024)

SPacketBufferSendM=0(1024/1024)

SPacketBufferSendB=2(1022/1024)

SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)

SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)

SSyncQueueStatus::SQueueStatusNode=0(1024/1024)

2012-06-18 17:16:40 <Console input> /vhckoff

2012-06-18 17:16:40 <Console output> error cmd not found

2012-06-18 17:16:51 <Console input> /vchkoff

2012-06-18 17:16:51 <Console output> cmd version chk off ok
and third

Quote:
2012-06-18 09:12:18 PS_GAME__system log start (Game01) [KR]

2012-06-18 09:12:18 Loaded Behavior In Factory : data/ai/sorp1

2012-06-18 09:12:18 Loaded Behavior In Factory : data/ai/croco1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/croco2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Troll1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Spink1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/GoldenPig

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Sorp3

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Sorp2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Deinos

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Parridalis

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Alcarian

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Belizabeth

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Kirhiross

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/CrypticOne

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Haruhion

2012-06-18 09:12:19 Loaded Behavior In Factory : data/ai/Freezing

2012-06-18 09:12:19 RandomOption Error : ItemID=7199, byServer=3, Wis=0

2012-06-18 09:12:19 RandomOption Error : ItemID=7200, byServer=3, Wis=0

2012-06-18 09:12:20 RandomOption Error : ItemID=10214, byServer=3, Wis=0

2012-06-18 09:12:20 RandomOption Error : ItemID=10215, byServer=3, Wis=0

2012-06-18 09:12:23 connect mgr 892

2012-06-18 09:12:23 connect dbagent 896

2012-06-18 09:12:23 connect dbagent2 900

2012-06-18 09:12:23 connect gamelog 916

2012-06-18 09:12:23 Market End -----------------------

2012-06-18 09:12:24 Load Shaiya.SData 0

2012-06-18 09:15:01 <Console input> /nprotectoff

2012-06-18 09:15:01 <Console output> cmd NProtect off ok

2012-06-18 10:12:34 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 11:12:34 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 11:20:52 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=12, SC=2,SCS=1, SB=31,SBS=15

2012-06-18 11:27:30 <Console input> /nprotectoff

2012-06-18 11:27:30 <Console output> cmd NProtect off ok

2012-06-18 11:49:31 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

2012-06-18 11:55:59 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=2,SCS=0, SB=31,SBS=0

2012-06-18 12:12:38 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 13:12:42 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 14:12:42 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 15:12:43 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 16:12:43 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 17:12:43 InsZone Count : CurAll(0), GuildHouse(cur=0,max=0), GuildRank(cur=0,max=0), Party(cur=0,max=0)

2012-06-18 17:13:43 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

2012-06-18 17:17:34 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

2012-06-18 17:38:01 discon client: (104, 1236) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=2,SCS=0, SB=31,SBS=0
Please help me :P
[ADM]Sonic. is offline  
Old 06/19/2012, 03:01   #2
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2012
Posts: 7
Received Thanks: 2
same problem to me
Justas157 is offline  
Old 06/19/2012, 05:28   #3
 
Bаne's Avatar
 
elite*gold: 0
The Black Market: 2/0/1
Join Date: Mar 2010
Posts: 2,334
Received Thanks: 1,777
Really this is a problem people have repedidly brought to Epvpers. The fix is simple and it's litterly posted everywhere, just use the search bar.
Bаne is offline  
Thanks
3 Users
Old 06/19/2012, 10:44   #4
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 22
Received Thanks: 5
I need an answer since i spent 1 day trying to find the fix
[ADM]Sonic. is offline  
Old 06/19/2012, 13:29   #5
 
.Shaco.'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: May 2012
Posts: 171
Received Thanks: 297
We did show people to how to solve problem like this, and i'm sure that there is topic. So to respect to the people who showed about how to fix, take more time and search for it. If we just give you the link it will be useless and disrespectful for the people who released and guided about it. So find it out your self instead of asking for a link.

Regards,
Shaco
.Shaco. is offline  
Thanks
1 User
Old 06/19/2012, 16:50   #6
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 22
Received Thanks: 5
I really cant find anything, pleaseee help me...
[ADM]Sonic. is offline  
Old 06/19/2012, 18:11   #7


 
Covea's Avatar
 
elite*gold: 0
The Black Market: 3/0/0
Join Date: Jun 2012
Posts: 124
Received Thanks: 198
2 Minutes Searchin':

Failed to connect to game server, after selecting server and clicking ok
May be caused by Windows Firewall blocking the client trying to connect to the server.
Can also be caused by the incorrect IP address entered in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config\ps_g ame.ini on the line that starts with GamePublicIP=
It could possibly also be from incorrect IP addresses in other .ini files.

Disconnect after selecting game server and clicking ok
Most likely you have incorrect or missing data in your database. There could be many causes of this. I'd suggest using the SQL profiler to trace what happens in this case and look for error messages in the logs. If there is an error message present in the logs try to find which SQL query that you traced with the profiler caused it.

I've ran into this specific cause of the above many times now, and it always happens to me when I set up a fresh server. Never have I seen anyone else mention it before though. I decided to add it here just in case it would be useful to someone.

Inside of PS_GameData.dbo.usp_Read_Char_Product_Item_E there is this query:

Code:
SELECT Slot,ItemID,ItemCount FROM PS_USERDB01.PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID
Since PS_USERDB01 does not exist, it causes my client to disconnect after selected the server and clicking ok.

To fix it, I remove PS_USERDB01 from the stored procedure so the query looks like this:

Code:
SELECT Slot,ItemID,ItemCount FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID


Thanks to abrasive.
Covea is offline  
Thanks
11 Users
Old 06/19/2012, 18:28   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 22
Received Thanks: 5
I cant find the PS_GameData.dbo.usp_Read_Char_Product_Item_E, where do i find that?
[ADM]Sonic. is offline  
Old 06/19/2012, 18:55   #9


 
Covea's Avatar
 
elite*gold: 0
The Black Market: 3/0/0
Join Date: Jun 2012
Posts: 124
Received Thanks: 198
PS_GameData -> Programmability -> Saved Procedures -> usp_Read_Char_Product_Item_E
Covea is offline  
Thanks
3 Users
Old 06/19/2012, 19:27   #10
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 22
Received Thanks: 5
Thank you so much! I atleast found that now, now im going to try that thing :P
[ADM]Sonic. is offline  
Old 06/19/2012, 20:51   #11
 
ShaiyaOmega's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jan 2011
Posts: 238
Received Thanks: 901
This particular error is caused by not having your linked servers installed.
When you run the sql files depending on who's server files you use it creates a linked server named "PS_USERDB01"
Run This to fix it.
Code:
/* Add linked servers */

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
	EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_DEFINEDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_DEFINEDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_NCASH')
BEGIN
	EXEC sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_NCASH', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_NCASH', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_GAMEDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_GAMEDB01', @optname='rpc out', @optvalue='true';

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='PS_USERDB01')
BEGIN
	EXEC sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1';
	EXEC sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='PS_USERDB01', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='PS_USERDB01', @optname='rpc out', @optvalue='true';
ShaiyaOmega is offline  
Thanks
23 Users
Reply

Tags
disconnect, selecting, server, shaiya

« Help me to up level skills | [Idea] Protecting the Data.saf/ Data.sah »

Similar Threads Similar Threads
Someone can help me ? --> select Server
05/17/2011 - Shaiya - 0 Replies
Hello all :) i did one private server and i follow instruction of Omega that i can again tell thx :D cuz he help me for other things...maybe again today ! :D My problem is that i have 2 server in select server when i start the game... i mean One server closed and one open (the one that i used) how i can removed the write of the other ? cuz i use only one and i dont know how he comes there :D Please help me to remove it :p see on picture to understand better :p thx much ImageShack® -...
Metin 2 Select Character select error
02/26/2011 - Metin2 Private Server - 1 Replies
Dabei-ist das spiel Charakter-Auswahl Error help Log Files 0225 23:37:16227 :: CEffectManager::RegisterEffect - LoadScript(d:/ymir work/effect/hit/percent_damage1.mse) Error 0225 23:37:16227 :: CInstanceBase::RegisterEffect(eEftType=264, c_szEftAttachBone=, c_szEftName=d:/ymir work/effect/hit/percent_damage1.mse, isCache=1) - Error 0225 23:37:16227 :: CEffectManager::RegisterEffect - LoadScript(d:/ymir work/effect/hit/percent_damage2.mse) Error 0225 23:37:16227 ::...
Problem with server select
02/24/2010 - SRO Private Server - 0 Replies
i downloaded this emu http://www.elitepvpers.com/forum/sro-guides-templat es/114485-guide-how-setup-own-silkroad-server-4.ht ml and all work but i cant select a server dann i get a error can you help me sry for bad english i am german:handsdown::handsdown::handsdown:
[Release]WoW Server Select.
01/23/2010 - WoW Exploits, Hacks, Tools & Macros - 3 Replies
WoW Server Select ::.. Created by: OuTLawZ-GoSu This program stores wow server addresses so you don't have to keep them written down. http://img135.imageshack.us/img135/8448/wowserver selecttd2.th.jpg Problems, Feature requests, Comments, Post them here. Downloads:
Revemu Server select
02/10/2005 - Ragnarok Online - 12 Replies
Hi ich wollte mal revemu testen und wenn ich mich auf euro einlogg geht der immer automatisch auf loki obwohl mein char auf chaos is wo stell ich das um ? Neli



All times are GMT +1. The time now is 00:14.

elitepvpers - play less, get more - Top

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.