All, back again! kind'a wondering if any one can give advice on another mod? that i want to intergrate??
Im using the drop in site map generator but its not listing the gallery images?
I think the code that would need to be changed so that it looks at the gallery is as follows. (I may be wrong i still trying to get my head round this stuff???)
Code: Select all
// This is our SQL query. In short, it gets the most recent topics that are in forums that are viewable to to public group (group 2) and then sorts them by how recently they've been posted in. The query is limited to the number of rows configured earlier in the script.
$sql = 'SELECT `'.$table_prefix.'topics`.`topic_id`, `'.$table_prefix.'topics`.`topic_last_post_time` FROM `'.$table_prefix.'topics` INNER JOIN `'.$table_prefix.'acl_groups` ON `'.$table_prefix.'topics`.`forum_id`=`'.$table_prefix.'acl_groups`.`forum_id` WHERE `'.$table_prefix.'acl_groups`.`group_id`=\'2\' AND `'.$table_prefix.'acl_groups`.`auth_option_id`=\'0\' ORDER BY `'.$table_prefix.'topics`.`topic_last_post_time` DESC LIMIT '.$PAGE_LIMIT;
And then i guess the code that outputs the url's to the sitemap would also need editing?
Code: Select all
//Begin printing out the sitemap.
$result=mysql_query($sql,$con);
while ($row = mysql_fetch_array($result)){?>
<url>
<loc><?php echo $PHPBB3_URL; ?>viewtopic.php?t=<?php echo "$row[topic_id]";?></loc>
<lastmod><?php echo date('Y-m-d\TH:i:s',$row[topic_last_post_time]).'-07:00';?></lastmod>
<changefreq>always</changefreq>
<priority><?php echo $PAGE_PRIORITY; ?></priority>
</url>
Any ideas anyone?
I can post the whole file if required? its only one file and not that big actually?
Many thanks
Andy