SEO for pligg CMS

-------------------------------------------------------------------------------------
WebCEO helps you run all of your search engine optimization efforts.
-------------------------------------------------------------------------------------

Pligg evolved from code from the site mename. It allows you to make a site similar to Digg where users can rate web pages. However, Pligg can be used for almost any type of article web site. Customizing the templates and getting your site customized has proven to be a chore for many of its users though.

Pros: Very flexible. Simple to edit and learn.
Cons: Low on features. Hard to find templates or modules.

My pligg site: Slovenian digg

Update to 9.9.5. Its first SEO friendly version of pligg cms system.
Download: http://forums.pligg.com/attachments/current-version/1509d1217929605-pligg-beta-9-9-5-pligg-beta-9.9.5.zip

Keywords
Put your top keywords into tags & categories!

Participate! Don't just submit your own links and then disappear. I know I'm guilty of this myself at a few places, but it really is in your best interest to get involved with these bookmarking communities that have relevant themes and niches. Popular members can get high PR profiles, and people are more likely to check out your articles and links. Of course, the key to any successful submission is that the content fits the need of the group. It is a democracy after all, and any good SEO needs to keep that in mind when working with web 2.0.

Download & install: http://patchlog.com/wp-content/uploads/2008/04/xml_sitemaps-0.9.zip

After installation you should be able to access the sitemap index like this : http://yourdomain.com/module.php?module=xml_sitemaps_show_sitemap or if you want the sitemap to look friendly ( btw ask.com will only accept a friendly sitemap ending in .xml ) , you just have to go into Admin->Configuration->XmlSitemaps and enable "Sitemap Friendly URL", and if you do that then you have to put the following lines in your .htaccess somewhere before the line "##### URL Method 2 ("Clean" URLs) Begin #####" :

RewriteRule ^sitemapindex.xml module.php?module=xml_sitemaps_show_sitemap [L]
RewriteRule ^sitemap-([a-zA-Z0-9]+).xml module.php?module=xml_sitemaps_show_sitemap&i=$1 [L]

After that put the following line into robots.txt:
Sitemap: http://www.yourdomain.com/sitemapindex.xml

Submit your sitemap to:
Google: http://www.google.com/webmasters/
Yahoo: http://siteexplorer.search.yahoo.com/
MSN: http://webmaster.live.com/

--- page_statistics_main.php Wed Apr 18 21:36:46 2007
+++ page_statistics_main_orig.php Fri May 25 22:21:03 2007
@@ -10,14 +10,16 @@
$main_smarty = do_sidebar($main_smarty);

$offset = (get_current_page()-1)*$page_size;
- $rows = $db->get_var("SELECT count(*) FROM ".table_pageviews.",".table_links." WHERE `pv_type`='story' AND link_id IN(SELECT DISTINCT link_id FROM ".table_links." WHERE link_id=pv_page_id)");

- $sql = mysql_query("SELECT link_title,link_url,link_id,pv_page_id,count(*) views FROM ".table_pageviews.",".table_links." WHERE `pv_type`='story' AND link_id IN(SELECT DISTINCT link_id FROM ".table_links." WHERE link_id=pv_page_id) GROUP BY `pv_page_id` ORDER BY views DESC LIMIT $offset,$page_size");
+ $sql = mysql_query("SELECT SQL_CALC_FOUND_ROWS left(link_title, 40) as link_title,link_url,link_id,pv_page_id,count(*) views from ".table_pageviews." left join ".table_links." on (link_id=pv_page_id) WHERE pv_type='story' GROUP BY pv_page_id ORDER BY views DESC LIMIT $offset,$page_size");

+
$stats = array();

while ($row = mysql_fetch_array($sql, MYSQL_ASSOC)) array_push ($stats, $row);
$main_smarty->assign('stats', $stats);

+ $rows = $db->get_var("SELECT FOUND_ROWS()");
+
// breadcrumbs
$navwhere['text1'] = "Page Statistics";
$main_smarty->assign('navbar_where', $navwhere);

Working "related links" function (/libs/html1.php).

function related_stories($storyid, $related_tags, $category){
// this returns similar stories based on tags in common and in the same category
global $db;
$related_tags="'".str_replace(",","', '",addslashes($related_tags))."'"; // This gives us the proper string structure for IN SQL statement

// Select 10 stories that share tags with the current story and order them by number of tags they share
$sql = "SELECT ".table_links.".link_title, ".table_links.".link_title_url, COUNT( ".table_tags.".tag_link_id ) AS relevance, ".table_tags.".tag_link_id FROM ".table_tags.", ".table_links." WHERE ".table_tags.".tag_words IN ( ".$related_tags." ) AND ".table_tags.".tag_link_id = ".table_links.".link_id AND ".table_links.".link_status != 'discard' AND ".table_links.".link_id != ".$storyid;
$sql.= " GROUP BY ".table_tags.".tag_link_id, ".table_links.".link_title, ".table_links.".link_title_url ORDER BY relevance DESC LIMIT 10";

$related_story = $db->get_results($sql);
$related_story = object_2_array($related_story);
return $related_story;
}

User-agent: *
#Crawl-delay: 5
Disallow: /templates_c/
Disallow: /templates/
Disallow: /3rdparty/
Disallow: /libs/
Disallow: /modules/
Disallow: /plugins/
Disallow: /internal/
Disallow: /backup/
Disallow: /thickbox/
Disallow: /api/
Disallow: /evb/
Disallow: /avatars/
Disallow: /admin_index.php
Disallow: /admin
Disallow: /js/
Disallow: /img/
Sitemap: http://www.yourdomain.com/sitemapindex.xml