EP 3 :3

[aragonik]

Hey Guys, I settles my EP5 sever up really well thanks for that all!

But now im looking for ep 3 DB,ps_game.exe,game.exe with 127.0.0.1.

What i have yet#

#1 A game.exe but wrong edited,

#2 im having the EP3 Shaiyaserver>SERVER files.

#3 im NOT having the ep3 SQL db files.

#4 Im having an error D: my Game always turns to Pause signs

2012-01-15 17:58:33 PS_GAME__system log start (Game01)

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/sorp1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/croco1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/croco2

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Troll1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Spink1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/GoldenPig

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Sorp3

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Sorp2

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Deinos

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Parridalis

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Alcarian

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Belizabeth

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/Kirhiross

2012-01-15 17:58:33 Loaded Behavior In Factory : data/ai/CrypticOne

2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:34 error mob item drop info load error


2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:34 error mob item drop info load error

2012-01-15 17:58:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_DEFINEDB' 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-01-15 17:58:35 CGameData::LoadItemLimit: err=-1, query=exec usp_Read_ItemCount_ByServer_R

2012-01-15 17:58:35 DB table load error item limit

2012-01-15 17:58:35 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-01-15 17:58:35 Call save all waiting...

2012-01-15 17:58:35 Call save all failed dbagent disconnected(user count = 0)...

2012-01-15 17:58:35 server shutdown Connection INFO : T=000: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-01-15 17:58:35 Save MobID=1963109

2012-01-15 17:58:35 PS_GAME__system log end (Game01)

2012-01-15 17:58:35 3 1 SService::ServiceCtrlDispatcher(): service shutdown

maybe this is caused because im using ep4 DB files.



And for all those wondering YES im devloping a EP 3 server. But i first have to get this working. I've got all the items etc thoug

[JohnHeatz]

I do believe that this error is caused due to mismatch between your sdata and your database.

[aragonik]

oh. soo how shall i fix this? :/

its propably because i need ep3 db's no?

[JohnHeatz]

You could try (but before doing so, please make a back up of your db) using ShStudio to make the SQL query for you to run on your db, so that it gets them to match.

I will be checking for an EP3 DB because I believe I have one...somewhere... and if I find it I will actually post it.

[aragonik]

What do you mean with :
You could try (but before doing so, please make a back up of your db) using ShStudio to make the SQL query for you to run on your db, so that it gets them to match.

I have backed up my DB files anyway but what about the SQL query, ShStudio stuffz? and i would be really really pleased if you could share your EP 3 DB files

[[DEV]xXDASHXx]

Originally Posted by aragonik

2012-01-15 17:58:35 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_DEFINEDB' 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)

maybe this is caused because im using ep4 DB files.



And for all those wondering YES im devloping a EP 3 server. But i first have to get this working. I've got all the items etc thoug

here is your error right here

Could not find server 'PS_DEFINEDB' 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. so i sugest in your database under linked servers remove all linked servers then rerun this quary

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

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

this should re install ALL linked servers after reinserting all linked servers if error still persists repost the log and i can go thrue it to discover a new error as the mixmatch in sdata itself WILL not cause the server to stop running all the sdata is is a visyal display ingame a mixed sdata only restricts use of said items mobs and so on when in the game.

[aragonik]

I deleted The Game in my linked sevrers. Ran this Query it re-created a Game. But there still aint no 'PS_DEFINEDB' And such in my linked servers.


#edit I THINK i fixed it by making the 'PS_DEFINEDB' mannualy by using a querry, now i have game and 'PS_DEFINEDB' in my linked servers :P second problem is the EP3 game.exe it cant connect because i propably modified the wrong ip X_X could some one help me with the game.exe?

This is an ep3 game.exe ( i think) wich Ip has to be edited? D:



Or if any one would be so friendly to send me a ep3 127.0.0.1 game.exe

[[DEV]xXDASHXx]

Originally Posted by aragonik

I deleted The Game in my linked sevrers. Ran this Query it re-created a Game. But there still aint no 'PS_DEFINEDB' And such in my linked servers.


#edit I THINK i fixed it by making the 'PS_DEFINEDB' mannualy by using a querry, now i have game and 'PS_DEFINEDB' in my linked servers :P second problem is the EP3 game.exe it cant connect because i propably modified the wrong ip X_X could some one help me with the game.exe?

This is an ep3 game.exe ( i think) wich Ip has to be edited? D:



Or if any one would be so friendly to send me a ep3 127.0.0.1 game.exe

inside your ss at the bottom you will notice a line CONFIG.INI then a serios of what apears as IP's 61.129.54.66 is the ip you are going to be changeing. thrue many ip edits on game.exe i have noticed 99.99999% of the time the ip needing to be changed is easyest to search CONFIG then scrole down just a bit and the ip is positioned between 221.132.38.2 and 222.122.78.211 atleast on preaty much every game.exe i have edited that is were it has apeared for me

[aragonik]

#Request Close

I still need a EP 3 SQL DB!! :3

[killer2p]

i happen to have the ep3 db

[cok28rus]

Give game.exe 3episode please .... =)