function umc_home_import()
{
XMPP_ERROR_trace(__FUNCTION__, func_get_args());
// global $UMC_USER;
// we automatically import old homes for all players on login, but only once
// include spyc to parse YAML https://github.com/mustangostang/spyc
require_once '/home/includes/spyc/Spyc.php';
$users = umc_get_active_members();
foreach ($users as $uuid => $username) {
$path = '/home/minecraft/server/bukkit/plugins/Essentials/userdata/' . $uuid . ".yml";
$A = Spyc::YAMLLoad($path);
$existing_count = umc_home_count(false, $uuid);
if ($existing_count > 0) {
continue;
}
if (!isset($A['homes'])) {
continue;
}
$count = count($A['homes']);
if ($count == 0) {
continue;
}
$H = $A['homes'];
// iterate homes and import them
foreach ($H as $home_name => $h) {
$name = umc_mysql_real_escape_string($home_name);
// XMPP_ERROR_trigger($h);
$sql = "INSERT INTO minecraft_srvr.`homes`(`name`, `uuid`, `world`, `x`, `y`, `z`, `yaw`) VALUES " . "({$name},'{$uuid}','{$h['world']}','{$h['x']}','{$h['y']}','{$h['z']}','{$h['yaw']}');";
umc_mysql_query($sql, true);
}
umc_log('home', 'import', "{$uuid}/{$username} {$count} homes have been imported!");
}
}
function umc_get_userinfo($user_raw)
{
$username = strtolower($user_raw);
XMPP_ERROR_trace(__FUNCTION__, func_get_args());
// get registration date from Wordpress
$uuid = umc_user2uuid($username);
$user['uuid'] = $uuid;
// get userlevel, balance, onlinetime
$sql = "SELECT userlevel, onlinetime, lastlogin, lastlogout, username, UUID.UUID, balance, lot_count, firstlogin\r\n FROM minecraft_srvr.UUID\r\n LEFT JOIN minecraft_iconomy.mineconomy_accounts ON UUID.`UUID` = mineconomy_accounts.uuid\r\n WHERE UUID.`UUID` = '{$uuid}'";
$D = umc_mysql_fetch_all($sql);
$d = $D[0];
if ($d['userlevel'] == null) {
$level = 'Guest';
} else {
$level = $d['userlevel'];
}
$username_history = umc_uuid_username_history($uuid);
if ($username_history) {
$user['Username History'] = $username_history;
}
$user['Level'] = $level;
$user['Last Seen'] = $d['lastlogin'];
if ($d['onlinetime'] == NULL) {
$online_time = "n/a";
} else {
$online_time = umc_seconds_to_time($d['onlinetime']);
}
$firstdate = substr($d['firstlogin'], 0, 10);
$today_ts = strtotime("now");
$firsttime_ts = strtotime($firstdate);
$days = round(abs($today_ts - $firsttime_ts) / 60 / 60 / 24);
$user['User since'] = "{$firstdate} ({$days} days)";
if ($firstdate > '2013-11-20') {
// not all play time recorded
$user['Online time since 2013-11-20'] = $online_time;
} else {
$user['Online time'] = $online_time;
}
if ($d['balance'] == NULL) {
$user['Uncs'] = '0.00';
} else {
$user['Uncs'] = number_format($d['balance'], 2, ".", "'");
}
$user['First login'] = $d['firstlogin'];
$homes_count = umc_home_count(false, $uuid);
$user['Homes count'] = $homes_count;
$karma = umc_getkarma($user['uuid'], true);
$user['Karma'] = $karma;
$lots = umc_user_getlots($uuid);
$display_lots = array();
foreach ($lots as $lot => $data) {
$display_lots[$data['world']][] = $lot;
}
foreach ($display_lots as $world => $lots) {
$World = ucfirst($world);
if (count($lots) < 5) {
$user["{$World} lots"] = implode(", ", $lots);
} else {
$user["{$World} lots"] = count($lots) . " lots";
}
}
return $user;
}
function umc_home_import()
{
global $UMC_USER;
// we automatically import old homes for all players on login, but only once
$existing_count = umc_home_count();
if ($existing_count > 0) {
return;
}
// include spyc to parse YAML https://github.com/mustangostang/spyc
require_once '/home/includes/spyc/Spyc.php';
$path = '/home/minecraft/server/bukkit/plugins/Essentials/userdata/' . $UMC_USER['uuid'] . ".yml";
$A = Spyc::YAMLLoad($path);
if (!isset($A['homes']) || count($A['homes']) == 0) {
return;
}
$H = $A['homes'];
// iterate homes and import them
foreach ($H as $home_name => $h) {
$name = umc_mysql_real_escape_string($home_name);
// XMPP_ERROR_trigger($h);
$sql = "INSERT INTO minecraft_srvr.`homes`(`name`, `uuid`, `world`, `x`, `y`, `z`, `yaw`) VALUES " . "({$name},'{$UMC_USER['uuid']}','{$h['world']}','{$h['x']}','{$h['y']}','{$h['z']}','{$h['yaw']}');";
umc_mysql_query($sql, true);
}
umc_log('homes', 'import', "{$UMC_USER['uuid']}/{$UMC_USER['username']}homes have been imported!");
}
