$im->setFormat('jpg');
if ($im->readImageBlob(base64_decode($picEncoded))) {
$w = $im->getImageWidth();
$h = $im->getimageheight();
// echo $w . "." . $h;exit;
if ($w != MAX_WIDTH or $h != MAX_HEIGHT) {
// resize image
$im->scaleimage($w / $h < MAX_WIDTH / MAX_HEIGHT ? MAX_WIDTH : 0, $w / $h < MAX_WIDTH / MAX_HEIGHT ? 0 : MAX_HEIGHT);
$w = $im->getImageWidth();
$h = $im->getimageheight();
$im->cropimage(MAX_WIDTH, MAX_HEIGHT, ($w - MAX_WIDTH) / 2, ($h - MAX_HEIGHT) / 2);
}
$imgtoSave = StrSafe_DB(base64_encode($im->getImageBlob()));
safe_w_sql("insert into Photos set PhEnId={$EnId}, PhPhoto={$imgtoSave} on duplicate key update PhPhoto={$imgtoSave}");
require_once 'Common/CheckPictures.php';
updatePhoto($EnId);
}
}
$Sql = "SELECT EnId, CONCAT(EnDivision, '-',EnClass) as Category, CONCAT(CoName, ' (' ,CoCode,')') as Country, CONCAT(UPPER(EnFirstName),' ' ,EnName) as Athlete, PhPhoto as Photo " . "FROM Entries " . "LEFT JOIN Countries ON EnCountry=CoId " . "LEFT JOIN Photos ON EnId=PhEnId " . "WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EnId=" . StrSafe_DB($_REQUEST['Id']);
$Rs = safe_r_sql($Sql);
if (safe_num_rows($Rs)) {
$row = safe_fetch($Rs);
$Answer .= '<athlete>' . '<id>' . $row->EnId . '</id>' . '<ath><![CDATA[' . $row->Athlete . ']]></ath>' . '<team><![CDATA[' . $row->Country . ']]></team>' . '<cat><![CDATA[' . $row->Category . ']]></cat>' . '<pic><![CDATA[' . ($row->Photo ? "data:image/jpeg;base64," . $row->Photo : '') . ']]></pic>' . '</athlete>';
}
} else {
$Errore = 1;
}
header('Content-Type: text/xml');
echo '<response>';
echo '<error>' . $Errore . '</error>';
echo $Answer;
// do nothing for edit and delete
// but treat treatedit and treatdelete
if ($action == 'treatedit') {
if (isset($_POST['letitre']) && isset($_POST['ladesc'])) {
$letitre = secure($_POST['letitre']);
$ladesc = secure($_POST['ladesc']);
unbindPhotoCategory($photo['id']);
if (isset($_POST['category']) && is_array($_POST['category'])) {
$category = $_POST['category'];
} else {
$category = [];
}
foreach ($category as $value) {
bindPhotoCategory($photo['id'], $value);
}
$update_photo = updatePhoto($photo['id'], $letitre, $ladesc);
if ($update_photo == false) {
$editerror = 'La modification a échoué !';
}
// errors ? stack in a variable and show them
} else {
header('Location: ./?page=deconnect');
}
} elseif ($action == 'delete') {
unbindPhotoCategory($photo['id']);
deletePhoto($photo['id']);
unlink(CHEMIN_RACINE . $dossier_ori . $photo['lenom'] . '.' . $photo['lextension']);
unlink(CHEMIN_RACINE . $dossier_gd . $photo['lenom'] . '.jpg');
unlink(CHEMIN_RACINE . $dossier_mini . $photo['lenom'] . '.jpg');
}
} else {
