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

    Speedyboy235

    Yea.... major problem all of a sudden. I have even reset the MySQL database, reset the world tables and log files, everything. I keep getting this error on startup, it literally never ends, and is all I see, it made my server.log file 2MB in less than 10 seconds...

    Code:
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 8, 0, 8, 3, '9883', 35, '99947');': Data truncation: Out of range value for column 'z' at row 1
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 8, 0, 8, 11, '9884', 35, '99947');': Data truncation: Out of range value for column 'z' at row 1
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 8, 0, 8, 2, '9884', 35, '99946');': Data truncation: Out of range value for column 'z' at row 1
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 8, 0, 8, 3, '9883', 35, '99946');': Data truncation: Out of range value for column 'z' at row 1
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 8, 0, 8, 2, '9882', 35, '99946');': Data truncation: Out of range value for column 'z' at row 1
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 8, 0, 8, 2, '9882', 36, '99946');': Data truncation: Out of range value for column 'z' at row 1
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 17, 0, 10, 1, '9879', 11, '99961');': Data truncation: Out of range value for column 'z' at row 1
    2012-05-16 20:26:18 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-SkyBlock` (date, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337192449), 17, 0, 10, 1, '9887', 18, '100029');': Data truncation: Out of range value for column 'z' at row 1
    PLEASE HELP!
    ANY HELP IS APPRECIATED!
    Thanks in advance.
     
  3. Offline

    number1_Master

    Just give your server awhile to import that to the database. I recommend not letting anyone on.
     
  4. Offline

    tincopper2

    It's not possible because you're full of shit. thank you.

    Thanks! I had the same problem and you actually helped me fix it! Congrats!

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

    efstajas

    Is there any way I can see the LogBlock actions or commands people used in a log or somewhere? People report that one admin is cheating by rollbacking diamonds over and over again and I would like to look into that.
     
  6. Offline

    Patolord

    Code:
    2012-05-17 17:49:35 [INFO] [PLAYER_COMMAND] SilentDoom: /spawn
    2012-05-17 17:49:40 [INFO] [PLAYER_COMMAND] jett99: /f leave
    2012-05-17 17:49:40 [INFO] hugh12345 [/50.132.4.106:45197] logged in with entity id 2493691 at ([world] 286.69151172401524, 63.0, 1448.3122051386645)
    2012-05-17 17:49:41 [INFO] [Heroes] Loaded hero: hugh12345 with EID: 2493691
    2012-05-17 17:49:41 [INFO] [PLAYER_COMMAND] pieguy324: /suicide
    2012-05-17 17:49:41 [WARNING] pieguy324 was denied access to command.
    2012-05-17 17:49:44 [INFO] Dark_lord87 [/76.193.168.86:51181] logged in with entity id 2497801 at ([world] 1199.5, 11.0, -1492.5)
    2012-05-17 17:49:45 [INFO] [Heroes] Loaded hero: Dark_lord87 with EID: 2497801
    2012-05-17 17:49:46 [INFO] Templar jek821: damb
    2012-05-17 17:49:46 [INFO] [Heroes] Saved hero: kent1226
    2012-05-17 17:49:46 [INFO] **Templar [Bowman]cypruskids: iron
    2012-05-17 17:49:49 [INFO] [Footman]Megacrafti21213: can i join a faction
    2012-05-17 17:49:53 [INFO] [PLAYER_COMMAND] SilentDoom: /f show pred
    2012-05-17 17:49:54 [INFO] mudkip552 [/68.146.75.159:60643] logged in with entity id 2508329 at ([world] 161.068388995188, 64.0, -776.96284665826)
    2012-05-17 17:49:55 [INFO] [Heroes] Loaded hero: mudkip552 with EID: 2508329
    2012-05-17 17:50:02 [INFO] [Heroes] Saved hero: jek821
    2012-05-17 17:50:03 [INFO] **Templar [Bowman]cypruskids: mine
    2012-05-17 17:50:03 [INFO] [PLAYER_COMMAND] mudkip552: /f show
    2012-05-17 17:50:10 [INFO] Connection reset
    2012-05-17 17:50:10 [INFO] mudkip552 lost connection: disconnect.quitting
    2012-05-17 17:50:10 [INFO] [Heroes] Saved hero: mudkip552
    2012-05-17 17:50:16 [INFO] [PLAYER_COMMAND] jett99: /f home
    2012-05-17 17:50:17 [INFO] [Footman]Megacrafti21213: how many people
    2012-05-17 17:50:22 [INFO] [PLAYER_COMMAND] jett99: /f home]
    2012-05-17 17:50:26 [INFO] **Templar [Bowman]cypruskids: 4or5
    2012-05-17 17:50:28 [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main-chest` (id, itemtype, itemamount, itemdata) values (LAST_INSERT_ID(), 364, -21, 0);:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '44593' for key 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    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:1039)
    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:292)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    at java.lang.Thread.run(Unknown Source)
    Can someone help on this ^ ?

    [SEVERE] [LogBlock Consumer] SQL exception on INSERT INTO `lb-main-chest` (id, itemtype, itemamount, itemdata) values (LAST_INSERT_ID(), 364, -21, 0);:
    com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '44593' for key 1

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

    Patolord

    nevermind its on the FAQ
     
  8. Offline

    Po1ntBlank

    Getting an error, didnt see it on the faq. Basically the server lost connection to the internet and bugged out. I tried stopping and restarting, but no dice. Any idea how to fix?

    Code:
    16:52:31 [WARNING] [LogBlock] Error while importing: 'INSERT INTO `lb-Arena` (da
    te, playerid, replaced, type, data, x, y, z) VALUES (FROM_UNIXTIME(1337469125),
    (SELECT playerid FROM `lb-players` WHERE playername = 'torirocks324213'), 79, 9,
    0, '278', 1, '382');': Column 'playerid' cannot be null
     
  9. Offline

    DxWeennaaaa

  10. Offline

    MarioG1

  11. Offline

    RiotShielder

  12. Offline

    MarioG1

  13. Offline

    RiotShielder

    Thanks, I thought that was an old build because it was in March
     
  14. Offline

    TurboCinque

    Hey guys im having trubble with LogBlock

    everytime i do /lb area 4 destroyed
    I get " Block destructions within 4 blocks of you in world : no results found"

    How can i fix this?
     
    Jok likes this.
  15. Offline

    owenftw

    I am using CoreProtect instead now.
    less buggy
     
  16. Offline

    micim987

    I think there a bug with chest logging
    Im not the admin of the server but i told one of the admins after I took a mine cart that someone filled the chest with random stuff and the plugin told them it was me who filled the chest up with stuff but i didn't carry that much stuff I was really close to getting a ban. Is this a bug? Has this ever happened to someone before?
     
  17. Offline

    Po1ntBlank

    When pasting the command into PHPMyAdmin I get this error

    #1044 - Access denied for user 'thedistr'@'localhost' to database '_minecraft'

    Any help?
     
  18. Offline

    Shreaders1

    Question - Why are members of my server able to use /lb toolblock or /lb tool or w/e where they can obtain the blaze rod / sponge (which are my tools that I have set?) I'm sure it has something to do with configuration ... but could someone tell me exactly how to prevent this?

    Thank you so much!
    Sorry for being so plugin illiterate!
    - Shreads
     
  19. Offline

    MarioG1

    You have to set permissionDefault: 'FALSE' in your config File.
     
  20. Offline

    tmanisawesome

    do u have to use mysql
     
  21. Offline

    Shreaders1

    Yes

    MarioG1 - Thank you for the help can't wait to try it out :)
     
  22. Offline

    IsaiahRobichaud

    The last thing on number
    The last thing on number 4 sure sounds interesting
    Rolling back chat?? How would that work LOL
     
    afistofirony likes this.
  23. Offline

    tmanisawesome

    my computer wont run a mysql server is there an alternateive
     
  24. Offline

    afistofirony

    Lmfao, I think he meant logging chat. But yeah, rolling it back would be fun. :3



    These things are already logged. Chests are logged, doors are logged, and so are buttons. Chat is not logged, but it's not difficult to go through chat logs in the console.
     
  25. Offline

    MarioG1

    No, I think there is no alternative.
     
  26. Offline

    Shreaders1

    Maybe look into this? http://www.freemysql.net/
    I know there is a video on youtube of someone setting up a LogBlock configuration using a site similar to this. I can't find the video at the moment, but I will keep an eye out for it and link you to it as soon as I can. It basically is like running your MySQL via a webhosting site - and it's free.

    I am unaware of how safe it is, however, because I have yet to use it myself. Instead I just allow the company hosting my server to provide me with a mysql database :) I also feel I should mention the person who created the video using the free mysql website had a TeamAVO Background.. or something similar to that. But according to the posts on the video, it seemed to be legit and a pretty simple alternative to managing your own MYSql.
     
  27. Offline

    Riolu

    PLEASE DO FLATFILE! I hate that damn MySQL and sure that would nice alternative for players that have no deal with MySQL.
     
  28. Offline

    olddutch7

    Hello,
    I have noticed that all players can use the bedrock cube to view edits within the map. I have been looking around and playing with the settings and I cannot figure out how to make it so only op's can have access to this feature. I was wondering if this was possible, and if so, how?
     
    Patolord likes this.
  29. Offline

    Sayshal

    Based on this, I don't think he's even updating this plugin anymore.
     
  30. Offline

    Eeppinen

    Hi! I just installed logblock and got mysql working, but i have one problem. When i right click ground with my /lb tool, it doesnt do anything! It should be logged world cos i checked that.
     
  31. Offline

    Patolord

    same
     

Share This Page