setStatus($pk, 3);
continue;
}
if ($row["dt1"] == "") {
setStatus($pk, 4);
continue;
}
$people = explode("|", $row["people"]);
echo "Ready to Load<br>";
foreach ($people as $p) {
if ($p == "") {
continue;
}
echo "Person: {$p} <br>";
$person_pk = "";
$person_pk = getPerson($p);
echo "--- pk: {$person_pk} <br>";
if ($person_pk == "") {
setStatus($pk, 5);
continue;
}
$q3 = sprintf("INSERT INTO appearances (show_fk,person_fk,appear_dt) VALUES (%d,%d,'%s')", $row["show_pk"], $person_pk, $row["dt1"]);
$result3 = $conn->query($q3);
$appear_pk = "";
$appear_pk = $conn->insert_id;
if ($appear_pk == "") {
setStatus($pk, 6);
continue;
}
$q3 = sprintf("INSERT INTO media (appear_fk,media_type,media_code,media_url,media_title,media_desc) VALUES (%d,%d,'%s','%s','%s','%s')", $appear_pk, $row["media_type"], $row["media_code"], $row["media_url"], $row["media_title"], $row["media_desc"]);
$result3 = $conn->query($q3);
<?php
include 'header.php';
$sandra = getPerson('13');
$maria = getPerson('12');
include 'server/adminprofil.php';
//För att få mail-adressen som formuläret postar till.
?>
<div id="main">
<div id="headerimg"><img src="img/head/6_h.png"></div>
<h1>kontakt</h1>
<div class="kontakt2col">
<br>
<h3>adress</h3>
<p>Vera Sandbergsallé 8</br>412 96 Göteborg</p>
<br><br>
<h3>sandra melin</h3>
<p><?php
print $sandra['tel'];
?>
</br>sandra@waterweave.se</p>
<br><br>
<h3>maria knutsson</h3>
<p><?php
print $maria['tel'];
?>
<?php
include 'include/header.php';
?>
</head>
<body>
<?php
include_once "include/analyticstracking.php";
?>
<div class="container">
<!-- ナビゲーションバー -->
<?php
include 'include/navbar.php';
?>
<?php
getPerson();
?>
<?php
if (countPodium('World') != 0 or countPodium('Euro') != 0 or countPodium('Asian') != 0 or countPodium('Japan') != 0 or countHistoryR('WR') != 0 or countHistoryR('CR') != 0 or countHistoryR('NR') != 0) {
?>
<div class="panel-group" id="accordion3">
<!-- 世界大会入賞 -->
<?php
if (countPodium('World')) {
?>
<div class="panel panel-default">
<a class="list-group-item" data-toggle="collapse" data-parent="#accordion3" href="#collapse31">
<?php
echo $wpodium[$lang];
?>
function editAccount($uid)
{
$user = getPerson($uid);
$picture = $_FILES['picture'];
if ($_POST['email'] == "") {
return "Email may not be empty";
}
if ($_POST['fullname'] == "") {
return "Full name may not be empty";
}
if ($picture['name'] != '') {
$pic = pictureHandling($uid, $picture);
} else {
$pic = getPic($uid);
}
$purifier = new HTMLPurifier();
$fullname = $purifier->purify($_POST['fullname']);
$pic = $purifier->purify($pic);
$email_level = $purifier->purify($_POST['email_pref']);
mysql_query('START TRANSACTION');
$failed = 0;
$sql = sprintf("UPDATE user_info SET fullname='%s', picture='%s', email_level='%s' WHERE uid='%s'", mysql_real_escape_string($fullname), mysql_real_escape_string($pic), mysql_real_escape_string($email_level), mysql_real_escape_string($uid));
$result = mysql_query($sql);
if ($result == FALSE) {
$failed = 1;
}
$sql = sprintf("DELETE from user_info_values WHERE person_id = '%s'", mysql_real_escape_string($uid));
$result = mysql_query($sql);
if ($result == FALSE) {
$failed = 1;
}
$sql = sprintf("SELECT id, shortname, longname FROM user_info_key");
$result = get_rows($sql);
if (!$result) {
$failed = 1;
}
foreach ($result as $r) {
$shortname = $r['shortname'];
$longname = $r['longname'];
$user_key_id = $r['id'];
$value = $_POST[$shortname];
$value = $purifier->purify($value);
if ($_POST[$shortname] != "") {
$sql = sprintf("INSERT INTO user_info_values VALUES ('%s', '%s', '%s')", mysql_real_escape_string($uid), mysql_real_escape_string($user_key_id), mysql_real_escape_string($value));
$res = mysql_query($sql);
if ($res == FALSE) {
$failed = 1;
}
}
}
if ($failed == 1) {
mysql_query('ROLLBACK');
return "Registration Failed";
} else {
mysql_query('COMMIT');
return TRUE;
}
}
$pk = $row["load_pk"];
echo "<hr>Row {$pk}<br>";
if ($row["show_pk"] == "") {
setStatus($pk, 2);
continue;
}
if ($row["people"] == "") {
setStatus($pk, 3);
continue;
}
if ($row["dt"] == "") {
setStatus($pk, 4);
continue;
}
echo "finding person: " . $row["person"] . "<br>";
$person_pk = getPerson($row["person"]);
echo "pk returned: {$person_pk}<Br>";
if ($person_pk == "") {
setStatus($pk, 5);
continue;
}
echo "showpk: " . $row["show_pk"] . "<br>";
try {
$q3 = sprintf("INSERT INTO appearances (show_fk,person_fk,appear_dt) VALUES (%d,%d,STR_TO_DATE('%s','%%m/%%d/%%Y'))", $row["show_pk"], $person_pk, $row["dt"]);
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
echo "query3: {$q3} <br>";
$result3 = $conn->query($q3);
$appear_pk = "";
$appear_pk = $conn->insert_id;
$sql = "INSERT INTO person_date(person_id, attribute_key, value) VALUES(?,'birthdate',?)";
$db->insert($sql, array($personId, $_POST['birthdate']));
}
$response['person'] = getPerson($db, $personId);
} else {
//Update person
$response['action'] = "update";
$response['person_id'] = $personId;
$sql = "UPDATE persons SET first_name=?, last_name=? WHERE person_id=?";
$rows = $db->update($sql, array($_POST['firstName'], $_POST['lastName'], $_POST['personId']));
//Insert or update birthday
$sql = "SELECT person_date_id FROM person_date WHERE person_id=? AND attribute_key='birthdate'";
$personDateId = $db->getValue($sql, array($personId));
if (empty($personDateId)) {
$sql = "INSERT INTO person_date (person_id, attribute_key, value) VALUES(?,'birthdate',?)";
$db->insert($sql, array($personId, $_POST['birthdate']));
} else {
$sql = "UPDATE person_date SET value=? WHERE person_date_id=?";
$db->update($sql, array($_POST['birthdate'], $personDateId));
}
$response['person'] = getPerson($db, $personId);
}
function getPerson(&$db, $personId)
{
$sql = "SELECT persons.person_id, first_name AS firstName, last_name AS lastName, birth.value AS birthdate FROM persons LEFT JOIN person_date AS birth ON birth.person_id=persons.person_id AND attribute_key='birthdate' WHERE persons.person_id=?";
return $db->getRow($sql, array($personId));
}
header('Access-Control-Allow-Origin: *');
header('Content-Type: application/json');
$response['timer'] = microtime(true) - $timerStart;
echo json_encode($response, JSON_NUMERIC_CHECK);
<?php
require_once "include/header.php";
if (isLoggedIn()) {
if ($uid = getPersonUID()) {
$person = getPerson($uid)[0];
if (sizeof($person) > 0) {
echo "<br />";
echo $person["uid"][0];
echo "<br />";
echo $person["cn"][0];
echo "<br />";
echo $person["mail"][0];
echo "<br />";
echo $person["telephonenumber"][0];
echo "<br />";
foreach ($person["memberof"] as $group) {
if (!strpos($group, "email") && !strpos($group, "first semester")) {
echo $group;
echo "<br />";
}
}
}
}
}
require_once "include/footer.php";
}
# Main
# ----
$resource = getResource();
$request_method = getMethod();
$parameters = getParameters();
# Redirect to appropriate handlers.
if ($resource[0] == "staffapi") {
if ($request_method == "POST" && $resource[1] == "person") {
postPerson($parameters);
} else {
if ($request_method == "GET" && $resource[1] == "persons") {
getPersons();
} else {
if ($request_method == "GET" && $resource[1] == "person") {
getPerson($resource[2]);
} else {
if ($request_method == "DELETE" && $resource[1] == "person") {
deletePerson($resource[2]);
} else {
http_response_code(405);
# Method not allowed
}
}
}
}
} else {
http_response_code(405);
# Method not allowed
}
?>
echo '<div class="errormsg">Incorrect Old Password</div>';
} else {
if ($passwd == 'invalid') {
echo '<div class="errormsg">Invalid New Password</div>';
} else {
if ($passwd == 'short') {
echo '<div class="errormsg">Password Must Be At Least 6 Characters</div>';
} else {
if ($passwd == 'error') {
echo '<div class="errormsg">An Error Occurred While Changing Password</div>';
}
}
}
}
}
printPerson(getPerson($uid));
?>
<p class="pad-bottom"><a href="<?php
echo URL;
?>
/edit-account.php">Edit your information</a></p>
<script type="text/javascript">
//<