[Mems]

Originally Posted by otacontoaster 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. 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: "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

Look at your mysql info.

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

Are you sure user "root" with NO password is going to work? Make sure the host is correct, sometimes you need the full address.

[owen_a]

Yes, but no one understands.

Below I'll show an example of the username and password. ( These arnt REAL passwords. )

My username for my database is: root

My password is: mysql555

My Database is: tf2_stats

-----------------------------------------------------------

In my web config i have:

<?php
$mysql_server = "localhost";
$mysql_user = "root";
$mysql_password = "mysql555";
$mysql_database = "tf2_stats";
function db_escape ($post)
{
if (is_string($post)) {
if (get_magic_quotes_gpc()) {
$post = stripslashes($post);
}
return mysql_real_escape_string($post);
}

foreach ($post as $key => $val) {
$post[$key] = db_escape($val);
}

return $post;
}
?>

-----------------------------------------------------------------------

And my Game config will Look Something Like This:

"tf2stats"
{
"driver" "mysql"
"host" "127.0.0.1"
"database" "tf2_stats"
"user" "root"
"pass" "mysql555"
//"timeout" "0"
"port" "3306"
}
}

-----------------------------------------------------------------------

After all that I Save all the configs, Start the TF2 Server. Perfect it connects to to the database like a dizzle.

Now Load the website, getting excited to see if it works, and those god damn errors show!

This is a mini auto-biography on what i have done!!!! As you can see THERE IS NOTHING WRONG!

No Offense " r5053 ", but my only intention is, is that it is Lack of programming.

[Kataan]

Owen I suggest you wait until version 5 is released, which should be very soon.

[Mems]

It's not the authors fault. It worked flawlessly on my setup [:

[r5053]

Originally Posted by Kataan Owen I suggest you wait until version 5 is released, which should be very soon.

This is too my opinion Please stop posting problems with the actual webinterface, the new one will be out shortly.

[Lob (UK]

Hi,

Firstly, i would just like to say Thank You for this excellent Stats Plugin. I have been using it on all my TF2 Servers (Just plugin version with no webinterface) for around a Year (only just registered now though LoL) and it is the best around by far and extremely popular. My community and all players Love it and we have almost 20 thousand players on my 2Fort Server.

My members have regularly been requesting an additional feature for the ingame usage so i thought i would post the request.

Would it be possible to have an ingame chat command of say "top" so players can view a popup of say a list of the top 10 players (like the current top10 command) but with an additional option of "next" so they can carry on from 11-20 and then 21-30 etc. A bit like Mani stats if you know what i mean. It is so they can view the target points they need to beat to move up the rankings etc. The only way they can do that at the moment is to type players and view the players ranks whom are currently on the Server hoping that some of them are quite high up etc.

Thanks again for this Top Stats Plugin

- Lob (UK)

[Max_Damage]

Thanks for this plugin, i've got it to work for the most part i believe.
The only problem that I have is, are the MySQL fields created automatically?

[r5053]

Originally Posted by Max_Damage Thanks for this plugin, i've got it to work for the most part i believe. The only problem that I have is, are the MySQL fields created automatically?

yes everything it does automatic, if you start it the first time with a Mysql DB it creates the table, and if it's required it updates the mysql tables after a plugin update.

[r5053]

one minute ago i've submitted the RC1 of version 5 to the Testers for internal testing.

Here's the Changelog of Version 5:

+added cvar: rank_extendetlogging "0"
+added extended logging
*optimized deathflag handeling
+added cvar: rank_extlogcleanuptime "72" // "Defines the time until a entry in the Kill log gets removed in hours 0 = disabled"
+new say command:hidepoints
+new say command:unhidepoints
+added funktion that loads clients settings on connect (for now this is the Setting if the client see it if he earn points or not (requires rank_pointmsg 2)
*prevents pda_engineer_build from getting logged into the weapon error logfile
*changed the size of the string array in the say command funtkion to fix a log error
*added a debug output to extinguish
*fixed showing the servername if you extinguish someone (seems to be a bug who has to be fixed by valve, i disabled showing the name if the extinguished value is wrong)
*fixed showing the servername if you steal a sandvich from someone
*fixed showing points if you get no points for a kill
+added cvar who enables and disables getting points (rank_enable)
+added Chat output on changing rank_enable
*complete reworked the Top Menu now it shows the top 100

[Lob (UK]

Excellent stuff.

Thanks very much for changing the Top menu to show the top100.

Very much appreciated.

Looking forward to your official release.

- Lob