Dolist_Net - Version 2.0.2.1

Version Notes

v2

Download this release

Release Info

Developer Dolist
Extension Dolist_Net
Version 2.0.2.1
Comparing to
See all releases


Code changes from version 2.0.2.0 to 2.0.2.1

Files changed (33) hide show
  1. app/code/community/Dolist/Net/Helper/Data.php +5 -0
  2. app/code/community/Dolist/Net/Model/Dolistv8/Calculatedfields.php +1 -1
  3. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Calculatedfields.php +1 -1
  4. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Date/Firstorder.php +1 -1
  5. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Date/Lastorder.php +1 -1
  6. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Date/Lastquotenotordered.php +1 -1
  7. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgnbdifferentproductsperorder.php +3 -3
  8. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgnbdifferentproductsperorderline.php +3 -3
  9. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgnbproductsperorder.php +1 -1
  10. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgorderamountexcltax.php +1 -1
  11. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgorderamountincltax.php +1 -1
  12. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Firstorderamountexcltax.php +1 -1
  13. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Firstorderamountincltax.php +1 -1
  14. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastnotorderedcartamountexcltax.php +1 -1
  15. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastnotorderedcartamountincltax.php +1 -1
  16. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastorderamountexcltax.php +1 -1
  17. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastorderamountincltax.php +1 -1
  18. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Nbpromotionrulesused.php +1 -1
  19. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorderamountexcltax.php +1 -1
  20. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorderamountincltax.php +1 -1
  21. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorderedproducts.php +1 -1
  22. app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorders.php +1 -1
  23. app/code/community/Dolist/Net/Model/Service.php +26 -26
  24. app/code/community/Dolist/Net/etc/config.xml +1 -1
  25. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-install-0.0.1.0.php +224 -224
  26. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.1.0-0.0.1.1.php +1 -1
  27. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.1.1-0.0.2.0.php +2 -2
  28. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.2.0-0.0.3.0.php +2 -2
  29. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.3.0-0.0.4.0.php +2 -2
  30. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.4.0-0.0.5.0.php +2 -2
  31. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.5.0-0.0.6.0.php +2 -2
  32. app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-2.0.0.6-2.0.0.7.php +6 -5
  33. package.xml +1 -1
app/code/community/Dolist/Net/Helper/Data.php CHANGED
@@ -939,4 +939,9 @@ class Dolist_Net_Helper_Data extends Mage_Core_Helper_Abstract
939
 
940
  return $flag->getFlagData();
941
  }
 
 
 
 
 
942
  }
939
 
940
  return $flag->getFlagData();
941
  }
942
+
943
+ public function getTablename($table)
944
+ {
945
+ return (string)Mage::getConfig()->getTablePrefix() . $table;
946
+ }
947
  }
app/code/community/Dolist/Net/Model/Dolistv8/Calculatedfields.php CHANGED
@@ -664,7 +664,7 @@ class Dolist_Net_Model_Dolistv8_Calculatedfields extends Mage_Core_Model_Abstrac
664
 
665
  /** @var Varien_Db_Select $select */
666
  $select = $readAdapter->select();
667
- $select->from(array('o' => $this->getTable($tableName)), array('o.created_at'))
668
  ->where('o.customer_id=?', $this->getData('customer_id'))
669
  ->where('o.store_id=?', $this->getData('store_id'))
670
  ->order('o.created_at DESC')
664
 
665
  /** @var Varien_Db_Select $select */
666
  $select = $readAdapter->select();
667
+ $select->from(array('o' => (string)Mage::getConfig()->getTablePrefix() . $tableName), array('o.created_at'))
668
  ->where('o.customer_id=?', $this->getData('customer_id'))
669
  ->where('o.store_id=?', $this->getData('store_id'))
670
  ->order('o.created_at DESC')
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Calculatedfields.php CHANGED
@@ -40,7 +40,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Calculatedfields extends Mage_Core_Model_
40
  $select = $readAdapter
41
  ->select()
42
  ->from(
43
- array('o' => $this->getTable($orderTableName)),
44
  array(
45
  'date' => 'o.created_at'
46
  )
40
  $select = $readAdapter
41
  ->select()
42
  ->from(
43
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $tableName),
44
  array(
45
  'date' => 'o.created_at'
46
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Date/Firstorder.php CHANGED
@@ -27,7 +27,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Date_FirstOrder extends Do
27
  }
28
 
29
  $select = $readAdapter->select()
30
- ->from(array('o' => $this->getTable($tableName)),
31
  array(
32
  'date' => 'MIN(created_at)'
33
  ))
27
  }
28
 
29
  $select = $readAdapter->select()
30
+ ->from(array('o' => (string)Mage::getConfig()->getTablePrefix() . $tableName),
31
  array(
32
  'date' => 'MIN(created_at)'
33
  ))
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Date/Lastorder.php CHANGED
@@ -26,7 +26,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Date_LastOrder extends Dol
26
  }
27
 
28
  $select = $readAdapter->select()
29
- ->from(array('o' => $this->getTable($tableName)),
30
  array(
31
  'date'=>'MAX(created_at)'
32
  ))
26
  }
27
 
28
  $select = $readAdapter->select()
29
+ ->from(array('o' => (string)Mage::getConfig()->getTablePrefix() . $tableName),
30
  array(
31
  'date'=>'MAX(created_at)'
32
  ))
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Date/Lastquotenotordered.php CHANGED
@@ -27,7 +27,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Date_LastQuoteNotOrdered
27
 
28
  $request = $readAdapter->select()
29
  ->from(
30
- array('q' => $this->getTable($quoteTableName)),
31
  array(
32
  'q.updated_at'
33
  )
27
 
28
  $request = $readAdapter->select()
29
  ->from(
30
+ array('q' => Mage::helper('dolist')->getTablename($quoteTableName)),
31
  array(
32
  'q.updated_at'
33
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgnbdifferentproductsperorder.php CHANGED
@@ -28,7 +28,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_AvgNbDifferentProducts
28
  // Nested request
29
  $select = $readAdapter->select()
30
  ->from(
31
- array('o' => $this->getTable($orderTableName)),
32
  array(
33
  'AVG(o.total_item_count) AS avg_total_item_count'
34
  )
@@ -42,12 +42,12 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_AvgNbDifferentProducts
42
  // Nested request
43
  $select = $readAdapter->select()
44
  ->from(
45
- array('o' => $this->getTable($orderTableName)),
46
  array(
47
  'count(sf.item_id)/count(DISTINCT o.entity_id) as avg_total_item_count'
48
  )
49
  )->joinLeft(
50
- array('sf' => $this->getTable($orderItemTableName)),
51
  "sf.order_id = o.entity_id",
52
  array()
53
  )
28
  // Nested request
29
  $select = $readAdapter->select()
30
  ->from(
31
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
32
  array(
33
  'AVG(o.total_item_count) AS avg_total_item_count'
34
  )
42
  // Nested request
43
  $select = $readAdapter->select()
44
  ->from(
45
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
46
  array(
47
  'count(sf.item_id)/count(DISTINCT o.entity_id) as avg_total_item_count'
48
  )
49
  )->joinLeft(
50
+ array('sf' => Mage::helper('dolist')->getTablename($orderItemTableName)),
51
  "sf.order_id = o.entity_id",
52
  array()
53
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgnbdifferentproductsperorderline.php CHANGED
@@ -29,7 +29,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_AvgNbDifferentProducts
29
  // Nested request
30
  $select = $readAdapter->select()
31
  ->from(
32
- array('o' => $this->getTable($orderTableName)),
33
  array(
34
  'AVG(total_qty_ordered / total_item_count) AS avg_products_per_line'
35
  )
@@ -42,12 +42,12 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_AvgNbDifferentProducts
42
 
43
  $select = $readAdapter->select()
44
  ->from(
45
- array('o' => $this->getTable($orderTableName)),
46
  array(
47
  'SUM(o.total_qty_ordered)/count(sf.item_id) as avg_products_per_line'
48
  )
49
  )->joinLeft(
50
- array('sf' => $this->getTable($orderItemTableName)),
51
  "sf.order_id = o.entity_id",
52
  array()
53
  )
29
  // Nested request
30
  $select = $readAdapter->select()
31
  ->from(
32
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
33
  array(
34
  'AVG(total_qty_ordered / total_item_count) AS avg_products_per_line'
35
  )
42
 
43
  $select = $readAdapter->select()
44
  ->from(
45
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
46
  array(
47
  'SUM(o.total_qty_ordered)/count(sf.item_id) as avg_products_per_line'
48
  )
49
  )->joinLeft(
50
+ array('sf' => Mage::helper('dolist')->getTablename($orderItemTableName)),
51
  "sf.order_id = o.entity_id",
52
  array()
53
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgnbproductsperorder.php CHANGED
@@ -32,7 +32,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_AvgNbProductsPerOrder
32
  $select = $readAdapter
33
  ->select()
34
  ->from(
35
- array('o' => $this->getTable($orderTableName)),
36
  array(
37
  'total' => 'AVG(o.total_qty_ordered)'
38
  )
32
  $select = $readAdapter
33
  ->select()
34
  ->from(
35
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
36
  array(
37
  'total' => 'AVG(o.total_qty_ordered)'
38
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgorderamountexcltax.php CHANGED
@@ -33,7 +33,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_AvgOrderAmountExclTax
33
  $select = $readAdapter
34
  ->select()
35
  ->from(
36
- array('o' => $this->getTable($orderTableName)),
37
  array(
38
  'total' => 'AVG(o.grand_total - o.tax_amount)'
39
  )
33
  $select = $readAdapter
34
  ->select()
35
  ->from(
36
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
37
  array(
38
  'total' => 'AVG(o.grand_total - o.tax_amount)'
39
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Avgorderamountincltax.php CHANGED
@@ -28,7 +28,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_AvgOrderAmountInclTax
28
  $select = $readAdapter
29
  ->select()
30
  ->from(
31
- array('o' => $this->getTable($orderTableName)),
32
  array(
33
  'total' => 'AVG(o.grand_total)'
34
  )
28
  $select = $readAdapter
29
  ->select()
30
  ->from(
31
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
32
  array(
33
  'total' => 'AVG(o.grand_total)'
34
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Firstorderamountexcltax.php CHANGED
@@ -31,7 +31,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_FirstOrderAmountExclTa
31
  $select = $readAdapter
32
  ->select()
33
  ->from(
34
- array('o' => $this->getTable($orderTableName)),
35
  array(
36
  'total' => '(o.grand_total - o.tax_amount)'
37
  )
31
  $select = $readAdapter
32
  ->select()
33
  ->from(
34
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
35
  array(
36
  'total' => '(o.grand_total - o.tax_amount)'
37
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Firstorderamountincltax.php CHANGED
@@ -31,7 +31,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_FirstOrderAmountInclTa
31
  $select = $readAdapter
32
  ->select()
33
  ->from(
34
- array('o' => $this->getTable($orderTableName)),
35
  array(
36
  'total' => 'o.grand_total'
37
  )
31
  $select = $readAdapter
32
  ->select()
33
  ->from(
34
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
35
  array(
36
  'total' => 'o.grand_total'
37
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastnotorderedcartamountexcltax.php CHANGED
@@ -30,7 +30,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_LastNotOrderedCartAmou
30
 
31
  $request = $readAdapter->select()
32
  ->from(
33
- array('q' => $this->getTable($quoteTableName)),
34
  array(
35
  'q.base_subtotal_with_discount'
36
  )
30
 
31
  $request = $readAdapter->select()
32
  ->from(
33
+ array('q' => Mage::helper('dolist')->getTablename($quoteTableName)),
34
  array(
35
  'q.base_subtotal_with_discount'
36
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastnotorderedcartamountincltax.php CHANGED
@@ -27,7 +27,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_LastNotOrderedCartAmou
27
  /** @var Varien_Db_Select $request */
28
  $request = $readAdapter->select()
29
  ->from(
30
- array('q' => $this->getTable($quoteTableName)),
31
  array(
32
  'subtotal' => '(q.base_subtotal_with_discount*q.base_to_global_rate)',
33
  )
27
  /** @var Varien_Db_Select $request */
28
  $request = $readAdapter->select()
29
  ->from(
30
+ array('q' => Mage::helper('dolist')->getTablename($quoteTableName)),
31
  array(
32
  'subtotal' => '(q.base_subtotal_with_discount*q.base_to_global_rate)',
33
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastorderamountexcltax.php CHANGED
@@ -30,7 +30,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_LastOrderAmountExclTax
30
  $select = $readAdapter
31
  ->select()
32
  ->from(
33
- array('o' => $this->getTable($orderTableName)),
34
  array(
35
  'total' => '(o.grand_total - o.tax_amount)'
36
  )
30
  $select = $readAdapter
31
  ->select()
32
  ->from(
33
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
34
  array(
35
  'total' => '(o.grand_total - o.tax_amount)'
36
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Lastorderamountincltax.php CHANGED
@@ -29,7 +29,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_LastOrderAmountInclTax
29
  $select = $readAdapter
30
  ->select()
31
  ->from(
32
- array('o' => $this->getTable($orderTableName)),
33
  array(
34
  'total' => 'o.grand_total'
35
  )
29
  $select = $readAdapter
30
  ->select()
31
  ->from(
32
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
33
  array(
34
  'total' => 'o.grand_total'
35
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Nbpromotionrulesused.php CHANGED
@@ -26,7 +26,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_NbPromotionRulesUsed e
26
  // Nested request
27
  $select = $readAdapter->select()
28
  ->from(
29
- array('s' => $this->getTable($salesruleTableName)),
30
  array(
31
  'nb_rules'=>'SUM(s.times_used)'
32
  )
26
  // Nested request
27
  $select = $readAdapter->select()
28
  ->from(
29
+ array('s' => Mage::helper('dolist')->getTablename($salesruleTableName)),
30
  array(
31
  'nb_rules'=>'SUM(s.times_used)'
32
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorderamountexcltax.php CHANGED
@@ -32,7 +32,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_TotalOrderAmountExclTa
32
  $select = $readAdapter
33
  ->select()
34
  ->from(
35
- array('o' => $this->getTable($orderTableName)),
36
  array(
37
  'total' => 'SUM(o.grand_total - o.tax_amount)'
38
  )
32
  $select = $readAdapter
33
  ->select()
34
  ->from(
35
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
36
  array(
37
  'total' => 'SUM(o.grand_total - o.tax_amount)'
38
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorderamountincltax.php CHANGED
@@ -32,7 +32,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_TotalOrderAmountInclTa
32
  $select = $readAdapter
33
  ->select()
34
  ->from(
35
- array('o' => $this->getTable($orderTableName)),
36
  array(
37
  'total' => 'SUM(o.grand_total)'
38
  )
32
  $select = $readAdapter
33
  ->select()
34
  ->from(
35
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
36
  array(
37
  'total' => 'SUM(o.grand_total)'
38
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorderedproducts.php CHANGED
@@ -33,7 +33,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_TotalOrderedProducts e
33
  $select = $readAdapter
34
  ->select()
35
  ->from(
36
- array('o' => $this->getTable($orderTableName)),
37
  array(
38
  'total' => 'SUM(o.total_qty_ordered)'
39
  )
33
  $select = $readAdapter
34
  ->select()
35
  ->from(
36
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
37
  array(
38
  'total' => 'SUM(o.total_qty_ordered)'
39
  )
app/code/community/Dolist/Net/Model/Mysql4/Dolistv8/Export/Adapter/Int/Totalorders.php CHANGED
@@ -34,7 +34,7 @@ class Dolist_Net_Model_Mysql4_Dolistv8_Export_Adapter_Int_TotalOrders extends Do
34
  $select = $readAdapter
35
  ->select()
36
  ->from(
37
- array('o' => $this->getTable($orderTableName)),
38
  array(
39
  'total' => 'COUNT(entity_id)'
40
  )
34
  $select = $readAdapter
35
  ->select()
36
  ->from(
37
+ array('o' => (string)Mage::getConfig()->getTablePrefix() . $orderTableName),
38
  array(
39
  'total' => 'COUNT(entity_id)'
40
  )
app/code/community/Dolist/Net/Model/Service.php CHANGED
@@ -761,7 +761,7 @@ class Dolist_Net_Model_Service extends Varien_Object
761
  ->addAttributeToSelect('customer_id')
762
  ->addFieldToFilter('main_table.store_id', $storeId)
763
  ->getSelect();
764
- $select1->join($this->getTable('customer_entity'), 'main_table.customer_id = ' . $this->getTable('customer_entity') . '.entity_id', null);
765
 
766
  $select2 = Mage::getModel('newsletter/subscriber')
767
  ->getCollection()
@@ -777,9 +777,9 @@ class Dolist_Net_Model_Service extends Varien_Object
777
 
778
  $query = new Varien_Db_Select($select1->getAdapter());
779
  $query->from(array('subscriber_extract' => $innerQuery));
780
- $query->joinLeft($this->getTable('customer_entity'), 'subscriber_extract.customer_id = ' . $this->getTable('customer_entity') . '.entity_id');
781
- $query->joinLeft($this->getTable('newsletter_subscriber'), 'subscriber_extract.customer_id = ' . $this->getTable('newsletter_subscriber') . '.customer_id AND ' . $this->getTable('newsletter_subscriber') . '.customer_id != 0');
782
- $query->joinLeft(array($this->getTable('newsletter_subscriber') . '_guest' => $this->getTable('newsletter_subscriber')), 'subscriber_extract.customer_id = ' . $this->getTable('newsletter_subscriber') . '_guest' . '.subscriber_email AND ' . $this->getTable('newsletter_subscriber') . '_guest.customer_id = 0');
783
 
784
  $query->reset(Zend_Db_Select::COLUMNS);
785
  if ($count) {
@@ -798,15 +798,15 @@ class Dolist_Net_Model_Service extends Varien_Object
798
  ->reset(Zend_Db_Select::COLUMNS)
799
  ->reset(Zend_Db_Select::FROM)
800
  ->reset(Zend_Db_Select::WHERE)
801
- ->from($this->getTable('newsletter_subscriber'), '')
802
- ->where($this->getTable('newsletter_subscriber') . '.store_id = ?', $storeId);
803
 
804
  if ($count) {
805
  $query
806
  ->reset(Zend_Db_Select::COLUMNS)
807
- ->columns('COUNT(DISTINCT newsletter_subscriber.customer_id) as total');
808
  } else {
809
- $query->columns('IF(newsletter_subscriber.customer_id=0, subscriber_email, newsletter_subscriber.customer_id) AS customer_id')->distinct();;
810
  }
811
  }
812
 
@@ -816,31 +816,31 @@ class Dolist_Net_Model_Service extends Varien_Object
816
  $date->setTimestamp($differential);
817
 
818
  if ($exportWithCustomer) {
819
- $query->joinLeft($this->getTable('customer_address_entity'), 'subscriber_extract.customer_id = ' . $this->getTable('customer_address_entity') . '.parent_id', null);
820
- $query->joinLeft($this->getTable('dolist_dolistv8_calculatedfields'), 'subscriber_extract.customer_id = ' . $this->getTable('dolist_dolistv8_calculatedfields') . '.customer_id', null);
821
- $query->joinLeft($this->getTable('sales_flat_quote'), 'subscriber_extract.customer_id = ' . $this->getTable('sales_flat_quote') . '.customer_id', null);
822
 
823
  $query->where(
824
- $this->getTable('customer_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
825
- . ' OR ' . $this->getTable('customer_address_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
826
- . ' OR ' . $this->getTable('dolist_dolistv8_calculatedfields') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
827
- . ' OR ' . $this->getTable('sales_flat_quote') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
828
- . ' OR ' . $this->getTable('newsletter_subscriber') . '.updated_at >= ' . $differential
829
- . ' OR ' . $this->getTable('newsletter_subscriber') . '_guest.updated_at >= ' . $differential
830
  );
831
  }
832
  else {
833
- $query->joinLeft($this->getTable('customer_entity'), 'newsletter_subscriber.customer_id = ' . $this->getTable('customer_entity') . '.entity_id', null);
834
- $query->joinLeft($this->getTable('customer_address_entity'), 'newsletter_subscriber.customer_id = ' . $this->getTable('customer_address_entity') . '.parent_id', null);
835
- $query->joinLeft($this->getTable('dolist_dolistv8_calculatedfields'), 'newsletter_subscriber.customer_id = ' . $this->getTable('dolist_dolistv8_calculatedfields') . '.customer_id', null);
836
- $query->joinLeft($this->getTable('sales_flat_quote'), 'newsletter_subscriber.customer_id = ' . $this->getTable('sales_flat_quote') . '.customer_id', null);
837
 
838
  $query->where(
839
- $this->getTable('customer_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
840
- . ' OR ' . $this->getTable('customer_address_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
841
- . ' OR ' . $this->getTable('dolist_dolistv8_calculatedfields') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
842
- . ' OR ' . $this->getTable('sales_flat_quote') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
843
- . ' OR ' . $this->getTable('newsletter_subscriber') . '.updated_at >= ' . $differential
844
  );
845
  }
846
 
761
  ->addAttributeToSelect('customer_id')
762
  ->addFieldToFilter('main_table.store_id', $storeId)
763
  ->getSelect();
764
+ $select1->join(Mage::helper('dolist')->getTablename('customer_entity'), 'main_table.customer_id = ' . Mage::helper('dolist')->getTablename('customer_entity') . '.entity_id', null);
765
 
766
  $select2 = Mage::getModel('newsletter/subscriber')
767
  ->getCollection()
777
 
778
  $query = new Varien_Db_Select($select1->getAdapter());
779
  $query->from(array('subscriber_extract' => $innerQuery));
780
+ $query->joinLeft(Mage::helper('dolist')->getTablename('customer_entity'), 'subscriber_extract.customer_id = ' . Mage::helper('dolist')->getTablename('customer_entity') . '.entity_id');
781
+ $query->joinLeft(Mage::helper('dolist')->getTablename('newsletter_subscriber'), 'subscriber_extract.customer_id = ' . Mage::helper('dolist')->getTablename('newsletter_subscriber') . '.customer_id AND ' . Mage::helper('dolist')->getTablename('newsletter_subscriber') . '.customer_id != 0');
782
+ $query->joinLeft(array(Mage::helper('dolist')->getTablename('newsletter_subscriber') . '_guest' => Mage::helper('dolist')->getTablename('newsletter_subscriber')), 'subscriber_extract.customer_id = ' . Mage::helper('dolist')->getTablename('newsletter_subscriber') . '_guest' . '.subscriber_email AND ' . Mage::helper('dolist')->getTablename('newsletter_subscriber') . '_guest.customer_id = 0');
783
 
784
  $query->reset(Zend_Db_Select::COLUMNS);
785
  if ($count) {
798
  ->reset(Zend_Db_Select::COLUMNS)
799
  ->reset(Zend_Db_Select::FROM)
800
  ->reset(Zend_Db_Select::WHERE)
801
+ ->from(Mage::helper('dolist')->getTablename('newsletter_subscriber'), '')
802
+ ->where(Mage::helper('dolist')->getTablename('newsletter_subscriber') . '.store_id = ?', $storeId);
803
 
804
  if ($count) {
805
  $query
806
  ->reset(Zend_Db_Select::COLUMNS)
807
+ ->columns('COUNT(DISTINCT '.Mage::helper('dolist')->getTablename('newsletter_subscriber').'.customer_id) as total');
808
  } else {
809
+ $query->columns('IF('.Mage::helper('dolist')->getTablename('newsletter_subscriber').'.customer_id=0, subscriber_email, '.Mage::helper('dolist')->getTablename('newsletter_subscriber').'.customer_id) AS customer_id')->distinct();;
810
  }
811
  }
812
 
816
  $date->setTimestamp($differential);
817
 
818
  if ($exportWithCustomer) {
819
+ $query->joinLeft(Mage::helper('dolist')->getTablename('customer_address_entity'), 'subscriber_extract.customer_id = ' . Mage::helper('dolist')->getTablename('customer_address_entity') . '.parent_id', null);
820
+ $query->joinLeft(Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields'), 'subscriber_extract.customer_id = ' . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . '.customer_id', null);
821
+ $query->joinLeft(Mage::helper('dolist')->getTablename('sales_flat_quote'), 'subscriber_extract.customer_id = ' . Mage::helper('dolist')->getTablename('sales_flat_quote') . '.customer_id', null);
822
 
823
  $query->where(
824
+ Mage::helper('dolist')->getTablename('customer_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
825
+ . ' OR ' . Mage::helper('dolist')->getTablename('customer_address_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
826
+ . ' OR ' . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
827
+ . ' OR ' . Mage::helper('dolist')->getTablename('sales_flat_quote') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
828
+ . ' OR ' . Mage::helper('dolist')->getTablename('newsletter_subscriber') . '.updated_at >= ' . $differential
829
+ . ' OR ' . Mage::helper('dolist')->getTablename('newsletter_subscriber') . '_guest.updated_at >= ' . $differential
830
  );
831
  }
832
  else {
833
+ $query->joinLeft(Mage::helper('dolist')->getTablename('customer_entity'), ''.Mage::helper('dolist')->getTablename('newsletter_subscriber').'.customer_id = ' . Mage::helper('dolist')->getTablename('customer_entity') . '.entity_id', null);
834
+ $query->joinLeft(Mage::helper('dolist')->getTablename('customer_address_entity'), ''.Mage::helper('dolist')->getTablename('newsletter_subscriber').'.customer_id = ' . Mage::helper('dolist')->getTablename('customer_address_entity') . '.parent_id', null);
835
+ $query->joinLeft(Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields'), ''.Mage::helper('dolist')->getTablename('newsletter_subscriber').'.customer_id = ' . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . '.customer_id', null);
836
+ $query->joinLeft(Mage::helper('dolist')->getTablename('sales_flat_quote'), ''.Mage::helper('dolist')->getTablename('newsletter_subscriber').'.customer_id = ' . Mage::helper('dolist')->getTablename('sales_flat_quote') . '.customer_id', null);
837
 
838
  $query->where(
839
+ Mage::helper('dolist')->getTablename('customer_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
840
+ . ' OR ' . Mage::helper('dolist')->getTablename('customer_address_entity') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
841
+ . ' OR ' . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
842
+ . ' OR ' . Mage::helper('dolist')->getTablename('sales_flat_quote') . '.updated_at >= \'' . $date->format('Y-m-d\TH:i:sP') . '\''
843
+ . ' OR ' . Mage::helper('dolist')->getTablename('newsletter_subscriber') . '.updated_at >= ' . $differential
844
  );
845
  }
846
 
app/code/community/Dolist/Net/etc/config.xml CHANGED
@@ -4,7 +4,7 @@
4
 
5
  <modules>
6
  <Dolist_Net>
7
- <version>2.0.2.0</version>
8
  </Dolist_Net>
9
  </modules>
10
 
4
 
5
  <modules>
6
  <Dolist_Net>
7
+ <version>2.0.2.1</version>
8
  </Dolist_Net>
9
  </modules>
10
 
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-install-0.0.1.0.php CHANGED
@@ -14,8 +14,8 @@ $installer->startSetup();
14
  // Create new table to store Dolist-EMT templates
15
  $installer->run(
16
  "
17
- DROP TABLE IF EXISTS {$this->getTable('dolist_dolistemt_template')};
18
- CREATE TABLE {$this->getTable('dolist_dolistemt_template')} (
19
  `id` int(10) unsigned NOT NULL auto_increment,
20
  `template_id` int(10) unsigned NOT NULL,
21
  `template_name` varchar(255) NOT NULL default '',
@@ -29,7 +29,7 @@ try {
29
  // Alter column only if column does not already exist
30
  $installer->run(
31
  "
32
- ALTER TABLE {$this->getTable('newsletter_subscriber')}
33
  ADD COLUMN `dolist_status` int(11) NOT NULL default '0',
34
  ADD COLUMN `updated_at` datetime DEFAULT NULL;
35
  "
@@ -43,230 +43,230 @@ try {
43
  // Alter column only if column does not already exist
44
  $installer->run(
45
  "
46
- ALTER TABLE {$this->getTable('directory_country')}
47
  ADD COLUMN `dolist_code` varchar(3) NOT NULL default '999';
48
  "
49
  );
50
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '43' WHERE `country_id` = 'AD';");
51
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '645' WHERE `country_id` = 'AE';");
52
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '647' WHERE `country_id` = 'AE';");
53
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '660' WHERE `country_id` = 'AF';");
54
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '459' WHERE `country_id` = 'AG';");
55
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '446' WHERE `country_id` = 'AI';");
56
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '70' WHERE `country_id` = 'AL';");
57
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '77' WHERE `country_id` = 'AM';");
58
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '478' WHERE `country_id` = 'AN';");
59
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '330' WHERE `country_id` = 'AO';");
60
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '528' WHERE `country_id` = 'AR';");
61
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '38' WHERE `country_id` = 'AT';");
62
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '800' WHERE `country_id` = 'AU';");
63
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '474' WHERE `country_id` = 'AW';");
64
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '78' WHERE `country_id` = 'AZ';");
65
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '93' WHERE `country_id` = 'BA';");
66
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '469' WHERE `country_id` = 'BB';");
67
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '666' WHERE `country_id` = 'BD';");
68
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '2' WHERE `country_id` = 'BE';");
69
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '236' WHERE `country_id` = 'BF';");
70
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '68' WHERE `country_id` = 'BG';");
71
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '640' WHERE `country_id` = 'BH';");
72
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '328' WHERE `country_id` = 'BI';");
73
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '284' WHERE `country_id` = 'BJ';");
74
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '413' WHERE `country_id` = 'BM';");
75
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '703' WHERE `country_id` = 'BN';");
76
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '516' WHERE `country_id` = 'BO';");
77
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '508' WHERE `country_id` = 'BR';");
78
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '453' WHERE `country_id` = 'BS';");
79
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '675' WHERE `country_id` = 'BT';");
80
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '391' WHERE `country_id` = 'BW';");
81
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '73' WHERE `country_id` = 'BY';");
82
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '421' WHERE `country_id` = 'BZ';");
83
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '404' WHERE `country_id` = 'CA';");
84
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '306' WHERE `country_id` = 'CF';");
85
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '318' WHERE `country_id` = 'CG';");
86
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '36' WHERE `country_id` = 'CH';");
87
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '272' WHERE `country_id` = 'CI';");
88
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '512' WHERE `country_id` = 'CL';");
89
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '302' WHERE `country_id` = 'CM';");
90
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '720' WHERE `country_id` = 'CN';");
91
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '480' WHERE `country_id` = 'CO';");
92
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '436' WHERE `country_id` = 'CR';");
93
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '448' WHERE `country_id` = 'CU';");
94
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '247' WHERE `country_id` = 'CV';");
95
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '600' WHERE `country_id` = 'CY';");
96
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '61' WHERE `country_id` = 'CZ';");
97
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '4' WHERE `country_id` = 'DE';");
98
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '338' WHERE `country_id` = 'DJ';");
99
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '8' WHERE `country_id` = 'DK';");
100
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '460' WHERE `country_id` = 'DM';");
101
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '456' WHERE `country_id` = 'DO';");
102
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '208' WHERE `country_id` = 'DZ';");
103
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '22' WHERE `country_id` = 'EA';");
104
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '500' WHERE `country_id` = 'EC';");
105
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '53' WHERE `country_id` = 'EE';");
106
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '220' WHERE `country_id` = 'EG';");
107
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '336' WHERE `country_id` = 'ER';");
108
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '11' WHERE `country_id` = 'ES';");
109
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '334' WHERE `country_id` = 'ET';");
110
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '32' WHERE `country_id` = 'FI';");
111
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '815' WHERE `country_id` = 'FJ';");
112
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '529' WHERE `country_id` = 'FK';");
113
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '823' WHERE `country_id` = 'FM';");
114
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '25' WHERE `country_id` = 'FO';");
115
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '1' WHERE `country_id` = 'FR';");
116
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '314' WHERE `country_id` = 'GA';");
117
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '6' WHERE `country_id` = 'GB';");
118
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '473' WHERE `country_id` = 'GD';");
119
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '76' WHERE `country_id` = 'GE';");
120
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '496' WHERE `country_id` = 'GF';");
121
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '276' WHERE `country_id` = 'GH';");
122
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '44' WHERE `country_id` = 'GI';");
123
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '406' WHERE `country_id` = 'GL';");
124
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '252' WHERE `country_id` = 'GM';");
125
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '260' WHERE `country_id` = 'GN';");
126
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '458' WHERE `country_id` = 'GP';");
127
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '310' WHERE `country_id` = 'GQ';");
128
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '9' WHERE `country_id` = 'GR';");
129
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '416' WHERE `country_id` = 'GT';");
130
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '257' WHERE `country_id` = 'GW';");
131
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '488' WHERE `country_id` = 'GY';");
132
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '740' WHERE `country_id` = 'HK';");
133
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '424' WHERE `country_id` = 'HN';");
134
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '92' WHERE `country_id` = 'HR';");
135
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '452' WHERE `country_id` = 'HT';");
136
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '64' WHERE `country_id` = 'HU';");
137
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '21' WHERE `country_id` = 'IC';");
138
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '700' WHERE `country_id` = 'ID';");
139
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '7' WHERE `country_id` = 'IE';");
140
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '624' WHERE `country_id` = 'IL';");
141
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '664' WHERE `country_id` = 'IN';");
142
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '357' WHERE `country_id` = 'IO';");
143
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '612' WHERE `country_id` = 'IQ';");
144
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '616' WHERE `country_id` = 'IR';");
145
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '24' WHERE `country_id` = 'IS';");
146
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '5' WHERE `country_id` = 'IT';");
147
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '464' WHERE `country_id` = 'JM';");
148
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '628' WHERE `country_id` = 'JO';");
149
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '732' WHERE `country_id` = 'JP';");
150
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '346' WHERE `country_id` = 'KE';");
151
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '83' WHERE `country_id` = 'KG';");
152
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '696' WHERE `country_id` = 'KH';");
153
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '812' WHERE `country_id` = 'KI';");
154
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '375' WHERE `country_id` = 'KM';");
155
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '449' WHERE `country_id` = 'KN';");
156
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '724' WHERE `country_id` = 'KP';");
157
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '728' WHERE `country_id` = 'KR';");
158
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '636' WHERE `country_id` = 'KW';");
159
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '463' WHERE `country_id` = 'KY';");
160
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '79' WHERE `country_id` = 'KZ';");
161
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '684' WHERE `country_id` = 'LA';");
162
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '604' WHERE `country_id` = 'LB';");
163
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '465' WHERE `country_id` = 'LC';");
164
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '37' WHERE `country_id` = 'LI';");
165
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '669' WHERE `country_id` = 'LK';");
166
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '268' WHERE `country_id` = 'LR';");
167
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '395' WHERE `country_id` = 'LS';");
168
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '55' WHERE `country_id` = 'LT';");
169
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '23' WHERE `country_id` = 'LU';");
170
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '54' WHERE `country_id` = 'LV';");
171
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '216' WHERE `country_id` = 'LY';");
172
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '204' WHERE `country_id` = 'MA';");
173
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '825' WHERE `country_id` = 'MC';");
174
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '74' WHERE `country_id` = 'MD';");
175
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '370' WHERE `country_id` = 'MG';");
176
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '824' WHERE `country_id` = 'MH';");
177
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '96' WHERE `country_id` = 'MK';");
178
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '232' WHERE `country_id` = 'ML';");
179
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '676' WHERE `country_id` = 'MM';");
180
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '716' WHERE `country_id` = 'MN';");
181
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '743' WHERE `country_id` = 'MO';");
182
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '462' WHERE `country_id` = 'MQ';");
183
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '228' WHERE `country_id` = 'MR';");
184
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '46' WHERE `country_id` = 'MT';");
185
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '373' WHERE `country_id` = 'MU';");
186
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '667' WHERE `country_id` = 'MV';");
187
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '386' WHERE `country_id` = 'MW';");
188
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '412' WHERE `country_id` = 'MX';");
189
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '701' WHERE `country_id` = 'MY';");
190
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '366' WHERE `country_id` = 'MZ';");
191
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '389' WHERE `country_id` = 'NA';");
192
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '809' WHERE `country_id` = 'NC';");
193
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '240' WHERE `country_id` = 'NE';");
194
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '288' WHERE `country_id` = 'NG';");
195
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '432' WHERE `country_id` = 'NI';");
196
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '3' WHERE `country_id` = 'NL';");
197
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '28' WHERE `country_id` = 'NO';");
198
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '672' WHERE `country_id` = 'NP';");
199
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '803' WHERE `country_id` = 'NR';");
200
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '804' WHERE `country_id` = 'NZ';");
201
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '649' WHERE `country_id` = 'OM';");
202
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '442' WHERE `country_id` = 'PA';");
203
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '504' WHERE `country_id` = 'PE';");
204
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '822' WHERE `country_id` = 'PF';");
205
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '801' WHERE `country_id` = 'PG';");
206
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '708' WHERE `country_id` = 'PH';");
207
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '662' WHERE `country_id` = 'PK';");
208
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '60' WHERE `country_id` = 'PL';");
209
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '408' WHERE `country_id` = 'PM';");
210
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '813' WHERE `country_id` = 'PN';");
211
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '455' WHERE `country_id` = 'PR';");
212
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '10' WHERE `country_id` = 'PT';");
213
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '520' WHERE `country_id` = 'PY';");
214
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '644' WHERE `country_id` = 'QA';");
215
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '372' WHERE `country_id` = 'RE';");
216
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '66' WHERE `country_id` = 'RO';");
217
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '94' WHERE `country_id` = 'RS';");
218
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '75' WHERE `country_id` = 'RU';");
219
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '324' WHERE `country_id` = 'RW';");
220
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '632' WHERE `country_id` = 'SA';");
221
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '806' WHERE `country_id` = 'SB';");
222
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '355' WHERE `country_id` = 'SC';");
223
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '224' WHERE `country_id` = 'SD';");
224
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '30' WHERE `country_id` = 'SE';");
225
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '706' WHERE `country_id` = 'SG';");
226
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '329' WHERE `country_id` = 'SH';");
227
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '91' WHERE `country_id` = 'SI';");
228
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '63' WHERE `country_id` = 'SK';");
229
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '264' WHERE `country_id` = 'SL';");
230
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '248' WHERE `country_id` = 'SN';");
231
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '342' WHERE `country_id` = 'SO';");
232
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '492' WHERE `country_id` = 'SR';");
233
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '311' WHERE `country_id` = 'ST';");
234
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '428' WHERE `country_id` = 'SV';");
235
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '608' WHERE `country_id` = 'SY';");
236
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '393' WHERE `country_id` = 'SZ';");
237
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '454' WHERE `country_id` = 'TC';");
238
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '244' WHERE `country_id` = 'TD';");
239
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '280' WHERE `country_id` = 'TG';");
240
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '680' WHERE `country_id` = 'TH';");
241
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '82' WHERE `country_id` = 'TJ';");
242
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '80' WHERE `country_id` = 'TM';");
243
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '212' WHERE `country_id` = 'TN';");
244
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '817' WHERE `country_id` = 'TO';");
245
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '52' WHERE `country_id` = 'TR';");
246
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '472' WHERE `country_id` = 'TT';");
247
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '807' WHERE `country_id` = 'TV';");
248
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '736' WHERE `country_id` = 'TW';");
249
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '352' WHERE `country_id` = 'TZ';");
250
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '72' WHERE `country_id` = 'UA';");
251
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '350' WHERE `country_id` = 'UG';");
252
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '400' WHERE `country_id` = 'US';");
253
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '524' WHERE `country_id` = 'UY';");
254
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '81' WHERE `country_id` = 'UZ';");
255
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '45' WHERE `country_id` = 'VA';");
256
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '467' WHERE `country_id` = 'VC';");
257
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '484' WHERE `country_id` = 'VE';");
258
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '461' WHERE `country_id` = 'VG';");
259
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '690' WHERE `country_id` = 'VN';");
260
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '816' WHERE `country_id` = 'VU';");
261
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '811' WHERE `country_id` = 'WF';");
262
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '819' WHERE `country_id` = 'WS';");
263
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '653' WHERE `country_id` = 'YE';");
264
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '377' WHERE `country_id` = 'YT';");
265
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '48' WHERE `country_id` = 'YU';");
266
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '388' WHERE `country_id` = 'ZA';");
267
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '378' WHERE `country_id` = 'ZM';");
268
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '322' WHERE `country_id` = 'ZR';");
269
- $installer->run("UPDATE {$this->getTable('directory_country')} SET `dolist_code` = '382' WHERE `country_id` = 'ZW';");
270
  } catch (Exception $e) {
271
  Mage::logException($e);
272
  }
14
  // Create new table to store Dolist-EMT templates
15
  $installer->run(
16
  "
17
+ DROP TABLE IF EXISTS " . Mage::helper('dolist')->getTablename('dolist_dolistemt_template') . ";
18
+ CREATE TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistemt_template') . " (
19
  `id` int(10) unsigned NOT NULL auto_increment,
20
  `template_id` int(10) unsigned NOT NULL,
21
  `template_name` varchar(255) NOT NULL default '',
29
  // Alter column only if column does not already exist
30
  $installer->run(
31
  "
32
+ ALTER TABLE " . Mage::helper('dolist')->getTablename('newsletter_subscriber') . "
33
  ADD COLUMN `dolist_status` int(11) NOT NULL default '0',
34
  ADD COLUMN `updated_at` datetime DEFAULT NULL;
35
  "
43
  // Alter column only if column does not already exist
44
  $installer->run(
45
  "
46
+ ALTER TABLE " . Mage::helper('dolist')->getTablename('directory_country') . "
47
  ADD COLUMN `dolist_code` varchar(3) NOT NULL default '999';
48
  "
49
  );
50
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '43' WHERE `country_id` = 'AD';");
51
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '645' WHERE `country_id` = 'AE';");
52
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '647' WHERE `country_id` = 'AE';");
53
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '660' WHERE `country_id` = 'AF';");
54
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '459' WHERE `country_id` = 'AG';");
55
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '446' WHERE `country_id` = 'AI';");
56
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '70' WHERE `country_id` = 'AL';");
57
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '77' WHERE `country_id` = 'AM';");
58
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '478' WHERE `country_id` = 'AN';");
59
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '330' WHERE `country_id` = 'AO';");
60
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '528' WHERE `country_id` = 'AR';");
61
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '38' WHERE `country_id` = 'AT';");
62
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '800' WHERE `country_id` = 'AU';");
63
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '474' WHERE `country_id` = 'AW';");
64
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '78' WHERE `country_id` = 'AZ';");
65
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '93' WHERE `country_id` = 'BA';");
66
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '469' WHERE `country_id` = 'BB';");
67
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '666' WHERE `country_id` = 'BD';");
68
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '2' WHERE `country_id` = 'BE';");
69
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '236' WHERE `country_id` = 'BF';");
70
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '68' WHERE `country_id` = 'BG';");
71
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '640' WHERE `country_id` = 'BH';");
72
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '328' WHERE `country_id` = 'BI';");
73
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '284' WHERE `country_id` = 'BJ';");
74
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '413' WHERE `country_id` = 'BM';");
75
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '703' WHERE `country_id` = 'BN';");
76
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '516' WHERE `country_id` = 'BO';");
77
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '508' WHERE `country_id` = 'BR';");
78
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '453' WHERE `country_id` = 'BS';");
79
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '675' WHERE `country_id` = 'BT';");
80
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '391' WHERE `country_id` = 'BW';");
81
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '73' WHERE `country_id` = 'BY';");
82
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '421' WHERE `country_id` = 'BZ';");
83
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '404' WHERE `country_id` = 'CA';");
84
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '306' WHERE `country_id` = 'CF';");
85
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '318' WHERE `country_id` = 'CG';");
86
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '36' WHERE `country_id` = 'CH';");
87
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '272' WHERE `country_id` = 'CI';");
88
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '512' WHERE `country_id` = 'CL';");
89
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '302' WHERE `country_id` = 'CM';");
90
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '720' WHERE `country_id` = 'CN';");
91
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '480' WHERE `country_id` = 'CO';");
92
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '436' WHERE `country_id` = 'CR';");
93
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '448' WHERE `country_id` = 'CU';");
94
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '247' WHERE `country_id` = 'CV';");
95
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '600' WHERE `country_id` = 'CY';");
96
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '61' WHERE `country_id` = 'CZ';");
97
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '4' WHERE `country_id` = 'DE';");
98
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '338' WHERE `country_id` = 'DJ';");
99
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '8' WHERE `country_id` = 'DK';");
100
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '460' WHERE `country_id` = 'DM';");
101
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '456' WHERE `country_id` = 'DO';");
102
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '208' WHERE `country_id` = 'DZ';");
103
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '22' WHERE `country_id` = 'EA';");
104
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '500' WHERE `country_id` = 'EC';");
105
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '53' WHERE `country_id` = 'EE';");
106
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '220' WHERE `country_id` = 'EG';");
107
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '336' WHERE `country_id` = 'ER';");
108
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '11' WHERE `country_id` = 'ES';");
109
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '334' WHERE `country_id` = 'ET';");
110
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '32' WHERE `country_id` = 'FI';");
111
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '815' WHERE `country_id` = 'FJ';");
112
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '529' WHERE `country_id` = 'FK';");
113
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '823' WHERE `country_id` = 'FM';");
114
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '25' WHERE `country_id` = 'FO';");
115
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '1' WHERE `country_id` = 'FR';");
116
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '314' WHERE `country_id` = 'GA';");
117
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '6' WHERE `country_id` = 'GB';");
118
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '473' WHERE `country_id` = 'GD';");
119
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '76' WHERE `country_id` = 'GE';");
120
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '496' WHERE `country_id` = 'GF';");
121
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '276' WHERE `country_id` = 'GH';");
122
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '44' WHERE `country_id` = 'GI';");
123
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '406' WHERE `country_id` = 'GL';");
124
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '252' WHERE `country_id` = 'GM';");
125
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '260' WHERE `country_id` = 'GN';");
126
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '458' WHERE `country_id` = 'GP';");
127
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '310' WHERE `country_id` = 'GQ';");
128
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '9' WHERE `country_id` = 'GR';");
129
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '416' WHERE `country_id` = 'GT';");
130
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '257' WHERE `country_id` = 'GW';");
131
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '488' WHERE `country_id` = 'GY';");
132
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '740' WHERE `country_id` = 'HK';");
133
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '424' WHERE `country_id` = 'HN';");
134
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '92' WHERE `country_id` = 'HR';");
135
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '452' WHERE `country_id` = 'HT';");
136
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '64' WHERE `country_id` = 'HU';");
137
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '21' WHERE `country_id` = 'IC';");
138
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '700' WHERE `country_id` = 'ID';");
139
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '7' WHERE `country_id` = 'IE';");
140
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '624' WHERE `country_id` = 'IL';");
141
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '664' WHERE `country_id` = 'IN';");
142
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '357' WHERE `country_id` = 'IO';");
143
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '612' WHERE `country_id` = 'IQ';");
144
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '616' WHERE `country_id` = 'IR';");
145
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '24' WHERE `country_id` = 'IS';");
146
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '5' WHERE `country_id` = 'IT';");
147
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '464' WHERE `country_id` = 'JM';");
148
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '628' WHERE `country_id` = 'JO';");
149
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '732' WHERE `country_id` = 'JP';");
150
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '346' WHERE `country_id` = 'KE';");
151
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '83' WHERE `country_id` = 'KG';");
152
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '696' WHERE `country_id` = 'KH';");
153
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '812' WHERE `country_id` = 'KI';");
154
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '375' WHERE `country_id` = 'KM';");
155
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '449' WHERE `country_id` = 'KN';");
156
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '724' WHERE `country_id` = 'KP';");
157
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '728' WHERE `country_id` = 'KR';");
158
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '636' WHERE `country_id` = 'KW';");
159
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '463' WHERE `country_id` = 'KY';");
160
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '79' WHERE `country_id` = 'KZ';");
161
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '684' WHERE `country_id` = 'LA';");
162
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '604' WHERE `country_id` = 'LB';");
163
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '465' WHERE `country_id` = 'LC';");
164
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '37' WHERE `country_id` = 'LI';");
165
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '669' WHERE `country_id` = 'LK';");
166
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '268' WHERE `country_id` = 'LR';");
167
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '395' WHERE `country_id` = 'LS';");
168
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '55' WHERE `country_id` = 'LT';");
169
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '23' WHERE `country_id` = 'LU';");
170
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '54' WHERE `country_id` = 'LV';");
171
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '216' WHERE `country_id` = 'LY';");
172
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '204' WHERE `country_id` = 'MA';");
173
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '825' WHERE `country_id` = 'MC';");
174
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '74' WHERE `country_id` = 'MD';");
175
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '370' WHERE `country_id` = 'MG';");
176
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '824' WHERE `country_id` = 'MH';");
177
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '96' WHERE `country_id` = 'MK';");
178
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '232' WHERE `country_id` = 'ML';");
179
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '676' WHERE `country_id` = 'MM';");
180
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '716' WHERE `country_id` = 'MN';");
181
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '743' WHERE `country_id` = 'MO';");
182
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '462' WHERE `country_id` = 'MQ';");
183
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '228' WHERE `country_id` = 'MR';");
184
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '46' WHERE `country_id` = 'MT';");
185
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '373' WHERE `country_id` = 'MU';");
186
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '667' WHERE `country_id` = 'MV';");
187
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '386' WHERE `country_id` = 'MW';");
188
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '412' WHERE `country_id` = 'MX';");
189
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '701' WHERE `country_id` = 'MY';");
190
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '366' WHERE `country_id` = 'MZ';");
191
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '389' WHERE `country_id` = 'NA';");
192
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '809' WHERE `country_id` = 'NC';");
193
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '240' WHERE `country_id` = 'NE';");
194
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '288' WHERE `country_id` = 'NG';");
195
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '432' WHERE `country_id` = 'NI';");
196
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '3' WHERE `country_id` = 'NL';");
197
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '28' WHERE `country_id` = 'NO';");
198
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '672' WHERE `country_id` = 'NP';");
199
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '803' WHERE `country_id` = 'NR';");
200
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '804' WHERE `country_id` = 'NZ';");
201
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '649' WHERE `country_id` = 'OM';");
202
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '442' WHERE `country_id` = 'PA';");
203
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '504' WHERE `country_id` = 'PE';");
204
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '822' WHERE `country_id` = 'PF';");
205
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '801' WHERE `country_id` = 'PG';");
206
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '708' WHERE `country_id` = 'PH';");
207
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '662' WHERE `country_id` = 'PK';");
208
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '60' WHERE `country_id` = 'PL';");
209
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '408' WHERE `country_id` = 'PM';");
210
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '813' WHERE `country_id` = 'PN';");
211
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '455' WHERE `country_id` = 'PR';");
212
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '10' WHERE `country_id` = 'PT';");
213
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '520' WHERE `country_id` = 'PY';");
214
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '644' WHERE `country_id` = 'QA';");
215
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '372' WHERE `country_id` = 'RE';");
216
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '66' WHERE `country_id` = 'RO';");
217
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '94' WHERE `country_id` = 'RS';");
218
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '75' WHERE `country_id` = 'RU';");
219
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '324' WHERE `country_id` = 'RW';");
220
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '632' WHERE `country_id` = 'SA';");
221
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '806' WHERE `country_id` = 'SB';");
222
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '355' WHERE `country_id` = 'SC';");
223
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '224' WHERE `country_id` = 'SD';");
224
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '30' WHERE `country_id` = 'SE';");
225
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '706' WHERE `country_id` = 'SG';");
226
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '329' WHERE `country_id` = 'SH';");
227
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '91' WHERE `country_id` = 'SI';");
228
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '63' WHERE `country_id` = 'SK';");
229
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '264' WHERE `country_id` = 'SL';");
230
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '248' WHERE `country_id` = 'SN';");
231
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '342' WHERE `country_id` = 'SO';");
232
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '492' WHERE `country_id` = 'SR';");
233
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '311' WHERE `country_id` = 'ST';");
234
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '428' WHERE `country_id` = 'SV';");
235
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '608' WHERE `country_id` = 'SY';");
236
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '393' WHERE `country_id` = 'SZ';");
237
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '454' WHERE `country_id` = 'TC';");
238
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '244' WHERE `country_id` = 'TD';");
239
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '280' WHERE `country_id` = 'TG';");
240
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '680' WHERE `country_id` = 'TH';");
241
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '82' WHERE `country_id` = 'TJ';");
242
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '80' WHERE `country_id` = 'TM';");
243
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '212' WHERE `country_id` = 'TN';");
244
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '817' WHERE `country_id` = 'TO';");
245
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '52' WHERE `country_id` = 'TR';");
246
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '472' WHERE `country_id` = 'TT';");
247
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '807' WHERE `country_id` = 'TV';");
248
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '736' WHERE `country_id` = 'TW';");
249
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '352' WHERE `country_id` = 'TZ';");
250
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '72' WHERE `country_id` = 'UA';");
251
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '350' WHERE `country_id` = 'UG';");
252
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '400' WHERE `country_id` = 'US';");
253
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '524' WHERE `country_id` = 'UY';");
254
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '81' WHERE `country_id` = 'UZ';");
255
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '45' WHERE `country_id` = 'VA';");
256
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '467' WHERE `country_id` = 'VC';");
257
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '484' WHERE `country_id` = 'VE';");
258
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '461' WHERE `country_id` = 'VG';");
259
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '690' WHERE `country_id` = 'VN';");
260
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '816' WHERE `country_id` = 'VU';");
261
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '811' WHERE `country_id` = 'WF';");
262
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '819' WHERE `country_id` = 'WS';");
263
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '653' WHERE `country_id` = 'YE';");
264
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '377' WHERE `country_id` = 'YT';");
265
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '48' WHERE `country_id` = 'YU';");
266
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '388' WHERE `country_id` = 'ZA';");
267
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '378' WHERE `country_id` = 'ZM';");
268
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '322' WHERE `country_id` = 'ZR';");
269
+ $installer->run("UPDATE " . Mage::helper('dolist')->getTablename('directory_country') . " SET `dolist_code` = '382' WHERE `country_id` = 'ZW';");
270
  } catch (Exception $e) {
271
  Mage::logException($e);
272
  }
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.1.0-0.0.1.1.php CHANGED
@@ -16,7 +16,7 @@ try {
16
  // Alter column only if column does not already exist
17
  $installer->run(
18
  "
19
- ALTER TABLE {$this->getTable('newsletter_subscriber')}
20
  DROP COLUMN `updated_at`,
21
  ADD COLUMN `updated_at` int(10) DEFAULT 0;
22
  "
16
  // Alter column only if column does not already exist
17
  $installer->run(
18
  "
19
+ ALTER TABLE " . Mage::helper('dolist')->getTablename('newsletter_subscriber') . "
20
  DROP COLUMN `updated_at`,
21
  ADD COLUMN `updated_at` int(10) DEFAULT 0;
22
  "
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.1.1-0.0.2.0.php CHANGED
@@ -16,8 +16,8 @@ try {
16
  // Alter column only if column does not already exist
17
  $installer->run(
18
  "
19
- DROP TABLE IF EXISTS {$this->getTable('dolist_dolistemt_message_queue')};
20
- CREATE TABLE {$this->getTable('dolist_dolistemt_message_queue')} (
21
  `id` bigint unsigned NOT NULL auto_increment,
22
  `template_id` int(10) unsigned NOT NULL,
23
  `serialized_message` LONGTEXT NOT NULL default '',
16
  // Alter column only if column does not already exist
17
  $installer->run(
18
  "
19
+ DROP TABLE IF EXISTS " . Mage::helper('dolist')->getTablename('dolist_dolistemt_message_queue') . ";
20
+ CREATE TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistemt_message_queue') . " (
21
  `id` bigint unsigned NOT NULL auto_increment,
22
  `template_id` int(10) unsigned NOT NULL,
23
  `serialized_message` LONGTEXT NOT NULL default '',
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.2.0-0.0.3.0.php CHANGED
@@ -16,8 +16,8 @@ $installer->startSetup();
16
 
17
  $installer->run(
18
  "
19
- DROP TABLE IF EXISTS {$this->getTable('dolist_dolistv8_calculatedfields')};
20
- CREATE TABLE {$this->getTable('dolist_dolistv8_calculatedfields')} (
21
  `customer_id` int(10) unsigned,
22
  `first_order_amount` decimal(12,4) DEFAULT NULL,
23
  `first_order_amount_with_vat` decimal(12,4) DEFAULT NULL,
16
 
17
  $installer->run(
18
  "
19
+ DROP TABLE IF EXISTS " . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . ";
20
+ CREATE TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . " (
21
  `customer_id` int(10) unsigned,
22
  `first_order_amount` decimal(12,4) DEFAULT NULL,
23
  `first_order_amount_with_vat` decimal(12,4) DEFAULT NULL,
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.3.0-0.0.4.0.php CHANGED
@@ -15,8 +15,8 @@ $installer->startSetup();
15
  // Create new table to store Dolist-EMT templates
16
  $installer->run(
17
  "
18
- DROP TABLE IF EXISTS {$this->getTable('dolist_dolistv8_customfields')};
19
- CREATE TABLE {$this->getTable('dolist_dolistv8_customfields')} (
20
  `id` int(10) unsigned AUTO_INCREMENT,
21
  `type` varchar(255) NOT NULL,
22
  `name` varchar(255) NOT NULL,
15
  // Create new table to store Dolist-EMT templates
16
  $installer->run(
17
  "
18
+ DROP TABLE IF EXISTS " . Mage::helper('dolist')->getTablename('dolist_dolistv8_customfields') . ";
19
+ CREATE TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_customfields') . " (
20
  `id` int(10) unsigned AUTO_INCREMENT,
21
  `type` varchar(255) NOT NULL,
22
  `name` varchar(255) NOT NULL,
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.4.0-0.0.5.0.php CHANGED
@@ -15,8 +15,8 @@ $installer->startSetup();
15
  // Create new table to store Dolist-EMT templates
16
  $installer->run(
17
  "
18
- DROP TABLE IF EXISTS {$this->getTable('dolist_reports')};
19
- CREATE TABLE {$this->getTable('dolist_reports')} (
20
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
21
  `type` varchar(255) NOT NULL,
22
  `name` varchar(255) NOT NULL,
15
  // Create new table to store Dolist-EMT templates
16
  $installer->run(
17
  "
18
+ DROP TABLE IF EXISTS " . Mage::helper('dolist')->getTablename('dolist_reports') . ";
19
+ CREATE TABLE " . Mage::helper('dolist')->getTablename('dolist_reports') . " (
20
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
21
  `type` varchar(255) NOT NULL,
22
  `name` varchar(255) NOT NULL,
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-0.0.5.0-0.0.6.0.php CHANGED
@@ -14,10 +14,10 @@ $installer->startSetup();
14
 
15
  // Create new table to store Dolist-EMT templates
16
  $installer->run(
17
- "ALTER TABLE {$this->getTable('dolist_dolistv8_customfields')} ADD scope VARCHAR(8) AFTER magento_field, ADD scope_id INT AFTER scope;"
18
  );
19
  $installer->run(
20
- "ALTER TABLE {$this->getTable('dolist_dolistv8_customfields')} ADD CONSTRAINT uc_namescope UNIQUE (name,scope_id)"
21
  );
22
 
23
  $installer->endSetup();
14
 
15
  // Create new table to store Dolist-EMT templates
16
  $installer->run(
17
+ "ALTER TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_customfields') . " ADD scope VARCHAR(8) AFTER magento_field, ADD scope_id INT AFTER scope;"
18
  );
19
  $installer->run(
20
+ "ALTER TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_customfields') . " ADD CONSTRAINT uc_namescope UNIQUE (name,scope_id)"
21
  );
22
 
23
  $installer->endSetup();
app/code/community/Dolist/Net/sql/dolist_setup/mysql4-upgrade-2.0.0.6-2.0.0.7.php CHANGED
@@ -5,10 +5,11 @@ $installer = $this;
5
  $installer->startSetup();
6
 
7
  // Create new table to store Dolist-EMT templates
8
- $installer->run("ALTER TABLE {$this->getTable('dolist_dolistv8_calculatedfields')} DROP PRIMARY KEY;");
9
- $installer->run("ALTER TABLE {$this->getTable('dolist_dolistv8_calculatedfields')} ADD id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;");
10
- $installer->run("ALTER TABLE {$this->getTable('dolist_dolistv8_calculatedfields')} ADD store_id INT AFTER start_date;");
11
- $installer->run("ALTER TABLE {$this->getTable('dolist_dolistv8_calculatedfields')} ADD CONSTRAINT uc_customerid_storeid UNIQUE (customer_id,store_id);");
12
- $installer->run("TRUNCATE TABLE {$this->getTable('dolist_dolistv8_calculatedfields')};");
 
13
 
14
  $installer->endSetup();
5
  $installer->startSetup();
6
 
7
  // Create new table to store Dolist-EMT templates
8
+
9
+ $installer->run("ALTER TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . " DROP PRIMARY KEY;");
10
+ $installer->run("ALTER TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . " ADD id INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;");
11
+ $installer->run("ALTER TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . " ADD store_id INT AFTER start_date;");
12
+ $installer->run("ALTER TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . " ADD CONSTRAINT uc_customerid_storeid UNIQUE (customer_id,store_id);");
13
+ $installer->run("TRUNCATE TABLE " . Mage::helper('dolist')->getTablename('dolist_dolistv8_calculatedfields') . ";");
14
 
15
  $installer->endSetup();
package.xml CHANGED
@@ -1,5 +1,5 @@
1
  <?xml version='1.0' encoding='utf-8'?>
2
- <package><name>Dolist_Net</name><license uri="http://opensource.org/licenses/osl-3.0.php">OSL 3.0</license><notes>v2</notes><time>13:03:27</time><__packager>build_package.py v0.0.3</__packager><summary>Official extension for Dolist email marketing solution.</summary><stability>stable</stability><__commit_hash>3fd91bb2c8970335abf0e1f89640f460a9ddb96a</__commit_hash><version>2.0.2.0</version><extends /><contents><target name="mage"><dir name="shell"><file hash="9b10f919097a3abe18833961359449c4" name="dolist_export_segments.php" /></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file hash="9116ca5966c127c3a065d3ccf991f6dd" name="dolist.xml" /></dir><dir name="template"><dir name="dolist"><file hash="05db7ca8032551aea167c573c06d0287" name="configuration.phtml" /><file hash="468f46da25ee4c840098e0754299a9a1" name="customerexport.phtml" /><dir name="store"><file hash="4100093e08cf4ce57c317ee017cba630" name="switcher.phtml" /></dir><dir name="system"><dir name="config"><dir name="dolistemt"><file hash="ba10b87cd51fef3d88a0dcf747d8b8dc" name="testconnection.phtml" /></dir><dir name="dolistv8"><file hash="a9b57b458cb1dfb83f0f5061be82f9f9" name="array.phtml" /><file hash="5c89a07ee29d11640870592c2edfc114" name="testconnection.phtml" /></dir></dir></dir></dir></dir></dir></dir></dir></target><target name="magecommunity"><dir name="Dolist"><dir name="Net"><dir name="Block"><dir name="Adminhtml"><file hash="b5c65ae9b68d820870fb38e78e100265" name="Customerexport.php" /><file hash="fd8f4ad560d6777587a9ed90223c18c4" name="Edit.php" /><file hash="2e37abf70940f00b110279cef8b82280" name="Report.php" /><dir name="Customer"><file hash="8f6d9965be320c972d998f34171c4a5a" name="Edit.php" /></dir><dir name="Customersegment"><file hash="cf6a52e571dd475b96e93c00a8e2b5f0" name="Edit.php" /></dir><dir name="Edit"><file hash="057c9ee5853ea17801c990b42385fa5f" name="Form.php" /><file hash="45aba333e3e017601eff3a730e2991df" name="Tabs.php" /><dir name="Tab"><file hash="d93a56df1f7d60a8f4d275886f150ddf" name="Configuration.php" /><file hash="d1299519d583afd8b8afdad5ddafc326" name="Export.php" /><file hash="a55d01b5e4d114b20adef94f5dc503db" name="Report.php" /></dir></dir><dir name="System"><dir name="Config"><file hash="8393df0943d5575c31cb596c8d368ce6" name="Abstract.php" /><file hash="77b6b112b2492beb3dae124efe0b924a" name="Date.php" /><file hash="59fa9be3d71a648ab9d4dfe697d2e183" name="Enable.php" /><file hash="c62a40696ae0028b2908ed34768d8c2a" name="Switcher.php" /><file hash="883194919f569b7f49a12fd9d4f83082" name="Templatelist.php" /><dir name="Dolistemt"><file hash="9193591b22b093d9e5baaf83b0818ec8" name="Templatelist.php" /><file hash="4025ca1026614c48996c57112b25cf1c" name="Templatemapping.php" /><file hash="b95697d6fea9d16003f01b5a1f63db6a" name="Testconnection.php" /></dir><dir name="Dolistv8"><file hash="5be525c4398c036956d6489aa8fa582d" name="Attributelist.php" /><file hash="88336cf98961a1df4e23bf2de819c17d" name="Customdatefields.php" /><file hash="485252191fb609780609f7ec6b9d0fad" name="Customerattributelist.php" /><file hash="96a8428b3503291204d8922500e39210" name="Customintfields.php" /><file hash="2011749c69cae4968ded68dc4cce6945" name="Customstrfields.php" /><file hash="cb016b986834178808cad7dd9c8d96c2" name="Testconnection.php" /></dir></dir></dir></dir></dir><dir name="controllers"><dir name="Adminhtml"><file hash="651fed35ece40312ac21e2fb8efd1dea" name="CustomerdolistController.php" /><dir name="System"><dir name="Config"><file hash="9c42cecb347d4ffb4db54ee901345359" name="TestconnectionController.php" /></dir></dir></dir></dir><dir name="etc"><file hash="1f9d77e2b9f8e4b86f54f272eb213218" name="adminhtml.xml" /><file hash="156679287f061e6470c7699ee4554fe4" name="config.xml" /><file hash="f0d6b4651431d1d11532fe9402fc5003" name="system.xml" /></dir><dir name="Helper"><file hash="d7058bb7a3ae89c7a586d8b42ad64062" name="Data.php" /><file hash="1d28b2acc7b47c17bb17af60e60c891d" name="Log.php" /><file hash="46b027b6f19b5a4ba72e1e992ac95269" name="Queue.php" /></dir><dir name="Model"><file hash="61da7cc29853bb9ce85b0bb587545c99" name="Customersegment.php" /><file hash="84647426508242e63f12912bd49ce3be" name="Observer.php" /><file hash="5a820cdad6554553ba9ecc189862397e" name="Reports.php" /><file hash="82d5e0530ce00299650055c3f5b0bf63" name="Service.php" /><dir name="Adminhtml"><file hash="8ff835df0881b386870fe52a116e10bb" name="Observer.php" /><dir name="System"><dir name="Config"><dir name="Backend"><dir name="Serialized"><file hash="ce8002b5ba1bd19901b5de4db7200672" name="Array.php" /></dir></dir><dir name="Source"><file hash="d594a5df0ec9c76ca0f55ac0c4422f56" name="Timeperiods.php" /></dir></dir></dir></dir><dir name="Dolistemt"><file hash="67917ea713604769bdc5e348d04830b4" name="Template.php" /><dir name="Email"><file hash="7e39b7cdc9a6f62c784937317d344d0b" name="Template.php" /></dir><dir name="Message"><file hash="3dd939ec132047606cc1f322677bcc1c" name="Queued.php" /></dir></dir><dir name="Dolistv8"><file hash="a45ccd59e014474c4902742db468bdcc" name="Calculatedfields.php" /><file hash="b1d4006ddf6c62b46bcadeb6a6b56fc0" name="Customfields.php" /><file hash="6a91b08ff749b635ffaff68a267cee53" name="Ftp.php" /></dir><dir name="Exporter"><file hash="83168b8fa77083c3157af0ef50d78cf0" name="Csv.php" /><dir name="Adapter"><file hash="c52f8d05c198b2ee691d25104aa191ca" name="Date.php" /><file hash="66b2ee18bdf3924011a068f936b8818a" name="Default.php" /><file hash="797f1a935a1f8e1a9ce213d6cf03c235" name="Int.php" /></dir></dir><dir name="Mysql4"><file hash="7a3a3de6ef2fd144c192ef60357e370f" name="Reports.php" /><dir name="Dolistemt"><file hash="f972ef82ba3003da8d849e60df044440" name="Template.php" /><dir name="Message"><file hash="466461ebec5e905d89659698a21ed0ed" name="Queued.php" /><dir name="Queued"><file hash="1b0ed0a91ecd7fb5941c694221d12578" name="Collection.php" /></dir></dir><dir name="Template"><file hash="7b845449076c1dfaee11a7b04cb50400" name="Collection.php" /></dir></dir><dir name="Dolistv8"><file hash="69ccfc96fcdc3958b5cf09b4a68c4228" name="Calculatedfields.php" /><file hash="0c66d48562faaa3641a190becc66f618" name="Customfields.php" /><dir name="Calculatedfields"><file hash="106dc6dd921c134378002992e4d94e08" name="Collection.php" /></dir><dir name="Customfields"><file hash="93a52bb46b05487e79471448b46ca51e" name="Collection.php" /></dir><dir name="Export"><dir name="Adapter"><file hash="08a870e9120893dfe74349313bbb0c75" name="Abstract.php" /><file hash="83d064b83909ac3a4421d474397b5029" name="Address1.php" /><file hash="b9dc124ff88ecbaa750e580f97b246f2" name="Address2.php" /><file hash="b87316bf23926e93485b6868323f88a4" name="Address3.php" /><file hash="75e243f2a3526955ea7d94cad4798ec2" name="City.php" /><file hash="b2372fe91c4a61bd81549fbee4722e85" name="Company.php" /><file hash="176e3a58ab1371ffd87a8dd41ff6231b" name="Country.php" /><file hash="a47e3ada99704b2cfebd7ed151d39762" name="Default.php" /><file hash="a96d9b7d0d6e810533df36901e0dc7ac" name="Fax.php" /><file hash="f044aed5b697abb4b5b7722307413fef" name="Phone.php" /><file hash="1a84be76756c8b6e550a683301bf455f" name="Postcode.php" /><dir name="Date"><file hash="c46a5408f7f314ff3a81c71af1fa15e2" name="Default.php" /><file hash="a48a0eed243297a43aa6461c1b5b6e03" name="Firstorder.php" /><file hash="05f3b71b731ef2705dbb6fa1368e896f" name="Lastorder.php" /><file hash="b05b9d4832f4d71b514cef3df5d2fffc" name="Lastquotenotordered.php" /></dir><dir name="Int"><file hash="ee37b3a560f78424f854a7b0ddfcb81a" name="Avgnbdifferentproductsperorder.php" /><file hash="99ed6713b29425a263f344605c30a92e" name="Avgnbdifferentproductsperorderline.php" /><file hash="4ced1dd88746fae3cc32d6c8f3305aec" name="Avgnbproductsperorder.php" /><file hash="cac637c6aa9c4e9b97c36727c9d7ecab" name="Avgorderamountexcltax.php" /><file hash="6573738e3dc12cbb2348633635c3f1fb" name="Avgorderamountincltax.php" /><file hash="89686b61f7e201bf64a26c91ff035a34" name="Firstorderamountexcltax.php" /><file hash="50f04945e8297134b6fde3c305ae4d0b" name="Firstorderamountincltax.php" /><file hash="93cd651cf1b246f8670604e1278b938d" name="Lastnotorderedcartamountexcltax.php" /><file hash="5ba8b21f31f42f72d017579313d7be02" name="Lastnotorderedcartamountincltax.php" /><file hash="60cb423f6ee43a558c6a1f376838701f" name="Lastorderamountexcltax.php" /><file hash="e59c163c0f82fe449ee6d4da5f3a02b9" name="Lastorderamountincltax.php" /><file hash="6adaf658e0cd36f0980344c727439d4c" name="Nbpromotionrulesused.php" /><file hash="f0c0d785e76069fd95095d33cd10f88f" name="Totalorderamountexcltax.php" /><file hash="0aca766b611a08ea57d01b8f8066e77f" name="Totalorderamountincltax.php" /><file hash="713e6a127000c24fa32edd98f3893e32" name="Totalorderedproducts.php" /><file hash="215bb7375fe16e53c4230659819c1e62" name="Totalorders.php" /></dir></dir></dir></dir><dir name="Reports"><file hash="3ec7cc4fd35c539db1411cbe0bf98a25" name="Collection.php" /></dir></dir><dir name="Service"><dir name="Dolistemt"><dir name="Request"><file hash="bfe76bef2f1301562f9003cacd82b5b1" name="Getauthenticationtoken.php" /><file hash="f08c835bbcb6ca69daf2bdeaaea28a4c" name="Gettemplatelist.php" /><file hash="06062e2ccf54c189874000d50d909de6" name="SendEmail.php" /></dir><dir name="Response"><file hash="387210c798ed818d410ac7a62a8f7a08" name="Getauthenticationtoken.php" /><file hash="ab3db8a6a1bc1e38dc163c28f64f9612" name="Gettemplatelist.php" /><file hash="45d3740fe05ecd90bf722b19725ad7d8" name="SendEmail.php" /></dir></dir><dir name="Dolistv8"><dir name="Request"><file hash="55a56a710b88398c99f1aaeb01816976" name="Createimport.php" /><file hash="af14961d044f007696452307b9f7a89e" name="Getauthenticationtoken.php" /><file hash="d085194dc5f599884969de6f5cc32f9d" name="Getcontact.php" /><file hash="d710c9e4d512a929e4aa2a0c32d1becc" name="Getfieldlist.php" /></dir><dir name="Response"><file hash="93e32967b4c1ba7ae0981023e49f9471" name="Createimport.php" /><file hash="5f14b532c12728495b6163092bce1003" name="Getauthenticationtoken.php" /><file hash="59c766c7fefe70fb1e18571f8904942a" name="Getcontact.php" /><file hash="1ab5aef6b09f671a382d5eef5a182bce" name="Getfieldlist.php" /></dir></dir><dir name="Message"><file hash="e10bee52c6cebf4ccd4c93a41afe5ae0" name="Abstract.php" /></dir></dir><dir name="System"><dir name="Config"><file hash="b64b291b560a8522094c203333cadae6" name="Check.php" /><dir name="Source"><file hash="3d7e993ac25b0ade883df78a9ef97b19" name="Group.php" /><dir name="Dolistemt"><file hash="de59edbfbae9db377ff561a49fcb8ff5" name="Defaulttemplate.php" /><file hash="6fe1abcf43f76468eaea0e3616584243" name="Errors.php" /><file hash="8debc19194b97203394b012b0258ac91" name="Template.php" /></dir><dir name="Dolistv8"><file hash="7bcd4cf17c51414df7c4633b6c89ddf2" name="Customerattributelist.php" /><file hash="10485fb8f6477d5a55c2b8ddcd4c9d02" name="Customfield.php" /></dir><dir name="Email"><file hash="e5af986543b65db2684e4a62a3967a89" name="Template.php" /></dir></dir></dir></dir></dir><dir name="sql"><dir name="dolist_setup"><file hash="dfd2ee346a310bb35daafbe68c4794a3" name="mysql4-install-0.0.1.0.php" /><file hash="f073c48493bc6a0b9a58faec608c870c" name="mysql4-upgrade-0.0.1.0-0.0.1.1.php" /><file hash="cd2920e566d6733b9688720416ed5211" name="mysql4-upgrade-0.0.1.1-0.0.2.0.php" /><file hash="33db9c1fa136d893692a73e1b670caff" name="mysql4-upgrade-0.0.2.0-0.0.3.0.php" /><file hash="8b8d0544161894ab0c9ae56a5d2cca8c" name="mysql4-upgrade-0.0.3.0-0.0.4.0.php" /><file hash="afc7e28dd865ab008376ab58453a3221" name="mysql4-upgrade-0.0.4.0-0.0.5.0.php" /><file hash="33f55ec12f8b0481320491bfb71da3b1" name="mysql4-upgrade-0.0.5.0-0.0.6.0.php" /><file hash="3b88e0c1e51137ebf1e3af199a4d59ab" name="mysql4-upgrade-2.0.0.6-2.0.0.7.php" /></dir></dir></dir></dir></target><target name="magelocale"><dir name="fr_FR"><file hash="fb0e33fdd1a7018e9cd00cb7ec2f8e73" name="Dolist_Net.csv" /></dir></target><target name="magelocal"><dir name="modules"><file hash="73c963262d3cb6831bf1240a165b215e" name="Dolist_Net.xml" /></dir></target></contents><dependencies><required><php><min>5.3.2</min><max>7.1.0</max></php></required></dependencies><authors><author><name>Dolist</name><user>Dolist</user><email>magento@dolist.net</email></author></authors><date>2016-09-27</date><compatibile /><channel>community</channel><description>&amp;lt;p&amp;gt;Take simultaneous advantage from both Magento's Community Edition or Enterprise
3
  Edition and Dolist's e-mail marketing platforms power. Dolist-V8 for e-mail marketing campaigns and
4
  Dolist-EMT for
5
  transactional messages in order to optimize both your prospects and customers relationship.&amp;lt;/p&amp;gt;&amp;#xD;
1
  <?xml version='1.0' encoding='utf-8'?>
2
+ <package><name>Dolist_Net</name><license uri="http://opensource.org/licenses/osl-3.0.php">OSL 3.0</license><notes>v2</notes><time>10:15:53</time><__packager>build_package.py v0.0.3</__packager><summary>Official extension for Dolist email marketing solution.</summary><stability>stable</stability><__commit_hash>d3894be6a5b51ad60ca231923d2195fe11dfa358</__commit_hash><version>2.0.2.1</version><extends /><contents><target name="mage"><dir name="shell"><file hash="9b10f919097a3abe18833961359449c4" name="dolist_export_segments.php" /></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file hash="9116ca5966c127c3a065d3ccf991f6dd" name="dolist.xml" /></dir><dir name="template"><dir name="dolist"><file hash="05db7ca8032551aea167c573c06d0287" name="configuration.phtml" /><file hash="468f46da25ee4c840098e0754299a9a1" name="customerexport.phtml" /><dir name="store"><file hash="4100093e08cf4ce57c317ee017cba630" name="switcher.phtml" /></dir><dir name="system"><dir name="config"><dir name="dolistemt"><file hash="ba10b87cd51fef3d88a0dcf747d8b8dc" name="testconnection.phtml" /></dir><dir name="dolistv8"><file hash="a9b57b458cb1dfb83f0f5061be82f9f9" name="array.phtml" /><file hash="5c89a07ee29d11640870592c2edfc114" name="testconnection.phtml" /></dir></dir></dir></dir></dir></dir></dir></dir></target><target name="magecommunity"><dir name="Dolist"><dir name="Net"><dir name="Block"><dir name="Adminhtml"><file hash="b5c65ae9b68d820870fb38e78e100265" name="Customerexport.php" /><file hash="fd8f4ad560d6777587a9ed90223c18c4" name="Edit.php" /><file hash="2e37abf70940f00b110279cef8b82280" name="Report.php" /><dir name="Customer"><file hash="8f6d9965be320c972d998f34171c4a5a" name="Edit.php" /></dir><dir name="Customersegment"><file hash="cf6a52e571dd475b96e93c00a8e2b5f0" name="Edit.php" /></dir><dir name="Edit"><file hash="057c9ee5853ea17801c990b42385fa5f" name="Form.php" /><file hash="45aba333e3e017601eff3a730e2991df" name="Tabs.php" /><dir name="Tab"><file hash="d93a56df1f7d60a8f4d275886f150ddf" name="Configuration.php" /><file hash="d1299519d583afd8b8afdad5ddafc326" name="Export.php" /><file hash="a55d01b5e4d114b20adef94f5dc503db" name="Report.php" /></dir></dir><dir name="System"><dir name="Config"><file hash="8393df0943d5575c31cb596c8d368ce6" name="Abstract.php" /><file hash="77b6b112b2492beb3dae124efe0b924a" name="Date.php" /><file hash="59fa9be3d71a648ab9d4dfe697d2e183" name="Enable.php" /><file hash="c62a40696ae0028b2908ed34768d8c2a" name="Switcher.php" /><file hash="883194919f569b7f49a12fd9d4f83082" name="Templatelist.php" /><dir name="Dolistemt"><file hash="9193591b22b093d9e5baaf83b0818ec8" name="Templatelist.php" /><file hash="4025ca1026614c48996c57112b25cf1c" name="Templatemapping.php" /><file hash="b95697d6fea9d16003f01b5a1f63db6a" name="Testconnection.php" /></dir><dir name="Dolistv8"><file hash="5be525c4398c036956d6489aa8fa582d" name="Attributelist.php" /><file hash="88336cf98961a1df4e23bf2de819c17d" name="Customdatefields.php" /><file hash="485252191fb609780609f7ec6b9d0fad" name="Customerattributelist.php" /><file hash="96a8428b3503291204d8922500e39210" name="Customintfields.php" /><file hash="2011749c69cae4968ded68dc4cce6945" name="Customstrfields.php" /><file hash="cb016b986834178808cad7dd9c8d96c2" name="Testconnection.php" /></dir></dir></dir></dir></dir><dir name="controllers"><dir name="Adminhtml"><file hash="651fed35ece40312ac21e2fb8efd1dea" name="CustomerdolistController.php" /><dir name="System"><dir name="Config"><file hash="9c42cecb347d4ffb4db54ee901345359" name="TestconnectionController.php" /></dir></dir></dir></dir><dir name="etc"><file hash="1f9d77e2b9f8e4b86f54f272eb213218" name="adminhtml.xml" /><file hash="885f76b6ea4c64a412c6c489a45f253d" name="config.xml" /><file hash="f0d6b4651431d1d11532fe9402fc5003" name="system.xml" /></dir><dir name="Helper"><file hash="2b2ced3addfa1ecb36441383d8c2a45f" name="Data.php" /><file hash="1d28b2acc7b47c17bb17af60e60c891d" name="Log.php" /><file hash="46b027b6f19b5a4ba72e1e992ac95269" name="Queue.php" /></dir><dir name="Model"><file hash="61da7cc29853bb9ce85b0bb587545c99" name="Customersegment.php" /><file hash="84647426508242e63f12912bd49ce3be" name="Observer.php" /><file hash="5a820cdad6554553ba9ecc189862397e" name="Reports.php" /><file hash="b8aab39cc2d21f91e16b6697f2b68a4e" name="Service.php" /><dir name="Adminhtml"><file hash="8ff835df0881b386870fe52a116e10bb" name="Observer.php" /><dir name="System"><dir name="Config"><dir name="Backend"><dir name="Serialized"><file hash="ce8002b5ba1bd19901b5de4db7200672" name="Array.php" /></dir></dir><dir name="Source"><file hash="d594a5df0ec9c76ca0f55ac0c4422f56" name="Timeperiods.php" /></dir></dir></dir></dir><dir name="Dolistemt"><file hash="67917ea713604769bdc5e348d04830b4" name="Template.php" /><dir name="Email"><file hash="7e39b7cdc9a6f62c784937317d344d0b" name="Template.php" /></dir><dir name="Message"><file hash="3dd939ec132047606cc1f322677bcc1c" name="Queued.php" /></dir></dir><dir name="Dolistv8"><file hash="3bfb38a9d3e61fe67f96af06e31a7069" name="Calculatedfields.php" /><file hash="b1d4006ddf6c62b46bcadeb6a6b56fc0" name="Customfields.php" /><file hash="6a91b08ff749b635ffaff68a267cee53" name="Ftp.php" /></dir><dir name="Exporter"><file hash="83168b8fa77083c3157af0ef50d78cf0" name="Csv.php" /><dir name="Adapter"><file hash="c52f8d05c198b2ee691d25104aa191ca" name="Date.php" /><file hash="66b2ee18bdf3924011a068f936b8818a" name="Default.php" /><file hash="797f1a935a1f8e1a9ce213d6cf03c235" name="Int.php" /></dir></dir><dir name="Mysql4"><file hash="7a3a3de6ef2fd144c192ef60357e370f" name="Reports.php" /><dir name="Dolistemt"><file hash="f972ef82ba3003da8d849e60df044440" name="Template.php" /><dir name="Message"><file hash="466461ebec5e905d89659698a21ed0ed" name="Queued.php" /><dir name="Queued"><file hash="1b0ed0a91ecd7fb5941c694221d12578" name="Collection.php" /></dir></dir><dir name="Template"><file hash="7b845449076c1dfaee11a7b04cb50400" name="Collection.php" /></dir></dir><dir name="Dolistv8"><file hash="5776d48a50145975b4611593f764c274" name="Calculatedfields.php" /><file hash="0c66d48562faaa3641a190becc66f618" name="Customfields.php" /><dir name="Calculatedfields"><file hash="106dc6dd921c134378002992e4d94e08" name="Collection.php" /></dir><dir name="Customfields"><file hash="93a52bb46b05487e79471448b46ca51e" name="Collection.php" /></dir><dir name="Export"><dir name="Adapter"><file hash="08a870e9120893dfe74349313bbb0c75" name="Abstract.php" /><file hash="83d064b83909ac3a4421d474397b5029" name="Address1.php" /><file hash="b9dc124ff88ecbaa750e580f97b246f2" name="Address2.php" /><file hash="b87316bf23926e93485b6868323f88a4" name="Address3.php" /><file hash="75e243f2a3526955ea7d94cad4798ec2" name="City.php" /><file hash="b2372fe91c4a61bd81549fbee4722e85" name="Company.php" /><file hash="176e3a58ab1371ffd87a8dd41ff6231b" name="Country.php" /><file hash="a47e3ada99704b2cfebd7ed151d39762" name="Default.php" /><file hash="a96d9b7d0d6e810533df36901e0dc7ac" name="Fax.php" /><file hash="f044aed5b697abb4b5b7722307413fef" name="Phone.php" /><file hash="1a84be76756c8b6e550a683301bf455f" name="Postcode.php" /><dir name="Date"><file hash="c46a5408f7f314ff3a81c71af1fa15e2" name="Default.php" /><file hash="47bddb55318ce847d2f6b15d640f7a60" name="Firstorder.php" /><file hash="062f333db7de511fb2ce872d46aaf42b" name="Lastorder.php" /><file hash="b22578ad3ec3a7abc87fa0ce461f1a4d" name="Lastquotenotordered.php" /></dir><dir name="Int"><file hash="5d796e6bea90f12d0269909e7cf3d139" name="Avgnbdifferentproductsperorder.php" /><file hash="49b1404377684e76769785c6b687d7c7" name="Avgnbdifferentproductsperorderline.php" /><file hash="7e61a698ff50831d2cb3af22c70e7417" name="Avgnbproductsperorder.php" /><file hash="fd37fd3eb15a6336297d2c7413bba92b" name="Avgorderamountexcltax.php" /><file hash="5cc93dee1c5d0edd08c5a89965c9a309" name="Avgorderamountincltax.php" /><file hash="8d21cfa8cd4c928a2047b3f381617722" name="Firstorderamountexcltax.php" /><file hash="9f01b2f043d5aeee79d061b6f5b87ebe" name="Firstorderamountincltax.php" /><file hash="965ff875b99114c6e05e1984380f058c" name="Lastnotorderedcartamountexcltax.php" /><file hash="3881c4c05470a40d42e17d2e7baddadc" name="Lastnotorderedcartamountincltax.php" /><file hash="2a9dd928c19c08ebb72ae15a28291350" name="Lastorderamountexcltax.php" /><file hash="6597ce7e67a5b81987d83630cdce0b4a" name="Lastorderamountincltax.php" /><file hash="ca834fc08021a32baf5b6c600851f9d5" name="Nbpromotionrulesused.php" /><file hash="20424e6e5d771aa1226efa1f790ba47a" name="Totalorderamountexcltax.php" /><file hash="47a12daeacf165e05f6fc995ac8afdd0" name="Totalorderamountincltax.php" /><file hash="e09646a71a83c71a04103c44ee0afc12" name="Totalorderedproducts.php" /><file hash="10a3b1d4a6fba1ff056aab081908c940" name="Totalorders.php" /></dir></dir></dir></dir><dir name="Reports"><file hash="3ec7cc4fd35c539db1411cbe0bf98a25" name="Collection.php" /></dir></dir><dir name="Service"><dir name="Dolistemt"><dir name="Request"><file hash="bfe76bef2f1301562f9003cacd82b5b1" name="Getauthenticationtoken.php" /><file hash="f08c835bbcb6ca69daf2bdeaaea28a4c" name="Gettemplatelist.php" /><file hash="06062e2ccf54c189874000d50d909de6" name="SendEmail.php" /></dir><dir name="Response"><file hash="387210c798ed818d410ac7a62a8f7a08" name="Getauthenticationtoken.php" /><file hash="ab3db8a6a1bc1e38dc163c28f64f9612" name="Gettemplatelist.php" /><file hash="45d3740fe05ecd90bf722b19725ad7d8" name="SendEmail.php" /></dir></dir><dir name="Dolistv8"><dir name="Request"><file hash="55a56a710b88398c99f1aaeb01816976" name="Createimport.php" /><file hash="af14961d044f007696452307b9f7a89e" name="Getauthenticationtoken.php" /><file hash="d085194dc5f599884969de6f5cc32f9d" name="Getcontact.php" /><file hash="d710c9e4d512a929e4aa2a0c32d1becc" name="Getfieldlist.php" /></dir><dir name="Response"><file hash="93e32967b4c1ba7ae0981023e49f9471" name="Createimport.php" /><file hash="5f14b532c12728495b6163092bce1003" name="Getauthenticationtoken.php" /><file hash="59c766c7fefe70fb1e18571f8904942a" name="Getcontact.php" /><file hash="1ab5aef6b09f671a382d5eef5a182bce" name="Getfieldlist.php" /></dir></dir><dir name="Message"><file hash="e10bee52c6cebf4ccd4c93a41afe5ae0" name="Abstract.php" /></dir></dir><dir name="System"><dir name="Config"><file hash="b64b291b560a8522094c203333cadae6" name="Check.php" /><dir name="Source"><file hash="3d7e993ac25b0ade883df78a9ef97b19" name="Group.php" /><dir name="Dolistemt"><file hash="de59edbfbae9db377ff561a49fcb8ff5" name="Defaulttemplate.php" /><file hash="6fe1abcf43f76468eaea0e3616584243" name="Errors.php" /><file hash="8debc19194b97203394b012b0258ac91" name="Template.php" /></dir><dir name="Dolistv8"><file hash="7bcd4cf17c51414df7c4633b6c89ddf2" name="Customerattributelist.php" /><file hash="10485fb8f6477d5a55c2b8ddcd4c9d02" name="Customfield.php" /></dir><dir name="Email"><file hash="e5af986543b65db2684e4a62a3967a89" name="Template.php" /></dir></dir></dir></dir></dir><dir name="sql"><dir name="dolist_setup"><file hash="4e0d4b4567915185b09538ddbe683344" name="mysql4-install-0.0.1.0.php" /><file hash="b75badbb3ac168379f77ba479f4db417" name="mysql4-upgrade-0.0.1.0-0.0.1.1.php" /><file hash="48c4b1e3272d84c2d5ce9d3b4025a34e" name="mysql4-upgrade-0.0.1.1-0.0.2.0.php" /><file hash="a7864e7f7dff85ad6887135420df79ea" name="mysql4-upgrade-0.0.2.0-0.0.3.0.php" /><file hash="34642cd15cf27c5db8236796f8c7e45a" name="mysql4-upgrade-0.0.3.0-0.0.4.0.php" /><file hash="57fb0c1739a04b3ae545cf9c74fadc79" name="mysql4-upgrade-0.0.4.0-0.0.5.0.php" /><file hash="9ac17d51115c6dc708028227dd810e54" name="mysql4-upgrade-0.0.5.0-0.0.6.0.php" /><file hash="727f63ec521b7a958d15d6bbdb5e7680" name="mysql4-upgrade-2.0.0.6-2.0.0.7.php" /></dir></dir></dir></dir></target><target name="magelocale"><dir name="fr_FR"><file hash="fb0e33fdd1a7018e9cd00cb7ec2f8e73" name="Dolist_Net.csv" /></dir></target><target name="magelocal"><dir name="modules"><file hash="73c963262d3cb6831bf1240a165b215e" name="Dolist_Net.xml" /></dir></target></contents><dependencies><required><php><min>5.3.2</min><max>7.1.0</max></php></required></dependencies><authors><author><name>Dolist</name><user>Dolist</user><email>magento@dolist.net</email></author></authors><date>2016-11-22</date><compatibile /><channel>community</channel><description>&amp;lt;p&amp;gt;Take simultaneous advantage from both Magento's Community Edition or Enterprise
3
  Edition and Dolist's e-mail marketing platforms power. Dolist-V8 for e-mail marketing campaigns and
4
  Dolist-EMT for
5
  transactional messages in order to optimize both your prospects and customers relationship.&amp;lt;/p&amp;gt;&amp;#xD;