Execute($newword_sql); oos_redirect_admin(oos_href_link_admin($aFilename['stats_keywords'], 'update_word_list=' . BUTTON_VIEW_WORD_LIST . '')); } if (isset($_GET['removeword']) && isset($_GET['delete'])){ $searchword_swaptable = $oostable['searchword_swap']; $word_delete_sql = "DELETE FROM $searchword_swaptable WHERE sws_id = " . oos_db_input($_GET['delete']); $result = $dbconn->Execute($word_delete_sql); oos_redirect_admin(oos_href_link_admin($aFilename['stats_keywords'], 'update_word_list=' . BUTTON_VIEW_WORD_LIST . '')); } if (isset($_GET['editword']) && isset($_GET['link'])){ $searchword_swaptable = $oostable['searchword_swap']; $word_select_sql = "SELECT * FROM $searchword_swaptable WHERE sws_id = " . oos_db_input($_GET['edit']); $result = $dbconn->Execute($word_select_sql); $word_select_result = $result->fields; } if (isset($_GET['editword']) && isset($_GET['updateword'])){ $searchword_swaptable = $oostable['searchword_swap']; $word_update_sql = "UPDATE $searchword_swaptable SET sws_word= '" . oos_db_input($_GET['txtWord']) . "', sws_replacement = '" . addslashes($_GET['txtReplacement']) . "' WHERE sws_id = " . $_GET['id']; $result = $dbconn->Execute($word_update_sql); oos_redirect_admin(oos_href_link_admin($aFilename['stats_keywords'], 'update_word_list=' . BUTTON_VIEW_WORD_LIST . '')); } $no_js_general = true; require 'includes/oos_header.php'; ?>

Execute("TRUNCATE $search_queries_sortedtable"); } if (isset($_GET['update'])) { $search_queriestable = $oostable['search_queries']; $sql_q = $dbconn->Execute("SELECT DISTINCT search_text, COUNT(*) AS ct FROM $search_queriestable GROUP BY search_text"); while ($sql_q_result = $sql_q->fields) { $search_queries_sortedtable = $oostable['search_queries_sorted']; $update_q = $dbconn->Execute("SELECT search_text, search_count FROM $search_queries_sortedtable WHERE search_text = '" . $sql_q_result['search_text'] . "'"); $update_q_result = $update_q->fields; $count = $sql_q_result['ct'] + $update_q_result['search_count']; if ($update_q_result['search_count'] != '') { $search_queries_sortedtable = $oostable['search_queries_sorted']; $dbconn->Execute("UPDATE $search_queries_sortedtable SET search_count = '" . $count . "' WHERE search_text = '" . $sql_q_result['search_text'] . "'"); } else { $search_queries_sortedtable = $oostable['search_queries_sorted']; $dbconn->Execute("INSERT INTO $search_queries_sortedtable (search_text, search_count) VALUES ('" . $sql_q_result['search_text'] . "'," . $count . ")"); } $search_queriestable = $oostable['search_queries']; $dbconn->Execute("TRUNCATE $search_queriestable"); // Move that ADOdb pointer! $sql_q->MoveNext(); } // Close result set $sql_q->Close(); } if (isset($_GET['update_word_list'])) { echo oos_draw_form('addwords', $aFilename['stats_keywords'], '', 'get'); ?> Execute($pw_word_sql); while ($pw_words_result = $pw_words->fields) { ?> MoveNext(); } // Close result set $pw_words->Close(); ?> ';} ?> Execute($pw_sql); while ($sql_q_result = $result->fields) { ?> MoveNext(); } // Close result set $result->Close(); ?>

'' . SIDEBAR_HEADING . ''); $contents[] = array('text' => ' ' . SIDEBAR_INFO_1); $contents[] = array('text' => ''); $contents[] = array('text' => oos_draw_separator()); $contents[] = array('text' => ' '); $contents[] = array('text' => oos_draw_separator()); $contents[] = array('text' => ' ' . SIDEBAR_INFO_2); $contents[] = array('text' => ''); $contents[] = array('text' => oos_draw_separator()); $contents[] = array('text' => SIDEBAR_INFO_3); $contents[] = array('text' => ''); if ( (oos_is_not_null($heading)) && (oos_is_not_null($contents)) ) { $box = new box; echo $box->infoBox($heading, $contents); } ?>