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; } }
$requestJSON = $_POST['requestJSON']; } //Triage the request based on ACTION switch ($action) { // Function to either create a user or create a session if exists case 'createSession': createSession($swid, $email, $login, $fName, $lName, $device); break; case 'createMedia': createMedia($contentItemName, $contentItemDescription, $contentItemExternalReference, $contentItemUrl, $drmKeyId, $drmKeySeed); break; case 'createSimpleMedia': createSimpleMedia($contentItemName, $contentItemDescription, $contentItemExternalReference, $contentItemUrl); break; case 'updateMedia': updateMedia($contentItemName, $contentItemDescription, $contentItemExternalReference, $contentItemUrl, $drmKeyId, $drmKeySeed, $scrubberURL, $englishCaption, $frenchCaption, $italianCaption, $germanCaption, $spanishCaption); break; case 'simpleUpdateMedia': simpleUpdateMedia($contentItemName, $contentItemDescription, $contentItemExternalReference, $contentItemUrl, $drmKeyId, $drmKeySeed); break; case 'createProduct': createProduct($productName, $productExternalReference, $englishCID, $frenchCID, $italianCID, $germanCID, $spanishCID); break; case 'createStandardProduct': createStandardProduct($productName, $productExternalReference, $CID); break; case 'retrieveMedia': retrieveMedia($contentItemExternalReference); break; case 'JSONUpdateMedia': JSONUpdateMedia($requestJSON);
break; } //we have rows to process foreach ($rows as $row) { printf("processing row id %d \n", $row['id']); //write a pipe that can return fileData $abspath = "/home/rjha/web/upload/" . $row["stored_name"]; $uploader->process($prefix, $abspath); $errors = $uploader->getErrors(); if (sizeof($errors) > 0) { print_r($errors); exit; } else { $mediaVO = $uploader->getMediaData(); //print_r($mediaVO); updateMedia($mysqli, $row["id"], $mediaVO); } sleep(3); } //loop sleep(1); $count++; printf("loop iteration number %d \n", $count); } function updateMedia($mysqli, $mediaId, $mediaVO) { //update m.thumbnail,m.stored_name,m.bucket,m.store $updateSQL = " update sc_media set thumbnail = ?,stored_name = ?,bucket = ?, store = ? where id = ? "; $stmt = $mysqli->prepare($updateSQL); $store = "s3"; if ($stmt) {
$sql = " select id,images_json from sc_post where (id <= {end}) and (id >= {start} ) "; $sql = str_replace(array("{end}", "{start}"), array(0 => $end, 1 => $start), $sql); $rows = MySQL\Helper::fetchRows($mysqli, $sql); foreach ($rows as $row) { //remove malformed utf-8 characters $fjson = iconv('UTF-8', 'UTF-8//IGNORE', $row['images_json']); $images = json_decode($fjson); //printf("code from json_decode is %d \n",json_last_error()); $data = array(); if (!empty($images)) { foreach ($images as $image) { $image->thumbnailName = Util::getThumbnailName($image->originalName); //printf("tname is %s \n",$image->thumbnailName); array_push($data, $image); //update sc_media.thumbnail_name updateMedia($mysqli, $image->id, $image->thumbnailName); } //new mediaVO $strMediaVO = json_encode($data); //push new mediaVO to sc_post updatePost($mysqli, $row['id'], $strMediaVO); } else { //no images case $strMediaVO = '[]'; updatePost($mysqli, $row['id'], $strMediaVO); } } sleep(1); $count++; } function updateMedia($mysqli, $mediaId, $tname)
} return $media->getId(); } $id = FALSE; switch ($_POST['area']) { case 'category': $id = createCategory(); break; case 'cofilter': $id = createCommentfilter(); break; case 'comment': $id = updateComment(); break; case 'media': $id = updateMedia(); break; case 'page': $id = createPage(); break; case 'post': $id = createPost(); deletePost2CategoryRelations($id); createPost2CategoryRelations($id); break; case 'user': $id = createUser(); break; } if ($id === FALSE) { ae_Log::printAll();