Raised This Month: $188 Target: $400
 47% 

[L4D] Player Stats (Co-op) v1.1.1


Post New Thread Reply   
 
Thread Tools Display Modes
MasterS
Junior Member
Join Date: May 2009
Old 05-18-2009 , 07:54   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #461

[l4d_stats.smx] Database.cfg missing 'l4dstats' entry!
here is my databases.cfg can you help me !
Code:
"Databases"
{
    "driver_default"        "mysql"
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
}

"l4dstats"
{
    "driver"              "mysql"
    "host"                "localhost"
    "database"            "l4d"
    "user"                "l4d"
    "pass"                "hide"
oh ! and when I run createtable.php got the follow results
Code:
Warning
Code:
:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /date/www/bfxhz/l4drank/common.php on line 134
Maps table created successfully!

Maps data inserted successfully!

Players table created successfully!

All tables created successfully!

Last edited by MasterS; 05-18-2009 at 08:06. Reason: something forgot to say
MasterS is offline
muukis
Veteran Member
Join Date: Apr 2009
Old 05-18-2009 , 10:43   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #462

Quote:
Originally Posted by MasterS View Post
[l4d_stats.smx] Database.cfg missing 'l4dstats'
You have to place the "l4dstats" entry inside the "Databases" brackets. Also, in your example, you are missing a closing bracket for the "l4dstats" entry? Copy&paste error?

I had some problems with the MySQL, but don't remember if it was the same as yours. You can however try checking if your MySQL server is set to strict mode. That mode will cause problems due to some warnings the original queries will generate.

http://dev.mysql.com/doc/refman/5.0/...-sql-mode.html
muukis is offline
msleeper
Veteran Member
Join Date: May 2008
Location: Atlanta, Jawjuh
Old 05-18-2009 , 17:38   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #463

Quote:
Originally Posted by galadril View Post
So whats the status>?????
You're extremely impatient. I already said that I was not going to include the changes to the webstats. I provide a very basic package for people, if someone wants to modify it then they are more than welcome to.

No, I haven't had a chance to totally complete things. Real life and work are important and I've had other obligations that require my attention. I will get these finished as soon as I can.

Quote:
Originally Posted by muukis View Post
You have to place the "l4dstats" entry inside the "Databases" brackets. Also, in your example, you are missing a closing bracket for the "l4dstats" entry? Copy&paste error?
This. Fix your layout and you'll be fine.

As for your MySQL error, do what muukis suggested with the "strict" mode and you should be fine.
__________________
msleeper is offline
MasterS
Junior Member
Join Date: May 2009
Old 05-19-2009 , 08:40   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #464

Thank you I can run the Player Stats now !

And another problem I have search the problem about mysql strict mode and answer is add
Code:
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to my.cnf

I have add this to my.cnf and restart mysql now do I need to reintall the database with createtable.php ?
MasterS is offline
msleeper
Veteran Member
Join Date: May 2008
Location: Atlanta, Jawjuh
Old 05-19-2009 , 16:02   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #465

It probably wouldn't hurt. Just delete all of the tables and run the installer again.
__________________
msleeper is offline
MasterS
Junior Member
Join Date: May 2009
Old 05-19-2009 , 23:47   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #466

aways got the same problem
I have add
Code:
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to my.cnf in the mysqld section and run
Code:
SET @@global.sql_mode= '';
with phpmyadmin but no effect
when i run createtable.php still get
Code:
Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /date/www/l4drank/common.php on line 134
MasterS is offline
rebbie23
Junior Member
Join Date: May 2009
Old 05-22-2009 , 08:46   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #467

when a user types rank in the server this is the error I am getting in console and nothing shows up on the players screen.
can any one tell me what this means?

Quote:
: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
: [SM] Displaying call stack trace for plugin "l4d_stats.smx":
: [SM] [0] Line 1549, /home/groups/alliedmodders/forums/files/3/7/5/2/1/41102.attach::cmd_ShowRank()
: [SM] [1] Line 1520, /home/groups/alliedmodders/forums/files/3/7/5/2/1/41102.attach::cmd_Say()
and this is what my databases.cfg looks like (pretty positive this is right)

Quote:
"Databases"
{
"driver_default" "mysql"

"default"
{
"driver" "default"
"host" "localhost"
"database" "sourcemod"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}

"storage-local"
{
"driver" "sqlite"
"database" "sourcemod-local"
}

"clientprefs"
{
"driver" "sqlite"
"host" "localhost"
"database" "clientprefs-sqlite"
"user" "root"
"pass" ""
//"timeout" "0"
//"port" "0"
}
"l4dstats"
{
"driver" "mysql"
"host" "64.111.119.19"
"database" "robertdcbrown_l4dstats"
"user" "xxxxxx"
"pass" "xxxxx"

}
rebbie23 is offline
msleeper
Veteran Member
Join Date: May 2008
Location: Atlanta, Jawjuh
Old 05-22-2009 , 16:17   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #468

You're forgetting your closing } at the end.
__________________
msleeper is offline
rebbie23
Junior Member
Join Date: May 2009
Old 05-22-2009 , 16:46   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #469

Quote:
Originally Posted by msleeper View Post
You're forgetting your closing } at the end.


sorry, I forgot to copy and paste it. There is a final bracket in my config file.

still having same problem.
rebbie23 is offline
msleeper
Veteran Member
Join Date: May 2008
Location: Atlanta, Jawjuh
Old 05-22-2009 , 16:54   Re: [L4D] Player Stats (Co-op) v1.1.1
Reply With Quote #470

Are you positive that your MySQL host allows external connections, or that you have configured your MySQL server properly?
__________________
msleeper is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 05:46.


Powered by vBulletin®
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Theme made by Freecode