Chat, GUID, Stats and Mapstats Logger[3.0.2.2] 01.02.

[ImportBot]

Originally Posted by BB-Insomnia*:

 

imagine an 32 Slot server with some kids abusing this feature... 1000 lines of ranks in a minute :-( wouldn't be fun ^^

[ImportBot]

Originally Posted by EBassie*:

 

imagine an 32 Slot server with some kids abusing this feature... 1000 lines of ranks in a minute :-( wouldn't be fun ^^

Never had any problems with it when running WolfRcon. There are only a few people per round checking their stats.

[ImportBot]

Originally Posted by BB-Insomnia*:

 

neither i had such a problem yet.

how about a !rank for you, and @rank to show it to all, and @rank =BB=Insomnia to show the rank of =BB=Insomnia to all?

[ImportBot]

Originally Posted by Phogue*:

 

Unofficial convention within procon is ! for public, # for admins and @ for private responses. Usually if I add something in to a plugin I've written that spams the server I put in a way to disable or limit it to private responses only. I still make ! do something, but instead just pipe it to private chat. The bfbcs statsphile plugin has only that single setting in it.

[ImportBot]

Originally Posted by XpKiller*:

 

logging for weapons is done

 

will able to pull your weaponstats for a specific weapon with the command @stats weaponname example: @stats M95 and your weaponstats show up.

 

i maybe upload tomorrow.

[ImportBot]

Originally Posted by EBassie*:

 

Sounds great XpKiller!

Have you thought about what phogue said about the stats output?

 

@ is private

! is public

[ImportBot]

Originally Posted by XpKiller*:

 

I want to rename the table tbl_PlayerGUID to tbl_PlayerStats anyone against this?

[ImportBot]

Originally Posted by EBassie*:

 

Fine with me!

 

Will you make it automatic, or do we have to manually change the tablename?

[ImportBot]

Originally Posted by XpKiller*:

 

I will put the needed sql commands into the zip file

[ImportBot]

Originally Posted by HunterBfV*:

 

I want to rename the table tbl_PlayerGUID to tbl_PlayerStats anyone against this?

Please do only use lowercase table names. I always tend to forget to check your latest plugin code release, then I got multiple tables on my linux sql and need to migrate them, plus run a find and replace in your code. ;-)

 

thx!

[ImportBot]

Originally Posted by HunterBfV*:

 

What about:

 

[19:40:55 45] Error: System.Data.Odbc.OdbcException: ERROR [23000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Duplicate entry 'tombsm8-782e2bf87724e7f0c066f125bbd51071' for key 2

I am getting the same error from time to time running a linux sql.

I thought it may have to do with special characters in player names forcing the syntax to go wrong?

[ImportBot]

Originally Posted by XpKiller*:

 

What about:

 

[19:40:55 45] Error: System.Data.Odbc.OdbcException: ERROR [23000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.91-community]Duplicate entry 'tombsm8-782e2bf87724e7f0c066f125bbd51071' for key 2

I am getting the same error from time to time running a linux sql.

I thought it may have to do with special characters in player names forcing the syntax to go wrong?

No this has nothing to do with special character in my opinion this is a database issue also the mysql version is quite old.

 

 

I will change all table names to lower case due better Linux support

The table columns will stay upper and lower case i won't touch them !

[ImportBot]

Originally Posted by HunterBfV*:

 

Ok, I will keep an eye on the next error messages coming up and try to copy & paste them here.

thx!

[ImportBot]

Originally Posted by XpKiller*:

 

I will run a last test today and if every thing is fine I will upload the new version.

[ImportBot]

Originally Posted by EBassie*:

 

XpKiller,

 

are you planning to use Procons new HTTP daemon feature?

[ImportBot]

Originally Posted by XpKiller*:

 

*bump*

 

Ask if you got Questions!!!

 

Give Feedback!!!!

 

New Version 2.0

 

Changelog:

1.5x --> 2.0

 

renamed tables tbl_ChatLog --> tbl_chatlog and tbl_PlayerGUID --> tbl_playerstats for better Linux Mysql Support

 

Drop your old tables or use the tablemodifier.sql

 

now stats for all Weapons in Game with own ranking system!!

 

now top10 for all Weapons in Game due the own ranking system

 

call weaponsstats with the command: [@,!,#]stats Weaponname --> @stats M95

 

call top10 Player for specific Weapon with [@,!,#]top10 Weaponname --> @top10 M95

 

WeaponNames are changeable so you call the 40mmgl with weaponname Noobtube

 

Now using ! for sending stats to all and @,# only to the player who request + the function to disabled sending it to all

 

Some mirror bugfixes and performance tweaks

 

[ImportBot]

Originally Posted by EBassie*:

 

Nice upgrade XpKiller!

 

I hope my database doesn't explode thought!

Will check for possible problems. Database conversion was flawless.

[ImportBot]

Originally Posted by EBassie*:

 

Found some bugs:

%rounds% seems to be displaying %playerHeadshots% when displayed.

 

Players already in DB (I used the conversion) do not seem to update correct:

No country, lastseen does not always update (i think).

[ImportBot]

Originally Posted by XpKiller*:

 

To the first one: I will take look I tweaked the querys so it might be possible that something gone wrong

 

To the second one: I cannot fill fields with data I don't have. Some fields like Firstseenonserver are only updated at first insert but I will review that too

[ImportBot]

Originally Posted by EBassie*:

 

HI XpKiller,

 

it seems sometimes score is not updated / inserted correct.

I got a lot new player entries with kills in it, but NO score.

[ImportBot]

Originally Posted by XpKiller*:

 

HI XpKiller,

 

it seems sometimes score is not updated / inserted correct.

I got a lot new player entries with kills in it, but NO score.

I found the bug I forgot to save the score if a player leave before roundend is now fixed

The other bugs are fixed to load up the new version in a few hours

 

I also optimized the SQL querys they are now 35% - 500% faster than before!!!

[ImportBot]

Originally Posted by EBassie*:

 

Great work XpKiller!

Thank you!

[ImportBot]

Originally Posted by BB-Insomnia*:

 

I also optimized the SQL querys they are now 35% - 500% faster than before!!!

CHEATER! Turn off your time hack!

Nice!

[ImportBot]

Originally Posted by YoDaNaDeS*:

 

hey mate when i have this enabled on my server and it changes map this makes procon crash.

 

this is the error i get

 

Description:

Stopped working

 

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: procon.exe

Problem Signature 02: 0.5.4.8

Problem Signature 03: 4c513f77

Problem Signature 04: System.Data

Problem Signature 05: 2.0.0.0

Problem Signature 06: 4a274a01

Problem Signature 07: 19cc

Problem Signature 08: 19

Problem Signature 09: System.Data.Odbc.OdbcException

OS Version: 6.1.7600.2.0.0.256.1

Locale ID: 1033

 

when its disabled everything runs fine, have i installed it incorrectly maybe?

[ImportBot]

Originally Posted by EBassie*:

 

Did you:

 

Disable Sandbox restictions in Procon

Stop Procon

If want to keep you old stats data use the tablemodifier.sql to change the tables

Put the tableconfig.cfg into the procon folder( there where the PRoCon.exe is)

Put the plugin file into the pluginfolder

Start Procon

Setup the Plugin

[ImportBot]

Originally Posted by XpKiller*:

 

hey mate when i have this enabled on my server and it changes map this makes procon crash.

 

this is the error i get

 

Description:

Stopped working

 

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: procon.exe

Problem Signature 02: 0.5.4.8

Problem Signature 03: 4c513f77

Problem Signature 04: System.Data

Problem Signature 05: 2.0.0.0

Problem Signature 06: 4a274a01

Problem Signature 07: 19cc

Problem Signature 08: 19

Problem Signature 09: System.Data.Odbc.OdbcException

OS Version: 6.1.7600.2.0.0.256.1

Locale ID: 1033

 

when its disabled everything runs fine, have i installed it incorrectly maybe?

Looks like an problem with the MYSQL odbc driver because i catch all exceptions so that it wont crash

Try to reinstall the Odbc Driver

[ImportBot]

Originally Posted by XpKiller*:

 

hey mate when i have this enabled on my server and it changes map this makes procon crash.

 

this is the error i get

 

Description:

Stopped working

 

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: procon.exe

Problem Signature 02: 0.5.4.8

Problem Signature 03: 4c513f77

Problem Signature 04: System.Data

Problem Signature 05: 2.0.0.0

Problem Signature 06: 4a274a01

Problem Signature 07: 19cc

Problem Signature 08: 19

Problem Signature 09: System.Data.Odbc.OdbcException

OS Version: 6.1.7600.2.0.0.256.1

Locale ID: 1033

 

when its disabled everything runs fine, have i installed it incorrectly maybe?

Looks like an problem with the MYSQL odbc driver because i catch all exceptions so that it wont crash

Try to reinstall the Odbc Driver

Update New version 2.01

2.00 --> 2.01

 

fixed %rounds% and %playerHeadshots% where switched

CountryCode will be updated after every Round now

fixed Scoreloging for Player who left server before Roundend

greatly improved the performance of the SQL-Querys(Select querys), they are now 35% to 500% faster than before

[ImportBot]

Originally Posted by EBassie*:

 

Thanks for the fast update.

Seems to work great now!

[ImportBot]

Originally Posted by Repoman1*:

 

Just a quick question for Disable Sandbox restictions in Procon is this to stay perm....disabled or just for the plugin update?

[ImportBot]

Originally Posted by XpKiller*:

 

The plugin reads the keywords out of the tableconfig.cfg also the the tablebuilder reads the names of the tablecolumns out of this file. If the sandbox restrictions are not disabled the plugin cant do this and wont work.