• Registered: 2006-07-31
  • Posts: 254

Re: Google Sitemaps

I have just tried to run the google sitemap plugin and noticed some problems with it.

It is listing everything, even if you have boards set for viewing by admin/moderators. Any chance of upgrading it to hide those from the listing?

my mind is on a permanent tangent
byUsers forum
  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Google Sitemaps

*checks*

SELECT t.id as topic_id, last_post, sticky, num_replies FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=t.forum_id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL ORDER BY last_post DESC

I'm only checking forums that guests have the ability to see in an unmodded version of PunBB. wink
If you've modded your forum to use some other permissions system, you'll need to modify the query as well

  • Registered: 2006-07-31
  • Posts: 254

Re: Google Sitemaps

note to self: when querying that something is incorrect  assume I am wrong and double check everything first.

aye my bad - checked on local copy that didn't have all the permissions altered *sigh* I will get there one day!

my mind is on a permanent tangent
byUsers forum