function updateEvent($push)
{
$bdd = new PDO(DSN, DBUSER, DBPASS);
require MODELES . 'functions/adresse.php';
require MODELES . 'functions/insertMedia.php';
require MODELES . 'functions/updateMedia.php';
require MODELES . 'functions/removeMedia.php';
$id_type = $push["id_type"];
$adresse_id = insertAddress($push['adresse']);
$media_id = NULL;
if (!empty($push['id_media_principal'])) {
if (!empty($push['lien_photo'])) {
if ($push['lien_photo'] == -1) {
unlink(PHOTO_EVENT . $push['old_lien_photo']);
removeMedia($push['id_media_principal']);
$media_id = NULL;
} else {
updateMedia($push['lien_photo'], $push['id_media_principal']);
$media_id = $push['id_media_principal'];
}
}
} else {
if (!empty($push['lien_photo'])) {
$media_id = insertMedia($push['lien_photo']);
}
}
// insérer dans organise ou organise = coming soon
foreach ($push as $key => $value) {
if ($value == '') {
$push[$key] = NULL;
}
}
$updateQuery = $bdd->prepare('UPDATE
evenement SET
titre = :titre,
debut = :debut,
fin = :fin,
age_min = :age_min,
age_max = :age_max,
visibilite = :visibilite,
invitation = :invitation,
tarif = :tarif,
description = :description,
site = :site,
langue = :langue,
id_type = :id_type,
id_adresse = :id_adresse,
id_media_principal = :id_media_principal,
sponsor = :sponsor,
organisateur = :organisateur,
organisateur_contact = :organisateur_contact,
max_participants = :max_participants
WHERE id = :id;');
if ($updateQuery->execute([':titre' => $push['titre'], ':debut' => $push['date_debut'] . ' ' . $push['beginning'], ':fin' => $push['date_fin'] . ' ' . $push['end'], ':age_min' => $push['age_min'], ':age_max' => $push['age_max'], ':visibilite' => $push['visibilite'], ':invitation' => $push['invitation'], ':tarif' => $push['price'], ':description' => $push['description'], ':site' => $push['website'], ':langue' => $push['langue'], ':id_type' => $id_type, ':id_adresse' => $adresse_id, ':id_media_principal' => $media_id, ':sponsor' => $push['sponsors'], ':max_participants' => $push['max_attendees'], ':organisateur' => $push['hosts'], ':organisateur_contact' => $push['hosts_contact'], ':id' => $push['id']])) {
return True;
} else {
var_dump($updateQuery->errorInfo());
return False;
}
}
function insertEvent($push)
{
$bdd = new PDO(DSN, DBUSER, DBPASS);
require MODELES . 'functions/adresse.php';
require MODELES . 'functions/insertMedia.php';
$id_type = $push["id_type"];
$adresse_id = insertAddress($push['adresse']);
if (!empty($push['lien_photo'])) {
$media_id = insertMedia($push['lien_photo']);
} else {
$media_id = NULL;
}
// insérer dans organise ou organise = coming soon
$insertQuery = $bdd->prepare('INSERT INTO
evenement (titre, debut, fin, age_min, age_max, visibilite, invitation, tarif, description, site, langue, id_type, id_adresse, id_createur, id_media_principal, sponsor, organisateur, organisateur_contact, max_participants)
VALUES (:titre, :debut, :fin, :age_min, :age_max, :visibilite, :invitation, :tarif, :description, :site, :langue, :id_type, :id_adresse, :id_createur, :id_media_principal, :sponsor, :organisateur, :organisateur_contact, :max_participants)');
if ($insertQuery->execute([':titre' => $push['titre'], ':debut' => $push['debut'], ':fin' => $push['fin'], ':age_min' => $push['age_min'], ':age_max' => $push['age_max'], ':visibilite' => $push['visibilite'], ':invitation' => $push['invitation'], ':tarif' => $push['price'], ':description' => $push['description'], ':site' => $push['website'], ':langue' => $push['langue'], ':id_type' => $id_type, ':id_adresse' => $adresse_id, ':id_media_principal' => $media_id, ':sponsor' => $push['sponsors'], ':max_participants' => $push['max_attendees'], ':organisateur' => $push['hosts'], ':organisateur_contact' => $push['hosts_contact'], ':id_createur' => $push['id_createur']])) {
$eventId = $bdd->lastInsertId();
return $eventId;
} else {
var_dump($insertQuery->errorInfo());
return False;
}
}
// logText("Artwork: ". $artwork);
// }
//timeExecution("Parse info");
if (isset($title) && isset($artist)) {
if (!$lastRecord || $lastRecord->title != $title) {
insertRecord($fileName, $title, $album, $artist);
//timeExecution("Insert record");
//iTunes API request
$term = urlencode($artist . (isset($album) ? " " . $album : "") . " " . $title);
// //echo $term;
$iTunesJSON = file_get_contents('http://itunes.apple.com/search?term=' . $term . '&media=music&entity=song&limit=1');
$iTunesData = json_decode($iTunesJSON, true);
if ($iTunesData["resultCount"] > 0) {
$iTunesMetadata = $iTunesData["results"][0];
//timeExecution("Pull iTunes data");
insertMedia($iTunesMetadata);
//timeExecution("Add media");
} else {
logText("No itunes info");
}
//$content = "<div style='background-image: url({$artwork});'><h1>{$artist} - {$title}</h1></div>";
// $contentFile = fopen("content.php", "w");
// fwrite($contentFile, $content);
// fclose($contentFile);
} elseif ($lastRecord) {
//UPDATE filename in DB
updateRecord($lastRecord->id, $fileName);
//timeExecution("Update record");
logText("Song duplicate");
}
} else {
unset($contents['images'][$key]);
$contents['img_number']--;
}
}
}
if (!empty($_FILES["photos"]["name"][0]) && $contents['img_number'] < 4) {
// Boucle sur $_FILES pour passer sur tous les fichiers
$photoLeft = 4 - $contents['img_number'];
foreach ($_FILES['photos']['name'] as $f => $name) {
if ($photoLeft <= 0) {
break;
}
$check = checkOnePhotos("photos", $f, $maxsize, $max_height, $max_width, $validExtensions, NULL, PHOTO_EVENT);
if ($check[0]) {
if (uploadOnePhotos("photos", $f, NULL, PHOTO_EVENT, $check[1])) {
$media_id = insertMedia($check[1]);
if (insertEventMedia($_GET['id'], $media_id)) {
$contents['images'][$f] = [$media_id, $check[1]];
$contents['img_number']++;
// Nombre d'images uploadés avec succès.
$photoLeft--;
//Nombre de photos restantes.
}
}
} else {
$contents['errorMessage'] .= '(' . $name . ')' . $check[1];
}
}
}
if (empty($contents['errorMessage']) && (!empty($_POST) or !empty($_FILES))) {
alert("ok", "Les images on bien été modifiées");
