[solved] configure htaccess file for simple rewrite mod

AmirAbbas · by **AmirAbbas** » Fri May 26, 2006 3:14 pm

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: Select all: # 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 ^phpbb/cat([0-9]+)\.html$ /phpbb/index.php?c=$1 [QSA,L] # PAGINATED FORUM RewriteRule ^phpbb/forum([0-9]+)-([0-9]+)\.html$ /phpbb/viewforum.php?f=$1&start=$2 [QSA,L] # FORUM RewriteRule ^phpbb/forum([0-9]+)\.html$ /phpbb/viewforum.php?f=$1 [QSA,L] # PAGINATED TOPIC RewriteRule ^phpbb/topic([0-9]+)-([0-9]+)\.html$ /phpbb/viewtopic.php?t=$1&start=$2 [QSA,L] # TOPIC RewriteRule ^phpbb/topic([0-9]+)\.html$ /phpbb/viewtopic.php?t=$1 [QSA,L] # POST RewriteRule ^phpbb/post([0-9]+)\.html$ /phpbb/viewtopic.php?p=$1 [QSA,L] #PROFILES RewriteRule ^phpbb/member([0-9]+)\.html$ /phpbb/profile.php?mode=viewprofile&u=$1 [QSA,L] # END PHPBB PAGES #####################################################

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

Code: Select all: # 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 #####################################################

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: Select all: # 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

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: Select all: # 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

)

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

) and test them. They shoudl work

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

This way the code will be faster

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

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

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

++

AmirAbbas · by **AmirAbbas** » Sat May 27, 2006 7:14 am

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: Select all: # 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

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

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 ?

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: Select all: // 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: Select all: // 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 · by **dcz** » Sat May 27, 2006 7:33 am

amir abbas wrote:first thank you for yor detailed reply
second, forgive me for my poor english 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

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

Well, it means that you may need to put :

Code: Select all: 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: Select all: # 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

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

amir abbas wrote:and

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

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

amir abbas wrote:
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: Select all
// 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: Select all
// 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

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

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: Select all: if( !($result = $db->sql_query($sql, false, 'sitm_')) )

instead of :

Code: Select all: if ( !$result = $db->sql_query( $sql ) )

everywhere the query is premodded (other are not worth it

)

++

AmirAbbas · by **AmirAbbas** » Sat May 27, 2006 8:23 am

ok for the lat time

i think i must change rewriterules to this form

Code: Select all: # 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 ?

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 · by **dcz** » Sat May 27, 2006 8:31 am

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

++

AmirAbbas · by **AmirAbbas** » Sat May 27, 2006 8:44 am

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

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

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

Code: Select all: //$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 · by **dcz** » Sat May 27, 2006 8:45 am

Exactly and you are welcome

[solved] configure htaccess file for simple rewrite mod

[solved] configure htaccess file for simple rewrite mod

Advertisement

Re: need help to configure htaccess file for simple rewrite

Who is online

Advertisement