<?php
// $Id: aat_legacy_upgrade.php,v 1.0 2009/12/29 clara@clararaubertas.net

// Migrate data from the old Amazon Associates Tools.

include_once('includes/bootstrap.inc');
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);
bootstrap_invoke_all('init');
ini_set('memory_limit', '512M');
echo "Bootstrap sucessful\n\n";


$counter = 0;
  if (db_table_exists('amazonitem')) {
    $select  = "SELECT a.asin, a.detailpageurl, a.smallimageurl, a.smallimageheight, a.smallimagewidth, a.title FROM {amazonitem} a ";
    $insert = "INSERT INTO {amazon_item} (asin, detailpageurl, title) VALUES (%d, '%s', '%s')";
    $insert2 = "INSERT INTO {amazon_item_image} (asin, url, height, width, size) VALUES (%d, '%s', %d, %d, 'smallimage')";
    $results = db_query($select);
    while ($asin = db_fetch_object($results)) {
    
      $a = db_query($insert, $asin->asin, $asin->detailpageurl, $asin->title, $asin->amount);
      $b = db_query($insert2, $asin->asin, $asin->smallimageurl, $asin->smallimageheight, $asin->smallimagewidth);
      if ($a && $b) {
      $counter++;
}
    }
}

echo $counter;
echo " items updated";