Very Basic Player Tracker (Updated 7/15/10) - Page 3

vertexshader · 07-15-2010 , 07:23 Re: Very Basic Player Tracker (Updated 7/14/10)

Wow, ktnx

HSFighter · *Last edited by HSFighter; 07-15-2010 at 16:44.*

Nice work msleeper.

I will add countryflags to the webadmin-update this weekend ^^

Any chance to add Serverport to?
This make it possible to show Servername in the "Webadmin-Server-Selection" for your plugin:

Example:

msleeper · 07-15-2010 , 15:43 Re: Very Basic Player Tracker (Updated 7/14/10)

Sure, I will add that shortly.

msleeper · 07-15-2010 , 16:57 Re: Very Basic Player Tracker (Updated 7/15/10)

Okay, updated to 1.5 and added server port to the stats. Use this SQL to modify an existing table:

PHP Code:


			
     ALTER  TABLE  `player_tracker`  ADD  `geoipcountry` VARCHAR( 255  )  NOT  NULL  AFTER  `serverip` ;

HSFighter · *Last edited by HSFighter; 07-19-2010 at 15:58.*

Thank you msleeper.

--

The Player Tracker area in Sourcemod Webadmin has now support for Countryflags and Servernames.

Please make sure you have sm_tracker_geoiptype set to 1 !
(2 letter Country Code), else you will doun't see a country flag.

N-Joy

checkster · 07-20-2010 , 12:09 Re: Very Basic Player Tracker (Updated 7/15/10)

PHP Code:


			
L 07/20/2010 - 14:13:57: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:35:44: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:36:13: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:36:54: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:45:55: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:50:21: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:55:35: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:55:36: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:55:36: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 14:55:36: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:07:55: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:10:01: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:41:58: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:48:10: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:52:52: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:52:56: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:53:10: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:53:42: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:53:53: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:59:08: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:59:09: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 07/20/2010 - 15:59:09: [tracker.smx] Failed to connect to database: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

what have I done wrong ?

Lebson506th · 07-20-2010 , 12:25 Re: Very Basic Player Tracker (Updated 7/15/10)

http://lmgtfy.com/?q=Can%27t+connect...Fmysql.sock%27

checkster · 07-21-2010 , 05:59 Re: Very Basic Player Tracker (Updated 7/15/10)

Quote:

Originally Posted by Lebson506th

http://lmgtfy.com/?q=Can%27t+connect...Fmysql.sock%27

Your such a funny person, how about presenting a solution.
I know what the error is, but I dont know how to fix it.
No need to be dippshitt.

Lebson506th · 07-21-2010 , 08:12 Re: Very Basic Player Tracker (Updated 7/15/10)

...read the first link.

The fact that you ignored something called "Solve: Can't connect to local MySQL server through socket /tmp..." makes it quite clear that i'm not the one who's a dipshit here.

In that link it gives you step-by-step instructions on how to fix this issue. Try it.

checkster · 07-21-2010 , 11:51 Re: Very Basic Player Tracker (Updated 7/15/10)

well I only saw the first part, and it was early.
So I gues Im the dipshitt.
Sry