Jan Piotrowski]
Author: Aleister
Version: 2.7
Author URI: http://www.dagondesign.com
Modification 25.01.2007: leicht modifzierte deutsche Version by http://www.keilblock.com + http://seo-marketing-blog.de
Changes/Aenderungen: Plain Text-Snippet, anstatt komplett verlinktem Text-Snippet, wird dargestellt + Anpassung der numerischen Seitennavi dahingehend, dass kein duplicate content durch die erste Seite der Sitemap (/sitemap + /sitemap/1/ = duplicate content) entsteht.
*/
add_option('ddsg_items_per_page', '20');
add_option('ddsg_p_or_p_shown', 'both'); // (posts, pages, both)
add_option('ddsg_p_or_p_first', 'posts'); // (posts, pages)
add_option('ddsg_comments_on_posts', TRUE);
add_option('ddsg_comments_on_pages', FALSE);
add_option('ddsg_show_zero_comments', FALSE);
add_option('ddsg_hide_duplicates', TRUE);
add_option('ddsg_xml_path', '');
add_option('ddsg_xml_where', 'last'); // (last, every)
add_option('ddsg_page_nav', '1'); // (1, 2)
add_option('ddsg_page_nav_where', 'top'); // (top, bottom, both)
add_option('ddsg_blank_title', TRUE);
add_option('ddsg_show_excerpt', 'none'); // (none, excerptw, excerptc)
add_option('ddsg_post_sort_order', 'title'); // (title, datea, dated)
add_option('ddsg_page_sort_order', 'title'); // (title, datea, dated)
add_option('ddsg_cat_text', 'Kategorie:');
add_option('ddsg_first_nc', '30');
add_option('ddsg_first_nw', '5');
add_option('ddsg_hide_protected', TRUE);
add_option('ddsg_sm_name', '');
add_option('ddsg_new_window', FALSE);
add_option('ddsg_show_post_date', FALSE);
add_option('ddsg_post_date_format', "F jS, Y");
add_option('ddsg_exclude_cats', "");
add_option('ddsg_exclude_pages', "");
add_option('ddsg_continued_msg', "(Fortsetzung)");
add_option('ddsg_xml_text', "XML-Sitemap anzeigen");
add_option('ddsg_no_title_text', "(kein Titel)");
function ddsg_add_option_pages() {
if (function_exists('add_options_page')) {
add_options_page('Dagon Design Sitemap Generator', 'DDSitemapGen', 8, __FILE__, 'ddsg_options_page');
}
}
function ddsg_options_page() {
if (isset($_POST['info_update'])) {
?> 0) {
$ipp_check = $_POST["ddsg_items_per_page"];
}
}
update_option('ddsg_items_per_page', (string) $ipp_check);
update_option('ddsg_comments_on_posts', (bool) $_POST["ddsg_comments_on_posts"]);
update_option('ddsg_comments_on_pages', (bool) $_POST["ddsg_comments_on_pages"]);
update_option('ddsg_show_zero_comments', (bool) $_POST["ddsg_show_zero_comments"]);
update_option('ddsg_hide_duplicates', (bool) $_POST["ddsg_hide_duplicates"]);
update_option('ddsg_blank_title', (bool) $_POST["ddsg_blank_title"]);
update_option('ddsg_show_excerpt', (string) $_POST["ddsg_show_excerpt"]);
update_option('ddsg_p_or_p_first', (string) $_POST["ddsg_p_or_p_first"]);
update_option('ddsg_p_or_p_shown', (string) $_POST["ddsg_p_or_p_shown"]);
update_option('ddsg_page_nav', (string) $_POST["ddsg_page_nav"]);
update_option('ddsg_page_nav_where', (string) $_POST["ddsg_page_nav_where"]);
update_option('ddsg_xml_path', (string) $_POST["ddsg_xml_path"]);
update_option('ddsg_xml_where', (string) $_POST["ddsg_xml_where"]);
update_option('ddsg_post_sort_order', (string) $_POST["ddsg_post_sort_order"]);
update_option('ddsg_page_sort_order', (string) $_POST["ddsg_page_sort_order"]);
update_option('ddsg_cat_text', (string) $_POST["ddsg_cat_text"]);
update_option('ddsg_first_nc', (string) $_POST["ddsg_first_nc"]);
update_option('ddsg_first_nw', (string) $_POST["ddsg_first_nw"]);
update_option('ddsg_hide_protected', (bool) $_POST["ddsg_hide_protected"]);
update_option('ddsg_sm_name', (string) $_POST["ddsg_sm_name"]);
update_option('ddsg_new_window', (bool) $_POST["ddsg_new_window"]);
update_option('ddsg_show_post_date', (bool) $_POST["ddsg_show_post_date"]);
update_option('ddsg_post_date_format', (string) $_POST["ddsg_post_date_format"]);
update_option('ddsg_exclude_cats', (string) $_POST["ddsg_exclude_cats"]);
update_option('ddsg_exclude_pages', (string) $_POST["ddsg_exclude_pages"]);
update_option('ddsg_continued_msg', (string) $_POST["ddsg_continued_msg"]);
update_option('ddsg_xml_text', (string) $_POST["ddsg_xml_text"]);
update_option('ddsg_no_title_text', (string) $_POST["ddsg_no_title_text"]);
echo "Einstellungen aktualisiert!";
?>
Dagon Design Sitemap Generator v2.7
get_results("
SELECT post_parent
FROM {$table_prefix}posts
WHERE post_date < NOW()
AND post_status != 'draft' AND post_status != 'attachment'
AND post_parent != 0
GROUP BY post_parent
");
$pid_list = array();
if (!empty($temp_list)) {
foreach ($temp_list as $item) {
$pid_list[] = $item->post_parent;
}
}
return $pid_list;
}
// generate category list
function ddsg_gen_cat_list() {
global $wpdb, $table_prefix, $ddsg_cats, $ddsg_exclude_cats;
$c_items = (array)$wpdb->get_results("
SELECT cat_ID, cat_name, category_parent
FROM {$table_prefix}categories
ORDER BY category_parent, cat_ID
");
$cat_count = 0;
foreach ($c_items as $c_item) {
$ddsg_cats[$cat_count]['id'] = $c_item->cat_ID;
$ddsg_cats[$cat_count]['name'] = $c_item->cat_name;
$ddsg_cats[$cat_count]['pid'] = $c_item->category_parent;
$cat_count++;
}
}
function in_array_i($strItem, $arItems)
{
$bFound = FALSE;
foreach ((array)$arItems as $strValue)
{
if (strtoupper($strItem) == strtoupper($strValue))
{
$bFound = TRUE;
}
}
return $bFound;
}
// generate list of pages
function ddsg_generate_data_pages($id = 0, $level = 0) {
global $wpdb, $table_prefix, $ddsg_data, $ddsg_temp_index, $ddsg_page_sort_order, $ddsg_hide_protected, $ddsg_pids, $ddsg_exclude_pages;
$extra_checks = "";
if ($ddsg_hide_protected) {
$extra_checks = " AND post_password = '' ";
}
$items = $wpdb->get_results("
SELECT post_title, ID, post_parent, post_name
FROM {$table_prefix}posts, {$table_prefix}post2cat, {$table_prefix}categories
WHERE post_parent = '$id'
AND post_status = 'static'
AND ID = {$table_prefix}post2cat.post_id
AND {$table_prefix}post2cat.category_id = {$table_prefix}categories.cat_ID
AND post_date < NOW()
AND post_status != 'draft' AND post_status != 'attachment'
$extra_checks
ORDER BY {$ddsg_page_sort_order}, cat_name
");
if (empty($items)) {
return;
}
$last_pid = 0;
foreach ((array)$items as $item) {
if (!in_array_i($item->post_name, $ddsg_exclude_pages)) {
if ($item->post_parent > $last_pid) {
$level = $level + 1;
} else if ($item->post_parent < $last_pid) {
$level = $level - 1;
}
$last_pid = $item->post_parent;
$ddsg_data[$ddsg_temp_index]['id'] = $item->ID;
$ddsg_data[$ddsg_temp_index]['status'] = "static";
$ddsg_data[$ddsg_temp_index]['level'] = $level;
$ddsg_data[$ddsg_temp_index]['title'] = $item->post_title;
$ddsg_temp_index++;
if (in_array((int)$item->ID, (array)$ddsg_pids)) {
ddsg_generate_data_pages($item->ID, $level);
}
}
}
}
// generate list of posts
function ddsg_generate_data_posts($id = 0, $level = 0) {
global $wpdb, $table_prefix, $ddsg_data, $ddsg_temp_index, $ddsg_post_sort_order;
global $ddsg_hide_duplicates, $ddsg_hide_protected, $ddsg_show_post_date, $ddsg_exclude_cats;
$extra_checks = "";
if ($ddsg_hide_protected) {
$extra_checks = " AND post_password = '' ";
}
$items = $wpdb->get_results("
SELECT post_title, ID, post_status, cat_ID, post_date, cat_name
FROM {$table_prefix}posts, {$table_prefix}post2cat, {$table_prefix}categories
WHERE post_parent = '$id'
AND post_status != 'static'
AND ID = {$table_prefix}post2cat.post_id
AND {$table_prefix}post2cat.category_id = {$table_prefix}categories.cat_ID
AND post_date < NOW()
AND post_status != 'draft' AND post_status != 'attachment'
$extra_checks
ORDER BY cat_name, {$ddsg_post_sort_order}
");
if (empty($items)) {
return;
}
foreach ((array)$items as $item) {
$is_dup = 0;
if ($ddsg_hide_duplicates) {
foreach ($ddsg_data as $d) {
if ($d['id'] == $item->ID) {
$is_dup = 1;
}
}
}
if (!$is_dup) {
if (!in_array_i($item->cat_name, $ddsg_exclude_cats)) {
$ddsg_data[$ddsg_temp_index]['id'] = $item->ID;
$ddsg_data[$ddsg_temp_index]['status'] = $item->post_status;
$ddsg_data[$ddsg_temp_index]['cat_id'] = $item->cat_ID;
$ddsg_data[$ddsg_temp_index]['title'] = $item->post_title;
if ($ddsg_show_post_date) {
$ddsg_data[$ddsg_temp_index]['date'] = $item->post_date;
}
$ddsg_temp_index++;
if (in_array((int)$item->ID, (array)$ddsg_pids)) {
ddsg_generate_data_posts($item->ID, $level);
}
}
}
}
}
// return number of comments for post or page
function ddsg_num_comments($id, $display) {
global $wpdb, $table_prefix;
global $ddsg_comments_on_pages;
global $ddsg_comments_on_posts;
global $ddsg_show_zero_comments;
if (!$ddsg_comments_on_pages && $display == 'page')
return "";
if (!$ddsg_comments_on_posts && $display == 'post')
return "";
$num = $wpdb->get_var("
SELECT COUNT(1) FROM {$table_prefix}comments
WHERE comment_post_ID = {$id}
AND comment_approved = '1'
");
if ($num > 0) {
return " (" . $num . ")";
} else if ($ddsg_show_zero_comments) {
return " (0)";
}
return "";
}
function ddsg_get_page_parent($id, $level = 0) {
// returns parent name of id (used in processing of data)
global $wpdb, $table_prefix, $ddsg_data, $ddsg_new_window;
while ($ddsg_data[$id]['level'] != $level) {
$id--;
}
$pid = $ddsg_data[$id]['id'];
$result = $wpdb->get_row("
SELECT post_title FROM {$table_prefix}posts
WHERE ID = '$pid'
");
return '' . $result->post_title . '';
}
function get_cat_trail($cat_id) {
global $ddsg_cats, $ddsg_new_window, $ddsg_exclude_cats;
$output1 = "";
$i = 0;
while ($ddsg_cats[$i]['id'] != $cat_id) {
$i++;
}
$pid = $ddsg_cats[$i]['pid'];
/* while ($pid > 0) {
$i = 0;
while ($ddsg_cats[$i]['id'] != $pid) {
$i++;
}
*/
if (in_array_i($ddsg_cats[$i]['name'], $ddsg_exclude_cats)) {
$output1 = "(hidden) » " . $output1;
} else {
$output1 = '' . $ddsg_cats[$i]['name'] . ' ' . $output1;
}
/*
$pid = $ddsg_cats[$i]['pid'];
}
*/
return $output1;
}
function ddsg_get_title($i) {
global $ddsg_data;
global $ddsg_blank_title;
global $ddsg_no_title_text;
$tt = "";
// There is a title
if (strlen($ddsg_data[$i]['title']) > 0) {
$tt .= $ddsg_data[$i]['title'];
} else {
if ($ddsg_blank_title) {
$tt .= $ddsg_no_title_text;
}
}
return $tt;
}
function ddsg_get_excerpt($i) {
global $ddsg_data;
global $ddsg_show_excerpt;
global $wpdb;
global $table_prefix;
global $ddsg_first_nc;
global $ddsg_first_nw;
$tt = "";
switch ($ddsg_show_excerpt) {
case 'excerptc':
$the_text = $wpdb->get_var("SELECT post_content FROM " . $table_prefix . "posts WHERE ID=" . $ddsg_data[$i]['id']);
$tt .= ': ' . substr(strip_tags(trim($the_text)) , 0, $ddsg_first_nc) . "... ";
break;
case 'excerptw':
$the_text = $wpdb->get_var("SELECT post_content FROM " . $table_prefix . "posts WHERE ID=" . $ddsg_data[$i]['id']);
$the_text = strip_tags(trim($the_text));
$t_array = explode(" ", $the_text, $ddsg_first_nw + 1);
$t_output = NULL;
for ($n = 0; $n < $ddsg_first_nw; $n++) {
if ($t_array[$n]) {
$t_output .= $t_array[$n] . " ";
}
}
$tt .= ': ' . $t_output . "... ";
break;
}
return $tt;
}
function ddsg_process_data($data1, $limit, $offset) {
global $ddsg_data;
global $ddsg_comments_on_posts;
global $ddsg_comments_on_pages;
global $ddsg_cat_text;
global $ddsg_new_window;
global $ddsg_show_post_date;
global $ddsg_post_date_format;
global $ddsg_continued_msg;
$last_cat = 0;
$last_id = 0;
$first_page = 1;
$last_cp = "";
$data1 = NULL;
$start_item = $offset;
$end_item = $offset + $limit;
if (($limit == 0) || ($end_item > count($ddsg_data))) {
$end_item = count($ddsg_data);
}
$data1 .= '';
for ($i = $start_item; $i < $end_item; $i++) {
// List posts
if ($ddsg_data[$i]['status'] != 'static') {
if ($last_cat != $ddsg_data[$i]['cat_id']) {
$data1 .= '- ' . $ddsg_cat_text;
// includes parents
$data1 .= get_cat_trail($ddsg_data[$i]['cat_id']);
if (($i == $start_item) && ($i != 0)) {
$data1 .= " " . $ddsg_continued_msg . " ";
}
$data1 .= "";
$data1 .= "
";
$last_cat = $ddsg_data[$i]['cat_id'];
}
$show_post_date = "";
if ($ddsg_show_post_date) {
$show_post_date = " " . date($ddsg_post_date_format, strtotime($ddsg_data[$i]['date'])) . " ";
}
$data1 .= '- ' . ddsg_get_title($i) . '' . ddsg_get_excerpt($i) . $show_post_date . ddsg_num_comments($ddsg_data[$i]['id'], 'post') . '
';
if (($i + 1) == $end_item) {
$data1 .= "
";
} else if ($ddsg_data[$i + 1]['cat_id'] != $last_cat) {
$data1 .= "
";
}
}
// Get previous / current levels
$c_level = $ddsg_data[$i]['level'];
if (($i > $start_item) && ($i > 0)) {
$p_level = $ddsg_data[$i - 1]['level'];
} else {
$p_level = 0;
}
// List pages
if ($ddsg_data[$i]['status'] == 'static') {
if (($i == $start_item) && ($c_level > 0)) {
$data1 .= "
" . ddsg_get_page_parent($i). " " . $ddsg_continued_msg;
}
if ($c_level > $p_level) {
for ($n = 1; $n < ($c_level - $p_level); $n++) {
$data1 .= "- " . ddsg_get_page_parent($i, $ddsg_data[$i]['level'] - $n). " " . $ddsg_continued_msg;
}
$data1 .= "
- ";
}
if ($c_level < $p_level) {
$data1 .= "
";
for ($n = 0; $n < ($p_level - $c_level); $n++) {
$data1 .= "
";
}
$data1 .= "- ";
}
if ($c_level == $p_level) {
if ($first_page) {
$first_page = 0;
if ($c_level > 0 ) {
$data1 .= "
";
}
} else {
$data1 .= "
";
}
$data1 .= "
";
}
$data1 .= '' . ddsg_get_title($i) . '' . ddsg_num_comments($ddsg_data[$i]['id'], 'page');
if (($i + 1) == $end_item) {
$data1 .= "";
for ($n = 0; $n < $c_level; $n++) {
$data1 .= "";
}
} else if ($ddsg_data[$i + 1]['status'] != 'static') {
$data1 .= "";
for ($n = 0; $n < $c_level; $n++) {
$data1 .= "";
}
}
}
}
$data1 .= "
Seite " . $start_page . " von " . $total_pages;
if ($start_page == 2) {
$output1 .= ' : Vorherige';
} elseif ($start_page > 1) {
$output1 .= ' : Vorherige';
}
if ($start_page < $total_pages) {
$output1 .= ' : Nächste';
}
$output1 .= "
Seiten: ';
for ($i = 1; $i <= $total_pages; $i++) {
if ($i == $start_page) {
$output1 .= $i . " ";
} else {
if ($i == 1){
$output1 .= '' . $i . ' ';
} else{
$output1 .= '' . $i . ' ';
}
}
}
$output1 .= "
Seite ' . $start_page . ' von ' . $total_pages;
if ($start_page > 1) {
$output1 .= ' : Vorherige';
}
if ($start_page < $total_pages) {
$output1 .= ' : Nächste';
}
$output1 .= "
Seiten: ';
for ($i = 1; $i <= $total_pages; $i++) {
if ($i == $start_page) {
$output1 .= $i . " ";
} else {
$output1 .= '' . $i . ' ';
}
}
$output1 .= "
" . $nav_text;
}
// Show link to XML sitemap?
if (trim($ddsg_xml_path)) {
if (($ddsg_xml_where == 'every') OR ($start_page == $total_pages)) {
$the_output .= '';
}
}
$the_output .= 'sitemap plugin by dagondesign.com modified by seo-marketing-blog.de
';
return $the_output;
}
function ddsg_generate_sitemap($content) {
if (strpos($content, "")) {
$content_array = array();
$content_array = split("", $content);
$content_array[0] = rtrim(trim($content_array[0]), "");
$content_array[1] = ltrim(trim($content_array[1]), "
");
return ($content_array[0] . ddsg_create_sitemap() . $content_array[1]);
} else {
return $content;
}
}
add_filter('query_vars', 'ddsg_query_vars');
add_filter('rewrite_rules_array', 'ddsg_permalinks');
add_filter('the_content', 'ddsg_generate_sitemap');
add_action('admin_menu', 'ddsg_add_option_pages');
?>