[Request] Ep4 Cash Shop Fix

[blackhatjoe]

I finally got my EP4 server running and public

I had to do some thinking outside of the box for that one >.<

Anyway I tried a cash shop fix here and all it did was break my server

Are there any good and PROVEN to work cash shop fixes?

Thanks

[Schwap]

works for me

[Polypropylen]

Originally Posted by Schwap

works for me

should work for everyone?!
or not...

[blackhatjoe]

Originally Posted by Schwap

works for me

Yeah, I tried that one twice and both times it broke my server.

[ProfNerwosol]

If you used the LinkedServer fix as well it most likely disabled RPC for your linked servers. This should restore it.

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

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