[risolto] Sitemap per phpBB

fabrizio77

Rispondo qua invece di aprire un altro topic perche mi pare quello giusto...
Allora ho fatto i procedimenti per la sitemap usando questa procedura http://www.giorgiotave.it/wikigt/os/Sitemap_per_PhpBB ho fatto l upload a google sitemap e ha accettato la sitemap ma poi al momento della verifica dice che il formato della suddetta sitemap non è accettato. Non so se il problema dipende dal rewrite delle url. Il mio file .htacess è il seguente:
Options +FollowSymlinks
RewriteEngine On
#RewriteBase /forum/

RewriteRule [.]-vf([0-9]) viewforum.php?%{QUERY_STRING}&f=$1
RewriteRule [.]-vp([0-9]) viewtopic.php?%{QUERY_STRING}&p=$1
RewriteRule [.]-vt([0-9]) viewtopic.php?%{QUERY_STRING}&t=$1
RewriteRule ^mapforum.xml$ mapforum.php
RewriteRule ^forum-([0-9]+).xml$ mapforum.php?fid=$1

Qualche idea? PS Yahoo sembra aver accettato la sitemap

cionfs

@fabrizio77 said:

Options +FollowSymlinks
RewriteEngine On
#RewriteBase /forum/

RewriteRule [.]-vf([0-9]) viewforum.php?%{QUERY_STRING}&f=$1
RewriteRule [.]-vp([0-9]) viewtopic.php?%{QUERY_STRING}&p=$1
RewriteRule [.]-vt([0-9]) viewtopic.php?%{QUERY_STRING}&t=$1
RewriteRule ^mapforum.xml$ mapforum.php
RewriteRule ^forum-([0-9]+).xml$ mapforum.php?fid=$1

Qualche idea? PS Yahoo sembra aver accettato la sitemap

Leva il # da RewriteBase /forum/

Devi avere

Options +FollowSymlinks
RewriteEngine On
RewriteBase /forum/

RewriteRule [.]-vf([0-9]) viewforum.php?%{QUERY_STRING}&f=$1
RewriteRule [.]-vp([0-9]) viewtopic.php?%{QUERY_STRING}&p=$1
RewriteRule [.]-vt([0-9]) viewtopic.php?%{QUERY_STRING}&t=$1
RewriteRule ^mapforum.xml$ mapforum.php
RewriteRule ^forum-([0-9]+).xml$ mapforum.php?fid=$1

fabrizio77

ok provvedo e poi appena google mi dice qualcosa ti faccio sapere!!!

fabrizio77

Niente da fare
Google dice: Formato file non supportato
Il file Sitemap non è in un formato supportato. Verifica che risponda alle nostre Norme Sitemap e reinvia.
La pg mapforum.php mi da':

Warning: main(./forum/extension.inc): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(): Failed opening './forum/extension.inc' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(./forum/common.): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112

Warning: main(): Failed opening './forum/common.' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112
http://www.karima-ammar.comforum-65535.xml 1969-12-31
Warning: mysql_query(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_query(): A link to the server could not be established in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line **166

Forse è nel databse l errore?
**

cionfs

Prova a dare al file mapforum.php i permessi chmod 777 se non li hai dati. Inoltre hai segnalato a google il file mapforum.xml?

fabrizio77

Allora i permessi non li aveva e glieli ho dati
duuque io a google ho dato questo indirizzo: www.miosito.com/forum/mapforum.xml
il file xml pero io non l ho creato, pensavo facesso tutto in automatico o no?
scusa ma sono un po duro con ste cose!

cionfs

lui identifica il file mapforum.php come mapforum.xml per il rewrite.

Sei andato su google>strumenti per webmaster?

Segnala http://www.miosito.com/forum/mapforum.xml con http:// prima

fabrizio77

si ho segnalato l url sia in addurl che nella sezione dei webmasters dove ho l account. Gli errori pero ci sono sempre

Warning: main(./forum/extension.inc): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(): Failed opening './forum/extension.inc' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(./forum/common.): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112

Warning: main(): Failed opening './forum/common.' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112
http://www.karima-ammar.comforum-65535.xml 1969-12-31
Warning: mysql_query(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_query(): A link to the server could not be established in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 166

cionfs

Mi spiace ma non so come poterti aiutare a questo punto. Aspettiamo e vediamo se qualcun'altro sa qualcosa

fabrizio77

ok

pandasp

In mapforum.php prova a cambiare

$phpbb_root_path = './forum/';

in

$phpbb_root_path = '/forum/';

In pratica ho tolto un punto

fabrizio77

va bene
grazie del consiglio, provo anche questa

fabrizio77

Guardavo anche questa riga...

define('PHPBB_PREFIX', 'phpbb_'); // Your phpBB tables prefix, WITHOUT the _ character.

dice without _ allora dovrei mettere phpbb invece di phpbb_ ?

cionfs

@fabrizio77 said:

Guardavo anche questa riga...

define('PHPBB_PREFIX', 'phpbb_'); // Your phpBB tables prefix, WITHOUT the _ character.

dice without _ allora dovrei mettere phpbb invece di phpbb_ ?

Si, non l'avevi fatto?

fabrizio77

no l ho notato ora... perche cmq il prefisso è phpbb_
adesso l ho tolto e ho messo: define('PHPBB_PREFIX', 'phpbb');
speriamo funzioni!

fabrizio77

ma se vado qui: http://www.sito.com/forum/mapforum.php dovrei vedere qualcosa in particolare? solo errori

pandasp

@fabrizio77 said:

ma se vado qui: http://www.sito.com/forum/mapforum.php dovrei vedere qualcosa in particolare? solo errori

http://www.sito.com/forum/mapforum.xml
dovresti vedere quello che dovrebbe vedere google

Se ti da errori ci sono ancora problemi

Che errori ti da?

fabrizio77

Warning: main(/forum/extension.inc): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(): Failed opening '/forum/extension.inc' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(/forum/common.): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112

Warning: main(): Failed opening '/forum/common.' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112
http://www.karima-ammar.comforum-65535.xml 1969-12-31
Warning: mysql_query(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_query(): A link to the server could not be established in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line **166

questo è quello che dice ho provato a fare come avete detto e ho corretto quella riga che io avevo sbagliato a non correggere! per il resto non so.. fors eil mio mapforum.php è sbagliato?
**

cionfs

@fabrizio77 said:

Warning: main(/forum/extension.inc): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(/forum/extension.inc): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(): Failed opening '/forum/extension.inc' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 111

Warning: main(/forum/common.): failed to open stream: No such file or directory in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112

Warning: main(): Failed opening '/forum/common.' for inclusion (include_path='.:/usr/local/lib/php') in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 112
http://www.karima-ammar.comforum-65535.xml 1969-12-31
Warning: mysql_query(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_query(): A link to the server could not be established in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line 165

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/content/f/a/b/fabrizio77/html/forum/mapforum.php on line **166

questo è quello che dice ho provato a fare come avete detto e ho corretto quella riga che io avevo sbagliato a non correggere! per il resto non so.. fors eil mio mapforum.php è sbagliato?
**

Posta il mapforum.php

Ora che ho rivisto il mio mapforum.php e le righe con gli errori sembra che ci sia un problema com mysql... che versione di mysql hai? 4 o 5?

fabrizio77

ecco qui:
function make_url_friendly($url)
{

$url = strtolower($url);

$find = array(' ',
        '&',
        '\r\n',
        '\n',
        '/',
        '\\',
        '+');

$url = str_replace ($find, '-', $url);

$find = array(' ',
        'é',
        'è',
        'ë',
        'ê');

$url = str_replace ($find, 'e', $url);

$find = array(' ',
        'ó',
        'ò',
        'ô',
        'ö');

$url = str_replace ($find, 'o', $url);

$find = array(' ',
        'á',
        'à',
        'â',
        'ä');

$url = str_replace ($find, 'a', $url);

$find = array(' ',
        'í',
        'ì',
        'î',
        'ï');

$url = str_replace ($find, 'i', $url);

$find = array(' ',
        'ú',
        'ù',
        'û',
        'ü');

$url = str_replace ($find, 'u', $url);

$find = array('/[^a-z0-9\-<>]/',
        '/[\-]+/',
        '/<[^>]*>/');

$repl = array('',
        '-',
        '');

$url =  preg_replace ($find, $repl, $url);

return $url;

}

// Some configuration options!
define('FORUM_DOMAIN_ROOT', 'http://www.karima-ammar.com'); // Full URL with trailing slash!

define('FORUM_URL_PREFIX', '-vf'); // What comes up before the forum ID?
define('FORUM_URL_SUFFIX', '.html'); // What comes up after the forum ID?
define('THREAD_URL_PREFIX', '-vt'); // What comes up before the thread ID?
define('THREAD_URL_SUFFIX', '.html'); // What comes up after the thread ID?

define('PHPBB_PREFIX', 'phpbb'); // Your phpBB tables prefix, WITHOUT the _ character.

// --------------------------------------------------
// You don't need to edit anything below this line!!!
// --------------------------------------------------

define('IN_PHPBB', true);
$phpbb_root_path = '/forum/';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

if ($_GET['fid']) { $fid = $_GET['fid']; }

// Sitemap File <sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.84">
// URL Index File <urlset xmlns="http://www.google.com/schemas/sitemap/0.84">';
if (isset($fid)) {
echo '<?xml version="1.0" encoding="UTF-8"?>'."\n";
if ($fid == '65535') {
// Let's first send out the header & homepage
echo ' <urlset xmlns="http://www.google.com/schemas/sitemap/0.84">'."\n";
echo ' <url>
<loc>'.FORUM_DOMAIN_ROOT.'</loc>
<changefreq>daily</changefreq>
</url>';
// Let's send out a URL list of forums
$sql = 'SELECT forum_id, forum_name FROM '.PHPBB_PREFIX.'forums WHERE auth_view = "0" and auth_read = "0" and forum_id not like "%-%"';
$result = mysql_query($sql);
while ($data = mysql_fetch_assoc($result)) {
echo ' <url>
<loc>'.FORUM_DOMAIN_ROOT.make_url_friendly($data['forum_name']).FORUM_URL_PREFIX.$data['forum_id'].FORUM_URL_SUFFIX.'</loc>
<changefreq>daily</changefreq>
</url>';
}
echo ' </urlset>';
} else {
// Let's check it's not a restricted forum
$sql = 'SELECT forum_id FROM '.PHPBB_PREFIX.'forums WHERE auth_view = "0" and auth_read = "0" and forum_id = "'.$fid.'" and forum_id not like "%-%"';
$result = mysql_query($sql);
$data = mysql_fetch_assoc($result);
if ($data['forum_id'] == $fid) {
echo ' <urlset xmlns="http://www.google.com/schemas/sitemap/0.84">'."\n";
$sql = 'SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM '.PHPBB_PREFIX.'topics t, '.PHPBB_PREFIX.'users u, '.PHPBB_PREFIX.'posts p, '.PHPBB_PREFIX.'posts p2, '.PHPBB_PREFIX.'users u2 WHERE t.forum_id = '.$fid.' AND t.topic_poster = u.user_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id ORDER BY t.topic_type DESC, t.topic_last_post_id DESC';
$result = mysql_query($sql);
while ($data = mysql_fetch_assoc($result)) {
echo ' <url>
<loc>'.FORUM_DOMAIN_ROOT.make_url_friendly($data['topic_title']).THREAD_URL_PREFIX.$data['topic_id'].THREAD_URL_SUFFIX.'</loc>
<lastmod>'.date('Y-m-d', $data['post_time']),'</lastmod>
</url>';
}
echo ' </urlset>';
}
}
} else {
echo '<?xml version="1.0" encoding="UTF-8"?>'."\n";
echo ' <sitemapindex xmlns="http://www.google.com/schemas/sitemap/0.84">'."\n";
// Let's create a link to the main forum index sitemap
echo ' <sitemap>
<loc>'.str_replace("forum/", "", FORUM_DOMAIN_ROOT).'forum-65535.xml</loc>
<lastmod>'.date('Y-m-d', $data['post_time']),'</lastmod>
</sitemap>';
// Let's do a loop here and list all the forums!
$sql = 'SELECT forum_id FROM '.PHPBB_PREFIX.'forums WHERE auth_view = "0" and auth_read = "0" and forum_id not like "%-%"';
$result = mysql_query($sql);
while ($data = mysql_fetch_assoc($result)) {
echo ' <sitemap>
<loc>'.str_replace("forum/", "", FORUM_DOMAIN_ROOT).'forum-'.$data['forum_id'].'.xml</loc>
<lastmod>'.date('Y-m-d', $data['post_time']),'</lastmod>
</sitemap>';
}
echo "\n".' </sitemapindex>';
}

?>

il database è 4, grazie per le risposte raga'