[INACTIVE][SEC] BigBrother 1.7.1: A Complete Griefer Logging + Rollback Package [531]

No, It would run like it should. But it would fill up my /tmp but it still worked after that though even with full /tmp. It's like the sqlite was not deleting the files made in /tmp and cleaning up after it self. I only noticed this because MySQL uses the /tmp for every thing before writing to the DB. It was giving me errors saying db full. But stopping the server it self would auto delete all them .lib files.

Works with #80

Anyone managed to get this work with mySQL ?

Yes, me.
You edit the properties and everything is set up automagically, provided your DB permissions are correct.

great addon, but maybe we need more info for /bb here and a radius function for /bb rollback

I was wondering if you could add bucket/flint&tinder use to the logging, this way we that just want to log dont need to get yet another plugin just for this that use other databases

Running Cbukkit 79 with BB on SQLite mode..

1. given the batch delay, is it not possible to rollback a users actions until 4-5 actions are performed in-world?

2. I ran into a problem using BB just now: UserX logged in and spent a few hours building, then i called him over to help test BB. I placed some blocks and had him destroy them. BB detected this just fine with "/bb here UserX", but when I sought to rollback his actions using "/bb rollback UserX 10m"...it instead rolled back ALL of his actions since login hours before.

3. I tried undoing the rollback, but I had already performed another rollback after the damaging one..so it wasn't possible. Needless to say; UserX was unhappy

Which brings me to a suggestion: Is it possible to add a feature to have certain levels of undo history? Maybe up to 5 successive rollbacks?

@lawina : Yea, if you get the settings set up w/ the correct info like Lim-Dul said, it should work great. I'd actually highly recommend using MySQL over SQLite if you have the ability to.

@GyD : Yep, I'm planning on adding a radius-based rollback arguement in the next update. What would you like as more info for /bb here?

@arthoz : It already does have bucket logging (it logs it as placed and broken). And I'm working on fire tracking code to go hand in hand with the flint+steel, so that if User195 were to light a fire, and that ended up destroying your house, rolling him back would fix your house. I may need one more hook though. However, I could have a separate 'action' be just for flint+steel if you'd like that.

@highwisdom :
1) Nope, it's seconds. So if someone does only one action, you can roll them back within 4 seconds
2) Ah, it's /bb rollback UserX t:10m, the different arguments (t:, id:, r: ) need to be started with a identifier so it doesn't get confused and thing 10m is a player.
3) I may do this, but I'm hesitant because if a rollback is large enough, one undo will take up a lot of space in memory, let alone 5 :\

This would also work nicely

forgot the "t:" -_-;....

Is it not possible to make 'savestate' style database backups written to the server HDD instead of holding them in memory?

tkelly, thanks for your great plugins.

One question though, do signs really get logged? I tested it, does not seem to work.
Changed blocks all show up, but not the signs. 1.3.2 / #82

we did have an issue with /bb here t only seems to show changes if your right on the block could do with it being a radius

say jim logs in and finds that theres a huge hole in his house so he calls a mod "hay mrgreaper whats up with this beeping hole in my house grrrr"
mrgreaper goes over and issues /bb here (at the moment mrgreaper would have to stand in the hole)
it tells mrgreaper that meanie2010 was the last one to edit the block
mrgreaper issues /bb here meanie2010 (would that roll back the damage in just that area?) or /bb meanie2010
then has a little chat with meanie2010 to let him know why he is about to be banned
jim meanwhile praises mrgreaper and bigbrother

have i got that right or is there more to it??

we have done the odd test /bb mrgreaper when we first installed but dare not play around with it too much incase it wipes everything the user has done since it was added to the server

@mrgreaper You've almost got it but not quite.

1) /bb here is a radius but only of 2. If you add a number after that you can specify a radius (/bb here 20) or you can change it in the settings file.

2) To roll back you notice that it was meanie2010:
/bb rollback meanie2010 t:1d

the t:1d means rollback everything meanie2010 has done for the last 24 hours (you can use 20m for 20 min etc) which is the best you'll get because (from what I know) radius rollback isn't included yet (ever? I don't know). However, you can roll back by block type instead of time.

If you read the first post there's full instructions as to what it can and can't do. I could always have missed something though.

@highwisdom : yea, I could do a "savestate" for rollback saving/undo. This'll take a little bit of reworking, so I'll probably get that in a little later.

@zipfe : Sign creation doesn't yet (that'll be coming in the next update now that I have a hook I need). But sign destruction is in there. If that's not working for you, let me know.

@mrgreaper : @Pluckerpluck pretty much got it all.
/bb here shows you the changes people modified in the area around you, you can change up the radius by adding a number after that like Plucker said (and you can change the default radius in BigBrother.properties).
If you want to see player+block-specific changes (ie. meanie2010 broke 20 glass and placed 5 tnt), you'd use:
/bb here meanie2010.

Once you're ready to rollback, you'd use /bb rollback meanie2010. And yea, there are a few different arguments you can add to rollback more specifically (as only using that command will rollback all meanie's stuff). Right now you can specificy by time (t) and block type (id) and, in the next update, radius (r).

So all of meanie's changes in the past 1 hr and 30 min within a 50 block radius *will* be:
/bb rollback meanie2010 t:1h30m r:50

nice, thank you

Ah, i just looked for bucket ids, didnt even think about that, *blames lack of sleep*
But yes, an action for flint+steel would be awesome, with users being the pyromaniacs they are theres a lot of usage from it

This is brilliant. So brilliant, as a matter of fact, that I'll be writing a PHP stat generator based on the BB database for my server. Because numbers are awesome.

Yup, a few lines of python typed here and i got a script that makes markers.py for minecraft-overviewer so i can easily see with the eye where "bad things" happen (and show others if i want to)

minecraft overviewer?

its a map generator with google maps interface

willing to share?

what did I do wrong ?

He just did? It's a link to the GitHub page. ;-)

Big Brother is loading fine but the commands aren't doing anything. I'm using the most recent build of both BB and Craftbukkit as of this post.

its definitely loading. /bb commands show in console as unknown commands.

Ah my fault quoted the wrong post, I ment his own person script quoted from his previous post:

"Yup, a few lines of python typed here and i got a script that makes markers.py for minecraft-overviewer so i can easily see with the eye where "bad things" happen (and show others if i want to)"

@subram : It looks like you don't have the dependency library in place. Check the OP and get the one that you need. I think in the next update, I'm going to have it auto-download the dependency libraries...

@arthoz @theoutrider Would you mind sending me/keeping me updated on those scripts? Eventually I'd love to include a web-based browsing package for BB, and those sound like awesome pieces to include.

Sure, no problem, i'll share later on when i add a few more features to it =)

maybe next time GroupUsers support ?
GroupUsers [1.1] - Compatible with hey0's groups.txt and users.txt

Appreciate it .. and tkelly, keep it up!

So I'm getting together a big update that changes around a few things and adds a few things, namely:
- Better connection management. Improve speed and reduce lag overall, and reduce number of .lib files potentially created by SQLite in /tmp folder. (100% done)
- Settings move. Moved settings into the plugins/BigBrother folder. (100% done)
- Dependency Downloader. Download the MySQL and SQLite automatically. (100% done)
- "Environment" logging. When an action can't be accurately attributed to a specific player, it'll be logged as "Environment" to allow you to still rollback and restore to perfect condition. (95% 100% done)
- Explosion logging. Explosions from TNT will try to be associated with a specific player. All other explosions (Creepers, un-associated TNT, Ghast Bombs) will be put into the "Environment". (90% 100%done)
- Leaf Decay. With the initial version, all leaf decay will be logged as "Environment". Later, I'm going to try to associate the decay with a specific player. (100% done)
- Physical History Checker. With a magic stick, you can check the history of an area using different modes. BLOCK mode can show you the history of a specific block. BBHERE mode can essentially run a /bb here command with the stick. I'll probably get more in later. (50% 100% done)
- Radius Rollback. Rollback only the area around you. (100% done)
- Misc Logging. These will be eventually replaced. Logging of Chest opening (will be replaced with removing items from chests). Logging of using flint+steel (will be replaced with fire logging). (70% 100% done).

So I'm just about done probably within 3 days if I'm not too busy IRL; but with so many changes, I'll need a little help testing everything. So if you'd like to help out with testing, let me know.

Oh, and rolling back creepers is awesome :3

I'm entirely planning on making a public release of the stats generator as soon as it's done Good opportunity to finally learn some PHP and SQL. Figuring out the db structure was a lot easier than I expected.