SvrStats
This is a stat logging plugin that logs everything from blocks broken to characters chatted to time online. It has MySQL support, but currently no commands as it's (currently) meant for online stats (and you have to make the frontend yourself). In the future i might go ahead and add commands or a frontend but right now i'm focused on adding moar stuff to log. GitHub (Source)
Backstory
I was surfing the interwebz, when suddently i saw a page for some server's player stats. I then thought "this would be good for my server" and i checked out the server's website. Turns out they were selling the stat system for 200 dollars. I thought "i can do this myself" and then went on coding, while testing on a production server (i'm hardcore like that).
Technical stuff
When the plugin first launches, it connects to the database. If the connection is successful, it checks if there's a table named "stats" in the selected database. If there isn't, it creates one.
When a player joins, it checks if the player is in the database. If not, it creates a coloumn for the player with the default values. Here's the field specs:
field | description |
---|---|
player | The name of the player. |
joins | The amount of times the player has joined. |
lastjoin | The last unix time the player joined the server. |
playtime | Amount of seconds the player has played on the server. |
firstjoin | The first unix time the player joined the server. Set to the current unix time when the coloumn is created, then never modified. |
chatchar | Amount of characters typed in chat. |
chats | Amount of chat messages sent. |
placed | Amount of blocks placed. |
broke | Amount of blocks broken. |
My console gets spammed pretty badly with things such as
[Server] SEVERE Could not pass event BlockPlaceEvent to SvrStats..
I guess an update of 1.3.2 would do the job.
Great job love it!! it just works!
Just letting you know, I already created a plugin for this :p
BukkitStats It uses a PHP API instead of connecting directly to the MySQL Database, which allows for using remote MySQL Hosting (reduces lag)
I'm in the progress of adding more features such as blocks placed and broken, waiting tell i have about 10 changes before the next update push