orgremove.php

<?

#
# Minecraftia! Inquisitor json mapped 'org.bukkit.entity' remover
# v1.0
#

require 'bootstrap.php';

use minecraftia\db\Bitch;

$q = "SELECT name, mapped FROM inquisitor.players p WHERE p.mapped LIKE '%bukkit%' LIMIT 1;";
$result = Bitch::source('inquisitor')->all($q);

foreach ($result as $r) {
  $j = json_decode($r["mapped"], true);
  unset($j["mobsKilled"]["org"]);
  $mapped = json_encode($j);

  $q = "UPDATE inquisitor.players p SET p.mapped = :mapped WHERE p.name = :name";
  $result = Bitch::source('inquisitor')->query($q, compact('mapped', 'name'));
}

?>