function cp_modules_mypoints_admin()
{
echo '<div class="wrap">';
echo '<h2>CubePoints - ' . __('My Points', 'cp') . '</h2>';
echo __('Manage and view information about your points.', 'cp');
echo '<br /><br />';
echo '<div style="background:#EFEFEF;display:inline-block;margin-right:25px;"><div style="float:left;font-size:17px;font-weight:bold;background:#E0E0E0;padding:18px;color:#565656;">' . __('My Points', 'cp') . ':</div><div style="float:left;padding:18px;font-size:20px;">' . cp_getPoints(cp_currentUser()) . '</div></div>';
if (cp_module_activated('ranks')) {
echo '<div style="background:#EFEFEF;display:inline-block;"><div style="float:left;font-size:17px;font-weight:bold;background:#E0E0E0;padding:18px;color:#565656;">' . __('My Rank', 'cp') . ':</div><div style="float:left;padding:18px;font-size:20px;">' . cp_module_ranks_getRank(cp_currentUser()) . '</div></div>';
}
echo '<div style="clear:both;"></div><br />';
echo '<p style="font-weight:bold;">' . __('Your recent point transactions:', 'cp') . '</p>';
cp_show_logs(cp_currentUser(), 15, false);
echo '</div>';
}
global $wpdb;
$where = 'WHERE comment_approved = 1 AND user_id = ' . $public_user_ID;
$num_com = $wpdb->get_var("SELECT COUNT( * ) AS total\n\t FROM {$wpdb->comments}\n\t {$where}");
//first steps to implement karma
//$karma = $num_com * 3 + $num_art * 50;
#if (function_exists('cp_getPoints'))
#$karma = cp_getPoints( $public_user_ID ); //$num_com * 3 + $num_art * 50;
$subscriptions = $wp_subscribe_reloaded->get_subscriptions('email', 'equals', $email, 'dt', 'DESC');
#echo 'Username: '******'<br />';
#echo 'User email: ' . $current_user->user_email . '<br />';
#echo 'User first name: ' . $current_user->user_firstname . '<br />';
#echo 'User last name: ' . $current_user->user_lastname . '<br />';
$rank_level = lhg_get_rank_level($public_user_ID);
$karma_rank_total = lhg_get_karma_threshold($rank_level);
if (function_exists('cp_module_ranks_getRank')) {
$rank_txt = cp_module_ranks_getRank($public_user_ID);
}
//if ($karma < 1000){ $karma_rank_total = 1000; $rank_level = 2; }
//if ($karma < 100) { $karma_rank_total = 100 ; $rank_level = 1; }
$max_rank_levels = 7;
$squares_full = '<div class="square_full"></div>';
$squares_empty = '<div class="square_empty"></div>';
$squares = '<br><div class="squarebar">';
$i = 0;
while ($i < $rank_level) {
$squares .= $squares_full;
$i++;
}
while ($i < $max_rank_levels) {
$squares .= $squares_empty;
$i++;
function lhg_comment_percent_bar($uid)
{
global $lang;
if ($lang == "de") {
return;
}
#$karma = cp_getPoints( $uid );
$karma = lhg_get_karma($uid);
$level = lhg_get_rank_level($uid);
$rank_txt = cp_module_ranks_getRank($public_user_ID);
$max_rank = 3;
$tooltip = lhg_user_tooltip($uid);
$output = '<div class="comment_percent_bar">';
$output .= '<div class="rateline" style="border: 0px solid #000;" title="' . $tooltip . '">
<div style="float: left;"></div>
<div class="outerbox" style="background-color: #fff; width: 54px; float: left; margin: 4px 0px; border: 1px solid #eee;">
<div class="box" style="border: 0px solid #088; background-color: #2b8fc3; height: 6px; width: ' . 100 * $level / $max_rank . '%;" >
</div>
</div>
</div>';
//$output .= ''.$rank_txt.'';
$output .= '</div>';
return $output;
}
function gold_admin_bar_init()
{
global $wpdb;
global $wp_admin_bar;
$current_user = wp_get_current_user();
$user_id = $current_user->ID;
$userlogin = $current_user->user_login;
$testing = $wpdb->get_var('select option_value from wp_options where option_name = "cp_module_ranks_data"');
$new = unserialize($testing);
ksort($new);
$new_array = array(current($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new));
reset($new);
$rank = cp_module_ranks_getRank(cp_currentUser());
$rank_points = array_search($rank, $new_array);
$current_rank_points = array_search($rank, $new);
// Get the sum of the gold, silver, and copper.
$prev_lvl = $new_array[$rank_points];
$xp = cp_getPoints($user_id);
$current_lvl = array_search($next_lvl, $new);
$next_ranks_points = $new_array[$rank_points + 1];
$xp_level = array_search($next_ranks_points, $new);
$xp_left = $xp;
$percentage_num = $xp - array_search($prev_lvl, $new);
$percentage_dom = $xp_level - $current_rank_points;
$percentage = $percentage_num / $percentage_dom * 100;
reset($new);
$new = unserialize($testing);
ksort($new);
$first_value = next($new);
$second_value = next($new);
$third_value = next($new);
$forth_value = next($new);
$fifth_value = next($new);
$sixth_value = next($new);
$seventh_value = next($new);
$eaighth_value = next($new);
$nineth_value = next($new);
$tenth_value = next($new);
$eleventh_value = next($new);
$twelveth_value = next($new);
$thirteenth_value = next($new);
$forteenth_value = next($new);
reset($new);
if ($percentage == 0) {
$percentage = 1;
}
if ($percentage > 100) {
$percentage = 100;
}
// Is the user sufficiently leveled, or has the bar been disabled?
if (!is_admin_bar_showing() || !is_user_logged_in()) {
return;
}
$wp_admin_bar->add_menu(array('title' => 'Add', 'href' => false, 'id' => 'gold_links'));
if (!is_admin_bar_showing() || !is_user_logged_in()) {
return;
}
$wp_admin_bar->add_menu(array('title' => "<div id='prog_bar_admin_box' style='width:120px; padding-top: 7px !important;'><div id=\"progress-bar-2\" class=\"all-rounded\" style=\"\tborder: 2px solid #777777 !important;\n\n\n\n\n\n\n\n\tborder-radius: 8px 8px 8px 8px;\n\n\n\n\n\n\n\n\tclear: none !important;\n\n\n\n\n\n\n\n\tmargin-bottom: 0 !important;\n\n\n\n\n\n\n\n\tpadding: 0 !important;\">\n\n\n\n\n\n\n\n\n\t<div id\n\n\n\n\n\n\n\n\t=\"progress-bar-percentage\" class=\"all-rounded\" style=\"\n\n\n\n\n\n\n\n\t-webkit-border-radius: 5px;\n\n\n\n\n\n\n\n -moz-border-radius: 5px;\n\n\n\n\n\n\n\n border-radius: 5px;\n\n\n\n\n\n\n\n\tborder-bottom-width:100%; \n\n\n\n\n\n\n\n\tpadding: 5px 0px;\n\n\n\n\n\n\n\n \tcolor: #FFF;\n\n\n\n\n\n\n\n \tfont-weight: bold;\n\n\n\n\n\n\n\n\tbackground-color:#ff6600;\n\n\n\n\n\n\n\n \ttext-align: center; width: " . $percentage . "%\">\n\n\n\n\n\n\n\n\t</div></div></div>", 'href' => false, 'id' => 'prog_bar_links'));
/**
* Add the submenu links.
*/
$wp_admin_bar->add_menu(array('title' => '
<form action = "" method="post">
<div style="background: url(/wp-content/plugins/cube-gold/images/clock.png); width: 34px; height: 34px; float:left; margin-right:2px;"></div><input type="text" name = "minutes_admin" style="margin-top:8px; margin-left: 6px; width: 25px;" />
for:<input type="text" name = "minutes_reason_admin" style="width: 145px; margin-left: 6px;" />
<br />
<div style="background: url(/wp-content/plugins/cube-gold/images/xp.png); width: 32px; height: 23px; float:left; margin-top: 10px;"></div> <input type="text" name = "xp_admin" style="width:25px; margin-top: 11px; margin-left: 7px; margin-right: 2px;" />
for:<input type="text" name = "xp_reason_admin" style="width: 145px; margin-left: 6px;" />
<br />
<div style="background: url(/wp-content/plugins/cube-gold/images/gold-icon.png); width: 33px; height: 37px; float:left;"></div> <input type="text" name = "gold_admin" style="width:25px; margin-top: 11px; margin-left: 7px; margin-right: 2px;" />
for:<input type="text" name = "gold_reason_admin" style="width: 145px; margin-left: 6px;" />
<br />
<form action="" method="post"><input style="width: 145px; margin-left: 6px;" type="submit" value="Add" /></form>
', 'href' => false, 'parent' => 'gold_links'));
$gold_sum = (int) $wpdb->get_var("select sum(gold) from wp_class_cur where login = '******'");
$minutes_sum = (int) $wpdb->get_var("select sum(minutes) from wp_class_cur where login = '******'");
$period_count_check_three = (int) $wpdb->get_var("select count(*) from wp_total_cur where id = {$user_id} and period_one != 0 and period_two != 0 and period_three != 0");
if ($period_count_check_three != 0) {
$period_count = 3;
} else {
$period_count_check_two = (int) $wpdb->get_var("select count(*) from wp_total_cur where id = {$user_id} and period_one != 0 and period_two != 0");
if ($period_count_check_two != 0) {
$period_count = 2;
} else {
$period_count = 1;
}
}
$minutes_required = 10800 * $period_count;
$minutes_percentage_admin = $minutes_sum / $minutes_required * 100;
$wp_admin_bar->add_menu(array('title' => $rank, 'href' => false, 'parent' => 'prog_bar_links'));
$wp_admin_bar->add_menu(array('title' => $xp_left . "/" . $xp_level . " (" . floor($percentage) . "%)", 'href' => false, 'parent' => 'prog_bar_links'));
$wp_admin_bar->add_menu(array('title' => $minutes_sum . '/' . $minutes_required . ' (' . floor($minutes_percentage_admin) . '%)', 'href' => false, 'parent' => 'prog_bar_links'));
$wp_admin_bar->add_menu(array('title' => $gold_sum . ' Gold', 'href' => false, 'parent' => 'prog_bar_links'));
$minute_admin = $_POST['minutes_admin'];
$gold_admin = $_POST['gold_admin'];
$gold_admin_reason = $_POST['gold_reason_admin'];
$minutes_admin_reason = $_POST['minutes_reason_admin'];
$xp_admin_reason = $_POST['xp_reason_admin'];
$xp_admin = $_POST['xp_admin'];
if (isset($gold_admin) && isset($gold_admin_reason)) {
if ($gold_admin != 0) {
global $wpdb;
$current_user = wp_get_current_user();
$userlogin = $current_user->user_login;
$table_name = $wpdb->prefix . "class_cur";
$wpdb->insert($table_name, array('gold' => $gold_admin, 'gold_reason' => $gold_admin_reason, 'login' => $userlogin, 'timestamp' => date('m/d@H:i', current_time('timestamp', 0))), array('%s', '%s'));
echo '<embed src ="/wp-content/plugins/cube-gold/CashRegister.mp3" hidden="true" autostart="true"></embed>';
}
}
if (isset($xp_admin) && isset($xp_admin_reason)) {
if ($xp_admin != 0) {
global $wpdb;
$current_user = wp_get_current_user();
$user_id = $current_user->ID;
$table_name = $wpdb->prefix . "cp";
$points = cp_getPoints($user_id);
$wpdb->insert($table_name, array('points' => $xp_admin, 'data' => $xp_admin_reason, 'uid' => $user_id, 'timestamp' => time(), 'type' => 'addpoints'), array('%s', '%s'));
update_user_meta($user_id, 'cpoints', $points + $xp_admin);
echo '<div class="noticetime"><div class="notice-wrap"><div class="notice-item-wrapper"><div style="" class="notice-item notice"><div class="notice-item-close">×</div><p>+' . $xp_admin . '</p></div></div></div></div>';
}
}
if (isset($minute_admin)) {
if ($minute_admin != 0) {
global $wpdb;
$current_user = wp_get_current_user();
$userlogin = $current_user->user_login;
$time = date('m/d@H:i', current_time('timestamp', 0));
$table_name = $wpdb->prefix . "class_cur";
$wpdb->insert($table_name, array('minutes' => $minute_admin, 'minutes_reason' => $minutes_admin_reason, 'login' => $userlogin, 'timestamp' => $time), array('%s'));
}
}
}
function cp_module_ranks_widget()
{
if (is_user_logged_in()) {
?>
<li><?php
_e('Rank', 'cp');
?>
: <?php
echo cp_module_ranks_getRank(cp_currentUser());
?>
</li>
<?php
}
}
/**
* cubepoints_bp_profile()
*
* Adds CubePoints to Profile Page
*
* @version 1.9.8.2
* @since 1.0
*/
function cubepoints_bp_profile()
{
global $bp;
if (function_exists('cp_displayPoints')) {
?>
<span class="cubepoints_buddypress"><?php
echo cp_displayPoints($bp->displayed_user->id);
?>
</span>
<?php
}
if (cp_module_activated('donate')) {
if (is_user_logged_in()) {
?>
<span class="cupepoints_buddypress_donate"><a href="#" title="<?php
_e('Donate', 'cp_buddypress');
?>
" onclick="Javascript:cp_module_donate();" class="thickbox cp_donateLink"><?php
_e('Donate Points', 'cp_buddypress');
?>
</a></span>
<?php
}
}
if (cp_module_activated('ranks')) {
?>
<span class="cupepoints_buddypress_rank"><?php
_e('Rank', 'cp_buddypress');
?>
- <?php
echo cp_module_ranks_getRank($bp->displayed_user->id);
?>
</span>
<?php
}
}
/**
* Section template.
*/
function section_template()
{
global $wpdb;
$current_user = wp_get_current_user();
if (isset($_GET['id'])) {
$user_id = $_GET['id'];
$user_info = get_userdata($user_id);
$userlogin = $user_info->user_login;
$gamertag = $user_info->display_name;
$user_website = $user_info->user_url;
} else {
$user_id = $current_user->ID;
$userlogin = $current_user->user_login;
$gamertag = $current_user->display_name;
$user_website = $current_user->user_url;
}
$quest_posts_ids = $wpdb->get_results("select post_id from wp_postmeta where meta_value = 'page.quest.php' and meta_key ='_wp_page_template'");
$quest_posts_count = (int) $wpdb->get_var("select count(*) from wp_postmeta where meta_value = 'page.quest.php' and meta_key ='_wp_page_template'");
$quests_e = (int) $wpdb->get_var("select count(data) from wp_cp where uid = {$user_id} and status = 1");
$quests_a = (int) $wpdb->get_var("select count(data) from wp_cp where uid = {$user_id} and status = 2");
$quests_c = (int) $wpdb->get_var("select count(data) from wp_cp where uid = {$user_id} and status = 3");
$quests_m = (int) $wpdb->get_var("select count(data) from wp_cp where uid = {$user_id} and status = 4");
$quests_ne = $quest_posts_count - $quests_e - $quests_a - $quests_c - $quests_m;
//Progres Bar!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$testing = $wpdb->get_var('select option_value from wp_options where option_name = "cp_module_ranks_data"');
$new = unserialize($testing);
ksort($new);
$new_array = array(current($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new), next($new));
reset($new);
$rank = cp_module_ranks_getRank($user_id);
$rank_points = array_search($rank, $new_array);
$current_rank_points = array_search($rank, $new);
// Get the sum of the gold, silver, and copper.
$prev_lvl = $new_array[$rank_points];
$xp = cp_getPoints($user_id);
$current_lvl = array_search($next_lvl, $new);
$next_ranks_points = $new_array[$rank_points + 1];
$xp_level = array_search($next_ranks_points, $new);
?>
<input type="text" style="display:none;" name="re_xp_in" value="<?php
echo 8000;
?>
" /></form> <?php
if (isset($_POST['re_xp_in'])) {
$xp_left = $_POST['re_xp_in'];
} else {
$xp_left = $xp;
}
$percentage_num = $xp_left - array_search($prev_lvl, $new);
$percentage_dom = $xp_level - $current_rank_points;
$percentage = $percentage_num / $percentage_dom * 100;
if ($percentage <= 1) {
$percentage = 1;
}
reset($new);
$new = unserialize($testing);
ksort($new);
$first_value = next($new);
$second_value = next($new);
$third_value = next($new);
$forth_value = next($new);
$fifth_value = next($new);
$sixth_value = next($new);
$seventh_value = next($new);
$eaighth_value = next($new);
$nineth_value = next($new);
$tenth_value = next($new);
$eleventh_value = next($new);
$twelveth_value = next($new);
$thirteenth_value = next($new);
$forteenth_value = next($new);
//Gold!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$period_count_check_three = (int) $wpdb->get_var("select count(*) from wp_total_cur where id = {$user_id} and period_one != 0 and period_two != 0 and period_three != 0");
if ($period_count_check_three != 0) {
$period_count = 3;
} else {
$period_count_check_two = (int) $wpdb->get_var("select count(*) from wp_total_cur where id = {$user_id} and period_one != 0 and period_two != 0");
if ($period_count_check_two != 0) {
$period_count = 2;
} else {
$period_count = 1;
}
}
$minutes_required = 10800 * $period_count;
$querygold = "SELECT SUM(gold) FROM wp_class_cur where login = '******'";
$resultgold = mysql_query($querygold) or die(mysql_error());
$rowgold = mysql_fetch_array($resultgold);
$gold_rnd = $rowgold['SUM(gold)'];
$queryminutes = "SELECT SUM(minutes) FROM wp_class_cur where login = '******'";
$resultminutes = mysql_query($queryminutes) or die(mysql_error());
$rowminutes = mysql_fetch_array($resultminutes);
$minutes_rnd = $rowminutes['SUM(minutes)'];
$wpdb->update($table_name_c, array('totalgold' => $gold_rnd), array(login => $userlogin), array('%d', '%d'), array('%s'));
$qry_m = "select minutes, minutes_reason, timestamp from wp_class_cur where login = '******' and minutes IS NOT NULL order by id desc ";
$qry_g = "select gold, gold_reason, timestamp from wp_class_cur where login = '******' and gold IS NOT NULL order by id desc";
$qry_xp = "select type, data, points from wp_cp where uid = '{$user_id}' order by id desc";
$qry_per = "select period_one, period_two, period_three, computer_one, computer_two, computer_three from wp_total_cur where login = '******'";
$rt_m = mysql_query($qry_m);
$rt_g = mysql_query($qry_g);
$rt_xp = mysql_query($qry_xp);
$rt_per = mysql_query($qry_per);
$minutes_percentage = $minutes_rnd / $minutes_required * 100;
?>
<head>
<link rel="stylesheet" href="/wp-content/themes/<?php
echo get_stylesheet();
?>
/sections/statspage/myown_js/ui-lightness/jquery-ui-1.8.21.custom.css" type="text/css" />
<link rel="stylesheet" type="text/css" href="/wp-content/themes/<?php
echo get_stylesheet();
?>
/sections/statspage/myown_js/myown_style.css" />
</head>
<body>
<div id="topinfo">
<h2 id="gt"><?php
echo $gamertag;
?>
</h2>
<div id="gravatarstat">
<?php
echo '<div id="re_xp_p"></div>';
echo get_avatar($user_id, '96', $default = '<path_to_url>');
?>
</div>
<div id="profileinfo">
<table cellpadding="0px" id="profiletable">
<tr><td width="150px"><a href="<?php
echo $user_website;
?>
" >Website</a></td><td width="150px">Ecountered: <?php
echo $quests_e + $quests_a + $quests_c + $quests_m;
?>
</td><tr>
<tr><td><?php
echo $rank;
?>
</td><td> Accepted: <?php
echo $quests_a + $quests_c + $quests_m;
?>
</td></tr>
<tr><td> <?php
print $xp_left . '/' . $xp_level;
?>
</td><td> Completed: <?php
echo $quests_c + $quests_m;
?>
</td></tr>
<tr><td> <?php
print $gold_rnd;
?>
Gold </td><td> Mastered: <?php
echo $quests_m;
?>
</td></tr>
<tr><td> <?php
echo $minutes_rnd;
?>
/<?php
echo $minutes_required;
?>
Minutes</td><td>Not Encountered: <?php
echo $quests_ne;
?>
</td><tr>
</table>
</div>
<div id="progressbar">
<?php
print "<div id=\"progress-bar-2\" class=\"all-rounded\">\n";
print "<div id\n\t=\"progress-bar-percentage-stats-2\" class=\"all-rounded\" style=\"\n\t-webkit-border-radius: 5px;\n -moz-border-radius: 5px;\n border-radius: 5px;\n\tborder-bottom-width:100%px; \n\theight:20px;\n\tpadding: 5px 0px;\n \tcolor: #FFF;\n \tfont-weight: bold;\n\tbackground-color:#ff6600;\n\t\nbackground: -webkit-gradient(linear, left top, left bottom, \ncolor-stop(0%, #ff6600), color-stop(20%, #ff6600), color-stop(150%, rgba(255,255,255,.9))); \n\nbackground: -webkit-linear-gradient(top, #ff6600, rgba(255,255,255,.9)); \nbackground: -moz-linear-gradient(top, #ff6600 0%, #ff6600 20%, rgba(255,255,255,.9) 150%);\n \ttext-align: center; width: " . $percentage . "%\">";
print "</div></div>";
print $xp_left . '/' . $xp_level;
?>
</div>
<div id="progressbar2">
<?php
print "<div id=\"progress-bar-3\" class=\"all-rounded\">\n";
?>
<div id="time-indicator">
<div id="ti"> | | | | |
</div>
</div>
<?php
print "<div id\n\t=\"progress-bar-percentage-stats-3\" class=\"all-rounded\" style=\"\n\t-webkit-border-radius: 5px;\n -moz-border-radius: 5px;\n border-radius: 5px;\n\tborder-bottom-width:100%px; \n\theight:20px;\n\tpadding: 5px 0px;\n \tcolor: #FFF;\n \tfont-weight: bold;\n\tbackground-color:#486fb3;\n\t\nbackground: -webkit-gradient(linear, left top, left bottom, \ncolor-stop(0%, #486fb3), color-stop(20%, #486fb3), color-stop(150%, rgba(255,255,255,.9))); \nbackground: -webkit-linear-gradient(top, #486fb3, rgba(255,255,255,.9)); \nbackground: -moz-linear-gradient(top, #486fb3 0%, #486fb3 20%, rgba(255,255,255,.9) 150%);\n \ttext-align: center; width: " . $minutes_percentage . "%\">";
print "</div></div>";
print $minutes_rnd . '/' . $minutes_required;
?>
</div>
</div>
<div id ="tabs">
<ul>
<li><a href="#quests">Quests</a></li>
<li><a href="#xp">XP</a></li>
<li><a href="#minutes">Minutes</a></li>
<li><a href="#gold">Gold</a></li>
<li><a href="#log">Log-ins</a></li>
</ul>
<div id="log">
<?php
$log_list = $wpdb->get_results("select i_datetime from wp_3wp_activity_monitor_index where user_id = {$user_id} and activity_id = 'wp_login' order by i_id desc");
foreach ($log_list as $lg_list) {
foreach ($lg_list as $log_lst) {
echo $log_lst . '<br />';
}
}
?>
</div>
<div id="xp">
<table id="xp_table" rules="rows">
<tr><th>Type</th><th>Reason</th><th>XP</th></tr>
<?php
$j = 1;
while ($nt = mysql_fetch_array($rt_xp)) {
$xp_div_id = $j & 1 ? "odd" : "even";
$data = $nt['data'];
$type = $nt['type'];
$xp_p = $nt['points'];
$xp_quest_check = (int) $wpdb->get_var("select count(*) from wp_cp where data ='{$data}' and uid = {$user_id} and type = 'Quest'");
if ($xp_quest_check != 0) {
$xp_post_id = $wpdb->get_var("select post_parent from wp_posts where post_title = '{$data}' order by id desc limit 1");
$xp_post_id_link = get_permalink($xp_post_id);
echo '<tr id="' . $xp_div_id . '"><th>' . $type . '</th><th><a href="' . $xp_post_id_link . '">' . $data . '</a></th><th>' . $xp_p . '</th></tr>';
} else {
echo '<tr id="' . $xp_div_id . '"><th>' . $type . '</th><th>' . $data . '</th><th>' . $xp_p . '</th></tr>';
}
$j = $j + 1;
}
?>
</table>
</div>
<div id="minutes">
<?php
$v = 1;
while ($nt = mysql_fetch_array($rt_m)) {
$minutes_div_id = $v & 1 ? "odd" : "even";
$minutes = $nt['minutes'];
$minutes_reason = $nt['minutes_reason'];
echo '<div id="' . $minutes_div_id . '">' . $minutes . '-' . $minutes_reason . ' - ' . $nt['timestamp'] . '</div>';
$v = $v + 1;
}
?>
</div>
<div id="gold"
><?php
$g = 1;
while ($nt = mysql_fetch_array($rt_g)) {
$gold_div_id = $g & 1 ? "odd" : "even";
$gold_d = $nt['gold'];
$gold_reason_d = $nt['gold_reason'];
$gold_check_master = (int) $wpdb->get_var("select count(*) from wp_cp where data ='{$gold_reason_d}' and uid = {$user_id} and status in(4,5)");
$gold_check_pc = (int) $wpdb->get_var("select count(*) from wp_class_cur where gold_reason ='{$gold_reason_d}' and login = '******' and status = 5");
if ($gold_check_master != 0) {
$gold_post_id = $wpdb->get_var("select post_parent from wp_posts where post_title = '{$gold_reason_d}' order by id desc limit 1");
$gold_post_id_link = get_permalink($gold_post_id);
echo '<div id= "' . $gold_div_id . '">' . $gold_d . ' - <a href="' . $gold_post_id_link . '" >' . $gold_reason_d . '</a> - ' . $nt['timestamp'] . '</div>';
} else {
if ($gold_check_pc != 0) {
$gold_post_id = $wpdb->get_var("select post_parent from wp_posts where post_title = '{$gold_reason_d}' order by id desc limit 1");
$gold_post_id_link = get_permalink($gold_post_id);
echo '<div id= "' . $gold_div_id . '">' . $gold_d . ' - <a href="' . $gold_post_id_link . '" >' . $gold_reason_d . '</a> - ' . $nt['timestamp'] . '</div>';
} else {
echo '<div id= "' . $gold_div_id . '">' . $gold_d . ' - ' . $gold_reason_d . ' - ' . $nt['timestamp'] . '</div>';
}
}
$g = $g + 1;
}
?>
</div>
<div id="quests">
<?php
$quests = $wpdb->get_results("SELECT id FROM wp_cp WHERE status != 0 and uid = {$user_id} order by id desc");
?>
<table> <tr align="left"><th> Encountered</th><th> Accepted</th><th> Completed</th><th> Mastered</th></tr><?php
$s = 1;
foreach ($quests as $qst) {
foreach ($qst as $qsts) {
$encountered = $wpdb->get_var("SELECT data FROM wp_cp WHERE status = 1 and uid = {$user_id} and id = {$qsts}");
$accepted = $wpdb->get_var("SELECT data FROM wp_cp WHERE status = 2 and uid = {$user_id} and id = {$qsts}");
$completed = $wpdb->get_var("SELECT data FROM wp_cp WHERE status = 3 and uid = {$user_id} and id = {$qsts}");
$mastered = $wpdb->get_var("SELECT data FROM wp_cp WHERE status = 4 and uid = {$user_id} and id = {$qsts}");
$encountered_t = $wpdb->get_var("SELECT data FROM wp_cp WHERE (status = 1 or status = 2 or status = 3 or status = 4) and uid = {$user_id} and id = {$qsts}");
$accepted_t = $wpdb->get_var("SELECT data FROM wp_cp WHERE ( status = 2 or status = 3 or status = 4) and uid = {$user_id} and id = {$qsts}");
$completed_t = $wpdb->get_var("SELECT data FROM wp_cp WHERE ( status = 3 or status = 4) and uid = {$user_id} and id = {$qsts}");
$mastered_t = $wpdb->get_var("SELECT data FROM wp_cp WHERE status = 4 and uid = {$user_id} and id = {$qsts}");
$encountered_time = $wpdb->get_var("SELECT enc FROM wp_class_cur_log WHERE uid = {$user_id} and (quest ='{$encountered}' or quest = '{$accepted}' or quest = '{$completed}' or quest = '{$mastered}')");
$accepted_time = $wpdb->get_var("SELECT acc FROM wp_class_cur_log WHERE uid = {$user_id} and (quest ='{$encountered}' or quest = '{$accepted}' or quest = '{$completed}' or quest = '{$mastered}')");
$completed_time = $wpdb->get_var("SELECT com FROM wp_class_cur_log WHERE uid = {$user_id} and (quest ='{$encountered}' or quest = '{$accepted}' or quest = '{$completed}' or quest = '{$mastered}')");
$mastered_time = $wpdb->get_var("SELECT mas FROM wp_class_cur_log WHERE uid = {$user_id} and (quest ='{$encountered}' or quest = '{$accepted}' or quest = '{$completed}' or quest = '{$mastered}')");
$title = $wpdb->get_var("SELECT data FROM wp_cp where id = {$qsts}");
$ids = (int) $wpdb->get_var("SELECT post_parent FROM wp_posts WHERE post_title = '{$title}' order by id desc limit 1");
$permalink = get_permalink($ids);
?>
<tr id= "<?php
echo $s & 1 ? "odd" : "even";
?>
"> <td align="left" title="<?php
echo $encountered_time;
?>
"><a href="<?php
echo $permalink;
?>
"><?php
echo $encountered_t;
?>
</a> </td>
<td align="left" title="<?php
echo $accepted_time;
?>
"> <a href="<?php
echo $permalink;
?>
"><?php
echo $accepted_t;
?>
</a> </td>
<td align="left" title="<?php
echo $completed_time;
?>
"> <a href="<?php
echo $permalink;
?>
"><?php
echo $completed_t;
?>
</a> </td>
<td align="left" title=" <?php
echo $mastered_time;
?>
"> <a href="<?php
echo $permalink;
?>
"><?php
echo $mastered_t;
?>
</a> </td> </tr> <?php
$s = $s + 1;
}
}
?>
</table>
</div>
</div>
<script src="/wp-content/themes/<?php
echo get_stylesheet();
?>
/sections/statspage/myown_jquery.js"></script>
<script src="/wp-content/themes/<?php
echo get_stylesheet();
?>
/sections/statspage/myown_js/jquery-ui.js"></script>
<script src="/wp-content/themes/<?php
echo get_stylesheet();
?>
/sections/statspage/myown_js/development-bundle/external/jquery.cookie.js"></script>
<script src="/wp-content/themes/<?php
echo get_stylesheet();
?>
/sections/statspage/myown_js/ui.js"></script>
</body>
<?php
do_action('bp_after_blog_page');
?>
</div><!-- .padder -->
</div><!-- #content -->
<?php
}
