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

    Ajax_killer

    no i do not where do i get one? is it free?
     
  3. Offline

    [qwerty]

    Depends, you can pay someone to host it, or you can run one locally on your server. Ask your server host if you have PHPMyAdmin, that's a common program to administrate MySQL databases.
     
  4. Offline

    j4d3rz

    Hey. Gonna sound really bad. I have a server mc.mingul.co.uk:25583 and I'm admittldly not the best with plugins. I can do a few simple Drag 'n' Drop, with command plugins but not complicated ones. Since BB stopped, I'm left with Log or LogBlock. Obviously LogBlock allows rollback which is what I want. It's installed on my server but is red, meaning its not fully installed. Can anyone help at all, i need it ASAP!!
     
  5. Offline

    DiddiZ

    Adjust some sonsumer settings, increase timePerRun and forceToProcess.
    A MySQL server on localholst also would be much faster.

    You need a MySQL server and to put it's connection details into LB config.

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

    j4d3rz

    Could you help me with this?
     
  7. Offline

    DiddiZ

    Most MC hosters provide a database. If you got root access, or are running on localhost:
    http://www.mysql.com/downloads/
     
  8. Offline

    thetank332

    It works perfectly. BUT:
    I can't use /lb chestaccess
    wich is a bad thing :/
     
  9. Offline

    DiddiZ

    Enabled chest logging in world config and installed spout?
     
  10. Offline

    j4d3rz

    If I gave you acess would you be able to do it for me?
     
  11. Offline

    groveham

    I'm having trouble with log block. I am starting my own server and someone has recommended that I have this plugin.
    I have installed and configured it and added permissions do Admins, but every time I test it, it just places the bedrock block and I cant seem to figure out why. I have no errors in the console window, everything loads fine and I have set up my database etc.
    It may be just a simple configuration setting that I missed but I've been over it so many times.
    Can anyone help or does anyone know what I'm doing wrong?
     
  12. Offline

    paunk

    well, it didnt help, i deleted and when i do /reload, it auto regenerate and it hangs again.
     
  13. Offline

    jaboy

    i would like to use LB .... and have my log form bb but when i try to use the (downloaded) converter it dose not do anything

    Code:
    INSERT IGNORE INTO `lb-players` (playername) SELECT DISTINCT name FROM bbusers;
    INSERT IGNORE INTO `lb-players` (playername) VALUES ('Fire'), ('TNT'), ('Creeper');
    This works fine

    Code:
    INSERT INTO `lb-moria` (date, playerid, replaced, data, x, y, z)
    SELECT FROM_UNIXTIME(date) AS date, playerid, type, data, x, y, z
    FROM bbdata
    INNER JOIN bbusers ON bbdata.player = bbusers.id
    INNER JOIN `lb-players` ON bbusers.name = `lb-players`.playername
    WHERE action = 0 AND world = 0;
    After i use this (or any of the others) ... it just says "0 rows inserted."
    (the " tableName" is lb-moria and "moria" has world id 0)

    What have i done wrong !?

    oh and btw .... the convert file says i only have to do
    "INSERT IGNORE INTO `lb-players` (playername) SELECT DISTINCT name FROM bbusers;"
    but the website says that i also have to do
    INSERT IGNORE INTO `lb-players` (playername) VALUES ('Fire'), ('TNT'), ('Creeper');

    i guess to use the one form the website ?!
     
  14. Offline

    [qwerty]

    Does this look good, if the MySQL server is remote?
    Code:
    consumer:
        delayBetweenRuns: 6
        forceToProcessAtLeast: 30
        timePerRun: 250
        useBukkitScheduler: true
     
  15. Offline

    DiddiZ

    Use latest dev then. Fixed some import issues there.
    Yeah, the website is more up to date.

    I guess you also get no result from:
    SELECT * FROM bbdata WHERE action = 0 AND world = 0;

    So try:
    SELECT * FROM bbdata WHERE world = 0;
    No results mean world id is wrong.

    SELECT count(*), world FROM bbdata GROUP BY world;
    Gives you rows per world.

    SELECT * FROM bbdata WHERE action = 0;
    No results mean no logged block breks ...

    If it works, yes. Ultimate settings would be:
    Code:
        delayBetweenRuns: 6
        forceToProcessAtLeast: 1000
        timePerRun: 5000
    But use these as last resort :D

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

    groveham

    I'm having trouble with log block. I am starting my own server and someone has recommended that I have this plugin.I have installed and configured it and added permissions do Admins, but every time I test it, it just places the bedrock block and I cant seem to figure out why.
    I have no errors in the console window, everything loads fine and I have set up my database etc.
    It may be just a simple configuration setting that I missed but I've been over it so many times.
    Can anyone help or does anyone know what I'm doing wrong? I will paste my permission and config file below.

    Code:
    CONFIG FILE BELOW
    
    loggedWorlds:
    - world
    - world_nether
    mysql:
      port: 3306
      host: localhost
      password: abc123
      user: root
      database: minecraft
    logging:
      logCreeperExplosionsAsPlayerWhoTriggeredThese: false
      logKillsLevel: PLAYERS
      hiddenPlayers: []
      hiddenBlocks:
      - 0
      logPlayerInfo: true
    clearlog:
      dumpDeletedLog: false
      keepLogDays: -1
    questioner:
      askRedos: true
      askClearLogs: true
      askRollbacks: true
      askClearLogAfterRollback: true
      banPermission: mcbans.ban.local
      askRollbackAfterBan: false
    rollback:
      replaceAnyway:
      - 8
      - 9
      - 10
      - 11
      - 51
      dontRollback:
      - 10
      - 11
      - 46
      - 51
      maxTime: 2 days
      maxArea: 50
    consumer:
      delayBetweenRuns: 5
      forceToProcessAtLeast: 20
      timePerRun: 200
      useBukkitScheduler: true
    lookup:
      toolID: 270
      toolQuery: area 0 all sum none limit 15 desc silent
      toolblockID: 7
      toolBlockQuery: area 0 all sum none limit 15 desc silent
      defaultDist: 20
      defaultTime: 30 minutes
      linesPerPage: 15
      linesLimit: 1500
    tools:
      tool:
        item: 270
        leftClickBehavior: TOOL
        params: area 0 all sum none limit 15 desc silent
        rightClickBehavior: TOOL
        aliases:
        - t
        defaultEnabled: true
        mode: LOOKUP
        permissionDefault: OP
      toolblock:
        item: 7
        leftClickBehavior: TOOL
        params: area 0 all sum none limit 15 desc silent
        rightClickBehavior: TOOL
        aliases:
        - tb
        defaultEnabled: true
        mode: LOOKUP
        permissionDefault: OP
    updater:
      checkVersion: true
      installSpout: true
    version: '1.32'
    
    PERMISSIONS BELOW
    
    Admin:
        default: false
        permissions:
        - '*'
        - lockette.*
        - -essentials.backup
        - -essentials.essentials
        - -essentials.setspawn
        - -essentials.reloadall
        - -essentials.plugin
        - essentials.*
        - worldedit.*
        - worldguard.*
        - iConomy.*
        - ChestShop.*
        - Vanish.*
        inheritance:
        - moderator
        info:
          prefix: '&6[Admin]&9 '
          build: true
          suffix: ''
     
  17. Offline

    DiddiZ

    I don't see any LB permissions there.
    You need 'logblock.*', 'logblock.tools.tool' and 'logblock.tools.toolblock'
     
  18. Offline

    [qwerty]

    Do you know what this is, i'm getting lots of crazy errors...
    Code:
    g username "root".
    Last login: Sat Nov  5 19:07:35 2011 from d118-75-33-198.try.wideopenwest.com
    [root@dedi4 ~]# screen -r
    [screen is terminating]
    [root@dedi4 ~]# screen -r
    There is no screen to be resumed.
    [root@dedi4 ~]# screen -r
    20:17:08 [INFO] [LogBlock] Trying to import queue-1320549206739-0.sql ...
    20:18:03 [WARNING] [LogBlock] Failed to import queue-1320549206739-0.sql:
    java.sql.BatchUpdateException: You can't specify target table 'lb-players' for update in FROM clause
            at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065)
            at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:102)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:139)
            at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:112)
            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)
    20:18:03 [INFO] [LogBlock] Trying to import queue-1320549206739-5.sql ...
    20:18:22 [WARNING] [LogBlock] Failed to import queue-1320549206739-5.sql:
    java.sql.BatchUpdateException: You can't specify target table 'lb-players' for update in FROM clause
            at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065)
            at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:102)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:139)
            at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:112)
            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)
    20:18:22 [INFO] [LogBlock] Trying to import queue-1320549206739-1.sql ...
    20:19:17 [WARNING] [LogBlock] Failed to import queue-1320549206739-1.sql:
    java.sql.BatchUpdateException: You can't specify target table 'lb-players' for update in FROM clause
            at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065)
            at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:102)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:139)
            at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:112)
            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)
    20:19:17 [INFO] [LogBlock] Trying to import queue-1320549206739-4.sql ...
    20:20:24 [WARNING] [LogBlock] Failed to import queue-1320549206739-4.sql:
    java.sql.BatchUpdateException: You can't specify target table 'lb-players' for update in FROM clause
            at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1065)
            at de.diddiz.LogBlock.LogBlock.onLoad(LogBlock.java:102)
            at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:139)
            at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:112)
            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)
    20:20:24 [INFO] [LogBlock] Trying to import queue-1320549206739-3.sql ...
    
     
  19. Offline

    groveham

    Ahhh ok, i knew i would have missed something.
    I did that however, i type/lb toolblock, and i get my bedrock but when I left click nothing happens, and when I right click it places the bedrock like a normal block, is there something else I am missing?
     
  20. Offline

    DiddiZ

    Update to latest dev
    Added your world to loggedWorlds?
     
  21. Offline

    groveham

    Yes, See below,
    I have followed all the tutorials I can find and I still cant figure out why it doesnt work =/

    Code:
    loggedWorlds:
    - world
    - world_nether
    mysql:
      port: 3306
      host: localhost
      password: abc123
      user: root
      database: minecraft
    logging:
      logCreeperExplosionsAsPlayerWhoTriggeredThese: false
      logKillsLevel: PLAYERS
      hiddenPlayers: []
      hiddenBlocks:
      - 0
      logPlayerInfo: true
    clearlog:
      dumpDeletedLog: false
      keepLogDays: -1
    questioner:
      askRedos: true
      askClearLogs: true
      askRollbacks: true
      askClearLogAfterRollback: true
      banPermission: mcbans.ban.local
      askRollbackAfterBan: false
    rollback:
      replaceAnyway:
      - 8
      - 9
      - 10
      - 11
      - 51
      dontRollback:
      - 10
      - 11
      - 46
      - 51
      maxTime: 2 days
      maxArea: 50
    consumer:
      delayBetweenRuns: 5
      forceToProcessAtLeast: 20
      timePerRun: 200
      useBukkitScheduler: true
    lookup:
      toolID: 270
      toolQuery: area 0 all sum none limit 15 desc silent
      toolblockID: 7
      toolBlockQuery: area 0 all sum none limit 15 desc silent
      defaultDist: 20
      defaultTime: 30 minutes
      linesPerPage: 15
      linesLimit: 1500
    tools:
      tool:
        item: 270
        leftClickBehavior: TOOL
        params: area 0 all sum none limit 15 desc silent
        rightClickBehavior: TOOL
        aliases:
        - t
        defaultEnabled: true
        mode: LOOKUP
        permissionDefault: OP
      toolblock:
        item: 7
        leftClickBehavior: TOOL
        params: area 0 all sum none limit 15 desc silent
        rightClickBehavior: TOOL
        aliases:
        - tb
        defaultEnabled: true
        mode: LOOKUP
        permissionDefault: OP
    updater:
      checkVersion: true
      installSpout: true
    version: '1.32'
    
     
  22. Offline

    jaboy

    to the first one
    as you guessed .... notthing

    2,3 & 4 works / have many results .... but i dont know what to use em for ?!

    edit ...
    i said in my first post that non of the "converters" work.... LIES lol
    found out that
    "placed blocks" and "Chest Access" works

    edit2 ....
    did you update the website?!
    under import to "player"
    i cant find
    "INSERT IGNORE INTO `lb-players` (playername) VALUES ('Fire'), ('TNT'), ('Creeper');"
    ?!
     
  23. Offline

    groveham

    I found the problem, and wow I feel like such a douche..... the loggedworlds needs to be the exact spelling as in caps and everything, my world file has cap W at the beginning so 'World', I didnt realise it would cause it not to work.

    I would just like to thank your time, and a note to anyone that has the same problem as me, CAPS matter lol

    Code:
    loggedWorlds:
    - world
    - world_nether
    mysql:
      port: 3306
      host: localhost
    
    [/quote]
     
    DiddiZ likes this.
  24. Offline

    DiddiZ

    Yeah, I split that up and moved it to the burned blocks, tnt and creeper imports.

    SELECT * FROM bbdata WHERE world = 0;
    Selects all rows with world id = 0, to see if there are even rows.

    SELECT count(*), world FROM bbdata GROUP BY world;
    Shows rows per world id

    Now, this one may be the interesting:
    SELECT * FROM bbdata WHERE action = 0;
    Show whether ther are block changes with action type 0 (block break)

    As the BB wiki is kind of down, I can't check if the action changed meanwhile (but that's unlikely anyways)
     
  25. Offline

    jaboy

    yea i just had a look at it .... the action id for block break is 1 and not 0 .... when i used that .... it worked :D
     
  26. Offline

    DiddiZ

    1 was supposed to be place ...
    damnit :D
     
  27. Offline

    [qwerty]

    I did and im getting another error lol. The dev from nov 4 was red, so i got the one from oct.
    Code:
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548132), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548132), firstlogin), ip = '/72.145.3.73:60070' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320548144), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548226), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548226), firstlogin), ip = '/24.184.125.171:64562' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'TenchinMogutso');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548234), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548234), firstlogin), ip = '/72.145.3.73:60083' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548290), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548290), firstlogin), ip = '/81.149.107.159:51013' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'phillthefaffer');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320548299), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320546945), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320546945), firstlogin), ip = '/69.243.165.108:58559' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'jfingers');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320546956), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'jfingers');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547027), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547027), firstlogin), ip = '/69.243.165.108:58669' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'jfingers');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547125), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547125), firstlogin), ip = '/184.91.236.248:50844' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'radioactivequill');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547201), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547201), firstlogin), ip = '/67.169.15.26:59738' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'nickij25');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320547359), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'jfingers');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549131), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'radioactivequill');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320549137), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320549137), firstlogin), ip = '/68.113.46.133:55746' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'BiggerJohn');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549146), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'BiggerJohn');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549179), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'garfieldcfc');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320549182), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320549182), firstlogin), ip = '/75.190.182.92:1047' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'jreynolds511');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320549201), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320549201), firstlogin), ip = '/76.25.181.157:54978' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'garfieldcfc');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Heyo028');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'iLordGrand');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'kooli');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'phillthefaffer');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'a3419');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Some_Soggy_Tacos');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'jreynolds511');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549206), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'garfieldcfc');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547525), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547525), firstlogin), ip = '/86.9.137.113:57682' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Heyo028');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547597), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547597), firstlogin), ip = '/72.145.3.73:59741' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547604), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547604), firstlogin), ip = '/71.222.134.113:52620' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Some_Soggy_Tacos');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320547606), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547613), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547613), firstlogin), ip = '/76.25.181.157:50430' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'garfieldcfc');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320547637), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'garfieldcfc');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320547757), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'nickij25');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320547793), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Some_Soggy_Tacos');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547825), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547825), firstlogin), ip = '/76.25.181.157:50600' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'garfieldcfc');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547839), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547839), firstlogin), ip = '/71.222.134.113:52676' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Some_Soggy_Tacos');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320547912), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Some_Soggy_Tacos');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547917), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547917), firstlogin), ip = '/72.145.3.73:60043' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320547925), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547955), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547955), firstlogin), ip = '/68.40.208.219:53470' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'iLordGrand');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320547969), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320547969), firstlogin), ip = '/71.222.134.113:52726' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'Some_Soggy_Tacos');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548059), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548059), firstlogin), ip = '/72.145.3.73:60057' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320548065), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548070), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548070), firstlogin), ip = '/86.19.113.47:63656' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'a3419');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548811), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548811), firstlogin), ip = '/93.75.216.194:52494' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'ArianaLove');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548877), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548877), firstlogin), ip = '/72.145.3.73:60155' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320548885), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320549074), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'ArianaLove');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548583), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548583), firstlogin), ip = '/72.145.3.73:60119' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320548597), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'collinfuerst1');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548642), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548642), firstlogin), ip = '/75.190.182.92:55960' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'DrakeAlexander');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320548683), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'TenchinMogutso');
    UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320548702), lastlogin)) WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'DrakeAlexander');
    UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320548725), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320548725), firstlogin), ip = '/70.20.61.24:51021' WHERE playerid = (SELECT playerid FROM `lb-players` WHERE playername = 'kooli');
     
  28. Offline

    DiddiZ

    These errors are ok, just online time.
     
  29. Offline

    jaboy

    i just had a look at it .... all the actions id for your converts is a number "too low" (it needs to be plussed (+) whit 1 :p

    a list of the actions ids (just so you can see what im taking about)
    Code:
    1     BrokenBlock     A block destroyed by a player.
    2     PlacedBlock     A block placed by a player
    3     DestroySignText     A sign destroyed, including text.
    4     Teleport     A player teleporting
    5     DeltaChest     A change applied to a chest.
    6     Command     A player using a command.
    7     Chat     A player chatting.
    8     Disconnect     A disconnected player.
    9     Login     A player logging in
    10     DoorOpen     An opened door.
    11     ButtonPress     A button pressed by a player.
    12     LeverSwitch     Lever toggled
    13     CreateSignText     A sign created with text.
    14     LeafDecay     Decaying leaves
    15     FlintAndSteel     A player igniting something with flint and steel.
    16     TNTExplosion     A box of TNT exploding.
    17     CreeperExplosion     A creeper exploding.
    18     MiscExplosion     An explosion with an unknown cause.
    19     ChestOpen     A chest opened by a player.
    20     BlockBurn     A block destroyed by fire.
    21     Flow     Fluid movement
    22     DropItem     A dropped item
    23     PickupItem     A picked-up item
    24     SignDestroyed     A sign being destroyed
    25     Heartbeat     Keeps the connection to the database alive, also p...
    26     BlockPistoned     A block moved by a piston
     
  30. Offline

    [qwerty]

    Ok, I just was not sure; but the errors were from some import I think.
    Thanks for the help man :)
     
    DiddiZ likes this.
  31. Offline

    Ajax_killer

    im gonna run the server on my computer where do i get this plugin/msql stuff?
     

Share This Page