Psychostats Interface Plugin - Page 16

PStar · *Last edited by PStar; 01-15-2009 at 06:42.*

OK now it is working.
How can i make thaht this would bee recognized az a caln tag? .:calanname:.

bjcasey · *Last edited by bjcasey; 02-08-2009 at 23:48.*

I've been getting the following error and I can't figure out why.

Code:

L 02/08/2009 - 23:36:14: SourceMod error session started
L 02/08/2009 - 23:36:14: Info (map "cp_orange_x3") (file "errors_20090208.log")
L 02/08/2009 - 23:36:14: [CLIENTPREFS] [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 02/08/2009 - 23:36:30: [psychostats_threaded_uni.smx] Database failure: [1045]: Access denied for user 'totalblo_user'@'216.155.146.22' (using password: YES)

The database is not on the same server as the game server and I've contacted my webhost who runs the server the database is on and they have confirmed my database information as being correct. I have also gone into mysql remote and added the IP address of my gameserver. My stats are working fine pulling from the database and populating on the website, but this game plugin can't seem to do the same thing. Any help would be appreciated.

bjcasey · 02-09-2009 , 19:44 Re: Psychostats Interface Plugin

Anyone still around that can help with this please?

urus · *Last edited by urus; 02-10-2009 at 04:07.*

Quote:

Originally Posted by bjcasey

Anyone still around that can help with this please?

Note: You will need to setup MySQL server to accept connections from your game server, or the plugin simply wont work.

Your mysql user totalblo_user must have access rights to psychostats database from srcds server`s ip

ecko_ · 02-13-2009 , 03:08 Re: Psychostats Interface Plugin

How do you accomplish this?

Snake60 · 02-13-2009 , 06:49 Re: Psychostats Interface Plugin

Any news about update???

ecko_ · *Last edited by ecko_; 02-13-2009 at 16:11.*

I figured this out I think. I went to my cpanel and added the ip that was coming up so it will accept. Restarted server and I no longer get the error. In fact I get no error. But when I go into the server and type /rank or /top10 I get nothing. I also checked the log to see if it was successful and it says successful connection.

Can someone explain?

Thanks

skyride · 02-15-2009 , 23:44 Re: Psychostats Interface Plugin

Hey guys.

Just wondering. Ive currently got this running on my 3 public servers atm, is there any way to have this fetch the user data everytime it is asked for? It seems to hold the data in cache until map change.

mkay_63 · 02-16-2009 , 09:34 Re: Psychostats Interface Plugin

Quote:

Originally Posted by skyride

It seems to hold the data in cache until map change.

Hey,

are you sure - it's updating exactly after map change?
How often PsychoStats (stats.pl) update the database?

As you may know, PsychoStats isn't realtime ;=)

skyride · *Last edited by skyride; 02-17-2009 at 12:36.*

Yes, I am aware of that. I have stats.pl set to run once per minute. Ive even tried having TF2 windowed, running it manually then checking and its DEFINATELY holding cache in some form.

Im not meaning EXACTLY after map change. Im meaning that once someone queries it mid-game, it seems to hold that info in cache until map change.

Either way, ive decided to go with HLstatsX:Community Edition (its a totally different project to premium, ive spoke alot with the main dev) since people seem to be caring much more about in-game information.