Linksmanager 3.1.3

Code:

} else if($action == 'insert') {
$sql_data_array['links_date_added'] = 'now()';
}

if ($action == 'update') {
zen_db_perform(TABLE_LINKS, $sql_data_array, 'update', "links_id = '" . (int)$links_id . "'");
} else if($action == 'insert') {
zen_db_perform(TABLE_LINKS, $sql_data_array);

$links_id = zen_db_insert_id();
}

$categories_query = "select link_categories_id from " . TABLE_LINK_CATEGORIES_DESCRIPTION . " where link_categories_name = '" . $links_category . "' and language_id = '" . $_SESSION['languages_id'] . "'";

$categories = $db->Execute($categories_query);
$link_categories_id = $categories->fields['link_categories_id'];

if ($action == 'update') {
$db->Execute("update " . TABLE_LINKS_TO_LINK_CATEGORIES . " set link_categories_id = '" . (int)$link_categories_id . "' where links_id = '" . (int)$links_id . "'");
} else if($action == 'insert') {
$db->Execute("insert into " . TABLE_LINKS_TO_LINK_CATEGORIES . " ( links_id, link_categories_id) values ('" . (int)$links_id . "', '" . (int)$link_categories_id . "')");
}

$sql_data_array = array('links_title' => $links_title,
'links_description' => $links_description);

if ($action == 'update') {
zen_db_perform(TABLE_LINKS_DESCRIPTION, $sql_data_array, 'update', "links_id = '" . (int)$links_id . "' and language_id = '" . $_SESSION['languages_id'] . "'");
} else if($action == 'insert') {
$insert_sql_data = array('links_id' => $links_id,
'language_id' => $_SESSION['languages_id']);

$sql_data_array = array_merge($sql_data_array, $insert_sql_data);
zen_db_perform(TABLE_LINKS_DESCRIPTION, $sql_data_array);
}

if (isset($_POST['links_notify']) && ($_POST['links_notify'] == 'on')) {
$email = sprintf(EMAIL_TEXT_STATUS_UPDATE, $links_contact_name, $links_status_array[$links_status]) . '<br />' . STORE_OWNER . '<br />' . STORE_NAME;

zen_mail($links_contact_name, $links_contact_email, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS');
}

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);