Inactive [INFO/ADMIN] LogBlock v1.54 - Enderdragon Logging! Tree Grow Logging! [1.4.5]

Discussion in 'Inactive/Unsupported Plugins' started by DiddiZ, Feb 15, 2011.

  1. Offline


    Version: 1.50​
    Find and Backroll those Damn Griefers
    LogBlock release are on DevBukkit:

    LogBlock dev builds:

    Please read the installation guide

    I won't port LogBlock myself to mcAPI. Source code is available, so it shouldn't be to difficult for someone else to do it, also I'm still here. so I can answer questions. If there is more than one willing, that's up to you to handle that.

    The reasons I take this step, are the usual: I quit playing Minecraft about 5 months ago and lastly I was struggling to keep up with updates. The developement of Guardian made slow progress, so I fear it won't be ready to fully replace LB in time.

    Download latest dev build: Jenkins
    View the source code: GitHub
    Table of contents:
    1. Description
    2. Features
    3. Why to use LogBlock
    4. Example command
    5. Older versions
    6. Change log
    7. Todo list / feature requests
    8. Permission nodes
    9. Plugins supporting this
    10. Support the dev
    11. How to post error messages
    12. Advertizing

    LogBlock logs block changes into a MySQL database. Block changes can be placed or destroyed block, explosions, burned blocks, sign text changes, chest access, leaves decay etc.
    It can be used as griefer identification tool, to find out who build a particular building, or even roll back changes by certain players. Other purposes can be e.g: Undoing of forest fires
    All additional features are optional, to keep the database as short as possible. All database actions run in their own threads to avoid server lags.
    The use of permissions plugin (or any clone) is possible, but not necessary.
    Uses Spout for chest logging (but it's fully optional, and there is no need for the client mod at all).

    • Logging for block placing, block braking, fire, explosions, leaves decay, signtexts, lava flow and chest content
    • Very mighty commands system, not only allowing to rollback and redo, but also to tp to blockchanges, delete log ingame etc. Full list of commands.
    • Many parameters for lookup/rollback/redo/tp/clearlog commands: Block changes of one ore more player, in a specific area, in a world edit selection, specific block types only, block changes older or newer that a specific date, destroyed/created block only, in a different world and combinations of all these parameters. Full list of parameters.
    • Rebuilding map after importing a backup (/lb redo)
    • Last parameter to use the parameters of the last command
    • Quick ingame lookup of block history a wood pickaxe or a bedrock block.
    • All commands accessible from console (exept tools :D)
    • Custom queries for tools.
    • Different tool modes (lookup, rollback, redo, writelogfile and clearlog)
    • Saves block data like wool color, log type, torch adjustment, etc
    • Multiworld and multiserver support (some servers sharing the same database)
    • BigBrother log import
    • Loggable super pickaxe plugin (not to confuse with WorldEdit's super pickaxe)
    • API
    • Webstats
    Why to use LogBlock:

    Example commands: (thanks to tha d0ctor, read more about commands here)

    /lb rollback player fire since 1d3h – rolls back fire 1 day 3 hours
    /lb rollback player fire since 1d3h area 15 – rolls back fire 1 day 3 hours within a radius of 15 blocks

    /lb rollback player thad0ctor since 1h - rolls back thad0ctor 1 hour
    /lb rollback player thad0ctor since 1d area 5 – rolls back thad0ctor actions for the last day within 5 blocks
    /lb rollback area 10 since 1h30m - rolls back all modifications within 10 blocks since the list 1 hours and 30 mins
    /lb rollback area 10 before 06.11.2011 - roll back all changes in an area of 1o before June 11th, 2011
    /lb rollback player thad0ctor since 05:36:00 - roll back all changes of thad0ctor since 05:36 (server time)

    Download, Command, Configuration and Details:

    -> Full changelog
    • LogBlock v1.50 # 81 (Dez. 13, 2011)
      Works with CraftBukkit 1.0.1-R1
      • Feature: /lb me shows the total block count
      • Feature: Chest logging without spout
      • Feature: Enderdragon logging
      • Feature: Logging for tree and mushroom grow (thanks to MD5 for the api)
      • Fix: Area param works again with default radius
      • Fix: Rollbacks got slowed down a bit to avoid rare server crashes
      • Fix: If mysql username, password or database only consist of unquoted numbers, LB will read them now
      • Config: World configs changed totally, some names changed and all logging options are now in an own section
    • LogBlock v1.41 #63 (Nov. 15, 2011)
      Works with CraftBukkit recommended build #1337
      • Fix: Players with spawnTools permission are no longer allowed to spawn all tools.
      • Fix: Added a check to avoid "The permission xy is already defined!" errors
    • LogBlock v1.40 #60 (Nov. 09, 2011)
      Works with CraftBukkit recommended build #1337
      • Feature: Custom auto ClearLog
      • Feature: Reduced error spam. Instead of like 40 line of error code, there is now just a warning stating the MySQL con
      • Feature: The queue will now be dumped after 10 tries even when the MySQL server is connected
      • Feature: Custom material names, allows naming custom blocks
      • Feature: LogBlock will now respond to messages when started without MySQL connection
      • Fix: Log import runs now async
      • Fix: Log import errors won't crash the server
      • Fix: Console commands work again
      • Fix: You can now use upper case letter in tool names (I don't know why you even should, but ...)
      • Config: Added, clearlog.enableAutoClearlog in main config. Added materials.yml. Removed clearlog.keepLogDays
      • Permissions: Added 'logblock.spawnTools'
    • LogBlock v1.32 (Oct. 04, 2011)
      Works with CraftBukkit recommended build #1240
      • Feature: Player info logging: firstLogin, lastLogin, onlinetime, ip. No ingame lookup yet.
      • Feature: /lb queuesize to see the current queue size
      • Fix: Door logging logs now also fence gates
      • Fix: Bukkit api break in CB #1191
      • Fix: time restriction works now as intended. Thanks to xrobau
      • Fix: Players with insufficient permissions can't smuggle bedrock from one world to another
      • Config: Added logPlayerInfo
    • LogBlock v1.30 (Sep. 22, 2011)
      Works with CraftBukkit recommended build #1185
      • Feature: Chat lookup /lb chat player diddiz search +admin +sucks +dicks (more info)
      • Feature: Door logging
      • Feature: Dynamic tools, define your own tools
      • Feature: Use since and before to define a timespan
      • Feature: Enderman logging
      • Feature: cake logging (who ate it)
      • Config: Added logEndermen, logCakes and logDoors to world config and moved the tool section in main config.
      • Permissions: logblock.tool changed to and
        logblock.toolblock to
    Todo List:

    Permission Nodes:

    Plugins supporting Logblock:
    List (open)

    When you want to appear your plugin here, tell me about

    Support the developer (that's me :D):
    If you want to support me writing plugins or want to thank me for the plugin/support, you can: Suggest features I missed, report bugs (best with fix :D), donate via PayPal, flattr my plugins, gift me The Witcher 2 (thanks to newyoukdaily), 2x 1GB DDR1 modules (thanks to HonestFlames), or send me the inner life of a laptop or netbook with a broken display (need it to build a model aircraft, so there is no need for parts like display and keyboard).


    How to post error messages:

    I won't aswer questions to general MySQL setup/installation/what is MySQL (there are lots of good tutorials out there, use google)
    Please read the installation guide before asking a question about installation problems.
    Please read the FAQ before posting a error report. It may be solved there.
    In case of rollback or lookup problems: Type /lb savequeue and try again (when it's fixed then, it was a consumer problem, see FAQ)
    When you post error messages, it's important to paste the whole stack trace!

    Newyorkdailys Plugin Support Buisness (open)
    Still can't get LogBlock working, or any other plugin? Are you getting errors in your console and cant figure out why? Newyorkdaily offers Basic/Advanced Plugin support.
    • General/Advanced troubleshooting: FREE!
    • Plugin Installations: 1-2 Plugins - FREE!
    • 3 or More Plugins - $2
    Click on the link below to connect to him now!

    There is a LogBlock irc channel: #logblock at
    You can ask me on skype. My name is 'hawky.diddiz'.
  2. Offline


    Questioner does not work for me.
    CB #1060 logblock 1.26 #8 and spout 1.0.2 #123
  3. Offline


    Hey newb question,
    Do you HAVE to use a MySQL database to run Logblock ?
  4. Offline


    Hm, don't know about permissions bukkit, but i guess like every other plugin?
    No, worldedit has to queue the block changes, but that's rather inefficient for millions of blocks. There is atm no efficient way.
    Did you enable auto log clearance by setting keepLogDays?
    Hm, any errors?
  5. Offline


    still getting the chest log issue with spout 1.0.2, log block 1.26 and RB 1060, anyone can test the feature?

  6. Offline


    I've been using LogBlock for quite some time now (It's great!) but I came across a weird error today in looking up stats for the server.

    When I try to write out the block summary for players using writelogfile I get this...

    >lb writelogfile sum players world "world"
    21:18:13 [INFO] Creating Block changes in world summed up by players.log
    21:18:13 [INFO] Exception, check error log
    21:18:13 [SEVERE] [LogBlock WriteLogFile] SELECT playername, SUM(created) AS created, SUM(destroyed) AS destroyed FROM ((SELECT playerid, count(type) AS created, 0 AS destroyed FROM `lb-main` AND type > 0 GROUP BY playerid) UNION (SELECT playerid, 0 AS created, count(replaced) AS destroyed FROM `lb-main` AND replaced > 0 GROUP BY playerid)) AS t INNER JOIN `lb-players` USING (playerid) GROUP BY playerid ORDER BY SUM(created) + SUM(destroyed) DESC  (file was /[path to server snipped]/plugins/LogBlock/log/Block changes in world summed up by players.log):
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'AND type > 0 GROUP BY playerid) UNION (SELECT playerid, 0 AS created, count(repl' at line 1
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(
            at java.lang.reflect.Constructor.newInstance(
            at com.mysql.jdbc.Util.handleNewInstance(
            at com.mysql.jdbc.Util.getInstance(
            at com.mysql.jdbc.SQLError.createSQLException(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.sendCommand(
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
            at com.mysql.jdbc.ConnectionImpl.execSQL(
            at com.mysql.jdbc.ConnectionImpl.execSQL(
            at com.mysql.jdbc.StatementImpl.executeQuery(
            at de.diddiz.LogBlock.CommandsHandler$
    Not sure if its the fact that I'm not joking about how far back the data goes...

    03-20 22:13:54 croccydile opened chest at 156:61:219
  7. Offline

    Hanii Puppy

    SQL is a pain in the arse :\ Otherwise, this plugin looked like a good replacement for BigBrother - which I didn't have to set up a separate SQL server to use.
  8. Offline


    My exact thoughts.
    Is there any way of a future release where we don't have to set up Mysql ?
  9. Offline


    What does this mean?

    2011-08-18 01:13:32 [SEVERE] Error occurred while enabling LogBlock v1.26 (Is it up to date?): com/sk89q/worldedit/bukkit/selections/Selection
    java.lang.NoClassDefFoundError: com/sk89q/worldedit/bukkit/selections/Selection
        at de.diddiz.LogBlock.LogBlock.onEnable(
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(
        at net.minecraft.server.MinecraftServer.e(
        at net.minecraft.server.MinecraftServer.a(
        at net.minecraft.server.MinecraftServer.init(
    Caused by: java.lang.ClassNotFoundException: com.sk89q.worldedit.bukkit.selections.Selection
        at$ Source)
        at Method)
        at Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        at java.lang.ClassLoader.loadClass(Unknown Source)
        ... 11 more
  10. Offline


    no errors what so ever.
  11. Offline


    Have you tried setting it up? It might look a little scary if you're not used to dealing with stuff for server class machines, but if you just follow one of the MANY tutorials out there you'll have it installed in minutes. Literally. Minutes.
  12. Offline


    Hehe Don't worry I have setup a Mysql database and I am running logblock atm.
    I would just prefer an option not to :).
  13. Offline


    Hi Diddz i noticed that when water touches lava it created cobble, but it isnt logged correctly which leads to not rollbacking it correctly, it just sais "lavaflow created lava" Could you please change so that creating of cobble is logged to lava instead of waterflow? Because i dont want server lag because of enabled waterflow logging.
  14. Offline


    Thanks, that's a bug in my dynamic query builder

    Download WorldEdit.jar and place it in lib folder, it should have beed loaded automatically, but ...
    Postgres and H2 support is planned
    For me it works, can you describe how you can reproduce that?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: Jul 18, 2016
  15. Offline


    Thank you!
    I love this plugin my server would die without it!
    I hope you never lose intrest in keeping it updated.
    Nice work sir.
  16. Offline


    Love this it's smash's BigBrother by far I think!
  17. Offline


  18. Offline


    newb questions and yes i read up there on how to download it but still confused.
    so, when downloading to V1.26 LogBlock it requires CB #1060+Spout?
    or does V1.26 LogBlock works for CB #1000 without Spout?
  19. Offline


    when i try to do anything with chestaccess, it says Chest access found within 3 of you in worl:none while i was right in front of a very much used chest
  20. Offline


    No, spout is always optional.
    v1.26 for CB #1060 ans v1.25 for CB #1000

    What command did you use and what excactly was LBs reply?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
    Last edited by a moderator: Jul 18, 2016
  21. Offline


    since we updated from 1.23 to 1.26 the console keep spaming SQL errors from time to time.
    - We use : mysql Ver 14.14 Distrib 5.1.50, for pc-linux-gnu (x86_64) using readline 5.1
    - i made NO DB reset on Update - is that the problem?

    here the paste :
    2011-08-18 16:51:08 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb_bm_world` (date, playerid,
    replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1313679068), 34, 0, 345, 0, '-464', 72, '-364');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'type' at row 1
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(
            at com.mysql.jdbc.MysqlIO.sendCommand(
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(
            at com.mysql.jdbc.ConnectionImpl.execSQL(
            at com.mysql.jdbc.ConnectionImpl.execSQL(
            at com.mysql.jdbc.StatementImpl.execute(
            at com.mysql.jdbc.StatementImpl.execute(
    the plugin still work normal far as i know but has anyone an idea wath the problem is ?

    (yes the system time is okay)
  22. Offline


    logblock listen to the chat, wait till the both points are marked and wait for the //set command

    hm..the db must get 2 entries if anyone use a cuboid.. the coordinates, player, the changed block-id and so on from bottom left to top right.

    i think many servers has the problem from crazy friends.. I know many servers, where "other friends" destoyed the world -> No backup
  23. Offline


    Any ideas to fix the chestlog bug?

    using spout 1.0.2, logblock 1.26 and cb 1060 it fails, using lb1.25, spout 1.0.1 and cb 1000 works fine...
  24. Offline


    To simulate all worldedit commands is also the wrong way, as it's kind of extensive, inaccurate and won't work with worldedit updates.
    That's ok, idk where the item ids come from, but as that are odd items there is no loss.
    Besides that I have to get rid of spout, no. I use the same versions and it work.
  25. Offline


    Is is possible to use the same database to logblock 2 separate servers or would this cause problems?
  26. Offline


    It will work (and I used that for months :D)
    But make sure that you aren't using the same tables.
  27. Offline


    Cool thanks I figured I'd need to do separate tables.. I've decided I need to use logblock on my PVP Survival Server where I have only used it as anti grief on my creative server. I've decided the LB might be the perfect way to catch Xrayers by setting up honeypot chests deep underground - and logging chest access, as well as perhaps block destroy - those straight down pillars into peoples bases - an obvious sign of a cheat.. just worried about lag now, my PVP server has so much action.
  28. Offline


    Besides that I have to get rid of spout, no. I use the same versions and it work.

    mmm i doubt, all server admins i know have the same problem here, chestlog dont log well after last spout update, if there are data before update, u can look fine, but the new data dont log well..
  29. Offline

    What about that?
  30. Offline


    Just made our official switch from bigbrother to logblock. I truly couldn't be happier. All things i always longed to have in bigbrother such as proper sign/chest logging, ect, finally exists :) Very pleased with the work being done here! Would highly recommend this plugin to everyone!
    DiddiZ likes this.
  31. Offline


    same, clean installation, cb 1060+lb 1.26+spout (your link) same error

    ive tested it 1 hour, with clean installations, and ever the same error, other server admins have too.

    seems dont recognaise well the tooks, put ins and player inventory

Share This Page