[Fragenstein]

Okay...thanks

[bakaideda]

I'm getting this error!

L 04/11/2009 - 16:34:08: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 04/11/2009 - 16:34:08: [SM] Displaying call stack trace for plugin "psychostats_threaded_uni.smx":
L 04/11/2009 - 16:34:08: [SM]   [0]  Line 252, /home/groups/sourcemod/upload_tmp/phpRcc4v2.sp::top10pnl()
L 04/11/2009 - 16:34:08: [SM]   [1]  Line 95, /home/groups/sourcemod/upload_tmp/phpRcc4v2.sp::Command_Say()

-------------------------------------
Port was closed! Now everything is ok!

[Cratoz]

The plugin doesn't show rank or top when i type "rank" or "top" commands in chat.

When i type "sm plugins list" it shows that the plugin is running, and i have no error logs when i start server or so. I have try'd "sm plugins refresh" also without any luck..

The server is running on the same machine as mysql and apache server and so on. So i use localhost as host, also try'd ip. And its correct login and pw to database.

But im also running zBlock on the server, but ive try'd to disable that too without any luck there eatiher.

Anyone help please? Dunno what to do.

------

EDIT: Saw i got this error when i change map or start server.

L 05/20/2009 - 00:12:27: [psychostats_threaded_uni.smx] Database failure: [2002]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

Anyone know what i means?

[SuperShadow]

Let me google that for you: http://www.lmgtfy.com/?q=Can%27t+con...Fmysql.sock%27

[gisus]

Originally Posted by dekken i found the Issue you have assumed our tables will be like this: ps_blabla But for me it goes psplayer psconfig without underscore "_" so what i suggest you to do instead of hardcoding the "_" Sign add it on the top of the file so peoples could edit it for their needs. Thank You. good job so far, plugin runs nicely

Originally Posted by dekken L 08/21/2008 - 06:46:56: [psychostats_threaded_uni.smx] DatabaseInit (CONNECTED) L 08/21/2008 - 06:46:57: [psychostats_threaded_uni.smx] MySQL Error: Table 'dekken_psycho.ps_config' doesn't exist While starting the server.. it doesnt even connect whats the problem =\

We have the same problem http://prikachi.com/users/gisus/40V.jpg please help. where is this table ,we don't have ,or don't know where it is.Where we can change this ps_config without "_" .I thing we should have some code like this:
CREATE TABLE `css_rank`(
`rank_id` int(64) NOT NULL auto_increment,
`steamId` varchar(255) NOT NULL default '',
`nick` varchar(255) NOT NULL default '',
`kills` int(12) NOT NULL default '0',
`deaths` int(12) NOT NULL default '0',
`headshots` int(12) NOT NULL default '0',
`sucsides` int(12) NOT NULL default '0',
PRIMARY KEY (`rank_id`));
but this don't work for us .....About CS:S

[SuperShadow]

Did you install Psychostats from here? http://www.psychostats.com/

[benbrooks]

Okay, Just fixed this thing... hopefully.

For anybody getting the following error, You need to make the database readable from everywhere, not just localhost or whatever.

L 05/31/2009 - 13:19:49: [psychostats_threaded_uni.smx] Database failure: [1045]: Access denied for user 'username'@'IP' (using password: YES)

Here is the thing you need to change (in phpmyadmin)

[Xsinthis]

Its working great for me but it's mostly in russian, how do i remedy this?

[Packhead]

Originally Posted by Xsinthis Its working great for me but it's mostly in russian, how do i remedy this?

If you use my version that's been taken care of for you, in addition to some other features working properly (rank, top10, etc...)


http://forums.alliedmods.net/showpos...&postcount=168

[t3rm1nal_s(0ut]

Originally Posted by Packhead If you use my version that's been taken care of for you, in addition to some other features working properly (rank, top10, etc...) http://forums.alliedmods.net/showpos...&postcount=168

why don't create a new statsme screen?