Player Time Tracker v2.3.5 - Page 10

wtfaatp · 11-21-2011 , 15:06 Re: Player Time Tracker v2.3.4

Awesome man no problem take your time.

crazydog · 11-21-2011 , 17:53 Re: Player Time Tracker v2.3.4

Quote:

Originally Posted by crilleaz

Notice: Undefined index: sort in E:\wamp\www\time\ptt.php on line 20
Notice: Undefined index: StoredTime in E:\wamp\www\time\ptt.php on line 81

how do i fix this?

Change your PHP error reporting value to not display notices. ^_^

See http://us.php.net/manual/en/errorfun...rror-reporting
and http://us.php.net/manual/en/errorfunc.constants.php

wtfaatp · 12-02-2011 , 12:56 Re: Player Time Tracker v2.3.4

Just wondering if there is any update on this?

crazydog · 12-02-2011 , 14:49 Re: Player Time Tracker v2.3.4

Thanks for reminding me to upload it - check the first post in a couple minutes

wtfaatp · *Last edited by wtfaatp; 12-03-2011 at 00:08.*

Thank you man
I'm getting a SQL error.

Code:

L 12/03/2011 - 04:47:14: [ptt.smx] Error! [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 12/03/2011 - 05:05:28: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 05:05:28: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 05:05:28: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 05:05:28: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 05:07:09: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 05:07:09: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 05:07:09: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 05:07:09: [SM]   [0]  Line 233, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::Command_AddPlayer()
L 12/03/2011 - 05:07:23: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 05:07:23: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 05:07:23: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 05:07:23: [SM]   [0]  Line 233, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::Command_AddPlayer()

Database.cfg

Code:

"Databases"
{
	"driver_default"		"mysql"
	
	"default"
	{
		"driver"			"default"
		"host"				"localhost"
		"database"			"sourcemod"
		"user"				"root"
		"pass"				""
	}

	"maprate"
	{
		"driver"			"mysql"
		"host"				"2**7"
		"database"			"w*"
		"user"				"*n"
		"pass"				"*"
		"port"				"3306"
	}
	
	"sourcebans"
	{
		"driver"			"mysql"
		"host"				"2*7"
		"database"			"*"
		"user"				"*"
		"pass"				"*"
		"port"				"3306"
	}
	
	"ptt"
	{
		"driver"			"mysql"
		"host"				"*" //Triple checked
		"database"			"*"//Triple checked
		"user"				"*"//Triple checked
		"pass"			"*"//Triple checked
		"port"				"3306"
	}
	
	"storage-local"
	{
		"driver"			"sqlite"
		"database"			"sourcemod-local"
	}

	"clientprefs"
	{
		"driver"			"sqlite"
		"host"				"localhost"
		"database"			"clientprefs-sqlite"
		"user"				"root"
		"pass"				""
	}
}

plugins.ptt.cfg

Code:

// This file was auto-generated by SourceMod (v1.4.0)
// ConVars for plugin "ptt.smx"


// Track every player that ever connects to your server? (1=yes 0=no)
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
sm_ptt_automatic "1"

// Database (in databases.cfg) to use. Defaut="default"
// -
// Default: "default"
sm_ptt_database "ptt"

// Start tracking as soon as client is added to database? (1=yes 0=no)
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
sm_ptt_default_action "1"

// Enable Tracking? (1=yes 0=no)
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
sm_ptt_enabled "1"

// Time (in seconds) between data updates
// -
// Default: "5"
// Minimum: "1.000000"
// Maximum: "10.000000"
sm_ptt_refresh "5"

// Table in your SQL Database to use. Default="TimeTracker"
// -
// Default: "TimeTracker"
sm_ptt_table "TimeTracker"

// Which players to track: 1=all, 2=only those on a team (no spectators/unassigned)
// -
// Default: "1"
sm_ptt_team "2"

My other plugins that use databases work fine. :\

crazydog · 12-03-2011 , 02:37 Re: Player Time Tracker v2.3.5

Were you getting that before the update?

What's the host setting for the ptt db config? Also, double check sm_ptt_database is correct.

wtfaatp · 12-03-2011 , 03:27 Re: Player Time Tracker v2.3.5

I didn't install till the most recent release :\

sm_ptt_database "ptt"
"ptt"
{
"driver" "mysql"
"host" "*" //Triple checked
"database" "*"//Triple checked
"user" "*"//Triple checked
"pass" "*"//Triple checked
"port" "3306"
}

And the SQL database is allowing the incoming Ip.

crazydog · *Last edited by crazydog; 12-03-2011 at 03:32.*

I'm not sure what to tell you - the error is related to the underling MySQL driver/binary in the system, nothing with the plugin or Sourcemod.

The strange part is that it says "Can't connect to local MySQL server through socket", although you make it seem you're connecting to a remote database.

wtfaatp · *Last edited by wtfaatp; 12-03-2011 at 16:45.*

:\ I decided to put the table in my sourcebans database.
I know this works and is being used on the same server.

Code:

16:36:28 [SM] Listing 58 plugins:
           01 "Basic Comm Control" (1.4.0) by AlliedModders LLC
           02 "Sound Commands" (1.4.0) by AlliedModders LLC
           03 "Rock The Vote" (1.4.0) by AlliedModders LLC
           04 "GunGame:SM Winner Logger" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           05 "Team Balance" (1.2) by Otstrel.ru Team
           06 "Client Preferences" (1.4.0) by AlliedModders LLC
           07 "Map Nominations" (1.4.0) by AlliedModders LLC
           08 "Show Damage" (1.0.7) by exvel
           09 "Basic Info Triggers" (1.4.0) by AlliedModders LLC
           10 "SourceBans" (1.4.8) by SourceBans Development Team
           11 "Anti-Flood" (1.4.0) by AlliedModders LLC
           12 "GgSoundTracksManager" (1.0.0) by LordMarqus
           13 "Admin Menu" (1.4.0) by AlliedModders LLC
           14 "SMAC Eye Angle Test" (0.7.4.7) by GoD-Tony, psychonic
           15 "GunGame:SM Map Vote Starter" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           16 "DeathMatch:SM Spawn Protection" (1.6.1) by Otstrel.ru Team, TigerOx, TechKnow
           17 "Basic Chat" (1.4.0) by AlliedModders LLC
           18 "Admin File Reader" (1.4.0) by AlliedModders LLC
           19 "DeathMatch:SM Weapons Remover" (1.6.1) by Otstrel.ru Team, TigerOx, TechKnow
           20 "Advanced admin commands" (0.16) by 3sigma
           21 "DeathMatch:SM Ragdoll Remover" (1.6.1) by Otstrel.ru Team, TigerOx, TechKnow
           22 "SMAC Aimbot Detector" (0.7.4.7) by GoD-Tony
           23 "StickyNades Lite" (1.2.6) by TigerOx, Tsunami
           24 "MapChooser Extended" (1.7.3) by Powerlord, Zuko, and AlliedModders LLC
           25 "Fun Commands" (1.4.0) by AlliedModders LLC
           26 "Player Commands" (1.4.0) by AlliedModders LLC
           27 "GunGame:SM Stats" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           28 "AssistSystem" (1.1.2) by LordMarqus
           29 "GunGame:SM Config Reader" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           30 "SMAC Rcon Locker" (0.7.4.7) by GoD-Tony, Kigen
           31 "DeathMatch:SM Elimination" (1.6.1) by Otstrel.ru Team, TigerOx, TechKnow
           32 "DeathMatch:SM" (1.6.1) by Otstrel.ru Team, TigerOx, TechKnow
           33 "Fun Votes" (1.4.0) by AlliedModders LLC
           34 "NoBlock" (1.4.2) by Otstrel.ru Team
           35 "HLstatsX CE Ingame Plugin" (1.6.15) by psychonic
           36 "Reserved Slots" (1.4.0) by AlliedModders LLC
           37 "SMAC AutoTrigger Detector" (0.7.4.7) by GoD-Tony
           38 "SMAC Anti-Speedhack" (0.7.4.7) by GoD-Tony
           39 "SMAC Command Monitor" (0.7.4.7) by GoD-Tony, psychonic, Kigen
           40 "GunGame:SM Afk Management" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           41 "Basic Votes" (1.4.0) by AlliedModders LLC
           42 "Anti-TK" (1.2.0) by Rothgar, LordMarqus
           43 "Admin Help" (1.4.0) by AlliedModders LLC
           44 "GunGame:SM Bot Protection" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           45 "SMAC ConVar Checker" (0.7.4.7) by GoD-Tony, psychonic, Kigen
           46 "Map Rate" (1.1) by Ryan "FLOOR_MASTER" Mannion & Chefe
           47 "Updater" (1.1.3) by GoD-Tony
           48 "DeathMatch:SM Preset Spawns" (1.6.1) by Otstrel.ru Team, TigerOx, TechKnow
           49 "GunGame:SM (with SDK Hooks support)" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           50 "VipMod" (1.0.3) by LordMarqus
           51 "Double Jump" (1.0.1) by Paegus
           52 "Basic Commands" (1.4.0) by AlliedModders LLC
           53 "Player Time Tracker" (2.3.5) by Crazydog
           54 "GunGame:SM TK Management" (1.1.9.1) by teame06-hat, Liam, Otstrel.ru Team
           55 "SourceMod Anti-Cheat" (0.7.4.7) by GoD-Tony, psychonic
           56 "SMAC Client Protection" (0.7.4.7) by GoD-Tony, psychonic, Kigen
           57 "GunGame:SM Display Winner" (1.1.9.1) by bl4nk, Otstrel.ru Team
           58 "Nextmap" (1.4.0) by AlliedModders LLC

Im still getting the same error :\

Code:

L 12/03/2011 - 16:45:00: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 16:45:00: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 16:45:00: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 16:45:00: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 16:55:50: Error log file session closed.
L 12/03/2011 - 16:55:53: SourceMod error session started
L 12/03/2011 - 16:55:53: Info (map "gg_mario_vs_wario_v2") (file "errors_20111203.log")
L 12/03/2011 - 16:55:53: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 16:55:53: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 16:55:53: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 16:55:53: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 17:07:56: Error log file session closed.
L 12/03/2011 - 17:07:59: SourceMod error session started
L 12/03/2011 - 17:07:59: Info (map "gg_awp_angular") (file "errors_20111203.log")
L 12/03/2011 - 17:07:59: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 17:07:59: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 17:07:59: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 17:07:59: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 17:53:42: [ptt.smx] [PTT] ERROR: Could not connect to SQL database! ([2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2))
L 12/03/2011 - 17:53:42: [SM] Native "CloseHandle" reported: Handle 0 is invalid (error 4)
L 12/03/2011 - 17:53:42: [SM] Displaying call stack trace for plugin "ptt.smx":
L 12/03/2011 - 17:53:42: [SM]   [0]  Line 482, /home/groups/alliedmodders/forums/files/9/4/5/8/43604.attach::OnClientPostAdminCheck()
L 12/03/2011 - 18:03:26: Error log file session closed.

Again I'm using the sourcebans database which I use on the server so I know the information to be correct.

Code:

// This file was auto-generated by SourceMod (v1.4.0)
// ConVars for plugin "ptt.smx"


// Track every player that ever connects to your server? (1=yes 0=no)
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
sm_ptt_automatic "1"

// Database (in databases.cfg) to use. Defaut="default"
// -
// Default: "default"
sm_ptt_database "sourcebans"

// Start tracking as soon as client is added to database? (1=yes 0=no)
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
sm_ptt_default_action "1"

// Enable Tracking? (1=yes 0=no)
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
sm_ptt_enabled "1"

// Time (in seconds) between data updates
// -
// Default: "5"
// Minimum: "1.000000"
// Maximum: "10.000000"
sm_ptt_refresh "5"

// Table in your SQL Database to use. Default="TimeTracker"
// -
// Default: "TimeTracker"
sm_ptt_table "TimeTracker"

// Which players to track: 1=all, 2=only those on a team (no spectators/unassigned)
// -
// Default: "1"
sm_ptt_team "2"

Would really love to use this :\.

crazydog · 12-03-2011 , 17:58 Re: Player Time Tracker v2.3.5

What happens if you disable SourceBans, and any other plugin that uses a database, temporarily?