Log Import

Table of Contents BigBrother Imports Players Destroyed Blocks Placed Blocks Flint and Steel Usage Burned blocks TNT Creeper Sign texts Chest Access (only opening of a container)

BigBrother

Unlike LogBlock, BigBrother logs all data into one table.

Example: You want to import the world "world".

1. Look into table `bbworlds` and figure out which id the world "world" has.
2. Replace in all occurrences of "world = 0" in the sql queries below the "0" with the id from step 1.
3. Look into "plugins/LogBlock/config.yml" and figure out which tableName the world "world" uses (default `lb-main`).
4. Replace all occurrences of "lb-main" in the sql queries below with the table name from step 3.
5. Execute the queries separately. E.g. via phpMyAdmin or the MySQL console. All imports are optional except the #Players import.

Imports

Note: The player import is required, while all others are optional.

Players

INSERT IGNORE INTO `lb-players` (playername) SELECT DISTINCT name FROM bbusers;

Destroyed Blocks

INSERT INTO `lb-main` (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 = 1 AND world = 0;

Placed Blocks

INSERT INTO `lb-main` (date, playerid, type, 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 = 2 AND world = 0;

Flint and Steel Usage

INSERT INTO `lb-main` (date, playerid, type, x, y, z)
SELECT FROM_UNIXTIME(date) AS date, playerid, 51, 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 = 15 AND world = 0;

Burned blocks

INSERT IGNORE INTO `lb-players` (playername) VALUES ('Fire');
INSERT INTO `lb-main` (date, playerid, replaced, data, x, y, z)
SELECT FROM_UNIXTIME(date) AS date, (SELECT playerid FROM `lb-players` WHERE playername = 'Fire'), type, data, x, y, z
FROM bbdata
WHERE action = 20 AND world = 0;

TNT

INSERT IGNORE INTO `lb-players` (playername) VALUES ('TNT');
INSERT INTO `lb-main` (date, playerid, replaced, data, x, y, z)
SELECT FROM_UNIXTIME(date) AS date, (SELECT playerid FROM `lb-players` WHERE playername = 'TNT'), type, data, x, y, z
FROM bbdata
WHERE action = 16 AND world = 0;

Creeper

INSERT IGNORE INTO `lb-players` (playername) VALUES ('Creeper');
INSERT INTO `lb-main` (date, playerid, replaced, data, x, y, z)
SELECT FROM_UNIXTIME(date) AS date, (SELECT playerid FROM `lb-players` WHERE playername = 'Creeper'), type, data, x, y, z
FROM bbdata
WHERE action = 17 AND world = 0;

Sign texts

INSERT INTO `lb-main-sign` (id, signtext)
SELECT lb.id, REPLACE(bb.data, '`', '\\0')
FROM bbdata as bb
INNER JOIN bbusers ON bb.player = bbusers.id
INNER JOIN `lb-players` ON bbusers.name = `lb-players`.playername
LEFT JOIN `lb-main` AS lb USING (x, y, z) WHERE (lb.type = '63' OR lb.type = '68') AND bb.action = 13 AND bb.world = 0;

Chest Access (only opening of a container)

INSERT INTO `lb-main` (date, playerid, replaced, type, x, y, z)
SELECT FROM_UNIXTIME(date) AS date, playerid, type AS replaced, type, 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 = 19 AND world = 0;