[SCE_Ghost]

Actually Eraser made a good point to note in the install section. Gameserver does have a sep outgoing ip, I had to request it, put that in my remote sql access and everything is back up and working!

1 developmental note a player pointed out, when it shows your ranks nothing is in capital Ranks, or You lose 2 points it's you lose 2 points. All other TF2 messages all start with a cap. stupid point but it would look cleaner.

[eraserhead]

Hi all,

I made a guide to make life easier for everyone. See the attachment. I suppose you guys will have some remarks on this guide, tell me so i can improve the document. Maybe DN can post this at the beginning of the thread. After this i will remove ALL my replies in this thread that are connection related and maybe the others can do that too so the number of pages DN has to scroll through will keep to a minimum. I don't know if PDF is a good format?

[SeeingBllue]

Can someone help me please? I've read through this whole thread looking for an answer.

I have serious trouble trying to get my plugins to connect to mysql server. I've added my IP to the remote sql using % as a wild card just incase.

There are the errors I have for tf2stats specifically.

[SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
[SM] Displaying call stack trace for plugin "n1g-tf2-stats.smx":
[SM]   [0]  Line 2797, G:\Users\Raphael\Desktop\Neuer Ordner (4)\TF2-Stats-V5.0\plugin\tf\addons\sourcemod\scripting\n1g-tf2-stats.sp::createdbtables()
[SM]   [1]  Line 179, G:\Users\Raphael\Desktop\Neuer Ordner (4)\TF2-Stats-V5.0\plugin\tf\addons\sourcemod\scripting\n1g-tf2-stats.sp::OnPluginStart()

This is my database.cfg

"Databases"
{
    "driver_default"        "sqlite"
    
    "default"
    {
        "driver"            "default"
        "host"                "74.86.*.*"
        "database"            "princes1_maprating"
        "user"                "princes1_maprate"
        "pass"                "****"
        //"timeout"            "30"
        //"port"            "3306"
    }

    "jukebox"
    {
        "driver"            "mysql"
        "host"                "74.86.*.*"
        "database"            "psydelic_jukebox"
        "user"                "psydelic_jukebox"
        "pass"                "****"
        //"timeout"            "30"
        //"port"            "3306"
    }
    
    "map_rating"
    {
        "driver"            "sqlite"
        "database"            "maprating"
    }

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

    "tf2stats"
        {
            "driver"                    "mysql"
            "host"                        "74.86.*.*"
            "database"                    "psydelic_stats"
            "user"                        "psydelic_usr"
            "pass"                        "****"
            //"timeout"                    "0"
            "port"                    "3306"
        }
}

I also have problems getting my jukebox mod to work that also uses myspl, the map rating mod works because it uses sqlite. When I look at myphpadmin i see the stats database but no tables have been created.

This is what the plugin list says

Load Errors:
TF2 Stats: Error detected in plugin startup (see error logs)

I can't for the life of me figure out what I'm doing wrong, setting mysql mods is a nightmare....

[DarthNinja]

Are you actually using "74.86.*.*" in your config, or did you just edit out the last two brackets for posting?

[SeeingBllue]

I edited it of course. I also checked with my game server host and the outbound IP is the same as the server IP according to them.

[eraserhead]

Two things i tried to rule out where the problem domain was:

1.Try to log into you MySQL database from your homecomputer. If that works then everything on the webservers end is working correctly.
2.Check out if your gameserver host has the possibility to host a MySQL database and make a connection with that database. That way you only have one provider to deal with when solving the problem.

[eraserhead]

Hi DN,

When will we have a web ranking update for the new soldier/demo update? There are new weapons that need to be addes to the weapon icons list.

[Lob (UK]

Its a bit confusing now because there are 2 authors doing the same plugin so i am not sure if the original thread by r5053 is still in use as this plugin is exactly the same one except for the latest web updates etc.

Anyway, Heres is my weapon error Log if it helps you with the new weapons. NOTE: There are a couple that where never sorted previously which i will paste too.

Existing errors

L 11/19/2009 - 17:04:32: [n1g-tf2-stats.smx] Weapon: telefrag
L 11/20/2009 - 20:23:21: [n1g-tf2-stats.smx] Weapon: deflect_flare

New errors so far after Soldier/Demo update

 
L 12/18/2009 - 03:50:31: [n1g-tf2-stats.smx] Weapon: taunt_soldier
L 12/18/2009 - 04:08:40: [n1g-tf2-stats.smx] Weapon: rocketlauncher_directhit
L 12/18/2009 - 04:08:50: [n1g-tf2-stats.smx] Weapon: pickaxe
L 12/18/2009 - 04:18:10: [n1g-tf2-stats.smx] Weapon: demoshield
L 12/18/2009 - 06:05:06: [n1g-tf2-stats.smx] Weapon: taunt_demoman
L 12/18/2009 - 06:06:57: [n1g-tf2-stats.smx] Weapon: sticky_resistance
L 12/18/2009 - 09:35:03: [n1g-tf2-stats.smx] Weapon: sword

- Lob (UK)

[DarthNinja]

Originally Posted by Lob (UK Its a bit confusing now because there are 2 authors doing the same plugin so i am not sure if the original thread by r5053 is still in use as this plugin is exactly the same one except for the latest web updates etc. Anyway, Heres is my weapon error Log if it helps you with the new weapons. NOTE: There are a couple that where never sorted previously which i will paste too. Existing errors L 11/19/2009 - 17:04:32: [n1g-tf2-stats.smx] Weapon: telefrag L 11/20/2009 - 20:23:21: [n1g-tf2-stats.smx] Weapon: deflect_flare New errors so far after Soldier/Demo update L 12/18/2009 - 03:50:31: [n1g-tf2-stats.smx] Weapon: taunt_soldier L 12/18/2009 - 04:08:40: [n1g-tf2-stats.smx] Weapon: rocketlauncher_directhit L 12/18/2009 - 04:08:50: [n1g-tf2-stats.smx] Weapon: pickaxe L 12/18/2009 - 04:18:10: [n1g-tf2-stats.smx] Weapon: demoshield L 12/18/2009 - 06:05:06: [n1g-tf2-stats.smx] Weapon: taunt_demoman L 12/18/2009 - 06:06:57: [n1g-tf2-stats.smx] Weapon: sticky_resistance L 12/18/2009 - 09:35:03: [n1g-tf2-stats.smx] Weapon: sword - Lob (UK)

The other plugin is unmaintained, the author hasn't logged in in over 2 months the last time I checked.

I've been avoiding editing the plugin, mostly because the web stuff was easier, and because the plugin is 3000+ lines of code .

I wasn't aware about the telefrag and flare deflect, but I'll make sure to add those along with the new weapons.
I'm giong to wait a little while though, until sourcemod is fixed for the new update.

Thanks for posting the weapon names so I don't have to hunt for them ;)

[MjrNuT]

lol telefrag

it had drown.

I don't blame you for holding off on the plugin. Makes even more sense considering all the new things to track and SM in general due to the update.

Thanks for the update on things.