[DrFallen]

Originally Posted by DrFallen Yep updated this morning no problems accessing, There seems to be an issue with process.php when trying to add new users it comes up with the mysqli error and problems with the header. Other than that great job.

Huh weirdly if you reclick the link it loops normally to main again and everything is fine. Odd

[island55]

Originally Posted by Pickles47 https://github.com/Sinclair47/connections

is there a table missing? when i get everything installed/configured i'm getting a query error that the table "player_analytics" doesn't exist... i tried creating one then i get some other error about connect_time or lastconnect time or something...
i know i'm close to having this thing set up 100% but there's just a few things missing

any ideas?


edit: you're missing "player_analytics.sql" from the "sql" directory.. there's only 2 files in there, "servers.sql" and "users.sql"

jesus, nevermind... i didn't know the plugin created the table when it started for the first time...

[asherkin]

You can't use the same buffer as both the input and output of SQL_EscapeString, it's unsafe.

[Dr. McKay]

Originally Posted by asherkin You can't use the same buffer as both the input and output of SQL_EscapeString, it's unsafe.

Fixed, thanks.

[Advokat]

I don't seem to be able to get Player Analytics to recognise the GeoIPCity extension as being installed, though it's listed in the sm exts list:

[11] GeoIPCity (1.1.1): Geographical IP information

The entry, relevant section attached, into the table for each player typically looks like this, which I'd guess is how it looks normally with the base GeoIP alone?

city    region    country    country_code    country_code3 
NULL     NULL     Australia  NULL            NULL

Any ideas on where I might be going wrong? I made sure to load player_analytics after GeoIPCity when I was testing it but I believe I initially installed Player Analytics before I grabbed GeoIPCity when I was first setting it up.

[Dr. McKay]

Originally Posted by Advokat I don't seem to be able to get Player Analytics to recognise the GeoIPCity extension as being installed, though it's listed in the sm exts list: The entry, relevant section attached, into the table for each player typically looks like this, which I'd guess is how it looks normally with the base GeoIP alone? city region country country_code country_code3 NULL NULL Australia NULL NULL Any ideas on where I might be going wrong? I made sure to load player_analytics after GeoIPCity when I was testing it but I believe I initially installed Player Analytics before I grabbed GeoIPCity when I was first setting it up.

It should automatically detect the extension. It's possible that there's no city info for your region.

[nineteeneleven]

I wrote a quick php script to look up players connection, and their relevant information.

http://nineteeneleven.info/downloads...yer_finder.zip

[Advokat]

Originally Posted by Dr. McKay It should automatically detect the extension. It's possible that there's no city info for your region.

Wouldn't it still provide the three letter country code though?

[island55]

Pickles47: instead of having a flag category, you should move the icon category next to the name for quicker reference and have the player's name be the selected color rather than having the name of everyone, even admins being the blue color

just a thought.. nonetheless, this GUI is amazing. is there any way to make this public? obviously removing player IPs and specific locations?

[Pitbull3]

haha I found the admin dashboard randomly looking at bootstrap stuff...

http://startbootstrap.com/templates/sb-admin/