vam_db_perform(TABLE_AUTHORS_INFO, $sql_data_array, 'update', "authors_id = '" . (int) $authors_id . "' and languages_id = '" . (int) $language_id . "'"); } } if (USE_CACHE == 'true') { vam_reset_cache_block('authors'); } vam_redirect(vam_href_link(FILENAME_AUTHORS, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'auID=' . $authors_id)); break; case 'deleteconfirm': $authors_id = vam_db_prepare_input($_GET['auID']); vam_db_query("delete from " . TABLE_AUTHORS . " where authors_id = '" . (int) $authors_id . "'"); vam_db_query("delete from " . TABLE_AUTHORS_INFO . " where authors_id = '" . (int) $authors_id . "'"); if (isset($_POST['delete_articles']) && $_POST['delete_articles'] == 'on') { $articles_query = vam_db_query("select articles_id from " . TABLE_ARTICLES . " where authors_id = '" . (int) $authors_id . "'"); while ($articles = vam_db_fetch_array($articles_query)) { vam_remove_article($articles['articles_id']); } } else { vam_db_query("update " . TABLE_ARTICLES . " set authors_id = '' where authors_id = '" . (int) $authors_id . "'"); } if (USE_CACHE == 'true') { vam_reset_cache_block('authors'); } vam_redirect(vam_href_link(FILENAME_AUTHORS, 'page=' . $_GET['page'])); break; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html <?php echo HTML_PARAMS;
if (USE_CACHE == 'true') { vam_reset_cache_block('topics'); } vam_redirect(vam_href_link(FILENAME_ARTICLES, 'tPath=' . $tPath)); break; case 'delete_article_confirm': if (isset($_POST['articles_id']) && isset($_POST['article_topics']) && is_array($_POST['article_topics'])) { $article_id = vam_db_prepare_input($_POST['articles_id']); $article_topics = $_POST['article_topics']; for ($i = 0, $n = sizeof($article_topics); $i < $n; $i++) { vam_db_query("delete from " . TABLE_ARTICLES_TO_TOPICS . " where articles_id = '" . (int) $article_id . "' and topics_id = '" . (int) $article_topics[$i] . "'"); } $article_topics_query = vam_db_query("select count(*) as total from " . TABLE_ARTICLES_TO_TOPICS . " where articles_id = '" . (int) $article_id . "'"); $article_topics = vam_db_fetch_array($article_topics_query); if ($article_topics['total'] == '0') { vam_remove_article($article_id); } } if (USE_CACHE == 'true') { vam_reset_cache_block('topics'); } vam_redirect(vam_href_link(FILENAME_ARTICLES, 'tPath=' . $tPath)); break; case 'move_topic_confirm': if (isset($_POST['topics_id']) && $_POST['topics_id'] != $_POST['move_to_topic_id']) { $topics_id = vam_db_prepare_input($_POST['topics_id']); $new_parent_id = vam_db_prepare_input($_POST['move_to_topic_id']); $path = explode('_', vam_get_generated_topic_path_ids($new_parent_id)); if (in_array($topics_id, $path)) { $messageStack->add_session(ERROR_CANNOT_MOVE_TOPIC_TO_PARENT, 'error'); vam_redirect(vam_href_link(FILENAME_ARTICLES, 'tPath=' . $tPath . '&tID=' . $topics_id));