July 17, 2019, 08:35:49
Welcome Guest, please login or register.
* *
Welcome Guest, please login or register.
July 17, 2019, 08:35:49

Login with username, password and session length

Members
  • Total Members: 280
  • Latest: Hodor
Stats
  • Total Posts: 11092
  • Total Topics: 884
  • Online Today: 16
  • Online Ever: 117
  • (April 01, 2019, 03:02:39)
Users Online
Users: 0
Guests: 12
Total: 12

Donations

Help keep us up and rimming!
33% 
July Donations
DK
McD
Anonymous

Author Topic: Please can someone help me with ServerLink?  (Read 4085 times)

0 Members and 1 Guest are viewing this topic.

Offline Piglet

  • [Core]Fan
  • N00b
  • *
  • Posts: 27
  • Karma: +0/-0
Please can someone help me with ServerLink?
« on: February 26, 2018, 23:15:34 »
I found serverlink code here: https://github.com/kmiklas/3SPNv3223/tree/master/serverlink

Unfortunately I didn't see any documentation and a search or 10 didn't find anything.

I installed mariadb (mysql) and php and the stuff needed to link the two, configured the server to talk to it, set up a server in the tables - and the two talk together  - but it doesn't seem to save stats when I play against bots to test it.

Any ideas?


UT2004 Client:

Code: [Select]
...
New Player Pigletã id=blah
PlayerJoined: Pigletã
ServerLink: Connect: foo:nnn as servername
Resolving piglets.mooo.com...
Requesting stats for player Pigletã
Resolved foo (nnn.nnn.nnn.nnn)
ServerLink: Server resolved foo:nnn
ServerLink: Connection open.
ServerLink: Received: WELCOME!
ServerLink: Received: STATS_UPDATE 0 0 0.0
Changed name to Pigletã
Close TcpipConnection 192.168.1.6:61532 02/26/18 21:56:34
PlayerLeft: Pigletã
Storing player data for Pigletã
MasterServerUplink: Uplink failed to connect to master server 207.135.145.2.
Master server connection failed
Attempting to reconnect to master server!
Resolving ut2004master1.epicgames.com...
MasterServerUplink: Resolved ut2004master1.epicgames.com as 199.255.40.173.
MasterServerUplink: Connection to ut2004master1.epicgames.com established.
Approval APPROVED
Master server requests heartbeat 0 with code 1164
Master server requests heartbeat 1 with code 1164
Master server requests heartbeat 2 with code 1164
Master server assigned our MatchID: 68444236
ServerLink: Closing link.
ServerLink: Connect: foo:nnn as servername
Resolving foo...
Resolved foo (nnn.nnn.nnn.nnn)

Linux Server:

Code: [Select]
...
Server servername authenticated
Player record not found for player hash: <myhash> <mysstats>  <number>
Resource id #350 ERROR: Success
Resource id #350 DISCONNECTED!
Resource id #434 CONNECTED! IP:192.168.1.1 PORT:1225
Server servername authenticated
Player record not found for player hash: <myhash> <mysstats>  <number>
...

Offline Den

  • [Core]
  • N00b
  • *
  • Posts: 24
  • Karma: +0/-666
Re: Please can someone help me with ServerLink?
« Reply #1 on: February 28, 2018, 23:06:03 »
One day wanted do same but alas. Here you suer will not get help  :sad: I know TR admin paid to coders to get own MySQL but tbw he is dickhead and will not share info. Also SoL community has solution, I can try to reach their coder. I'm also interested in having own server with database so if u have solution, pls share

Offline Piglet

  • [Core]Fan
  • N00b
  • *
  • Posts: 27
  • Karma: +0/-0
Re: Please can someone help me with ServerLink?
« Reply #2 on: March 06, 2018, 22:36:17 »
Ahh - I worked it out. I'd not configured my test server to store data when there were bots. It was working fine.

The code from the link in my previous email does work fine.

I think there must be more code for administration of the database - but I couldn't find that.

What help do you need?

Offline horst

  • N00b
  • *
  • Posts: 1
  • Karma: +0/-0
Re: Please can someone help me with ServerLink?
« Reply #3 on: August 27, 2018, 06:49:03 »
hey ! I just found this thread about the serverlink. Im trying to get the SL working on my Server but somehow it does not work. would be happy if youi could give me some Support...
What I did:
- Create Server and DB, Server works fine with 3spn v.3300
- DB also works fine, created the tables per serverlink script
- inserterted DB Information on UT2004 Server / 3spn
- runned serverlink script on DB Server --> Listening

---> i dont know why, but it doesnt seem to work.
Do you know if the DB and Gameserver have to have the same IP, so in case DB is seperated from the gameserver it doesn't work?

UT Gameserverlog:
ServerLink: Connect: 72.5.53.43:3306 as idbftam
ScriptLog: ServerLink: Server resolved 72.5.53.43:3306
ScriptLog: ServerLink: Connection open.


Linuxserverlog:
Socker is Listening...



Cheers, Horst!
« Last Edit: August 27, 2018, 07:06:51 by horst »

 

Links