[ys24ys]

One idea was to add.

add a week rank mode :
Top10 1 week unit that displays a list of functions.(a weeked top10 ranker)

sm_rankweek 1/0 (1-on/ 0-off)
What do you think?? it is not simple?

[StevoTVR]

• 12/11/13 - v.0.4
  • Added commands to set players' point values manually
  • Added command to reset the stats database
  • Removed sm_stats_startpoints ConVar
    • New players now start at the average score of all players
  • Fixed server being able to call rank and top10 commands
  • Fixed plugin overriding database changes from other sources

[wangbochiang]

Originally Posted by StevoTVR 12/11/13 - v.0.4 Added commands to set players' point values manually Added command to reset the stats database Removed sm_stats_startpoints ConVar New players now start at the average score of all players Fixed server being able to call rank and top10 commands Fixed plugin overriding database changes from other sources

Nice Work!! Testing now for new version with old point database,
but I think average score is unfair to older player, but I'll let the plugin running for a while and see what will come up,
Thanks for supporting this plugin!!

[TUSK3N1337]

This plugin makes my server lag everytime a zombie gets killed can someone tell me why? My lerp is showing yellow/red just because of this plugin, HELP!

Edit: It Seem Like The lerp is turning yellow/red when you make a headshot. So It Only Appears to be headshots and objectives that makes the var go up to 10 idk why!??

[StevoTVR]

Originally Posted by TUSK3N1337 This plugin makes my server lag everytime a zombie gets killed can someone tell me why? My lerp is showing yellow/red just because of this plugin, HELP! Edit: It Seem Like The lerp is turning yellow/red when you make a headshot. So It Only Appears to be headshots and objectives that makes the var go up to 10 idk why!??

Are you using this with a sqlite or mysql database?

[TUSK3N1337]

I installed your plugin thats all I did I put the nmrihstats.smx in plugins and nmrihstats.sp in scripting, I dont know what im using because I have never heard of mysql or sqlite.

https://drive.google.com/file/d/0B95...it?usp=sharing

thats my database.cfg.

PS im a idiot

[StevoTVR]

Originally Posted by TUSK3N1337 I installed your plugin thats all I did I put the nmrihstats.smx in plugins and nmrihstats.sp in scripting, I dont know what im using because I have never heard of mysql or sqlite. https://drive.google.com/file/d/0B95...it?usp=sharing thats my database.cfg. PS im a idiot

By default it uses the default local sqlite database. You can add a section called nmrihstats to change that.

Anyway, the queries are all threaded, so it shouldn't be causing any gameplay lag. Your server must be running at capacity to get any noticeable lag from this plugin.

[TUSK3N1337]

This is the error Message I get.

L 12/16/2013 - 225:22: [SM] Plugin encountered error 25: Call was aborted
L 12/16/2013 - 225:22: [SM] Native "SetFailState" reported: [2003]: Can't connect to MySQL server on 'localhost' (10061)
L 12/16/2013 - 225:22: [SM] Displaying call stack trace for plugin "nmrihstats.smx":
L 12/16/2013 - 225:22: [SM] [0] Line 130, /home/groups/alliedmodders/forums/files/4/2/7/5/9/128101.attach::ConnectDatabase()
L 12/16/2013 - 225:22: [SM] [1] Line 114, /home/groups/alliedmodders/forums/files/4/2/7/5/9/128101.attach::OnPluginStart()
L 12/16/2013 - 225:23: [admin-sql-prefetch.smx] Could not connect to database "default": [2003]: Can't connect to MySQL server on 'localhost' (10061)
L 12/16/2013 - 225:24: [admin-sql-prefetch.smx] Could not connect to database "default": [2003]: Can't connect to MySQL server on 'localhost' (10061)

[StevoTVR]

Originally Posted by TUSK3N1337 This is the error Message I get. L 12/16/2013 - 225:22: [SM] Plugin encountered error 25: Call was aborted L 12/16/2013 - 225:22: [SM] Native "SetFailState" reported: [2003]: Can't connect to MySQL server on 'localhost' (10061) L 12/16/2013 - 225:22: [SM] Displaying call stack trace for plugin "nmrihstats.smx": L 12/16/2013 - 225:22: [SM] [0] Line 130, /home/groups/alliedmodders/forums/files/4/2/7/5/9/128101.attach::ConnectDatabase() L 12/16/2013 - 225:22: [SM] [1] Line 114, /home/groups/alliedmodders/forums/files/4/2/7/5/9/128101.attach::OnPluginStart() L 12/16/2013 - 225:23: [admin-sql-prefetch.smx] Could not connect to database "default": [2003]: Can't connect to MySQL server on 'localhost' (10061) L 12/16/2013 - 225:24: [admin-sql-prefetch.smx] Could not connect to database "default": [2003]: Can't connect to MySQL server on 'localhost' (10061)

Your database connection details are incorrect, or your database server is not configured properly. Do you have MySQL running on the same server as your game server?

If you don't know about databases, or if you only have one NMRiH server, you should just leave out the nmrihstats section and let the plugin use the default database.

[ys24ys]

Hi StevoTVR
I used to use this plugin is no problem. Thx.

I ask you.
one:
You are Top20, Top30 can I give to expand?

two:
Top User "STEAM auth ID" when to run the command output can be also set up?
or Automatically flag 'r' can I give you to add a feature?
I have Top10 is flag 'r' to give. but, SQLite Database Browser.exe is supported only English search for the inconvenience.(In order to provide special custom skins)