function umc_user_directory()
{
XMPP_ERROR_trace(__FUNCTION__, func_get_args());
// list all users
if (isset($_GET['u'])) {
$username_get = filter_var($_GET['u'], FILTER_SANITIZE_STRING);
$wordpress_id = umc_user_get_wordpress_id($username_get);
$username = strtolower(umc_check_user($username_get));
if (!$wordpress_id) {
return "User does not exist!";
}
// Start tabs
echo '<div style="display: block;" class="umc_jquery_tabs umc_fade_in ui-tabs ui-widget ui-widget-content ui-corner-all">';
echo '<ul role="tablist" class="ui-tabs-nav ui-helper-reset ui-helper-clearfix ui-widget-header ui-corner-all">';
// Start tab 1
echo '<div aria-hidden="false" role="tabpanel" class="ui-tabs-panel ui-widget-content ui-corner-bottom" aria-labelledby="ui-id-1" id="tab0">';
// user icon
echo get_avatar($wordpress_id, $size = '96');
echo "<br><strong>Username:</strong> {$username}<br>";
$uuid = umc_user2uuid($username);
echo "<br><strong>UUID:</strong> {$uuid}<br>";
$previous_names = umc_uuid_username_history($uuid);
if ($previous_names) {
echo "<strong>Usernames History:</strong> {$previous_names}<br>";
}
// is user banned?
if (umc_user_is_banned($uuid)) {
echo "<strong>User is BANNED!</strong><br>";
return;
} else {
umc_promote_citizen($username);
umc_donation_level($username);
}
// get userlevel
$level = umc_get_userlevel($username);
echo "<strong>Level:</strong> {$level}<br>";
$karma = umc_getkarma($uuid, true);
echo "<strong>Karma:</strong> {$karma}<br>";
$money = umc_money_check($uuid);
echo "<strong>Money:</strong> {$money} Uncs<br>";
$donator_level = umc_users_donators($uuid);
if ($donator_level > 12) {
$donator_str = 'More than 1 year';
} else {
if ($donator_level) {
$donator_level_rounded = round($donator_level, 1);
$donator_str = "{$donator_level_rounded} Months";
} else {
$donator_str = "Not a donator";
}
}
echo "<strong>Donations remaining:</strong> {$donator_str}<br>";
// get member since
$online_time = umc_get_lot_owner_age('days', $uuid);
if ($online_time) {
$lastlogin = $online_time[$uuid]['lastlogin']['days'];
$firstlogin = $online_time[$uuid]['firstlogin']['days'];
echo "<strong>Member since:</strong> {$firstlogin} days<br>";
echo "<strong>Offline since:</strong> {$lastlogin} days<br>";
}
// get user bio
$sql = "SELECT meta_value FROM minecraft.wp_users\r\n LEFT JOIN minecraft.wp_usermeta ON wp_users.ID = wp_usermeta.user_id\r\n WHERE display_name='{$username}' AND meta_key='description';";
$D = umc_mysql_fetch_all($sql);
if (count($D) > 0) {
$row = $D[0];
echo "<strong>Bio:</strong> " . $row['meta_value'] . "<br>";
}
// End tab 1
echo "</div>";
// Start tab 2
echo '<div aria-hidden="false" role="tabpanel" class="ui-tabs-panel ui-widget-content ui-corner-bottom" aria-labelledby="ui-id-2" id="tab1">';
// get lots
$lots = umc_user_getlots($uuid);
echo "<strong>Lots:</strong><br> ";
foreach ($lots as $data) {
echo $data['lot'] . "<br>" . $data['image'] . "<br>";
}
// End tab 2
echo "</div>";
// Start tab 3
echo '<div aria-hidden="false" role="tabpanel" class="ui-tabs-panel ui-widget-content ui-corner-bottom" aria-labelledby="ui-id-3" id="tab2">';
// comments
$sql2 = "SELECT comment_date, comment_author, id, comment_id, post_title FROM minecraft.wp_comments\r\n LEFT JOIN minecraft.wp_posts ON comment_post_id=id\r\n WHERE comment_author = '{$username}' AND comment_approved='1' AND id <> 'NULL'\r\n ORDER BY comment_date DESC";
$D2 = umc_mysql_fetch_all($sql2);
echo "<strong>Comments:</strong> (" . count($D2) . ")\n<ul>\n";
foreach ($D2 as $row) {
echo "<li>" . $row['comment_date'] . " on <a href=\"/index.php?p=" . $row['id'] . "#comment-" . $row['comment_id'] . "\">" . $row['post_title'] . "</a></li>\n";
}
echo "</ul>\n";
//forum posts
$sql3 = "SELECT wpp.id AS id, wpp.post_title AS title, wpp.post_date AS date,\r\n\t\twpp.post_parent AS parent, wpp.post_type AS type, parent.post_title AS parent_title\r\n FROM minecraft.wp_posts AS wpp\r\n\t LEFT JOIN minecraft.wp_users ON wpp.post_author=wp_users.id\r\n\t LEFT JOIN minecraft.wp_posts AS parent ON parent.id=wpp.post_parent\r\n\t WHERE wp_users.display_name='{$username}'\r\n\t\tAND (wpp.post_type='reply' OR wpp.post_type='topic')\r\n\t\tAND wpp.post_status='publish'\r\n\t ORDER BY wpp.post_date DESC";
$D3 = umc_mysql_fetch_all($sql3);
// echo $sql;
echo "<strong>Forum Posts:</strong> (" . count($D3) . ")\n<ul>\n";
foreach ($D3 as $row) {
$date = $row['date'];
if ($row['type'] == 'reply') {
$link = $row['parent'] . "#post-" . $row['id'];
$title = $row['parent_title'];
} else {
$link = $row['id'];
$title = $row['title'];
}
echo "<li>{$date} on <a href=\"/index.php?p={$link}\">{$title}</a></li>";
}
echo "</ul>\n";
// End tab 3
echo "</div>";
// Completely end tabs
echo "</div>";
} else {
// $bans = umc_get_banned_users();
//var_dump($bans);
$out = "<script type=\"text/javascript\" src=\"/admin/js/jquery.dataTables.min.js\"></script>\n" . "<script type=\"text/javascript\">\n" . 'jQuery(document).ready(function() {jQuery' . "('#shoptable_users').dataTable( {\"order\": [[ 2, \"desc\" ]],\"paging\": false,\"ordering\": true,\"info\": true} );;} );\n" . "</script>\n" . "This table only tracks online time since 2013-11-20.<br>" . '<table id="shoptable_users"><thead>' . "<th>Username</th>" . "<th>Level</th>" . "<th>Registered days</th>" . "<th>Offline days</th>" . "<th>Lots</th>" . "<th>Online min/day</th>" . "<th>Online hrs</th>" . "</thead>\n<tbody>\n";
$sql = "SELECT username, DATEDIFF(NOW(),firstlogin) as registered_since, parent as userlevel, count(owner) as lot_count, onlinetime, DATEDIFF(NOW(), lastlogin) as days_offline\r\n FROM minecraft_srvr.UUID\r\n LEFT JOIN minecraft_srvr.permissions_inheritance ON UUID.uuid=child\r\n LEFT JOIN minecraft_worldguard.user ON UUID.uuid = user.uuid\r\n LEFT JOIN minecraft_worldguard.region_players ON user.id=region_players.user_id\r\n WHERE owner = 1 AND firstlogin >'0000-00-00 00:00:00' AND username <> '_abandoned_'\r\n GROUP BY username, owner\r\n ORDER BY firstlogin";
$rst = umc_mysql_query($sql);
$now = time();
// or your date as well
$your_date = strtotime("2013-11-20");
$datediff = $now - $your_date;
$alt_days = floor($datediff / (60 * 60 * 24));
while ($row = umc_mysql_fetch_array($rst)) {
$days_offline = $row['days_offline'];
$settler_levels = array('Settler', 'SettlerDonator', 'SettlerDonatorPlus');
if (in_array($row['userlevel'], $settler_levels) && $row['onlinetime'] >= 60) {
umc_promote_citizen(strtolower($row['username']), $row['userlevel']);
}
if ($row['registered_since'] - $days_offline > 1) {
if ($alt_days < $row['registered_since']) {
// people who are not in the lb-players database should not be listed, they are too old
if ($alt_days - $days_offline == 0) {
continue;
}
$avg_online = floor($row['onlinetime'] / 60 / $alt_days);
} else {
$avg_online = floor($row['onlinetime'] / 60 / $row['registered_since']);
}
} else {
$avg_online = 0;
}
$online_total = round($row['onlinetime'] / 60 / 60);
$icon_url = umc_user_get_icon_url($row['username']);
$out .= "<tr>" . "<td><img title='{$row['username']}' src='{$icon_url}' alt=\"{$row['username']}\"> <a href=\"?u={$row['username']}\">{$row['username']}</a></td>" . "<td>{$row['userlevel']}</td>" . "<td class='numeric_td'>{$row['registered_since']}</td>" . "<td class='numeric_td'>{$days_offline}</td>" . "<td class='numeric_td'>{$row['lot_count']}</td>" . "<td class='numeric_td'>{$avg_online}</td>" . "<td class='numeric_td'>{$online_total}</td>" . "</tr>\n";
}
$out .= "</tbody>\n</table>\n";
echo $out;
}
}
function umc_server_status()
{
global $UMC_DOMAIN;
XMPP_ERROR_trace(__FUNCTION__, func_get_args());
$errno = '';
$errstr = '';
$fp = @fsockopen('uncovery.me', 25565, $errno, $errstr, 1);
if (!$fp) {
echo "{$errstr} ({$errno})<br />\n";
return "<img src=\"{$UMC_DOMAIN}/admin/img/offline.png\" height=\"50\"><Br>";
} else {
global $UMC_USER;
$out = "<img src=\"{$UMC_DOMAIN}/admin/img/online.png\" height=\"50\"><br>";
if ($UMC_USER) {
$uuid = $UMC_USER['uuid'];
$username = strtolower($UMC_USER['username']);
$date_new = umc_datetime();
$now = $date_new->format('Y-m-d H:i');
$out .= '<strong>Server Address:</strong> uncovery.me<br>' . '<strong>Server Port:</strong> 25565<br>' . "<strong>Server Time:</strong> {$now}<br>" . "<strong>Next reboot in:</strong> " . umc_time_until_restart() . "<br>";
$result = count_users();
$out .= '<strong>Registered Users:</strong> ' . $result['total_users'] . '<br>';
//$rights = umc_read_data('permissions');
//$users = $rights['permissions']['users'];
//$result = count($users);
//$out .= '<strong>Builders:</strong> '. $result . '<br>';
$out .= '<strong>Online Users:</strong> ';
$online_users = umc_read_markers_file('array');
$no_users = count($online_users);
if ($no_users > 0 && $online_users != '') {
$out .= "({$no_users}) ";
foreach ($online_users as $data) {
$out .= "<a href=\"{$UMC_DOMAIN}/users-2/?u={$data['name']}\">{$data['name']}</a>, ";
}
} else {
$out .= "nobody";
}
$out = rtrim($out, ", ");
// $out .= "<br>". umc_donation_stats();
$dlevel = umc_donation_level($UMC_USER['username']);
if ($dlevel) {
$out .= "<br><strong>Your donation lasts</strong> {$dlevel} more months.";
}
} else {
$out = 'Please login!';
}
}
return $out;
}
function umc_ws_eventhandler($event)
{
global $WS_INIT, $UMC_USER;
XMPP_ERROR_trace(__FUNCTION__, func_get_args());
$player = $UMC_USER['username'];
// iterate all plugins
foreach ($WS_INIT as $data) {
// check if there is a setting for the current event
if ($data['events'] != false && isset($data['events'][$event])) {
// execute function
$function = $data['events'][$event];
if (!is_string($function)) {
XMPP_ERROR_trigger("plugin eventhandler failed event {$event}");
}
// execute the function
$function();
}
}
// non-plugin events
switch ($event) {
case 'PlayerQuitEvent':
umc_log('system', 'logout', "{$player} logged out");
umc_uuid_record_usertimes('lastlogout');
break;
case 'PlayerJoinEvent':
umc_uuid_check_usernamechange($UMC_USER['uuid']);
umc_donation_level($player);
umc_promote_citizen($player, false);
umc_log('system', 'login', "{$player} logged in");
umc_uuid_record_usertimes('lastlogin');
// check if the user has a skin stored, if not, get it
umc_usericon_get($UMC_USER['uuid'], false);
break;
case 'PlayerPreLoginEvent':
// nothing needed since the fact that websend is called makes it register the UUID already
break;
default:
// all the events not covered above
// XMPP_ERROR_send_msg("Event $event not assigned to action (umc_ws_eventhandler)");
}
}
