$lv = getStat('lv', $pid);
$cvDN = getDeckInfo(getSkill('cvset', $pid), 'display_name');
$currentHP = getStat('curhp', $pid);
$maximumHP = getStat('maxhp', $pid);
$setHP = getStat('sethp', $pid);
$ttldks = getStat('ttldks', $pid);
$ttlpvstyl = getStat('ttlpvstyl', $pid);
$sumcfc = getStat('sumcfc', $pid);
$sumckanjiRE = getStat('sumckanjiRE', $pid);
$sumckanjiE = getStat('sumckanjiE', $pid);
$sumckanjiH = getStat('sumckanjiH', $pid);
$sumcaudioR = getStat('sumcaudioR', $pid);
$vocabulary = round(getScore('vocabulary', $pid), 2);
$listening = round(getScore('listening', $pid), 2);
$kanji = round(getScore('kanji', $pid), 2);
$ttldks = countUserDecks($pid);
$pDecks = getUserDecks($pid);
$pDecksSrtAscArr = sortDeckArrDN($pDecks);
//careful with this. vertNav.php uses $uDecksSrtAscArr
include "pdc.php";
try {
$stmt = $db->query("SELECT uo.*,\n\t\t\t\t\t\t\t(\n\t\t\t\t\t\t\tSELECT COUNT(*)\n\t\t\t\t\t\t\tFROM user_stats ui\n\t\t\t\t\t\t\tWHERE (ui.value) >= (uo.value)\n\t\t\t\t\t\t\tAND ui.stat_id=14\n\t\t\t\t\t\t\t) AS rank\n\t\t\t\t\t\tFROM user_stats uo\n\t\t\t\t\t\tWHERE user_id={$pid}\n\t\t\t\t\t\tAND stat_id=14");
$urank = $stmt->fetchALL(PDO::FETCH_ASSOC);
} catch (PDOException $ex) {
echo "Couldn't get rank <br />";
}
$ranktfca = $urank[0]['value'] != 0 ? $urank[0]['rank'] : 'N/A';
require_once 'stats.php';
?>
<!DOCTYPE html>
<html lang="en">
}
require_once 'words.php';
require_once 'stats.php';
require_once 'config.php';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die('Error connecting to mysql');
mysql_select_db($dbname);
mysql_query("SET NAMES UTF8");
$userID = getUserID($_SESSION['username']);
$fcrank = getUserFCardRank($userID);
$ttldks = getStat('ttldks', $userID);
$ttlpvstyl = getStat('ttlpvstyl', $userID);
$fcrankFA = $fcrank > 50 ? '<i class="fa fa-frown-o text-danger"></i>' : ($fcrank > 25 ? '<i class="fa fa-meh-o"></i>' : ($fcrank <= 25 ? '<i class="fa fa-smile-o text-success"></i>' : ''));
$dksFA = $ttldks < 3 ? '<i class="fa fa-frown-o text-danger"></i>' : ($ttldks >= 3 && $ttldks < 7 ? '<i class="fa fa-meh-o"></i>' : ($ttldks >= 7 ? '<i class="fa fa-smile-o text-success"></i>' : ''));
$vstylFA = $ttlpvstyl < 3 ? '<i class="fa fa-frown-o text-danger"></i>' : ($ttlpvstyl >= 3 && $ttlpvstyl < 7 ? '<i class="fa fa-meh-o"></i>' : ($ttlpvstyl >= 7 ? '<i class="fa fa-smile-o text-success"></i>' : ''));
if ($ttldks == 0) {
$ttldks = countUserDecks($userID);
setStat('ttldks', $userID, $ttldks);
}
//make sure db is correc
if ($ttlpvstyl == 0) {
$ttlpvstyl = countUserVStyle($userID);
setStat('ttlpvstyl', $userID, $ttlpvstyl);
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0"><!-- Super important! Tells googlebot that this site is responsive!-->
