Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya
You last visited: Today at 07:15

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

Advertisement



need help

Discussion on need help within the Shaiya forum part of the MMORPGs category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Aug 2009
Posts: 47
Received Thanks: 18
need help

what is this error someone can help me
err=-1, [Microsoft][ODBC SQL Server Driver]Timeout expired, SQL STATE: HYT00, NATIVE ERROR: 0 (0x0)

2011-02-08 17:43:54 ::LoadBillingItem 14263 qerr=-1, EXEC usp_Read_Char_Product_Item_E 14273
claudeD is offline  
Old 02/08/2011, 18:08   #2
 
elite*gold: 0
Join Date: Jul 2010
Posts: 498
Received Thanks: 449
I had this error while setting up my new server it was because of the details in linked server objects, i suggest you delete them all,




then use the following query ( After setting your new details):

Code:
/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
	EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END	
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';

/* 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';

--exec PS_UserData.dbo.usp_Create_ShaiyaAccount 1, 'admin', admin123


/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Master
	(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Point, Enpassword, Birth)
	VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);
END

IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
	INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
	(UserUID,GameAccount,OneTimePassword,OTPExpireDate,DelCharPWD,CreateDate)
	VALUES (1,'admin','admin123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Detail
	(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQuestion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
	Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,Sms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
	Job,JobNo,LocalNo,PwQuNo)
	VALUES ('admin',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
	NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
END
Edit your Inis in client folder with the correct details and restart after applying changes.

I hope this helps.

Tip: Open the query with notepad and do control + H then replace Shaiya123 by your new pass for example. You'll save some time
Alladrios is offline  
Thanks
2 Users
Old 02/25/2011, 19:38   #3
 
TumbsUp's Avatar
 
elite*gold: 0
Join Date: Jan 2011
Posts: 526
Received Thanks: 175
i know its old but when i excute that i get this error:


EDIT i have win Seven Ultimate
TumbsUp is offline  
Reply




All times are GMT +1. The time now is 07:15.


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.