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


    I don't know you you actually mean here.

    I updated using your query without splitting and its worked and all ID's are in.

    But the data is still create/delete etc for actions for the first set to that number 1576062 is that a problem?

    I created a backup before starting of the database to sql.
  3. Offline


    Um, most likely you now have many playerid as playernames in lb-players table ...
  4. Offline


    Unfortantly I do and none of the previous initial logs are working either :(

    But Hey I have the second section of logs back again :/

    So what happens here?

    Trying to import the backup on my local mysql but its 625mb.
  5. Offline


    That works only for the log with player names still in there. New newer log alredy has a playerid stead of the name, so it added the id as name. You better delete these names :D
  6. Offline


    Don't get you again what im going is install the backup on my local system (which is going now) its too big to reupload then I Ill cross referance as what I feel is all names are deleted from the newer ones now :/

    Or just output data from tables and reupload the new data to get the server going again and then work on the older data making it compatible.

    Ill use your query to output split the data up on my test system.

    "CREATE TABLE `temp` like `lb-main` SELECT * FROM `lb-main` WHERE id < 1576063;"

    Is that all I need and change the < to > ?

    Then do it multiples to split the data up.

    You told me how to do the middle data what about the initial first data with the create/destroy in actions how do i bring that up to date also?

    Also is there a way to renumber cross referencing names as Ill have 3 sets of name id's which is not cool.

    I'm kinda basic at doing sql etc but know a very small amount and cleaning up some mess we had from someone else here :/

    Update: unfortunately my backup wasn't full I guess were screwed with the latest data since going to bukkit.
  7. Offline


    You've to use the same lb-player table all the time, ot it will end up giving one player different ids.
    I'm sorry when my query messed up your data, I couldn't know that all your log was in a single table :'(

    When you still need my help, add me on skype (hawky.diddiz) or give me acces to the db, think I'd be faster than expaining it all to you.
  8. Offline


    Ill add you now to skype

    Big thanks to DiddiZ who fixed our database bringing the non updated tables up to date and sorting out a royal mess with player names and ID's that weren't updated previously by others.

    With 8 months of data now restored we really appreciate it and as you know you have a little something in your paypal as a thank you for helping :D

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


    how to select whole world? e.g. for fire ...
  10. Offline


    The whole world is selected by default, when you don't use area or selection.
    eg: "/lb player fire" returns all changes in world from player fire (same for "/lb block fire")
  11. Offline


    K, thank you...
    any chance to get who created the fire?

  12. Offline


    The purpose, that originally made me writing the new commands system :D
    Don't know whether you figured out, but the "created" parameter helps a lot :D
  13. Offline


    Got it, thank you.

    Nice new flexible command system, if you are familiar with it :)
    DiddiZ likes this.
  14. Offline


    Yes, the only thing that I am getting that is not normal is the error. The error started recently. Nothing was changed. Not the password, nothing changed.
  15. Offline


    That's odd ...
    Did you tried reinstalling LB from the scratch?
  16. Offline


    Dmnd, the plugin doesnt make table's for me , can anyone explain me how to add the tables manually? Like a SQL query .( I dont know what it is exactly )
  17. Offline


  18. Offline


  19. Offline


    Any chance of having per world settings for logging settings? My server is just too big to log everything on everyworld, and some worlds I need full logging, other worlds I only need a minor amount of logging.
  20. Offline


    There is a certain chance :D
    But not so soon.
  21. Offline


    Also I am really curious about how your threading works, cause with using bukkit scheduling the bukkit thread runs super hard but less noticable lag, when its set to false the bukkit thread doesn't work as hard but wierd lags occur.

    I have a 24 core server so if there is a way to get it to multithread better that would be awesome ;).
  22. Offline


    Basically in both cases the consumer should run in an own thread. Idk why there are so huge differences, I might have to do some profiling :D
  23. Offline



    Thanks alot for this great plugin! :)

    But I have an issue with Bukkitcontrib ...
    When I have that installed WorldEdit dosent work properly :/

    Do you have any idea what this is?

  24. Offline


    There was a problem with BukkitContrib, that got fixed in v0.3.
    The version included in LB v1.00 and v1.01 was vo.2 with that bug.
  25. Offline


    Ok, thanks alot for fast response :D
  26. Offline


    148 recipes
    16 achievements
    11:14:35 [INFO] Starting minecraft server version Beta 1.6.6
    11:14:35 [INFO] Loading properties
    11:14:35 [INFO] Starting Minecraft server on *:25565
    11:14:35 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-823-
    gb9d0b04-b860jnks (MC: 1.6.6)
    11:14:36 [INFO] Preparing level "world"
    11:14:36 [INFO] Preparing start region for level 0
    11:14:37 [INFO] Preparing spawn area: 65%
    11:14:37 [INFO] Preparing start region for level 1
    11:14:38 [INFO] Preparing spawn area: 57%
    11:14:39 [INFO] [LogBlock] Version check: Your version is up to date
    11:14:39 [INFO] Downloading mysql-connector-java-bin.jar (767kb) ...
    11:14:40 [INFO] 2%
    11:14:41 [INFO] 7%
    11:14:41 [INFO] 11%
    11:14:42 [INFO] 24%
    11:14:42 [INFO] 40%
    11:14:43 [INFO] 75%
    11:14:43 [INFO] Download finished
    11:14:43 [INFO] [LogBlock] Connecting to username@jdbc:mysql://localhost:3306/mi
    11:14:45 [SEVERE] [LogBlock] Error while fetching connection
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link fai
    The last packet sent successfully to the server was 0 milliseconds ago. The driv
    er has not received any packets from the server.
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            at com.mysql.jdbc.Util.handleNewInstance(
            at com.mysql.jdbc.SQLError.createCommunicationsException(
            at com.mysql.jdbc.MysqlIO.<init>(
            at com.mysql.jdbc.ConnectionImpl.coreConnect(
            at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(
            at com.mysql.jdbc.ConnectionImpl.createNewIO(
            at com.mysql.jdbc.ConnectionImpl.<init>(
            at com.mysql.jdbc.JDBC4Connection.<init>(
            at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
            at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
            at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
            at java.lang.reflect.Constructor.newInstance(Unknown Source)
            at com.mysql.jdbc.Util.handleNewInstance(
            at com.mysql.jdbc.ConnectionImpl.getInstance(
            at com.mysql.jdbc.NonRegisteringDriver.connect(
            at java.sql.DriverManager.getConnection(Unknown Source)
            at java.sql.DriverManager.getConnection(Unknown Source)
            at de.diddiz.util.MySQLConnectionPool.getConnection(MySQLConnectionPool.
            at de.diddiz.LogBlock.LogBlock.getConnection(
            at de.diddiz.LogBlock.LogBlock.onLoad(
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(
            at net.minecraft.server.MinecraftServer.e(
            at net.minecraft.server.MinecraftServer.a(
            at net.minecraft.server.MinecraftServer.init(
    Caused by: Connection refused: connect
            at Method)
            at Source)
            at Source)
            at Source)
            at Source)
            at Source)
            at Source)
            at<init>(Unknown Source)
            at<init>(Unknown Source)
            at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
            at com.mysql.jdbc.MysqlIO.<init>(
            ... 23 more
    11:14:45 [SEVERE] [LogBlock] Error while loading:
            at de.diddiz.LogBlock.LogBlock.onLoad(
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(
            at net.minecraft.server.MinecraftServer.e(
            at net.minecraft.server.MinecraftServer.a(
            at net.minecraft.server.MinecraftServer.init(
    11:14:46 [INFO] LogBlockQuestioner v0.02 enabled
    11:14:46 [INFO] LogBlock disabled.
    11:14:46 [INFO] Done (1.021s)! For help, type "help" or "?"
    I have no idea what the problem is, help anyone?
  27. Offline


    You forgot to set the mysql config
  28. Offline


    Do I have to have a MySQL? :/
  29. Offline


  30. Offline


    18:51:54 [SEVERE] Exception in thread "Thread-3785"
    18:51:54 [SEVERE] java.lang.NoSuchMethodError: de.diddiz.LogBlockQuestioner.LogBlockQuestioner.ask(Lorg/bukkit/entity/Player;Ljava/lang/String;[Ljava/lang/String;)Ljava/lang/String;
    18:51:54 [SEVERE]       at de.diddiz.LogBlock.CommandsHandler$
    18:51:54 [SEVERE]       at
    18:51:54 [SEVERE]       at
    When I try to roll back. It'll tell me how many blocks were found, but it won't give me the /yes, /no confirm.
  31. Offline


    Update the Questioner with the version in LB v1.10, it got updated.

Share This Page