Google Sitemap v2.7

[grynmoors]

Yeah, the inlude works but I think the DB stuff needs to be this:

$sql = "Select video_id, video_title, video_description, video_add_date, video_flv_name, video_length from videos where video_approve=1 and video_active=1";

[grynmoors]

I'm trying to automate this as much as I can so that I can just upload it to all my vshare sites without having to configure each one each time...the only thing I can't get to work is the {$base_url} part. Comes out looking weird

http:///6/using_satchel_and_claymore_in_ctf/http:///etc

[carefree2]

I'm trying to automate this as much as I can so that I can just upload it to all my vshare sites without having to configure each one each time...the only thing I can't get to work is the {$base_url} part. Comes out looking weird

http:///6/using_satchel_and_claymore_in_ctf/http:///etc

Keep in mind its still xml format even though it has php extension

$config['baseurl']

[grynmoors]

Right, I was thinking "smarty" code. I submitted it to Google and we'll see what happens. I can't post my completed code to the forums for some reason, it keeps getting cut off.

[ikhebdexfactor]

I get the following error? any sollutions yet?


The following tags were not closed: urlset. Error processing resource 'http://www.ikhebdexfactor.nl/sitemap.php'.

[carefree2]

I get the following error? any sollutions yet?


The following tags were not closed: urlset. Error processing resource 'http://www.ikhebdexfactor.nl/sitemap.php'.

Error: Table 'ikhebdex_vshare.video' doesn't exist

Table doesn't exist

The script works. Use my version for google

[ikhebdexfactor]

Don't know what i am doing wrong then, im using your code already, filled in datebase info double checked it, and filled in my URL.

echo "<url><loc>http://www.ikhebdexfactor.nl/video/".$info[0]."/".$SefUrl."/</loc></url>";

mmmmmmmm help :)

Error: Table 'ikhebdex_vshare.video' doesn't exist

Table doesn't exist

The script works. Use my version for google

[carefree2]

Yeah im still using version 2.6. Version 2.7 database is different

Change:

    $sql = "Select  VID, title, description, adddate, flvdoname, duration from video where approve=1 and active=1";

to

    $sql = "Select  * from videos where video_approve=1 and video_active=1";

[griidetru]

Thanks so much 4 sharing with us,bros

[Blain]

I am currently getting the following message after creating the sitemap.php file and placing it within my public_html folder (with the index.php).

This XML file does not appear to have any style information associated with it. The document tree is shown below.

This message is then followed by the code within the file. Is this normal? If so, no problems here, but it seems a bit fishy.

Thanks for the sitemap anywho, and the answers of course.

--
Cheers,