$prio = (int) _post('prio');
if ($prio < -1) {
$prio = -1;
} elseif ($prio > 2) {
$prio = 2;
}
$duedate = parse_duedate(trim(_post('duedate')));
$t = array();
$t['total'] = 0;
if ($title == '') {
echo json_encode($t);
exit;
}
$tags = trim(_post('tags'));
$db->ex("BEGIN");
$tag_ids = prepare_tags($tags, $listId);
$cur_ids = get_task_tags($id);
if ($cur_ids) {
$ids = implode(',', $cur_ids);
$db->ex("DELETE FROM tag2task WHERE task_id={$id}");
$db->dq("UPDATE tags SET tags_count=tags_count-1 WHERE id IN ({$ids})");
}
if ($tag_ids) {
update_task_tags($id, $tag_ids);
}
if (is_null($duedate)) {
$duedate = 'NULL';
} else {
$duedate = $db->quote($duedate);
}
$db->dq("UPDATE todolist SET title=?,note=?,prio=?,tags=?,duedate={$duedate} WHERE id={$id}", array($title, $note, $prio, $tags));
function update_11_12($db, $dbtype)
{
if ($dbtype == 'mysql') {
$db->ex("ALTER TABLE todolist ADD `duedate` DATE default NULL");
} else {
$db->ex("ALTER TABLE todolist ADD duedate DATE default NULL");
}
# Fixing broken tags
$db->ex("BEGIN");
$db->ex("DELETE FROM tags");
$db->ex("DELETE FROM tag2task");
$q = $db->dq("SELECT id,tags FROM todolist");
while ($r = $q->fetch_assoc()) {
if ($r['tags'] == '') {
continue;
}
$tag_ids = prepare_tags($r['tags']);
if ($tag_ids) {
update_task_tags($r['id'], $tag_ids);
}
}
$db->ex("COMMIT");
}
$licontent = '';
while ($row = mysql_fetch_array($result)) {
//dimensions
$width = $row['width'];
$height = $row['height'];
$_size_warning = "";
if ($width < 800 or $height < 800) {
$_size_warning = "<div style='font-size:1em;'><a style='color:red;' href='" . SITEURL . "?page_id=771'>Внимание! Размеры файла<br />ограничивают применение!</a></div>";
}
$_size = $width . "px X " . $height . "px;";
$_x_sm = round($width / 300 * 2.54, 1);
$_y_sm = round($height / 300 * 2.54, 1);
$_sizesm = $_x_sm . " см X " . $_y_sm . " см";
$sizeout = "<div id='dimensions'><b>Размер:</b><br />" . $_size . "<span style='color:#ACACAC;font-size:0.875em;'><br />при печати 300dpi:<br />" . $_sizesm . $_size_warning . "</div>";
///dimensions
$licontent .= '<li id="' . $row['id'] . '" style="background-image:url(\'http://cartoonbank.ru/wp-content/plugins/wp-shopping-cart/product_images/' . $row['image'] . '\');background-repeat:no-repeat;" title="' . $row['name'] . '"><span class="slideinfo"><b>Номер: </b><span id="cuid_' . $row['id'] . '">' . $row['id'] . '</span><br /><b>Автор:</b><br /><a href="?brand=' . $row['brandid'] . '">' . $row['brand'] . '</a><br /><b>Название:</b><br />' . stripslashes($row['name']) . '<br /><b>Категория:</b><br />' . stripslashes($row['kategoria']) . '<br /><b>Описание:</b><br />' . stripslashes($row['description']) . '<br /><b>Тэги:</b><br />' . prepare_tags($row['additional_description']) . $sizeout . '<div id="star_rating_' . $row['id'] . '"><img src="http://cartoonbank.ru/img/ldng.gif"></div></span></li>';
//pokazh($row);
}
?>
<!-- main start -->
