Sitemap for SMF (acceptable for Google Webmasters)

By: Unknown on 06:52

Print It

Hi all,

A former mod of Sitemap for SMF does not get accepted by Google Webmasters Site when I want to submit it, because it has no acceptable file format for spiders to access. Its something like this http://yoursite.com/index.php?action=kitsitemap;xml

Now a coded a piece of PHP to create a sitemap containing boards and topic links only and acceptable by Google, just copy the below code and save as sitemap.php

1. <?php
2. /*
3. Sitemap for SMF written by DON JAJO
4. http://2netlodge.com
5. */
6. $dbhost = "";//your database host, usually "localhost" in many servers
7. $dbname = "";// your SMF database name
8. $dbuser = "";// your SMF database user or username
9. $dbpwd = "";// your SMF database password
10. $siteurl = "http://yoursite.com/";// your site URL with trailing slash (eg http://yoursite.com/)
12. //Connection to database done!
13. $connect = mysql_connect($dbhost,$dbuser,$dbpwd)or die(mysql_error());
14. //I selected database name
15. mysql_select_db($dbname);
17. //Configuring headers
18. header("Content-type: text/xml");
19. echo<?xml version=1.0 encoding=UTF-8?>';
20. echo' <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">';
21. ?>
23. <?php
24. //querying for board ids in the database
25. $boards = mysql_query("select * from smf_boards")or die(mysql_error());
26. while($row = mysql_fetch_array($boards))
27. {
28. $boardid = $row['id_board'];
30. //Outputing
31. ?>
32. <url>
33. <loc><?=$siteurl?>index.php?board=<?=$boardid?>.0</loc>
34. </url>
35. <?php
36. }
38. //querying for topic ids in the database
39. $topics = mysql_query("select * from smf_topics")or die(mysql_error());
40. while($row2 = mysql_fetch_array($topics))
41. {
42. $topicid = $row2['id_topic'];
44. //Outputing
45. ?>
46. <url>
47. <loc><?=$siteurl?>index.php?topic=<?=$topicid?>.0</loc>
48. </url>
49. <?php
50. }
51. ?>
53. </urlset>

Edit the Mysql details and save

NOTE: If your table prefix is not smf_ please change it from the query

I don't know how to create SMF mod, I would have created a mod for it

Run http://yoursite.com/sitemap.php
Hope it helps!