This is probably one of the more critical plugins out there. Just something that takes all changes to the world by players (block creation, block deletion, etc), and logs it to a database. Also useful/awesome would be the ability to undo changes by a player. LogBlock for hMod already does this, albeit the reversion is rather shoddy (it crashes the server :S). A port would be nice unless someone wants to do it from scratch.
Is this much like the hmod big brother plugin because i think that does the same things Maybe that could be ported over by someone if not the person who made it?
LogBlock stores all block changes, creations and placement to a mysql database for quick query and revision.
I'm pretty sure boots said he was going to bring over LogBlock. And I'm also going to bring over a new version of BigBrother. So you'll have just as many options as before
The database would be massive. Every block edit would be logged. Thousands of blocks are placed and deleted a day.
That's really not bad at all; one of our servers at work (from 10+ years ago) was working with a DB larger than that with no real issues. Your main issue would be if the table was over-indexed or not indexed at all, but, aside from that, the SQL databases are meant to handle issues like that.
well funny thing is that this is my HTPC/File Server now also my Minecraft Server, so it only has an Athlon II X2 4GB DDR3, the drives i bought back in Spring 08 (4x640GB, due to space now in Raid-0). But with the change to bukkit (at some point) i might need a better server since it will use more threads (thank god)
I don't know much about SQL but I'd certainly like to see one of the logging plugins for bukkit that would dellete entries of a certain age eg. after a log entry is a week old or something.
Actually, you don't even really need that to be part of the plugin; it'd be a good feature, but, you can also write a cron script in PHP / Python / whatever to connect to the DB and run something like the following: Code: DELETE FROM some_table WHERE date_field < DATE_SUB(NOW(), INTERVAL 7 DAY);