function cancelphoto($uid)
{
$cn = connect_db();
$sql = "select * from `photo` where userid='" . $uid . "'";
$link = mysql_query($sql, $cn) or die("Error : " . mysql_error());
while ($data = mysql_fetch_assoc($link)) {
image_delete($data['id']);
}
disconnect_db($cn);
}
function image_multi_edit()
{
global $txp_user, $all_image_cats, $all_image_authors;
// Empty entry to permit clearing the category.
$categories = array('');
foreach ($all_image_cats as $row) {
$categories[] = $row['name'];
}
$selected = ps('selected');
if (!$selected or !is_array($selected)) {
return image_list();
}
$selected = array_map('assert_int', $selected);
$method = ps('edit_method');
$changed = array();
$key = '';
switch ($method) {
case 'delete':
return image_delete($selected);
break;
case 'changecategory':
$val = ps('category');
if (in_array($val, $categories)) {
$key = 'category';
}
break;
case 'changeauthor':
$val = ps('author');
if (in_array($val, $all_image_authors)) {
$key = 'author';
}
break;
default:
$key = '';
$val = '';
break;
}
if (!has_privs('image.edit')) {
if (has_privs('image.edit.own')) {
$selected = safe_column('id', 'txp_image', 'id IN (' . join(',', $selected) . ') AND author=\'' . doSlash($txp_user) . '\'');
} else {
$selected = array();
}
}
if ($selected and $key) {
foreach ($selected as $id) {
if (safe_update('txp_image', "{$key} = '" . doSlash($val) . "'", "id = {$id}")) {
$changed[] = $id;
}
}
}
if ($changed) {
update_lastmod();
return image_list(gTxt('image_updated', array('{name}' => join(', ', $changed))));
}
return image_list();
}
function image_multi_edit()
{
$selected = ps('selected');
if (!$selected or !is_array($selected)) {
return image_list();
}
$selected = array_map('assert_int', $selected);
$method = ps('edit_method');
$changed = array();
if ($method == 'delete') {
return image_delete($selected);
}
if ($method == 'changecategory') {
foreach ($selected as $id) {
if (safe_update('txp_image', "category = '" . doSlash(ps('category')) . "'", "id = {$id}")) {
$changed[] = $id;
}
}
}
if ($changed) {
update_lastmod();
return image_list(gTxt('image_updated', array('{name}' => join(', ', $changed))));
}
return image_list();
}
