[DarthNinja]

Originally Posted by Algebraic! Thanks, but i really need to know how to make it so admins get ranked to Anyone?

Originally Posted by DarthNinja SQLite seems to be buggy lately. Use mysql if possible for the time being.

[Algebraic!]

Originally Posted by DarthNinja SQLite seems to be buggy lately. Use mysql if possible for the time being.

Originally Posted by Algebraic! Im just doing the simple version for my 1 server. No website. No SQL. I dont even know much of anything about SQL...

I don't use SQL....am i doing something wrong?

[twjohnny42]

Ranked module does not have any new updated version of the news?

When I set this plugins on my Server , It still Crash

[zenxeon]

Checking in on your progress

[Mlk27]

DarthNinja, do you have any plan to add unicode support in the plugin?

Btw, spotted some errors

TF2STATS_WEAPONERRORS.log

L 07/16/2010 - 16:21:11: [tf2_stats.smx] Weapon: bleed_kill
L 07/16/2010 - 16:45:36: [tf2_stats.smx] Weapon: frontier_justice
L 07/16/2010 - 16:46:15: [tf2_stats.smx] Weapon: wrangler_kill
L 07/17/2010 - 00:07:53: [tf2_stats.smx] Weapon: bleed_kill
L 07/17/2010 - 00:22:01: [tf2_stats.smx] Weapon: wrangler_kill
L 07/17/2010 - 00:24:01: [tf2_stats.smx] Weapon: southern_hospitality
L 07/17/2010 - 00:24:29: [tf2_stats.smx] Weapon: southern_hospitality

[Lob (UK]

Hi DarthNinja,

I have figured out what is causing the Syntax Errors that i mentioned in a previous post that i have been getting a lot of.

It is players who are not being added to the database due to letters/symbols/punctuation or other things in their name. This is why i am getting quite a lot of them.

Here are a couple of examples. These 2 players could not see their rank and where not in the database. Here are their names when they joined the Server and the Syntax Error occuring at the same time as they joined which prevented them from being added to the database and hence had no rank.

L 07/17/2010 - 11:48:57: "Cr(_)sTy™ ﴾UK﴿<436><STEAM_0:0:5810639><>" entered the game L 07/17/2010 - 11:48:57: [TF2_Stats.smx] SQL Error: near "0": syntax error L 07/17/2010 - 149:14: "The Cake Is a Spy!<750><STEAM_0:1:21904640><>" entered the game L 07/17/2010 - 149:15: [TF2_Stats.smx] SQL Error: near ",": syntax error

I asked both players to disconnect and change their names to something ordinary such as Crusty and Cake. When they both reconnected with ordinary names, the welcome message came up and they were both added to the database just fine and no syntax errors.

So the problem is with certain players names that contain certain letters/symbols/Punctuation Marks etc from what i can see.

Cheers

- Lob (UK)

[Crome]

I hope I don't get flamed for being an idiot, But I can't get the web interface to work.

database.cfg :

    "tf2stats"
        {
            "driver"                "mysql"
            "host"                "localhost"
              "database"                   "tf2stats"
               "user"                        "tf2stats"
              "pass"                        "*********"
                //"timeout"                  "0"
            "port"                "3306"
        }

settings.php :

$mysql_server = "localhost";
$mysql_user = "tf2stats";
$mysql_password = "*********";
$mysql_database = "tf2stats";

The plugin run's fine, It tracks kills and after checking PHPmyAdmin the database is full of entries.

When I go to my site I get the following:

[Wed Jul 21 16:27:09 2010] [error] [client **.**.**.**] PHP Notice:  Undefined variable: clanname in C:\\wamp\\www\\tf2stats\\index.php on line 12, referer: http://ukgamefurs.com/tf2stats/index.php
[Wed Jul 21 16:27:09 2010] [error] [client **.**.**.**] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\\wamp\\www\\tf2stats\\index.php on line 27, referer: http://ukgamefurs.com/tf2stats/index.php
[Wed Jul 21 16:27:09 2010] [error] [client **.**.**.**] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in C:\\wamp\\www\\tf2stats\\index.php on line 27, referer: http://ukgamefurs.com/tf2stats/index.php
[Wed Jul 21 16:27:09 2010] [error] [client **.**.**.**] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\\wamp\\www\\tf2stats\\index.php on line 30, referer: http://ukgamefurs.com/tf2stats/index.php
[Wed Jul 21 16:27:09 2010] [error] [client **.**.**.**] PHP Warning:  mysql_query() [<a href='function.mysql-query'>function.mysql-query</a>]: A link to the server could not be established in C:\\wamp\\www\\tf2stats\\index.php on line 30, referer: http://ukgamefurs.com/tf2stats/index.php

Any advice?

[eraserhead]

Did you read my guide at the beginning of this thread? Are you sure your gameserver and MySQL database are on the same machine?

[Crome]

Originally Posted by eraserhead Did you read my guide at the beginning of this thread? Are you sure your gameserver and MySQL database are on the same machine?

Yes, Your guide was very helpfull.

My game and webserver are both running on the same machine - I have already installed sourcebans with no problem on the same machine, Can't figure out what's going wrong here :S

http://ukgamefurs.com/tf2stats/index.php Link to my site if it's helpfull.

[eraserhead]

Did you create the user tf2stats and did you grant that user access to the mysql table called tf2stats?