An error occured while saving the link.

[John D]

Hey,
Getting the following error on www.AllDotNet.com (http://www.AllDotNet.com)

Included the main files below:

Submit.tpl
<?php
/**
* Project: PHPLinkDirectory: Link exchange directory
*

* @link http://www.phplinkdirectory.com/
* @copyright 2004-2005 NetCreated, Inc. (http://www.netcreated.com/)
* @package PHPLinkDirectory
* @version 2.0.0 RC5.2
**/

require_once 'init.php';
session_start();

//Evaluate payment options
if (PAY_ENABLE == '1' && PAYPAL_ACCOUNT != '') {
$price = array ();
if (FTR_ENABLE == '1' && PAY_FEATURED > 0) {
$price['featured'] = PAY_FEATURED;
}
if (PAY_NORMAL > 0) {
$price['normal'] = PAY_NORMAL;
if (PAY_ENABLE_FREE) {
$price['free'] = 0;
}
}
if (PAY_RECPR > 0) {
$price['reciprocal'] = PAY_RECPR;
}
$tpl->assign('price', $price);

if (isset ($_REQUEST['LINK_TYPE'])) {
$link_type = $_REQUEST['LINK_TYPE'];
switch ($link_type) {
case 'reciprocal' :
$recpr_required = 1;
break;
case 'free' :
$recpr_required = REQUIRE_RECIPROCAL;
break;
default :
$recpr_required = 0;
break;
}
} else {
$recpr_required = 0;
}
$_SESSION['SmartyValidate']['submit_link']['validators'][6]['empty'] = $recpr_required ? 0 : 1;
$_SESSION['SmartyValidate']['submit_link']['validators'][7]['empty'] = $recpr_required ? 0 : 1;
} else {
$recpr_required = REQUIRE_RECIPROCAL;
}
$tpl->assign('recpr_required', $recpr_required);
if (empty ($_REQUEST['submit'])) {
if (!empty ($_SERVER['HTTP_REFERER']))
$_SESSION['return'] = $_SERVER['HTTP_REFERER'];
$cid = get_category($_SERVER['HTTP_REFERER']);
$data = array ();
$data['CATEGORY_ID'] = $cid;
$data['RECPR_REQUIRED'] = $recpr_required;
SmartyValidate :: connect($tpl);
init_submission();
SmartyValidate :: register_form('submit_link', true);
SmartyValidate :: register_criteria('isValueUnique', 'validate_unique', 'submit_link');
SmartyValidate :: register_criteria('isNotEqual', 'validate_not_equal', 'submit_link');
SmartyValidate :: register_criteria('isURLOnline', 'validate_url_online', 'submit_link');
SmartyValidate :: register_validator('v_TITLE', 'TITLE', 'notEmpty', false, false, false, 'trim', 'submit_link');
SmartyValidate :: register_validator('v_TITLE_U', 'TITLE:link:CATEGORY_ID', 'isValueUnique', false, false, false, null, 'submit_link');
SmartyValidate :: register_validator('v_URL', 'URL', 'isURL', false, false, false, 'trim', 'submit_link');
SmartyValidate :: register_validator('v_URL_ONLINE', 'URL', 'isURLOnline', false, false, false, null, 'submit_link');
SmartyValidate :: register_validator('v_URL_U', 'URL:link::'. (ALLOW_MULTIPLE ? ':CATEGORY_ID' : ''), 'isValueUnique', false, false, false, null, 'submit_link');
SmartyValidate :: register_validator('v_CATEGORY_ID', 'CATEGORY_ID:0', 'isNotEqual', true, false, false, null, 'submit_link');
SmartyValidate :: register_validator('v_RECPR_URL', 'RECPR_URL', 'isURL', !$recpr_required, false, false, 'trim', 'submit_link');
SmartyValidate :: register_criteria('isRecprOnline', 'validate_recpr_link', 'submit_link');
SmartyValidate :: register_validator('v_RECPR_ONLINE', 'RECPR_URL', 'isRecprOnline', !$recpr_required, false, false, null, 'submit_link');
SmartyValidate :: register_validator('v_OWNER_NAME', 'OWNER_NAME', 'notEmpty', false, false, false, 'trim', 'submit_link');
SmartyValidate :: register_validator('v_OWNER_EMAIL', 'OWNER_EMAIL', 'isEmail', false, false, false, 'trim', 'submit_link');
if(count($price)>0){
SmartyValidate :: register_validator('v_LINK_TYPE', 'LINK_TYPE', 'notEmpty', false, false, false, 'trim', 'submit_link');
}
if (VISUAL_CONFIRM) {
SmartyValidate :: register_criteria('isCaptchaValid', 'validate_captcha', 'submit_link');
SmartyValidate :: register_validator('v_CAPTCHA', 'CAPTCHA', 'isCaptchaValid', false, false, false, null, 'submit_link');
}
} else {
SmartyValidate :: connect($tpl);
$data = get_table_data('link');
$data['STATUS'] = 1;
$data['IPADDRESS'] = get_client_ip();
$data['VALID'] = 1;
$data['LINK_TYPE'] = $link_type;
$data['RECPR_REQUIRED'] = $recpr_required;
if ($recpr_required) {
$data['RECPR_VALID'] = 1;
$data['RECPR_LAST_CHECKED'] = gmdate('Y-m-d H:i:s');
}

if (ENABLE_ID)
$data['RECPR_ID'] = $_SESSION['RECPR_ID'];

$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?)://`", $data['URL']))
$data['URL'] = "http://".$data['URL'];
if (strlen(trim($data['RECPR_URL'])) > 0 && !preg_match("`^http(s?)://`", $data['RECPR_URL']))
$data['RECPR_URL'] = "http://".$data['RECPR_URL'];
if (VISUAL_CONFIRM) {
$data = array_merge($data, array ('CAPTCHA' => $_REQUEST['CAPTCHA']));
}
if (SmartyValidate :: is_valid($data, 'submit_link')) {
if (VISUAL_CONFIRM) {
unset ($data['CAPTCHA']);
}
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']);
}
}

$id = $db->GenID($tables['link']['name'].'_SEQ');
$data['ID'] = $id;
$data['LINK_TYPE'] = $link_type_int[$link_type];
switch($link_type){
case 'free':
$data['NOFOLLOW'] = 1;
break;
case 'featured':
$data['FEATURED'] = 1;
break;
}
$data['OWNER_NOTIF'] = $price[$link_type] > 0?0:1;
$data['PAYED'] = $price[$link_type] > 0?0:-1;
if ($db->Replace($tables['link']['name'], $data, 'ID', true) > 0) {
$tpl->assign('posted', true);
send_submit_notifications($data);
if($price[$link_type] > 0) { //Move to payment page
header("Location: payment.php?id=".$data['ID']);
exit;
}else{
unset ($data['TITLE']);
unset ($data['URL']);
unset ($data['DESCRIPTION']);
unset ($data['RECPR_URL']);

if (ENABLE_ID)
init_submission();
}
} else {
$tpl->assign('error', true);
}
}
}
unset ($_SESSION['CAPTCHA']);
$path = array ();
$path[] = array ('ID' => '0', 'TITLE' => _L(SITE_NAME), 'TITLE_URL' => DOC_ROOT, 'DESCRIPTION' => SITE_DESC);
$path[] = array ('ID' => '0', 'TITLE' => _L('Submit Link'), 'TITLE_URL' => '', 'DESCRIPTION' => _L('Submit a new link to the directory '));
$tpl->assign('path', $path);

if (ENABLE_ID)
$tpl->assign('recpr_id', $_SESSION['RECPR_ID']);

$categs = get_categs_tree($db, 0);
$tpl->assign('categs', $categs);
$tpl->assign($data);
$tpl->assign('LINK_TYPE', $link_type);
echo $tpl->fetch('submit.tpl', $id);

function validate_captcha($value, $empty, & $params, & $form) {
require_once 'libs/captcha/captcha.class.php';
return isset ($_SESSION['CAPTCHA']) && strtolower($_SESSION['CAPTCHA']) == strtolower($value);
}
function init_submission() {
mt_srand();
$_SESSION['RECPR_ID'] = mt_rand(0, 0xFFFFFF);
}
?>
[/code]
Can anyone see any problems?

Not sure what's wrong - I had a few mods but I tried to remove it because I thought that might be the problem.

Thanks

[John D]

I had to repair the link table

#1016 - Can't open file: 'PLD_LINK.MYI' (errno: 145)

[Keralakkara]

Hello Please help me I have also the same error Content visible to registered users only.