[INACTIVE][INFO] CheeseStats v0.01

Discussion in 'Inactive/Unsupported Plugins' started by jahwag, Jan 17, 2011.

  1. Offline

    jahwag

    This plugin is similar to "LogBlocks" from hmod. It logs all blocks replaced by players into a mysql table containing the time/player/blocks/position.
    I'll be adding more features in the future.

    Download:
    http://forums.bukkit.org/attachment...3/?temp_hash=856a2c320f8da3c2070d0bee7096a1ea
    Mirror:
    http://hotfile.com/dl/97568319/ede4fe0/CheeseStats-v0_01.zip.html

    Source:
    https://github.com/jahwag/CheeseStats

    Changelog:
    -- 0.01 --
    Initial public release.

    Readme:
    Code:
    -- CHEESESTATS V.001 --
    
    -- INSTALLATION --
    1. Extract the entire archive into the directory where your craftbukkit jar is located.
    2. Create a mysql database called 'cheesestats' and execute the following queries:
    
    ---------------------------------------------------------------------------------------------------------
    
    CREATE TABLE  `cheesestats`.`Materials` (
      `materialType` int(10) unsigned NOT NULL,
      `materialName` varchar(25) NOT NULL,
      PRIMARY KEY (`materialType`)
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
    
    CREATE TABLE  `cheesestats`.`ReplacedBlocks` (
      `eventId` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
      `eventTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      `player` varchar(25) NOT NULL,
      `oldBlock` int(10) unsigned NOT NULL,
      `newBlock` int(10) unsigned NOT NULL,
      `xPos` bigint(20) NOT NULL,
      `yPos` bigint(20) NOT NULL,
      `zPos` bigint(20) NOT NULL,
      PRIMARY KEY (`eventId`),
      KEY `playerIndex` (`player`),
      KEY `timeIndex` (`eventTime`),
      KEY `fk_constraint1` (`oldBlock`),
      KEY `fk_constraint2` (`newBlock`),
      CONSTRAINT `fk_constraint1` FOREIGN KEY (`oldBlock`) REFERENCES `Materials` (`materialType`),
      CONSTRAINT `fk_constraint2` FOREIGN KEY (`newBlock`) REFERENCES `Materials` (`materialType`)
    ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1
    
    ---------------------------------------------------------------------------------------------------------
    
    -- BUILDING/COMPILING --
    In CheeseStats/lib/ execute install.sh to install the bukkit library which is not available from any public repo.
    
    -- CONFIGURATION --
    You can configure your MySQL settings in cheese/CheeseStats.properties.
    
     

    Attached Files:

  2. Offline

    poopiepants

    Hello,

    thanks for the plugin.
    When entering the sql command I receive the following error.

    #1064 - 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 'CREATE TABLE `cheesestats`.`ReplacedBlocks` ( `eventId` bigint(20) unsigned ' at line 7


    Also this line in the readme
    BUILDING/COMPILING --
    In CheeseStats/lib/ execute install.sh to install the bukkit library which is not available from any public repo.

    I am installing this on a windows box, is this necessary?

    Thank you for the plugin!

    Poopiepants
     
  3. Offline

    anon

    SQLite suport?
     
  4. Offline

    jahwag

    Try running the create table queries one at a time. That made it work for me in MySQL Query Browser.

    It's not necessary to compile and build the maven project because the binaries for the latest revision are already there. It's only meant for developers. I'll add that as a comment to avoid confusion.


    There's no SQLite support. Only MySQL support. In the future PostgreSQL and others may also be added(only requires slight modification to the existing source in case somebody wishes to do it themselves).
     
  5. Offline

    poopiepants

    It worked. Doh! I can't believe I didn't try that.
    Thank you for the quick response.

    I am new to minecraft, so I am not familiar with the old logblock version.
    Is this mainly to rollback griefers or can it also be used for stats displayed?
    Thank you for your help, it is greatly appreciated.
     
  6. Offline

    jahwag

    It's intended both to rollback griefers and for displaying stats.

    New version is coming soon with several updates. It will log more stuff like deaths, kills etc.
     
  7. Offline

    subarct1c

    Are we going to see the ability to check on a per block level what changed while in world like LogBlock did by right clicking with the tool?
     
  8. Offline

    Kainzo

    Can we get a sqlite version?
     
  9. i would like to know if you maybe put an php output that we can show stats on the web
     

Share This Page