go_stats.php

<?php

function go_stats_overlay() { 
	echo '<div id="go_stats_page_black_bg" style="display:none !important;"></div><div id="go_stats_white_overlay" style="display:none;"></div>';
}

function go_admin_bar_stats() {
	$user_id = 0;
	if ( ! empty( $_POST['uid'] ) ) {
		$user_id = (int) $_POST['uid'];
		$current_user = get_userdata( $user_id );
	} else {
		$current_user = wp_get_current_user();
		$user_id = $current_user->ID;
	}
	check_ajax_referer( 'go_admin_bar_stats_' );
	
	?>
	<input type="hidden" id="go_stats_hidden_input" value="<?php echo $user_id; ?>"/>
	<?php
	$user_fullname = $current_user->first_name.' '.$current_user->last_name;
	$user_login =  $current_user->user_login;
	$user_display_name = $current_user->display_name;
	$user_website = $current_user->user_url;
	$user_avatar = get_avatar( $user_id, 161 );
	$user_focuses = go_display_user_focuses( $user_id );
	
	// option names 
	$points_name = go_return_options( 'go_points_name' );
	$currency_name = go_return_options( 'go_currency_name' );
	$bonus_currency_name = go_return_options( 'go_bonus_currency_name' );
	$penalty_name = go_return_options( 'go_penalty_name' );
	$minutes_name = go_return_options( 'go_minutes_name' );

	$current_points = go_return_points( $user_id );
	$current_currency = go_return_currency( $user_id );
	$current_bonus_currency = go_return_bonus_currency( $user_id );
	$current_penalty = go_return_penalty( $user_id );
	$current_minutes = go_return_minutes( $user_id );

	$go_option_ranks = get_option( 'go_ranks' );
	$points_array = $go_option_ranks['points'];

	$max_rank_index = count( $points_array ) - 1;
	$max_rank_points = (int) $points_array[ $max_rank_index ];

	$percentage_of_level = 1;

	// user pnc 
	$rank = go_get_rank( $user_id );
	$current_rank = $rank['current_rank'];
	$current_rank_points = $rank['current_rank_points'];
	$next_rank = $rank['next_rank'];
	$next_rank_points = $rank['next_rank_points'];
	
	if ( null !== $next_rank_points ) {
		$rank_threshold_diff = ( $next_rank_points - $current_rank_points );
	} else {
		$rank_threshold_diff = 1;
	}
	$pts_to_rank_threshold = ( $current_points - $current_rank_points );

	if ( $max_rank_points === $current_rank_points ) {
		$prestige_name = go_return_options( 'go_prestige_name' );
		$pts_to_rank_up_str = $prestige_name;
	} else {
		$pts_to_rank_up_str = "{$pts_to_rank_threshold} / {$rank_threshold_diff}";
	}

	$percentage_of_level = ( $pts_to_rank_threshold / $rank_threshold_diff ) * 100;
	if ( $percentage_of_level <= 0 ) { 
		$percentage_of_level = 0;
	} else if ( $percentage_of_level >= 100 ) {
		$percentage_of_level = 100;
	}
	
	?>
	<div id='go_stats_lay'>
		<div id='go_stats_gravatar'><?php echo $user_avatar; ?></div>
		<div id='go_stats_header'>
			<div id='go_stats_user_info'>
				<?php echo "{$user_fullname}<br/>{$user_login}<br/><a href='{$user_website}' target='_blank'>{$user_display_name}</a><br/><div id='go_stats_user_points'><span id='go_stats_user_points_value'>{$current_points}</span> {$points_name}</div><div id='go_stats_user_currency'><span id='go_stats_user_currency_value'>{$current_currency}</span> {$currency_name}</div><div id='go_stats_user_bonus_currency'><span id='go_stats_user_bonus_currency_value'>{$current_bonus_currency}</span> {$bonus_currency_name}</div>{$current_penalty} {$penalty_name}<br/>{$current_minutes} {$minutes_name}"; ?>
			</div>
			<div id='go_stats_user_rank'><?php echo $current_rank; ?></div>
			<div id='go_stats_user_progress'>
				<div id="go_stats_progress_text_wrap">
					<div id='go_stats_progress_text'><?php echo $pts_to_rank_up_str; ?></div>
				</div>
				<div id='go_stats_progress_fill' style='width: <?php echo $percentage_of_level; ?>%;<?php $color = barColor( $current_bonus_currency, $current_penalty ); echo "background-color: {$color}; ";?>'></div>
			</div>
            <?php if ( go_return_options( 'go_focus_switch' ) == 'On' ) {?>
            <div id='go_stats_user_focuses'><?php echo ( ( ! empty( $user_focuses) ) ? $user_focuses : '' ); ?></div>
            <?php } ?>
			<div id='go_stats_user_tabs'>
            <!--
				<a href='javascript:;' id="go_stats_body_progress" class='go_stats_body_selectors' tab='progress'>
					WEEKLY PROGRESS
				</a> | 
            -->
            	<?php $is_admin = current_user_can( 'manage_options' ); if ( $is_admin ) { ?>
               		<a href='javascript:;' id='go_stats_admin_help' class='go_stats_body_selectors' tab='help'>
                    	HELP
                    </a> |
                <?php } ?>
				<a href='javascript:;' id="go_stats_body_tasks" class='go_stats_body_selectors' tab='tasks'>
					<?php echo strtoupper( go_return_options( 'go_tasks_plural_name' ) ); ?>
				</a> | 
				<a href='javascript:;' id="go_stats_body_items" class='go_stats_body_selectors' tab='items'>
					<?php echo strtoupper( go_return_options( 'go_inventory_name' ) ); ?>
				</a> | 
				<a href='javascript:;' id="go_stats_body_rewards" class='go_stats_body_selectors' tab='rewards'>
					REWARDS
				</a> | 
				<a href='javascript:;' id="go_stats_body_minutes" class='go_stats_body_selectors' tab='minutes'>
					<?php echo strtoupper( $minutes_name ); ?>
				</a> |
				<a href='javascript:;' id="go_stats_body_penalties" class='go_stats_body_selectors' tab='penalties'>
					<?php echo strtoupper( $penalty_name ) ?>
				</a> | 
				<a href='javascript:;' id="go_stats_body_badges" class='go_stats_body_selectors' tab='badges'>
					<?php echo strtoupper( go_return_options( 'go_badges_name' ) ); ?>
				</a> | 
				<a href='javascript:;' id="go_stats_body_leaderboard" class='go_stats_body_selectors' tab='leaderboard'>
					<?php echo strtoupper( go_return_options( 'go_leaderboard_name' ) ); ?>
				</a>
			</div>
		</div>
		<div id='go_stats_body'></div>
	</div>
	<?php 
	die();
}

function go_stats_task_list() {
	global $wpdb;
	$go_table_name = "{$wpdb->prefix}go";
	if ( ! empty( $_POST['user_id'] ) ) {
		$user_id = (int) $_POST['user_id'];
	} else {
		$user_id = get_current_user_id();
	}
	check_ajax_referer( 'go_stats_task_list_' );

	$is_admin = current_user_can( 'manage_options' );
	$task_list = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT status, post_id, count, url 
			FROM {$go_table_name} 
			WHERE uid = %d AND (status = 1 OR status = 2 OR status = 3 OR status = 4) 
			ORDER BY id DESC",
			$user_id
		)
	);
	$counter = 1;
	?>
	<ul id='go_stats_tasks_list' <?php if ( $is_admin ) { echo "class='go_stats_tasks_list_admin'"; } ?>>
		<?php
		foreach ( $task_list as $task ) {
			$task_urls = unserialize( $task->url );
			$custom = get_post_meta( $task->post_id );
			?>
			<li class='go_stats_task <?php if ( $counter % 2 == 0) { echo 'go_stats_right_task'; } ?>'>
				<a href='<?php echo get_permalink( $task->post_id ); ?>' <?php echo ( ( $user_id != get_current_user_id() ) ? "target='_blank'" : '' ); ?>class='go_stats_task_list_name'><?php echo get_the_title( $task->post_id); ?></a>
				<?php
				if ( $is_admin ) {
				?>
				<button class='go_stats_task_admin_submit' task='<?php echo $task->post_id; ?>'>SEND</button>
					<input type='text' class='go_stats_task_admin_message' id='go_stats_task_<?php echo $task->post_id ?>_message' name='go_stats_task_admin_message' placeholder='See me'/>
                    
				<?php 
				}
				?>
				<div class='go_stats_task_status_wrap'>
				<?php
								
				if ( ! empty( $custom['go_mta_three_stage_switch'][0] ) && $custom['go_mta_three_stage_switch'][0] == 'on' ) {
					$stage_count = 3;
				} elseif ( ! empty( $custom['go_mta_five_stage_switch'][0] ) && $custom['go_mta_five_stage_switch'][0] == 'on' ) {
					$stage_count = 5;
				} else {
					$stage_count = 4;
				}

				$url_switch = array(
					1 => ! empty( $custom['go_mta_encounter_url_key'][0] ),
					2 => ! empty( $custom['go_mta_accept_url_key'][0] ),
					3 => ! empty( $custom['go_mta_completion_url_key'][0] ),
					4 => ! empty( $custom['go_mta_mastery_url_key'][0] )
				);
				
				for ( $i = 5; $i > 0; $i--) {

					/* 
					 * Produces an empty string when the user hasn't viewed any quests yet.
					 * When populated, the timestamps variable will contain an array. The
					 * array will contain arrays, indexed by the post id of the task, which
					 * will contain timestamps indexed by stage.
					 *  
					 * e.g. $timestamps[342][2][0] will grab the first registered attempt
					 *		at the accept stage of task with the post id 342.
					 *		$timestamps[342][2][1] will grab the most recent attempt.
					 */
					$timestamps = get_user_meta( $user_id, 'go_task_timestamps', true );

					// Used for the class attribute in the stage box anchor tag.
					$link_class_list_str = 'go_stats_task_stage_wrap go_user';

					/*
					 * Used for the href attribute in the stage box anchor tag.
					 * The stage URL is not set to "#" by default, because the
					 * stage box div tag's class list relies on the stage URL
					 * being empty. An inline empty check is made for the stage
					 * URL as the stage box is being output.
					 */
					$link_stage_url = '';

					// Used for the target attribute in the stage box anchor tag.
					$link_target_string = '';

					// Used for the class attribute in the stage box div tag.
					$div_class_list_str = 'go_stats_task_status';

					// Used for the title attribute in the stage box div tag.
					$div_title_str = '';

					// Used for the count attribute in the repeat stage box div tag.
					$div_count_str = '';

					/*
					 * Used for the date timestamp in the content of the stage box div tag
					 * (for all except the repeat stage box).
					 */
					$div_timestamp_date_str = '';

					if ( ! empty( $task_urls[ $i ] ) ) {
						$link_stage_url = $task_urls[ $i ];
					} else if ( 5 == $i &&
							! empty( $task_urls[4] ) &&
							4 == $task->status &&
							$task->count >= 1 ) {
						$link_stage_url = $task_urls[4];
					}

					if ( $is_admin ) {
						$link_class_list_str = 'go_stats_task_admin_stage_wrap';
					}

					if ( ! empty( $link_stage_url ) ) {
						$link_class_list_str .= ' go_stats_task_stage_url';
					}

					if ( is_array( $timestamps ) && ! empty( $timestamps[ $task->post_id ] ) &&
							! empty( $timestamps[ $task->post_id ][ $i ] ) ) {
						$div_title_str = "First attempt: {$timestamps[ $task->post_id ][ $i ][0]}\n".
							"Most recent: {$timestamps[ $task->post_id ][ $i ][1]}";
					}

					if ( $task->status >= $i || $task->count >= 1 ) {
						$div_class_list_str .= ' completed';
					} else if ( $i > $stage_count ) {
						$div_class_list_str .= ' go_stage_does_not_exist';
					}

					if ( ! empty( $link_stage_url ) &&
							( ( $i <= 4 && $task->count < 1 ) ||
							( $i == 5 && $task->count >= 1 ) ) ) {
						$div_class_list_str .= ' stage_url';
					}

					if ( ! empty( $url_switch[ $i - 1 ] ) &&
							$task->status < $i &&
							$task->count < 1 &&
							$i <= $stage_count ) {
						$div_class_list_str .= ' future_url';
					}

					if ( $i == 5 && $task->count > 1 ) {
						$div_count_str = $task->count;
					}

					if ( 5 != $i &&
							is_array( $timestamps ) &&
							! empty( $timestamps[ $task->post_id ] ) &&
							! empty( $timestamps[ $task->post_id ][ $i ][0] ) ) {
						$div_timestamp_date_str = substr(
							$timestamps[ $task->post_id ][ $i ][0],
							0,
							5
						);
					}

					/*
					 * This echo statement displays the stage boxes in the stats panel.
					 * We simply check for the task count string being empty, as the count
					 * attribute should be added to the div when the repeat stage's box is
					 * being displayed. There is no check for the date timestamp string being
					 * empty because it will simply output an empty string on the repeat
					 * stage's box.
					 */
					echo "
						<a class='{$link_class_list_str}' href='".( ! empty( $link_stage_url ) ? $link_stage_url : '#' )."' ".
								( ! empty( $link_stage_url ) ? 'target="_blank"' : '' ).">
							<div class='{$div_class_list_str}' title='{$div_title_str}' task='{$task->post_id}' stage='{$i}' ".
									( ! empty( $div_count_str ) ? "count='{$div_count_str}'>{$div_count_str}" : '>' ).
								"<p>{$div_timestamp_date_str}</p>
							</div>
						</a>
					";
				}
				?>
				</div>
			<?php
			$counter++;
			?>
			</li>
			<?php
		}
	?>
	</ul>
	<?php
	die();
}

function go_stats_move_stage() {
	global $wpdb;

	if ( ! current_user_can( 'manage_options' ) ) {
		die( -1 );
	}

	$go_table_name = "{$wpdb->prefix}go";
	if ( ! empty( $_POST['user_id'] ) ) {
		$user_id = (int) $_POST['user_id'];
	} else {
		$user_id = get_current_user_id();
	}
	check_ajax_referer( 'go_stats_move_stage_' );

	$current_rank = get_user_meta( $user_id, 'go_rank', true );
	$task_id = ( ! empty( $_POST['task_id'] ) ? (int) $_POST['task_id'] : 0 );
	$status  = ( ! empty( $_POST['status'] ) ? (int) $_POST['status'] : 1 );
	$count   = ( ! empty( $_POST['count'] ) ? (int) $_POST['count'] : 0 );
	$message = ( ! empty( $_POST['message'] ) ? sanitize_text_field( $_POST['message'] ) : 'See me' );
	$custom_fields = get_post_custom( $task_id );
	$date_picker = (
		! empty( $custom_fields['go_mta_date_picker'][0] ) && unserialize( $custom_fields['go_mta_date_picker'][0] ) ?
		array_filter( unserialize( $custom_fields['go_mta_date_picker'][0] ) ) :
		null
	);
	$rewards = unserialize( $custom_fields['go_presets'][0] );
	$current_status = $wpdb->get_var(
		$wpdb->prepare(
			"SELECT status 
			FROM {$go_table_name} 
			WHERE uid = %d AND post_id = %d",
			$user_id,
			$task_id
		)
	);
	$page_id = $wpdb->get_var(
		$wpdb->prepare(
			"SELECT page_id 
			FROM {$go_table_name} 
			WHERE uid = %d AND post_id = %d",
			$user_id,
			$task_id
		)
	);

	$go_option_ranks = get_option( 'go_ranks' );
	$points_array = $go_option_ranks['points'];

	$max_rank_index = count( $points_array ) - 1;
	$max_rank_points = (int) $points_array[ $max_rank_index ];
	$prestige_name = go_return_options( 'go_prestige_name' );

	$changed = array(
		'type'            => 'json',
		'points'          => 0,
		'currency'        => 0,
		'bonus_currency'  => 0,
		'max_rank_points' => $max_rank_points,
		'prestige_name'   => $prestige_name,
	);

	if ( ! empty( $date_picker ) ) {
		$dates = $date_picker['date'];
		$percentages = $date_picker['percent'];
		$unix_today = strtotime( date( 'Y-m-d' ) );

		$past_dates = array();

		foreach ( $dates as $key => $date ) {
			if ( $unix_today >= strtotime( $date ) ) {
				$past_dates[ $key ] = abs( $unix_today - strtotime( $date ) );
			}
		}

		if ( ! empty( $past_dates ) ) {
			asort( $past_dates );
			$update_percent = (float) ( ( $percentages[ key( $past_dates ) ] ) / 100);
		} else {
			$update_percent = 1;
		}
	} else {
		$update_percent = 1;
	}

	if ( 1 === $status ) {
		$current_rewards = $wpdb->get_results(
			$wpdb->prepare(
				"SELECT points, currency, bonus_currency 
				FROM {$go_table_name} 
				WHERE uid = %d AND post_id = %d",
				$user_id,
				$task_id
			)
		);

		go_task_abandon(
			$user_id,
			$task_id,
			$current_rewards[0]->points,
			$current_rewards[0]->currency,
			$current_rewards[0]->bonus_currency * $update_percent
		);

		$changed['points'] = -$current_rewards[0]->points;
		$changed['currency'] = -$current_rewards[0]->currency;
		$changed['bonus_currency'] = -$current_rewards[0]->bonus_currency;

		$current_points = go_return_points( $user_id );
		$updated_rank = get_user_meta( $user_id, 'go_rank', true );
		if ( $current_rank[0][1] != $updated_rank[0][1] ) {
			$changed['rank'] = $updated_rank[0][0];
		}
		$changed['current_points'] = $current_points;
		$changed['current_rank_points'] = $updated_rank[0][1];
		$changed['next_rank_points'] = $updated_rank[1][1];
		$changed['abandon'] = 'true';

		if ( 'See me' === $message ) {
			go_message_user( $user_id, $message.' about, <a href="'.get_permalink( $task_id ).'" style="display: inline-block; text-decoration: underline; padding: 0px; margin: 0px;">'.get_the_title( $task_id ).'</a>, please.' );
		} else {
			go_message_user( $user_id, 'RE: <a href="' . get_permalink( $task_id ) . '">' . get_the_title( $task_id ) . '</a> ' . $message );
		}
	} else {

		for ( $count; $count > 0; $count-- ) {
			go_add_post(
				$user_id, $task_id, $current_status,
				floor( -$rewards['points'][ $current_status ] * $update_percent ),
				floor( -$rewards['currency'][ $current_status ] * $update_percent ),
				floor( -$rewards['bonus_currency'][ $current_status ] * $update_percent ),
				null, $page_id, true, -1
			);

			$changed['points'] += floor(
				-$rewards['points'][ $current_status ] * $update_percent
			);
			$changed['currency'] += floor(
				-$rewards['currency'][ $current_status ] * $update_percent
			);
			$changed['bonus_currency'] += floor(
				-$rewards['bonus_currency'][ $current_status ] * $update_percent
			);
		}

		while ( $current_status != $status ) {
			if ( $current_status > $status ) {
				$current_status--;

				go_add_post(
					$user_id, $task_id, $current_status,
					floor( -$rewards['points'][ $current_status ] * $update_percent ),
					floor( -$rewards['currency'][ $current_status ] * $update_percent ),
					floor( -$rewards['bonus_currency'][ $current_status ] * $update_percent ),
					null, $page_id, false, null
				);

				$changed['points'] += floor(
					-$rewards['points'][ $current_status ] * $update_percent
				);
				$changed['currency'] += floor(
					-$rewards['currency'][ $current_status ] * $update_percent
				);
				$changed['bonus_currency'] += floor(
					-$rewards['bonus_currency'][ $current_status ] * $update_percent
				);

			} elseif ( $current_status < $status ) {
				$current_status++;
				$current_count = $wpdb->get_var(
					$wpdb->prepare(
						"SELECT count 
						FROM {$go_table_name} 
						WHERE uid = %d AND post_id = %d",
						$user_id,
						$task_id
					)
				);
				if ( 5 === $current_status && 0 === $current_count ) {
					go_add_post(
						$user_id, $task_id, $current_status - 1,
						floor( $rewards['points'][ $current_status - 1 ] * $update_percent ),
						floor( $rewards['currency'][ $current_status - 1 ] * $update_percent ),
						floor( $rewards['bonus_currency'][ $current_status - 1 ] * $update_percent ),
						null, $page_id, true, 1
					);

					$changed['points'] += floor( $rewards['points'][ $current_status - 1 ] * $update_percent );
					$changed['currency'] += floor( $rewards['currency'][ $current_status - 1 ] * $update_percent );
					$changed['bonus_currency'] += floor( $rewards['bonus_currency'][ $current_status - 1 ] * $update_percent );

				} elseif ( $current_status < 5 ) {
					go_add_post(
						$user_id, $task_id, $current_status,
						floor( $rewards['points'][ $current_status - 1 ] * $update_percent ),
						floor( $rewards['currency'][ $current_status - 1 ] * $update_percent ),
						floor( $rewards['bonus_currency'][ $current_status - 1 ] * $update_percent ),
						null, $page_id, false, null
					);

					$changed['points'] += floor( $rewards['points'][ $current_status - 1 ] * $update_percent );
					$changed['currency'] += floor( $rewards['currency'][ $current_status - 1 ] * $update_percent );
					$changed['bonus_currency'] += floor( $rewards['bonus_currency'][ $current_status - 1 ] * $update_percent );
				}
			}
		}

		if ( 'See me' === $message ) {
			go_message_user( $user_id, $message.' about, <a href="'.get_permalink( $task_id ).'" style="display: inline-block; text-decoration: underline; padding: 0px; margin: 0px;">'.get_the_title( $task_id ).'</a>, please.' );
		} else {
			go_message_user( $user_id, 'RE: <a href="'.get_permalink( $task_id ).'">'.get_the_title( $task_id ).'</a> '.$message );
		}
		$current_points = go_return_points( $user_id );
		$updated_rank = get_user_meta( $user_id, 'go_rank', true );
		if ( $current_rank[0][1] != $updated_rank[0][1] ) {
			$changed['rank'] = $updated_rank[0][0];
		}
		$changed['current_points'] = $current_points;
		$changed['current_rank_points'] = $updated_rank[0][1];
		$changed['next_rank_points'] = $updated_rank[1][1];
	}

	echo json_encode( $changed );
	die();
}

function go_stats_item_list() {
	global $wpdb;
	$go_table_name = "{$wpdb->prefix}go";
	if ( ! empty( $_POST['user_id'] ) ) {
		$user_id = (int) $_POST['user_id'];
	} else {
		$user_id = get_current_user_id();
	}
	check_ajax_referer( 'go_stats_item_list_' );

	$items = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT * 
			FROM {$go_table_name} 
			WHERE uid = %d AND status = %d AND gifted = %d 
			ORDER BY timestamp DESC, id DESC, reason DESC",
			$user_id,
			-1,
			0
		)
	);
	$gifted_items = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT * 
			FROM {$go_table_name} 
			WHERE uid = %d AND status = %d AND gifted = %d 
			ORDER BY timestamp DESC, reason DESC, id DESC",
			$user_id,
			-1,
			1
		)
	);
	?>
	<div style="width: 99%;">
	 <div style="float: left; width: 33%;"><strong>PURCHASES</strong></div>
	 <div style="float: left; width: 33%;"><strong>RECEIVED</strong></div>
	 <div style="float: left; width: 33%;"><strong>SOLD</strong></div>
 	 <br style="clear: left;" />
	</div>

	<ul id='go_stats_item_list_purchases' class='go_stats_body_list'>
		<?php
		
		foreach ( $items as $item ) {
			$item_id = $item->post_id;
			$item_count_total = $wpdb->get_var(
				$wpdb->prepare(
					"SELECT SUM( count ) 
					FROM {$go_table_name} 
					WHERE uid = %d AND status = %d AND post_id = %d",
					$user_id,
					-1,
					$item_id
				)
			);
			$count_before = $wpdb->get_var(
				$wpdb->prepare(
					"SELECT SUM( count ) 
					FROM {$go_table_name} 
					WHERE uid = %d AND status = %d AND post_id = %d AND id <= %d",
					$user_id,
					-1,
					$item_id,
					$item->id
				)
			);
			$purchase_date = $item->timestamp;
			$purchase_reason = $item->reason;
			?>
				<li class='go_stats_item go_stats_purchased_item'>
					<?php
						echo "<a href='#' onclick='go_lb_opener({$item_id})'>".get_the_title( $item_id )."</a> ({$count_before} of {$item_count_total}) {$purchase_date} {$purchase_reason}";
					?>
				</li>
			<?php
		}
		?>
	</ul>
	<ul id='go_stats_item_list_recieved' class='go_stats_body_list'>
        <?php
		
		if ( ! empty( $gifted_items ) ) {		
			foreach ( $gifted_items as $item ) {
				$item_id = $item->post_id;
				$item_count_total = $wpdb->get_var(
					$wpdb->prepare(
						"SELECT SUM( count ) 
						FROM {$go_table_name} 
						WHERE uid = %d AND status = %d AND post_id = %d",
						$user_id,
						-1,
						$item_id
					)
				);
				$count_before = $wpdb->get_var(
					$wpdb->prepare(
						"SELECT SUM( count ) 
						FROM {$go_table_name} 
						WHERE uid = %d AND status = %d AND post_id = %d AND id <= %d",
						$user_id,
						-1,
						$item_id,
						$item->id
					)
				);
				$purchase_date = $item->timestamp;
				$purchase_reason = $item->reason;
				?>
					<li class='go_stats_item go_stats_purchased_item'>
						<?php
							echo "<a href='#' onclick='go_lb_opener({$item_id})'>".get_the_title( $item_id )."</a> ({$count_before} of {$item_count_total}) {$purchase_date}";
						?>
					</li>
				<?php
			}
		}
		?>
	</ul>
	<ul class='go_stats_body_list'>
	</ul>
	<?php
	die();
}

function go_stats_rewards_list() {
	global $wpdb;
	$go_table_name = "{$wpdb->prefix}go";
	if ( ! empty( $_POST['user_id'] ) ) {
		$user_id = (int) $_POST['user_id'];
	} else {
		$user_id = get_current_user_id();
	}
	check_ajax_referer( 'go_stats_rewards_list_' );

	$new_tab = ( $user_id != get_current_user_id() ) ? "target='_blank'" : '';
	$rewards = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT * 
			FROM {$go_table_name} 
			WHERE uid = %d AND ( points != %d OR currency != 0 OR bonus_currency != 0 ) 
			ORDER BY id DESC",
			$user_id,
			0
		)
	);
	?>
	<div style="width: 99%;">
	 <div style="float: left; width: 33%;"><strong><?php echo strtoupper( go_return_options( 'go_points_name' ) ); ?></strong></div>
	 <div style="float: left; width: 33%;"><strong><?php echo strtoupper( go_return_options( 'go_currency_name' ) ); ?></strong></div>
	 <div style="float: left; width: 33%;"><strong><?php echo strtoupper( go_return_options( 'go_bonus_currency_name' ) ); ?></strong></div>
 	 <br style="clear: left;" />
	</div>
	<ul id='go_stats_rewards_list_points' class='go_stats_body_list'>
	<?php
	foreach ( $rewards as $reward ) {
		$reward_id = $reward->post_id;
		$reward_points = $reward->points;
		if ( $reward_points != 0 ) {
			$reward_html = '';
			if ( ! empty( $reward->status ) ) {
				if ( $reward->status == -1 ) {
					$reward_html = sprintf(
						'<div class="go_stats_item_wrapper"><a href="#" onclick="go_lb_opener(%s)">%s</a></div>',
						$reward_id,
						get_the_title( $reward_id )
					);
				} elseif ( $reward->status < 6 ) {
					$reward_html = sprintf(
						'<div class="go_stats_item_wrapper"><a href="%s" %s>%s</a></div>',
						get_permalink( $reward_idF ),
						$new_tab,
						get_the_title( $reward_id )
					);
				} else {
					$reward_html = sprintf( '<div class="go_stats_item_wrapper">%s</div>', $reward->reason );
				}
				$reward_html .= "<div class='go_stats_amount'>({$reward_points})</div>";
			}
			printf( '<li class="go_stats_reward go_stats_reward_points">%s</li>', $reward_html );
		}
	}
	?>
	</ul>
	<ul id='go_stats_rewards_list_currency' class='go_stats_body_list'>
	<?php
	foreach ( $rewards as $reward ) {
		$reward_id = $reward->post_id;
		$reward_currency = $reward->currency;
		if ( $reward_currency != 0 ) {
			$reward_html = '';
			if ( ! empty( $reward->status ) ) {
				if ( $reward->status == -1 ) {
					$reward_html = sprintf(
						'<div class="go_stats_item_wrapper"><a href="#" onclick="go_lb_opener(%s)">%s</a></div>',
						$reward_id,
						get_the_title( $reward_id )
					);
				} elseif ( $reward->status < 6 ) {
					$reward_html = sprintf(
						'<div class="go_stats_item_wrapper"><a href="%s" %s>%s</a></div>',
						get_permalink( $reward_idF ),
						$new_tab,
						get_the_title( $reward_id )
					);
				} else {
					$reward_html = sprintf( '<div class="go_stats_item_wrapper">%s</div>', $reward->reason );
				}
				$reward_html .= "<div class='go_stats_amount'>({$reward_currency})</div>";
			}
			printf( '<li class="go_stats_reward go_stats_reward_currency">%s</li>', $reward_html );
		}
	}
	?>
	</ul>
	<ul id='go_stats_rewards_list_bonus_currency' class='go_stats_body_list'>
	<?php
		foreach ( $rewards as $reward ) {
			$reward_id = $reward->post_id;
			$reward_bonus_currency = $reward->bonus_currency;
			if ( $reward_bonus_currency != 0 && ! empty( $reward->status ) && $reward->status !== 6 ) {
				$reward_html = '';
				if ( $reward->status == -1 ) {
					$reward_html = sprintf(
						'<div class="go_stats_item_wrapper"><a href="#" onclick="go_lb_opener(%s)">%s</a></div>',
						$reward_id,
						get_the_title( $reward_id )
					);
				} elseif ( $reward->status < 6 ) {
					$reward_html = sprintf(
						'<div class="go_stats_item_wrapper"><a href="%s" %s>%s</a></div>',
						get_permalink( $reward_idF ),
						$new_tab,
						get_the_title( $reward_id )
					);
				} else {
					$reward_html = sprintf( '<div class="go_stats_item_wrapper">%s</div>', $reward->reason );
				}
				$reward_html .= "<div class='go_stats_amount'>({$reward_bonus_currency})</div>";
				printf( '<li class="go_stats_reward go_stats_reward_bonus_currency">%s</li>', $reward_html );
			}
		}
	?>
	</ul>
	<?php
	die();
}

function go_stats_minutes_list() {
	global $wpdb;
	$go_table_name = "{$wpdb->prefix}go";
	if ( ! empty( $_POST['user_id'] ) ) {
		$user_id = (int) $_POST['user_id'];
	} else {
		$user_id = get_current_user_id();
	}
	check_ajax_referer( 'go_stats_minutes_list_' );

	$minutes = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT * 
			FROM {$go_table_name} 
			WHERE uid = %d AND ( minutes != %d ) 
			ORDER BY id DESC",
			$user_id,
			0
		)
	);
	?>
	<ul id='go_stats_minutes_list' class='go_stats_body_list'>
		<?php 
			foreach ( $minutes as $minute ) {
				?>
					<li class='go_stats_minutes'>
						<span><?php echo ( ( $minute->status == -1 ) ? "<a href='#' onclick='go_lb_opener({$minute->post_id})'>".get_the_title( $minute->post_id )."</a>" : $minute->reason ).' '.$minute->timestamp; ?> </span>
						<div class='go_stats_amount'>(<?php echo $minute->minutes; ?>)</div>
					</li>
				<?php
			}
		?>
	</ul>
	<?php
	die();
}

function go_stats_penalties_list() {
	global $wpdb;
	$go_table_name = "{$wpdb->prefix}go";
	if ( ! empty( $_POST['user_id'] ) ) {
		$user_id = (int) $_POST['user_id'];
	} else {
		$user_id = get_current_user_id();
	}
	check_ajax_referer( 'go_stats_penalties_list_' );

	$penalties = $wpdb->get_results(
		$wpdb->prepare(
			"SELECT * 
			FROM {$go_table_name} 
			WHERE uid = %d AND ( penalty != %d ) 
			ORDER BY id DESC",
			$user_id,
			0
		)
	);
	?>
	<ul id='go_stats_penalties_list' class='go_stats_body_list'>
		<?php 
			foreach ( $penalties as $penalty ) {
				?>
					<li class='go_stats_penalties'>
						<div class='go_stats_item_wrapper'><span><?php echo $penalty->reason.' '.$penalty->timestamp; ?></span></div>
						<div class='go_stats_amount'>(<?php echo $penalty->penalty; ?>)</div>
					</li>
				<?php
			}
		?>
	</ul>
	<?php
	die();
}

function go_stats_badges_list() {
	global $wpdb;
	$go_table_name = "{$wpdb->prefix}go";
	if ( ! empty( $_POST['user_id'] ) ) {
		$user_id = (int) $_POST['user_id'];
	} else {
		$user_id = get_current_user_id();
	}
	check_ajax_referer( 'go_stats_badges_list_' );

	$badges_array = get_user_meta( $user_id, 'go_badges', true );
	if ( is_array( $badges_array ) && ! empty( $badges_array ) ) {
		go_badge_output_list( $badges_array );
	}
	die();
}

function go_stats_leaderboard_choices() {
	check_ajax_referer( 'go_stats_leaderboard_choices_' );

	?>
	<div id='go_stats_leaderboard_filters'>
		<div id='go_stats_leaderboard_filters_head'>FILTERS</div>
		<label for='go_stats_leaderboard_focuses'><b><?php echo get_option( 'go_class_a_name' ); ?></b></label>
		<div id='go_stats_leaderboard_classes'>
			<?php
			$classes = get_option( 'go_class_a' );
			$first = 1;
			if ( $classes) {
				foreach ( $classes as $class_a ) {
					?>
						<div class='go_stats_leaderboard_class_wrap'><input type='checkbox' class='go_stats_leaderboard_class_choice' value='<?php echo $class_a; ?>'><span><?php echo $class_a; ?></span></div>
					<?php
					$first++;
				}
			}
			?>
		</div>
		<label for='go_stats_leaderboard_focuses'><b><?php echo get_option( 'go_focus_name' ); ?></b></label>
		<div id='go_stats_leaderboard_focuses'>
			<?php
			$focuses = get_option( 'go_focus' );
			if ( $focuses ) {
				foreach ( $focuses as $focus ) {
					?>
						<div class='go_stats_leaderboard_focus_wrap'><input type='checkbox' class='go_stats_leaderboard_focus_choice' value='<?php echo $focus; ?>'><span><?php echo $focus; ?></span></div>
					<?php
				}
			}
			?>
		</div>
	</div>
	<div id='go_stats_leaderboard'></div>
	<?php
	die();
}

function go_return_user_data( $id, $counter, $sort ) {
	$points = go_return_points( $id );
	$currency = go_return_currency( $id );
	$bonus_currency = go_return_bonus_currency( $id );
	$badge_count = go_return_badge_count( $id );
	$user_data_key = get_userdata( $id );
	$user_display = "<a href='#' onclick='go_admin_bar_stats_page_button(&quot;{$id}&quot;);'>{$user_data_key->display_name}</a>";

	$amount = 0;
	switch ( $sort) {
		case 'points' :
			$amount = $points;
			break;
		case 'currency' :
			$amount = $currency;
			break;
		case 'bonus_currency' :
			$amount = $bonus_currency;
			break;
		case 'badges' :
			$amount = $badge_count;
			break;
		default:

			// returns without output, since there's nothing to display
			return;
	}
	if ( 0 !== $amount ) {
		printf(
			'<li><div class="go_stats_item_wrapper">%d %s</div><div class="go_stats_amount">%s</li>',
			$counter,
			$user_display,
			$amount
		);
	}
}

function go_return_user_leaderboard( $user_id_objs, $class_a_choice, $all_foci, $type, $counter ) {

	// stops if there are no users
	if ( empty( $user_id_objs ) || ! is_array( $user_id_objs ) ) {
		return;
	}

	foreach ( $user_id_objs as $obj ) {
		$user_id = (int) $obj->uid;
		if ( ! go_user_is_admin( $user_id ) ) {
			$class_a = get_user_meta( $user_id, 'go_classifications', true );
			$user_focus = get_user_meta( $user_id, 'go_focus', true );
			if ( ! empty( $class_a ) ) {
				$class_keys = array_keys( $class_a );
			}
			if ( ! empty( $class_a_choice ) && is_array( $class_a_choice ) &&
					! empty( $all_foci ) && is_array( $all_foci ) ) {

				if ( ! empty( $class_keys ) && ! empty( $user_focus ) ) {
					$class_intersect = array_intersect( $class_keys, $class_a_choice );
					if ( is_array( $user_focus ) ) {
						$user_focus_intersect = array_intersect( $user_focus, $all_foci );
					} else {
						$user_focus_intersect = in_array( $user_focus, $all_foci );
					}
					if ( ! empty( $class_intersect ) && ! empty( $user_focus_intersect ) ) {
						go_return_user_data( $user_id, $counter, $type );
						$counter++;
					}
				}
			} elseif ( ! empty( $class_a_choice ) && is_array( $class_a_choice ) ) {
				if ( ! empty( $class_keys ) ) {
					$class_intersect = array_intersect( $class_keys, $class_a_choice );
					if ( ! empty( $class_intersect ) ) {
						go_return_user_data( $user_id, $counter, $type );
						$counter++;
					}
				}
			} elseif ( ! empty( $all_foci ) && is_array( $all_foci ) ) {
				if ( ! empty( $user_focus ) ) {
					if ( is_array( $user_focus ) ) {
						$user_focus_intersect = array_intersect( $user_focus, $all_foci );
					} else {
						$user_focus_intersect = in_array( $user_focus, $all_foci );
					}
					if ( ! empty( $user_focus_intersect ) ) {
						go_return_user_data( $user_id, $counter, $type );
						$counter++;
					}
				}
			}
		}
	}
}

function go_stats_leaderboard() {
	global $wpdb;
	check_ajax_referer( 'go_stats_leaderboard_' );

	// prepares tab titles
	$xp_name = strtoupper( go_return_options( 'go_points_name' ) );
	$gold_name = strtoupper( go_return_options( 'go_currency_name' ) );
	$honor_name = strtoupper( go_return_options( 'go_bonus_currency_name' ) );
	$badge_name = strtoupper( go_return_options( 'go_badges_name' ) );

	$go_totals_table_name = "{$wpdb->prefix}go_totals";
	$class_a_choice = ( ! empty( $_POST['class_a_choice'] ) ? (array) $_POST['class_a_choice'] : array() );
	$focuses = ( ! empty( $_POST['focuses'] ) ? (array) $_POST['focuses'] : array() );
	$date = 'all';
	if ( ! empty( $_POST['date'] ) ) {
		if ( 'all' !== $_POST['date'] ) {
			$date = (int) $_POST['date'];
		}
	}
?>
<ul id='go_stats_leaderboard_list_points' class='go_stats_body_list go_stats_leaderboard_list'>
	<li class='go_stats_body_list_head'><?php echo $xp_name; ?></li>
	<?php 
	$counter = 1;
	$users_points = $wpdb->get_results( "SELECT uid FROM {$go_totals_table_name} ORDER BY CAST( points as signed ) DESC" );
	go_return_user_leaderboard( $users_points, $class_a_choice, $focuses, 'points', $counter )
	?>
</ul><ul id='go_stats_leaderboard_list_currency' class='go_stats_body_list go_stats_leaderboard_list'>
	<li class='go_stats_body_list_head'><?php echo $gold_name; ?></li>
	<?php
	$counter = 1;
	$users_currency = $wpdb->get_results( "SELECT uid FROM {$go_totals_table_name} ORDER BY CAST( currency as signed ) DESC" );
	go_return_user_leaderboard( $users_currency, $class_a_choice, $focuses, 'currency', $counter )
	?>
</ul><ul id='go_stats_leaderboard_list_bonus_currency' class='go_stats_body_list go_stats_leaderboard_list'>
	<li class='go_stats_body_list_head'><?php echo $honor_name; ?></li>
	<?php 
	$counter = 1;
	$users_bonus_currency = $wpdb->get_results( "SELECT uid FROM {$go_totals_table_name} ORDER BY CAST( bonus_currency as signed ) DESC" );
	go_return_user_leaderboard( $users_bonus_currency, $class_a_choice, $focuses, 'bonus_currency', $counter )
	?>
</ul><ul id='go_stats_leaderboard_list_badge_count' class='go_stats_body_list go_stats_leaderboard_list'>
	<li class='go_stats_body_list_head'><?php echo $badge_name; ?></li>
	<?php
	$counter = 1;
	$users_badge_count = $wpdb->get_results( "SELECT uid FROM {$go_totals_table_name} ORDER BY CAST( badge_count as signed ) DESC" );
	go_return_user_leaderboard( $users_badge_count, $class_a_choice, $focuses, 'badges', $counter )
	?>
</ul>
<?php
	die();
}

?>