Raised This Month: $51 Target: $400
 12% 

SQL Logging of cl_connectmethod


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Pythong
SourceMod Donor
Join Date: Dec 2008
Old 11-13-2013 , 13:21   SQL Logging of cl_connectmethod
Reply With Quote #1

This would be a really good from a statistically point of view. If we log the following information a player connect:
  • cl_connectmethod
  • Server IP
  • Player Name
  • Steam_ID

We can create some interesting statistics about our players.

% of players connecting from, history, direct connect, favorites, quickplay on a per server basis or global basis to see your client population.
Pythong is offline
nineteeneleven
Veteran Member
Join Date: Nov 2010
Old 11-13-2013 , 13:40   Re: SQL Logging of cl_connectmethod
Reply With Quote #2

McKay already said he is working on one.
__________________
nineteeneleven is offline
Pythong
SourceMod Donor
Join Date: Dec 2008
Old 11-13-2013 , 13:42   Re: SQL Logging of cl_connectmethod
Reply With Quote #3

Oh sweet - i didn't see his post anywhere. I search his name and find the post relating to this.

Thanks,
Py
Pythong is offline
ddhoward
Veteran Member
Join Date: May 2012
Location: California
Old 11-13-2013 , 15:47   Re: SQL Logging of cl_connectmethod
Reply With Quote #4

Quote:
Originally Posted by Pythong View Post
Oh sweet - i didn't see his post anywhere. I search his name and find the post relating to this.

Thanks,
Py
It was in the same email thread on the mailing list where Fletcher announced the existence of this new cvar.
__________________
ddhoward is offline
Pythong
SourceMod Donor
Join Date: Dec 2008
Old 11-13-2013 , 15:54   Re: SQL Logging of cl_connectmethod
Reply With Quote #5

I see it now, Im only subscribed to hlds_linux and i see it was posted on hlds:
http://www.mail-archive.com/hlds@lis.../msg53621.html

I'm subscribed to HLDS too now

Can't wait
Pythong is offline
Peterpants
Junior Member
Join Date: Jan 2009
Old 11-13-2013 , 17:27   Re: SQL Logging of cl_connectmethod
Reply With Quote #6

Meanwhile, does anybody know the easiest way to get that cl_connectmethod string to simply be logged?
Peterpants is offline
Dr. McKay
Sir Dr. SourceMod Plugin Approver Esq. Ltd. M.D. PhD
Join Date: Aug 2011
Location: Atlantis
Old 11-14-2013 , 18:47   Re: SQL Logging of cl_connectmethod
Reply With Quote #7

Quote:
Originally Posted by Peterpants View Post
Meanwhile, does anybody know the easiest way to get that cl_connectmethod string to simply be logged?
PHP Code:
public OnClientConnected(client) {
    
decl String:method[64];
    
GetClientInfo(client"cl_connectmethod"methodsizeof(method));
    
LogMessage("%L connected via '%s'"clientmethod);

The analytics plugin that I'll be releasing soon-ish gives you this data for each connection:
  • Server IP
  • Player name
  • Player Steam ID
  • Time they connected
  • Date they connected
  • Method by which they connected
  • Number of players in-game when they connected
  • Map the server was on when they connected
  • How long they were conneccted
  • Their admin flags
  • Player IP
  • (With GeoIPCity) City, Region, Country Code, Country Code3
  • Player's Country
  • (With SteamTools in TF2) F2P/Premium status
  • Whether or not they have HTML MOTDs disabled
__________________

Last edited by Dr. McKay; 11-14-2013 at 18:48.
Dr. McKay is offline
ocwoody
AlliedModders Donor
Join Date: Nov 2010
Location: huh
Old 11-14-2013 , 21:32   Re: SQL Logging of cl_connectmethod
Reply With Quote #8

Quote:
Originally Posted by Dr. McKay View Post
PHP Code:
public OnClientConnected(client) {
    
decl String:method[64];
    
GetClientInfo(client"cl_connectmethod"methodsizeof(method));
    
LogMessage("%L connected via '%s'"clientmethod);

The analytics plugin that I'll be releasing soon-ish gives you this data for each connection:
  • Server IP
  • Player name
  • Player Steam ID
  • Time they connected
  • Date they connected
  • Method by which they connected
  • Number of players in-game when they connected
  • Map the server was on when they connected
  • How long they were conneccted
  • Their admin flags
  • Player IP
  • (With GeoIPCity) City, Region, Country Code, Country Code3
  • Player's Country
  • (With SteamTools in TF2) F2P/Premium status
  • Whether or not they have HTML MOTDs disabled
Awesome!
ocwoody is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 02:55.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode