$data['EXPIRY_DATE'] = date('Y-m-d H:i:s', strtotime($data['EXPIRY_DATE']));
}
}
if (SmartyValidate::is_valid($data, 'dir_links_edit')) {
if (empty($id)) {
$id = $db->GenID($tables['link']['name'] . '_SEQ');
}
if ($data['FEATURED'] == '1') {
$AllowedFeat = check_allowed_feat($data['CATEGORY_ID']);
$tpl->assign('AllowedFeat', $AllowedFeat);
}
if (ENABLE_PAGERANK) {
require_once 'include/pagerank.php';
$data['PAGERANK'] = get_page_rank($data['URL']);
if (!empty($data['RECPR_URL'])) {
$data['RECPR_PAGERANK'] = get_page_rank($data['RECPR_URL']);
}
}
$data['ID'] = $id;
if (!isset($data['RECPR_REQUIRED'])) {
$data['RECPR_REQUIRED'] = 0;
}
if (db_replace('link', $data, 'ID') > 0) {
$tpl->assign('posted', true);
if ($action == 'N') {
$cid = $data['CATEGORY_ID'];
$data = array();
$data['STATUS'] = 2;
$data['CATEGORY_ID'] = $cid;
} else {
send_status_notifications($id);
}
if ($sent) {
$id = $db->GenID($tables['email']['name'] . '_SEQ');
$data['ID'] = $id;
if ($db->Replace($tables['email']['name'], $data, 'ID', true) > 0) {
// Save to Links table
$link_data = get_table_data('link');
$link_data['RECPR_REQUIRED'] = REQUIRE_RECIPROCAL;
$link_data['STATUS'] = 2;
$link_data['OWNER_NAME'] = $data['NAME'];
$link_data['OWNER_EMAIL'] = $data['EMAIL'];
$link_data['DATE_ADDED'] = gmdate('Y-m-d H:i:s');
$link_data['DATE_MODIFIED'] = gmdate('Y-m-d H:i:s');
if (ENABLE_PAGERANK) {
require_once 'include/pagerank.php';
$link_data['PAGERANK'] = get_page_rank($link_data['URL']);
}
$link_data['ID'] = $link_id;
if ($db->Replace($tables['link']['name'], $link_data, 'ID', true) > 0) {
$category = $db->GetOne("SELECT `TITLE` FROM `{$tables['category']['name']}` WHERE `STATUS` = '2' AND `ID` = " . $db->qstr($full_data['CATEGORY_ID']));
$full_data['CATEGORY'] = $category;
$tpl->assign('posted', true);
$tpl->assign('sent', $full_data);
$data = array();
} else {
$tpl->assign('sql_error', $db->ErrorMsg());
}
} else {
$tpl->assign('sql_error', $db->ErrorMsg());
}
} else {
function add_link($cid, $link, $title = 'N/A', $desc = 'N/A', $status = '2')
{
global $db, $tables;
$data = array();
$data['TITLE'] = $title;
$data['DESCRIPTION'] = $desc;
$data['CATEGORY_ID'] = $cid;
$data['URL'] = $link;
$data['RECPR_REQUIRED'] = 0;
$data['STATUS'] = $status;
$error = array();
if (!check_unique('link', 'TITLE', $title, NULL, 'CATEGORY_ID', $cid)) {
$error['TITLE'] = true;
}
if (ALLOW_MULTIPLE == 1) {
$cu = check_unique('link', 'URL', $link, NULL, 'CATEGORY_ID', $cid);
} else {
$cu = check_unique('link', 'URL', $link, NULL);
}
if (!$cu) {
$error['URL'] = true;
}
if (count($error) > 0) {
$data['ERROR'] = $error;
return $data;
}
$data['IPADDRESS'] = $client_info['IP'];
if (!empty($client_info['HOSTNAME'])) {
$data['DOMAIN'] = $client_info['HOSTNAME'];
}
$data['VALID'] = 1;
$data['LAST_CHECKED'] = gmdate('Y-m-d H:i:s');
$data['DATE_ADDED'] = gmdate('Y-m-d H:i:s');
$data['DATE_MODIFIED'] = gmdate('Y-m-d H:i:s');
if (strlen(trim($data['URL'])) > 0 && !preg_match('#^http[s]?:\\/\\/#i', $data['URL'])) {
$data['URL'] = "http://" . $data['URL'];
}
if (ENABLE_PAGERANK) {
require_once '../include/pagerank.php';
$data['PAGERANK'] = get_page_rank($data['URL']);
}
$id = $db->GenID($tables['link']['name'] . '_SEQ');
$data['ID'] = $id;
if ($db->Replace($tables['link']['name'], $data, 'ID', true) == 0) {
$error['SQL'] = true;
}
$data['ERROR'] = $error;
return $data;
}
