[sneaK]

Originally Posted by arestonelle hey man, there is an problem with utf8 characters in ur forked version... All good, except this.. Any ideas? (Table and base are in utf8mb4)

I'm assuming same as this: https://github.com/sneak-it/PlayerAnalytics/issues/2

What sourcemod version are you running? What is the version of your MySQL installation?

Originally Posted by Ejziponken Wouldnt it be better to save steamid64 instead of STEAMID? Because of indexing etc for large databases with lots of users?

Generally speaking, int comparisons vs varchar are indeed faster.

[Edu_MochilaBR]

Hello, im using this plugin for some years, and no problems so far. I changed dedicated server recently and reinstalled the webpanel and plugins on 1 server and everything went well, now I'm trying to install on another identical server, just with a another map and this error appears:

L 08/15/2019 - 18:36:32: [SM] Exception reported: Fatal error creating dynamic native!
L 08/15/2019 - 18:36:32: [SM] Blaming: player_analytics.smx
L 08/15/2019 - 18:36:32: [SM] Call stack trace:
L 08/15/2019 - 18:36:32: [SM]   [0] CreateNative
L 08/15/2019 - 18:36:32: [SM]   [1] Line 81, D:\Libraries\Documents\Repos\Public Plugins\scripting\player_analytics.sp::AskPluginLoad2
L 08/15/2019 - 18:36:32: [SM] Failed to load plugin "player_analytics.smx": unexpected error 23 in AskPluginLoad callback.

I am trying to find a solution in the forum for almost 2 days and found this https://forums.alliedmods.net/showthread.php?t=101129, however I ended up destroying everything and made the situation worse. Coz some callbacks are deprecated with this last stable sm.
Could someone please give me a little help? Remembering that there are 2 identical servers only the maps are different.

[Cruze]

Originally Posted by Edu_MochilaBR Hello, im using this plugin for some years, and no problems so far. I changed dedicated server recently and reinstalled the webpanel and plugins on 1 server and everything went well, now I'm trying to install on another identical server, just with a another map and this error appears: L 08/15/2019 - 18:36:32: [SM] Exception reported: Fatal error creating dynamic native! L 08/15/2019 - 18:36:32: [SM] Blaming: player_analytics.smx L 08/15/2019 - 18:36:32: [SM] Call stack trace: L 08/15/2019 - 18:36:32: [SM] [0] CreateNative L 08/15/2019 - 18:36:32: [SM] [1] Line 81, D:\Libraries\Documents\Repos\Public Plugins\scripting\player_analytics.sp::AskPluginLoad2 L 08/15/2019 - 18:36:32: [SM] Failed to load plugin "player_analytics.smx": unexpected error 23 in AskPluginLoad callback. I am trying to find a solution in the forum for almost 2 days and found this https://forums.alliedmods.net/showthread.php?t=101129, however I ended up destroying everything and made the situation worse. Coz some callbacks are deprecated with this last stable sm. Could someone please give me a little help? Remembering that there are 2 identical servers only the maps are different.

You have 2 plugins creating same natives. Check if you have duplicate plugin in your plugins folder.

[Edu_MochilaBR]

Originally Posted by Cruze You have 2 plugins creating same natives. Check if you have duplicate plugin in your plugins folder.

Indeed, had another plugin, but with same name of. My bad.

Thank you.

[einsfuhrer]

I'm having some problems with the columns only showing NULL as value. The following values have NULL:

- city
- region
- country_code
- country_code3
- os

Is there a fix for that?

[theChaosCoder]

Hackmastr added Steam loginid support for the analytics web gui https://github.com/theChaosCoder/pla...lytics/pull/26
That means you can give permission per steamid now and "protect" your analytics page from the public more easily.

Originally Posted by einsfuhrer I'm having some problems with the columns only showing NULL as value. The following values have NULL: - city - region - country_code - country_code3 - os Is there a fix for that?

Probably this?
Player's city, region, 2-letter country code, and 3-letter country code (requires GeoIPCity)

[einsfuhrer]

Originally Posted by theChaosCoder Hackmastr added Steam loginid support for the analytics web gui https://github.com/theChaosCoder/pla...lytics/pull/26 That means you can give permission per steamid now and "protect" your analytics page from the public more easily. Probably this? Player's city, region, 2-letter country code, and 3-letter country code (requires GeoIPCity)

Thanks, I will make sure that I have GeoIPCity.

[einsfuhrer]

So I have added the GeoIPCity in extensions folder. But it still doesnt show the city or region or letter codes.

What else should I do?

[8guawong]

Originally Posted by sneaK As of 4/9/19 I've obtained cvar lists from Windows, Linux, and Mac on CS:GO, and have updated detect_os.games.txt, which I've linked below. Mac & Windows specific cvars broke some time ago, Linux has been fine. Bitbucket's mercurial has proven to be the bane of my existence and absolutely will not allow me to PR into Dr McKay's repo unfortunately. I'll do my best to keep it up to date (for at least CS:GO) in case of future issues on my github: https://github.com/sneak-it/PlayerAn...t_os.games.txt If anyone's interested, my forked Player Analytics repo has been updated with the following: SourcePawn Transitional Syntax Updated CS:GO gamedata to detect operating system CS:GO Prime Status Logging (if game is detected to be CS:GO) Removed leftover SteamTools code, replaced with SteamWorks (now optional!) Updated default charset to utf8mb4 Increased name column maximum size to account for emojis being stored (only upon initial db creation)

hi why am i getting this in log

[player_analytics.smx] SteamWorks extension not found, prime status logging will be unavailable

i have steamworks installed

] sm_rcon sm exts info 15
 File: SteamWorks.ext.dll
 Loaded: Yes (version 1.2.2)
 Name: SteamWorks Extension (Exposes SteamWorks functions to Developers)
 Author: Kyle Sanderson (http://AlliedMods.net)
 Binary info: API version 7 (compiled Aug  9 2017)
 Method: Loaded by SourceMod, attached to Metamod:Source

] sm_rcon sm plugins info player_analytics
  Filename: player_analytics.smx
  Title: Player Analytics (Logs analytical data about connecting players)
  Author: Dr. McKay / Bara / sneaK
  Version: 1.4.1
  URL: http://www.doctormckay.com
  Status: running
  Timestamp: 09/25/2019 15:35:44
  Hash: 4d3caaa9c47de78093ac53ce8b2482a3

Resource materials\panorama\images\icons\equipment\trigger_hurt.svg failed to load.
] meta version
 Metamod:Source Version Information
    Metamod:Source version 1.11.0-dev+1128
    Plugin interface version: 16:14
    SourceHook version: 5:5
    Loaded As: Valve Server Plugin
    Compiled on: Sep  2 2019 11:26:58
    Built from: https://github.com/alliedmodders/metamod-source/commit/98d0c0f
    Build ID: 1128:98d0c0f
    http://www.metamodsource.net/
] sm version
SourceMod 1.10.0.6439, by AlliedModders LLC
To see running plugins, type "sm plugins"
To see credits, type "sm credits"
Visit http://www.sourcemod.net/

do i need to update my steamworks?

---- edit ----

updating to latest steamworks still gives me that message

---- edit2 ----

have to change https://github.com/sneak-it/PlayerAn...lytics.sp#L252

to

if(StrEqual(g_GameFolder, "csgo")) {

to fix it for now

[eliteroyal]

Originally Posted by 8guawong hi why am i getting this in log [player_analytics.smx] SteamWorks extension not found, prime status logging will be unavailable i have steamworks installed ] sm_rcon sm exts info 15 File: SteamWorks.ext.dll Loaded: Yes (version 1.2.2) Name: SteamWorks Extension (Exposes SteamWorks functions to Developers) Author: Kyle Sanderson (http://AlliedMods.net) Binary info: API version 7 (compiled Aug 9 2017) Method: Loaded by SourceMod, attached to Metamod:Source ] sm_rcon sm plugins info player_analytics Filename: player_analytics.smx Title: Player Analytics (Logs analytical data about connecting players) Author: Dr. McKay / Bara / sneaK Version: 1.4.1 URL: http://www.doctormckay.com Status: running Timestamp: 09/25/2019 15:35:44 Hash: 4d3caaa9c47de78093ac53ce8b2482a3 Resource materials\panorama\images\icons\equipment\trigger_hurt.svg failed to load. ] meta version Metamod:Source Version Information Metamod:Source version 1.11.0-dev+1128 Plugin interface version: 16:14 SourceHook version: 5:5 Loaded As: Valve Server Plugin Compiled on: Sep 2 2019 11:26:58 Built from: https://github.com/alliedmodders/metamod-source/commit/98d0c0f Build ID: 1128:98d0c0f http://www.metamodsource.net/ ] sm version SourceMod 1.10.0.6439, by AlliedModders LLC To see running plugins, type "sm plugins" To see credits, type "sm credits" Visit http://www.sourcemod.net/ do i need to update my steamworks? ---- edit ---- updating to latest steamworks still gives me that message ---- edit2 ---- have to change https://github.com/sneak-it/PlayerAn...lytics.sp#L252 to if(StrEqual(g_GameFolder, "csgo")) { to fix it for now

hi, i tried ur fix, where is it suposed to show if the player is prime or not?
https://i.imgur.com/859yhEe.png