View Single Post
otacontoaster
Junior Member
Join Date: Jun 2009
Old 06-22-2009 , 11:02   Re: N1G-TF2-RANK - TF2 Ranking with optional Webinterface
Reply With Quote #754

I've searched through the entire thread looking for a solution to this but I can't find anything.

The stats work in-game just fine, but I'm trying to use the web interface and I'm just getting a few errors.

Code:
Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/livehnet/public_html/tf2stats/map_ranking.php on line 33
I assumed this was because it was trying to put something into an array that doesn't exist in the database, so I checked my database in phpMyAdmin and found that the database is completely empty. Am I missing something here?

Here's my database.cfg:
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"
    }
    "tf2stats"
    {
        "driver"            "mysql"
        "host"              "77.72.0.130"
        "database"          "livehnet_tf2stats"
        "user"              "livehnet_lenny"
        "pass"              "************"
        //"timeout"         "0"
        "port"              "3306"
    }  
}
And my config file for the web interface is set up with the same user/database/password combo.

You can view the interface here:
http://tf2stats.livefromplanetdeath.net/

Anyone have any idea what is causing this error? I expect it's something simple
otacontoaster is offline