[ImHackinBored!]

I can't seem to get this to work properly.

Typing "rank" does nothing.
Wether the bot cvar is 0 or 1 bots still get points and are the only player to be listed in the "top" menu.
smx does load.
SQL errors " near "0": syntax error" in log when I am not using SQL.
Possible conflict with "connectannounce.smx" ?? as the connect announce does not work properly with this loaded.

Possible conflict with mani admin?

Stats pop up when making kills but don't seem to be correct and "rank" does nothing. Sentry building destroy is set to 3 but you still only get 1 point when destroying a sentry.

Are there any known conflicts or issues? Any information would be great.
I Look forward to update with engie.

[eraserhead]

@evilzk: I don't see a dump of your databases.cfg. Your databases.cfg is located in addons\sourcemod\configs. It looks like this:

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

Also i never had to edit the dbconnect php file other people had to edit to get it working. Maybe use the default one?

@Imhackinbored: Did you try disabling connectannounce.smx then? I heard other people had problems with SQLite but in the past it worked fine for me, only had to install .smx and .cfg file and it would work. Why would you use mani admin?

[Lob (UK]

Originally Posted by ImHackinBored! I can't seem to get this to work properly. Typing "rank" does nothing. Wether the bot cvar is 0 or 1 bots still get points and are the only player to be listed in the "top" menu. smx does load. SQL errors " near "0": syntax error" in log when I am not using SQL. Possible conflict with "connectannounce.smx" ?? as the connect announce does not work properly with this loaded. Possible conflict with mani admin? Stats pop up when making kills but don't seem to be correct and "rank" does nothing. Sentry building destroy is set to 3 but you still only get 1 point when destroying a sentry. Are there any known conflicts or issues? Any information would be great. I Look forward to update with engie.

The SQL Error you have posted means the Player has not been added to the Database which is why typing Rank wont do anything. If the player changes their name to something normal, they should then be added to the database just fine. I have already reported this issue to DathNinja in a previous post. Not sure what is causing it but it has only been occuring since the last plugin/TF2 update. http://forums.alliedmods.net/showpos...&postcount=653

The Building Destroy Points/Tracking you mention has also been previously reported and DarthNinja has it on the "To Do" list in the OP and is looking into it.

- Lob (UK)

[DarthNinja]

Update released:

Originally Posted by DarthNinja V6.5 Not released: Changes rolled into V6.6. V6.6 Added kill tracking for: Goomba Stomp (Mod) The Lugermorph The Big Kill The Frontier Justice The Wrangler The Gunslinger The Southern Hospitality The Blender Taunt (Gunslinger Taunt) The Guitar Taunt (Frontier Justice Taunt) Fixed bots getting points for killing buildings (hopefully) Now logs players' last used IPs Changed all cvar descriptions (ingame) for easier reading Reorganized handles and cvars in code (nothing you will notice). Added some more mysql/php/html filters to player names.

See second post for more infos.

I hope you like the update, rolled in some name filters in as well as bot building fixes and the new engi weapons.
I also added the bleed kill, goomba kill, and the sam and max weapons.

A new feature is that players IP addresses are now logged when they connect (like names).
This is mostly for administration reasons - my one server was DoS attacked just a little while ago and I got the attacker's IP, but I had no list to search through. Now it is possible to search a list of IPs in the database if you need to. (This feature is mysql only).
I may also use this to add a country flag next to players' names on the website in the future.

[ImHackinBored!]

Originally Posted by eraserhead @Imhackinbored: Did you try disabling connectannounce.smx then? I heard other people had problems with SQLite but in the past it worked fine for me, only had to install .smx and .cfg file and it would work. Why would you use mani admin?

It was "canannunce.smx" to correct myself. And having it loaded or disabled did not make any dfference. When I first loaded tf2-stats there was a garbled up message when players joined which I don't see anymore.

I just can't seem to part with Mani. I think It's the easy Rcon menu and Ive worked with Mani since before SM. I suppose it will be time to go out with the old eventually.

Originally Posted by Lob (UK The SQL Error you have posted means the Player has not been added to the Database which is why typing Rank wont do anything. If the player changes their name to something normal, they should then be added to the database just fine. I have already reported this issue to DathNinja in a previous post. Not sure what is causing it but it has only been occuring since the last plugin/TF2 update. http://forums.alliedmods.net/showpos...&postcount=653 The Building Destroy Points/Tracking you mention has also been previously reported and DarthNinja has it on the "To Do" list in the OP and is looking into it. - Lob (UK)

YES, The error's only come up with players that have "simple" names. It also explains why the bot is in the list, because he has a "simple" name. Not sure why it seems to ignore the bot cvar though. None-the-less this plugin is useless untill it supports all characters/names as almost everyone has something "special" in there name these days as it's the fad. I can't tell everyone to change there name.

As for the Building Destroy Points I'm glad to see it's been reported. It's one of the reasons why I wanted this plugin. Will be glad to see this fixed.

Thanks Again.

EDIT: I see an Update NOW. WIll TEST Now.

[ImHackinBored!]

Syntax Errors for names still. "Rank therefore does nothing"

Client "I'm_๖ۣۜHackin'_Bored!" connected (###############).
L 07/24/2010 - 00:39:24: [TF2_Stats.smx] SQL Error: near "0": syntax error

canannounce.smx conflict back?

[RANK] The Administrator connected from . [Rank: 1 of 1]

Sentry is set to "3" by deafault but still does not give 3 points

[RANK] you got 1 points for destroying object

Found all this within the first few minutes of testing.

[DarthNinja]

I have not had any problems like the ones described, my database has over 22,000 players in it, and nobody has reported not being added correctly.
Since the problem doesn't seem to occur for me, please post the following information so I can try to reproduce to problem.

If you have an issue with players not being added, please post the following information:

Version of plugin:
I am experiencing this issue using: SQLite , MySQL (pick one)
Names of players the issue is happening to:


Please include part of your log where the error is listed (5 or so lines up and down from the error). Please use CODE tags.
Example:

L 07/23/2010 - 23:17:46: [funcommands.smx] "Console<0><Console><Console>" drugged "nevets<1825><STEAM_0:0:13415696><>"
L 07/23/2010 - 23:18:06: [funcommands.smx] "Console<0><Console><Console>" undrugged "nevets<1825><STEAM_0:0:13415696><>"
L 07/23/2010 - 23:20:57: [namechecker.smx] Checked Name: Hot Taco (Size: 8)
L 07/23/2010 - 23:21:18: [namechecker.smx] Checked Name: DestructO (Size: 9)
L 07/23/2010 - 23:21:28: [TF2_Stats.smx] DatabaseInit (CONNECTED) with db config
L 07/23/2010 - 23:21:29: [TF2_Stats.smx] SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `Player` ADD `KW_SntryL1` INT NOT NULL DEFAULT '0';ALTER TABLE `Play' at line 1
L 07/23/2010 - 23:09:07: [namechecker.smx] Checked Name: jerz (Size: 4)
L 07/23/2010 - 23:09:24: [afk_manager.smx] [AFK Manager] [TH]TehBladeZ0rz<1840><STEAM_0:0:23602882><> was moved to spectate for being AFK too long.
L 07/23/2010 - 23:09:36: [namechecker.smx] Checked Name: [TH]TehBladeZ0rz (Size: 16)
L 07/23/2010 - 23:10:07: [namechecker.smx] Checked Name: Casbah (Size: 6)
L 07/23/2010 - 23:10:09: [namechecker.smx] Checked Name: Bitch Plz (Size: 9)

Please include a list of plugins if you are running anything unusual.
Please include any other information you think might be helpful.

[ImHackinBored!]

"[TF2] Player Stats" (6.6) by DarthNinja, R-Hehl

SQLite

My In-Game Name: I'm_๖ۣۜHackin'_Bored!
The "๖ۣۜ " Can be found in MANY names including many people who join my server.

Given the error only appears when someone connects there isn't really anything before and especially after the error to post.

****** Finished executing mani_server.cfg ******
Unknown command "rank_deflect_flarepoints"
[RTD] Version: 0.3.8.1 loaded.
Connection to Steam servers successful.
   VAC secure mode is activated.
Client "I'm_๖ۣۜHackin'_Bored!" connected (#########:#####).
L 07/24/2010 - 00:39:24: [TF2_Stats.smx] SQL Error: near "0": syntax error

Log File

L 07/24/2010 - 00:36:33: SourceMod log file session started (file "L20100724.log") (Version "1.3.3")
L 07/24/2010 - 00:36:33: -------- Mapchange to ctf_2fort --------
L 07/24/2010 - 00:36:34: [GEOIP] GeoIP database info: GEO-106FREE 20091001 Build 1 Copyright (c) 2009 MaxMind Inc All Rights Reserved
L 07/24/2010 - 00:36:34: [funcommandsX.smx] Game detected as Team Fortress 2: Source (GAME_TF2)
L 07/24/2010 - 00:36:35: [TF2_Stats.smx] DatabaseInit SQLLITE (CONNECTED)
L 07/24/2010 - 00:39:24: [TF2_Stats.smx] SQL Error: near "0": syntax error
L 07/24/2010 - 00:43:26: [basecommands.smx] "Console<0><Console><Console>" changed map to "cp_dustbowl"
L 07/24/2010 - 00:43:29: [SM] Changed map to "cp_dustbowl"
L 07/24/2010 - 00:43:43: -------- Mapchange to cp_dustbowl --------
L 07/24/2010 - 00:45:12: [TF2_Stats.smx] SQL Error: near "0": syntax error
L 07/24/2010 - 00:46:16: [funcommands.smx] "I'm_๖ۣۜHackin'_Bored!<2><STEAM_0:0:19064440><>" toggled noclip on "I'm_๖ۣۜHackin'_Bored!<2><STEAM_0:0:#########><>"
L 07/24/2010 - 01:15:56: [SM] Changed map to "tc_hydro"
L 07/24/2010 - 01:16:05: -------- Mapchange to tc_hydro --------

List of plugins loaded at the time:
[SM] Listing 26 plugins:
01 "Admin File Reader" (1.3.3) by AlliedModders LLC
02 "Admin Help" (1.3.3) by AlliedModders LLC
03 "Admin Menu" (1.3.3) by AlliedModders LLC
04 "Advertisements" (0.5.5) by Tsunami
05 "Anti-Flood" (1.3.3) by AlliedModders LLC
06 "Auto Name Changer" (3.0) by MoggieX
07 "Basic Ban Commands" (1.3.3) by AlliedModders LLC
08 "Basic Chat" (1.3.3) by AlliedModders LLC
09 "Basic Comm Control" (1.3.3) by AlliedModders LLC
10 "Basic Commands" (1.3.3) by AlliedModders LLC
11 "Basic Info Triggers" (1.3.3) by AlliedModders LLC
12 "Basic Votes" (1.3.3) by AlliedModders LLC
13 "Connect Announce" (0.7) by Arg!
14 "Client Preferences" (1.3.3) by AlliedModders LLC
15 "fakeitem.smx"
16 "Fun Commands" (1.3.3) by AlliedModders LLC
17 "Fun Commands X" (1. by Spazman0 and Arg!
18 "Fun Votes" (1.3.3) by AlliedModders LLC
19 "Deluxe Godmod" (1.1.0) by DarthNinja
20 "Nextmap" (1.3.3) by AlliedModders LLC
21 "Player Commands" (1.3.3) by AlliedModders LLC
22 "[TF2] Pumpkin" (0.2) by linux_lover
23 "Reserved Slots" (1.3.3) by AlliedModders LLC
24 "[TF2] Roll The Dice" (0.3.8.1) by linux_lover
25 "Sound Commands" (1.3.3) by AlliedModders LLC
26 "[TF2] Player Stats" (6.6) by DarthNinja, R-Hehl

Extra Info:
No error's appear for the building destroy problem, it simply does not give correct ammount of points.

Bot problem (Bot's are in the "top" menu) has no error's it simply "seems to ignore" the cvar "rank_ignorebots"

Cvar "rank_deflect_flarepoints" is Unkown to server period.

[DarthNinja]

I think the problem you are having is related to SQLite. I use mysql and there are lots of players with special chars that track properly, such as:
☠☣ *ShakeNbake*☣ ☠
Mïĉħæļ ĵǻçķ§☺ñ
[PSI] ๖ۣۜBlazer

I see what the bug with the sentry points is; valve changed the numbering of buildings, so the numbers were incorrect.
I'll post a fixed version in a couple minutes.

[ImHackinBored!]

Alright Thanks.

Any Ideas/fixes or suggestions (other than going to MySQL) about the names...