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


  3. Ah. Thanks :)
  4. Hey, when i try to rollback, it says:
    You arent allowed to to this!
    and i have op and permissions* (pex)
  5. Offline


    @DiddiZ was /lb reload ever added? I'm to lazy to reboot and want to load a new world to log :p
  6. Offline


    How would I import logs that I deleted on accident but were put into the dump?
  7. Offline


    /lb area 3 chestaccess won't work for me, says there's no results found when I'm right next to the chest.
  8. Offline


    Not yet. I once made the bad decision to cache config values in some class files (it's faster, but ...), so I first have to review lots of code to remove that ...
    Move them to import folder
    Make sure chest access logging is enabled in world config
  9. Offline


    Moved them into import folder, nothing happened at all.
  10. Offline


    NP. Like once a every few month thing haha :) Small reboot does not kill.
  11. Offline


    I did, this is my config file:

    For chest access do my users require Spout? Or only the server requires it?

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


    ummm so one quick question is it normal for my server to restart when ever i type a LB command?
  13. Offline


    My bad, you need to change the extension from .csv fo .sql.
    Looks like your config wasn't auto updated once. The logging config got moved from config.yml to worldname.yml
    Only server
    No, not at all :D
    What command? Any error log in server.log?
  14. Offline


    I got this error, Last night, I have no idea what happened, and it wasn't doing this before, it just did today. Idk how to fix it.

    Bukkit Version - 1545
    LogBlock - 1.42

    Please help, Thanks!

    2011-12-10 09:15:08 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-main` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1323496135), (SELECT playerid FROM `lb-players` WHERE playername = 'pielovez'), 1, 0, 0, '481', 49, '878');': Column 'playerid' cannot be null
  15. Offline


    The server auto-downloads spout and when I try entering the server, I get stuck on Downloading terrain

    I'm using Bukkit #1566 1.0.0 on my server.


    I fixed it by dowloading the DEV version of Spout.
  16. Offline


    Well it imported the chat logs but blocks it puts in failed.txt
  17. Offline


    Looks like the player pielovez wasn't listen in players table, which is strage as he should be added then ...
    Any other errors, like failed to add player errors?
    Please provide :D
  18. Offline


    Its a 2 GB txt file ALL of my data.

    Here is a few of the millions of lines

    8702594,"2011-12-09 16:49:19",2498,3,0,0,-567,61,427
    8702593,"2011-12-09 16:49:19",17,18,0,8,1096,64,-679
    8702592,"2011-12-09 16:49:18",2498,3,0,0,-568,61,427
    8702591,"2011-12-09 16:49:17",2498,3,0,0,-570,61,427
    8702590,"2011-12-09 16:49:17",17,18,0,8,1099,67,-683
    8702589,"2011-12-09 16:49:16",17,18,0,8,1070,66,-673
    8702588,"2011-12-09 16:49:16",17,18,0,8,1098,66,-686
    8702587,"2011-12-09 16:49:16",3696,17,0,0,-49,69,-69
    8702586,"2011-12-09 16:49:14",2498,1,0,0,-571,60,427
    8702585,"2011-12-09 16:49:13",2231,0,50,5,-28,68,-126
    8702584,"2011-12-09 16:49:13",2498,3,0,0,-569,61,427
    8702583,"2011-12-09 16:49:13",2498,3,0,0,-571,61,427
    8702582,"2011-12-09 16:49:11",505,0,85,0,967,66,-112
    8702581,"2011-12-09 16:49:11",2498,1,0,0,-572,60,427
    8702580,"2011-12-09 16:49:11",3696,17,0,0,-49,66,-69
    8702579,"2011-12-09 16:49:10",2231,0,50,5,-28,68,-125
    8702578,"2011-12-09 16:49:10",2231,0,50,5,-29,68,-125
    8702577,"2011-12-09 16:49:10",505,0,85,0,967,66,-110
    8702576,"2011-12-09 16:49:10",17,18,0,8,1089,67,-683
    8702575,"2011-12-09 16:49:09",2098,54,54,0,-9,65,-65
    8702574,"2011-12-09 16:49:09",2231,0,50,5,-28,68,-124
    8702573,"2011-12-09 16:49:09",2231,0,50,5,-29,68,-124
    8702572,"2011-12-09 16:49:05",17,18,0,8,1092,66,-682
    8702571,"2011-12-09 16:49:03",2098,54,54,0,-10,65,-65
    8702570,"2011-12-09 16:49:03",2231,0,50,5,-28,68,-123

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


    Ty, my bad again. The dumps aren't stored as self containing sql file.
    You need to use the import functions from phpMyAdmin or MySQL Workbench.
  20. Offline


    Im sorry ive never done this before, may I ask how I would do it with MySQL workbench?
  21. Offline


    It should be: Server Administration -> Import -> Select file
  22. Offline


    yeah, like 1000 More names, but it seems that its working now, I just put my server on whitelist for 1 hr, and I guess what happened was that the server crashed, and the files didnt save properly, so for the next hour, I let it run so that LogBlock can import saved files.
  23. Offline


    when i type /plugins all plugin is green but logblock is red.....
    Please help me ! :(

    Attached Files:

    • min.png
      File size:
      747.8 KB
  24. Offline


    Did you set MySQL in config?
  25. Offline


    oh.. how?

    how...... im not good at it :p

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

    Emiya Shirou

    Which version Can I install for Craftbukkit 1.0.0 Developers Build and where do I find it?
  27. Offline


    CB 1560
    LB 1.42

    trying to run 'lb lookup player world world' and it always errors.

    been trying " and ' and ` , and { and ( to surround world, nothing seems work.

    anyone know how to do a lookup oin the console?
  28. Offline


    I have a player who can spam connect/disconnect and it crashes logblock.

    I asked the NoCheat author if there could be a way to disable this type of things, and he said...

    Are there any solutions?
  29. Offline


    00:05:17 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-chat` (date, playerid, message) VALUES (FROM_UNIXTIME(1323666155), 18, '/01:46 [SEVERE] 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 \'s Place! Nice!\', \'\', \'Monday, 12 December 2011 00:01:21\')\' at line 1');:
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'message' 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(
    at de.diddiz.LogBlock.CommandsHandler$
    at de.diddiz.LogBlock.CommandsHandler$AbstractCommand.<init>(
    at de.diddiz.LogBlock.CommandsHandler$CommandSaveQueue.<init>(
    at de.diddiz.LogBlock.CommandsHandler$
  30. Offline


    /lb player diddiz world "world"
    If it still doesn't work, update LB
    1.41 works, link to jenkins is in the op
    Interesting, in my tests a onlinetime > 838 hours didn't cause errors ...
    Temporarily workaround would be disabling onlinetime logging (config.yml logging.playerInfo) or resetting the onlinetime for that player ("UPDATE `lb-players` SET onlinetime = "00:00:00" WHERE playerid = 1585;)

    But anyways, that's a mysql error and usually completely unrelated to mc server errors.
    Where do the time stamps come from?
    Workaround could de changing the lenght from message column from 255 to 1024.
    You need to install MySQL, run the configuration wizard (you can leave everything default, but remember the pw you typed in a root pw)
    Then, start the MySQL console, log in and:
    CREATE DATABASE minecraft;
    GRANT ALL ON minecraft.* TO 'minecraft'@'localhost' IDENTIFIED BY 'another pw';
    Now you enter in LB config:
    user: minecraft;
    password: 'another pw'
    And you are done :D
  31. Offline



Share This Page