[Lolz0r]

Now write this in chat:

* You are not ranket.
* Could not display the top.
* Could not display the top

In console:

L 03/25/2012 - 14:57:11: [stats_custom.amxx] Error selecting rank: no such column: kills
L 03/25/2012 - 14:57:13: [stats_custom.amxx] Error selecting rank: no such column: kills
L 03/25/2012 - 14:57:14: [stats_custom.amxx] Error selecting rank: no such column: deaths
L 03/25/2012 - 14:57:17: [stats_custom.amxx] Error saving player data: table stats_custom has no column named kills
L 03/25/2012 - 14:57:17: [stats_custom.amxx] Error saving player weapon data: table stats_custom_weapons has no column named

And I have killss and deaths?

[Exolent[jNr]]

Probably because I updated the table structure.

Use this version, and run the "csstats_reset_custom" command from the server's console.

[Lolz0r]

When the write a command "csstats_reset_custom" in console a showed this - "near "," : syntax error"

And when a write /top15 and /bot15 server crashed. Also in console a showed this:

L 03/25/2012 - 21:06:47: [stats_custom.amxx] Error saving player weapon data: near ",": syntax error
L 03/25/2012 - 21:06:47: [stats_custom.amxx] Error saving player weapon data: near ",": syntax error

[Exolent[jNr]]

SQLite has weird query restrictions. Try it now.

[Lolz0r]

Now after write /top15 and /bot15 in console a write this:

L 03/25/2012 - 22:15:18: [stats_custom.amxx] Error selecting rank: ambiguous column name: deaths
L 03/25/2012 - 22:15:41: [stats_custom.amxx] Error selecting rank: ambiguous column name: deaths

And not display MOTD.

[Exolent[jNr]]

Fixed.

[Lolz0r]

The server again crash, after writes a commands - /top15 and /bot15, no errors in console, just crashes.

[Exolent[jNr]]

Fixed that.

[lqlqlq]

server is freeze for seconds when kill someone. (this is bug)

[Lolz0r]

Originally Posted by Exolent[jNr] Fixed that.

Okay, top statistic it work, but bot statistic no(you can remove it right in the new version). I found one problem:

Any value that i type for "cstats_rank" in the code, in the server when i type "amx_cvar csstats_rank" it is allways 0.

Originally Posted by lqlqlq server is freeze for seconds when kill someone. (this is bug)

+1

Originally Posted by Exolent[jNr] If everything works, I'll change the top from console to MOTD page.

Now when a top opens, could add MOTD page, here's one - photo + .txt file: