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

    DiddiZ

    Version: 1.50​
    [​IMG]
    [​IMG]
    Find and Backroll those Damn Griefers
    LogBlock release are on DevBukkit:
    http://dev.bukkit.org/server-mods/logblock/

    LogBlock dev builds:
    http://ci.kitteh.org/job/LogBlock/

    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
    Description:

    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).

    Features:
    • 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:
    [​IMG]http://diddiz.insane-architects.net/logblock.php

    Changelog:
    -> 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.auto, 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 logblock.tools.tool and
        logblock.toolblock to logblock.tools.toolblock.
    Todo List:

    https://github.com/LogBlock/LogBlock/issues

    Permission Nodes:
    https://github.com/LogBlock/LogBlock/wiki/Permissions

    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).

    [​IMG]


    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!

    Advertizing:
    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!
    http://wbe001.mibbit.com/?settings=7cb4fd3cdd72754df475fb92a0b65f6c&server=irc.Mibbit.Net&channel=#CBPluginSupport


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

    DiddiZ

    The message was there for about three weeks :D
     
  3. Offline

    Subcode

    ok, im getting this weird error.
    logblock is telling me that someone edited a sign and some blocks.
    when i do /lb rollback username area 15 it tells me 0 blocks found.
    however i'm standing right next to it.
     
  4. Offline

    DiddiZ

    Try with time spec:
    /lb rb player name area 15 since 1d
     
  5. Offline

    StopSpazzing

    CB #1240
    LB 1.32

    When I check a block it says someone has edited the block but when trying to roll someone back with the command /lb rollback player <playername> since 1d (they edited the block within 1 day), after /yes it says deleting logs and clears the person from the logs and doesn't roll anyone back. =/

    P.S. Still says under changelog:
    Code:
    LogBlock v1.33 (Oct. 04, 2011)
    
     
  6. Offline

    DiddiZ

    Ty, forgot to change it in the op.
    I guess you did multiple rollbacks? There are two questions for each rollback: 1. Are you sure and 2. Do you want to clear the log. When you confirm a second rollback and didn't answer to the previous clearlog question, the answer is used for first question.
     
  7. Offline

    mbaxter ʇıʞʞnq ɐ sɐɥ ı

    What should I query for if I'm searching the DB for what edits by a player were rolled back? For instance, a player has 90000 edits and I want to find the 20 that were rolled back. In BB it's just SELECT * FROM bbdata WHERE `player`=(idhere) and rbacked=1; but I can't figure out what I'm looking for with the LB database.
     
  8. Offline

    Sidnoea

    I don't know if this is a bug or not, but the /lookup command does not return button presses, only the tool does. CB #1240, LB 1.32.
     
  9. Offline

    MartN

    im again :D
    i see many errors like this in the console:
    Code:
    02:21:32 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-world` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1318030566), 175, 0, 50, 2, '152', 53, '-135');:
    java.sql.SQLException: Table './tc_server/lb@002dworld' is marked as crashed and last (automatic?) repair failed
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
            at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
            at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
            at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
            at de.diddiz.LogBlock.Consumer.run(Consumer.java:278)
            at java.util.TimerThread.mainLoop(Unknown Source)
            at java.util.TimerThread.run(Unknown Source)
    
     
  10. Offline

    DiddiZ

    That's not possible as there is no rollbacked column
    Also when using area?
    Looks like you table table is crached

    MySQL command to repair:
    REPAIR TABLE `lb-world`;
     
  11. Offline

    mbaxter ʇıʞʞnq ɐ sɐɥ ı

    @DiddiZ Then how do I look up what blocks were rolled back? :)
     
  12. Offline

    MartN

    thank you for the grat support on the last day, the table was only complete crashed and has only a size of ~ 45MB.
    the backup have a size of ~400 mb.

    I will let you send a donation if https is working again on my computer.
     
    DiddiZ likes this.
  13. Offline

    DiddiZ

    There is no real way.

    Hm, workaround: if you log chat: "/lb chat player name search rollback" or "search rb". Then you'll know the paras and can try to redo these ... doesn't work for area
     
  14. Offline

    Malix

    Okay, LogBlock just decided to do nothing after I updated to 1.32.

    I can't get toolblock to work, at all. I've tried with the config's defaults and with block 17 (log :)
    I have said /lb toolblock on and /lb tool on, and off, and still nothing.

    my permissions from PermissionsBukkit:
    Code:
                logblock.*: true
                logblock.tool: true
                logblock.toolblock: true
                logblock.tools.tool: true
    
    also I am OP on the server.

    when I say /lb toolblock, I get greeted with "You aren't allowed to do this."

    What I am doing wrong? This worked just fine prior updating to 1.32

    /lb area -lookups work just fine, just the tool and toolblock don't.

    Edit: Also, no console errors or anything.

    Edit2: Further testing got me this when I say /lb tool
    Code:
    13:18:07 [WARNING] [LogBlock] NPE in commandshandler:
    java.lang.NullPointerException
            at de.diddiz.LogBlock.CommandsHandler.onCommand(CommandsHandler.java:151)
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:358)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:757)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:722)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:715)
            at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92)
            at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:500)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    
     
  15. Offline

    DiddiZ

    You need :
    Code:
                logblock.*: true
                logblock.tools.tool: true
                logblock.tools.toolblock: true
    Can't add the tool permissions to loblock.* due to a bikkit issue with dynamic permissions.

    The npe looks strange, maybe it's also fixed with tool block permission.
     
  16. Offline

    KoLLIaPuK

    Hello. On how much your plugin loads the server? OS - Debian.
    Also. Plugin connected to mysql.
    i7-920, 12gb
     
  17. Offline

    darkhelmet

    I'm having similar sql errors because some auto-update didn't work. However the sql file on the site is outdated and I've grabbed several field changes from the code on github but there's more missing. Can you update the sql source?
     
  18. Offline

    Sidnoea

    Area doesn't return buttons either. Also, I found a new, more concerning bug... Lately, I've been logging onto the server and being unable to do any queries. LB still responds to things like /lb commands and /lb params, but if I try to do a lookup or use the tool, it doesn't respond. At all. I think I found the problem today. I had the same issue, and I looked at the console, and there was this strange entry:
    Code:
    2011-10-08 08:37:07 [INFO] Attempted to place a tile entity (net.minecraft.server.TileEntityFurnace@1877f770) at 11,64,10 (AIR) where there was no entity tile!
    2011-10-08 08:38:27 [INFO] Attempted to place a tile entity (net.minecraft.server.TileEntityFurnace@3ce5b5c8) at 11,64,10 (AIR) where there was no entity tile!
    I tried resetting the server, and LB gave me this:
    Code:
    2011-10-08 08:57:27 [INFO] [LogBlock] Waiting for consumer ...
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 9
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 8
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 7
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 6
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 5
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 4
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 3
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 2
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 1
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining queue size: 3283
    2011-10-08 08:57:27 [INFO] [LogBlock] Remaining tries: 0
    2011-10-08 08:57:27 [INFO] Unable to save queue to database. Trying to write to a local file.
    The server got stuck there, and I had to force stop it. When I tried to start it back up, I got this:
    Code:
    2011-10-08 08:57:55 [INFO] [LogBlock] Updating tables to 1.27 ...
    2011-10-08 08:57:56 [SEVERE] [LogBlock Updater] Error:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate key name 'message'
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
        at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
        at de.diddiz.LogBlock.Updater.update(Updater.java:95)
        at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:79)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:142)
        at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:104)
        at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:52)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:136)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    2011-10-08 08:57:59 [INFO] [LogBlock] Found 6imports.
    2011-10-08 08:57:59 [INFO] [LogBlock] Trying to import queue-1318082247499-0.sql ...
    The server would always get stuck there, and would refuse to keep going without LogBlock. I had to delete the queues in order for the server to start back up. I went to that furnace tile entity block that was mentioned, and it was an empty air block floating over the ocean. I'm not sure what's going on, but I have a feeling that the two are related.
     
  19. Offline

    tootybob

    There is a LogBlock irc channel: #logblock at irc.esper.net.
    You can ask me on skype. My name is 'hawky.diddiz'.[/quote]
    @DiddiZ I have installed logblock over and over, it doesn't work. My console says 2011-10-08 10:18:57 [INFO] [LogBlock] Version check: Your version is up to date2011-10-08 10:18:57 [INFO] [LogBlock] Connecting to username@jdbc:mysql://localhost:3306/minecraft...
    2011-10-08 10:18:59 [SEVERE] [LogBlock] Error while fetching connection
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure...It is probably a problem with MySQL?
     
  20. Offline

    DiddiZ

    Oh, sure, updating now.
    But you can set version in config to 1.30 and restart to have the tables autoupdated.
    That means MySQL connection lost.
    That explains why normal commands worked, but no lookup.

    Your second error is new to me, but could be related to Spout.

    And to your third error: set version in config to 1.30.
    Yeah, you didn't set the MySQL conection data in config.
     
  21. Offline

    domingo15

    Diddiz am having this error on my server.log don't know the cause, could you help me out.

    I get multiples of this error...
     
  22. Offline

    DiddiZ

    Set version in config to 1.30 and restart.
     
  23. Offline

    Sidnoea

    I don't use Spout, if that helps.
     
  24. Offline

    palz2015

    LAWGBLAWK IS GAAAAY
    It just says:
    Usage:
    /lb help
    ...

    EVEN WHEN I TYPE /LB HELP!
     
  25. Offline

    DiddiZ

    kk, then it's from bukkit. May be caused by world corruption or plugin malfunction, idk.

    Calm down and check for the error log :D
     
  26. Offline

    charmonkey

    I install the plugin and it says the plugin is outdated?
     
  27. Offline

    DiddiZ

    exact error log pls

    did you set MySQL connection data in config?
     
  28. Offline

    charmonkey

    Well when I type /plugins Logblock is red, so that means its outdated? Its it updated for 1.8.1??
     
  29. Offline

    DiddiZ

    Red means disabled for some reason, no MySQL connection in this case. Get you a MySQL server and add the connection data to the LB config.
     
  30. Offline

    Kane

    @DiddiZ
    Couple questions never used anything advanced till today when it came to large areas with logblock haha..

    1) I did /lb sel and woot worked well besides PAGES ewww haha. I use spout with like a infinite log pretty much I was wondering if I can get rid of having to do page by page. Heck I don't even know how to go next page even haha.

    2) Is there a way to exclude a players name when I do /lb sel so I don't have to see my name on my land for example?

    3) Is there a way when I do /lb sel it gives me the Latest date not the oldest :)


    Thanks so much hows guardian going btw? I been spying on you a bit on github ;)
     
  31. Offline

    DiddiZ

    1. Set lookup.linesPerPage to a different value, browse with /lb page <number>, /lb + /lb -
    2. Sure, /lb sel player !diddiz
    3. /lb sel asc, if you find more than 1500 rows it will unfortunately cut off the newest. Either use a smaler selection then, or set lookup.maxPages to a higher value (returned rows = linesPerPage * maxPages)
    Guardian grows slow atm oliverw92 is kind of busy now
     

Share This Page