<?php
  // set propert content type
  header('Content-type: text/plain');
  
  // include config file
  require_once 'include/config.inc.php';
  // load database tools
  require_once('include/database_tools.inc.php');
  // load the URL factory
  require_once 'include/url_factory.inc.php';
  
  // this query returns product_id and secondary_category_id data which needs to be
  // excluded using robots.txt
  // get a database connection
  db_link = DatabaseTools::getConnection();
   
  // execute the query
  $query\_results\; =\; mysql\_query($q);
  
  // close database connection 
  DatabaseTools::closeConnection($db\_link);$// create an associative array with the results
  rows = array();
  while ($result\; =\; mysql\_fetch\_assoc($query_results)) {
    $rows[]\; =$result;
  }
  
  // User agent
  echo "User-agent: * \r\n";
  
  // display the links that need to be excluded
  foreach ($rows\; as$row)
  {
    // get the category and product IDs
    $product\_id\; =$row['id'];
    $category\_id\; =$row['secondary_category_id'];
    $product\_name\; =$row['name'];
    $category\_name\; =$row['secondary_category_name'];
    
    // create disallow definition
    $url\; =\; make\_category\_product\_url($category_name, $category\_id,$product_name, $product\_id);$disallow = str_replace(SITE_DOMAIN, '', $url);\; echo\; "Disallow:\; "\; .$disallow . "\r\n";
  } 
  
  ?>
  Disallow: /cart.php