Subscriber alex Posted January 13, 2015 Subscriber Share Posted January 13, 2015 Is it possible ? Quote Link to comment Share on other sites More sharing options...
Management gaoesa Posted January 13, 2015 Management Share Posted January 13, 2015 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. Quote Link to comment Share on other sites More sharing options...
Dragonji Posted January 13, 2015 Share Posted January 13, 2015 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. Quote Link to comment Share on other sites More sharing options...
Management gaoesa Posted January 13, 2015 Management Share Posted January 13, 2015 The in-game silEnT database is not going to be changed. Quote Link to comment Share on other sites More sharing options...
Subscriber alex Posted January 13, 2015 Author Subscriber Share Posted January 13, 2015 No just players data, so we could have a webstats page! Quote Link to comment Share on other sites More sharing options...
Purple Posted January 14, 2015 Share Posted January 14, 2015 No just players data, so we could have a webstats page!You can still have this w/o that. use lua > log player stats each game, use luasql to send it to a database profit. (ps working on something similar for my clan Quote Link to comment Share on other sites More sharing options...
Subscriber alex Posted January 14, 2015 Author Subscriber Share Posted January 14, 2015 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 ? Quote Link to comment Share on other sites More sharing options...
Management gaoesa Posted January 14, 2015 Management Share Posted January 14, 2015 If you can consider using PostgreSQL, the next version of the mod will have a way to collect game statistics for you. alex 1 Quote Link to comment Share on other sites More sharing options...
Subscriber alex Posted January 14, 2015 Author Subscriber Share Posted January 14, 2015 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. Quote Link to comment Share on other sites More sharing options...
Subscriber JohnDory Posted January 14, 2015 Subscriber Share Posted January 14, 2015 we don't use LUA either.our stats are done with VSP it may be old but it works so far. alex 1 Quote Link to comment Share on other sites More sharing options...
Subscriber alex Posted January 14, 2015 Author Subscriber Share Posted January 14, 2015 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. Quote Link to comment Share on other sites More sharing options...
Subscriber alex Posted January 14, 2015 Author Subscriber Share Posted January 14, 2015 (edited) 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 January 14, 2015 by alex Quote Link to comment Share on other sites More sharing options...
Purple Posted January 14, 2015 Share Posted January 14, 2015 (edited) 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 Edited January 14, 2015 by Purple Quote Link to comment Share on other sites More sharing options...
Subscriber JohnDory Posted January 14, 2015 Subscriber Share Posted January 14, 2015 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. Quote Link to comment Share on other sites More sharing options...
Subscriber alex Posted January 15, 2015 Author Subscriber Share Posted January 15, 2015 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. Quote Link to comment Share on other sites More sharing options...
Management hellreturn Posted January 15, 2015 Management Share Posted January 15, 2015 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. Quote Link to comment Share on other sites More sharing options...
Subscriber JohnDory Posted January 15, 2015 Subscriber Share Posted January 15, 2015 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. Quote Link to comment Share on other sites More sharing options...
Dragonji Posted January 15, 2015 Share Posted January 15, 2015 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.com/forums/files/file/18-sql-stats-logger/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.