AnattaDesign_AbandonedCarts - Version 1.1.2

Version Notes

v1.1.2

Fixes a bug with installs using prefixed database tables

Download this release

Release Info

Developer Anatta Design
Extension AnattaDesign_AbandonedCarts
Version 1.1.2
Comparing to
See all releases


Code changes from version 1.1.1 to 1.1.2

Files changed (5) hide show
  1. app/code/local/AnattaDesign/AbandonedCarts/Helper/Data.php +4 -2
  2. app/code/local/AnattaDesign/AbandonedCarts/Model/Observer.php +4 -2
  3. app/code/local/AnattaDesign/AbandonedCarts/etc/config.xml +1 -1
  4. app/code/local/AnattaDesign/AbandonedCarts/sql/anattadesign_abandonedcarts_setup/mysql4-upgrade-1.1.1-1.1.2.php +3 -0
  5. package.xml +6 -6
app/code/local/AnattaDesign/AbandonedCarts/Helper/Data.php CHANGED
@@ -78,7 +78,8 @@ class AnattaDesign_AbandonedCarts_Helper_Data extends Mage_Core_Helper_Abstract
78
 
79
  // Get current version of the extension
80
  $connection = Mage::getSingleton( 'core/resource' )->getConnection( 'core_read' );
81
- $stmt = $connection->query( "SELECT version FROM core_resource WHERE code='anattadesign_abandonedcarts_setup';" );
 
82
  $data = $stmt->fetch();
83
  $version = $data['version'];
84
 
@@ -113,7 +114,8 @@ class AnattaDesign_AbandonedCarts_Helper_Data extends Mage_Core_Helper_Abstract
113
  // $ping_rescheduled = Mage::getStoreConfig( 'anattadesign_abandonedcarts_ping_rescheduled' );
114
  // Fetch directly from database to bypass Magento config cache.
115
  // Its better to bypass cache and make a sql query in favor of performance, sql query is not gonna run up on frontend side, except when all the cache is refreshed & extension is upgraded
116
- $stmt = $connection->query( "SELECT value FROM core_config_data WHERE path='anattadesign_abandonedcarts_ping_rescheduled' AND scope = 'default' AND scope_id = 0 LIMIT 1;" );
 
117
  $data = $stmt->fetch();
118
  if ( $data === false )
119
  $ping_rescheduled = 1;
78
 
79
  // Get current version of the extension
80
  $connection = Mage::getSingleton( 'core/resource' )->getConnection( 'core_read' );
81
+ $table = Mage::getSingleton('core/resource')->getTableName( 'core_resource' );
82
+ $stmt = $connection->query( "SELECT version FROM $table WHERE code='anattadesign_abandonedcarts_setup';" );
83
  $data = $stmt->fetch();
84
  $version = $data['version'];
85
 
114
  // $ping_rescheduled = Mage::getStoreConfig( 'anattadesign_abandonedcarts_ping_rescheduled' );
115
  // Fetch directly from database to bypass Magento config cache.
116
  // Its better to bypass cache and make a sql query in favor of performance, sql query is not gonna run up on frontend side, except when all the cache is refreshed & extension is upgraded
117
+ $table = Mage::getSingleton('core/resource')->getTableName( 'core_config_data' );
118
+ $stmt = $connection->query( "SELECT value FROM $table WHERE path='anattadesign_abandonedcarts_ping_rescheduled' AND scope = 'default' AND scope_id = 0 LIMIT 1;" );
119
  $data = $stmt->fetch();
120
  if ( $data === false )
121
  $ping_rescheduled = 1;
app/code/local/AnattaDesign/AbandonedCarts/Model/Observer.php CHANGED
@@ -12,7 +12,8 @@ class AnattaDesign_AbandonedCarts_Model_Observer {
12
  // Instead of using getStoreConfig make a direct sql query to bypass magento cache
13
  // $is_ping_rescheduled = Mage::getStoreConfig( 'anattadesign_abandonedcarts_ping_rescheduled' );
14
  $connection = Mage::getSingleton( 'core/resource' )->getConnection( 'core_read' );
15
- $stmt = $connection->query( "SELECT value FROM core_config_data WHERE path='anattadesign_abandonedcarts_ping_rescheduled' AND scope = 'default' AND scope_id = 0 LIMIT 1;" );
 
16
  $data = $stmt->fetch();
17
  // If $data is false, then that means there is no row in the table, and no ping has been rescheduled
18
  if ( $data !== false )
@@ -29,7 +30,8 @@ class AnattaDesign_AbandonedCarts_Model_Observer {
29
  return;
30
 
31
  $connection = Mage::getSingleton( 'core/resource' )->getConnection( 'core_read' );
32
- $stmt = $connection->query( "SELECT version FROM core_resource WHERE code='anattadesign_abandonedcarts_setup'" );
 
33
  $data = $stmt->fetch();
34
  $version = $data['version'];
35
 
12
  // Instead of using getStoreConfig make a direct sql query to bypass magento cache
13
  // $is_ping_rescheduled = Mage::getStoreConfig( 'anattadesign_abandonedcarts_ping_rescheduled' );
14
  $connection = Mage::getSingleton( 'core/resource' )->getConnection( 'core_read' );
15
+ $table = Mage::getSingleton('core/resource')->getTableName( 'core_config_data' );
16
+ $stmt = $connection->query( "SELECT value FROM $table WHERE path='anattadesign_abandonedcarts_ping_rescheduled' AND scope = 'default' AND scope_id = 0 LIMIT 1;" );
17
  $data = $stmt->fetch();
18
  // If $data is false, then that means there is no row in the table, and no ping has been rescheduled
19
  if ( $data !== false )
30
  return;
31
 
32
  $connection = Mage::getSingleton( 'core/resource' )->getConnection( 'core_read' );
33
+ $table = Mage::getSingleton('core/resource')->getTableName( 'core_resource' );
34
+ $stmt = $connection->query( "SELECT version FROM $table WHERE code='anattadesign_abandonedcarts_setup'" );
35
  $data = $stmt->fetch();
36
  $version = $data['version'];
37
 
app/code/local/AnattaDesign/AbandonedCarts/etc/config.xml CHANGED
@@ -2,7 +2,7 @@
2
  <config>
3
  <modules>
4
  <AnattaDesign_AbandonedCarts>
5
- <version>1.1.1</version>
6
  </AnattaDesign_AbandonedCarts>
7
  </modules>
8
  <global>
2
  <config>
3
  <modules>
4
  <AnattaDesign_AbandonedCarts>
5
+ <version>1.1.2</version>
6
  </AnattaDesign_AbandonedCarts>
7
  </modules>
8
  <global>
app/code/local/AnattaDesign/AbandonedCarts/sql/anattadesign_abandonedcarts_setup/mysql4-upgrade-1.1.1-1.1.2.php ADDED
@@ -0,0 +1,3 @@
 
 
 
1
+ <?php
2
+
3
+ Mage::helper( 'anattadesign_abandonedcarts' )->ping();
package.xml CHANGED
@@ -1,20 +1,20 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>AnattaDesign_AbandonedCarts</name>
4
- <version>1.1.1</version>
5
  <stability>stable</stability>
6
  <license>GPL</license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>Track abandoned carts &amp; show a funnel report to show statistics</summary>
10
  <description>Track abandoned carts &amp; show a funnel report to show statistics</description>
11
- <notes>v1.1.1&#xD;
12
  &#xD;
13
- Fixes a bug with widget rendering for installs using prefixed database tables</notes>
14
  <authors><author><name>Anatta Design</name><user>anattadesign</user><email>nirav@anattadesign.com</email></author></authors>
15
- <date>2013-04-18</date>
16
- <time>22:00:45</time>
17
- <contents><target name="magelocal"><dir name="AnattaDesign"><dir name="AbandonedCarts"><dir><dir name="Block"><file name="Widget.php" hash="c6baf4dc8dc25ed7c62e3b89cc78c413"/></dir><dir name="Helper"><file name="Data.php" hash="f7006d4e1b800435e8a2e78df3f3786c"/></dir><dir name="Model"><dir name="Checkout"><dir name="Onepage"><file name="Observer.php" hash="6745ab11e82cf6370e04d251d1010637"/></dir></dir><dir name="Mysql4"><dir name="Opstatistics"><file name="Collection.php" hash="66b29da439c196f325c9faec4b171f30"/></dir><file name="Opstatistics.php" hash="9ccaa740ddbfa607204bde0222fceafc"/><dir name="Statistics"><file name="Collection.php" hash="c92997470a39016001c196fa4bf17861"/></dir><file name="Statistics.php" hash="88d17295de3fc05637ac55e71c52a3a3"/></dir><file name="Observer.php" hash="65c9278ea5b84f14ff30b82a9d5780ca"/><file name="Opstatistics.php" hash="f3bfe7b7e44ef33e15877332a767b25a"/><file name="Statistics.php" hash="85f8bf8090484826dc0e43bb39324557"/></dir><dir name="controllers"><file name="WidgetController.php" hash="ca23d690e09435f5f4df54c539dea74b"/></dir><dir name="etc"><file name="config.xml" hash="49df21a3b821ef97b5bd48bbf971122d"/></dir><dir name="sql"><dir name="anattadesign_abandonedcarts_setup"><file name="mysql4-install-1.0.0.php" hash="b235486189e6609d4f9abc82ffae76c7"/><file name="mysql4-upgrade-1.0.0-1.0.1.php" hash="f9f7cbb6845f014f74c294692189c369"/><file name="mysql4-upgrade-1.0.1-1.1.0.php" hash="f9f7cbb6845f014f74c294692189c369"/><file name="mysql4-upgrade-1.1.0-1.1.1.php" hash="f9f7cbb6845f014f74c294692189c369"/></dir></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="anattadesign_abandonedcarts.xml" hash="c14481626a0c367d974a5660ed930482"/></dir><dir name="template"><dir name="anattadesign"><dir name="abandonedcarts"><file name="widget.phtml" hash="412dc7da934de493bf65b4000e55eb53"/></dir></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="AnattaDesign_AbandonedCarts.xml" hash="fba54c1c1c7b2abd323a56bcdd56be20"/></dir></target><target name="mage"><dir name="js"><dir name="anattadesign"><dir name="abandonedcarts"><file name="adminhack.js" hash="d8d1b081040d1dbbe87296e4ed064a91"/><file name="zepto.js" hash="61e66962daedd0943adc35a97b0eaa27"/></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="anattadesign"><dir name="abandonedcarts"><dir><dir name="css"><file name="style.css" hash="91b410a9fc1a5ff1e20e7c321fd64e23"/></dir><dir name="images"><file name="bt-rep.gif" hash="f2054c34f7d04f81082ef2d686464c5f"/><file name="powerdby.jpg" hash="82777ae659f9316a27dbf7e14e23a5e2"/><file name="table-step-img-arrow.jpg" hash="ea678306e6a71818565e09c771bec7a5"/><file name="table-step-img-last-arrow.jpg" hash="88b14ae05fd2105ba317025925a39880"/><file name="table-step-img.jpg" hash="4bcb56e9e828981d0c1654925848791e"/></dir></dir></dir></dir></dir></dir></dir></target></contents>
18
  <compatible/>
19
  <dependencies><required><php><min>5.2.0</min><max>6.0.0</max></php></required></dependencies>
20
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>AnattaDesign_AbandonedCarts</name>
4
+ <version>1.1.2</version>
5
  <stability>stable</stability>
6
  <license>GPL</license>
7
  <channel>community</channel>
8
  <extends/>
9
  <summary>Track abandoned carts &amp; show a funnel report to show statistics</summary>
10
  <description>Track abandoned carts &amp; show a funnel report to show statistics</description>
11
+ <notes>v1.1.2&#xD;
12
  &#xD;
13
+ Fixes a bug with installs using prefixed database tables</notes>
14
  <authors><author><name>Anatta Design</name><user>anattadesign</user><email>nirav@anattadesign.com</email></author></authors>
15
+ <date>2013-05-09</date>
16
+ <time>23:58:34</time>
17
+ <contents><target name="magelocal"><dir name="AnattaDesign"><dir name="AbandonedCarts"><dir><dir name="Block"><file name="Widget.php" hash="c6baf4dc8dc25ed7c62e3b89cc78c413"/></dir><dir name="Helper"><file name="Data.php" hash="735ff6cf1bb8f18bb52c127111aac585"/></dir><dir name="Model"><dir name="Checkout"><dir name="Onepage"><file name="Observer.php" hash="6745ab11e82cf6370e04d251d1010637"/></dir></dir><dir name="Mysql4"><dir name="Opstatistics"><file name="Collection.php" hash="66b29da439c196f325c9faec4b171f30"/></dir><file name="Opstatistics.php" hash="9ccaa740ddbfa607204bde0222fceafc"/><dir name="Statistics"><file name="Collection.php" hash="c92997470a39016001c196fa4bf17861"/></dir><file name="Statistics.php" hash="88d17295de3fc05637ac55e71c52a3a3"/></dir><file name="Observer.php" hash="4039511b270dd2e87d5f91a2a04a7c84"/><file name="Opstatistics.php" hash="f3bfe7b7e44ef33e15877332a767b25a"/><file name="Statistics.php" hash="85f8bf8090484826dc0e43bb39324557"/></dir><dir name="controllers"><file name="WidgetController.php" hash="ca23d690e09435f5f4df54c539dea74b"/></dir><dir name="etc"><file name="config.xml" hash="f3d993b3bea28e645d5791a413d529db"/></dir><dir name="sql"><dir name="anattadesign_abandonedcarts_setup"><file name="mysql4-install-1.0.0.php" hash="b235486189e6609d4f9abc82ffae76c7"/><file name="mysql4-upgrade-1.0.0-1.0.1.php" hash="f9f7cbb6845f014f74c294692189c369"/><file name="mysql4-upgrade-1.0.1-1.1.0.php" hash="f9f7cbb6845f014f74c294692189c369"/><file name="mysql4-upgrade-1.1.0-1.1.1.php" hash="f9f7cbb6845f014f74c294692189c369"/><file name="mysql4-upgrade-1.1.1-1.1.2.php" hash="f9f7cbb6845f014f74c294692189c369"/></dir></dir></dir></dir></dir></target><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="anattadesign_abandonedcarts.xml" hash="c14481626a0c367d974a5660ed930482"/></dir><dir name="template"><dir name="anattadesign"><dir name="abandonedcarts"><file name="widget.phtml" hash="412dc7da934de493bf65b4000e55eb53"/></dir></dir></dir></dir></dir></dir></target><target name="mageetc"><dir name="modules"><file name="AnattaDesign_AbandonedCarts.xml" hash="fba54c1c1c7b2abd323a56bcdd56be20"/></dir></target><target name="mage"><dir name="js"><dir name="anattadesign"><dir name="abandonedcarts"><file name="adminhack.js" hash="d8d1b081040d1dbbe87296e4ed064a91"/><file name="zepto.js" hash="61e66962daedd0943adc35a97b0eaa27"/></dir></dir></dir></target><target name="mageskin"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="anattadesign"><dir name="abandonedcarts"><dir><dir name="css"><file name="style.css" hash="91b410a9fc1a5ff1e20e7c321fd64e23"/></dir><dir name="images"><file name="bt-rep.gif" hash="f2054c34f7d04f81082ef2d686464c5f"/><file name="powerdby.jpg" hash="82777ae659f9316a27dbf7e14e23a5e2"/><file name="table-step-img-arrow.jpg" hash="ea678306e6a71818565e09c771bec7a5"/><file name="table-step-img-last-arrow.jpg" hash="88b14ae05fd2105ba317025925a39880"/><file name="table-step-img.jpg" hash="4bcb56e9e828981d0c1654925848791e"/></dir></dir></dir></dir></dir></dir></dir></target></contents>
18
  <compatible/>
19
  <dependencies><required><php><min>5.2.0</min><max>6.0.0</max></php></required></dependencies>
20
  </package>