case "resize":
//var_dump($_REQUEST);
require_once ROOT . "/classes/img_edit.php";
$q = "SELECT img.img_filename AS fname, img.img_project_id AS pid,\n\t\t\timg.img_width_b AS w, img.img_width_s AS ws, img.img_height_b AS h, img.img_height_s AS hs\n\t\t\tFROM `" . PREF . "img` img\n\t\t\tWHERE img.img_id='" . $_REQUEST['id'] . "'\n\t\t\tLIMIT 1";
$r = $sql->fetch($sql->query($q));
if ($r['pid']) {
$fp = ROOT . "/images/";
} else {
$fp = ROOT . "/images/unsorted/";
}
// resizing
$file = new img_edit($fp . $r['fname'] . ".jpg");
$_REQUEST['h1'] == '' ? $file->set_wh($_REQUEST['w1']) : $file->set_wh($_REQUEST['w1'], $_REQUEST['h1']);
$file->out('save', 4, $fp . $r['fname'] . ".jpg");
// thumbnailing
$file = new img_edit($fp . $r['fname'] . ".jpg");
$_REQUEST['h2'] == '' ? $file->set_wh($_REQUEST['w2']) : $file->set_wh($_REQUEST['w2'], $_REQUEST['h2']);
$file->out('save', 4, $fp . "thumb_" . $r['fname'] . ".jpg");
$big = getimagesize($fp . $r['fname'] . ".jpg");
$small = getimagesize($fp . "thumb_" . $r['fname'] . ".jpg");
$q = "UPDATE `" . PREF . "img` SET\n\t\t\t`img_width_b`='" . $big['0'] . "', `img_width_s`='" . $small['0'] . "',\n\t\t\t`img_height_b`='" . $big['1'] . "', `img_height_s`='" . $small['1'] . "'\n\t\t\tWHERE img_id='" . $_REQUEST['id'] . "'\n\t\t\tLIMIT 1";
$res = $sql->query($q);
$GLOBALS['_RESULT'] = array('w1' => $big['0'], 'w2' => $small['0'], 'h1' => $big['1'], 'h2' => $small['1']);
break;
case "resort_vals":
$q1 = "SELECT v.`value_sort` AS sort, ln.link_img AS iid\n\t\t\tFROM `" . PREF . "values` AS v, `" . PREF . "kvi_links` AS ln\n\t\t\tWHERE v.value_id='" . $_REQUEST['id'] . "' AND ln.link_value=v.value_id\n\t\t\tLIMIT 1";
$r = $sql->fetch($sql->query($q1));
$q2 = "SELECT MAX(v.value_sort) AS max, MIN(v.value_sort) AS min\n\t\t\tFROM `" . PREF . "kvi_links` AS ln, `" . PREF . "values` AS v\n\t\t\tWHERE ln.link_value=v.value_id AND ln.link_img='" . $r['iid'] . "'";
$r2 = $sql->fetch($sql->query($q2));
switch ($_REQUEST['to']) {
case "up":
// Create main library object. You MUST specify page encoding!
$JsHttpRequest = new JsHttpRequest("windows-1251");
if (!$auth->check()) {
$GLOBALS['_RESULT'] = array("q" => "You are not logged in");
exit;
}
$error = 0;
if (isset($_FILES['img']) and !$_FILES['img']['error']) {
while (file_exists(ROOT . "/images/unsorted/" . md5($_FILES['img']['name']) . ".jpg")) {
$_FILES['img']['name'] = $_FILES['img']['name'] . md5(rand(0, 10000));
}
if (move_uploaded_file($_FILES['img']['tmp_name'], ROOT . "/images/unsorted/" . md5($_FILES['img']['name']) . ".jpg")) {
$real = new img_edit(ROOT . "/images/unsorted/" . md5($_FILES['img']['name']) . ".jpg");
//$real->set_wh(800);
$real->out('save', 1, ROOT . "/images/unsorted/" . md5($_FILES['img']['name']) . ".jpg");
$thumb = new img_edit(ROOT . "/images/unsorted/" . md5($_FILES['img']['name']) . ".jpg");
$thumb->set_wh(120);
$thumb->out('save', 4, ROOT . "/images/unsorted/thumb_" . md5($_FILES['img']['name']) . ".jpg");
$big = getimagesize(ROOT . "/images/unsorted/" . md5($_FILES['img']['name']) . ".jpg");
$small = getimagesize(ROOT . "/images/unsorted/thumb_" . md5($_FILES['img']['name']) . ".jpg");
if (!$sql->query("INSERT INTO `" . PREF . "img` (\n\t\t\t`img_filename`,\n\t\t\t`img_filesize_b`,\n\t\t\t`img_date`,\n\t\t\t`img_project_id`,\n\t\t\t`img_order`,\n\t\t\t`img_width_b`, `img_width_s`, `img_height_b`, `img_height_s`, `img_filesize_s`\n\t\t) VALUES (\n\t\t\t'" . md5($_FILES['img']['name']) . "',\n\t\t\t'" . $_FILES['img']['size'] . "',\n\t\t\tNOW(),\n\t\t\t'0',\n\t\t\t'0',\n\t\t\t'" . $big['0'] . "', '" . $small['0'] . "', '" . $big['1'] . "', '" . $small['1'] . "', '" . filesize(ROOT . "/images/unsorted/thumb_" . md5($_FILES['img']['name']) . ".jpg") . "'\n\t\t\t)")) {
unlink(ROOT . "/images/unsorted/" . md5($_FILES['img']['name']) . ".jpg");
unlink(ROOT . "/images/unsorted/thumb_" . md5($_FILES['img']['name']) . ".jpg");
$error = 1;
}
// Store resulting data in $_RESULT array (will appear in req.responseJs).
$GLOBALS['_RESULT'] = array("q" => md5($_FILES['img']['name']), 'id' => mysql_insert_id());
} else {
$error = 1;
}
} else {
