Miscellaneous Hacks - TFSEO Google Sitemap Generator (URL rewriting support)

Google's sitemap with the URL rewriting of TFSEO.

If you dont know TFSEO look at: https://vborg.vbsupport.ru/showthread.php?t=173738

All credit goes to Superjeff, TFSEO'S creator, and i hope he can include and improve this code to merge it seamlessly into TFSEO.

READ CAREFULLY:
ONLY WORKS WITH METHOD 2 OF TFSEO (MEDIUM), with URL STRUCTURE SET TO DIRECTORY (THE FIRST ONE)

---------------------------------------


1. Add this line to your htaccess rules:

RewriteRule (.*)\.xml(.*) $1.php$2 [nocase]


2. Open sitemap.php and fill the required data.


3. Upload sitemap.php to the root of your forum.


4. Write in browser www.yourfoum.com/sitemap.php to generate the xml google sitemap.


About the rewrite rule:
What this does is it turns on the rewrite rule (allowing you to modify how URLs are handled, essentially) and adds the logic that allows a file.php to be intepreted as file.xml.

This now means that if you put sitemap.xml into your browser you'll be viewing the output from sitemap.php and that's crucial because now when Google looks for sitemap.xml it's viewing live data from your PHP script. This means that your sitemap.xml file will never be inaccurate.

So now you only must go to

http://www.google.com/webmasters/too...um/sitemap.xml

each you time you want to tell google to index the changes of your sitemap. The xml is generated by the php code on the fly so is always correct


limitations: Writes only home, forums and threads urls (i think is enough for most uses).

-----------------------------------
v1.1: Added parameters for Home, improved defaults value for frequency and priority.

[Bombowiec89]

thanks installed

[Q-v-n-s-Q]

very nice, so i need to install TFSEO as well.

[LoRdGd]

Can you explain me why the info about database is nesesary in this modyfication? Maybe im supersensitive, but this is a firs mod where i found sth like this.

[yahsuah]

Thanks!!!

I was searching this...

[paketeto]

Originally Posted by LoRdGd

Can you explain me why the info about database is nesesary in this modyfication? Maybe im supersensitive, but this is a firs mod where i found sth like this.

Of course. Im not a programmer, and i dont know how to merge this with vbulletin, so i had to make this "dirty" solution, but it works. I hope Superjeff, the tfseo creator, will include and integrate this without the need of fill duplicated data. Sorry.

Anyway, although being a dirty code, is safe to use and works fine.

[NAZIA]

Whats about this error|

XML Parsing Error: junk after document element
Location: http://bzupages.com/sitemap.php
Line Number 2, Column 1:<b>Warning</b>:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/mounted-storage/home108c/sub001/sc62900-HIDD/bzupages/sitemap.php</b> on line <b>47</b><br />
^

[paketeto]

Originally Posted by NAZIA

Whats about this error|

XML Parsing Error: junk after document element
Location: http://bzupages.com/sitemap.php
Line Number 2, Column 1:<b>Warning</b>:  mysql_num_rows(): supplied argument is not a valid MySQL result resource in <b>/mounted-storage/home108c/sub001/sc62900-HIDD/bzupages/sitemap.php</b> on line <b>47</b><br />
^

Did you fill all required data in sitemap.php correctly and the database connection was successful?

[xuanhuy238]

XML Parsing Error: syntax error
Location: http://www.pes.vn/sitemap.php
Line Number 1, Column 1:Query failed
^

how to fix it???

[paketeto]

Originally Posted by xuanhuy238

how to fix it???

The php is not connecting with your database, be sure you fill correctly all required data inside sitemap.php.