if ($oGoogle->GenerateProductSitemap()){ echo 'Generated Google Product Sitemap Successfully' . "\n\n"; } else { $submit = false; echo 'ERROR: Google Product Sitemap Generation FAILED!' . "\n\n"; } if ($oGoogle->GenerateCategorySitemap()){ echo 'Generated Google Category Sitemap Successfully' . "\n\n"; } else { $submit = false; echo 'ERROR: Google Category Sitemap Generation FAILED!' . "\n\n"; } if ($oGoogle->GenerateSitemapIndex()){ echo 'Generated Google Sitemap Index Successfully' . "\n\n"; } else { $submit = false; echo 'ERROR: Google Sitemap Index Generation FAILED!' . "\n\n"; } if ($submit){ echo 'CONGRATULATIONS! All files generated successfully.' . "\n\n"; echo 'If you have not already submitted the sitemap index to Google click the link below.' . "\n"; echo 'Before you do I HIGHLY recommend that you view the XML files to make sure the data is correct.' . "\n\n"; echo $oGoogle->GenerateSubmitURL() . "\n\n"; echo 'Here is your sitemap index: ' .$oGoogle->base_url . 'sitemapindex.xml' . "\n"; echo 'Here is your product sitemap: ' . $oGoogle->base_url . 'sitemapproducts.xml' . "\n"; echo 'Here is your category sitemap: ' . $oGoogle->base_url . 'sitemapcategories.xml' . "\n";
if ($oSitemap->GenerateProductSitemap()){ echo 'Generated Google Product Sitemap Successfully' . "\n\n"; } else { $submit = false; echo 'ERROR: Google Product Sitemap Generation FAILED!' . "\n\n"; } if ($oSitemap->GenerateCategorySitemap()){ echo 'Generated Google Category Sitemap Successfully' . "\n\n"; } else { $submit = false; echo 'ERROR: Google Category Sitemap Generation FAILED!' . "\n\n"; } if ($oSitemap->GenerateSitemapIndex()){ echo 'Generated Google Sitemap Index Successfully' . "\n\n"; } else { $submit = false; echo 'ERROR: Google Sitemap Index Generation FAILED!' . "\n\n"; } if ($submit){ if ($prevent_result->RecordCount() > 0) { $configurationtable = $oostable['configuration']; $dbconn->Execute("UPDATE $configurationtable SET configuration_value = '" . date("Ymd") . "' WHERE configuration_key = 'CRON_GOOGLE_RUN'"); } else { $configurationtable = $oostable['configuration']; $dbconn->Execute("INSERT INTO $configurationtable (configuration_key, configuration_value, configuration_group_id) VALUES ('CRON_GOOGLE_RUN', '" . date("Ymd") . "', '6')"); }
function createGoogleSitemap() { $google = new GoogleSitemap(); $submit = true; $product_sitemap = false; if (SITEMAP_PRODUCTEN == '1') { $product_sitemap = true; if ($google->GenerateProductSitemap()) { //echo 'De producten sitemap is succesvol aangemaakt!' . "<br />"; } else { $prods_query = tep_db_query('SELECT products_id FROM products limit 1'); if (tep_db_num_rows($prods_query) > 0) { $submit = false; echo 'ERROR: De producten sitemap is niet correct aangemaakt!' . "<br />"; } else { $product_sitemap = false; echo 'OPGELET: De producten sitemap is niet aangemaakt! Er zijn geen producten!' . "<br />"; } } } $category_sitemap = false; if (SITEMAP_CATEGORIEEN == '1') { $category_sitemap = true; if ($google->GenerateCategorySitemap()) { //echo 'De Categorieën sitemap is succesvol aangemaakt!' . "<br />"; } else { $cats_query = tep_db_query('SELECT categories_id FROM categories limit 1'); if (tep_db_num_rows($cats_query) > 0) { $submit = false; echo 'ERROR: De categorieën sitemap is niet correct aangemaakt!' . "<br />"; } else { $category_sitemap = false; echo 'OPGELET: De categorieën sitemap is niet aangemaakt! Er zijn geen categorieën!' . "<br />"; } } } $showManufacturers = false; if (SITEMAP_FABRIKANTEN == '1') { $showManufacturers = true; if ($google->GenerateManufacturerSitemap()) { //echo 'De fabrikanten sitemap is succesvol aangemaakt!' . "<br />"; } else { $manufacturers_query = tep_db_query("select manufacturers_id from " . TABLE_MANUFACTURERS . " limit 1"); if (tep_db_num_rows($manufacturers_query) > 0) { $submit = false; echo 'ERROR: De fabrikanten sitemap is niet correct aangemaakt!' . "<br />"; } else { $showManufacturers = false; echo 'OPGELET: De fabrikanten sitemap is niet aangemaakt! Er zijn geen fabrikanten!' . "<br />"; } } } $showSpecials = false; if (SITEMAP_PROMOTIES == '1') { $showSpecials = true; if ($google->GenerateSpecialsSitemap($languages_id)) { //echo 'De promotie sitemap is succesvol aangemaakt!' . "<br />"; } else { $specials_query = tep_db_query("select products_id from specials WHERE expires_date > NOW() AND status = '1' limit 1"); if (tep_db_num_rows($specials_query) > 0) { $submit = false; echo 'ERROR: De promotie sitemap is niet correct aangemaakt!' . "<br />"; } else { $showSpecials = false; echo 'OPGELET: De promotie sitemap is niet aangemaakt! Er zijn geen promoties!' . "<br />"; } } } $showInfopages = false; if (SITEMAP_INFOPAGINA == '1') { $showInfopages = true; if ($google->GeneratePagesSitemap()) { //echo 'De infopagina sitemap is succesvol aangepast!' . "<br />"; } else { $infopages_query = tep_db_query("select infopages_id from infopages WHERE infopages_status = '1' limit 1"); if (tep_db_num_rows($infopages_query) > 0) { $submit = false; echo 'ERROR: De infopagina sitemap is niet correct aangemaakt!' . "<br />"; } else { $showInfopages = false; echo 'OPGELET: De infopagina sitemap is niet aangemaakt! Er zijn geen infopagina\'s!' . "<br />"; } } } if ($google->GenerateSitemapIndex($showInfopages, $showManufacturers, $showSpecials, $category_sitemap, $product_sitemap)) { //echo 'De index sitemap is succesvol aangemaakt!' . "<br />"; } else { $submit = false; } if ($submit) { //echo "<br />".'Alle sitemaps zijn correct aangemaakt!' . "<br /><br />"; /*echo 'Dit is de index sitemap: ' . $google->base_url . 'sitemapindex.xml' . "<br />"; if ($product_sitemap) echo 'Dit is de producten sitemap: ' . $google->base_url . 'sitemapproducts.xml' . "<br />"; if ($category_sitemap) echo 'Dit is de categorieën sitemap: ' . $google->base_url . 'sitemapcategories.xml' . "<br />"; if ($showManufacturers) echo 'Dit is de fabrikanten sitemap: ' . $google->base_url . 'sitemapmanufacturers.xml' . "<br />"; if ($showSpecials) echo 'Dit is de promotie sitemap: ' . $google->base_url . 'sitemapspecials.xml' . "<br />"; if ($showInfopages) echo 'Dit is de infopagina sitemap: ' . $google->base_url . 'sitemappages.xml' . "<br />"; */ } else { echo '<pre>'; print_r($google->debug); echo '</pre>'; } }
echo 'De infopagina sitemap is succesvol aangepast!' . "<br />"; } else { $infopages_query = tep_db_query("select infopages_id from infopages WHERE infopages_status = '1' limit 1"); if (tep_db_num_rows($infopages_query) > 0) { $submit = false; echo 'ERROR: De infopagina sitemap is niet correct aangemaakt!' . "<br />"; } else { $showInfopages = false; echo 'OPGELET: De infopagina sitemap is niet aangemaakt! Er zijn geen infopagina\'s!' . "<br />"; } } } /************/ /* Index */ /************/ if ($google->GenerateSitemapIndex($showInfopages, $showManufacturers, $showSpecials, $category_sitemap, $product_sitemap)) { echo 'De index sitemap is succesvol aangemaakt!' . "<br />"; } else { $submit = false; } /************/ /* Output */ /************/ if ($submit) { echo "<br />" . 'Alle sitemaps zijn correct aangemaakt!' . "<br /><br />"; echo 'Dit is de index sitemap: <a href="' . $google->base_url . 'sitemapindex.xml">' . $google->base_url . 'sitemapindex.xml</a><br />'; if ($product_sitemap) { echo 'Dit is de producten sitemap: <a href="' . $google->base_url . 'sitemapproducts.xml">' . $google->base_url . 'sitemapproducts.xml</a> (' . $google->debug['QUERY']['PRODUCTS']['NUM_ROWS'] . ')<br />'; } if ($category_sitemap) { echo 'Dit is de categorieën sitemap: <a href="' . $google->base_url . 'sitemapcategories.xml">' . $google->base_url . 'sitemapcategories.xml</a> (' . $google->debug['QUERY']['CATEGORY']['NUM_ROWS'] . ')<br />';