November 18, 2018, 13:09:53
Welcome Guest, please login or register.
* *

Teamspam

Welcome Guest, please login or register.
November 18, 2018, 13:09:53

Login with username, password and session length

Members
  • Total Members: 193
  • Latest: Jiren
Stats
  • Total Posts: 10864
  • Total Topics: 850
  • Online Today: 42
  • Online Ever: 98
  • (November 14, 2018, 21:14:22)
Users Online
Users: 0
Guests: 15
Total: 15

Donations

Help keep us up and rimming!
38% 
November Donations
Gargol
McD
Anonymous

Author Topic: Please can someone help me with ServerLink?  (Read 592 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: 22
  • 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 »

 

Spammer

Sorry, you do not have permission to view pictures!

Spambox

Last 20 Shouts:

Hencho

Today at 02:29:57
are you smoking
 

Gargol

November 15, 2018, 18:24:31
HI all, happy pre christmas time
 

McD

November 09, 2018, 20:39:39
Like, fUUuuuUU
 

McD

November 09, 2018, 20:39:15
ups sorry caps
 

McD

November 09, 2018, 20:38:49
rHAAAUUUPP
 

McD

November 04, 2018, 13:52:50
YEaaAaaHHH
 

Pablito

October 25, 2018, 09:56:57
o_O
 

libz

October 22, 2018, 19:26:33
°_°
 

McD

September 30, 2018, 14:03:35
Yooooo
 

DK

September 27, 2018, 10:37:23

Hencho

September 22, 2018, 00:29:34
ay up me duck

roaster

September 21, 2018, 00:18:48
hellllooooo?
 

G4njaM4n

September 19, 2018, 19:09:01
hi mates
 

McD

September 16, 2018, 15:20:05
fortnite is for kids :-p
 

Legend

September 14, 2018, 16:28:11
miss u fliffy  u nabb
 

fluf

September 11, 2018, 20:35:13
;)
 

fluf

September 11, 2018, 20:35:04
i miis u man
 

fluf

September 11, 2018, 20:34:13
will be happy so see old papy core enjoy some frags

Show 50 latest

[Core]Freon

0/12 players & 0 specs
0 : 0
DM-BlizzzXL-DC-1

[Core]Freon #2

0/12 players & 0 specs
0 : 0
DM-Under_LE(NoBuzz)

[Core]TAM

0/12 players & 0 specs
0 : 0
DM-Rankin

[Core]DM

0/12 players & 0 specs
0 : 0
DM-Mako

Links