$email_text .= sprintf(EMAIL_TEXT_NEW_STATUS, $links_status_array[$links_status]);
$email_text .= EMAIL_TEXT_REPLY;
$html_msg['EMAIL_MESSAGE_HTML'] = str_replace('\\n', '', $email_text);
zen_mail($links_contact_name, $links_contact_email, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, $html_msg, 'Link Exchange');
}
zen_redirect(zen_href_link(FILENAME_LINKS, zen_get_all_get_params(array('lID', 'action')) . 'lID=' . $links_id));
} else {
if ($error == true) {
$lInfo = new objectInfo($_POST);
$processed = true;
}
}
break;
case 'deleteconfirm':
$links_id = zen_db_prepare_input($_GET['lID']);
zen_remove_link($links_id);
$messageStack->add_session(SUCCESS_PAGE_REMOVED, 'success');
zen_redirect(zen_href_link(FILENAME_LINKS, zen_get_all_get_params(array('lID', 'action'))));
break;
default:
$links_query = "select l.links_id, ld.links_title, l.links_url, ld.links_description, l.links_contact_email, l.links_status, l.links_image_url, l.links_contact_name, l.links_reciprocal_url, l.links_status, l.links_rating from " . TABLE_LINKS . " l left join " . TABLE_LINKS_DESCRIPTION . " ld on ld.links_id = l.links_id where ld.links_id = l.links_id and l.links_id = '" . (int) $_GET['lID'] . "' and ld.language_id = '" . $_SESSION['languages_id'] . "'";
$links = $db->Execute($links_query);
$categories_query = "select lcd.link_categories_name as links_category from " . TABLE_LINKS_TO_LINK_CATEGORIES . " l2lc left join " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd on lcd.link_categories_id = l2lc.link_categories_id where l2lc.links_id = '" . (int) $_GET['lID'] . "' and lcd.language_id = '" . $_SESSION['languages_id'] . "'";
$category = $db->Execute($categories_query);
$lInfo_array = array_merge((array) $links->fields, (array) $category->fields);
$lInfo = new objectInfo($lInfo_array);
}
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php
$db->Execute("update " . TABLE_LINK_CATEGORIES . "\n set link_categories_image = '" . $link_categories_image_name . "'\n where link_categories_id = '" . (int) $link_categories_id . "'");
} else {
// remove when set to none
if ($link_categories_image->filename = 'none' || $_POST['img_dir'] == 'none') {
$db->Execute("update " . TABLE_LINK_CATEGORIES . "\n set link_categories_image = ''\n where link_categories_id = '" . (int) $link_categories_id . "'");
}
}
}
zen_redirect(zen_href_link(FILENAME_LINK_CATEGORIES, '&cID=' . $link_categories_id));
break;
case 'delete_confirm':
if (isset($_POST['link_categories_id'])) {
$link_categories_id = zen_db_prepare_input($_POST['link_categories_id']);
$link_ids = $db->Execute("select links_id from " . TABLE_LINKS_TO_LINK_CATEGORIES . " where link_categories_id = '" . (int) $link_categories_id . "'");
while (!$link_ids->EOF) {
zen_remove_link($link_ids['links_id']);
$link_ids->MoveNext();
}
zen_remove_link_category($link_categories_id);
}
zen_redirect(zen_href_link(FILENAME_LINK_CATEGORIES));
break;
default:
$link_categories_query = "select lc.link_categories_id, lc.link_categories_image, lc.link_categories_status, lc.link_categories_sort_order, lc.link_categories_date_added, lc.link_categories_last_modified, lcd.link_categories_name, lcd.link_categories_description from " . TABLE_LINK_CATEGORIES . " lc left join " . TABLE_LINK_CATEGORIES_DESCRIPTION . " lcd on lc.link_categories_id = lcd.link_categories_id where lcd.link_categories_id = lc.link_categories_id and lc.link_categories_id = '" . (int) $_GET['cID'] . "' and lcd.language_id = '" . $_SESSION['languages_id'] . "'";
$link_categories = $db->Execute($link_categories_query);
$links_count_query = "select count(*) as link_categories_count from " . TABLE_LINKS_TO_LINK_CATEGORIES . " where link_categories_id = '" . (int) $_GET['cID'] . "'";
$links_count = $db->Execute($links_count_query);
// bof php5 fix - aclarke - 281206
$cInfo_array = array_merge((array) $link_categories->fields, (array) $links_count->fields);
// eof php5 fix - aclarke - 281206
$cInfo = new objectInfo($cInfo_array);
