Inactive [SEC] BigBrother 1.11.0 - Catch griffers red-handed [1060]

Discussion in 'Inactive/Unsupported Plugins' started by N3X15, Apr 13, 2011.

Thread Status:
Not open for further replies.
  1. Offline

    N3X15

    [​IMG]
    Important Crap

    I'm done, but BB isn't.
    I've got 10 developers on the contributors' list who supposedly want to help, but I haven't heard a word from them since the day I added them. BigBrother's so full of bugs now that I don't know where to start, and I simply don't have the time or patience to work on it anymore. If you want something that works, pick up LogBlock. I'm fucking done. I updated it to "run" on 1060, but that's as far as I'm taking this. If you still want to help, email me at [email protected] and give me a rundown of your experience in coding plugins so I know you'll do something.​
    UPDATE: 3 developers have been added to the repo, but I'm waiting for them to get familiarized and start committing before I declare this crisis over. I appreciate the support and help that has been thrown this way. If you'd still like to help, but don't know how to code, there are many other ways to contribute. See the Contributors section for more info.​


    Version: 1.11.0
    Original Author: tkelly910

    Contributors
    • Development Team
      • N3X15
      • Mafio
      • FalconGaming
    • Quality Assurance (QA) Team (Testing, ONLY ON LATEST RB*!)
      • N3X15
      • Mineral
      • All of the poor bastards on the 7chan.org minecraft server + other dev servers
      • *NOTE: Unless EvilSeph or other bukkit devs indicate an RB is imminent, e.g. within the next week.
    • Bug Triage (Sorting through bugs, marking duplicates, closing, prioritizing)
      • N3X15
    • Documentation (Wiki, FAQ, other stuff people will read)
      • N3X15
    • MORE NEEDED. PLEASE PM ME IF YOU ARE INTERESTED IN TESTING OR DEVELOPING.
    Introduction

    BigBrother is a powerful plugin that enables you to investigate roll back griefing via a large and all-knowing database. You have a choice between using immensely powerful commands to search an area for changes, or you can whack a block with a stick or place a log to see changes within a single block.

    • /bb log - Gives you the BigBrother Multipurpose Tool, or a simple log. Hit something with it to see changes in that spot, and place it if the block you're check is non-solid, like water, lava or air.
    • /bb done - Removes the log from your inventory, and gives you back any items it replaced.
    • Want to check an entire area? Use /bb here to list who changed what!
    • Need to roll back EvilGuy and DoucheBug's edits? Use /bb rollback EvilGuy DoucheBug!
      • Have to roll back edits up to 5 minutes ago? Simple! /bb rollback t:5m
      • Need to only roll back within a certain radius? /bb rollback r:<radius-in-blocks>
      • Roll back specific actions with /bb rollback a:10,BLOCK_PLACE
    • If you screw up, /bb undo
    • (NEW) /bb history "Suspicious Guy" to see that player's recent history! (add pg:# to go to page #)
    • Mow your lawn with /bb mowlawn!
    See the full list of commands and Permissions nodes here.

    Screenshots

    [​IMG]
    [​IMG]
    [​IMG](Yes, stationary_* and regular blocks got reversed, this is fixed.)​
    [​IMG]

    Need Help?

    • What version of CraftBukkit and BigBrother? If you don't know, type /version and /bb version.
    • What database engine are you using? Look at the value for database.type in BigBrother.yml. I use MySQL on my server and test on H2.
    • Do you get any errors? If so, please link to a pastebin with your server.log
    • What steps do I have to take to reproduce this behavior?
    • What other plugins are you using?
    Known Issues
    • Everything listed here
    • ItemCraft is not supported due to it sending unexpected NULLs via Block.getType(). Can be fixed by adding a new enum value for unknown blocks.
    • Bugs everywhere, stopped counting.
    Coming Soon
    • /bb history - Gets the history of a player
    • Fixed /bb update
    • Updated API
    • Externally accessible API
    • Custom Action IDs (for WorldEdit support, etc.)
    More Information

    IRC: Support/Chatter/Developer Jive @ irc.7chan.org #bigbrother (Moved so my build notification bot has an easier time notifying multiple channels)

    Changelog
    BigBrother 1.11.0 Changelog
    • Centralize and update bystander checks.
    • Fix parsing errors in DeltaChest
    • Clarify /bb log
    • Fix sign lines being too far down
    • Add command censoring (for people worried about xAuth and the like)
    • Fix pagination capping
    • Fix an error in DeltaChest reading
    • Add ?autoReconnect=true to the MySQL DSN
    • Remove all H2 support
    • Removed /bb stick from /bb help since it is now obsolete
    • Fixed it so commands that work won't say commands not recognized after they already work
    • Fixed the issue of when you had the /bb log if you broke something it would not record the break even if you were watched
    • Now if the user tries to find the history of an invalid user it won't throw null errors.
    • Yell at the users if they don't follow the setup procedure
    • Should fix most of the errors dealing with the log and watch/unwatch problems
    • Update README
    1.10.0+ (open)

    BigBrother 1.10.1 Changelog
    • Fix a rollback SQL syntax error
    • Fix explosion logging
    • Clarify database trimming message in log
    • Fix /bb history
    • Continue rolling back incorrectly-logged BlockBurns, if the data field is unparsable, default to 0.
    • Fix Heartbeat logging
    • Fix SuperPerms support.
    BigBrother 1.10.0 Changelog

    New Features:
    • Brand new plugin API! (Wiki)
    • Database change. There is now a converter, but you might still lose data!
    • Compact chest changes: (+Added)(=Replaced)(-Removed)
    • Heartbeat Action: Logs users online and the current time, both to keep your database connection open, and for monitoring of your server's uptime!
    • Piston Actions!
    • Bukkit Superperms support!
    • RB 1000 support!
    • /bb history!
    • Formatting fix for rollbacks
    • A buttload of NPE fixes
    Bugfixes:


    • [BB-81] Rollback doesn't work because of empty data-values
    • [BB-78/BB-69] onPickupItem/onDropItem NPEs
    • Memory leak fix (Thanks to Wootalyzer!)
    BigBrother 1.9.1:

    • Use BlockSpreadEvent for tracking fires (later told by EvilSeph that there's no current way to track fire in Bukkit)
    • Display a "Permission Denied" to users trying to use commands with insufficient priviliges instead of silently failing.
    • Add /bb mowlawn.
    • Fix stupid mixup between String.format usage on C# and Java in DeltaChest
    • Automatically update plugin.yml via Maven (internal crap)
    BigBrother 1.9


    • Support for 928+
    • NEW: Lava/Water/Fire flow logging (AND ACTUALLY TESTED, FOR ONCE!)
    • NEW: a: directive for rollbacks, for specifying comma-delimited action IDs to track
    • Lots and lots of bugfixes.
    • Marginally better H2 support
    • More automated tests
    • Standardized QA tests (ongoing)
     
  2. Offline

    kyrrill

    got that problem too, it creates bbusers and bbworld but dont wanna create a new bbdata :(
     
  3. Offline

    andrewkm

    Why doesnt everyone getting errors just try MYSQL! its working so perfectly fine for me..... ?
    [677] + [341] :) !!
     
  4. Offline

    footwo

    These problems are with MYSQL, read what people are saying.

    Even if you drop the tables completely and start fresh it always fails to create bbdata.

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

    andrewkm

    I just did a MASSIVE rollback. 5000+ edits i think...

    everything rolledback fine, however got these errors:

    Code:
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    2011-04-17 20:47:31 [WARNING] [BBROTHER] Caught exception when rolling back a DELTA_CHEST
    Not sure what they are and why.
    Also a massive LAG BOMB took place after rollback and everyone lost connection, but its all good now and they are back.

    [677] + [341]
     
  6. WIll NOT Rollback TNT. I have it configured properly too! i have tried all builds from 320 - 341!
     
  7. Offline

    Jesse57

    Ok first you can calm down.. If you reed to instructions fully as it says "With the current version of BigBrother, you may have to do more work to rollback TNT, burnt blocks, and lava. Currently, these are logged as "Environment" (as it's difficult to match these actions up to a specific player). So rolling back meanieguy and Environment with a good time argument will easily take care of this."


    And now that you also red that learn how to post problems properly before you get flagged and possibly baned
     
  8. Offline

    Liger_XT5

    Some of us CAN'T use mysql. My host will not support MYSQL. I have tried looking elsewhere to link into a mysql server and nothing works for me. I assume that if you want MYSQL for your server, you have to have it local, which sounds stupid.

    Back to what I wanted to say, I've been having server stability issues like crazy when I have BigBrother installed. Even updated it today and still had issues. Here's part of my 17MB server log:

    This is even when I removed the databases and log files and restarted the server.
    Show Spoiler

    2011-04-17 20:08:04 [SEVERE] [BBROTHER] Could not executeUpdate for Upgrading to BLOBs instead of VARCHAR.:
    org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "ALTER TABLE ""BBDATA"" CHANGE[*] ""DATA"" ""DATA"" BLOB NOT NULL "; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
    ALTER TABLE `bbdata` CHANGE `data` `data` BLOB NOT NULL [42001-153]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.message.DbException.getSyntaxError(DbException.java:192)
    at org.h2.command.Parser.getSyntaxError(Parser.java:487)
    at org.h2.command.Parser.parseAlterTable(Parser.java:4774)
    at org.h2.command.Parser.parseAlter(Parser.java:4162)
    at org.h2.command.Parser.parsePrepared(Parser.java:302)
    at org.h2.command.Parser.parse(Parser.java:275)
    at org.h2.command.Parser.parse(Parser.java:251)
    at org.h2.command.Parser.prepare(Parser.java:201)
    at org.h2.command.Parser.prepareCommand(Parser.java:214)
    at org.h2.engine.Session.prepareLocal(Session.java:426)
    at org.h2.engine.Session.prepareCommand(Session.java:374)
    at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
    at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:71)
    at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
    at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:83)
    at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:99)
    at me.taylorkelly.bigbrother.fixes.Fix6.apply(Fix6.java:26)
    at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:175)
    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578)
    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
    at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)


    This is when I was away for a few hours:
    Show Spoiler

    2011-04-17 15:20:05 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending blocks
    org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 2": "'7b31383a343a2d36343a303a303b31393a343a2d36343a303a303b32303a343a2d36343a303a303b32313a343a2d36343a303a303b32373a343a2d36343a303... (808)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1109)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:33)
    at java.lang.Thread.run(Thread.java:636)
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 2": "'7b31383a343a2d36343a303a303b31393a343a2d36343a303a303b32303a343a2d36343a303a303b32313a343a2d36343a303a303b32373a343a2d36343a303... (808)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.table.Column.validateConvertUpdateSequence(Column.java:321)
    at org.h2.table.Table.validateConvertUpdateSequence(Table.java:671)
    at org.h2.command.dml.Insert.insertRows(Insert.java:122)
    at org.h2.command.dml.Insert.update(Insert.java:86)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:33)
    at java.lang.Thread.run(Thread.java:636)
    2011-04-17 15:20:05 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    org.h2.jdbc.JdbcSQLException: Value too long for column "DATA VARCHAR(500) DEFAULT '' NOT NULL SELECTIVITY 2": "'7b31383a343a2d36343a303a303b31393a343a2d36343a303a303b32303a343a2d36343a303a303b32313a343a2d36343a303a303b32373a343a2d36343a303... (808)"; SQL statement:
    INSERT INTO bbdata (date, player, action, world, x, y, z, type, data, rbacked) VALUES (?,?,?,?,?,?,?,?,?,0) [90005-153]
    at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
    at org.h2.message.DbException.get(DbException.java:167)
    at org.h2.table.Column.validateConvertUpdateSequence(Column.java:321)
    at org.h2.table.Table.validateConvertUpdateSequence(Table.java:671)
    at org.h2.command.dml.Insert.insertRows(Insert.java:122)
    at org.h2.command.dml.Insert.update(Insert.java:86)
    at org.h2.command.CommandContainer.update(CommandContainer.java:69)
    at org.h2.command.Command.executeUpdate(Command.java:212)
    at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:143)
    at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1092)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
    at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:33)
    at java.lang.Thread.run(Thread.java:636)
    2011-04-17 15:20:05 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.

    This repeats quite a bit. I'm more than willing to upload the whole text if you'd like to see it all.

    I'd really like to have plugin like to be running all the time to make sure we catch any griefers. I recently caught one of the new players on my server trying to clear an area of trees to build, with fire. If he didn't mention it in the chat, we might have lost the whole continent. :/
     
  9. Offline

    Kainzo

    on a 400MB db - I'm still seeing massive lag on cleansing every 45mins to an hour - really not sure why.
     
  10. Offline

    dervonz

    With version #341 i get this error i didn't get with #332

    Code:
     [BBROTHER] Could not executeUpdate for Upgrading to BLOBs instead of VARCHAR.:
    org.h2.jdbc.JdbcSQLException: Syntax Fehler in SQL Befehl "ALTER TABLE ""BBDATA"" CHANGE[*] ""DATA"" ""DATA"" BLOB NOT NULL "; erwartet "., ADD, SET, RENAME, DROP, ALTER"
    Syntax error in SQL statement "ALTER TABLE ""BBDATA"" CHANGE[*] ""DATA"" ""DATA"" BLOB NOT NULL "; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:
    ALTER TABLE `bbdata` CHANGE `data` `data` BLOB NOT NULL [42001-153]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.getSyntaxError(DbException.java:192)
        at org.h2.command.Parser.getSyntaxError(Parser.java:487)
        at org.h2.command.Parser.parseAlterTable(Parser.java:4774)
        at org.h2.command.Parser.parseAlter(Parser.java:4162)
        at org.h2.command.Parser.parsePrepared(Parser.java:302)
        at org.h2.command.Parser.parse(Parser.java:275)
        at org.h2.command.Parser.parse(Parser.java:251)
        at org.h2.command.Parser.prepare(Parser.java:201)
        at org.h2.command.Parser.prepareCommand(Parser.java:214)
        at org.h2.engine.Session.prepareLocal(Session.java:426)
        at org.h2.engine.Session.prepareCommand(Session.java:374)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1100)
        at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:71)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:243)
        at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:83)
        at me.taylorkelly.bigbrother.tablemgrs.DBTable.executeUpdate(DBTable.java:99)
        at me.taylorkelly.bigbrother.fixes.Fix6.apply(Fix6.java:26)
        at me.taylorkelly.bigbrother.BigBrother.onEnable(BigBrother.java:175)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:578)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:216)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:115)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:93)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:215)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:202)
        at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:142)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:257)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
     
  11. Offline

    N3X15

    Fixing Fixed
     
  12. Offline

    Conan1981

    Hi,

    we┬┤ve just set up BB on our server because we had some Iron - stealing fool on it .. here are the Messages i get, the picke Items are not logged obviously :-/

    Code:
    10:24:23 [INFO] Starting minecraft server version Beta 1.4
    10:24:23 [INFO] Loading properties
    10:24:23 [INFO] Starting Minecraft server on *:25565
    10:24:23 [INFO] This server is running Craftbukkit version git-Bukkit-0.0.0-655-g396957f-b680jnks (MC: 1.4)
    10:24:23 [INFO] Preparing level "world"
    10:24:23 [INFO] Preparing start region
    10:24:24 [INFO] 144 recipes
    10:24:24 [INFO] [BBROTHER] ------------------------------------
    10:24:24 [INFO] [BBROTHER] Hello, and thank you for using the TESTING version of BigBrother!
    10:24:24 [INFO] [BBROTHER] Please note that, since this is far from complete, there will be many bugs.
    10:24:24 [INFO] [BBROTHER] IF YOU FIND ANY BUGS, PLEASE REPORT THEM ON http://bugs.nexisonline.net/bb
    10:24:24 [INFO] [BBROTHER] Please stay tuned in irc.esper.net #bigbrother for updates and build notifications.
    10:24:24 [INFO] [BBROTHER] ------------------------------------
    10:24:24 [INFO] [BBROTHER] Building `bbdata` table...
    10:24:24 [INFO] [BBROTHER] BBData H2 Driver r1 loaded!
    10:24:25 [INFO] [BBROTHER] Building `bbusers` table...
    10:24:25 [SEVERE] [BBROTHER] A permission plugin isn't loaded, only OPs can use commands
    10:24:25 [WARNING] [BBROTHER] 'Help' isn't detected. No /help support
    10:24:25 [INFO] [BBROTHER] BigBrother 1.8-SNAPSHOT enabled
    Code:
    10:25:10 [SEVERE] Could not pass event PLAYER_PICKUP_ITEM to BigBrother
    java.lang.NullPointerException
        at me.taylorkelly.bigbrother.datablock.PickupItem.<init>(PickupItem.java:12)
        at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerPickupItem(BBPlayerListener.java:138)
        at org.bukkit.plugin.java.JavaPluginLoader$17.execute(JavaPluginLoader.java:300)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:257)
        at net.minecraft.server.EntityItem.b(EntityItem.java:204)
        at net.minecraft.server.EntityHuman.i(EntityHuman.java:205)
        at net.minecraft.server.EntityHuman.r(EntityHuman.java:197)
        at net.minecraft.server.EntityPlayer.r(EntityPlayer.java:199)
        at net.minecraft.server.EntityLiving.f_(EntityLiving.java:231)
        at net.minecraft.server.EntityHuman.f_(EntityHuman.java:91)
        at net.minecraft.server.EntityPlayer.a(EntityPlayer.java:156)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:260)
        at net.minecraft.server.Packet10Flying.a(SourceFile:126)
        at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    10:25:21 [INFO] Connection reset
    Code:
    1303115071748 - login [email protected](-261,96,24) info: 0, 93.181.11.206
    1303115077527 - teleport [email protected](-11,66,125) info: 0,
    1303115083552 - exec'd command [email protected](-11,64,125) info: 0, /back
    1303115125532 - disconnect [email protected](4,65,192) info: 0,
    
    I dont checked Boxes so far but this is already unexpected ...
    Did we do anything wrong or is it not supported atm ?
    theres no other plugin on it yet.
     
  13. Offline

    Finda

    BB can't Create 'bbdata' table in MySQL but able to create all other tables
    other MySQL using plugins work fine
    After a while, when a player logins
     
  14. Offline

    cheepz

    Is my config wrong at all?
    Code:
    general:
        excluded-blocks: []
        rollbacks-per-tick: 2000
        personal-log-files: false
        auto-watch: true
        debug-mode: false
        default-search-radius: 5
        tnt-threshold: 10.0
        restore-fire: false
        stick-item: 280
        library-autodownload: true
    database:
        cleanse-age: 3d
        deletes-per-cleansing: '20000'
        max-records: '3000000'
        type: MYSQL
        send-delay: 4
        mysql:
            port: 3306
            username: CENSORED
            engine: MyISAM
            prefix: ''
            low-priority-insert: true
            hostname: veritasrp.minecraft.ms
            password: CENSORED
            database: minecraft
    watched:
        environment:
            lava-flow: false
            leaf-decay: false
        player:
            drop-item: false
            ip-player: false
            disconnect: false
            login: false
            pickup-item: false
            teleport: false
        explosions:
            tnt: true
            creeper: true
            misc: true
        chat:
            commands: true
            chat: false
        blocks:
            chest-changes: true
            block-place: true
            block-break: true
        misc:
            flint-logging: true
            door-open: true
            lever-switch: true
            button-press: true
     
  15. Offline

    Zalastri

    Hey, for some reason with a fresh DB It's not creating bigbrother_bbdata for me. This is what I'm getting miles of:

    Code:
    10:00:04 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    10:00:04 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    10:00:10 [SEVERE] [BBROTHER] Data Insert SQL Exception when sending blocks
    java.sql.BatchUpdateException: Table 'bigbrother.bbdata' doesn't exist
            at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
            at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
            at me.taylorkelly.bigbrother.datasource.DataBlockSender.sendBlocksSQL(DataBlockSender.java:85)
            at me.taylorkelly.bigbrother.datasource.DataBlockSender.access$000(DataBlockSender.java:25)
            at me.taylorkelly.bigbrother.datasource.DataBlockSender$SendingTask.run(DataBlockSender.java:224)
            at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:33)
            at java.lang.Thread.run(Thread.java:717)
    10:00:10 [SEVERE] [BBROTHER] Possible cause of previous SQLException:
    10:00:10 [WARNING] [BBROTHER] SQL send failed. Keeping data for later send.
    >
    
    EDIT: If anyone else is wondering, you can get past this by running an old version for a moment so it can create the right stuff. Worked for me. No errors in console now.
     
  16. Offline

    kyrrill

    okay got a nice db with blob data :) but now... how do i read this data with php myadmin :s :s all i see is [BLOB - 8o]...
     
  17. Offline

    Black_Jack

    Code:
    18:21:55 [SEVERE] Could not pass event PLAYER_DROP_ITEM to BigBrother
    java.lang.NullPointerException
            at me.taylorkelly.bigbrother.datablock.DropItem.<init>(DropItem.java:12)
            at me.taylorkelly.bigbrother.listeners.BBPlayerListener.onPlayerDropItem(BBPlayerListener.java:150)
            at org.bukkit.plugin.java.JavaPluginLoader$15.execute(JavaPluginLoader.java:288)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:59)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:255)
            at net.minecraft.server.EntityHuman.a(EntityHuman.java:280)
            at net.minecraft.server.EntityHuman.z(EntityHuman.java:239)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:344)
            at net.minecraft.server.Packet14BlockDig.a(SourceFile:42)
            at net.minecraft.server.NetworkManager.a(NetworkManager.java:198)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:72)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:100)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:368)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:283)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:375)
    
     
  18. Offline

    Whysopro

    So could anyone tell me how to actually update BB? We replaced the BigBrother.jar but that didn't fix anything, are there any other files/things that need to be modified/updated, and if yes, could someone tell me which and where they're located?
     
  19. Offline

    footwo

    Yeah, loads of us are getting the same problem. No solution or comment from the dev yet so I'm switched to using H2 for now.
     
  20. Offline

    Zalastri

    Like I said, just run an old version like 1 or 2 rbs back. It'll create the tables just fine, then switch back. Working great for me, no errors.
     
  21. Offline

    footwo

    Ill try this.
     
  22. Offline

    Liger_XT5

    Thanks! I'll update and let you know the outcome if something else decides to bug out. lol
     
  23. Offline

    Whysopro

    How to update BB? Hnnng.. I can't find a tutorial about it anywhere.
     
  24. Offline

    Jorrdan

    Signs still wont roll back, am i the only one with this problem?
     
  25. Offline

    mb01

    I need your help to understand the format of 'data'.
    Here's an exemple: {47:24:-64:0:0;48:12:1:0:0=24:64:0:0;
    I understand everything except the =, and what's after :(

    And I don't know why but sometimes it seems that the last entry doesn't how up until you create a new one (by just opening a chest, for exemple) or disconnect. Wierd.
     
  26. Offline

    Jorrdan

    Very latest version doesnt rollback environment such as TnT it also still doesnt rollback signs.
     
  27. Offline

    Flenix

    Hm, Okay. Where can I go to get more information?
    You can hop on over to BigBrother's github repository.

    That link isn't working. Whats the command to see who typed a command in the local area?
    Our mages have a spell called SandBlast which summons a ball of sand to suffocate enemies. I want to know who used it in areas they shouldn't, because they are supposed to undo (with another spell) once their enemy dies...
     
  28. Offline

    airguru

    The format is:
    slot_id:item_id:change:data_value:damage (data value currently not working, sorry :( )
    the = indicates a replacement of item

    So two changes were made to your chest:
    47:24:-64:0:0 - someone took 64 pieces of item 24 from slot 47
    48:12:1:0:0=24:64:0:0 - someone replaced one item 12 in slot 48, with 64 items 24

    If you use MySQL and want more human-readable format of chest logs, I wrote a simple php viewing script for that. Download the source of bigbrother from github, and look for it in the directory api/php/examples. The readme is there. I use it on my server to keep track of all chest accesses :) I don't like locking the chests, but prefer banning for stealing :) (I hope the php script is still working even when the database column was changed to blob)

    As for the late showing of last entry, that's a bukkit problem. The problem is, that we don't have "chest closed" event. So the changes to a chest are computed when a player does any next action after opening chest, like right-clicking, openin door, building a block, loggin out, just anything (except for moving, and picking up and dropping items, since it can happen even before closing a chest).

    Similar problem is, that we don't have "item appeared in inventory" event. So we just compare the contents of chest when player opens it, to a contents, when he makes another action. So, when multiple players will edit chest at the same time, several items will get logged multiple times in each one's log (and I think it will mess-up the reverts a bit:( ). We can't fix this by now, but the chest access logging as it is now is already a helpful improvement.
     
    mb01 likes this.
  29. Offline

    kyrrill

    The php script work well in blob format but still having a little problem :


    Code:
    Notice: Undefined variable: modif in C:\Program Files (x86)\EasyPHP-5.3.6.0\www\bb\api\php\actions\chest_changed.php on line 52
    
    Notice: Undefined index: 279 in C:\Program Files (x86)\EasyPHP-5.3.6.0\www\bb\api\php\actions\chest_changed.php on line 52
    
    Notice: Undefined index: 264 in C:\Program Files (x86)\EasyPHP-5.3.6.0\www\bb\api\php\actions\chest_changed.php on line 52
    
    Notice: Undefined index: 50 in C:\Program Files (x86)\EasyPHP-5.3.6.0\www\bb\api\php\actions\chest_changed.php on line 52
    
    Notice: Undefined index: 278 in C:\Program Files (x86)\EasyPHP-5.3.6.0\www\bb\api\php\actions\chest_changed.php on line 52
    
    Notice: Undefined index: 38 in C:\Program Files (x86)\EasyPHP-5.3.6.0\www\bb\api\php\actions\chest_changed.php on line 52
    And under those lines the table with chest changes
     
  30. Offline

    airguru

    Oh. Well, I'm not too good php programmer :D I think I fixed it however, but can't yet push it to github, because it seems that I broke it once again :mad:. So if you want to solve it quickly, I uploaded the changed api directory to my dropbox: http://dl.dropbox.com/u/3196988/api.zip , Report if it worked for you :)

    The only changed files are chest_changed.php, and unexpectedly, out of nowhere came the error in action.php, so I fixed it too (and it's changed).

    I will try to push this to N3X15's fork asap, once I figure out how to beat the github ;)
     
  31. Offline

    kyrrill

    youhouuu works perfectly ! thanks a lot for answering so fast !!
     
Thread Status:
Not open for further replies.

Share This Page