New Google Sitemap Generator

1 of 1494   Next >   Last >>   The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website. added one for reviews. not the best coder though basically added a new query and edit the loop $sql2 = "SELECT products_id as pID, products_id as products_id FROM " . TABLE_REVIEWS . ""; /* * Execute the query */ $query = tep_db_query($sql); $query2 = tep_db_query($sql2); /* * If there are returned rows... * Basic sanity check */ if ( tep_db_num_rows($query) > 0 ){ /* * Initialize the variable containers */ $container = array(); $number = 0; $top = 0; /* * Loop the query result set */ while( $result = tep_db_fetch_array($query)){ $pID = tep_db_fetch_array($query2); $top = max($top, $pID['products_id'], $result['date_added']); $location = tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $pID['pID'] . '&'. 'reviews_id=' . $result['rID'], 'NONSSL', false); if ( tep_not_null($result['last_mod']) ){ $lastmod = $result['last_mod']; } else { $lastmod = $result['date_added']; } $changefreq = 'weekly'; $ratio = ($top > 0) ? ($result['date_added']/$top) : 0; $priority = $ratio < .1 ? .1 : number_format($ratio, 1, '.', ''); /* * Initialize the content container array */ $container = array('loc' => htmlspecialchars(utf8_encode($location)), 'lastmod' => date ("Y-m-d", strtotime($lastmod)), 'changefreq' => $changefreq, 'priority' => $priority ); THANKS to who created this and the others! added one for reviews. not the best coder though basically added a new query and edit the loop $sql2 = "SELECT products_id as pID, products_id as products_id FROM " . TABLE_REVIEWS . ""; /* * Execute the query */ $query = tep_db_query($sql); $query2 = tep_db_query($sql2); /* * If there are returned rows... * Basic sanity check */ if ( tep_db_num_rows($query) > 0 ){ /* * Initialize the variable containers */ $container = array(); $number = 0; $top = 0; /* * Loop the query result set */ while( $result = tep_db_fetch_array($query)){ $pID = tep_db_fetch_array($query2); $top = max($top, $pID['products_id'], $result['date_added']); $location = tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $pID['pID'] . '&'. 'reviews_id=' . $result['rID'], 'NONSSL', false); if ( tep_not_null($result['last_mod']) ){ $lastmod = $result['last_mod']; } else { $lastmod = $result['date_added']; } $changefreq = 'weekly'; $ratio = ($top > 0) ? ($result['date_added']/$top) : 0; $priority = $ratio < .1 ? .1 : number_format($ratio, 1, '.', ''); /* * Initialize the content container array */ $container = array('loc' => htmlspecialchars(utf8_encode($location)), 'lastmod' => date ("Y-m-d", strtotime($lastmod)), 'changefreq' => $changefreq, 'priority' => $priority ); THANKS to who created this and the others! I downloaded NGS1.2 version, but it did not work on my 2.2 version. I added following lines instead of application_top/bottom.php define('SEARCH_ENGINE_FRIENDLY_URLS', 'false'); require('includes/configure.php'); require(DIR_WS_INCLUDES . 'filenames.php'); require(DIR_WS_INCLUDES . 'database_tables.php'); require(DIR_WS_FUNCTIONS . 'database.php'); tep_db_connect() or die('Unable to connect to database server!'); require(DIR_WS_FUNCTIONS . 'general.php'); require(DIR_WS_FUNCTIONS . 'html_output.php'); esta es una version de la1.1 sin manufacturers, pero con los parents de las categorias, aunque estas no tengan productos I've added the manufacturers XML sitemap, you need to insert the new general website map into google webmasters. Thanks :D FULL package!    Posted on: 09/22/2008     See contribution details Request Installation with Paid service