<?php
require dirname(__FILE__) . '/utils.php';
db_connect();
if (isset($_GET['src'])) {
$src = urldecode($_GET['src']);
// $sql = 'SELECT ';
if (is_file($src)) {
$imginfo = getimagesize($src);
header('Content-type: ' . $imginfo['mime']);
readfile($src);
}
} else {
if (isset($_GET['id'])) {
$sql = 'SELECT path, filename FROM files WHERE id=' . clean_champ($_GET['id']) . '';
$req = mysql_query($sql);
if (mysql_num_rows($req) == 1) {
$infos = mysql_fetch_assoc($req);
$src = $infos['path'] . '/' . $infos['filename'];
if (is_file($src)) {
$imginfo = getimagesize($src);
header('Content-type: ' . $imginfo['mime']);
readfile($src);
}
}
}
}
if (removeTagFromBdd($imgId, $_POST['tagId'])) {
$success[] = $imgId;
} else {
$errors[] = $imgId;
}
}
$res = drawMultiImgTags($imgList);
echo $res;
}
if (isset($_GET['loadTagsForImgList'])) {
$idList = explode(',', $_POST['idList']);
echo drawModalTagsEdit($idList);
}
if (isset($_GET['loadTagsForImg'])) {
$res = '';
$tags = queryImageTags(clean_champ($_GET['imgId']));
if (count($tags) == 0) {
$res = '<em>pas de tag</em>';
}
foreach ($tags as $id => $name) {
$res .= '<a href="search.php?tags_list=' . $id . '">' . $name . '</a><br>';
}
$res = substr($res, 0, -1);
echo $res;
}
if (isset($_GET['autocomplete'])) {
echo json_encode(searchTagByName($_GET['autocomplete']));
}
if (isset($_GET['importFiles'])) {
$nbImgProcessed = processImport();
$res = array('NB_IMG' => $nbImgProcessed);
function addTagBdd($_tagName)
{
$sql = 'INSERT INTO tags (name) VALUES ("' . clean_champ($_tagName) . '")';
if (mysql_query($sql)) {
return mysql_insert_id();
}
return -1;
}
