function db_getUserEmail($id, $username)
{
$ret = db_getUserDataRaw($id, $username);
if (empty($ret)) {
return FALSE;
}
return $ret['email'];
}
<?php
$active = "profile";
$color = "magenta";
include_once 'includes/config.php';
//session_start();
if (!isset($_SESSION["is_auth"])) {
header('location: login.php?msg=1');
exit;
}
$userId = $_SESSION['userId'];
$timeWindowName = $_SESSION['timeWindowName'];
$ret = db_getUserDataRaw($userId, null, null, null);
$userLastName = $ret['vez_nev'];
$userFirstName = $ret['ker_nev'];
$userElonev = $ret['elonev'];
$userEmail = $ret['email'];
$telefon = $ret['telefon'];
$comp = db_getCompanyDataForUser($userId, null, null, null);
$vallNev = $comp['nev'];
$thely = $comp['thely'];
$varos = $ret['lakhely_varos'];
$varosresz = $ret['lakhely_varosresz'];
$userCard = $ret['kartyaId'];
$userName = $ret['felh_nev'];
$msgColor = "darkred";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
if (isset($_POST['user-submit'])) {
if (!empty($_POST['e-mail']) && !empty($_POST['lakhely_varos']) && !empty($_POST['user_n']) && !empty($_POST['passw'])) {
$userEmail_uj = test_input($_POST['e-mail']);
$varos_uj = test_input($_POST['lakhely_varos']);
/**
* Returns a percentage of user's status in the current lecke.
* @param $userId
* @param $timeWindowName
* @return int (percentage) on success or FALSE on failure.
*/
function db_getStatusInLecke($userId = -1, $timeWindowName = "-1")
{
$ret = db_getUserDataRaw($userId, null, null, null);
if (empty($ret)) {
return FALSE;
} else {
$userName = $ret['felh_nev'];
}
$tid = db_getTimeWindowIdFromName($timeWindowName);
global $conn;
$stmt = $conn->prepare("SELECT SUM(suly)\n FROM aktivitas\n WHERE idoablakId = :twid");
$stmt->bindParam(':twid', $tid);
$stmt->execute();
$egesz = $stmt->fetchColumn();
$stmt = $conn->prepare("SELECT SUM(suly)\n FROM aktivitas, aktivitas_ertekek\n WHERE aktivitas.id = aktivitas_ertekek.aktivitasId AND felhNev = :usern AND idoablakId = :twid");
$stmt->bindParam(':usern', $userName);
$stmt->bindParam(':twid', $tid);
$stmt->execute();
$resz = $stmt->fetchColumn();
return round($resz * (100 / $egesz));
}
/**
* Returns the three column data for the corresponding lecke (test type: lecke start test).
* @param $userId
* @param $numberOfLecke
* @return array 1D associative array containing the graph dara, or FALSE if the user cannot be found.
*/
function db_getGraphDataForLeckeStartTest($userId = -1, $numberOfLecke = -1)
{
$graphData = array();
$leckeName = "lecke" . $numberOfLecke . "kezdo";
$ret = db_getUserDataRaw($userId, null, null, null);
if (empty($ret)) {
return FALSE;
} else {
$userName = $ret['felh_nev'];
}
/* first column for the graph */
global $conn;
$stmt = $conn->prepare("SELECT szazalek\n FROM kitolt\n WHERE felhNev = :uname AND tesztId = (SELECT id\n FROM teszt\n WHERE nev = :lname)");
$stmt->bindParam(':uname', $userName);
$stmt->bindParam(':lname', $leckeName);
$stmt->execute();
$row_count = $stmt->rowCount();
if ($row_count == 0) {
array_push($graphData, 0);
} else {
array_push($graphData, round($stmt->fetchColumn() * 100));
}
/* second column for the graph */
array_push($graphData, round(0.25 * 100));
/* third column for the graph */
$ret = db_getUserDataRaw($userId, null, null, null);
$cardId = $ret['kartyaId'];
$stmt = $conn->prepare("SELECT cegId\n FROM kartya\n WHERE kartya_id = :kartya");
$stmt->bindParam(':kartya', $cardId);
$stmt->execute();
$companyId = $stmt->fetchColumn();
$stmt = $conn->prepare("SELECT AVG(szazalek)\n FROM kitolt\n WHERE felhNev IN (SELECT felh_nev\n FROM felhasznalo\n WHERE kartyaId IN (SELECT kartya_id\n FROM kartya\n WHERE cegId = :compId)) AND tesztId = (SELECT id\n FROM teszt\n WHERE nev = :lname)");
$stmt->bindParam(':compId', $companyId);
$stmt->bindParam(':lname', $leckeName);
$stmt->execute();
if ($row_count == 0) {
array_push($graphData, 0);
} else {
array_push($graphData, round($stmt->fetchColumn() * 100));
}
return $graphData;
}
/**
* Adds a new record in table lzaro_kitolt into the database.
* @param $userId
* @param $timeWindowName
* @param $testName
* @param $time
* @return integer containing the last inserted id, or FALSE on failure.
*/
function db_addNewRecordInTableLzaro_kitolt($userId, $timeWindowName, $testName, $time)
{
$ret = db_getUserDataRaw($userId, null, null, null);
if (empty($ret)) {
return FALSE;
} else {
$userName = $ret['felh_nev'];
}
$tid = db_getTimeWindowIdFromName($timeWindowName);
$ret = db_getTestId($testName);
if (empty($ret)) {
return FALSE;
} else {
$testId = $ret;
}
global $conn;
$stmt = $conn->prepare("INSERT INTO lzaro_kitolt\n VALUES (NULL, :uname, :tid, :testId, :secs, NOW())");
$stmt->bindParam(':uname', $userName);
$stmt->bindParam(':tid', $tid);
$stmt->bindParam(':testId', $testId);
$stmt->bindParam(':secs', $time);
$stmt->execute();
return $conn->lastInsertId();
}
