September 19, 2018, 20:30:51
Welcome Guest, please login or register.
* *

Teamspam

 
69Dude 
 
Legend 
 
Gav 
Welcome Guest, please login or register.
September 19, 2018, 20:30:51

Login with username, password and session length

Members
  • Total Members: 192
  • Latest: horst
Stats
  • Total Posts: 10849
  • Total Topics: 848
  • Online Today: 32
  • Online Ever: 77
  • (November 30, 2017, 03:22:04)
Users Online
Users: 0
Guests: 14
Total: 14

Donations

Help keep us up and rimming!
23% 
September Donations
McD
Anonymous
franny

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

 

G4njaM4n

Today at 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
 

fluf

September 11, 2018, 20:33:10
dude, come tet it on freon 2 if u still have balls m8
 

69Dude

September 09, 2018, 02:28:07
DOES IT WORK ON FREON 2 FLUFF ??
 

fluf

September 08, 2018, 19:15:27
hi Fans, is it possible to fix some map who crashed on freon 1 ? for example Contrast become classic rankin... Ty and cu there fraggers . Kiss

roaster

September 08, 2018, 01:16:53
tried it, didn't like it....but nobody wants to help with pubg!

roaster

September 08, 2018, 01:16:24
fortnite is shite lol ...sorry lev!

roaster

September 08, 2018, 01:15:50
ut will never die ffs
 

Psan

September 07, 2018, 23:32:52
we are on roofies, Vicky, Levy is daft
 

69Dude

September 07, 2018, 22:52:14
we are on pubg Vicky, fortnite is shite
 

Levy

September 07, 2018, 21:44:56
We are on Fortnite Vicky, UT is dead.

roaster

September 06, 2018, 00:51:36
did everyone grow up???! :(

roaster

September 06, 2018, 00:51:11
where is everyone???

roaster

August 19, 2018, 08:03:18
I know what it is man!! Just wondered why!
 

69Dude

August 18, 2018, 22:29:02
You Tooooo !!!
 

G4njaM4n

August 18, 2018, 22:03:51
have a nice deja gay

Show 50 latest

[Core]Freon

8/12 players & 2 specs
0 : 0
DM-CORE-Rankin
HankMoody 61
Ketamine 45
Soul 44
Terry 39
>DMSX<Noon 60
jOzz 46
oops.. 37
>>CALIMERO59<< 35
Teacher
»Wr3cK`

[Core]Freon #2

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

[Core]TAM

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

[Core]DM

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

Links