:frog:
in 2b chat and he whispers me "how the fuck did you just post an emoji"anyone caught selling any drug to a minor should go to prison for decades
what about producersanyone caught selling any drug to a minor should go to prison for decades
what about producers those "neg reinf" should be reserved for the worst crimes,
but only when dealers+ violent crime
. like, only drug trades that already involve violent crime should be legalized?but only when dealers+ violent crime
. like, only drug trades that already involve violent crime should be legalized? approximately 0.5 ounces (14 grams) of baking chocolate per 2.2 pounds (1 kg) of body weight can be fatal for a raccoon
approximately 0.5 ounces (14 grams) of baking chocolate per 2.2 pounds (1 kg) of body weight can be fatal for a raccoon
2023/07/23 17:08:21 Receiving data about shulker named: 2017 banners (2)
2023/07/23 17:08:21 i hate lamp i hate lamp i hate lamp i hate lamp
2023/07/23 17:08:21 IGNORING bad faith data
2023/07/23 17:08:21
2023/07/23 17:08:25 Receiving data about shulker named: 2017 banners (2)
2023/07/23 17:08:25 i hate lamp i hate lamp i hate lamp i hate lamp
2023/07/23 17:08:25 IGNORING bad faith data
2023/07/23 17:08:25
2023/07/23 17:10:08 Receiving data about shulker named: 2017 banners (2)
2023/07/23 17:10:08 i hate lamp i hate lamp i hate lamp i hate lamp
2023/07/23 17:10:08 IGNORING bad faith data
2023/07/23 17:10:08
2023/07/23 17:10:20 Receiving data about shulker named: 2017 banners (2)
2023/07/23 17:10:20 i hate lamp i hate lamp i hate lamp i hate lamp
2023/07/23 17:10:20 IGNORING bad faith data
2023/07/23 17:10:20
if didLampJoinTheTestServerUsingViaVersionAgain(newStacks[i]) {
log.Println("i hate lamp i hate lamp i hate lamp i hate lamp")
log.Println("IGNORING bad faith data")
return
}
func didLampJoinTheTestServerUsingViaVersionAgain(stack *ItemStack) bool {
return stack != nil && bytes.Index(stack.nbt, []byte("Protocol1_12_2To1_13")) != -1
}
func didLampJoinTheTestServerUsingViaVersionAgain
the cost to access the server must be the same for everyone
this is the only applicable linethe cost to access the server must be the same for everyone
this is the only applicable line freeze
, then wipeFrozenAddress
)「Masonic」
and not the single ugliest shulker naming scheme ever devised by humans「Masonic」
and not the single ugliest shulker naming scheme ever devised by humans delete from shulker_contents where timestamp > ?
delete from chest_contents where timestamp > ?
delete from shulker_contents where timestamp > ?
delete from chest_contents where timestamp > ?
delete from shulker_contents where timestamp > ?
delete from chest_contents where timestamp > ?
Inventories.readNbt
was used without copying the shulker BlockEntityTag first. this caused all shulkers in all inventories to have their names stripped on the next frame. this was a mutation in place, so the gringotts system did not see the original name.
as a result, all shulkers at mdma and msd, and all #sorted shulkers anywhere else, have all items with no anvil name. e.g. if you search for diamond pickaxe in gringotts rn, all the other stashes show diamond picks with custom names, but mdma shows all picks having no anvil name
for the time being, please leave future inventoryinfo mod OFF while you are #sorting or #withdrawing or opening gringotts chests manually
mdma and msd will also need a new #scrub with this mod off, as well as any other stash where anyone opened any of the chests with the sortitone mod installed and future inventoryinfo mod on (edited)Inventories.readNbt
was used without copying the shulker BlockEntityTag first. this caused all shulkers in all inventories to have their names stripped on the next frame. this was a mutation in place, so the gringotts system did not see the original name.
as a result, all shulkers at mdma and msd, and all #sorted shulkers anywhere else, have all items with no anvil name. e.g. if you search for diamond pickaxe in gringotts rn, all the other stashes show diamond picks with custom names, but mdma shows all picks having no anvil name
for the time being, please leave future inventoryinfo mod OFF while you are #sorting or #withdrawing or opening gringotts chests manually
mdma and msd will also need a new #scrub with this mod off, as well as any other stash where anyone opened any of the chests with the sortitone mod installed and future inventoryinfo mod on (edited)Inventories.readNbt
was used without copying the shulker BlockEntityTag first. this caused all shulkers in all inventories to have their names stripped on the next frame. this was a mutation in place, so the gringotts system did not see the original name.
as a result, all shulkers at mdma and msd, and all #sorted shulkers anywhere else, have all items with no anvil name. e.g. if you search for diamond pickaxe in gringotts rn, all the other stashes show diamond picks with custom names, but mdma shows all picks having no anvil name
for the time being, please leave future inventoryinfo mod OFF while you are #sorting or #withdrawing or opening gringotts chests manually
mdma and msd will also need a new #scrub with this mod off, as well as any other stash where anyone opened any of the chests with the sortitone mod installed and future inventoryinfo mod on (edited) ,vnnijr
(edited) ,vnnijr
(edited),0
to the url for thati take partially filled shulkers to slowly but surely get rid of the lonely kittens.
/funnel
page, it does actually scan through every stack in every shulker CREATE TABLE IF NOT EXISTS canon (
canon_id INTEGER PRIMARY KEY,
canon TEXT UNIQUE NOT NULL,
CHECK(LENGTH(canon) > 0),
CHECK(canon_id > 0)
);
CREATE TABLE IF NOT EXISTS nbt (
nbt_id INTEGER PRIMARY KEY,
nbt BLOB UNIQUE NOT NULL,
canon_id INTEGER,
CHECK(LENGTH(nbt) > 0),
CHECK(nbt_id > 0),
FOREIGN KEY (canon_id) REFERENCES canon(canon_id) ON UPDATE CASCADE ON DELETE SET NULL
);
CREATE INDEX IF NOT EXISTS nbt_by_canon_just_for_sqlite ON nbt (canon_id) WHERE canon_id IS NOT NULL; -- the nbt_by_canon_just_for_sqlite index is not used by any of our code. it's only there because otherwise "DELETE FROM canon" is too slow, since the foreign key constraints cause it to check nbt on each deleted row, and without the index that's a full table scan per deleted row, so O(n^2) ugh
CREATE TABLE IF NOT EXISTS shulkers (
shulker_id INTEGER PRIMARY KEY,
name TEXT UNIQUE NOT NULL,
timestamp INTEGER NOT NULL,
curr_contents BLOB,
curr_contents_canon BLOB,
curr_stash_id INTEGER,
CHECK(shulker_id > 0),
CHECK(LENGTH(name) > 0),
CHECK(timestamp > 0),
CHECK((curr_contents IS NULL) = (curr_contents_canon IS NULL)),
CHECK(curr_contents IS NULL OR (LENGTH(curr_contents) = 27 * (2 + 1 + 3))),
CHECK(curr_contents_canon IS NULL OR (LENGTH(curr_contents_canon) = 27 * (2 + 1 + 3))),
FOREIGN KEY (curr_stash_id) REFERENCES stashes(stash_id) ON UPDATE CASCADE ON DELETE SET NULL
);
CREATE INDEX IF NOT EXISTS shulkers_by_curr_contents ON shulkers (curr_contents, curr_stash_id) WHERE curr_contents IS NOT NULL AND curr_stash_id IS NOT NULL;
CREATE INDEX IF NOT EXISTS shulkers_by_curr_contents_canon ON shulkers (curr_contents_canon, curr_stash_id) WHERE curr_contents_canon IS NOT NULL AND curr_stash_id IS NOT NULL;
CREATE TABLE IF NOT EXISTS shulker_slots (
shulker_id INTEGER NOT NULL,
slot_id INTEGER NOT NULL,
timestamp INTEGER NOT NULL,
current BOOLEAN NOT NULL,
item_id INTEGER NOT NULL,
quantity INTEGER NOT NULL,
nbt_id INTEGER,
CHECK(quantity >= 0 AND quantity <= 64),
CHECK((item_id = 0) = (quantity = 0)),
CHECK(NOT (item_id = 0 AND nbt_id IS NOT NULL)),
CHECK(timestamp > 0),
CHECK(slot_id >= 0 AND slot_id <= 26),
CHECK((current = 0) OR (current = 1)),
FOREIGN KEY (shulker_id) REFERENCES shulkers(shulker_id) ON UPDATE CASCADE ON DELETE CASCADE,
FOREIGN KEY (nbt_id) REFERENCES nbt(nbt_id) ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE UNIQUE INDEX IF NOT EXISTS shulker_slots_by_slot ON shulker_slots (shulker_id, slot_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS shulker_slots_by_slot_current ON shulker_slots (shulker_id, slot_id) WHERE current;
CREATE INDEX IF NOT EXISTS shulker_slots_by_item ON shulker_slots (item_id) WHERE current;
CREATE TABLE IF NOT EXISTS chest_slots (
x INTEGER NOT NULL,
y INTEGER NOT NULL,
z INTEGER NOT NULL,
slot_id INTEGER NOT NULL,
stash_id INTEGER,
timestamp INTEGER NOT NULL,
current BOOLEAN NOT NULL,
empty BOOLEAN NOT NULL,
shulker_id INTEGER,
CHECK(x >= -30000000 AND x <= 30000000),
CHECK(y >= -64 AND y <= 319),
CHECK(z >= -30000000 AND z <= 30000000),
CHECK(timestamp > 0),
CHECK((current = 0) OR (current = 1)),
CHECK(slot_id >= 0 AND slot_id <= 26),
CHECK((empty = 1) OR (empty = 0)),
CHECK(NOT (empty AND shulker_id IS NOT NULL)),
CHECK(NOT (stash_id IS NULL AND shulker_id IS NOT NULL)),
FOREIGN KEY (shulker_id) REFERENCES shulkers(shulker_id) ON UPDATE CASCADE ON DELETE SET NULL,
FOREIGN KEY (stash_id) REFERENCES stashes(stash_id) ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_slot ON chest_slots (x, z, y, slot_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_shulker ON chest_slots (shulker_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_slot_current ON chest_slots (x, z, y, slot_id) WHERE current;
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_shulker_current ON chest_slots (shulker_id) WHERE current;
CREATE TABLE IF NOT EXISTS shulker_slots (
shulker_id INTEGER NOT NULL,
slot_id INTEGER NOT NULL,
timestamp INTEGER NOT NULL,
current BOOLEAN NOT NULL,
item_id INTEGER NOT NULL,
quantity INTEGER NOT NULL,
nbt_id INTEGER,
CHECK(quantity >= 0 AND quantity <= 64),
CHECK((item_id = 0) = (quantity = 0)),
CHECK(NOT (item_id = 0 AND nbt_id IS NOT NULL)),
CHECK(timestamp > 0),
CHECK(slot_id >= 0 AND slot_id <= 26),
CHECK((current = 0) OR (current = 1)),
FOREIGN KEY (shulker_id) REFERENCES shulkers(shulker_id) ON UPDATE CASCADE ON DELETE CASCADE,
FOREIGN KEY (nbt_id) REFERENCES nbt(nbt_id) ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE UNIQUE INDEX IF NOT EXISTS shulker_slots_by_slot ON shulker_slots (shulker_id, slot_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS shulker_slots_by_slot_current ON shulker_slots (shulker_id, slot_id) WHERE current;
CREATE INDEX IF NOT EXISTS shulker_slots_by_item ON shulker_slots (item_id) WHERE current;
CREATE TABLE IF NOT EXISTS chest_slots (
x INTEGER NOT NULL,
y INTEGER NOT NULL,
z INTEGER NOT NULL,
slot_id INTEGER NOT NULL,
stash_id INTEGER,
timestamp INTEGER NOT NULL,
current BOOLEAN NOT NULL,
empty BOOLEAN NOT NULL,
shulker_id INTEGER,
CHECK(x >= -30000000 AND x <= 30000000),
CHECK(y >= -64 AND y <= 319),
CHECK(z >= -30000000 AND z <= 30000000),
CHECK(timestamp > 0),
CHECK((current = 0) OR (current = 1)),
CHECK(slot_id >= 0 AND slot_id <= 26),
CHECK((empty = 1) OR (empty = 0)),
CHECK(NOT (empty AND shulker_id IS NOT NULL)),
CHECK(NOT (stash_id IS NULL AND shulker_id IS NOT NULL)),
FOREIGN KEY (shulker_id) REFERENCES shulkers(shulker_id) ON UPDATE CASCADE ON DELETE SET NULL,
FOREIGN KEY (stash_id) REFERENCES stashes(stash_id) ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_slot ON chest_slots (x, z, y, slot_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_shulker ON chest_slots (shulker_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_slot_current ON chest_slots (x, z, y, slot_id) WHERE current;
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_shulker_current ON chest_slots (shulker_id) WHERE current;
select item_id from shulker_slots where shulker_id = ? and slot_id = ? order by timestamp desc limit 1
current
columnCREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_shulker_current ON chest_slots (shulker_id) WHERE current;
CREATE TABLE IF NOT EXISTS shulker_slots (
shulker_id INTEGER NOT NULL,
slot_id INTEGER NOT NULL,
timestamp INTEGER NOT NULL,
current BOOLEAN NOT NULL,
item_id INTEGER NOT NULL,
quantity INTEGER NOT NULL,
nbt_id INTEGER,
CHECK(quantity >= 0 AND quantity <= 64),
CHECK((item_id = 0) = (quantity = 0)),
CHECK(NOT (item_id = 0 AND nbt_id IS NOT NULL)),
CHECK(timestamp > 0),
CHECK(slot_id >= 0 AND slot_id <= 26),
CHECK((current = 0) OR (current = 1)),
FOREIGN KEY (shulker_id) REFERENCES shulkers(shulker_id) ON UPDATE CASCADE ON DELETE CASCADE,
FOREIGN KEY (nbt_id) REFERENCES nbt(nbt_id) ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE UNIQUE INDEX IF NOT EXISTS shulker_slots_by_slot ON shulker_slots (shulker_id, slot_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS shulker_slots_by_slot_current ON shulker_slots (shulker_id, slot_id) WHERE current;
CREATE INDEX IF NOT EXISTS shulker_slots_by_item ON shulker_slots (item_id) WHERE current;
CREATE TABLE IF NOT EXISTS chest_slots (
x INTEGER NOT NULL,
y INTEGER NOT NULL,
z INTEGER NOT NULL,
slot_id INTEGER NOT NULL,
stash_id INTEGER,
timestamp INTEGER NOT NULL,
current BOOLEAN NOT NULL,
empty BOOLEAN NOT NULL,
shulker_id INTEGER,
CHECK(x >= -30000000 AND x <= 30000000),
CHECK(y >= -64 AND y <= 319),
CHECK(z >= -30000000 AND z <= 30000000),
CHECK(timestamp > 0),
CHECK((current = 0) OR (current = 1)),
CHECK(slot_id >= 0 AND slot_id <= 26),
CHECK((empty = 1) OR (empty = 0)),
CHECK(NOT (empty AND shulker_id IS NOT NULL)),
CHECK(NOT (stash_id IS NULL AND shulker_id IS NOT NULL)),
FOREIGN KEY (shulker_id) REFERENCES shulkers(shulker_id) ON UPDATE CASCADE ON DELETE SET NULL,
FOREIGN KEY (stash_id) REFERENCES stashes(stash_id) ON UPDATE CASCADE ON DELETE RESTRICT
);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_slot ON chest_slots (x, z, y, slot_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_shulker ON chest_slots (shulker_id, timestamp DESC);
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_slot_current ON chest_slots (x, z, y, slot_id) WHERE current;
CREATE UNIQUE INDEX IF NOT EXISTS chest_slots_by_shulker_current ON chest_slots (shulker_id) WHERE current;
Tavux's Stash In A Box
pink shulker, sorted in june of this yearWITH inputs AS (SELECT ? AS shulker_id, ? AS timestamp), loc AS (SELECT x, y, z, slot_id, timestamp FROM chest_slots WHERE shulker_id = (SELECT shulker_id FROM inputs) AND timestamp = (SELECT timestamp FROM inputs)) SELECT chest_slots.timestamp FROM chest_slots INNER JOIN loc USING (x, y, z, slot_id) WHERE chest_slots.timestamp > loc.timestamp ORDER BY chest_slots.timestamp ASC LIMIT 1
This phenomenon is generally due to an internal short-circuit in the transformer. The short-circuit, created by an insulation failure, reaches 1,200-degree Celsius. It vaporizes the oil located in the transformer tank. The oil, being in contact with very high temperature, vaporizes and creates explosive gases.
leijurv
and i can't lose leijurv lmaomason
edit: password redacted, it's in #gringotts (edited)mason
edit: password redacted, it's in #gringotts (edited)mason
edit: password redacted, it's in #gringotts (edited)