Warning: Cannot modify header information - headers already sent by (output started at /var/www/jonas-eriksen.dk/pic/private/index.php:1) in /var/www/jonas-eriksen.dk/pic/private/index.php on line 215
index.php000064400000005634152334777630006415 0ustar00passwordResetCheck(); include('../static/header.php'); if (!isset($_GET['year'])) { $getYear = date("Y"); } else { $getYear = $_GET['year']; } $result = $event->getAll($getYear); ?>
Træningsresultater i $getYear"; foreach ($event->getYears() as $year) { ?> admin_level(0)) { ?> admin_level(0)) { ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; if ($admin->admin_level(0)) { echo ""; } echo ""; } ?>
Skyttenavn Point Krydstier Våbentype
Skyttenavn Point Krydstier Våbentype
$row[9]$row[0]$row[1]$row[2]$row[3]Edit
db = $DB_con; } public function newEvent($year, $shooterId, $point, $crossTen, $typeId) { try { $stmt = $this->db->prepare("INSERT INTO result_event (year, shooterId, point, `cross`, type, date) VALUES (:year, :userId, :point, :crossTen, :typeId, :date)"); $stmt->execute(array(":year" => $year, ":userId" => $shooterId, ":point" => $point, ":crossTen" => $crossTen, ":typeId" => $typeId, ":date" => date("Y/m/d"))); return $stmt; } catch (PDOException $e) { echo $e->getMessage(); } } public function getAll($eventYear) { try { $stmt = $this->db->prepare("SELECT result_users.fullname, result_event.point, result_event.`cross`, result_weapon.name, result_event.shooterId, result_users.id, result_weapon.id, result_event.`type`, result_event.year, result_event.id FROM result_event JOIN result_users on result_event.shooterId = result_users.id JOIN result_weapon on result_event.type = result_weapon.id WHERE result_event.year = :eventYear AND result_users.isDeleted != 1 ORDER BY result_event.id"); $stmt->execute(array(":eventYear" => $eventYear)); $result = $stmt->fetchAll(); return $result; } catch (PDOException $e) { echo $e->getMessage(); } } public function getAllForUser($eventYear, $userId) { try { $stmt = $this->db->prepare("SELECT result_event.id, result_event.point, result_event.`cross`, result_weapon.name, result_event.shooterId, result_users.id, result_weapon.id, result_event.`type`, result_event.year, result_event.date FROM result_event JOIN result_users on result_event.shooterId = result_users.id JOIN result_weapon on result_event.type = result_weapon.id WHERE result_event.year = :eventYear AND result_users.id = :userId ORDER BY result_event.id"); $stmt->execute(array(":eventYear" => $eventYear, ":userId" => $userId)); $result = $stmt->fetchAll(); return $result; } catch (PDOException $e) { echo $e->getMessage(); } } public function getAllForUserForPrint($userId) { try { $stmt = $this->db->prepare("SELECT result_event.id, result_event.point, result_event.`cross`, result_weapon.name, result_event.shooterId, result_users.id, result_weapon.id, result_event.`type`, result_event.year, result_event.date FROM result_event JOIN result_users on result_event.shooterId = result_users.id JOIN result_weapon on result_event.type = result_weapon.id WHERE result_users.id = :userId ORDER BY result_event.year, result_event.id"); $stmt->execute(array( ":userId" => $userId)); $result = $stmt->fetchAll(); return $result; } catch (PDOException $e) { echo $e->getMessage(); } } public function getYearCount($eventYear) { try { $stmt = $this->db->prepare("SELECT id FROM result_event WHERE result_event.year = :eventYear"); $stmt->execute(array(":eventYear" => $eventYear)); echo $stmt->rowCount(); } catch (PDOException $e) { echo $e->getMessage(); } } public function getYearCountForUser($eventYear, $userId) { try { $stmt = $this->db->prepare("SELECT id FROM result_event WHERE result_event.year = :eventYear AND shooterId = :userId"); $stmt->execute(array(":eventYear" => $eventYear, ":userId" => $userId)); echo $stmt->rowCount(); } catch (PDOException $e) { echo $e->getMessage(); } } public function getYears() { try { $stmt = $this->db->prepare("SELECT year FROM result_event GROUP BY year ORDER BY year DESC LIMIT 10"); $stmt->execute(); $result = $stmt->fetchAll(); return $result; } catch (PDOException $e) { echo $e->getMessage(); } } public function getYearsForUser($userId) { try { $stmt = $this->db->prepare("SELECT year FROM result_event WHERE shooterId = :shooterId GROUP BY year ORDER BY year DESC LIMIT 10"); $stmt->execute(array(":shooterId" => $userId)); $result = $stmt->fetchAll(); return $result; } catch (PDOException $e) { echo $e->getMessage(); } } public function getEvent($eventId) { try { $stmt = $this->db->prepare("SELECT point, `cross`, date, user2.shooterId, fullname, user2.id, rw.name, rw.id FROM result_event JOIN result_users user2 on result_event.shooterId = user2.id JOIN result_weapon rw on result_event.type = rw.id WHERE result_event.id = :eventId"); $stmt->execute(array(":eventId" => $eventId)); $event = $stmt->fetch(); return $event; } catch (PDOException $e) { echo $e->getMessage(); } } public function updateEvent($eventId, $point, $cross) { try { $stmt = $this->db->prepare("UPDATE result_event SET point = :point, `cross` = :cross WHERE id = :id"); $stmt->execute(array(":point" => $point, ":cross" => $cross, ":id" => $eventId)); return true; } catch (PDOException $e) { echo $e->getMessage(); } } public function deleteEvent($eventId) { try { $stmt = $this->db->prepare("DELETE FROM `result_event` WHERE `id` = :id"); $stmt->execute(array(":id" => $eventId)); return true; } catch (PDOException $e) { echo $e->getMessage(); } } public function getEventDates() { try { $stmt = $this->db->prepare("SELECT `result_event`.`date` FROM `result_event` GROUP BY `result_event`.`date` ORDER BY `result_event`.`date`; "); $stmt->execute(); $result = $stmt->fetchAll(); return $result; } catch (PDOException $e) { echo $e->getMessage(); } } }edit.php000064400000005635152334777630006234 0ustar00passwordResetCheck(); $log = new log($db); if (!$admin->admin_level(0)) { $admin->redirect('../static/401.php'); } $e = $event->getEvent($_GET['event']); if (isset($_POST['saveEvent'])) { $event->updateEvent($_GET['event'], $_POST['point'], $_POST['cross']); $log->addLog($_SESSION['userId'], "Event opdateret", "Event", "/event/edit.php?event=" . $_GET['event']); $admin->redirect('/user/profile.php?user=' . $e[5]); } if (isset($_POST['deleteEvent'])) { if($event->deleteEvent($_GET['event'])) { $log->addLog($_SESSION['userId'], "Event deleted", "Event", "/event/edit.php?event=" . $_GET['event']); $admin->redirect('/user/profile.php?user=' . $e[5]); } } $weaponStmt = $db->prepare("SELECT id, name FROM result_weapon WHERE id != " . $e[7] . " ORDER BY CASE WHEN name LIKE 'Riffel%' THEN 1 ELSE 2 END, name"); $weaponStmt->execute(); include('../static/header.php'); if (isset($_GET['event'])) { ?>

Skud af

Point
Cross
Date format('d-m-Y') . '" required pattern="\d{2}-\d{2}-\d{4}">'; ?>
Våben
Skyttenummer
Skytte
Intet event er valgt'; } include('../static/footer.php'); ?>