phpBB mod Rewrite : [solved] configure htaccess file for simple rewrite mod

[solved] configure htaccess file for simple rewrite mod

phpBB SEO » SEO Forum » phpBB mod Rewrite

Author

Message

AmirAbbas
phpBB SEO Team

Joined: 11 May 2006
Posts: 529
Location: IRAN

Posted: Fri May 26, 2006 3:14 pm Post subject: [solved] configure htaccess file for simple rewrite mod

i have installed phpbb seo simple rewrite mod on my forum
i have a question
i the install file there is a htaccess command

Code:

but this code doesn't work on my forum
i changed this code to this form

Code:

at this time its work
i have installed mx_ggsitemap and mx_sitemap
both of these code have some htaccess command
i've added all of this command at the end of htaccess file
at this time my htaccess file is like this

Code:

# These three lines should only be added if not already done in the .htaccess
Options +FollowSymlinks
RewriteEngine On
RewriteBase /forum/

#########################################################
# PHPBB SEO REWRITE RULES          #
#########################################################
# AUTHOR : DCZ http://www.phpbb-seo.com/
# STARTED : 01/2006
#####################################################
# FORUMS PAGES
########################
# CATEGORIES
RewriteRule ^cat([0-9]+)\.html$ /index.php?c=$1 [QSA,L]
# PAGINATED FORUM
RewriteRule ^forum([0-9]+)-([0-9]+)\.html$ /viewforum.php?f=$1&start=$2 [QSA,L]
# FORUM
RewriteRule ^forum([0-9]+)\.html$ /viewforum.php?f=$1 [QSA,L]
# PAGINATED TOPIC
RewriteRule ^topic([0-9]+)-([0-9]+)\.html$ /viewtopic.php?t=$1&start=$2 [QSA,L]
# TOPIC
RewriteRule ^topic([0-9]+)\.html$ /viewtopic.php?t=$1 [QSA,L]
# POST
RewriteRule ^post([0-9]+)\.html$ /viewtopic.php?p=$1 [QSA,L]
#PROFILES
RewriteRule ^member([0-9]+)\.html$ /profile.php?mode=viewprofile&u=$1 [QSA,L]
# END PHPBB PAGES
#####################################################
#########################################################
# MX SITEMAPS REWRITE RULES          #
#########################################################
# AUTHOR : dcz http://www.phpbb-seo.com/
# STARTED : 2006/04/28
########################

Options +FollowSymlinks
RewriteEngine on
RewriteBase /forum/

########################################################
RewriteRule ^sitemaps([0-9]+)\.html$ /sitemaps.php?c=$1 [QSA,L]
RewriteRule ^sitemaps\.html$ /sitemaps.php [QSA,L]
RewriteRule ^forum-m\ap\.html$ /sitemaps.php?fim [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)-([0-9]+)\.html$ /sitemaps.php?fmp=$1&start=$2 [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)\.html$ /sitemaps.php?fmp=$1 [QSA,L]
#########################################################
# END SITEMAPS REWRITE RULES          #
#########################################################
#########################################################
# MX GG_SITEMAPS REWRITE RULES          #
#########################################################
# AUTHOR : dcz http://www.phpbb-seo.com/
# STARTED : 2006/02/22
########################

Options +FollowSymlinks
RewriteEngine on
RewriteBase /forum/

########################################################

RewriteRule ^sitemaps.xml$ /sitemap.php [L]
RewriteRule ^mx-sitemap.xml$ /sitemap.php?mx [L]
RewriteRule ^forum-sitemap-([0-9]+).xml$ /sitemap.php?fid=$1 [L]
RewriteRule ^kb-sitemap-([0-9]+).xml$ /sitemap.php?kbid=$1 [L]
RewriteRule ^sitemap-forum.xml$ /sitemap.php?forum [L]
RewriteRule ^sitemap-kbcat.xml$ /sitemap.php?kbcat [L]

#########################################################
# END GG_SITEMAPS REWRITE RULES          #
#########################################################

i think its work for me. is this change correct ?

this is address of my forum

http://forum.amuzesh.org

i think the license of your code is defferent and i must keep your
link at page footer. i added your link
because i need your support

Last edited by AmirAbbas on Sat May 27, 2006 8:44 am; edited 1 time in total

dcz
Administrateur - Site Admin

Joined: 28 Apr 2006
Posts: 15131

Posted: Fri May 26, 2006 11:49 pm Post subject: Re: need help to configure htaccess file for simple rewrite

amir abbas wrote:

i have installed phpbb seo simple rewrite mod on my forum
i have a question is this change correct ?

Well, it works, but you should only use once :

Code:

# These three lines should only be added if not already done in the .htaccess
Options +FollowSymlinks
RewriteEngine On
RewriteBase /

And you did not change phpbb/ with your actual folder name Wink

And you have installed phpBB in a sub domain.

So in the end, if I understood well you settings, you should put the rewriterules for the forum in the "forum/" (according to what you posted it's where phpBB is intstalled) folder, which is phpBB root and the sub domain root as well. Here, we do not care any more about the main domain. So it should look like :

Code:

# These three lines should only be added if not already done in the .htaccess
Options +FollowSymlinks
RewriteEngine On
RewriteBase /

#########################################################
# PHPBB SEO REWRITE RULES          #
#########################################################
# AUTHOR : DCZ http://www.phpbb-seo.com/
# STARTED : 01/2006
#####################################################
# FORUMS PAGES
########################
# CATEGORIES
RewriteRule ^cat([0-9]+)\.html$ /index.php?c=$1 [QSA,L]
# PAGINATED FORUM
RewriteRule ^forum([0-9]+)-([0-9]+)\.html$ /viewforum.php?f=$1&start=$2 [QSA,L]
# FORUM
RewriteRule ^forum([0-9]+)\.html$ /viewforum.php?f=$1 [QSA,L]
# PAGINATED TOPIC
RewriteRule ^topic([0-9]+)-([0-9]+)\.html$ /viewtopic.php?t=$1&start=$2 [QSA,L]
# TOPIC
RewriteRule ^topic([0-9]+)\.html$ /viewtopic.php?t=$1 [QSA,L]
# POST
RewriteRule ^post([0-9]+)\.html$ /viewtopic.php?p=$1 [QSA,L]
#PROFILES
RewriteRule ^member([0-9]+)\.html$ /profile.php?mode=viewprofile&u=$1 [QSA,L]
# END PHPBB PAGES
#########################################################
# MX SITEMAPS REWRITE RULES          #
#########################################################
RewriteRule ^sitemaps([0-9]+)\.html$ /sitemaps.php?c=$1 [QSA,L]
RewriteRule ^sitemaps\.html$ /sitemaps.php [QSA,L]
RewriteRule ^forum-m\ap\.html$ /sitemaps.php?fim [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)-([0-9]+)\.html$ /sitemaps.php?fmp=$1&start=$2 [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)\.html$ /sitemaps.php?fmp=$1 [QSA,L]
#########################################################
# MX GG_SITEMAPS REWRITE RULES          #
#########################################################
RewriteRule ^sitemaps.xml$ /sitemap.php [L]
RewriteRule ^mx-sitemap.xml$ /sitemap.php?mx [L]
RewriteRule ^forum-sitemap-([0-9]+).xml$ /sitemap.php?fid=$1 [L]
RewriteRule ^kb-sitemap-([0-9]+).xml$ /sitemap.php?kbid=$1 [L]
RewriteRule ^sitemap-forum.xml$ /sitemap.php?forum [L]
RewriteRule ^sitemap-kbcat.xml$ /sitemap.php?kbcat [L]
#########################################################
# END GG_SITEMAPS REWRITE RULES          #
#########################################################

Then, you only need the mx gg sitemap and mx sitemap rewriterule if you actually use the mod rewrite for them.

The mod rewrite for the mx sitemaps is a very good Search Engine Optimization (SEO), it just cosmetic for Google sitemaps (will not SEO nothing Wink

)

You may encounter some small issues with the RewriteRules order if you activate mod rewrite for sitemaps (both of them) for the forum maps (and Google maps) url. If so, just put the sitemaps rewriterule containing "forum" before the phpBB ones.

To test, just upload this .htaccess, make sure it works for the forum, and go to ACP and activate mod rewrite in mx Sitemaps ACP (goole alos if you like cosmetic Wink

) and test them. They shoudl work Very Happy

Then, they both work nicely, but I noticed you server experiments difficulties to output your biggest forum's topics listing. It looks like you do not have a lot of resources dedicated to your forum, so you should start playing with mx Google sitemaps settings, limiting a bit more pagination, outputted url and sql cycle.

Also, it seems you installed the phpbbstyles.com sql cache mod, so please open all of the mx sitemaps files located in the includes/ phpBB folder, you will see that the code is already ready to use the sql cache mod, search for sql queries (not that much) and you will see that you just need to comment the regular phpBB if query ok and uncomment the sql cache one just undernief Wink

This way the code will be faster Wink

Then, take a look at this for the auto linking to the mx sitemaps mod Wink

amir abbas wrote:

i think the license of your code is different and i must keep your
link at page footer. i added your link
because i need your support

Actually, you have many choice to give a bit back to the community that will grow here. I mean, with phpBB you give a link per page to phpBB, which is very normal I think, and then one more for the style in many cases, which is beginning to be a bit more of a gift than for phpBB itself IMHO. I am not saying a style is not a great part of a forum success, but, just a bit less important than phpBB itself I think, even though a link per page is not that much of a deal.
Then, you eventually add one more link for the translation, which I think is again a greater gift than the one being made to phpBB, because if the language is a very important matter, the translations are usually very standard, and in many cases, you have different versions.

What the phpBB SEO effort will offer to your web site is an overall Search Engine Optimisation, and even much more when the site will really start to host SEO chat. In comparison with not doing any SEO on your forum, the results will be very important.

It not that obvious to see right now, but wait for two more Google dance and thing will become clearer. I did not start all this without proven results Wink

So I think at least a link on a good quality page is really fare. The RPL licence is still open source, you can mod it and use it as you want as long as you do not pretend to be the author nor remove the copyrights. And it only concern the mod rewrite.

I really believe we can built up here a really interesting SEO community, which will really share codes, and this is I think, something we can all take advantage of, and worth some linking.

Of course, the idea here is not to go to court every other day, it's just very true that not following these requirements will jeopardise support here and thus the tools you are using and that will for sure help you Wink

_________________
Useful links :
SEO Forum || SEO Directory || SEO phpBB || SEO phpBB3 || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Référencement phpBB3 || Recherche

AmirAbbas
phpBB SEO Team

Joined: 11 May 2006
Posts: 529
Location: IRAN

Posted: Sat May 27, 2006 7:14 am Post subject: Re: [solved] configure htaccess file for simple rewrite mod

first thank you for yor detailed reply
second, forgive me for my poor english Razz

i had a lot of mistake in my post

ok
i read your reply
at first about rewrite rules
i have installed phpbb in subdomain. i have made a sub domain with name forum and i have
installed phpbb in root of this folder
i test this code

Code:

# These three lines should only be added if not already done in the .htaccess
Options +FollowSymlinks
RewriteEngine On
RewriteBase /

#########################################################
# PHPBB SEO REWRITE RULES #
#########################################################
# AUTHOR : DCZ http://www.phpbb-seo.com/
# STARTED : 01/2006
#####################################################
# FORUMS PAGES
########################
# CATEGORIES
RewriteRule ^cat([0-9]+)\.html$ /index.php?c=$1 [QSA,L]
# PAGINATED FORUM
RewriteRule ^forum([0-9]+)-([0-9]+)\.html$ /viewforum.php?f=$1&start=$2 [QSA,L]
# FORUM
RewriteRule ^forum([0-9]+)\.html$ /viewforum.php?f=$1 [QSA,L]
# PAGINATED TOPIC
RewriteRule ^topic([0-9]+)-([0-9]+)\.html$ /viewtopic.php?t=$1&start=$2 [QSA,L]
# TOPIC
RewriteRule ^topic([0-9]+)\.html$ /viewtopic.php?t=$1 [QSA,L]
# POST
RewriteRule ^post([0-9]+)\.html$ /viewtopic.php?p=$1 [QSA,L]
#PROFILES
RewriteRule ^member([0-9]+)\.html$ /profile.php?mode=viewprofile&u=$1 [QSA,L]
# END PHPBB PAGES
#########################################################
# MX SITEMAPS REWRITE RULES #
#########################################################
RewriteRule ^sitemaps([0-9]+)\.html$ /sitemaps.php?c=$1 [QSA,L]
RewriteRule ^sitemaps\.html$ /sitemaps.php [QSA,L]
RewriteRule ^forum-m\ap\.html$ /sitemaps.php?fim [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)-([0-9]+)\.html$ /sitemaps.php?fmp=$1&start=$2 [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)\.html$ /sitemaps.php?fmp=$1 [QSA,L]
#########################################################
# MX GG_SITEMAPS REWRITE RULES #
#########################################################
RewriteRule ^sitemaps.xml$ /sitemap.php [L]
RewriteRule ^mx-sitemap.xml$ /sitemap.php?mx [L]
RewriteRule ^forum-sitemap-([0-9]+).xml$ /sitemap.php?fid=$1 [L]
RewriteRule ^kb-sitemap-([0-9]+).xml$ /sitemap.php?kbid=$1 [L]
RewriteRule ^sitemap-forum.xml$ /sitemap.php?forum [L]
RewriteRule ^sitemap-kbcat.xml$ /sitemap.php?kbcat [L]
#########################################################
# END GG_SITEMAPS REWRITE RULES #
#########################################################

it works for me
thanks

and another thing

Quote:

You may encounter some small issues with the RewriteRules order if you activate mod rewrite for

sitemaps (both of them) for the forum maps (and Google maps) url. If so, just put the sitemaps

rewriterule containing "forum" before the phpBB ones.

excuse me, i couldn't understand this part

and

Quote:

so you should start playing with mx Google sitemaps settings, limiting a bit more pagination,

outputted url and sql cycle.

you mean that i must edit default values. could you suggest this values ?

Quote:

Also, it seems you installed the phpbbstyles.com sql cache mod, so please open all of the mx sitemaps files located in the includes/ phpBB folder, you will see that the code is already ready to use the sql cache mod, search for sql queries (not that much) and you will see that you just need to comment the regular phpBB if query ok and uncomment the sql cache one just undernief

yes i have installed sql cache mod
you mean that i must open all of seven mx sitemap files in include folder
and edit this files ?

i searched those files
i found this parts of codes

Code:

// Pull all config data
   $sql = "SELECT * FROM " . SITEMAPS_CONFIG_TABLE;
   //Begin sql cache
   //if ( !$result = $db->sql_query( $sql ) )
   if( !($result = $db->sql_query($sql, false, 'sitm_')) )
   //End sql cache

you mean that i must change it to this form ?

Code:

// Pull all config data
   $sql = "SELECT * FROM " . SITEMAPS_CONFIG_TABLE;
   //Begin sql cache
   if ( !$result = $db->sql_query( $sql ) )
   //if( !($result = $db->sql_query($sql, false, 'sitm_')) )
   //End sql cache

at the end
thanks for your expert guides

dcz
Administrateur - Site Admin

Joined: 28 Apr 2006
Posts: 15131

Posted: Sat May 27, 2006 7:33 am Post subject: Re: [solved] configure htaccess file for simple rewrite mod

amir abbas wrote:

first thank you for yor detailed reply
second, forgive me for my poor english Razz

i had a lot of mistake in my post

ok
i read your reply
at first about rewrite rules
i have installed phpbb in sub-domain. i have made a sub domain with name forum and i have
installed phpbb in root of this folder
i test this code

it works for me
thanks

Cool

amir abbas wrote:

and another thing

Quote:

excuse me, i couldn't understand this part

Well, it means that you may need to put :

Code:

RewriteRule ^forum-m\ap\.html$ /sitemaps.php?fim [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)-([0-9]+)\.html$ /sitemaps.php?fmp=$1&start=$2 [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)\.html$ /sitemaps.php?fmp=$1 [QSA,L]

RewriteRule ^forum-sitemap-([0-9]+).xml$ /sitemap.php?fid=$1 [L]

Before

Code:

# CATEGORIES
RewriteRule ^cat([0-9]+)\.html$ /index.php?c=$1 [QSA,L]

In the .htaccess, because those are using "forum" as well for the RegEx, but it does not apply to all cases so if it works nice like this, then it's ok Wink

But you have to activate mod rewrite for both sitemaps for those to be active.

amir abbas wrote:

and

Quote:

so you should start playing with mx Google sitemaps settings, limiting a bit more pagination,

outputted url and sql cycle.

you mean that i must edit default values. could you suggest this values ?

SQL cycle put like under 100, try 50, and try raising it a bit after.
Url Limit try 500 or so, it's already a decent last active topic list Wink

Topic Pagination: Low Limit By default the first five page of every paginated topic will be outputted, it's not that much, but you could lower it a bit.
Topic Pagination: Upper Limit By default the last five pages of every paginated topic will be outputted as well, it's not that much, but you could lower it a bit.

Then, you can try to go a bit over 500 url if it works nicely on your biggest forum Wink

amir abbas wrote:

Quote:

yes i have installed sql cache mod
you mean that i must open all of seven mx sitemap files in include folder
and edit this files ?

i searched those files
i found this parts of codes

Code:

you mean that i must change it to this form ?

Code:

at the end
thanks for your expert guides

Actually you have found the only query that I missed while unmodding the sql cache Wink

No big deal, since it will work as well for people not using it, but you should leave this particular on as his, you will find the other to be different.

The idea is you want to use

Code:

if( !($result = $db->sql_query($sql, false, 'sitm_')) )

instead of :

Code:

if ( !$result = $db->sql_query( $sql ) )

everywhere the query is premodded (other are not worth it Wink

)

++

AmirAbbas
phpBB SEO Team

Joined: 11 May 2006
Posts: 529
Location: IRAN

Posted: Sat May 27, 2006 8:23 am Post subject: Re: [solved] configure htaccess file for simple rewrite mod

ok for the lat time Very Happy

i think i must change rewriterules to this form

Code:

# These three lines should only be added if not already done in the .htaccess
Options +FollowSymlinks
RewriteEngine On
RewriteBase /

#########################################################
# PHPBB SEO REWRITE RULES #
#########################################################
# AUTHOR : DCZ http://www.phpbb-seo.com/
# STARTED : 01/2006
#####################################################
# FORUMS PAGES
########################
RewriteRule ^forum-m\ap\.html$ /sitemaps.php?fim [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)-([0-9]+)\.html$ /sitemaps.php?fmp=$1&start=$2 [QSA,L]
RewriteRule ^forum-m\ap([0-9]+)\.html$ /sitemaps.php?fmp=$1 [QSA,L]

RewriteRule ^forum-sitemap-([0-9]+).xml$ /sitemap.php?fid=$1 [L]

# CATEGORIES
RewriteRule ^cat([0-9]+)\.html$ /index.php?c=$1 [QSA,L]
# PAGINATED FORUM
RewriteRule ^forum([0-9]+)-([0-9]+)\.html$ /viewforum.php?f=$1&start=$2 [QSA,L]
# FORUM
RewriteRule ^forum([0-9]+)\.html$ /viewforum.php?f=$1 [QSA,L]
# PAGINATED TOPIC
RewriteRule ^topic([0-9]+)-([0-9]+)\.html$ /viewtopic.php?t=$1&start=$2 [QSA,L]
# TOPIC
RewriteRule ^topic([0-9]+)\.html$ /viewtopic.php?t=$1 [QSA,L]
# POST
RewriteRule ^post([0-9]+)\.html$ /viewtopic.php?p=$1 [QSA,L]
#PROFILES
RewriteRule ^member([0-9]+)\.html$ /profile.php?mode=viewprofile&u=$1 [QSA,L]
# END PHPBB PAGES
#########################################################
# MX SITEMAPS REWRITE RULES #
#########################################################
RewriteRule ^sitemaps([0-9]+)\.html$ /sitemaps.php?c=$1 [QSA,L]
RewriteRule ^sitemaps\.html$ /sitemaps.php [QSA,L]
#########################################################
# MX GG_SITEMAPS REWRITE RULES #
#########################################################
RewriteRule ^sitemaps.xml$ /sitemap.php [L]
RewriteRule ^mx-sitemap.xml$ /sitemap.php?mx [L]
RewriteRule ^kb-sitemap-([0-9]+).xml$ /sitemap.php?kbid=$1 [L]
RewriteRule ^sitemap-forum.xml$ /sitemap.php?forum [L]
RewriteRule ^sitemap-kbcat.xml$ /sitemap.php?kbcat [L]
#########################################################
# END GG_SITEMAPS REWRITE RULES #
#########################################################

is it correct ?

Quote:

Actually you have found the only query that I missed while unmodding the sql cache

because i saw this part of code is different form other similar codes
i preferred to use this part as an example

i have understood other parts
thanks

dcz
Administrateur - Site Admin

Joined: 28 Apr 2006
Posts: 15131

Posted: Sat May 27, 2006 8:31 am Post subject: Re: [solved] configure htaccess file for simple rewrite mod

Everything is now nicely working, you should just uncomment the required for mx sitemaps module in session.php (append_sid() ) as stated in the phpBB SEO mod Rewrite install This will make you use a nice pagination for it ++
_________________ Useful links : SEO Forum \|\| SEO Directory \|\| SEO phpBB \|\| SEO phpBB3 \|\| Search ____________________ Liens Utiles : Forum référencement \|\| Annuaire référencement \|\| Référencement phpBB \|\| Référencement phpBB3 \|\| Recherche

AmirAbbas
phpBB SEO Team

Joined: 11 May 2006
Posts: 529
Location: IRAN

Posted: Sat May 27, 2006 8:44 am Post subject: Re: [solved] configure htaccess file for simple rewrite mod

you mean that i must edit this part of code in sessions.php

Code:

//"'(?)forum-map([0-9]+)\.html&start=([0-9]+)((&)|(&)){0,1}'",

Code:

//"forum-map\\1-\\2.html".if_query('\\3')."",

Code:

//$url = preg_replace("'(?)mx-map\.html&start=([0-9]+)'", "mx-map-\\1.html", $url);

i must remove the // from the first of these lines

OK
i edited my post and i add [solved] to title of topic
thanks again Wink

_________________
چهار گوش - طراحی وب - مجله طراحی وب

dcz
Administrateur - Site Admin

Joined: 28 Apr 2006
Posts: 15131

Posted: Sat May 27, 2006 8:45 am Post subject: Re: [solved] configure htaccess file for simple rewrite mod

Exactly and you are welcome
_________________ Useful links : SEO Forum \|\| SEO Directory \|\| SEO phpBB \|\| SEO phpBB3 \|\| Search ____________________ Liens Utiles : Forum référencement \|\| Annuaire référencement \|\| Référencement phpBB \|\| Référencement phpBB3 \|\| Recherche

Display posts from previous:

	phpBB SEO » SEO Forum » phpBB mod Rewrite
Page 1 of 1

Navigation