Page 3 of 3

Re: [BETA] BartVB SiteMap Generator

Posted: Tue May 20, 2008 2:56 am
by xenador
so im trying to get this working but no luck so far...list of changes from last posted one are only:

run via sql:
insert into phpbb_config (config_name, config_value) values ('sitemap_bot_user', '28508');
insert into phpbb_config (config_name, config_value) values ('sitemap_directory', 'sitemaps/');
if I want create a ./sitemaps/ directory chmoded to 777

and finally
open ./includes/sitemap_functions.php

Find:

Code: Select all

    $sql = 'SELECT *
                    FROM ' . USERS_TABLE . '
                    WHERE user_id = ' . intval($config['sitemap_bot_user']);

and replace with:

Code: Select all

$sql = 'SELECT *
                FROM ' . USERS_TABLE . '
                WHERE user_id = 28508' ;
correct? or was there something I missed...Im not using the seo mods and still throwing the same errors as the first couple users where, I am using the last one posted...about halfway down the page.

Re: [BETA] BartVB SiteMap Generator

Posted: Sun May 25, 2008 9:09 pm
by derDiesel
BartVB wrote:TODO (and I'm probably not going to do it :P)
[...]
- Automate generating the sitemaps
Jeah, pretty good idea! :D

Re: [BETA] BartVB SiteMap Generator

Posted: Sat May 31, 2008 2:22 pm
by TheMoustic
I've SEO MOD, I try that modification:

Code: Select all

insert into phpbb_config (config_name, config_value) values ('sitemap_bot_user', '1');
insert into phpbb_config (config_name, config_value) values ('sitemap_directory', 'sitemaps/');

Code: Select all

    <?php
    /**
    *
    * @package phpBB3
    * @version $Id: sitemap_functions.php 2007-11-26 Joshua2100 $
    * @copyright (c) 2007 Joshua www.commexcomputers.com
    * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    *
    */

    if (!defined('IN_PHPBB'))
    {
       exit;
    }
    // www.phpBB-SEO.com SEO TOOLKIT BEGIN
    if (empty($phpbb_seo) ) {
       require_once($phpbb_root_path . 'phpbb_seo/phpbb_seo_class.'.$phpEx);
       $phpbb_seo = new phpbb_seo();
    }
    // www.phpBB-SEO.com SEO TOOLKIT END
    // start
    function clean_for_xml($string)
    {
       // www.phpBB-SEO.com SEO TOOLKIT BEGIN
       global $phpbb_seo;
       return $phpbb_seo->format_url($string);
       // www.phpBB-SEO.com SEO TOOLKIT END
    }
    

Code: Select all

$sql = 'SELECT *
                FROM ' . USERS_TABLE . '
                WHERE user_id = 1' ;   

Code: Select all

cleaned out the bot_auth stuff.
                $f_xml .= '<loc>' . $board_url . "viewtopic.$phpEx?t=" . $row['topic_id'] . "</loc>\n";   
And clear out:

Code: Select all

       $bot_userdata = $db->sql_fetchrow($result);
       $bot_auth = new Auth();
       $bot_auth->acl($bot_userdata);   
and:

Code: Select all

       $bot_no_access = array();
       $bot_forum_auth_ary = $bot_auth->acl_getf('!f_read');
       foreach ($bot_forum_auth_ary as $forum_id => $not_allowed)
       {
          if ($not_allowed['f_read'])
          {
             $bot_no_access[] = (int) $forum_id;
          }
       }
   
But when I click on: Run now, I've:

Code: Select all

Fatal error: Using $this when not in object context in (...)/includes/sitemap_functions.php on line 102
Which is:

Code: Select all

            if (!function_exists('clean_url'))
            {
                trigger_error($user->lang['SEO_NOT_INT'] . adm_back_link($this->u_action), E_USER_WARNING);
            }  

Re: [BETA] BartVB SiteMap Generator

Posted: Thu Jun 05, 2008 2:53 pm
by desertst0rm
After clicking the Run Now button I'm getting this message "Unable to open sitemaps/sitemap_forums.xml for writing"

Re: [BETA] BartVB SiteMap Generator

Posted: Thu Jun 05, 2008 3:18 pm
by MikeShinoda
check the chmod permission

Re: [BETA] BartVB SiteMap Generator

Posted: Sun Jul 13, 2008 12:54 pm
by derDiesel
Hey,
any idea to rebuild the sitemap via cron-task automatically?

thx :)

Re: [BETA] BartVB SiteMap Generator

Posted: Sun Jan 18, 2009 10:53 pm
by denis4o
Any idea how long does it take google to index 2100 URL's from the sitemap? It indexed only 4 out of 2100 in a month. I'm so screwed with my rank now ...