Simple but effective sitemap generator

Hi folks,

I switched over from Skadate to Dolphin, thanks god :-)

I searched through this forum and did not find a suitable sitemap generator ... Ok, google offers an own new one, serverside (Linux), but that's a huge application, which breaks up the Apache config. So I made it a little bit easier and publish here an simple but effective sitemap"generator", based on php for Dolphin 7.

Create an empty file called (e.g.) base.php with an editor and place the following code into it: (start copy&paste from php symbol to php symbol at the end ;-)

<?php

// MySQL-Host angeben
$mysqlhost  = "localhost";

// MySQL-User angeben
$mysqluser  = "db-username";

// Passwort angeben
$mysqlpwd   = "db-password";

// Gewuenschte Datenbank angeben
$mysqldb    = "db-database-name";

// Verbindung aufbauen
$c alt= mysql_connect( $mysqlhost, $mysqluser, $mysqlpwd )
or die( "Verbindungsversuch fehlgeschlagen / Connection failed to database" );

// Datenbank oeffnen
mysql_select_db( $mysqldb, $connection )
or die( "Konnte die Datenbank nicht oeffnen / Could not open database.");

// Abfrage definieren
$query_sql    = "SELECT NickName FROM Profiles";

// Abfrage durchfuehren
$query_result = mysql_query( $query_sql )
or die( "Anfrage nicht erfolgreich" );

// Ergebnisse durchiterieren
$fp = fopen("base.txt", "w+");


while ( $adr = mysql_fetch_array( $query_result ) )
{

$ergebnis0 = $adr['NickName'];
$schema = "http://www.yourdomain.com/$ergebnis0\n";
fputs($fp, $schema);
}
fclose($fp);
?>
<?php
echo "Erfolgreich Sitemap erstellt! Sitemap was created successfully";
?>

Now create an empty file called base.txt.

Upload both files to your root directory. Change the file-attrib. to 0666/0777 of base.txt

Run the www.yourdomain.com/base.php

It will fill your base.txt with all URLs of your member-profiles

Submit this URL to Webmastertools (Google) - www.yourdomain.base.txt (will be your Sitemap URL)

STOP! I know, this is just a tiny application, but I promise, I will update it soon to implement the URLs of all other items as well.

I recommend to place the sitemap-code into your robots.txt, too, for other searchengines.

Great post Myface, followed it to a tee and it looks fine. Thank you for the nice resource

nice post...a sitemap is really important for better indexing and seo.

and here is the sitemap.php , sitemap.xml and sitemap.xml.gz with all settings if someone is interested.

a sitemap link in the footer is also very important.

http://www.boonex.com/unity/extensions/entry/Sitemap_Generator_D7

http://www.xml-sitemaps.com

Here are free best sitemap generator

another one good resource

@ AndreyP

yes for free it is really good.

i used it also before.

but there you cannot make frequency,proirity settings for each links.

so all on your site has the same settings, f.e. the user 1 and the very important event or your main index site.

it also stops at 500 pages and you cannot decide which pages you want in it,

so very important sites are missing maby.

and it shows f.e. www.boonex.us and boonex.us and boonex.us/index.php which really shouldn´t be there about duplicate content.

for a small new site it is ok, but not later.

Looks good myface24 - I did as shown, but received the following error, any ides?

---------------------
Parse error: syntax error, unexpected T_STRING in /home/folkdire/public_html/home/base.php on line 16
---------------------


For your reference, line 16:
$c alt= mysql_connect( $mysqlhost, $mysqluser, $mysqlpwd )

@myface24

Tip: you should make this file only usable for admins

i can write the sitemap how often i want on your site as a visitor and that is not so secure with all db connections in it

Sorry, the Boonex system "destroyed" my line in code:

The error in line 16 is at the beginning:

// Verbindung aufbauen
$c alt= mysql_connect( $mysqlhost, $mysqluser, $mysqlpwd )
or die( "Verbindungsversuch fehlgeschlagen" );

So the first parameter is Dollar-sign and "connection" in order to establish the database connection.

For me it worked great now, nevertheless "priority", "duration" etc. is important, but google indexed my pages "around 50000" within 1 month

I have install this... from UE30

http://www.boonex.com/unity/extensions/entry/Sitemap_Generator_D7

Its really perfect !!!

I bought the module - what do I have to say. GREAT JOB, excellent. Thanks! Within 1 minute, Google checked my old sitemap with your new xml one and confirmed 80% out of it as existing URL, so no new indexing needed ... 20% remains "uncrawled", but I think they spider all 40.000 URLs within the next 2-3 weeks.

So I can really recommend that sitemap to all of you. It's worth the price.

I went to :

http://www.xml-sitemaps.com/

And just typed in my web address and they crawled it - it took a while but then they gave me a free site map.  Only 500 pages crawled but its a good start for being free.

But I would probably buy the mod - for long term use

This one requires Java in order to use it..but there are no limitations. It seems to work quite well for my purposes.

Instructions here:

http://www.auditmypc.com/free-sitemap-generator.asp

Actual generator is here:

http://www.auditmypc.com/xml-sitemap.asp

Hi i have got a site which is focused mainly on videos, is the xml $19.99 sitemap generator full version including video sitemap for additional $5 worth using or the one from Boonex member ue30?

Any ideas please??

 the videos and images sitemap generator cost an additional $5/each, but well worth it. and really has nothing to do with boonex or dolphin, or should i say not dependent on having boonex or dolphin as part of your portfolio.

If your running 7.1 it's automated:

Simply go to Tools, "Sitemap", check the generate box, hit submit then sit back and relax. 

This post was from 4 years ago and referring to a previous version of Dolphin.

 So what..... let's keep bumping it

where did ue30 go....

Hi,

Tried messaging ue30 back in October about this but got no response so far. I'm using his SEO sitemap generator D7.1 which does the job efficiently but a little too efficiently as it's submitting content that only members can actually access which means I'm constantly getting warning reports in my Google Webmaster Tool Dashboard for URLs not accessible. I'm pretty sure these errors will have a detrimental impact on my search rankings so I was wondering if there was anyway I could switch off some of the content from being submitted. At the moment, the following content is automatically included:

System Pages
Profiles
Profile Info
Pages Ads
Pages Created With Page Builder
Feedback
Groups
News
Blog
Posts
Files
File Folders
Journals
Photos
Photo Albums
Sites
Book
Articles
Events
Sounds
Sound Albums
Videos
Video Albums
Forum Topics
Polls

I specifically don't want forum topics being submitted and profile info so if anyone can help, I would be very grateful.

Many thanks in advance,
Mark