[TF2 Stats] With Web Ranking and Item Logger [v9.1.0] - Page 161

CoolJosh3k

Feature request:

Ingame command to reset player k/d stats.
Cvar to control whether players can reset their own stats.

lionheart1066

My servers seem to be having a rather odd and annoying bug with this ranking plugin since the uber update. The plugin is very slow at responding to anyone who says top10 or rank and at the start of every round or so it decides to spam everyones rank for about a minute.

galadril

Quote:

Originally Posted by galadril

Aha, the errors are different now.. I'll check it out somewhere this weekend.!

@Dritz
Please try this version:
http://www.multiupload.com/G6QFO0963A

This should 'most' of the errors..

**DarthNinja**

Quote:

Originally Posted by lionheart1066

My servers seem to be having a rather odd and annoying bug with this ranking plugin since the uber update. The plugin is very slow at responding to anyone who says top10 or rank and at the start of every round or so it decides to spam everyones rank for about a minute.

Sounds like your database server is being slow to respond.

The cvars should disable the round-end chat spam by default, I'll have to check into that.

Obsidian

Just a thought...DarthNinja, you could add something to diagnose a slow database command in the future with a dummy command that runs a quick...eh, let's say a SELECT query and displays the response time of the DB server to the admin that ran the command (either in chat or in console...console would probably be best).
That'd help you and the end user diagnose a laggy database conn. I'm not sure how easy it would be to implement though, I've no experience with sourcemod. I'm just a web app developer.

**DarthNinja**

Sounds pointless.

legify · *Last edited by legify; 07-05-2011 at 15:18.*

I recently imported players from sqlite and set up mysql for tf2stats. It's not recording any online players.
This is what I get when I do sm plugins refresh via rcon.

TF2 Stats Failed to connect! Error: [1130]: Host '8.17.250.114' is not allowed to connect to this MySQL server
L 07/05/2011 - 12:08:41: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 07/05/2011 - 12:08:41: [SM] Displaying call stack trace for plugin "TF2_Stats.smx":
L 07/05/2011 - 12:08:41: [SM] [0] Line 5928, TF2_Stats.sp::createdbtables()
L 07/05/2011 - 12:08:41: [SM] [1] Line 496, TF2_Stats.sp::OnPluginStart()

I've added my gameserver IP to the Remote Database Access Hosts already.

legify · *Last edited by legify; 07-05-2011 at 17:51.*

Still need help ;[
EDIT: fixed

exesto · *Last edited by exesto; 07-06-2011 at 10:13.*

Where i can get a Player.sql database script. Bcoz when i add all scripts from sqlscripts folder, the player DB didnt show up.
And someone can please help me with error what shows in my page http://tf2.4id.lv/tf2stats/

Now i get somehow players to show, but palyer DB still is broken. Not showing each player stats.
And other question is that i have changed all what is in tutorial in database.cfg, but when server start it shows that connected to SQL lite, but i need to connect to mysql.

**DarthNinja**

galadril:
I think you need to do some error handing on the site.
For example if the Players table doesn't exist:

PHP Code:


			
die("Setup and run the plugin first!");