Jump to content

  • Log in with Facebook Log in with Twitter Log In with Google Log In with Steam Sign In
  • Create Account
Photo

Mysql support for players data

- - - - -

  • Please log in to reply
17 replies to this topic

#1
OFFLINE   alex

alex

    Regular Member

  • Subscriber
  • PipPipPip
  • 63 posts
12
A step in the right direction
  • LocationFrance

Is it possible ?



#2
OFFLINE   gaoesa

gaoesa

    Advanced Member

  • Management
  • PipPipPipPip
  • 4391 posts
341
Will become famous
  • LocationFinland

MySQL uses GPL license and linking against the client library is not possible for us. MariaDB client might be able to connect to MySQL server and uses LGPL license, might be possible.



#3
OFFLINE   Dragonji

Dragonji

    Advanced Member

  • Members
  • PipPipPipPip
  • 514 posts
142
On the road to fame
  • LocationPoland

If you mean stats by player data then I'm all for it (as an option) but if you mean the whole silEnT database stored in MySQL DB then it would be a mistake because non local DB can be unreliable and admins have additional work to set up everything.



#4
OFFLINE   gaoesa

gaoesa

    Advanced Member

  • Management
  • PipPipPipPip
  • 4391 posts
341
Will become famous
  • LocationFinland

The in-game silEnT database is not going to be changed.



#5
OFFLINE   alex

alex

    Regular Member

  • Subscriber
  • PipPipPip
  • 63 posts
12
A step in the right direction
  • LocationFrance

No just players data, so we could have a webstats page!



#6
OFFLINE   Purple

Purple

    Advanced Member

  • Banned
  • PipPipPipPip
  • 157 posts
56
Getting Better

No just players data, so we could have a webstats page!

You can still have this w/o that. :P use lua > log player stats each game, use luasql to send it to a database profit. :)

(ps working on something similar for my clan :P



#7
OFFLINE   alex

alex

    Regular Member

  • Subscriber
  • PipPipPip
  • 63 posts
12
A step in the right direction
  • LocationFrance

Sounds easy when you know lua, but I don't. It's not because something can be achieve by lua that it can't be implemented in the mod.

 

Oh sorry didn't know. I'll upload a good 20+ in the next few days. Thanks.

 

Can't find your 20+ lua script that you uploaded, normal ?



#8
OFFLINE   gaoesa

gaoesa

    Advanced Member

  • Management
  • PipPipPipPip
  • 4391 posts
341
Will become famous
  • LocationFinland

If you can consider using PostgreSQL, the next version of the mod will have a way to collect game statistics for you.



#9
OFFLINE   alex

alex

    Regular Member

  • Subscriber
  • PipPipPip
  • 63 posts
12
A step in the right direction
  • LocationFrance

If you can consider using PostgreSQL, the next version of the mod will have a way to collect game statistics for you.

Thank you sir.



#10
OFFLINE   JohnDory

JohnDory

    Advanced Member

  • Subscriber
  • PipPipPipPip
  • 246 posts
54
Getting Better
  • LocationCornwall, UK

we don't use LUA either.

our stats are done with VSP it may be old but it works so far.



#11
OFFLINE   alex

alex

    Regular Member

  • Subscriber
  • PipPipPip
  • 63 posts
12
A step in the right direction
  • LocationFrance

we don't use LUA either.

our stats are done with VSP it may be old but it works so far.

With the new implementation, VSP could fetch data without parsing the log.



#12
OFFLINE   alex

alex

    Regular Member

  • Subscriber
  • PipPipPip
  • 63 posts
12
A step in the right direction
  • LocationFrance

Correct me if im wrong, but VSP has be installed on a VPS or dedicated server ? The new SQL implementation would make it usable without shell access, which is good for ET shared hosting.


Edited by alex, 14 January 2015 - 02:03 PM.


#13
OFFLINE   Purple

Purple

    Advanced Member

  • Banned
  • PipPipPipPip
  • 157 posts
56
Getting Better

Sounds easy when you know lua, but I don't. It's not because something can be achieve by lua that it can't be implemented in the mod.

 

 

Can't find your 20+ lua script that you uploaded, normal ?

never got around to it :P


Edited by Purple, 14 January 2015 - 07:01 PM.


#14
OFFLINE   JohnDory

JohnDory

    Advanced Member

  • Subscriber
  • PipPipPipPip
  • 246 posts
54
Getting Better
  • LocationCornwall, UK

Correct me if im wrong, but VSP has be installed on a VPS or dedicated server ? The new SQL implementation would make it usable without shell access, which is good for ET shared hosting.

I do not know enough about it, but, I'm sure we used to have on our shared hosting before we got the VPS, its a long time ago though.



#15
OFFLINE   alex

alex

    Regular Member

  • Subscriber
  • PipPipPip
  • 63 posts
12
A step in the right direction
  • LocationFrance

I do not know enough about it, but, I'm sure we used to have on our shared hosting before we got the VPS, its a long time ago though.

Then, at this time, you had to upload the server.log to the web server before parsing it.



#16
OFFLINE   hellreturn

hellreturn

    Management

  • Management
  • PipPipPipPip
  • 2693 posts
158
On the road to fame

I do not know enough about it, but, I'm sure we used to have on our shared hosting before we got the VPS, its a long time ago though.

 

 

Then, at this time, you had to upload the server.log to the web server before parsing it.

 

None of those VPS stats are optimized in terms of database. No matter what you use either MyISAM or InnoDB it's going to slow down your whole machine. 

 

The currently free available VPS stats processors are really slow once you reach 1Gb of database size and you will reach it pretty fast. Sure you can set up cron to emtpy out tablets but then you loose the stats.



#17
OFFLINE   JohnDory

JohnDory

    Advanced Member

  • Subscriber
  • PipPipPipPip
  • 246 posts
54
Getting Better
  • LocationCornwall, UK

We don't have the game server and web server on the same machine, we delete the log files once they start getting to big and the stats are reset at the end of the year usually.

we've not noticed any slow down anywhere.



#18
OFFLINE   Dragonji

Dragonji

    Advanced Member

  • Members
  • PipPipPipPip
  • 514 posts
142
On the road to fame
  • LocationPoland

Sounds easy when you know lua, but I don't. It's not because something can be achieve by lua that it can't be implemented in the mod.

 

 

Can't find your 20+ lua script that you uploaded, normal ?

http://mygamingtalk....l-stats-logger/






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users